USPS Reports Guide –
USPS Reports by Number –
Report 798 New Hires and Transfers Report

The report will only display the latest new hire record on employees that might have terminated and been rehired. If the new hired employee terminates within the time period requested the termination date should be displayed on the report.

Report Criteria

Category	Personnel Management
Distribution	Agency
Frequency	Monthly
Form	111
Sort Sequence	Options (Required): First – Employee Name Second – Reason Code, Employee Name Third – Organization Code (all 11 digits), Employee Name Fourth – Organization Code (last 2 digits), Employee Name Fifth – Organization Code (all 11 digits) Sixth – Organization Code (last 2 digits) Seventh – Organization Code (all 11 digits), Hire date, Employee Name Eighth – Organization Code (last 2 digits), Hire date, Employee Name Ninth – Organization Code (all 11 digits), Reason Code, Employee Name Tenth – Organization Code (last 2 digits), Reason Code, Employee Name Sequence Default: Third Sort as the default on HNKPM, any agency requiring a different sort can request the set up change on HNKPM.
Page Break	First – no page break, grand total of employees separate page. Second – no page break, total by reason code – grand total of employees on separate page. Third – (1) break and total by organization code – grand total of employees on separate page; (2) no break, total by organization code – grand total of employees on separate page. Fourth – (1) break and total by organization code – grand total of employees on separate page; (2) no break, total by organization code – grand total of employees on separate page. Fifth – (1) break and total by organization code – grand total of employees on separate page; (2) no break, total by organization code – grand total of employees on separate page. Sixth – (1) break and total by organization code – grand total of employees on separate page; (2) no break, total by organization code – grand total of employees on separate page. Seventh – (1) break and total by organization code – grand total of employees on separate page; (2) no break, total by organization code – grand total of employees on separate page. Eighth – (1) break and total by organization code – grand total of employees on separate page; (2) no break, total by organization code – grand total of employees on separate page. Ninth – (1) no break, total by reason code – grand total of employees on separate page; (2) break by organization, total by reason code – grand total of employees on separate page. A – (1) no break, total by reason code – grand total of employees on separate page; (2) break by organization, total by reason code – grand total of employees on separate page.
Parameters	HNKPM – START DATE, END DATE and REPORT 798 SORT
Databases Used	HNH, HOB, HID, HNJ, HO0, H10, HN0 HNK, H70, HML, H0C
Selection Criteria	All employees with HNH records with a reason code that equals LEG, 010 or 012-017, with an effective date on or between the START DATE and END DATE.
Produce Output?	Yes
Request Screen	HNKPM – Requested by USPS personnel on 8th each month and will sort by the Report 798 Sort field. HPRPT – Set up to run automatically with each payroll and will sort by the Report 798 Sort field.
Posting Report?	No
Additional Notes	This is not the same report that is sent to the Attorney General's Office by the Comptroller's office twice a month. In order for the report to generate, a valid sort option must be entered in the Report 798 Sort field. (This field must not be blank.)

Report Headings

Column One

EMP NAME HID.RPTNAME: This field displays the employee's name. (Last name, first name, middle name – spell out as much as possible – 17 bytes maximum.)
SSN HNH.EMPLOYEENO: This field displays the employee's Social Security number (xxx-xx-xxxx). Put leading zeros if necessary (11 bytes).
HIRE DATE H0B.EMPLOYEEDATE: This field displays the employee's hire date (mm/dd/ccyy) (10 bytes).
RC HNH.HRISREASCD: This field displays the new hire reason code (LEG, 010, 012 - 017) (3 bytes).
EEXT RC HNH.EXTRSNCD: This field displays the new hire extended reason code if one exists. If it doesn't exist, display blank (4 bytes).
TFR AGY HNH (AGENCY COMMENT BYTES 8-10): This field displays the losing agency's number for direct transfers. If it doesn't exist, display blank (3 bytes).
TERM DATE H0B.TERMDATE: This field displays the termination date (mm/dd/ccyy) if the employee is hired and then terminates during the same time period requested on the report. Termination reason codes are 057, 060, 063, 064, 065, 067, 068, and 069. If a termination date doesn't exist, leave blank (10 bytes).

Column Two

ORG CD HNH.ORGCODE: This field displays the employee's organization code (11 bytes).
ST EFF SERV DT 0B.ADJEMPLDAT: This field displays the employee's state effective service date (mm/dd/ccyy) (10 bytes).
AGY EFF SERV DT H0B.DATEELIG1: This field displays the employee's effective service date at current agency (mm/dd/ccyy) (10 bytes).
BIRTH DT HID.BIRTHDATE: This field displays the employee's birthdate (mm/dd/ccyy) (10 bytes).
SSRV ELG: This field displays the employee's selective service eligibility. This is derived from the date of birth. If employee is male and age is between 18-25 years old then eligibility will be 'Y'; else 'N' (1 byte).
RACE HID.XXEEORACE: This field displays the employee's race. Spell out literal (5 bytes).
SEX HID.XXSEX: This field displays the employee's sex (1 byte).
VET STAT HID.MILSTATUS: This field displays the employee's veteran status. Display exact value: 'Y', 'N' or 'U' (1 byte).

Column Three

ORG TITLE HNO.ORGNAME: This field displays the employee's organization code title (32 bytes).
POS NO. HNH.POSITION: This field displays the employee's position number (8 bytes).
FTE HNH.ASSIGNFTE: This field displays the employee's FTE (Full time equivalency). If less than a full time (1.000), only display number after decimal (example: .750) (5 bytes).
HRS: This field is derived (FTE x 40) and displays the employee's weekly work hours (xx.xx) (5 bytes).
EMP TYP HNH.EMPTYPE: This field displays the employee type for the employee (3 bytes).
EEO CAT HNH.JCEEOCODE: This field displays the employee's EEO category code type (1 byte).
GRP HNH (AGENCY COMMENT BYTES 3-4): This field displays the employee's salary table (2 bytes).
GRP/STP HNH.POSPAYGRP/HNH.ACTUALSTEP: This field displays the employee's salary and step (5 bytes).
SAL/RATE HNH.HSALARY, HNH.HHRLYRATE: This field displays the employee's current salary or hourly rate. Display whichever applies (xx,xxx.xx) or (xxx.xxxxx) (9 bytes).
ANN SAL H0B.ANNSALARY: This field is displays the employee's annual salary (10 bytes).
JB CLS/TITLE HNH.JOBCLASS/H7O.JCTITLE: This field displays the employee's job class and job class title (28 bytes).
CLS TYP HNH (AGYCOMMENT BYTE 2): This field displays the employee's job class type (1 byte).
FUNCT JB/TITLE HNH.ACTFUNCLS/HML.FCTITLE: This field displays the employee's functional job class and functional job class title if one exists. If it doesn't exist, display as 'blank' (30 bytes).

Column Four

VISA TYPE/EXP DT HO0.VISATYPE/HO0.VISAEXPNDT: This field displays the employee's visa type and visa expiration date if one exists. If it doesn't exist, display as 'blank' (16 bytes).
ED LV HID.HIGHDEGREE: This field displays the employee's education level. If it doesn't exist, display as 'blank' (1 byte).
RT TYP H0B.FLAGB: This field displays the employee's current retirement type (1 byte).
RT DT: This field is derived from effective date of reason code 068 on HNH.HRISREASCD and will display the employee's retirement date (mm/dd/ccyy) from previous employment.
Note: If the employee's current retirement type is 'X', meaning return to work retiree, but can find reason code 068 in a USPS agency, then check other systems. If it doesn't exist, display as 00/00/0000 (10 bytes).
PREV TYP H0B.FLAGD: This field displays the previous retirement type from which the employee retired. If it doesn't exist, display as blank (1 byte).
PAY TYP HNH.HPAYTYPE: This field displays the employee's pay type. Spell out literal (6 bytes).
FRE HNH.HFREQOFPAY: This field displays the employee's pay frequency. Spell out as much as possible (10 bytes).
BRP H0B.FLAGA: This field displays whether the employee is eligible for benefit replacement pay. Display 'N','Y', or 'W' (1 byte).
HAZ IND HNH.HAZDTYIND: This field displays whether the employee is eligible for hazardous duty pay. If indicator = 'N' display as blank; else display value 'Y', '8', '9' (1 byte).
FLSA ST HNH.FLSASTAT: This field displays the employee's FLSA status. Spell out as much as possible (14 bytes).
LNG AMT H10.APAAMT (SPECIAL PAY = 06): This field displays the employee's monthly longevity amount. If it doesn't exist display as 000.00 (6 bytes).
HAZ AMT H10.APAAMT (SPECIAL PAY = 05): This field displays the employee's hazardous duty monthly amount. If it doesn't exist, display as 000.00 (6 bytes).

Column Five

WK-LOC HNH.LOCCODE: This field displays the employee's work location (4 bytes).
CNTY NM HNH.PCCOUNTY: This field displays the employee's work county. Spell out as much as possible (12 bytes).
WK-ADDR HNJ.PCADR1: This field displays the employee's work address. Spell out as much as possible (16 bytes).
WK-CITY, ST, ZIP HNJ.PCCITY, HNJ.PCSTATE, HNJ.PCZIP: This field displays the employee's work city, state and zip code. Spell out 8 bytes on the city (16 bytes).
WK-PHONE HNJ.WKPHNO: This field displays the employee's work phone number (12 bytes).

Column Six

ADDR/PHONE REL HO0.ADDRRELIND, HO0.HPHNRELIND

This displays the address release indicator (1 byte) and the home phone release indicator (1 byte).

HM-ADDR HID.EEADR1

This field displays the employee's home address. Spell out as much as possible (21 bytes).

HM-CITY, ST, ZIP HID.CITY, HID.STATE, HID.ZIPCODE

This field displays the employee's home city, state, and zip code. Spell out as 12 bytes on the city (21 bytes).

HM-PHONE HID.HOMEPHONE

This field displays the employee's home phone number (12 bytes).

The Report Header should include the following headings per example attached:

Agency Name
Report Title NEW HIRES AND TRANSFERS
From MM/DD/CCYY to MM/DD/CCYY (Start Date HNK.PMSTDT and End Date HNK.PMEDT)
Separate Total Page listing agency new hires.

The total number of new hires in the requested period should be printed on a separate page from the body of the report. The column headings should not be printed on this page.

Sample Report

   REPORT:   798                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:     1     
   AGENCY:   XXX                                   XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX                               RUN DATE: XX/XX/20XX
                                                      NEW HIRES AND TRANSFERS                                   RUN TIME: 11:31:47  
                                                   FROM 08/01/20XX TO 08/31/20XX
EMP NAME              ORG CD            ORG TITLE                           VISA TYP/EXP DT/ED LV                                   
SSN                   ST EFF SERV DT    POS NO. /FTE /HRS /EMP TYP /EEO CAT RT TYP/RT DT/PREV TYP  WK-LOC / CNTY NM ADDR/PHONE REL     
HIRE DATE             AGY EFF SERV DT   TBL-GRP/STP / SAL/RATE / ANN SAL    PAY TYP / FREQ         WK-ADDR          HM-ADDR         
RC /EXT RC/TFR AGY    BIRTH DT/SSRV ELG JB CLS / TITLE / CLS TYP            BRP/HAZ IND/ FLSA ST   WK-CITY,ST,ZIP   HM-CITY,ST,ZIP  
TERM DATE             RACE/SEX/VET STAT FUNCT JB CLS / TITLE                LNG AMT / HAZ AMT      WK-PHONE         HM-PHONE        
                                                                                
------------------------------------------------------------------------------------------------------------------------------------
XXXXX, XXXXXX X       00000222100       SUN SYSTEMS UNIT          /     /       
XXX-XX-XXXX           03/04/20XX        02220038 / 1.000 / 40.00 / CRF / Q   E / XX/XX/20XX /      00001 / TRAVIS   N/N               
08/16/20XX            08/16/20XX        1B-09 /    /  3,000.00 /  36,000.00  SALARY   / MONTHLY    1201 BRAZOS      1406 PARK PLACE
014 /      / 582      03/23/20XX / N    1570 - PROG SPEC I               /N  N / N / ADMIN-EXEMPT  AUSTIN  TX 78701 AUSTIN  TX 78748
                      WHITE / F / N                                             0.00 /    0.00     512/463-0000     512/444-4444    
TOTAL IN ORG:            1

USPS Reports Guide – USPS Reports by Number – Report 798 New Hires and Transfers Report