SELECT DISTINCT d.Datasets_ID, d.Creation_Date, d.DatasetCreated, d.Assessment_Tracker_ID, p.Patient_ID, p.Last_name_M0040, p.First_Name_m0040, p.Current_Payment_Sources_M0150, an.Assessment_Tracker_ID, an.Assessment_Reason_M0100, an.Assessment_Completed_M0090, an.Transmission_Status From #Request.prefix_db_agency#.Datasets d, #Request.prefix_db_agency#.patient p, #Request.prefix_db_agency#.Assessment_New an Where (d.Agency_ID = '#Session.AgencyLogin#' or d.Agency_ID = '#Session.AgencyID#') AND (d.DatasetCreated = 0 OR d.DatasetCreated = 1 or d.DatasetCreated is null) AND d.Patient_ID = p.Patient_ID AND d.Assessment_Tracker_ID = an.Assessment_Tracker_ID AND an.Transmission_Status LIKE '%ready to transmit%' Order By Assessment_Completed_M0090 asc, Last_name_M0040 asc

Dataset List

Check the datasets you want to download. After clicking "Submit", open PowerPath and click "Download Datasets for Transmission".

*If Medicare is a payment source, transmission of OASIS is required.

>

Select PatientRecordLock_ID From #Request.prefix_db_agency#.PatientRecordLock Where Patient_ID = #patient_ID# AND agency_ID = #session.agencyID# AND UnlockedBy_ID = 0

	Patient	Assessment Reason	Locked	*Payment Sources	Download
	#Last_Name_M0040#, #First_Name_M0040#	#Assessment_Reason_M0100#	#DateFormat(Creation_Date, "mm/dd/yy")#	#Current_Payment_Sources_M0150#	Patient Locked checked> Previously Selected

There are no datasets waiting to be downloaded.

Select PatientRecordLock_ID From #Request.prefix_db_agency#.PatientRecordLock Where Patient_ID = #patient_ID# AND agency_ID = #session.agencyID# AND UnlockedBy_ID = 0 bgcolor="FFFFFF" bgcolor="e7e7e9"> #Last_Name_M0040#, #First_Name_M0040# #Assessment_Reason_M0100# #DateFormat(Creation_Date, "mm/dd/yy")# #Current_Payment_Sources_M0150# Patient Locked checked> Previously Selected There are no datasets waiting to be downloaded. --->