Your session has Timed Out.
Please Sign In again to continue.
Session has timed out:
SELECT Assessment_Completed_M0090 FROM #Request.prefix_db_agency#.Assessment_New where Assessment_ID = '#session.cs.AssessmentId#'
update #Request.prefix_db_agency#.Pathway_Details Set Deleted='Yes' , Record_Mod_Date=Now(),Record_Modified_By='#session.EmployeeID#'
where Assessment_id='#session.cs.AssessmentId#'
SELECT Diagnosis.Short_Diagnosis, Diagnosis.Pathway_Type, Diagnosis.Severity
From #Request.prefix_db_agency#.Diagnosis
where Diagnosis.Assessment_ID='#Assessment_ID#'
and Diagnosis.M0230_Link != ''
and Diagnosis.DX_Order = 1
and Diagnosis.Pathway_Type is not null
SELECT Diagnosis.Short_Diagnosis, Diagnosis.Pathway_Type, Diagnosis.Severity
From #Request.prefix_db_agency#.Diagnosis
where Diagnosis.Assessment_ID='#Assessment_ID#'
and Diagnosis.M0230_Link != ''
and Diagnosis.DX_Order = 2
and Diagnosis.Pathway_Type is not null
>
SELECT Diagnosis.Short_Diagnosis, Diagnosis.Pathway_Type, Diagnosis.Severity
From #Request.prefix_db_agency#.Diagnosis
where Diagnosis.Assessment_ID='#Assessment_ID#'
and Diagnosis.M0230_Link != ''
and Diagnosis.DX_Order = 3
and Diagnosis.Pathway_Type is not null
>
SELECT Diagnosis.Short_Diagnosis, Diagnosis.Pathway_Type, Diagnosis.Severity
From #Request.prefix_db_agency#.Diagnosis
where Diagnosis.Assessment_ID='#Assessment_ID#'
and Diagnosis.M0230_Link != ''
and Diagnosis.DX_Order = 4
and Diagnosis.Pathway_Type is not null
>
SELECT Diagnosis.Short_Diagnosis, Diagnosis.Pathway_Type, Diagnosis.Severity
From #Request.prefix_db_agency#.Diagnosis
where Diagnosis.Assessment_ID='#Assessment_ID#'
and Diagnosis.M0230_Link != ''
and Diagnosis.DX_Order = 5
and Diagnosis.Pathway_Type is not null
>
SELECT Diagnosis.Short_Diagnosis, Diagnosis.Pathway_Type, Diagnosis.Severity
From #Request.prefix_db_agency#.Diagnosis
where Diagnosis.Assessment_ID='#Assessment_ID#'
and Diagnosis.M0230_Link != ''
and Diagnosis.DX_Order = 6
and Diagnosis.Pathway_Type is not null
>
SELECT Patient_ID,Agency_Id,Assessment_Tracker_ID FROM #Request.prefix_db_agency#.Assessment_New WHERE Assessment_ID='#Assessment_ID#'
SELECT Max(Item_Number)+1 as Item_Number1 FROM #Request.prefix_db_agency#.Pathway_Details
SELECT Certification_Start, Certification_End, Breathing_M0490, Resp_Treatments_M0500, Therapies_Home_M0250, High_Risk_Factors_M0290, Freq_of_Pain_M0420, M2250e_Pain,
Assessment_Reason_M0100, Grooming_M0640, Dress_Upper_M0650, Dress_Lower_M0660, Bathing_M0670, Toileting_M0680, Transferring_M0690,
Ambulation_M0700, Eating_M0710, Meal_Prep_M0720, M1840_Toilet, M1845_Toilet, M2250c_FallsPrev, Oral_Meds_M0780, Inject_Meds_M0800,
Vision_M0390, Pressure_Ulcer_Stage_M0460, Stasis_Ulcer_M0468, Surgical_Wound_M0482, M1350_Other_Wounds,
Stasis_Ulcer_Status_M0476,Surgical_Wound_Status_M0488, Braden_1_Sensory, Braden_2_Moisture, Braden_3_Activity, Braden_4_Mobility, M1910_FALL_RISK,
Braden_5_Nutrition, Braden_6_Friction, M1220_Verbal_Under, When_Anxious_M0580, Cog_Function_M0560, When_Confused_M0570, Depressive_Feelings_M0590,Endocrine_Assess,
Assessment_Completed_M0090, M1730a,M1730b,M2250d_Depress, Patient_Behav_Weekly_M0610, Hearing_M0400, Speech_M0410, Bowel_Incont_M0540, M1306_Unhealed_Pressure,Pressure_Ulcer_a_M0450, Pressure_Ulcer_Status_M0464,
Use_Phone_M0770, Ostomy_for_Bowel_M0550,UTI_M0510, Urinary_INcont_M0520, Urinary_INcont_when_M0530, M0250_Assess, M0420_Assess, M0440_Assess,
M0490_Assess, M0540_Assess, M0520_Assess, M0610_Assess, M0650_Assess, M0063_PATTERN, M0065_Pattern, M2100a_Equip, M2100b_Equip, M2100c_Equip, M2100d_Equip, M2100e_Equip, M2100f_Equip, M2100g_Equip
from #Request.prefix_db_agency#.Assessment_New where Assessment_ID='#Assessment_ID#'
SELECT p.Drug_Name
From #Request.prefix_db_agency#.PatientMeds p, #Request.prefix_db_lookup#.Meds_New m
where p.Patient_ID='#Patient_ID#'
and p.Medication_ID = m.Trade_ID
and (p.Drug_Name like "%insulin%" or p.Drug_Name like "%digox%" or m.Classification like '%anticoag%')
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,
Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,
Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,
Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,
Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,
Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,
Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
and Hearing_M0400 neq "">
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Pert, Response_Number,Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#', '#Pert#', '#Response_Number#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,
Skill, Care_Pathway,
Description, Type, Record_Creation_Date, Created_By,Item_Number
)
values
(
'#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,
'#Skill#','#Care_Pathway#',
'#Description#','#Type#',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_Number1#'
)
SELECT distinct Care_Pathway FROM #Request.prefix_db_agency#.Pathway_Details where deleted is null and Assessment_id=#Assessment_ID#
SELECT Pathway_ID, Intervention, Intervention_ID, Skill, Type FROM #Request.prefix_db_agency#.Interventions where Pathway_ID = '#Care_Pathway#'
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,
Patient_ID,
Assessment_Tracker_ID,
Assessment_ID,
Skill,
Care_Pathway,
Description,
Type,
Record_Creation_Date,
Created_By,
Intervention_Code
)
values
(
'#Session.AgencyLogin#',
#Patient_ID#,
#Assessment_Tracker_ID#,
#Assessment_ID#,
'#select_pathway_list.Skill#',
'#select_pathway_list.Pathway_ID#',
'#select_pathway_list.Intervention#',
'#select_pathway_list.Type#',
#CreateODBCDateTime(Now())#,
'#session.EmployeeID#',
'#select_pathway_list.Intervention_ID#'
)
SELECT Description, M0_Answer, Pathway_ID, Skill, Type,Item_id FROM #Request.prefix_db_lookup#.pathway_list p where (type ='goal' or type = 'intervention'
or type='vital sign') and
Pathway_ID='#Care_Pathway#'
Insert into #Request.prefix_db_agency#.Pathway_Details
(
Agency_ID,
Patient_ID,
Assessment_Tracker_ID,
Assessment_ID,
Skill,
Care_Pathway,
Description,
Type,
Record_Creation_Date,
Created_By,
Item_Number
)
values
(
'#Session.AgencyLogin#',
#Patient_ID#,
#Assessment_Tracker_ID#,
#Assessment_ID#,
'#select_pathway_list.Skill#',
'#Select_pathway_details.Care_Pathway#',
'#select_pathway_list.Description#',
'#select_pathway_list.Type#',
#CreateODBCDateTime(Now())#,
'#session.EmployeeID#',
'#select_pathway_list.Item_id#'
)