Skip to content
Breadcrumbs

USPS Reports Guide –
USPS Reports by Number –
Report 184 Texas Protects Detail Report

This report displays all payroll deductions for the Texas Protects Permanent Life Insurance plan.

Report Criteria

Category Payroll Administration
Distribution Agency
Frequency Runs with final payrolls.
Form 111
Sort Sequence
Options H0XCR Sort
Check Date, Document Number, Employee Number 998
Page Break  
Parameters WARRANT DATES
Databases Used H0M, H0C, H0B, H0H, HID
Selection Criteria All employees with an H0M.CURDEDAMT(47) not equal to zero for the current payroll or with warrant dates within the date range specified on HSRPQ.
Produce Output? Yes
Request Screen HSRPQ; HPRPT – Set up to run automatically with each final payroll.
Posting Report? No
Additional Notes Payment is made electronically to Metlife by the Comptroller's office. Send a copy of this report to Metlife to detail the payment.

Report Headings

DOCUMENT H0H.ALPHACONS1
Displays the USAS number assigned to the payroll.
CHECK DATE H0H.CHKDATE
Displays the payment date of the deduction.
EMPLOYEE NO H0B.EMPLOYEENO
Displays the employee's SSN.
EMPLOYEE NAME HID.RPTNAME
Displays the employee's name.
DEDUCT AMT H0M.CURDEDAMT(47)
Displays the amount of the Texas Protects deduction or adjustment.
DOCUMENT TOTAL DERIVED
Displays the total of all deductions or adjustments within this document.
AGENCY TOTAL DERIVED
Displays the total of all deductions or adjustments for the agency.

Sample Report

 REPORT:   184                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:     1    
 AGENCY:   XXX                                   XXXXXXXXXXX XX XXXXXX XXXXXXXX                               RUN DATE: XX/XX/20XX
                                                  TEXAS PROTECTS DETAIL REPORT                                RUN TIME: 22:01:21 
                                                                                                                                 
   DOCUMENT     CHECK DATE     EMPLOYEE NO     EMPLOYEE NAME                                             DEDUCT AMT              
                                                                                                                                 
   84013004     02/01/20XX     XXX-XX-XXXX     XXXX, XXXXXXXXXX                                                  86.10           
                                                                                                                                 
                                               DOCUMENT 86501044 TOTAL                                           86.10           
                                                                                                                                 
                                               AGENCY TOTAL                                                      86.10