USPS Reports Guide –
USPS Reports by Number –
Report 993 Employee Insurance Information
This report displays insurance information for all active, leave without pay (LWOP) and terminated employees. It can be set up as a month end report on HPRPT or requested as needed on HNKBA for the current or prior period.
Employees with a "NO" on HMTU1, that have declined or canceled insurance, will be listed separately at the end of each organization code; or if report is sorted by employee, at the end of the report.
Report Criteria
| Category | Benefits Administration | ||||||
|---|---|---|---|---|---|---|---|
| Distribution | Agency | ||||||
| Frequency | Monthly; Upon Request | ||||||
| Form | 111 | ||||||
| Sort Sequence |
|
||||||
| Page Break | Organization Code (if organization sort) | ||||||
| Parameters | HNKBA – START DATE, END DATE | ||||||
| Databases Used | H0B, HMT, HNK | ||||||
| Selection Criteria | All active, LWOP and terminated employees on USPS. The report uses the last HMT record whose effective date does not exceed the HNKBA end date. | ||||||
| Produce Output? | Yes | ||||||
| Request Screen | HNKBA HPRPT – Set up to run automatically with month end reports (set value on HPRPT to 3 for org sort; 4 for employee sort). |
||||||
| Posting Report? | No | ||||||
| Additional Notes | Month end set-up on HPRPT will use the end of the current payroll month as the end date. |
Report Headings
- EMPLOYEE NAME HID.RPTNAME
- Displays the employee’s name.
- TOB PREM
- Description header for LVL/AMT directly below.
- VI PL HMT.FORMCD03
- Displays the employer vision plan.
- LV HMT.VISNLVLCD
- Displays the vision level.
- EMP.SSN H0B.EMPLOYEENO
- Displays the employee’s SSN.
- FSA HEALTH HMT.TFHLTHAMT
- Displays the amount to be deducted for the Health Care Reimbursement Account.
- FSA DAY CARE HMT.TFDEPMNAMT
- Displays the amount to be deducted for the Dependent Care Reimbursement.
- LMTD FLEX
- Displays the employee’s limited flexible spending account to be deducted.
- EMP HSA
- Displays the amount to be deducted for the employee’s health savings account.
- ST HSA
- Displays the amount to be deducted for the state’s paid health savings account.
- PC HMT.TFREDIRCD
- Displays the employee’s premium conversion indicator.
- HL HMT.HLTHCARECD
- Displays the employee’s health insurance carrier code.
- LV HMT.HLTHLVLCD
- Displays the health insurance level.
- PREM HMT.HLTHEEAMT
- Displays the employee’s cost for the health plan.
- STPD HMT.HLTHERAMT
- Displays the state paid contribution of the employee’s insurance.
- LVL HMT.TBDIFLVL
- Displays the employee’s coverage level for the tobacco user premium differential.
- AMT HMT.TBDIFAMT
- Displays the employee’s cost for the tobacco user premium differential.
- DN-PL HMT.DNTLCARECD
- Displays the employee’s dental insurance carrier code.
- LV HMT.DNTLLVLCD
- Displays the dental insurance level.
- PREM HMT.DNTLEEAMT
- Displays the employee’s cost for the dental plan.
- OPTL-ELE HMT.OPTLIFECVG
- Displays the employee’s level of optional term life insurance coverage.
- COV HMT.OPTLCVGAMT
- Displays the amount of the employee’s optional term life insurance coverage.
- PREM HMT.OPLFEEAMT
- Displays the employee’s cost for optional term life insurance.
- DEP HMT.DEPLIFECVG
- Displays the level of employee’s dependent life insurance coverage.
- PREM HMT.DPLFEEAMT
- Displays the employee’s cost for dependent term life insurance.
- AD&D-CD HMT.ADDLVLCD
- Displays a value indicating the employee’s voluntary accidental death and dismemberment coverage.
- AMT HMT.CVGAM
- Displays the amount of the employee’s voluntary accidental death and dismemberment coverage in thousands.
- PREM HMT.ADDEEAMT
- Displays the employee’s cost for voluntary accidental death and dismemberment coverage.
- DIS-LV HMT.DISLEVEL, HMT.DISTLEVEL
- Displays a value for the employee’s disability insurance coverage.
- PREM HMT,DISYEEAMT, HMT.DISLTEEAMT
- Displays the employee’s cost for short term and/or long term disability insurance.
- EMP PREM XXXTOTEMPCOST
- Displays the employee’s total cost for insurance coverage.
Sample Report
REPORT: 993 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1
AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXX RUN DATE: 08/17/20XX
00000600200 EMPLOYEE INSURANCE INFORMATION RUN TIME: 08:19:54
AS OF 12/31/20XX
EMPLOYEE NAME TOB PREM VI-PL/LV/ PREM EMP. SSN FSA HEALTH FSA DAY CARE LMTD FLEX EMP HSA ST HSA
PC HL/LV/ PREM/ STPD LVL/ AMT DN-PL/LV/ PREM OPTL-ELE/COV/ PREM DEP/ PREM AD&D-CD/AMT/ PREM DIS-LV/ PREM EMP. PREM
XXX, XXXX XXX SP/MO/ 6.69 XXX-XX-XXXX .00 .00 .00 .00 .00
Y HI/MF/ 590.48/1207.78 NO/ .00 DH/MF/ 32.59 E1/ 0/ 15.18 Y / 1.38 NO/ 0/ .00 ST/NO/ 11.40/ .00 657.72
XXXXXXX, XXXXXXXXX X SP/MO/ 6.69 XXX-XX-XXXX 83.00 .00 .00 .00 .00
Y HI/MO/ .00/ 617.30 NO/ .00 DH/MO/ 9.59 E2/ 0/ 4.68 Y / 1.38 MF/200/ 8.00 ST/NO/ 9.56/ .00 39.90
XXXXXXXX, XXXXX XXXX NO/ / .00 XXX-XX-XXXX .00 .00 .00 .00 .00
Y HI/MO/ .00/ 617.30 NO/ .00 DB/MO/ 26.61 E2/ 0/ 7.20 NO/ .00 MO/200/ 4.00 ST/NO/ 11.04/ .00 48.85
XXXXX, XXXXX NO/ / .00 XXX-XX-XXXX .00 .00 .00 .00 .00
Y HI/MO/ .00/ 617.30 NO/ .00 NO/ / .00 E1/ 0/ 7.22 NO/ .00 NO/ 0/ .00 NO/NO/ .00/ .00 7.22
XXXXXXXX, XXXXX X NO/ / .00 XXX-XX-XXXX 20.00 .00 .00 .00 .00
Y HI/MO/ .00/ 617.30 NO/ .00 NO/ / .00 E1/ 0/ 2.28 NO/ .00 MO/ 10/ .20 ST/LT/ 9.32/ 19.57 31.37
XXXXXX, XXXXXX X NO/ / .00 XXX-XX-XXXX .00 .00 .00 .00 .00
Y HI/MC/ 236.80/ 854.10 NO/ .00 DB/MC/ 63.86 E2/ 0/ 4.56 Y / 1.38 NO/ 0/ .00 NO/NO/ .00/ .00 306.60
XXXXX, XXXXX X SP/MO/ 6.69 XXX-XX-XXXX .00 .00 25.00 200.00 90.00
Y CH/MC/ .00/ 90.00 NO/ .00 DB/MC/ 56.60 NO/ 0/ .00 NO/ .00 MO/200/ 4.00 NO/NO/ .00/ .00 267.29