Skip to content
Breadcrumbs

USPS Reports Guide –
USPS Reports by Number –
Report 862 Location Table Listing

This report displays all location codes for the agency. Displays the name, address, telephone numbers and T.W.C. number for all active and inactive locations.

Report Criteria

Category Personnel Management
Distribution Agency
Frequency Upon Request
Form 111
Sort Sequence Location Code, Inactive Date
Page Break Agency
Parameters All location codes on HNJU1.
Databases Used HNJ
Selection Criteria  
Produce Output? Yes
Request Screen HSRPT
Posting Report? No
Additional Notes A set up on H0XCR is not required for this report to run.

Report Headings

LOCATION HNJ.PLANTLOC
Displays the agency-defined code identifying the agency's location.
NAME HNJ.PCLOCATION
Displays the name corresponding to the location code.
BLDG HNJ.PCBUILDING
Displays the agency-defined code identifying the agency's building, if applicable.
UNIT NR HNJ.UNITNO
Displays the agency-defined number identifying a group or unit.
SITE HNJ.SITERPTTO
Displays the location code that this location reports to.
SITE TYPE HNJ.SITETYPE
Displays the agency site type.
BLDGBuilding Name
FLOORFloor Number
OFFICOffice Name
PHONE NR HNJ.WKPHNO
Displays the work telephone number for this location.
ADDRESS HNJU1
Displays the location's complete address.
EFF DATE HNJ.HISTORYDT
Displays the effective date of the location.
COUNTY HNJ.PCCOUNTY
Displays the county code of the location.
TWC NR HNJ.TECRPTNO
Displays the number assigned by the Texas Workforce Commission for TWC reporting purposes.
NACT DT HNJ.NACTDT
Displays the inactive date of the location, if applicable.
CLS RPT TO HNJ.JCRPTIND
Displays Y or N to indicate whether the location is included on the job classification report.

Sample Report

 REPORT:   862                       UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                               PAGE:    1
 AGENCY:   XXX                              XXXX XXXXX XXXXXXXXXXX XXXXX                                  RUN DATE: XX/XX/20XX
                                               LOCATION TABLE LISTING                                     RUN TIME: 2:00:00
                                                  

LOCATION       NAME              BLDG      UNIT      HR     SITE      SITETYPE       PHONE NR         ACCRESS             CITY
EFF DATE                                                              COUNTY         TWC NR                               STATE
MACT DT                                                                              CLSRPTTO                             ZIP CODE

00001         US HWY 290 EAST              0                0                      (512) XXX-XXXX    6330 US HWY 290 E      AUSTIN
                                                                      227              XXXXX                              TX
                                                                                    Y                                     78723