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.
- 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 ________________________________________________________