UPDATE #Request.prefix_db_agency#.pWoundsVitals
SET
Description = ,
Location = ,
other_locations = ,
Length = ,
Width = ,
Depth = ,
Param_Hi = ,
Reading1 = ,
Date_Change = ,
Change_by = ,
healingstage = ,
woundtype = ,
wnd_bed = ,
wnd_margin = ,
wnd_exudate = ,
wnd_odor = ,
wnd_pain = ,
wnd_tunneling = ,
wnd_underm = ,
wnd_gran = ,
wnd_epith = ,
wnd_eschar = ,
wnd_slough = ,
wnd_fib =
WHERE
ID =
SELECT * FROM #Request.prefix_db_agency#.pWoundsVitals
WHERE VitalOrWound = 'wound'
AND Assmt_ID =
AND status = 0 ORDER BY Pathway_ID DESC
SELECT * FROM getpwound
WHERE WoundType = '#arguments.woundtype#'
INSERT INTO #Request.prefix_db_agency#.pWoundsVitals (Assmt_ID, Status, Pathway_ID, Item_ID,
VitalOrWound, Description, Location, other_locations, Length, Width, Depth, Param_Hi, Reading1, Date_Create,Created_by,
Date_Change,Change_by,healingstage, frompgnote, woundtype, wnd_bed, wnd_margin, wnd_exudate, wnd_odor, wnd_pain, wnd_tunneling, wnd_underm, wnd_gran, wnd_epith, wnd_eschar, wnd_slough, wnd_fib)
VALUES
(,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
)
UPDATE #Request.prefix_db_agency#.pWoundsVitals SET
Status = ,
Date_Change = ,
Change_by =
WHERE ID =
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Assmt_ID =
AND status =
UPDATE #Request.prefix_db_agency#.pProblem SET
Status = ,
Date_Change = ,
Change_by =
WHERE ques_id =
AND Assmt_ID =
AND Skill =
SELECT * FROM #Request.prefix_db_agency#.pWoundsVitals WHERE ID =
UPDATE #Request.prefix_db_agency#.pWoundsVitals
SET
Description = ,
Notes = ,
Reading1 = ,
pain_location = ,
pain_duration = ,
pain_exacerbate = ,
pain_relief = ,
pain_med_effectiveness = ,
Date_Change = ,
Change_by =
WHERE
ID =
UPDATE #Request.prefix_db_agency#.pProgress
SET
Value_1 = ,
Value_2 = ,
Value_Sum = ,
Notes = ,
pain_location = ,
pain_duration = ,
pain_exacerbate = ,
pain_relief = ,
pain_med_effectiveness = ,
Date_Change = ,
Change_by =
WHERE Assmt_ID =
AND Schedule_ID =
AND Careplan_ID =
AND Type =
AND Status =
SELECT * FROM #Request.prefix_db_agency#.pWoundsVitals
WHERE Description =
AND Assmt_ID =
AND Status =
SELECT * FROM #Request.prefix_db_lookup#.pValue_Lookup
WHERE Description = '#Description#'
SELECT * FROM #Request.prefix_db_agency#.pVital_Param
WHERE Item_ID = '#Item_ID#'
INSERT INTO #Request.prefix_db_agency#.pWoundsVitals (Assmt_ID, Status, Pathway_ID, Item_ID,
VitalOrWound, Description, Param_Lo, Param_Hi, Notes, Reading1, pain_location, pain_duration,
pain_exacerbate, pain_relief, pain_med_effectiveness, Date_Create,Created_by,
Date_Change,Change_by)
VALUES
(,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
)
SELECT * FROM #Request.prefix_db_agency#.pProgress
WHERE Assmt_ID =
AND Schedule_ID =
AND Status =
AND Item_ID =
AND Type =
SELECT * FROM #Request.prefix_db_agency#.pWoundsVitals
WHERE Item_ID =
AND Assmt_ID =
AND Status =
INSERT INTO #Request.prefix_db_agency#.pProgress (Assmt_ID, Careplan_ID, Item_ID, Schedule_ID, Description, Status,
Type, Value_1, Value_2, Notes, Value_Sum, pain_location, pain_duration, pain_exacerbate,
pain_relief, pain_med_effectiveness, Date_Create, Created_by, Date_Change, Change_by)
VALUES
(,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
)
SELECT * FROM #Request.prefix_db_lookup#.pValue_Lookup WHERE Description =
SELECT * FROM #Request.prefix_db_agency#.pWoundsVitals
WHERE Assmt_ID =
AND Status =
AND VitalOrWound =
SELECT * FROM #Request.prefix_db_agency#.pProgress
WHERE Assmt_ID =
AND Schedule_ID =
AND Status =
AND Type =
SELECT * FROM #Request.prefix_db_lookup#.pValue_Lookup
WHERE Description NOT IN ( )
AND Description <> 'wound'
GROUP BY Item_ID
var LOCAL = StructNew();
if (ARGUMENTS.Row){
LOCAL.FromIndex = ARGUMENTS.Row;
LOCAL.ToIndex = ARGUMENTS.Row;
} else {
LOCAL.FromIndex = 1;
LOCAL.ToIndex = ARGUMENTS.Query.RecordCount;
}
LOCAL.Columns = ListToArray( ARGUMENTS.Query.ColumnList );
LOCAL.ColumnCount = ArrayLen( LOCAL.Columns );
LOCAL.DataArray = ArrayNew( 1 );
for (LOCAL.RowIndex = LOCAL.FromIndex ; LOCAL.RowIndex LTE LOCAL.ToIndex ; LOCAL.RowIndex = (LOCAL.RowIndex + 1)){
ArrayAppend( LOCAL.DataArray, StructNew() );
LOCAL.DataArrayIndex = ArrayLen( LOCAL.DataArray );
for (LOCAL.ColumnIndex = 1 ; LOCAL.ColumnIndex LTE LOCAL.ColumnCount ; LOCAL.ColumnIndex = (LOCAL.ColumnIndex + 1)){
LOCAL.ColumnName = LOCAL.Columns[ LOCAL.ColumnIndex ];
LOCAL.DataArray[ LOCAL.DataArrayIndex ][ LOCAL.ColumnName ] = ARGUMENTS.Query[ LOCAL.ColumnName ][ LOCAL.RowIndex ];
}
}
if (ARGUMENTS.Row){
return( LOCAL.DataArray[ 1 ] );
} else {
return( LOCAL.DataArray );
}