Skip to content
Breadcrumbs

USPS Reports Guide –
USPS Reports by Number –
Report 050 HR Extract Rebuild

This report produces a rebuild of the selected databases found on HNK50. This rebuild can be set up to run automatically anytime a change is made to the requested databases (Y), or it can be set up manually to run that night (R). A third option is also available for certain databases, which will capture only the most current record (C).

Report Criteria

Category Personnel Management
Distribution Agency
Frequency Upon Request; Nightly
Form 202
Sort Sequence
Options H0XCR Sort
Employee Number 4

Note: Transactions with no employee number will print prior to those with an employee number.
Page Break  
Parameters
  • HNKPC – START DATE, END DATE
  • HNK50 – Tables; Include Records FROM/TO
Databases Used
  • HNK, H0C
  • Agency Level: HMJ, HML, HMM, HNI, HNO, HNJ, H7O, H7S, H7W
  • Employee Level: HDT, HID, HMT, HNH, HNP, HNY, HN1, HN8, HO2, H0B, H0Z, H61
Selection Criteria All changes made to the databases marked on HNK50 during the selected HNK range. If the dates on HNK50 are blank, then START DATE and END DATE are used.
Produce Output? Yes – Electronic Interface and Report
Request Screen

HPRPT – Set up to run automatically each night.

HNK50 – Enter R or Y next to the desired agency level databases. To request employee level databases, contact your USPS representative with request option desired, either R or C.

R Full rebuild
Y Full rebuild only when a change occurs
C Only the most recent records will be processed. Valid only on tables HMT, HNH, HNP, HN1, H61, HO2.

Note: Rs will disappear that night. Ys will change into As after the online process to indicate that a change has been made and will be reported that night. As will be reset to Ys after that night's processing.

Posting Report? No
Additional Notes

Report 550 is the HR Daily Extract used to capture daily changes to the selected databases marked on HNK11.

Report Headings

FLAG SETTINGS HNK50
Displays the tables (databases) from HNK50 and the flag settings at the time the extract was run.
Y Full rebuild only when changes occur.
R Full rebuild during the next processing night.
A Indicates a change was made to a table when notification of a change was requested (Y was set). This will automatically be reset to Y after the nightly processing.
C Capture only the most recent records.

Sample Report

REPORT:    50                            UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:     1    
   AGENCY:   XXX                                   XXXXXXXXXXXXXXXXXXXXXXXXXXXXX                                RUN DATE: XX/XX/20XX
                                                          HR DAILY EXTRACT                                      RUN TIME: 03:24:29 
                                                                                                                                   
FLAG SETTINGS:    HDT=  HID=Y HMC=  HMT=  HM8=  HM9=  HND=  HNH=Y HNP=  HNY=  HN1=  HN8=  HOC=  HOH=  HO2=  HO8=  H0B=Y H0Z=  H61= 
                                                                                                                                   
                                                                                                                                   
          4 HID ROWS WRITTEN TO EXTRACT                                                                                            
          5 HNH ROWS WRITTEN TO EXTRACT                                                                                            
          5 H0B ROWS WRITTEN TO EXTRACT