Skip to content

USPS Reports Guide
USPS Reports by Number

Report 163 Employee Profile – TAD

This report displays data pertaining to an employee's job assignment, salary, tax withholding and individual information including the employee's home address, and telephone number. It can be used as a turn around document (TAD) for employees to verify current data and report any needed changes, such as their address. This report displays information for each position number the employee is assigned to. Additionally, the latest assignment information for each position number that the employee has ever filled is also displayed.

Report Criteria

Category Personnel Management
Distribution Agency
Frequency Upon Request
Form 111
Sort Sequence
Options H0XCR Sort
Employee Name 864
Page Break Employee
Parameters  
Databases Used H0C, HMP, H7O, HO0, HID, HN8, H0B, HNP, HNJ, HML
Selection Criteria All active employees.
Produce Output? Yes
Request Screen HSRPT
Posting Report? No
Additional Notes  

Report Headings

EMPLOYEE NAME HID.RPTNAME
Displays the employee's name.
EMPLOYEE SSN H0B.EMPLOYEENO
Displays the employee's SSN.
EMPLOYEE ADDRESS HIDU1
Displays the employee's address.
COUNTY HID.COUNTYCODE
Displays the county code in which the employee resides.
PH HID.HOMEPHONE
Displays the employee's home telephone number.
BIRTH DATE HID.BIRTHDATE
Displays the employee's birth date.
MARITAL STATUS H0B.MSTATUS
Displays the employee's marital status. It is used to calculate FIT.
1Single
2Married
NO OF DEP H0B.FITNOEXEMP
Displays the total number of dependents claimed by the employee for FIT purposes.
EMPLOYMENT DATE H0B.EMPLOYDATE
Displays the employee's hire date.
LWOP MNTHS HN8.LWOPMO
Displays the total leave without pay months for prior state service only. Leave without pay for the current employment period is not included.
EFF SERV BEGIN DATE H0B.ADJEMPLDAT
Displays the actual adjusted employment date after LWOP-months deduction and break-in-service deductions.
PRIOR SERVICE MONTHS DERIVED
Displays the number of months of prior state service.
LOC/EXT CODE HNP.PLANTLOC/HNP.EXLOCCD
Displays the five-digit agency-defined code used to identify an agency's physical location and an agency's extended location.
WORK ADDRESS HNJU1
Displays the employee's work address, based on the assigned work location code.
COUNTY HNJ.PCCOUNTY
Displays the employee's work county code based on the location code.
PH BUSPHONE
Displays the employee's work telephone number.
JOB TITLE HML.FCTITLE, HNP.JOBDESC
Displays the budgeted functional job class title that corresponds to the employee's position(s). If no functional job class was assigned, the job class title will display.
JOB CLASS HNP.JOBCLASS
Displays the budgeted job class code for the assigned position.
SALARY HMP.SALARY, HMP.HRLSALRATE
Displays the monthly salary or hourly rate.
GROUP HNP.PAYGROUP
Displays the budgeted pay group associated with the job class code for the assigned position.
STEP HMP.ACTUALSTEP
Displays the employee's pay step, if applicable.
ORGCODE HNP.ORGCODE
Displays the organization code as defined by the employee's position.

Sample Report

REPORT:   163                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:     1    
AGENCY:   XXX                                    XXXXX XXXXXXXXXX XX XXXXXXX                                 RUN DATE: XX/XX/20XX
                                                  EMPLOYEE PROFILE - TAD                                     RUN TIME: 21:24:12 
                                                                                                                              
                                                                                                                              
                                                                                                                              
EMPLOYEE NAME:    XXXXXXX, XXXXXXXXX X                  ________________________________________________________                   
EMPLOYEE SSN :    XXX-XX-XXXX                           ________________________________________________________                   
EMPLOYEE ADDRESS: XXXXX XXXXXXXCXXXXX                   ________________________________________________________                   
                                                        ________________________________________________________                   
                                                        ________________________________________________________                   
             MISSOURI CITY, TX 77459                    ________________________________________________________                   
     COUNTY:  79 PH (281) 555-5555                     ________________________________________________________                   
BIRTH DATE: 06/16/20XX                                  ________________________________________________________                   
MARITAL STATUS: 2     NO. OF DEP.:   4                 ________________________________________________________                   
EMPLOYMENT DATE: 05/19/20XX   LWOP MNTHS:   0           ________________________________________________________                   
EFF SERV BEGIN DATE: 05/19/20XX                         ________________________________________________________                   
PRIOR SERVICE MONTHS:   0                               ________________________________________________________                   
LOC/EXT CODE: 00040 /                                   ________________________________________________________                   
WORK ADDRESS: 111 Broadway                                                                                        
                                                                                                                              
                                                                                                                              
         Nome, TX 77055                                                                                                    
     COUNTY: 101  PH: (713) 555-5555                    ________________________________________________________                   
     JOB TITLE: EXAM II, DEPT OF BANKING                ________________________________________________________                   
     JOB CLASS: E014          SALARY:    4,579.00       ________________________________________________________                   
     GROUP: 13  STEP:  0  ORGCODE: 50810104040          ________________________________________________________