1 / 25

The Report

The Texas A&M University System Budget/Payroll/Personnel Operations Center (B/P/P) Insurance Billing Working Error Reports June 2, 2011. Drafts Not Sent (BILL0008 BP7500). The Report

noble-valenzuela
Download Presentation

The Report

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The Texas A&M University SystemBudget/Payroll/PersonnelOperations Center(B/P/P)Insurance BillingWorking Error ReportsJune 2, 2011

  2. Drafts Not Sent (BILL0008 BP7500) The Report DATE: 02/22/2011 TEXAS A&M UNIVERSITY SYSTEM PAGE: 7 P JOB NAME: BILL0008 BUDGET/PAYROLL/PERSONNEL SYSTEM BANK DRAFT REPORT - DRAFTS NOT SENT NAME UIN INVOICE TOTAL BL MED DEN VIS OL ADD LTD DL LTCE LTCS EMPLOYEE NAME 999009999 9999999 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 EMPLOYEE NAME 000000000 0000000 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 Notes May not have banking information filled in. • Invoices are still created, but draft not created.

  3. Drafts Not Sent (BILL0008 BP7500) Research 118 TAMUS B/P/P - Billing Info - Inquiry 05/27/11 09:50 Screen: ___ P BPP0005 R082 UIN: 802002777 Name: EMPLOYEE NAME Bill Status D Bill Addr H Med Carr 05 Den Carr 04 Percent Local Bank Draft Acct Change Date 11 08 2007 Retired From: WrkStn P ADLOC 05117310 Emp-Loc 05117310 Chk-Distr 05110220 Employer Retiree Days FYTD Available Total Amt Due Amt Due Due Past FYTD Paid To Pay Owed Carrier Carrier Date Due Received Carrier CarrierCarrier BL 3.97 06012011 MED 572.13 352.79 06012011 3390.24 3390.24 352.79 DEN 22.16 06012011 199.44 199.44 22.16 VIS OL 51.84 06012011 466.56 466.56 51.84 ADD 4.60 06012011 41.40 41.40 4.60 LTD DL 26.35 06012011 237.15 237.15 26.35 LTCE LTCS Total 576.10 457.74 4334.79 4334.79 457.74 ADDL-MED ADDL-DEN Comment PF1=Help,PF2=Comm,PF3=Exit,PF4=Main,PF5=Prev,PF6=Next,PF11=Right Solution Change Bill Status to blank or value other than D(draft).

  4. Errors for <from> Past Due Process (BILL0006 BP7502-02 ) The Report • BILL0006 PGM BP7502-2 WORK STATION A PAGE 1 • ERROR REPORT - FOR PAST DUE PROCESS -- DUE DATE 02-01-2011 • UIN NAME INVOICE DUE DT PD AMT INV AMT ERROR MESSAGE • UIN HERE EMPLOYEE NAME 0184944 20071001 0.00 0.00 OLDEST DUE DATE NOT = OPTION DUE DT • UIN HERE EMPLOYEE NAME 20071001 73.24 100.08 BALANCE DUE ON PD NOT = INVOICE TOTALS • UIN HERE EMPLOYEE NAME 20071001 73.24 100.08 BILL COVERAGE DATES MAY BE INCORRECT • UIN HERE EMPLOYEE NAME 20110101 0.00 0.00 MED DUE DT NOT = OPTION DUE DT • UIN HERE EMPLOYEE NAME 20110101 0.00 0.00 DEN DUE DT NOT = OPTION DUE DT • UIN HERE EMPLOYEE NAME 20110101 0.00 0.00 VIS DUE DT NOT = OPTION DUE DT • UIN HERE EMPLOYEE NAME 0498716 20110101 0.00 0.00 OLDEST DUE DATE NOT = OPTION DUE DT • UIN HERE EMPLOYEE NAME 20110201 163.01 171.01 BALANCE DUE ON PD NOT = INVOICE TOTALS • UIN HERE EMPLOYEE NAME 20110201 163.01 171.01 BILL COVERAGE DATES MAY BE INCORRECT • Shows invoice and date of invoice that is probably causing past due situation and possible cancellation. • Option Due Date is date for which report is run, shown in title. In this example, due date is 2/1/2011. • Possible problem in current month • Balance due on screen 118 is not the same as the total of all invoices. • Prior invoice still overdue. Shows oldest invoice due and due date of that invoice.

  5. Errors for <from> Past Due Process (BILL0006 BP7502-02 ) The Report • BILL0006 PGM BP7502-2 WORK STATION A • ERROR REPORT - FOR PAST DUE PROCESS -- DUE DATE 05-01-2011 • UIN NAME INVOICE DUE DT PD AMT INV AMT ERROR MESSAGE • 202-00-6722 EMPLOYEE NAME 0496956 20110101 0.00 0.00 OLDEST DUE DATE NOT = OPTION DUE DT • 202-00-6722 EMPLOYEE NAME 20110101 31.88 33.24 BALANCE DUE ON PD NOT = INVOICE TOTALS • 202-00-6722 EMPLOYEE NAME 20110101 31.88 33.24 BILL COVERAGE DATES MAY BE INCORRECT • 301-00-9539 EMPLOYEE NAME 20110401 0.00 0.00 MED DUE DT NOT = OPTION DUE DT • 301-00-9539 EMPLOYEE NAME 20110401 0.00 0.00 ADD DUE DT NOT = OPTION DUE DT • 301-00-9539 EMPLOYEE NAME 20110401 0.00 0.00 DEN DUE DT NOT = OPTION DUE DT • 301-00-9539 EMPLOYEE NAME 20110401 0.00 0.00 VIS DUE DT NOT = OPTION DUE DT

  6. Errors for <from> Past Due Process (BILL0006 BP7502-02 ) • Message 1: Oldest Due Date… • UIN NAME INVOICE DUE DT PD AMT INV AMT ERROR MESSAGE • 202-00-6722 EMPLOYEE NAME 0496956 20110101 0.00 0.00 OLDEST DUE DATE NOT = OPTION DUE DT • Notes • This error looks only for balances due and does not take into consideration any credits. • Reports invoice with oldest due date. • Research 643 TAMUS B/P/P System - Invoice History Screen Screen: ___ UIN: 202006722 Select Line Nbr: 0 Name: EMPLOYEE NAME WS: A Start next with: 09 01 2010 Outstanding Only: _ MM DD YYYY (Enter 'Y' to limit) Select Coverage Line Due-Date-- Month Med Den Balance Nbr Invoice Typ Status MM DD YYYY MM YYYY Comment Carr Carr Due 1 0530327 A Paid 05 01 2011 05 2011 01 2 0521934 A Paid 04 01 2011 04 2011 01 3 0513571 A Printed 03 01 2011 03 2011 01 0.12 looks due 4 0505212 A Credit 02 01 2011 02 2011 01 -0.12 5 0496956 A Printed 01 01 2011 01 2011 01 1.24 looks due, this is the oldest 6 0488712 A Credit 12 01 2010 12 2010 01 -1.12 7 0480389 A Credit 11 01 2010 11 2010 01 -0.12 8 0472081 A Paid 10 01 2010 10 2010 01 9 0463800 A Paid 09 01 2010 09 2010 01 Solution Apply the credits to the offending invoice.

  7. Errors for <from> Past Due Process (BILL0006 BP7502-02 ) • Message 2: Balance on PD not Equal to Invoice Totals • UIN NAME INVOICE DUE DT PD AMT INV AMT ERROR MESSAGE • 202-00-6722 EMPLOYEE NAME 20110101 31.88 33.24 BALANCE DUE ON PD NOT = INVOICE TOTALS • Notes • Message means the balance due on screen 118 is not the same as the total of all invoices. • This error looks at balances due and does not take into consideration any credits. • PD Amt is the amount on screen 118. • INV Amt is the total of the invoices with balances due (not including credits). • Research 118 TAMUS B/P/P - Billing Info - Inquiry Screen: ___ UIN: 202006722 Name: EMPLOYEE NAME Bill Status Bill Addr Med Carr 01 Den Carr 03 Percent Local Bank Draft Retired From: WrkStn A ADLOC 06111222 Emp-Loc 06111222 Chk-Distr 06111222 Employer Retiree Days FYTD Available Total Amt Due Amt Due Due Past FYTD Paid To Pay Owed Carrier Carrier Date Due Received Carrier CarrierCarrier BL 3.97 05012011 MED 387.48 31.88 05012011 191.28 191.28 DEN VIS OL ADD LTD DL LTCE LTCS Total 391.45 31.88 191.28 191.28 ADDL-MED 05 ADDL-DEN Comment

  8. Errors for <from> Past Due Process (BILL0006 BP7502-02 ) Research, cont. 643 TAMUS B/P/P System - Invoice History Screen Screen: ___ UIN: 202006722 Select Line Nbr: 0 Name: EMPLOYEE NAME WS: A Start next with: 09 01 2010 Outstanding Only: _ MM DD YYYY (Enter 'Y' to limit) Select Coverage Line Due-Date-- Month Med Den Balance Nbr Invoice Typ Status MM DD YYYY MM YYYY Comment Carr Carr Due 1 0530327 A Paid 05 01 2011 05 2011 01 31.88 looks due 2 0521934 A Paid 04 01 2011 04 2011 01 3 0513571 A Printed 03 01 2011 03 2011 01 0.12 looks due 4 0505212 A Credit 02 01 2011 02 2011 01 -0.12 5 0496956 A Printed 01 01 2011 01 2011 01 1.24 looks due 6 0488712 A Credit 12 01 2010 12 2010 01 -1.12 7 0480389 A Credit 11 01 2010 11 2010 01 -0.12 8 0472081 A Paid 10 01 2010 10 2010 01 9 0463800 A Paid 09 01 2010 09 2010 01 33.24  Total that looks due Solution Apply the credits to the offending invoice.

  9. Errors for <from> Past Due Process (BILL0006 BP7502-02 ) • Message 3: Bill Coverage Dates may be Incorrect • UIN NAME INVOICE DUE DT PD AMT INV AMT ERROR MESSAGE • 202-00-6722 EMPLOYEE NAME 20110101 31.88 33.24 BILL COVERAGE DATES MAY BE INCORRECT • Notes • Message means this invoice may have incorrect due or coverage dates. The program assumes premiums increase every year. So when the total of all invoices is more than the total on screen 118, that’s a hint the dates on the invoice may have been entered wrong. • Research • We can see from research in the first two messages (above) that this error message is incorrect; the bill dates are fine.

  10. Errors for <from> Past Due Process (BILL0006 BP7502-02 ) • Message 4: Due Date not Equal to Option Due Date • UIN NAME INVOICE DUE DT PD AMT INV AMT ERROR MESSAGE • 301-00-9539 EMPLOYEE NAME 20110401 0.00 0.00 MED DUE DT NOT = OPTION DUE DT • 301-00-9539 EMPLOYEE NAME 20110401 0.00 0.00 ADD DUE DT NOT = OPTION DUE DT • 301-00-9539 EMPLOYEE NAME 20110401 0.00 0.00 DEN DUE DT NOT = OPTION DUE DT • 301-00-9539 EMPLOYEE NAME 20110401 0.00 0.00 VIS DUE DT NOT = OPTION DUE DT • Notes • No Invoice number and no amounts are shown. • These warnings are based on the due dates from screen 106 (shown on 118); not based on any invoices. • Usually occurs when bill for current coverage has been requested and due dates were not updated on 106.

  11. Errors for <from> Past Due Process (BILL0006 BP7502-02 ) Research 106 TAMUS B/P/P - Benefit Maintenance - Inquiry Screen: ___ UIN: 301009539 Name: EMPLOYEE NAME WS: M Status: R SGIP-Rate F SGIP-Dt 06181998 GS-Sup PreTaxWaiveTob N Ben-Salary 29002 D P P C F Certified-other-med OL-Salary 29002 Ins e t l a a Cover Deduct Payment Start Due Change Stop d y n r m Amount AmountAmount Date DateDateDate BL W 1 7500 01172002 04012011 04012011 99999999 MED R 2 1 05 E 1 107.43 391.45 02012002 04012011 04012011 99999999 DEN R N 1 03 E 1 29.41 02012002 04012011 04012011 99999999 VIS R N E 1 6.39 09012002 04012011 04012011 99999999 OL W 5 145000 02012002 04012011 04012011 99999999 DL Spouse Children ADD R N 1 E 150000 4.20 02012002 04012011 04012011 99999999 LTD N N 02012002 04012011 04012011 03312011 LTCE LTCS SAHC 0 SADC 0 Direct-DepMedCr ABO LWOP-Start-Date FMLA-Start-Date Comments Dis ret efft 3-31-11 PF1=Help,PF2=Comm,PF3=Exit,PF4=Main,PF5=Prev,PF6=Next Remember, this report example is for May coverage due May 1, hence it expected to see due dates of 05/01. At the time this report ran the due date was 04/01. Solution Sometimes no action is needed. Must review the billing calendar and person’s payment. This sometimes occurs when a bill is requested for a new retiree or when reinstating coverage. Retirees pay for the coming month’s coverage, whereas employees pay for the current month’s coverage. If bills have been automatically created for the coming month and you create a bill (or two)for a retiree, you may need to update the due dates on screen 106. Always check the due dates of a person current on the billing.

  12. Errors for <from> Cancellation Process (BILL0009 BP7512-02 ) The Report DATE: 05/16/2011 TEXAS A&M UNIVERSITY SYSTEM BILL0009 PROGRAM: BP7512 -02 BUDGET/PAYROLL/PERSONNEL SYSTEM CAUTION REPORT FOR CANCELLATION PROCESS - DUE DATE 05-01-2011 NAME UIN INVOICE DUE DATE PD AMT INV AMT MESSAGE Employee Name 501 00 7451 0488740 12-01-2010 0.00 0.00 OLDEST DUE DATE NOT = OPTION DUE DATE 12-01-2010 61.29 62.49 BALANCE DUE ON PD NOT = INVOICE TOTALS Employee Name 601 00 7867 0505251 02-01-2011 0.00 0.00 OLDEST DUE DATE NOT = OPTION DUE DATE 02-01-2011 171.01 179.01 BALANCE DUE ON PD NOT = INVOICE TOTALS Employee Name 221 00 3163 07-01-2011 0.00 0.00 VIS DUE DATE AFTER OPTION DUE DATE Notes Most errors same as from Past Due Process (refer to BILL0006 BP7502-02).

  13. Errors for <from> Cancellation Process (BILL0009 BP7512-02 ) • Message: … DUE DATE AFTER OPTION DUE DATE • NAME UIN INVOICE DUE DATE PD AMT INV AMT MESSAGE • EMPLOYEE NAME 221 00 3163 07-01-2011 0.00 0.00 VIS DUE DATE AFTER OPTION DUE DATE • Notes • This error reported based on due dates from screen 106 (shown on 118) • Warns of future due dates • Research 106 TAMUS B/P/P - Benefit Maintenance - Inquiry 05/26/11 16:09 Screen: ___ P BPP0005 R165 UIN: 221003163 Name: EMPLOYEE NAME WS: H Status: L SGIP-Rate F SGIP-Dt 01012011 GS-Sup PreTaxWaiveTob Y Ben-Salary D P P C F Certified-other-med OL-Salary Ins e t l a a Cover Deduct Payment Start Due Change Stop d y n r m Amount AmountAmount Date DateDateDate BL M 1 7500 3.97 10012010 06012011 10012010 99999999 MED M 2 1 01 E 1 90.69 387.48 10012010 06012011 10012010 99999999 DEN M N 1 03 E 1 29.41 10012010 06012011 10012010 99999999 VIS M N E 1 6.39 10012010 07012011 10012010 99999999 OL DL Spouse Children ADD LTD LTCE LTCS SAHC N 11 550.00 10012010 10012010 10012010 10012010 SADC 0 Direct-DepMedCr ABO LWOP-Start-Date 09102010 FMLA-Start-Date 09102010 Comments Screen 106 Values Updated by Userid K139PL Solution This is usually due to a typo or misunderstanding of due dates. Correct the due date.

  14. Caution Report – Billing Month-End (BILL0007 BP7504-03 ) • The Report • DATE: 05/19/2011 TEXAS A&M UNIVERSITY SYSTEM • BILL0007 PROGRAM: BP7504-03 BUDGET/PAYROLL/PERSONNEL SYSTEM • CAUTION REPORT - BILLING MONTH-END -- PERIOD ENDING 05-31-2011 • UIN NAME INS TYPE ERROR MESSAGE PREM ON BE AMT TO PAY • 401-00-7588 EMPLOYEE NAME MED NO MED CARRIER-CORRECT 106 .00 .00 • 701-00-6484 EMPLOYEE NAME MED NOT PAID-ADDL CARR BLANK 182.72 .00 • 401-00-7420 EMPLOYEE NAME DEN DEN AMT PAID NOT = PREMIUM .00 147.05- • 501-00-7451 EMPLOYEE NAME MED MED AMT PAID NOT = PREMIUM 31.88 95.64 • 501-00-7451 EMPLOYEE NAME MED MED EMPR AMT NOT = BE EMPR 387.48 1,162.44 • 702-00-0304 EMPLOYEE NAME BL BL EMPR AMT NOT = BE EMPR .00 3.97 • Notes • NO … CARRIER is also referred to as “blank carrier”. • PREM ON BE is deduct amount on screen 106. • AMT TO PAY is the amount from screen 118 • PREMIUM is the current employee deduct amount from screen 106. • BE EMPR is the employer payment amount from screen 106.

  15. Caution Report – Billing Month-End (BILL0007 BP7504-03 ) Message 1: NO … CARRIER-CORRECT 106 UIN NAME INS TYPE ERROR MESSAGE PREM ON BE AMT TO PAY 401-00-7588 Employee Name MED NO MED CARRIER-CORRECT 106 .00 .00 Notes Payments are not processed and sent thru if it seems payment might be refunded. When the deduct code on screen 106 is off (an N), processing assumes any payments are for the coming month and no money need be sent since the person’s coverage ended this month or earlier. Research 118 TAMUS B/P/P - Billing Info - Inquiry 05/24/11 16:08 Screen: ___ P BPP0005 R122 UIN: 401007588 Name: EMPLOYEE NAME Bill Status D Bill Addr Med Carr Den Carr Percent Local Bank Draft C 000000000 Acct 0000000000 Change Date 05 06 2011 Retired From: WrkStn I ADLOC 15320011 Emp-Loc 15320011 Chk-Distr 15100000 Employer Retiree Days FYTD Available Total Amt Due Amt Due Due Past FYTD Paid To Pay Owed Carrier Carrier Date Due Received Carrier CarrierCarrier BL MED 341.56 14.07 14.07 14.07 DEN 06012011 VIS Solution Turn deduct code on so money will flow thru to vendor.

  16. Message 2: NOT PAID-ADDL CARR BLANK UIN NAME INS TYPE ERROR MESSAGE PREM ON BE AMT TO PAY 701-00-6484 EMPLOYEE NAME MED NOT PAID-ADDL CARR BLANK 182.72 .00 Notes Since no carrier is shown w/the additional med payment on screen 118, we don’t know to which vendor to send payment. Research 118 TAMUS B/P/P - Billing Info - Inquiry 05/24/11 16:15 Screen: ___ P BPP0005 R122 UIN: 701006484 Name: EMPLOYEE NAME Bill Status D Bill Addr Med Carr Den Carr Percent Local Bank Draft C Acct Change Date 01 30 2008 Retired From: WrkStn I ADLOC 15120023 Emp-Loc 15170700 Chk-Distr 15120023 Employer Retiree Days FYTD Available Total Amt Due Amt Due Due Past FYTD Paid To Pay Owed Carrier Carrier Date Due Received Carrier CarrierCarrier BL 06012011 MED 06012011 1644.48 1644.48 DEN 09012010 VIS 09012010 OL 06012011 388.80 388.80 ADD 06012011 62.10 62.10 LTD DL 06012011 324.00 324.00 LTCE LTCS Total 2419.38 2419.38 ADDL-MED 182.72 ADDL-DEN Comment Solution Find the offending invoice and remove amount. Then create new invoice w/proper carrier and indicate this amount. You may want to move the receipt from the offending invoice to the new one. Caution Report – Billing Month-End (BILL0007 BP7504-03 )

  17. Caution Report – Billing Month-End (BILL0007 BP7504-03 ) • Message 3: … AMT PAID NOT = PREMIUM • UIN NAME INS TYPE ERROR MESSAGE PREM ON BE AMT TO PAY • 401-00-7420 EMPLOYEE NAME DEN DEN AMT PAID NOT = PREMIUM .00 147.05- • Notes • This is a warning that the employee portion of the amount sent thru to the vendor (amount that was on screen 118) was not equal to the amount of the employee portion shown on screen 106. • Since the amount in this example is negative, we know it was a credit to the employee/retiree that resulted from an adjustment a processor entered. • Solution • The amount was sent to the vendor. No action needed unless the action was unexpected.

  18. Caution Report – Billing Month-End (BILL0007 BP7504-03 ) • Message 4: … EMPR AMT NOT = BE EMPR • UIN NAME INS TYPE ERROR MESSAGE PREM ON BE AMT TO PAY • 702-00-0304 EMPLOYEE NAME BL BL EMPR AMT NOT = BE EMPR .00 3.97 • Notes • This is a warning that the employer portion (SGIP) of the amount sent thru to the vendor (amount that was on screen 118) was not equal to the amount of the employer portion (SGIP) shown on screen 106. • Since the amount in this example from screen 106 is zero, it’s possible this person was not getting SGIP. • Solution • The amount was sent to the vendor. If this person was not to receive SGIP, then the offending invoice(s) would need to be adjusted so money would return from the vendor.

  19. PRTY CODE, PREMIUM UPDATE FOR EMP REACHING SGIP ELIG DATE (BILL0015 BP7005N) • The Report • Date: 05/24/2011 THE TEXAS A&M UNIVERSITY SYSTEM - B/P/P SYSTEM • BILL0015 BP7005N PRTY CODE, PREMIUM UPDATE FOR EMP REACHING SGIP ELIG DATE • SGIP SGIP CERT SGIP • UIN NAME DATE ELIG OTHR RATE ERROR MESSAGE • --------- ------------------- ---------- ---- ---- ---- ------------------------------------------------------ • 620009759 Employee Name 01-01-2011 2 Y F • --> LTD PRTY N MAY NEED MANUAL UPDATE • 620002793 Employee Name 06-01-2011 2 F • NO BL UPDATE, DUE DATE 05-01-2011 PRIOR TO SGIP DATE • NO DEN UPDATE, DUE DATE 05-01-2011 PRIOR TO SGIP DATE • NO MED UPDATE, DUE DATE 05-01-2011 PRIOR TO SGIP DATE • Notes • You must take action, since the person listed and the message shown will not appear on any other report. • SGIP date has been reached so premiums and priority codes have been updated.

  20. PRTY CODE, PREMIUM UPDATE FOR EMP REACHING SGIP ELIG DATE (BILL0015 BP7005N) Message 1: --> LTD PRTY N MAY NEED MANUAL UPDATE SGIP SGIP CERT SGIP UIN NAME DATE ELIG OTHR RATE ERROR MESSAGE --------- ------------------------ ---------- ---- ---- ---- ------------------------------------------ 620009759 Employee Name 01-01-2011 2 Y F --> LTD PRTY N MAY NEED MANUAL UPDATE Notes As the message states, LTD priority code may need updating. It’s currently an N but the employee may want a 6 (meaning use SGIP for the premium). Research Check submissions from the employee, either in iBenefits or on paper forms. Solution You must take action, since this will not be reported elsewhere. If the employee wanted SGIP applied to LTD premiums, update the priority for LTD on screen 106 to 6.

  21. PRTY CODE, PREMIUM UPDATE FOR EMP REACHING SGIP ELIG DATE (BILL0015 BP7005N) • Message 2: NO … UPDATE, DUE DATE … PRIOR TO SGIP DATE • SGIP SGIP CERT SGIP • UIN NAME DATE ELIG OTHR RATE ERROR MESSAGE • --------- ------------------- ---------- ---- ---- ---- ------------------------------------------------------ • 620002793 Employee Name 06-01-2011 2 F • NO BL UPDATE, DUE DATE 05-01-2011 PRIOR TO SGIP DATE • NO MED UPDATE, DUE DATE 05-01-2011 PRIOR TO SGIP DATE • NO DEN UPDATE, DUE DATE 05-01-2011 PRIOR TO SGIP DATE • Notes • You probably won’t see these messages (from BILL00015). • This message means the employer portion (SGIP) was not applied on screen 106, so the full premium amount is shown as the employee/retiree’s deduction amount. The SGIP wasn’t applied since it appears the person’s payments are not up to date. • Any invoices created for the coming month’s coverage are probably incorrect, since deduct amounts on screen 106 are incorrect.

  22. PRTY CODE, PREMIUM UPDATE FOR EMP REACHING SGIP ELIG DATE (BILL0015 BP7005N) • Research • 106 TAMUS B/P/P - Benefit Maintenance - Inquiry • Screen: ___ • UIN: 620002793 Name: Employee Name WS: H Status: A • SGIP-Rate F SGIP-Dt 06012011 GS-Sup PreTaxWaiveTob N Ben-Salary 37000 • D P P C F Certified-other-med OL-Salary 37000 • Ins e t l a a Cover Deduct Payment Start Due Change Stop • d y n r m Amount AmountAmount Date DateDateDate • BL 2 1 7500 3.97 03012011 05012011 03012011 99999999 • MED 2 2 1 01 E 1 478.17 03012011 05012011 03012011 99999999 • DEN 2 N 1 03 E 1 29.41 04012011 05012011 04012011 99999999 • VIS • OL • DL • Spouse Children • ADD • LTD • LTCE • LTCS • SAHC 0 • SADC 0 • Direct-DepMedCr ABO LWOP-Start-Date FMLA-Start-Date • Solution • You must take action, since this will not be reported elsewhere. Actions might include: • Updating due date, if person has paid in full for what’s currently due • Create any past invoices needed for past coverage not paid • Correct invoices, being sure SGIP and premiums have been adjusted (if after the SGIP date)

  23. Errors in updating insurance coverage because of stop date (BILL0015 BP8049N ) • The Report • Date: 05/24/2011 THE TEXAS A&M UNIVERSITY SYSTEM • BILL0015 BP8049N - 02 BUDGET/PAYROLL/PERSONNEL SYSTEM • Errors in updating insurance coverage because of stop date • Due Stop • Name UIN Ins Date Date • ______________________________ _________ ____ ________ ________ • Employee Name 511005931 BL 04012011 05312011 • MED 04012011 05312011 • DEN 04012011 05312011 • Employee Name 920005543 MED 05152011 05312011 • Notes • Might not get any errors. • Coverage is still turned off. • Due date earlier than stop date means person probably owes premiums. • Terminated persons paid biweekly often show here w/due dates of the 15th.

  24. Errors in updating insurance coverage because of stop date (BILL0015 BP8049N ) Research 757 TAMUS B/P/P - Benefit History - Status As Of Date Listed 05/27/11 14:19 Screen: ___ UIN: 511005931 As Of: 05 24 2011 18:03:24 P BPP0005 R082 Name: Employee Name LCD: 05 24 2011 18:03:24 WS: A Status: T SGIP-Rate SGIP-Dt GS-Sup PreTaxWaiveTob N Ben-Sal 15000 D P P C F SGIP-Elig N Cert-othr OL-Sal 15000 Ins e t l a a Cover Deduct Payment Start Due Change Stop d y n r m Amount AmountAmount Date DateDateDate BL N N 10012009 04012011 06012011 05312011 MED N N 1 03 10012009 04012011 06012011 05312011 DEN N N 1 03 E 10012009 04012011 06012011 05312011 Solution In this case, since the person didn’t pay their premiums, stop date was set to end of month last for which the premium was received. 757 TAMUS B/P/P - Benefit History - Status As Of Date Listed 05/27/11 14:16 Screen: ___ UIN: 511005931 As Of: 05 26 2011 10:19:28 P BPP0005 R082 Name: Employee Name LCD: 05 26 2011 10:19:28 WS: A Status: T SGIP-Rate SGIP-Dt GS-Sup PreTaxWaiveTob N Ben-Sal 15000 D P P C F SGIP-Elig N Cert-othr OL-Sal 15000 Ins e t l a a Cover Deduct Payment Start Due Change Stop d y n r m Amount AmountAmount Date DateDateDate BL N N 10012009 04012011 04012011 03312011 MED N N 1 03 10012009 04012011 04012011 03312011 DEN N N 1 03 E 10012009 04012011 04012011 03312011 VIS OL DL Comments insur ended 3/31/11 due to non-payment

  25. Errors in updating insurance coverage because of stop date (BILL0015 BP8049N ) Solution, cont. In this case, since the person didn’t pay the second half of their premiums, stop date was set to end of month last for which the premium was received, and refund given. 106 TAMUS B/P/P - Benefit Maintenance - Inquiry 05/27/11 14:26 Screen: ___ P BPP0005 R082 UIN: 920005543 Name: Employee Name WS: M Status: T SGIP-Rate SGIP-Dt GS-Sup PreTaxWaiveTob S Ben-Salary 28585 D P P C F Certified-other-med OL-Salary 28585 Ins e t l a a Cover Deduct Payment Start Due Change Stop d y n r m Amount AmountAmount Date DateDateDate BL N N 7500 01012010 05012011 05012011 04302011 MED N N 1 01 01012010 05012011 05012011 04302011 DEN Comments EE refused to pay 2nd 1/2 of May prem. refund and rolled end date back

More Related