SELECT HHA_Record_Data FROM #Request.prefix_db_agency#.Datasets
where Assessment_ID =#Assessment_ID#
SELECT Patient_ID,Agency_Number,Agency_ID,Assessment_Tracker_ID,Assessment_Reason_M0100,Discharged_From_M0175,Assessment_Completed_M0090 ,
Medical_or_Treatment_Change_M0200 ,Admission_Status,Transmission_status,Assessment_Unlock_Reason ,Correction_Number,Start_of_Care_M0030,
Resump_of_Care_M0032,Resump_of_Care_NA_M0032,Person_Complete_M0080,Inpatient_Discharge_Date_M0180,Inpatient_Discharge_Date_NA_M0180,
M1016_DX_NA,Conditions_Prior_M0220,Therapies_Home_M0250,Overall_Prognosis_M0260,Rehab_Prognosis_M0270,Life_Exp_M0280,
High_Risk_Factors_M0290, Vision_M0390, Hearing_M0400, Speech_M0410, Freq_of_Pain_M0420, Intrac_Pain_M0430,Open_Wounds_M0440,
Pressure_Ulcer_M0445,Pressure_Ulcer_a_M0450,Pressure_Ulcer_b_M0450,Pressure_Ulcer_c_M0450,Pressure_Ulcer_d_M0450,Pressure_Ulcer_e_M0450,
Pressure_Ulcer_Stage_M0460,Pressure_Ulcer_Status_M0464,Stasis_Ulcer_M0468,Stasis_Ulcer_Num_M0470,Stasis_Ulcer_Hidden_M0474,
Stasis_Ulcer_Status_M0476,Surgical_Wound_M0482 ,Surgical_Wound_OB_M0484,Surgical_Wound_Hidden_M0486,Surgical_Wound_Status_M0488,
Breathing_M0490,Resp_Treatments_M0500,UTI_M0510,Urinary_INcont_when_M0530,Urinary_INcont_M0520,Bowel_Incont_M0540,Ostomy_for_Bowel_M0550,
Cog_Function_M0560,When_Confused_M0570,When_Anxious_M0580,Depressive_Feelings_M0590,Patient_Behav_Weekly_M0610,Patient_Behav_freq_M0620,
Psy_Nursing_M0630,Grooming_M0640p,Grooming_M0640,Dress_Upper_M0650,Dress_Upper_M0650p,Bathing_M0670,Bathing_M0670p,Toileting_M0680p,
Toileting_M0680,Transferring_M0690,Transferring_M0690p ,Ambulation_M0700p,Ambulation_M0700,Eating_M0710,Eating_M0710p,Meal_Prep_M0720p,
Meal_Prep_M0720,Transport_M0730p,Transport_M0730,Laundry_M0740p,Laundry_M0740,Housekeeping_M0750p,Housekeeping_M0750,Shopping_M0760p,
Shopping_M0760,Dress_Lower_M0660,Dress_Lower_M0660p,Use_Phone_M0770p,Use_Phone_M0770,Oral_Meds_M0780,Oral_Meds_M0780p,Inhalant_Meds_M0790,
Inhalant_Meds_M0790p,Inject_Meds_m0800p,Inject_Meds_m0800,Patient_Manage_Equip_M0810,Caregiver_Manage_Equip_M0820,
Emergent_Care_M0830,Emergent_Care_Reason_M0840,Inpatient_Facility_M0855,Discharge_Disposition_M0870,After_Discharge_Services_M0880,
Hospital_Reason_M0890,Hospital_Reason_List_M0895,Nursing_Home_M0900,Date_Most_Recent_M0903,Date_Discharge_M0906,M0110,M0826_NA,
M0826_Ther_Need,M0102_Physician_SOC,M0104_Date_of_Referral,M1012_Inpat_DX_NA,M1012_Inpat_DX_UK,M1032_Frailty,M1220_Verbal_Under,
M1240_Pain_Assess,M1300_Pressure,M1302_Pressure,M1306_Unhealed_Pressure,M1308_d_2_Pressure,M1308_d_3_Pressure,M1310_1,M1310_Length,
M1312_Width,M1312_1,M1314_Depth,M1314_1,M1350_Other_Wounds,M1730_Depression,M1730a,M1730b,M1840_Toilet,M1845_Toilet,M1900a_SelfCare,
M1900b_Amb,M1900c_Transfer,M1900d_House,M1910_Fall_Risk,M2000_Adverse,M2002_Med_FU,M2010_Med_Edu,HIPPS_Code,M2100a_Equip,
M2100b_Equip,M2100c_Equip,M2100d_Equip,M2100e_Equip,M2100f_Equip, M2100g_Equip,M2110_Assist_Freq,M2250a_PhysNot,M2250b_Diabetic,
M2250c_FallsPrev,M2250d_Depress,M2250e_Pain,M2250f_PressUlc, M2250g_PressUlcMoist,
M1308_a_12_Pressure,M1308_b_12_Pressure,
M1308_c_12_Pressure,M1308_d_12_Pressure,M1308_d_22_Pressure,
M1308_d_32_Pressure,M1040_Influ,M1050_Pneu,M1055_Pneu,M1307_Date,
M1307_Oldest,M1500_Symptoms,M1510_Hrt_FU,M2004_Med_Int,M2015_Drug_Edu,
M2400a_Diabetic,M2400b_FallsPrev,M2400c_Depress,M2400d_Pain,M2400e_PressUlc,
M2400f_PressUlcMoist,Date_Discharge_M0906
FROM #Request.prefix_db_agency#.Assessment_New
WHERE Assessment_ID='#Assessment_ID#'
SELECT M0245_ICD
FROM #Request.prefix_db_agency#.Diagnosis
WHERE Assessment_ID='#Assessment_ID#' limit 0,1
SELECT Diagnosis.Primary_Diagnosis,Diagnosis.Secondary_Diagnosis,ICD,Code_Type,Text_ICD,Severity
From #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID='#Assessment_ID#' and M0230_Link is not null order by dx_order
SELECT *
From #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID='#Assessment_ID#' and M0230_Link is not null and Primary_Diagnosis =1 order by dx_order
SELECT *
From #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID='#Assessment_ID#' and M0190_Link is not null order by dx_order
SELECT *
From #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID='#Assessment_ID#' and M0210_Link is not null order by dx_order
SELECT *
From #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID='#Assessment_ID#' and M1012_Link is not null
select Assisting_Persons_M0350, Current_Payment_Sources_M0150, Agency_Assigned_ID, First_Name_M0040, Middle_Initial_M0040, Last_Name_M0040,
Suffix_M0040, State_M0050, Zip_M0060, Medicare_Number_M0063, Medicare_Number_NA_M0063, SSN_M0064, SSN_M0064_NA, Medicaid_Number_M0065,
Medicaid_Number_NA_M0065,DOB_M0066,Gender_M0069,Primary_ReferringPhys_ID_NA,Race_M0140,Current_Residence_M0300,M1100_Living_Situation
from #Request.prefix_db_agency#.patient where patient_id='#Patient_ID#'
select SFW_ID,Agency_State_ID,Agency_Medicare_ID,Agency_Medicaid_ID,Agency_Branch_ID,Natl_Provider_ID
from #Request.prefix_db_lookup#.Agency where Agency_ID='#Agency_Id#'
SELECT physician_ID FROM #Request.prefix_db_lookup#.patientphysician where patient_id='#Patient_ID#'
SELECT Natl_Provider_ID FROM #Request.prefix_db_lookup#.Physician where physician_ID = '#PatientPhy_Details.physician_ID#'
select contacttype,Frequency_of_Care,Caregiver_Scope from #Request.prefix_db_agency#.PatientContact where patient_id='#Patient_ID#'
SELECT Patient_ID, Last_Name_M0040 AS Last_Name, First_Name_M0040 AS First_Name, Middle_Initial_M0040 AS Middle
,Payer_ID
FROM #Request.prefix_db_agency#.patient
WHERE Patient_Id = '#Patient_ID#'
AND Agency_Id = '#Agency_Id#'
SELECT * FROM #Request.prefix_db_agency#.Datasets where Assessment_ID='#Assessment_ID#'
select * from #Request.prefix_db_agency#.Datasets where Assessment_ID='#Assessment_ID#'
update #Request.prefix_db_agency#.Assessment_New Set Transmission_status='Errors in dataset'
where Assessment_id='#Assessment_id#'
insert IGNORE into #Request.prefix_db_agency#.Datasets (Assessment_Tracker_ID,Assessment_ID,Agency_Number,Patient_ID,HHA_Record_Data,Creation_Date,Rev_Number,
Mask_req) values(#Assessment_Tracker_ID#,#Assessment_ID#,#Agency_Number#,#Patient_ID#,'#HHA_Record_Data#',now(),0,'#Mask_Required#')
update #Request.prefix_db_agency#.Assessment_New Set Transmission_status='#Transmission_status#'
where Assessment_id='#Assessment_id#'
update #Request.prefix_db_agency#.Datasets set HHA_Record_Data='#HHA_Record_Data#' where Datasets_ID = 's3.Datasets_ID'
update #Request.prefix_db_agency#.Assessment_New Set Transmission_status='#Transmission_status#'
where Assessment_id='#Assessment_id#'
insert into #Request.prefix_db_agency#.Datasets (Assessment_Tracker_ID,Assessment_ID,Agency_ID,Patient_ID,HHA_Record_Data,Creation_Date,Rev_Number,
Mask_req) values(#Assessment_Tracker_ID#,#Assessment_ID#,#Agency_ID#,#Patient_ID#,'#HHA_Record_Data#',now(),0,0)
update #Request.prefix_db_agency#.Assessment_New Set Transmission_status='#Transmission_status#'
where Assessment_id='#Assessment_id#'
update #Request.prefix_db_agency#.Datasets set HHA_Record_Data='#HHA_Record_Data#' where Datasets_ID = 'Datasets_ID'
update #Request.prefix_db_agency#.Assessment_New Set Transmission_status='#Transmission_status#'
where Assessment_id='#Assessment_id#'