/** not all updates are logged here **/ VSS Ver. 8.1.0.205 10/27/2022 - Same Day Admission/Confinement Notification - Switch # 28 - notification upon Auto-Computation - storedproc: Medic_CheckSameDayConfinement VSS Ver. 8.1.0.204 10/25/2022 - additional logs for Hemo, Chemo and Radiotherapy tagging - new function for patient logs VSS Ver. 8.1.0.203 10/17/2022 - Auto-Adjust amounts on grid to fill-in the discrepancy (Auto-computation Window) - Switch # 25 AUF Ver. 6.1.0.161 10/17/2022 - Additional logs for Generating transmittal number SH Ver.6.1.0.127 10/04/2022 - Data Entry (Doctors Tab) >add 5th Physician, Cardiologist, Surgeon, Anesthesiologist Entry - Updates: >Medic_SaveAnesthesiologist.sql **new >Medic_SaveSurgeon.sql **new >PhilHealth10.4.2022.exe LMC 09/28/2022 - CF4 Report = allow to reflect 0 vitals for patient arrived in ER with no vitals. (patient tagged as died as identifier) > stored_proc : Medic_LoadPHIC_CF4 - include in Covid Report; and exclude in Inpatient Report these ff codes ('C19PP1', 'C19PP2', 'C19PP3', 'C19PP4') requested by Roselyn Marquez -PHIC > stored_proc : MedicRep_DailyMedicareCensus_NewVer VSS 09/27/2022 - add entry and switch for Final Diagnosis Entry (Auto-Computation Form) connected to tboutpatienthistory.findings AUF|VSS 09/22/2022 -create function: fn_ExemptedCase -create table | insert data: tbMedCircular, tbMed_ExemptedCase -revise [vwMed_PatientMaster >add dbo.fn_ExemptedCase(A.AccountNum, 'Circ2021-0012') [isCirc2021-0012_Exe] -revise fn_isPxPNFCirc20210012 >Case When [isCirc2021-0012_Exe] = 1 Then 0 Else 1 End >note: refer to rcf#3862 VSS 09/22/2022 -add Validation and switch on Transmittal Report >if CF2 is printed >if CF4 is verified >exemption codes for CF4 filing -revised existing condition on Printing CF2 Report >added Update script on tbmedpatient.Form2Printed VSS 09/12-13/2022 -Fix switch for validating same case rate within the same day -revise condition and switch for validating case rate's terms and conditions -updates: >set isValidate90daysCaserate = 1 >Medic_CaseRateCondition NKTI 09/02/2022 -Report modification on Enough Benefit amount -Stored Proc Modif add fields: [1stIcdRvsCode], [2ndIcdRvsCode] -Condition: If Out-Patient and First Caserate is 90935 - Hemodialysis Then >set Actual HB Charge = caserate's hci amt of 2250 >set Actual PF Charge = caserate's pf amt of 350 -Updates: >MedicRep_PartIII.sql >Part3And4ACR.rpt WCI 08/26/2022 -add stored proc fields based on the report's conditions: >MonitoringOfDeniedClaimsVer2021.rpt >MonitoringOfPHICClaimsVer2021.rpt >MonitoringOfRTHClaimsVer2021.rpt >MonitoringOfUnpaidPHICClaimsVer2021.rpt WCI 08/22,25/2022 -create stored proc for reports: >Medic_MonitoringDeniedClaimsNewFormat >Medic_MonitoringRTHClaimsNewFormat >Medic_MonitoringPHICClaimsNewFormat >Medic_MonitoringUnpaidPHICClaimsNewFormat -create/revise functions >fn_GetCaseRateAmount >fn_GetEmployeeName >Fn_CaseType >Fn_ClaimTransactDates >fn_GetPaymentORNumber >fn_GetPaymentDate >fn_GetPHICPayment -add new fields: :tbMedPatient.DeniedProcRemarks :tbMedPatient.RthProcRemarks :tbMedPatient.RthDeficiency AUFMC 08/16/2022 -to itemize discount upon saving to Medic_DumpTable for patient 1718738B -updates: >alter medic_dumptable.Amount data type to Float from Money >Medic_AutoComputeChargesOP >Medic_InsertTempTable >Medic_SavePHICSOA >Medic_SavePHICSOA_Package KLPLH 08/10/2022 >request to reflect NET Amount as Actual PF on Auto-Computation. for pwd/senior patient only >create table and data for tbMedSpecialization **new >fn_getpf_itemized **new >Medic_ReSlashing >Medic_GetDoctorPF VSS 08/09/2022 >To add RTH Letter Printing on RTH Entry Form >To add on Menu: Denied Entry Form WCI 08/08/2022 -create template for reports: >MonitoringOfDeniedClaimsVer2021.rpt >MonitoringOfPHICClaimsVer2021.rpt >MonitoringOfRTHClaimsVer2021.rpt >MonitoringOfUnpaidPHICClaimsVer2021.rpt LMC 08/08/2022 Revisions : fn_GetCaseRateAmount : MedicRep_TotalReceivable : MedicRep_TotalReceivable_All : ReceivableTotal.rpt : ReceivableTotal_ALL.rpt VSS Ver8.1.0.196 08/04/2022 >fix isZBenefit error 'invalid property value' AUFMC 08/03/2022 >request to adjust HemoProcedureDates parameter size >adjustment on the ff: NewClaimForm2ACR.rpt WCI 08/03/2022 >request to reflect complete Middlename >adjustments on the ff: MedicRep_PaidandUnpaidMonitoring vwMed_PatientMaster **New PaidUnpaidMonitoring.rpt MJSH Ver8.0.0.21 07/21/2022 >revised condition on checking If the Patient is Senior or PWD: >Senior Citizen Discount Old basis = current Age is 60 and above then Actual less 20% >PWD Discount Old Basis = using storedproc Medic_isPWD >fn_DiscountAmount **new R1MC 07/19/2022 >only Senior Citizen Discount is NET of Discount. >All discount except Senior Disc should be encoded after PHIC Deduction. LMC 07/19/2022 >MMHR ::sent updates to Diane for approval -Medic_NewMandatoryReport_Census_Current ***new -MedicRep_GetNewMandatoryReport_New -MedicRep_GetMMHR_Census_Current ***new -MandatoryReportNewFrontNew.rpt ACE 07/15/2022 >Statement of Account - request to set Final Diagnosis as the ICD/RVS Description - request to set Other Diagnosis as the Final Diagnosis in Data Entry-Diagnosis - suppress Senior/PWD discount R1MC 07/08/2022 >implement Split Caserate SOA -NET of discount (pwd & senior citizen) -Auto-Compute Discount (BILLING) -distribute whole case rate -all items is less 20% discount (pwd & senior citizen) LMC 07/07/2022 >Requests: 1. CENSUS ON DAY 1 SHOULD INTEGRATE THE CENSUS OF THE PREVIOUS DAY CAPTURED ON CUT-OFF DATE OF PREVIOUS MONTHLY REPORT 2. DAY 2 ONWARDS SHALL FOLLOW THE FORMULA (CENSUS OF THE PREVIOUS DAY PLUS ADMISSION OF THE DAY MINUS DISCHARGES OF THE DAY) 3. TO RETAIN THE MMHR SHOWING THE ADMIASSION OF THE DAY FOR OUR REFERENCE (SEPARATE REPORT) >Adjustments: -MandatoryReportNewFrontNew.rpt -vwMed_MandatoryReport_Prev **new -MedicRep_GetNewMandatoryReport_New -additional fields: TotalDischargesPHIC; TotalDischargesNONPHIC; Census_NHIP; Census_NonNHIP BIHMI Ver 8.0.0.52 06/24/2022 >pre-load patient_data..tbpatienthistory.finaldiagnosis on Data Entry(CF2)-Final Diagnosis Column1 'FinalDiagnosis' +frmEntryACR.frm +frmDiagnosis.frm LMC 06/23/2022 Requests: Allow to manual encode number/value for Day 1 NHIP and NonNHIP >MandatoryReportNewFrontNew.rpt NKTI Ver 6.1.0.117 06/17/2022 >Issue: 0 Actual charges Loaded >remove stored proc 'Medic_CreateTempTable' from Form_Load LMC 06/16/2022 >Fix Bug: Discrepancy on 2nd caserate deduction of RA +adjustment on Medic_SavePHICSOA_Package MJSH Ver 8.0.0.19 06/15/2022 >Fix report's exporting +frmView.frm +frmView2.frm +frmView3.frm +modTemp.bas VSS Ver 8.1.0.195 06/14/2022 Create Switch for SOA Complete Version 5 PNF Format >run this file: _soaCompleteVer5PNF_switch.sql ***(run twice to activate) VSS Ver 8.1.0.194 06/13/2022 Added new features(from Lorma Version): >Entry for Claim Processors +run this file: _claimprocessorEntry_script_create.sql _claimprocessorEntry_switch.sql ***(run twice to activate) >Entry for PhilHealth Member Registration Form (PMRF) +run this file: _pmrfEntry_script_create.sql _pmrfEntry_switch.sql ***(run twice to activate) +copy/paste rpt file in /Reports folder PMRFormFront.rpt PMRFormBack.rpt PMRF_Instructions.rpt >Build File for PhilHealth Dialysis Dictionary +run this file: _phicdialysisdictionary_script_create.sql _phicdialysisdictionary_switch.sql ***(run twice to activate) ***Access 'Option->User Setting' to give access. >Data Entry(CF2)->6.Consent to APRs ->Date Signed +added switch to Load Discharge Date as `Access Patients Records Date Signed` :ModSet_ID = 20 +run this file: _insertSwitchAPRDateSigned.sql AUFMC 06/09/2022 Revision: >fn_CF2Fees item# 7 >Request from client to include newly created RevenueID for Professional Fees Discount ('PF', 'PE', 'SE') MJSH 06/09/2022 Issue: Discrepancy on fetching actual Net Amount after Discount. Revision: >Medic_Compensable.PHICAmount datatype from Money to Float >Medic_InsertCompensableNew param @Amount datatype from Money to Float Revise: To retain Transmittal Details when Recomputation of PHIC Deductions >Medic_ReSlashing NKTI Ver 6.1.0.115 06/08/2022 Fix previous added feature >Validation on adding Claim in Transmittal if it's transmitted already >Counting of Confinement days if Inpatient Claims >Saving Admission Date if Inpatient Claims (adjustment on Medic_SavePostedDataNew) LMC 06/08/2022 Revise MedicRep_DailyMedicareCensus_NewVer; DailyMedicareCensus_NewVer.rpt >exclude tbdots patient in OUTpatient and ALL; add Confinement Date (storedproc) >change Register Date to Confinement Date (rptFile) LMC Ver 8.1.0.209 Issue: Loading of Allocated Amounts from Manual Allocation Remove added feature 'Auto-adjust amount on Auto-Computation IN/OUT (geCompute grid) if discrepancy found' >not applicable due to manual encoding of RA and Manual Allocation of items AUF 06/08/2022 Fix: Bad DateTime Format error upon printing CF2-front if Expired patient >Medic_GetConfinementInfo BIHMI 06/02/2022 Revision >Medic_LoadPHICPatientInfo to remove default Signatory >CSFComplete.rpt LMC Ver 8.1.0.208 Fix Bug/s >'Subscript out of range' upon clicking Auto-Comp Out-Patient AUFMC Ver 6.1.0.160 06/02/2022 >Convert string RelatedProcedure, Procedure Dates to substring(255) in Print CF2 >alter table Medicare..tbmedpatient; alter column AdmitDiag(Max) NKTI Ver 6.1.0.114 06/01/2022 >LoadInfoNew LMC 05/31/2022 : MMHR - Discharges Census base on PHIC Computation : Round-Off KLPH 06/13/2022 : _insertSwitchAPRDateSigned MJSH Ver 8.0.0.19 06/01/2022 >Revise LoadConfinementInfo >Load Newborn Hearing Screening Test (Right/Left -Pass/Refer/NotPerformed) LMC 05/31/2022 Fix Bug/s "reflecting only one date" >Previous adjustment on MMHR Front Page (based on Admission Logbook) >MedicRep_GetNewMandatoryReport_New NKTI Ver 6.1.0.111 05/31/2022 Fix Bug/s "blank when initial loading" >Revise LoadMemberType >create new function 'fn_fetchMemberType' MJSH Ver 8.0.0.17 05/31/2022 Fix Bug added report >OPD Census (RT-PCR) MJSH Ver 8.0.0.16 05/30/2022 Added report >OPD Census (RT-PCR) NKTI Ver 6.1.0.110 05/30/2022 Fix Bug/s >Form_Load >LoadMemberDetails >Medic_DiagInfo_New Added feature : fn_getDefaultDx : To use ER Admission Time as Admission Time; only if patient is with ER record dpAdmTime.value = Format(.clsAdmission.AdmissionDate, "HH:MM:SS") fn_getAdmDateTime_w/er **Status: Done : To default Admission Dx and Final Dx for the ff: "FOR OUTPATIENT ONLY" > C19T1 Adm Dx = PATIENT OBSERVED WITHOUT CONFIRMATION OR WITH NEGATIVE TEST Final Dx = PATIENT OBSERVED WITHOUT CONFIRMATION OR WITH NEGATIVE TEST > C19X1 Adm Dx = PATIENT OBSERVED WITHOUT CONFIRMATION OR WITH NEGATIVE TEST Final Dx = PATIENT OBSERVED WITHOUT CONFIRMATION OR WITH NEGATIVE TEST > 90935 Adm Dx = End-Stage Renal Disease Final Dx = End-Stage Renal Disease **Status: need to finalize design (waiting for user inputs) : To default No. Of Days = 1; "FOR OUTPATIENT ONLY" **Status: Done MJSH Ver 8.0.0.15 05/30/2022 Fix Bug/s >Transmittal Date (refresh data issue) >Fetch Transmitted (refresh data issue) VSS Ver 8.1.0.193 05/18/2022 /***Updates***/ Added Tax and PF column on Payment Batch Allocation Revised Total Amount to Include Tax and PF Revised OR Amount to include PF Revised Signatories Entry Prompt Message Patient is already transmitted. [Transmittal Report] Prompt Message Patient is already refiled. [Transmittal Report Added Patient Logs Searching [Patient Logs] Added Patient Logs Printing [Patient Logs] Admission Diagnosis to view more than 254 characters in CF2 report Added Restriction on Resetting posted Professional Fees, Transmittal details, caserates, membership type, all data on table tbmedPatient if Claims is already Submitted on EClaims [Auto-Computation Recomputation] Added module version for userlogs Added restriction on saving Reason for Signing in behalf of member/patient is required. Added validation on saving for encoded membershiptype and Admission Philhealth type Added printing of SOA - Departmental (Auto-Computation) Added module settings for.... (refer in table tbMed_ModuleSettings) To green highlight verified CF4 and exempted codes; refer fn_isCF4Verified [PhilHealth Main Form] To prompt message when PF Package amount is insufficient [Auto-Computation] To enable PhilHealth coverage on ARSP drugs under PNF Circular 20210012; P.S. Only if HCI is a ASRP Member To restrict claims with unverified cf4 with non-exempt codes [Transmittal Report]; refer fn_isCF4Verified Enable editable Auto-Computation grid To allow computation of CF4 Processing Fee for PHIC Professional Fees Payment Organized Menus/Sub-Menus Added Printing of SOA PNF Format Added logs: Admitting Diagnosis logs Admitting PhilHealth Type logs Print Claim Form 1 Print Transmittal Print Transmittal - PBEF Print SOA Complete Version 1 PHIC Summary Version 1 Print SOA Complete Version 2 PHIC Summary Version 2 Print Claim Form III - Rev 2013 PartI Print Claim Form III - Rev 2013 PartII Print Claim Form II ACR Part III&IV Complete Print Claim Form II ACR Part III&IV Complete - Preprinted Print Claim Signature Form - Complete Print Claim Signature Form - Complete PrePrinted Print Claim Form 4 Page 1 Print Claim Form 4 Page 2 Print Claim Form 4 Course in the Ward Print Claim Form 4 Drugs and Medicines Print Patient's Logs Print Claim Form 2 View Claim Form 4 Page 1 Refreshed/Deleted CF1 data. [Claim Form 1 Entry] Added ICDCode..... [Build File Caserates] Update ICDCode :.... PackageID: .... [Build File Caserates] Added Signatory: ... [Signatory] Edited Signatory:... [Signatory] Save Doctor Payment with error [Doctor Payment Allocation] Data Entry: Update patient's MedicareType to ... [Data Entry; CF1 Entry] Data Entry: Deleted Doctor [Data Entry] Data Entry/CF2: Save [Data Entry] Fix bugs: Generating Generating Transmittal Number Adding Claims for Transmittal if already Transmitted Improved Searching Claims on Transmittal Printing Claim Form 2 with multiple doctors Printing Claim Signature Form with multiple doctors 04/28/2022 : Computation based on PNF Policy. See PNF Circular 20210012. *All Patients Admission starting August 22, 2021 onwards *Only PNF items are compensable *ARSP items are compensable only if HCI is a ARSP member *Exemptions: ZBenefit, Covid-19 Isolation Package : PhilHealth Items Detailed Report *Additional sorting for: >B. DRUGS AND MEDICINES (ARSP) >B. DRUGS AND MEDICINES (PNF) >B. DRUGS AND MEDICINES (Non-PNF) 04/28/2022 : fn_isMultipleAcct LMC Ver. 8.1.0.204 04/11/2022 Updates: 1. If Claim is already transmitted, then restrict making adjustment on the following: > Membership Type > Transmittal Category 2. PHIC Performance Process - New > Exclude RT-PCR claims from the current report > Additional option for RT-PCR claims report : MedicRep_InsertAVG_YearlyProcessPerformance_newFormat : MedicRep_YearlyProcessPerformance_new_NewFormat : ProcessPerformance_NewFormat.rpt VSS Ver 8.1.0.180 CHDG 03/28/2022 1. CF4 Processing Fee (PF Payment Allocation) : Medic_DoctorList_Patient : Medic_UpdatePaymentRoomDrugOthers 2. CF4 Verified (color coding - green) 3. Add Mod_Version to tbMedLogs LMC Ver. 03/21/2022 1. RT-PCR Transmittal Report : Fn_HciInfo : fn_RtPcrDetails : Fn_GetPHICMember : fnGetExtName : Medic_NewTransmittal_rtpcr : Transmittal_rtpcr.rpt LMC 02/16/2022 Daily Philhealth Summary New Report Format (Covid and RT-PCR) Revise Existing Report (In/Out/Hemo/All) : MedicRep_DailyMedicareCensus_NewVer : sp_Medicare_NotYetTransmitted_NewVer : sp_Medicare_NotYetTransmittedDirectFiling_NewVer LMC 11/17/2021 Revise condition for Denied Tagging. Commented the Delete/Update statement for resetting record : Medic_UpdatePaymentDenied : Medic_UpdatePDWithoutBreakDown BIHMI Ver. 8.0.0.47 10/05/2021 : MedicRep_DailyTransmittalReport : DailyTransmittalReport.rpt LMC Ver 8.1.0.185 09/14/2021 What's New? 1. Doctors Receivable - TBDots Patients 2. Doctors Receivable Per Doctor - TBDots TBDots Patients 3. Total Receivable by Membership Category - TBDots Patients 4. Total Receivable by Membership Category - include Actual Professional Fees - include Receivable Professional Fees 5. Total Receivable All - TBDots Patients 6. Total Receivable All - include Actual Professional Fees - include Receivable Professional Fees 7. Professional Fees Receivable Aging by Month 8. Professional Fees Receivable Aging by Year 9. Professional Fees Payments for Uploading w/ Deduction (Auto-upload in Accounting) 10. Professional Fees Payments for Uploading w/out Deduction (Auto-upload in Accounting) 11. PhilHealth Claims Monitoring Report for Hospital Bill 12. PhilHealth Claims Monitoring Report for Professional Fees VSS Ver 8.1.9.150 09/01/2020 Whats New? 1. Auto-Computaton Window : Enhanced Doctor Entry : Enable/Disable New Entry of PF; execute the script attached w/ this file. Version Ver8.1.9.149 08/27/2020 What's New? 1. Enhanced CF4 Entry by PK VSS Ver: 8.1.9.147 08/27/2020 What's New? 1. Build File Case Rates a. Single Period Confinement Tagging per ICD/RVS Code b. 45 Days Annual Benefit Tagging per ICD/RVS Code c. Complex Searching d. Includes Logs LMC Ver 8.1.0.207 05/17/2022 Bug Fix/es: >'Type Mismatch' upon clicking Manual Allocation >'Syntax Error' upon clicking Course in the Ward & Drugs and Medicines Report CDUH Ver. 6.1.0.160 04/16/2020 Bug Fix/es: : PackageID's Data Type adjusted to Long instead of Integer. Affected Area: >Auto-Computation >Build File VSS Ver. 8.1.0.143 04/15/2020 1. Build File Caserates -> To allow add same caserate if prev's status = 0 2. CF2 Report -> Include NewBorn Screening Filter Card No /* requested by VERTEX */ VSS Ver. 8.1.0.143 03/30/2020 Bug Fix/es: : Batch Payment Total Claim VSS Ver. 04/28/2020 Bug Fixe/s: : Loading/Saving of Newborn Screening Hearing Test SLUH 07/18/2019 Modifications: 1. Computation of Doctor's VAT : disconnect from Build File Module (tagging) 2. Details button to show Confinement History of Patient 3. Payment Register Additional feature/s: 1. Entry for patient's Confinement to Other Hospital 2. MemberType to set NON-PHIC if data not yet exists. 05/08/2019 : Medic_LoadPatientCF3 : Medic_LoadPrenatalConsultation_CF3 : NewClaimForm3MCP_2013.rpt : NewClaimForm3PCR_2013.rpt : fn_CF4 DDH 05/03/2019 CF4 and CF3 Updates : fn_CF4 : Medic_CF4_CourseInTheWard : Medic_LoadPHIC_CF3 : Medic_LoadPHIC_CF4 : ClaimForm4Page1.rpt : ClaimForm4Page2.rpt : NewClaimForm3MCP_2013.rpt : NewClaimForm3PCR_2013.rpt 03/18/2019 : CF2 Updates NewClaimForm2ACR.rpt SLUH 10/02/2018 CF2 BackPart - rpt file and sp from LMC CF2 BackPart - SP(Medicrep_partIII_test) - include Discount in HCI Actual(saved Actuals are NET of Discount) SLUH 10/02/2018 Recompute - Reset Doctor entry(tbmeddoctors) if not yet transmitted. Data Entry - Allow alteration of Doctor entry(tbmeddoctors) Auto-Comp - Adjust SP (Medic_GetDoctorPF) - refer to tbbilldailybill/tbbillopdailyout LMC 10/02/218 MMHR - Adjusted Causes of Confinement order by IndexNum NKTI 10/02/2018 CSF - Adjust SP(Medic_LoadPHICPatientInfo) exclude blank membernumber. CSF Complete - Adjust report for the new format(for approval) LMC 10/03/2018 MMHR - Causes of Confinement group by substring(Code,1,3) Census Philhealth Admission Report: SP(MedicRep_CensusReport_PHICAdmission, MedicRep_CensusReport_PHICAdmissionYearly) exclude tbdots patient Philhealth Processing Performance Report - SP(MedicRep_YearlyProcessPerformance_new_NewFormat) - exclude tbdots - MedicRep_InsertAVG_YearlyProcessPerformance_newFormat - exclude tbdots MJSH 11/08/2018 Create new SP for PWD NET of Discount on PHIC computation. Adjust Source code Adjust existing SP ALTER TABLE MEDICARE..TBMEDHOSPITAL ADD isAllowPWDDiscountPhic bit, isAllowPWDDiscountPhicOut bit UPDATE MEDICARE..TBMEDHOSPITAL SET isAllowPWDDiscountPhic = 1, isAllowPWDDiscountPhicOut = 1 NEW Medic_isPWD UPDATE Medic_SavePHICSOA_Senior Medic_SavePHICSOA_Senior_Package VSS VERSION 09/05/2018 DATA ENTRY : Removed updating Packageid/PackageIDSecondary in tbmedactual 09/05/2018 : Revised Medic_LoadPHICPatientInfo; Removed Set Attending as 1st Doctor. Get all doctor from tbmeddoctors with MedicarePF <> 0 09/06/2018 : Added CSF Template 09/06/2018 : Added Condition in Medic_SaveActualComputation_New_Package : if senior/pwd, round-off to 2 dec. + 0.01 09/06/2018 : Revised SOA_Summarized_Columns_PHIC_New_Split.rpt; round off 1st and 2nd caserate Amount due to .01 issues of Senior Patients- (CHDG only) NKTI VERSION 09/06/2018 FORM 1 ENTRY : Removed Saving validation if PIN is blank. LMC Version 09/10/2018 : Revised Medic_SaveMemberInfo; Added MemberSex, : Created Medic_SavePatientPIN PxPIN, PxPHICType, PxAdmPHICType MJSH/Adventist/MRXH 09/20/2018 Auto-Comp Win : removed condition Clientname = "MSH"(difference is the NET Of Disc for ActualPF; just added to SP) : Medic_GetDoctorPF: alter Actual PF to Net of DIscount if Clientname = "MSH" LMC Version 06/05/2018 Fixe/s: 1. Count Consumed days >include REPLACE(@MemberNumber, '-', '') LMC 04/12/2018 : Include VAT for HCI, PF in CF2 : SOA Complete Version 3 (VAT) - Preprinted MedicRep_PartIII Part3And4ACR.rpt LMC 02/23/2018 Exclude TBDOTS patient from the ff reports: >Total Receivable >List Of Untransmitted BASIS: Patients with RVS code 89221 Directly Observed Treatment Short-course; intensive phase 89222 Directly Observed Treatment Short-course; maintenance phase MedicRep_TotalReceivable MedicRep_TotalReceivable_All sp_Medicare_NotYetTransmitted sp_Medicare_NotYetTransmittedOutpatient Allah Valley 01/10/2018 ADJUSTMENTS 1. Includes tagging of rvs codes or procedural/surgical cases for first and second case 2. Unified searching of caserates (Medical and Surgical Cases) 3. Additional saving of data in Auto-Computation for the splitting computation requirements 4. Automatic allocation of maximum allowance base on the actual case rate, if hospital charges is less than the PHIC caserate allowance. /*****TABLE EQUIVALENT TO ALLAH VALLEY DBASE*****/ MEDICARE..tbMedCaseRates = MEDICARE..tbmed_MedicalCaserates MEDICARE..tbMedRVSCaseRates = MEDICARE..tbmed_procedures ****note: Don't use MEDICARE..tbmedPackage MEDICARE..tbmedActual FirstICDRVS = ICDCodeCase1 SecondICDRVS = ICDCodeCase2 PackageID = PackageID PackageIDSecondary = PackageID2 FirstICDRVSAmount = FirstICDRVSAmount SecondICDRVSAmount = SecondICDRVSAmount Allah Valley 09/18/2017 : ReceivableUnpaid.rpt : MedicRep_ReceivableUnPaid NKTI 06/29/2017 1. Claim Form 2( Front & Back Part) Request Type: New • Diagnosis • Diagnosis - Preprinted • PxName • PxName - Preprinted Request Type: Modification • CF2 Part 3 and 4 NKTI 07/12/2017 1. Data Entry (Final Diagnosis, Doctors) Request Type: Modification Implementation Date: September 30, 2017 1. Auto-Computation Request Type: Modification • Split case rates 2. New report SOA Request Type: Modification/New NKTI 03/20/2017 1. Claim Form 2 for HEMO ( Front & Back Part) Request Type: Modification • NewClaimForm2ACR.rpt • Part3And4ACR.rpt • Medic_SavePostedDataNew.sql • MedicRep_PartIII.sql LMC 05/31/2016 1. PBEF(Philhealth Benefit Eligibility Form) for Transmittal Report - additional feature - New report - Additional tagging 2. Payment Allocation of Professional Fees (connected to Accounting Module) - additional feature -Auto-Computation of VAT, TaxablePF, Tax, NET 3. Confinement History (Discharge date with different year) - fixed 4. Mandatory Report (New Format) 5. Payment Summary Detailed (New Report) -(Inpatient, Outpatient, Hemo and ALL) 6. NewClaimForm2ACR (Edit Report) 7. OPDPayments(Edit Report) 8. Summary Of Activities For The Month (fix) 9. Process Performance Report (fix) 10. Payment Register With Date Range (Additional Reports) -By Member, All -By OR, All 11. Validation of Doctor's Accreditation Number and Expiration period on Claim Form 1 Entry 12. Validation of Entries on Claim Form 2 Entry (Final Diagnosis) -restrict if incomplete/blank fields 13. Build File of Case Rates (connected with Build File Module) 14. Additional reports for all and HMO list of untransmitted Claims 15. special report ---> underpaid, unpaid (fix) 16. Receivable report not balance in underpaid (fix) 17. PhilHealth Extends Dialysis Coverage to 90 Days