SELECT eaRole FROM #Request.prefix_db_agency#.employee_auth where eaID='#Session.EmployeeID#';
UPDATE #Request.prefix_db_agency#.pCMS4857 SET
Date_Change = #CreateODBCDateTime(form.Date_Change)#,
Date_Sent = #CreateODBCDate(form.Date_Sent)#,
Date_Received = #CreateODBCDate(form.Date_Received)#,
ICD_Date = ,
Medications = ,
DME = ,
Safety = ,
Diet = ,
Allergies = ,
Functional_Limitations = ,
Activities_Permitted = ,
Mental_Status = ,
Prognosis = ,
Careplan_SN = ,
Goals_SN = ,
Careplan_PT = ,
Goals_PT = ,
Careplan_OT = ,
Goals_OT = ,
Careplan_ST = ,
Goals_ST = ,
Careplan_MSW = ,
Goals_MSW = ,
Careplan_HHA = ,
Goals_HHA = ,
Rehabilitation_Potential = ,
Discharge_Plan = ,
MD_Homebound = ,
MD_Clinical_Condition = ,
Change_by =
WHERE Order_ID =
and Status = 0
SELECT * FROM #Request.prefix_db_agency#.pCMS4857
WHERE Order_ID =
SELECT * FROM #Request.prefix_db_agency#.pCMS4857
WHERE Assmt_ID =
AND Status != 0
UPDATE #Request.prefix_db_agency#.pProblem SET CMSOrder_ID = 0
WHERE CMSOrder_ID IN ()
UPDATE #Request.prefix_db_agency#.pCareplan SET CMSOrder_ID = 0
WHERE CMSOrder_ID IN ()
UPDATE #Request.prefix_db_agency#.pPtmeds SET CMSOrder_ID = 0
WHERE CMSOrder_ID IN ()
UPDATE #Request.prefix_db_agency#.pWoundsVitals SET CMSOrder_ID = 0
WHERE CMSOrder_ID IN ()
>
UPDATE #Request.prefix_db_agency#.pAssessments SET
Record_Created_By = '#Session.EmployeeId#'
where Assmt_ID = '#form.Assmt_ID#'
AND status = 0
UPDATE #Request.prefix_db_agency#.pCMS4857 SET
Clinician_Signature = 'Digitally signed on #today# by #Session.Display#'
WHERE Order_ID =
UPDATE #Request.prefix_db_agency#.pCMS4857 SET
Clinician_Signature = ''
WHERE Order_ID =
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Assmt_ID =
AND status =
UPDATE #Request.prefix_db_agency#.pCMS4857
SET
Status = 2,
Date_Sent = #CreateODBCDate(form.Date_Sent)#,
Date_Sent = NULL,
Render_Phys_ID = ,
Date_Change = ,
Change_by =
WHERE Order_ID =
SELECT * FROM #Request.prefix_db_agency#.pCMS4857
WHERE Order_ID =
SELECT * FROM #Request.prefix_db_agency#.pCMS4857
WHERE Assmt_ID =
AND Status != 0
UPDATE #Request.prefix_db_agency#.pProblem SET CMSOrder_ID = 0
WHERE CMSOrder_ID IN ()
UPDATE #Request.prefix_db_agency#.pCareplan SET CMSOrder_ID = 0
WHERE CMSOrder_ID IN ()
UPDATE #Request.prefix_db_agency#.pPtmeds SET CMSOrder_ID = 0
WHERE CMSOrder_ID IN ()
UPDATE #Request.prefix_db_agency#.pWoundsVitals SET CMSOrder_ID = 0
WHERE CMSOrder_ID IN ()
poe = CreateObject("Component", "PhysOrderEmail");
//str = poe.NewOrderEmail(#form.formId#, #form.Render_Phys_ID#);