USPS Reports Guide –
USPS Reports by Number –
Report 856 "Out Of State Employees"
The report will be generated for only those agencies that have employees working out of state. The report will include all employees whose residence state is other than 44 or whose state or local tax does not = 0 (this will insure report will include negatives and positives). The agency can access the report on HNKPA by entering a Y next to Report 856.
Note: The agency can also submit an LOA to set the report up on the HPRPT to be received with month-end reports. If the report is not run before quarter clears, it cannot be re-run for that quarter.
This report will display the residential state, employee name, social security number, organization code, work state, state in which employee lives, residential city, state taxable, local taxable, state taxes, local taxes and the total of the taxes.
If an employee has local taxes, the report will generate a second report for that employee with a column for Local (LC), and the MTD, QTD and YTD columns will be named LOCAL.
Report Criteria
Category | Payroll |
---|---|
Distribution | Agency |
Frequency | Upon Request |
Form | |
Sort Sequence | Automatic on State, Alpha |
Page Break & Total | No options. |
Parameters | HNKPA |
Databases Used | HID, H0B, HNH, H0A |
Selection Criteria | All employees whose residence state is other than 44 or State or local taxes are greater than 0. |
Produce Output? | Yes – Report |
Request Screen | HNKPA |
Posting Report? | No |
Additional Notes | IF LOCAL TAXES EXIST (After report is printed for states, then print additional report broken out by local code). There will be an additional column (LC) and the column headers will display as 'local' instead of 'state'. Also the As of Date of the Report = the H0IO1 (system date). |
Report Headings – State
Column One
- TAX ST H0A.STATE CD
- This field displays the state where the employee is taxed.
Example: 3-AR
Column Two
- NAME HID.RPTNAME
- This field displays the employee's name.
- RES CITY/ST HID.CITY/STATE
- This field displays the employee's city and state in which he/she resides as displayed from (INDIVIDUAL IDENTIFICATION) when report ran.
Column Three
- SSN H0B.EMPLOYEENO
- This field displays the employee's social security number.
- ORG CD HNH.ORG CODE
- This field displays the employee's organization code.
Column Four
- WK ST H0B.1ST WORK STATE
- This field displays the employee's state in which he/she works.
Example: 44
Column Five
- SUI ST H0B.SUI ST
- This field displays the employee's state in which he/she receives (SUI) state.
- UNEMPLOYMENT INSURANCE
- Example: 44
Column Six
- M-T-D ST TX H0A,MSIT
- This field displays the employee's month to date state tax.
Column Seven
- M-TXBL STATE H0A,MSITTXBL
- This field displays the employee's month to date state taxable amount.
Column Eight
- Q-T-D ST TX H0A,QSITTXBL
- This field displays the employee's quarter to date state tax.
Column Nine
- Q-TXBL STATE H0A,QSIT
- This field displays the employee's quarter to date state taxable amount.
Column Ten
- Y-T-D ST TAX H0A,YSIT
- This field displays the employee's year to date state tax.
Column Eleven
- Y-TAXBL STATE H0A,YSITTXBL
- This field displays the employee's year to date state taxable amount.
Report Criteria – Local
Column One
- TAX ST H0A.STATE CD
- This field displays the state where the employee is taxed.
Example: 3-AR
Column Two
- LC H0A,LOCALCODE
- This field displays the code for the employee's local taxing entity.
Example: 4
Column Three
- NAME HID.RPTNAME
- This field displays the employee's name.
- RES CITY HID.CITY/STATE
- This field displays the employee's city and state in which he/she resides.
As displayed from HIDU1 (INDIVIDUAL IDENTIFICATION) when the report ran.
Column Four
- SSN H0B.EMPLOYEENO
- This field displays the employee's social security number.
- ORG CD HNH.ORG CODE
- This field displays the employee's organization code.
Column Five
- WK ST H0B.1ST WORK STATE
- This field displays the employee's state in which he/she works.
Example: 33
Column Six
- SUI ST H0B.SUI ST
- This field displays the employee's state in which he/she receives (SUI) state.
- UNEMPLOYMENT INSURANCE
- Example: 33
Column Seven
- M-T-D LC TX H0A,MLOCAL
- This field displays the employee's month to date local tax.
Column Eight
- M-TXBL LOCAL H0A,MLOCALTXBL
- This field displays the employee's month to date local taxable amount.
Column Nine
- Q-T-D LC TX H0A,QLOCAL
- This field displays the employee's month to date local taxable amount.
Column Ten
- Q-TXBL LOCAL H0A,QLOCALTXBL
- This field displays the employee's quarter to date local taxable amount.
Column Eleven
- Y-T-D LC TX H0A,YLOCAL
- This field displays the employee's year to date local tax.
Column Twelve
- Y-TXBL LOCAL H0A,YLOCALTXBL
- This field displays the employee's year to date local tax.
Sample Report
REPORT: 856 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1 AGENCY: 444 TEXAS DEPARTMENT OF TRAINING AND REPORTS RUN DATE: XX/XX/20XX OUT OF STATE TAX REPORT RUN TIME: 02:03:38 AS OF 03/14/20XX TAX NAME SSN WK SUI M-T-D M-TXBL Q-T-D Q-TXBL Y-T-D Y-TXBL ST RES CITY, ST ORG CD ST ST ST TX STATE ST TX STATE ST TX STATE 04-AR XXX, XXXXX X XXX-XX-XXXX TX TX 124.67 2745.25 374.01 8235.75 374.01 8235.75 TEXARKANA, AR 01973200000 XXXXXX, XXXXXXX XXX-XX-XXXX TX TX 140.00 2964.33 420.00 8892.99 420.00 8892.99 DODDRIDGE, AR 01909500000 XXXXXX, XXXXXXXXXX XXX-XX-XXXX TX TX 0.00 95.69 4.80 1364.29 4.80 1364.29 TEXARKANA, AR 05698900000 XXXXXX, XXXXXXX X XXX-XX-XXXX TX TX 83.89 2148.22 251.67 6444.66 251.67 6444.66 XXXXX, AR 05658900000 XXXX, XXXXXXX XXX-XX-XXXX TX TX 87.96 2216.00 263.88 6648.00 263.88 6648.00 ASHDOWN, AR 01940900000 TOTAL 436.52 10169.49 1314.36 31585.69 1314.36 31585.69