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#'
update #Request.prefix_db_agency#.Diagnosis d, #Request.prefix_db_lookup#.vetted_190924 v
set d.Clinical_Type = v.Pathway
where d.Assessment_id='#session.cs.AssessmentId#'
and d.ICD = v.ICD
SELECT Patient_ID,Agency_Id,Assessment_Tracker_ID FROM #Request.prefix_db_agency#.Assessment_New WHERE Assessment_ID='#Assessment_ID#'
SELECT Certification_Start, Certification_End, Breathing_M0490, Therapies_Home_M0250, Freq_of_Pain_M0420, 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, 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, When_Anxious_M0580, Cog_Function_M0560, When_Confused_M0570, Depressive_Feelings_M0590,Endocrine_Assess,
Assessment_Completed_M0090, M1730a,M1730b,Patient_Behav_Weekly_M0610, 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
from #Request.prefix_db_agency#.Assessment_New where Assessment_ID='#Assessment_ID#'
SELECT *
From #Request.prefix_db_agency#.Diagnosis d
where d.Assessment_ID='#Assessment_ID#'
and d.M0230_Link != ''
and d.Disabled = 0
and d.Clinical_Type is not null
INSERT IGNORE 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#,'SN','#Clinical_Type#', concat('M1021''M1023',' ', '#Short_Diagnosis#',' ','#ICD#'),'symptom','#Severity#','0''25''50''75''100',#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Clinical_Type#')
SELECT *
From #Request.prefix_db_agency#.Diagnosis d, #Request.prefix_db_lookup#.CW_Pathways_MHCB c
where d.Assessment_ID='#Assessment_ID#'
and d.Clinical_Type = c.Pathway_ID
and d.M0230_Link != ''
and d.Disabled = 0
and d.Clinical_Type is not null
and c.Type != 'Teaching'
INSERT IGNORE 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#,'SN','#Pathway_ID#', concat('M1021''M1023',' ','#Short_Diagnosis#',' ','#ICD#',' ', '#Description#'),'#Type#','#Severity#','0''25''50''75''100',
#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Item_ID#')
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#',concat('#gTemp#',': ','#Description#'),'#Type#','#Pert#','#Response_Number#',#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Care_Pathway#')
SELECT * From #Request.prefix_db_lookup#.CW_Pathways_MHCB c
where c.Pathway_ID = 14
and c.Type != 'Teaching'
INSERT IGNORE 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)
VALUES ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'SN','#Pathway_ID#', concat('#gTemp#',': ','#Description#'),'#Type#', #CreateODBCDateTime(Now())#,'#session.EmployeeID#')
SELECT * From #Request.prefix_db_lookup#.CW_Pathways_MHCB c
where c.Pathway_ID IN (18,19,20)
and c.Type != 'Teaching'
INSERT IGNORE 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)
VALUES ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'SN','#Pathway_ID#', '#Description#','#Type#', #CreateODBCDateTime(Now())#,'#session.EmployeeID#')
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#','#Care_Pathway#')
SELECT * From #Request.prefix_db_lookup#.CW_Pathways_MHCB c
where c.Pathway_ID = #Care_Pathway#
and c.Type != 'Teaching'
INSERT IGNORE 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)
VALUES ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'SN','#Pathway_ID#', concat('#gTemp#',': ','#Description#'),'#Type#', #CreateODBCDateTime(Now())#,'#session.EmployeeID#')
Insert into #Request.prefix_db_agency#.Pathway_Details
(Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,Skill,Care_Pathway,Description,Type,Pert,Record_Creation_Date,Created_By,Item_Number)
values ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'#Skill#','#Care_Pathway#','#Description#','#Type#','#Pert#',#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Care_Pathway#')
SELECT * From #Request.prefix_db_lookup#.CW_Pathways_MHCB c
where c.Pathway_ID = #Care_Pathway#
and c.Type != 'Teaching'
INSERT IGNORE 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)
VALUES ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'SN','#Pathway_ID#', concat('#gTemp#',': ','#Description#'),'#Type#', #CreateODBCDateTime(Now())#,'#session.EmployeeID#')
Insert into #Request.prefix_db_agency#.Pathway_Details
(Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,Skill,Care_Pathway,Description,Type,Pert,Record_Creation_Date,Created_By,Item_Number)
values ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'#Skill#','#Care_Pathway#','#Description#','#Type#','#Pert#',#CreateODBCDateTime(Now())#,'#session.EmployeeID#','#Care_Pathway#')
SELECT * From #Request.prefix_db_lookup#.CW_Pathways_MHCB c
where c.Pathway_ID = #Care_Pathway#
and c.Type != 'Teaching'
INSERT IGNORE 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)
VALUES ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'SN','#Pathway_ID#', concat('#gTemp#',': ','#Description#'),'#Type#', #CreateODBCDateTime(Now())#,'#session.EmployeeID#')
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#','#Care_Pathway#')
SELECT * From #Request.prefix_db_lookup#.CW_Pathways_MHCB c
where c.Pathway_ID = #Care_Pathway#
and c.Type != 'Teaching'
INSERT IGNORE 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)
VALUES ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'SN','#Pathway_ID#', concat('#gTemp#',': ','#Description#'),'#Type#', #CreateODBCDateTime(Now())#,'#session.EmployeeID#')
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#','#Care_Pathway#')
SELECT * From #Request.prefix_db_lookup#.CW_Pathways_MHCB c
where c.Pathway_ID = #Care_Pathway#
and c.Type != 'Teaching'
INSERT IGNORE 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)
VALUES ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'SN','#Pathway_ID#', concat('#gTemp#',': ','#Description#'),'#Type#', #CreateODBCDateTime(Now())#,'#session.EmployeeID#')
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#','#Care_Pathway#')
SELECT * From #Request.prefix_db_lookup#.CW_Pathways_MHCB c
where c.Pathway_ID = #Care_Pathway#
and c.Type != 'Teaching'
INSERT IGNORE 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)
VALUES ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'SN','#Pathway_ID#', concat('#gTemp#',': ','#Description#'),'#Type#', #CreateODBCDateTime(Now())#,'#session.EmployeeID#')
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#','#Care_Pathway#')
SELECT * From #Request.prefix_db_lookup#.CW_Pathways_MHCB c
where c.Pathway_ID = #Care_Pathway#
and c.Type != 'Teaching'
INSERT IGNORE 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)
VALUES ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'SN','#Pathway_ID#', concat('#gTemp#',': ','#Description#'),'#Type#', #CreateODBCDateTime(Now())#,'#session.EmployeeID#')
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#','#Care_Pathway#')
SELECT * From #Request.prefix_db_lookup#.CW_Pathways_MHCB c
where c.Pathway_ID = #Care_Pathway#
and c.Type != 'Teaching'
INSERT IGNORE 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)
VALUES ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'SN','#Pathway_ID#', concat('#gTemp#',': ','#Description#'),'#Type#', #CreateODBCDateTime(Now())#,'#session.EmployeeID#')
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#','#Care_Pathway#')
SELECT * From #Request.prefix_db_lookup#.CW_Pathways_MHCB c
where c.Pathway_ID = #Care_Pathway#
and c.Type != 'Teaching'
INSERT IGNORE 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)
VALUES ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'SN','#Pathway_ID#', concat('#gTemp#',': ','#Description#'),'#Type#', #CreateODBCDateTime(Now())#,'#session.EmployeeID#')
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#','#Care_Pathway#')
SELECT * From #Request.prefix_db_lookup#.CW_Pathways_MHCB c
where c.Pathway_ID = #Care_Pathway#
and c.Type != 'Teaching'
INSERT IGNORE 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)
VALUES ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'SN','#Pathway_ID#', concat('#gTemp#',': ','#Description#'),'#Type#', #CreateODBCDateTime(Now())#,'#session.EmployeeID#')
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#','#Care_Pathway#')
SELECT * From #Request.prefix_db_lookup#.CW_Pathways_MHCB c
where c.Pathway_ID = #Care_Pathway#
and c.Type != 'Teaching'
INSERT IGNORE 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)
VALUES ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'SN','#Pathway_ID#', concat('#gTemp#',': ','#Description#'),'#Type#', #CreateODBCDateTime(Now())#,'#session.EmployeeID#')
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#','#Care_Pathway#')
SELECT * From #Request.prefix_db_lookup#.CW_Pathways_MHCB c
where c.Pathway_ID = #Care_Pathway#
and c.Type != 'Teaching'
INSERT IGNORE 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)
VALUES ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'SN','#Pathway_ID#', concat('#gTemp#',': ','#Description#'),'#Type#', #CreateODBCDateTime(Now())#,'#session.EmployeeID#')
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#','#Care_Pathway#')
SELECT * From #Request.prefix_db_lookup#.CW_Pathways_MHCB c
where c.Pathway_ID = #Care_Pathway#
and c.Type != 'Teaching'
INSERT IGNORE 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)
VALUES ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'SN','#Pathway_ID#', concat('#gTemp#',': ','#Description#'),'#Type#', #CreateODBCDateTime(Now())#,'#session.EmployeeID#')
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#','#Care_Pathway#')
SELECT * From #Request.prefix_db_lookup#.CW_Pathways_MHCB c
where c.Pathway_ID = #Care_Pathway#
and c.Type != 'Teaching'
INSERT IGNORE 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)
VALUES ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'SN','#Pathway_ID#', concat('#gTemp#',': ','#Description#'),'#Type#', #CreateODBCDateTime(Now())#,'#session.EmployeeID#')
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#','#Care_Pathway#')
SELECT * From #Request.prefix_db_lookup#.CW_Pathways_MHCB c
where c.Pathway_ID = #Care_Pathway#
and c.Type != 'Teaching'
INSERT IGNORE 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)
VALUES ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'SN','#Pathway_ID#', concat('#gTemp#',': ','#Description#'),'#Type#', #CreateODBCDateTime(Now())#,'#session.EmployeeID#')
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#','#Care_Pathway#')
SELECT * From #Request.prefix_db_lookup#.CW_Pathways_MHCB c
where c.Pathway_ID = #Care_Pathway#
and c.Type != 'Teaching'
INSERT IGNORE 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)
VALUES ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'SN','#Pathway_ID#', concat('#gTemp#',': ','#Description#'),'#Type#', #CreateODBCDateTime(Now())#,'#session.EmployeeID#')
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#','#Care_Pathway#')
SELECT * From #Request.prefix_db_lookup#.CW_Pathways_MHCB c
where c.Pathway_ID = #Care_Pathway#
and c.Type != 'Teaching'
INSERT IGNORE 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)
VALUES ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'SN','#Pathway_ID#', concat('#gTemp#',': ','#Description#'),'#Type#', #CreateODBCDateTime(Now())#,'#session.EmployeeID#')
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#','#Care_Pathway#')
SELECT * From #Request.prefix_db_lookup#.CW_Pathways_MHCB c
where c.Pathway_ID = #Care_Pathway#
and c.Type != 'Teaching'
INSERT IGNORE 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)
VALUES ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'#Skill#','#Pathway_ID#', '#Description#','#Type#', #CreateODBCDateTime(Now())#,'#session.EmployeeID#')
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#','#Care_Pathway#')
SELECT * From #Request.prefix_db_lookup#.CW_Pathways_MHCB c
where c.Pathway_ID = #Care_Pathway#
and c.Type != 'Teaching'
INSERT IGNORE 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)
VALUES ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'#Skill#','#Pathway_ID#', '#Description#','#Type#', #CreateODBCDateTime(Now())#,'#session.EmployeeID#')
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#','#Care_Pathway#')
SELECT * From #Request.prefix_db_lookup#.CW_Pathways_MHCB c
where c.Pathway_ID = #Care_Pathway#
and c.Type != 'Teaching'
INSERT IGNORE 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)
VALUES ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'#Skill#','#Pathway_ID#', '#Description#','#Type#', #CreateODBCDateTime(Now())#,'#session.EmployeeID#')
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#','#Care_Pathway#')
SELECT * From #Request.prefix_db_lookup#.CW_Pathways_MHCB c
where c.Pathway_ID = #Care_Pathway#
and c.Type != 'Teaching'
INSERT IGNORE 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)
VALUES ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'#Skill#','#Pathway_ID#', '#Description#','#Type#', #CreateODBCDateTime(Now())#,'#session.EmployeeID#')
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#','#Care_Pathway#')
SELECT * From #Request.prefix_db_lookup#.CW_Pathways_MHCB c
where c.Pathway_ID = #Care_Pathway#
and c.Type != 'Teaching'
INSERT IGNORE 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)
VALUES ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'#Skill#','#Pathway_ID#', '#Description#','#Type#', #CreateODBCDateTime(Now())#,'#session.EmployeeID#')
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#','#Care_Pathway#')
SELECT * From #Request.prefix_db_lookup#.CW_Pathways_MHCB c
where c.Pathway_ID = #Care_Pathway#
and c.Type != 'Teaching'
INSERT IGNORE 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)
VALUES ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'#Skill#','#Pathway_ID#', '#Description#','#Type#', #CreateODBCDateTime(Now())#,'#session.EmployeeID#')
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#','#Care_Pathway#')
SELECT * From #Request.prefix_db_lookup#.CW_Pathways_MHCB c
where c.Pathway_ID = #Care_Pathway#
and c.Type != 'Teaching'
INSERT IGNORE 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)
VALUES ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'#Skill#','#Pathway_ID#', '#Description#','#Type#', #CreateODBCDateTime(Now())#,'#session.EmployeeID#')
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#','#Care_Pathway#')
SELECT * From #Request.prefix_db_lookup#.CW_Pathways_MHCB c
where c.Pathway_ID = #Care_Pathway#
and c.Type != 'Teaching'
INSERT IGNORE 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)
VALUES ('#Session.AgencyLogin#',#Patient_ID#,#Assessment_Tracker_ID#,#Assessment_ID#,'#Skill#','#Pathway_ID#', '#Description#','#Type#', #CreateODBCDateTime(Now())#,'#session.EmployeeID#')