select * from zip_cbsa WHERE ZIPCODE = SELECT IFNULL(MAX(Patient_ID),0)+1 As pPatient_ID FROM #Request.prefix_db_agency#.pPatients SELECT IFNULL(MAX(AutoPatient_ID),0)+1 As pAutoPatient_ID FROM #Request.prefix_db_agency#.pPatients INSERT INTO #Request.prefix_db_agency#.pPatients (Patient_ID,Loc_ID, Status,Referral_ID,Payer_ID, Pt_Agy_ID, Pt_First, Pt_Middle, Pt_Last, Pt_Suffix, Pt_Street, Pt_City, Pt_State, Pt_Phone, Pt_Zip, Pt_DOB,Pt_Race, M0140_ETHNIC, Pt_Gender, Pt_language,Interpreter, Allergies, Pt_SSN, Pt_SSN_UK, Home_Directions, Specific_Concerns, Email, Comments, Zip_Longitude, Zip_Latitude, Pt_Longitude, Pt_Latitude , FIPS_Code, CBSA_Code, UrbanRural, WageIndex, Record_Creation_Date, Record_Created_By, Record_Mod_Date, Record_Mod_By) VALUES ( , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ) 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")#', '#Trim(form.Pt_Last)#','#Trim(form.Pt_First)#',NULL,NULL,'Melissa','eligibility', '#session.employeeid#', '#TimeFormat(now(), "short")#',#now()#,#now()#,'#Session.employeeid#') Hello Team,

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



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="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 eligibility Request",Body="'#body_informations#'"); 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")#', '#Trim(form.Pt_Last)#','#Trim(form.Pt_First)#',NULL,NULL,'Melissa','intake_dataentry', '#session.employeeid#', '#TimeFormat(now(), "short")#',#now()#,#now()#,'#Session.employeeid#') SELECT * FROM #Request.prefix_db_agency#.pPatients WHERE Status IN (0,1,4) AND Patient_ID = UPDATE #Request.prefix_db_agency#.pPatients SET Status = , Record_Mod_Date = , Record_Mod_By = WHERE Loc_ID = AND Patient_ID = INSERT INTO #Request.prefix_db_agency#.pPatients (Patient_ID,Loc_ID, Status, Pt_Agy_ID, Pt_First, Pt_Middle, Pt_Last, Pt_Suffix, Pt_Street, Pt_City, Pt_State, Pt_Phone, Pt_Zip, Pt_DOB,Pt_Race, M0140_ETHNIC, Pt_Gender, Pt_language, Interpreter, Allergies, Pt_SSN, Pt_SSN_UK, Home_Directions, Specific_Concerns, Email, Comments, Zip_Longitude, Zip_Latitude, Pt_Longitude, Pt_Latitude, FIPS_Code, CBSA_Code, UrbanRural, WageIndex,FileName, Record_Creation_Date, Record_Created_By, Record_Mod_Date, Record_Mod_By) VALUES ( , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ) UPDATE IGNORE #Request.prefix_db_agency#.pPatients SET FileName = '#form.patid#.jpg' WHERE Patient_ID = AND Status != SELECT * FROM #Request.prefix_db_agency#.pPtContacts WHERE Patient_ID =