SELECT IFNULL(MAX(Admit_ID),0)+1 As pAdmit_ID FROM #Request.prefix_db_agency#.pAdmit UPDATE #Request.prefix_db_agency#.pAdmit SET Status = , Date_Change = , Change_by = WHERE Patient_ID = AND Admit_ID = SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Patient_ID = AND Admit_ID = AND Status = UPDATE #Request.prefix_db_agency#.pAdmit_Svcs SET Status = WHERE Admit_ID = UPDATE #Request.prefix_db_agency#.pAssessments SET Status = WHERE Assmt_ID IN () AND Status = 0 UPDATE #Request.prefix_db_agency#.pSchedules SET Status = WHERE Assmt_ID IN () AND Status = 0 UPDATE #Request.prefix_db_agency#.pProblem SET Status = WHERE Assmt_ID IN () AND Status = 0 UPDATE #Request.prefix_db_agency#.pCareplan SET Status = WHERE Assmt_ID IN () AND Status = 0 UPDATE #Request.prefix_db_agency#.pAuths SET Status = WHERE Assmt_ID IN () AND Status = 0 UPDATE #Request.prefix_db_agency#.pProgress SET Status = WHERE Assmt_ID IN () AND Status = 0 DELETE FROM #Request.prefix_db_agency#.pOASIS_QA WHERE Assmt_ID IN () UPDATE #Request.prefix_db_agency#.pCMS4857 SET Status = WHERE Assmt_ID IN () AND Status = 0 SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Patient_ID = AND Status = AND F26 like '1%' UPDATE #Request.prefix_db_agency#.pAdmit SET Status = , Admit_Type = , Referral_ID = , Admission_Source = , M0104_PHYSN_RFRL_DT = , Refer_Phys_ID = , M0102_PHYSN_ORDRD_SOCROC_DT = , M0102_PHYSN_ORDRD_SOCROC_DT_NA = , M0102_PHYSN_ORDRD_SOCROC_DT = NULL, M0102_PHYSN_ORDRD_SOCROC_DT_NA = , M0030_START_CARE_DT = , Render_Phys_ID = , Date_F2F = , MD_Clinical_Condition = , MD_Homebound = , Caregiver = , M1100_PTNT_LVG_STUTN = , Service_Place = , FU_Freq = , Clinical_Manager = , clinical_authorization = , Case_Manager = , case_authorization = , agreed_careplan = , Advance_Directive = , Advance_DirectiveDate = , Code_Status = , Emerg_Priority = , problem_Intake = , Caregiver_competency = , Caregiver_commitment = , Notes = , Approved = , drafts = , Agy_Admit = , Date_Change = , Change_by = WHERE Patient_ID = AND Admit_ID = AND Status = INSERT INTO #Request.prefix_db_agency#.pAdmit ( Admit_ID,Patient_ID, Status, Admit_Type, Referral_ID, Admission_Source, M0104_PHYSN_RFRL_DT, Refer_Phys_ID, M0102_PHYSN_ORDRD_SOCROC_DT,M0102_PHYSN_ORDRD_SOCROC_DT_NA,M0030_START_CARE_DT, Render_Phys_ID, Date_F2F, MD_Clinical_Condition, MD_Homebound, Caregiver, M1100_PTNT_LVG_STUTN, Service_Place,FU_Freq, Clinical_Manager,clinical_authorization, Case_Manager, case_authorization,agreed_careplan, Advance_Directive, Advance_DirectiveDate, Code_Status, Emerg_Priority, problem_Intake, Caregiver_competency, Caregiver_commitment, Notes, Approved, drafts, Agy_Admit, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , NULL, , , , , , , NULL, , , , , , , , , , , , , , , , , , , , , , , , , , , ) UPDATE #Request.prefix_db_agency#.pAdmit_Svcs SET Admit_ID = , Date_Change = , Change_by = WHERE AutoAdmitSvcs_ID IN () AND Status = 0 SELECT * FROM #Request.prefix_db_agency#.pAdmit_Svcs WHERE Admit_ID = AND Status = 0 AND Assmt_ID = 0 form.admitaction EQ 'sendfax' OR form.admitaction EQ 'update' OR form.admitaction EQ '487order' OR form.admitaction EQ 'admissiondrafts' OR form.admitaction EQ 'no_order' ) AND donot_create_oasis EQ 'no' > SELECT pPatients.*,Agency.* ,pAdmit.Refer_Phys_ID AS Primary_ReferringPhys_Id_M0072, pAdmit.* FROM #Request.prefix_db_agency#.pPatients JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Patient_Id = pPatients.Patient_Id JOIN #Request.prefix_db_lookup#.Agency ON Agency.Agency_Id = pPatients.Loc_ID WHERE pPatients.Patient_Id = AND pAdmit.Admit_ID = AND pPatients.status < 2 AND pAdmit.status = 0 GROUP BY pPatients.Patient_Id SELECT * FROM #Request.prefix_db_agency#.pPtPayer WHERE Patient_ID = '#form.ID#' AND Status = 0 SELECT * FROM #Request.prefix_db_agency#.pAdmit_Svcs WHERE Admit_ID = AND Status = 0 INSERT INTO #Request.prefix_db_agency#.pAdmit_Svcs ( Admit_ID,Patient_ID, Status, Skill, Start_Date, Physician_order, Notes, Admitted, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( '#pAdmit_ID#' ,'#form.ID#',0, '1 - SOC - SN', '#DateFormat(GetPatient.M0030_START_CARE_DT,"yyyy-mm-dd")#', 'yes','Created 1 - SOC - SN by admission','yes', #now()# , #admissionEmployeeId# , #now()#, #admissionEmployeeId# ) SELECT * FROM #Request.prefix_db_agency#.pAdmit_Svcs WHERE Admit_ID = AND Status = 0 AND Skill NOT IN ('0') request.pat = CreateObject("component","components.general.patients").init(); GetM = request.pat.medslist(#form.ID#); SELECT * FROM GetM WHERE Status = 0 AND N0415 IS NOT NULL SELECT * FROM GetM WHERE Status = 0 AND N0415 IS NULL ' /> ' /> ' /> SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Status = 0 AND F26 = AND F27 = AND Admit_ID = UPDATE #Request.prefix_db_agency#.pAssessments SET F176 = , F177 = , F178 = , Record_Mod_Date = , Record_Mod_By = WHERE Assmt_ID = AND Admit_ID = AND status = 0 UPDATE #Request.prefix_db_agency#.pAdmit_Svcs SET Start_Date = , Date_Change = , Change_by = WHERE AutoAdmitSvcs_ID = AND Admit_ID = AND Status = 0 "/> ) AND getpAdmit_Svcs.Assmt_ID EQ 0 AND F26 NEQ ''> SELECT Assmt_ID FROM #Request.prefix_db_agency#.pAssessments WHERE Status = 0 AND Admit_ID = AND Patient_ID = AND IFNULL(F26, '') = AND IFNULL(F27, '') = AND IFNULL(F176, '') = ORDER BY AutoAssmt_ID ASC LIMIT 1 UPDATE #Request.prefix_db_agency#.pAdmit_Svcs SET Assmt_ID = WHERE AutoAdmitSvcs_ID = AND status = 0 SELECT IFNULL(Max(Assmt_ID),0)+1 as Assmt_ID FROM #Request.prefix_db_agency#.pAssessments WHERE Status = 0 SELECT 1 as Assmt_ID INSERT INTO #Request.prefix_db_agency#.pAssessments ( Assmt_ID,Admit_ID,Patient_ID,Loc_ID,F26,F27, F176, F177,F178, F206,F207,F208,F209,F210, F211, F212,F213,F214,F215,F216,F217,F220, Record_Creation_Date,Record_Created_By, Record_Mod_Date, Record_Mod_By ) VALUES ( , , , , , , , , , , , , , , , , , , , , , , , , , ) SELECT LAST_INSERT_ID() as LastInsertID SELECT * FROM #Request.prefix_db_agency#.pPatients WHERE pPatients.Patient_ID = AND pPatients.Status NOT IN (2,3) INSERT INTO #Request.prefix_db_lookup#.Coding_Request (Agency_ID,Request_Date,Last_Name,First_Name,Assessment_Type, Assessment_Date,Assigned_to,Coding_status,Assigned_by,Request_Time,MHCB_Entered, time_requested,Updated_by) VALUES ('#session.agencyid#','#DateFormat(now(),"yyyy-mm-dd")#', '#Getpats.Pt_Last#','#Getpats.Pt_First#','#F26#', '#DateFormat(certstartdate,"yyyy-mm-dd")#','Melissa','H_P_Review', '#admissionEmployeeId#', '#TimeFormat(now(), "short")#',#now()#,#now()#,'#Session.employeeid#') INSERT INTO #Request.prefix_db_lookup#.Coding_Request (Agency_ID,Request_Date,Last_Name,First_Name, Assessment_Type, Assessment_Date,Assigned_to,Coding_status,Assigned_by,Request_Time,MHCB_Entered, time_requested,Updated_by) VALUES ('#session.agencyid#','#DateFormat(now(),"yyyy-mm-dd")#', '#Getpats.Pt_Last#','#Getpats.Pt_First#','#F26#', '#DateFormat(certstartdate,"yyyy-mm-dd")#','Melissa','Coding', '#admissionEmployeeId#', '#TimeFormat(now(), "short")#',#now()#,#now()#,'#Session.employeeid#') Hello Team,

We got a new coding request with below information
Agency Name : #getTimeZone.Agency_Name# (#getTimeZone.Agency_Login#)
Patient Name : #Getpats.Pt_First#,#Getpats.Pt_Last#
Requested Date: #DateFormat(now(),"yyyy-mm-dd")# - #TimeFormat(now(), "short")#
Assessment Type: #F26# - #DateFormat(certstartdate,"yyyy-mm-dd")#



This is an automated system notification from MyHomeCareBiz.com. Therefore, there is no Unsubscribe option.





request.general = CreateObject("component","components.general.general").init(); getresult = request.general.SendMail(To="jasmin.s@myhomecarebiz.com,billing@myhomecarebiz.com,coding@myhomecarebiz.com,denise.l@myhomecarebiz.com,charmaine.v@myhomecarebiz.com,jordan.d@myhomecarebiz.com,ann.r@myhomecarebiz.com,hedelyn.f@myhomecarebiz.com,jayar.p@myhomecarebiz.com",Subject="Notification for New Coding Request",Body="'#body_informations#'"); UPDATE #Request.prefix_db_agency#.pAdmit_Svcs SET Assmt_ID = #Request.Assmt_ID# WHERE AutoAdmitSvcs_ID = #getpAdmit_Svcs.AutoAdmitSvcs_ID# ANd status = 0 SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Admit_ID = AND Patient_ID = AND F26 = AND Status = 0 SELECT Assmt_ID FROM #Request.prefix_db_agency#.pAssessments WHERE Status = 0 AND Admit_ID = AND Patient_ID = AND IFNULL(F26, '') = AND IFNULL(F27, '') = AND IFNULL(F176, '') = ORDER BY AutoAssmt_ID ASC LIMIT 1 SELECT IFNULL(Max(Assmt_ID),0)+1 as Assmt_ID FROM #Request.prefix_db_agency#.pAssessments WHERE Status = 0 SELECT 1 as Assmt_ID INSERT INTO #Request.prefix_db_agency#.pAssessments ( Assmt_ID,Admit_ID,Patient_ID,Loc_ID,F26,F27, F176, F177,F178, Record_Creation_Date,Record_Created_By, Record_Mod_Date, Record_Mod_By ) VALUES ( , , , , , , , , , , , , ) SELECT * FROM #Request.prefix_db_agency#.pAdmit_Svcs WHERE Admit_ID = AND Patient_ID = AND (Skill LIKE '%Hospice%' OR Skill = 'Hospice Comprehensive') AND Status = 0 AND Assmt_ID = 0 LIMIT 1 UPDATE #Request.prefix_db_agency#.pAdmit_Svcs SET Assmt_ID = WHERE AutoAdmitSvcs_ID = AND Status = 0 SELECT * FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = AND status = 0 INSERT INTO #Request.prefix_db_agency#.pCMS4857 ( Assmt_ID, Status,Form_Type, Date_Sent, Insured_HIC, Date_Admit, Certification_From, Certification_To, Pt_Agy_ID, Agy_CCN, Pt_First, Pt_Last, Pt_Street, Pt_City, Pt_State, Pt_Zip, Pt_Phone, Agy_Name, Agy_Street, Agy_City, Agy_State, Agy_Zip, Agy_Phone, Agy_NPI, Pt_DOB, Pt_Gender, Order_description, Discharge_Plan, Clinician_Signature, Render_Phys_ID, MD_Homebound, MD_Clinical_Condition, Date_Create, Created_by, Date_Change, Change_by) VALUES ( , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ) select LAST_INSERT_ID() as keyvalue