Child pages
  • Job Requirements
Skip to end of metadata
Go to start of metadata

Design Issues To Consider

  • Many of the fields in the USPJOB file are used for EMIS reporting. Some of these fields really have no other purpose in USPS except that they need to be tracked and reported for EMIS. When EMIS requirements change and new fields are added and removed changes to the base USPS files were always required. Should we continue this practice in the USPS-R project and makie changes to the underlying Employee, Position, etc. database structures when EMIS requirements change, or is there a better way to handle this?

Existing Requests That Could Effect Database Design

  • USPSV-1222 - JIRA project doesn't exist or you don't have permission to view it. CERT-APPLICATION field is no longer used
  • USPSV-782 - JIRA project doesn't exist or you don't have permission to view it. Add ability to track "last paid date" on a per job basis
  • USPSV-450 - USPJOB FILE - Add new sub pay group field to USPJOB file Closed Add ability to assign employees to a "sub pay group" that allows additional granularity to pay group assignments
  • USPSV-297 - USPSCN/JOBSCN: Increase size of contract type field on JOBSCN. Closed Increase size of contract type field
  • USPSV-491 - USPSCN/JOBSCN: modify to accept 1/2 day increments Closed Allow extended service days to be tracked in fractional increments

Existing Functional Enhancement Requests

  • USPSV-382 - USPSCN/JOBSCN: Add copy option for JOBSCN Closed Add a copy option to JOBSCN

JOBXML Methods

  • GET
  • SEARCH
  • CREATE
  • UPDATE
  • DELETE
  • GETNEXT (EMIS Service Only)

Current USPJOB.IDX File Layout

  01  USPJOB-REC ;REDEFINESCLAUSE
           02  USPJOB-KEY.
               03  SSN             PIC X(9).
               03  EMPID           REDEFINES SSN PIC X(9).
               03  JBN             PIC 9(2).
           02  CLEAR-OUT-AREA.
               03  JOBSTAT         PIC X.
               03  DATHIRE.
                   04  YEAHIRE     PIC 9(4).
                   04  MONHIRE     PIC 9(2).
                   04  DAYHIRE     PIC 9(2).
               03  DATTERM.
                   04  YEATERM     PIC 9(4).
                   04  MONTERM     PIC 9(2).
                   04  DAYTERM     PIC 9(2).
               03  UNITAMT         PIC S9(4)V9(3) COMP.
               03  PAYUNIT         PIC 9.
               03  PAYPLAN         PIC 9.
               03  HRSINDAY        PIC S9(2)V9(2) COMP.
               03  DAYINPER        PIC 9(2).
               03  SRVDYSPPP       PIC 9(2).
               03  FILLER          PIC X.
               03  USPJOB-CAL-START-DATE PIC X(8).
               03  SRVADV-FLAG     PIC X.
               03  PERCONT         PIC X.
               03  SRVDYS          PIC S9(5)V9(2) COMP.
               03  POCITION        PIC X(45).
               03  BLDDEP          PIC X(6).
               03  BLD-DEP         REDEFINES BLDDEP.
                   04  BLD         PIC X(3).
                   04  DEP         PIC X(3).
               03  CONTOBL         PIC S9(6)V9(2) COMP.
               03  ELGSICK         PIC X.
               03  ELGVAC          PIC X.
               03  ELGPERSONAL     PIC X.
               03  ELGCOMP         PIC X.
               03  DATRAISE.
                   04  YEARAISE    PIC 9(4).
                   04  MONRAISE    PIC 9(2).
                   04  DAYRAISE    PIC 9(2).
               03  CONTAMT         PIC S9(6)V9(2) COMP.
               03  CONTDUE         PIC S9(6)V9(2) COMP.
               03  WRKDYCT         PIC 9(3)V9(3).
               03  DYWRKCT         PIC 9(3)V9(3).
               03  NUMPAYS         PIC 9(2).
               03  NMPYPAID        PIC 9(2).
               03  TYPEAPPT        PIC 9.
               03  SUBAPPT-TYPE    PIC X(3).
               03  STRCHPY         PIC X.
               03  MULT-MUN        PIC X.
               03  DOCKAMT         PIC S9(6)V9(2) COMP.
               03  FILLER          PIC X.
               03  CONTSTART       PIC X(8).
               03  CONTSTOP        PIC X(8).
               03  RETSWCH         PIC X.
               03  PAYPERPER       PIC S9(6)V9(2) COMP.
               03  CONTAMTPD       PIC S9(6)V9(2) COMP.
               03  CONTADOCK       PIC S9(6)V9(2) COMP.
               03  ALL-YTD.
                   04  YTDRPAY     PIC S9(6)V9(2) COMP.
                   04  YTDOPAY     PIC S9(6)V9(2) COMP.
                   04  YTDMPAY     PIC S9(6)V9(2) COMP.
                   04  YTDGRPAY    PIC S9(6)V9(2) COMP.
                   04  YTDRUNT     PIC S9(4)V9(2) COMP.
                   04  YTDOUNT     PIC S9(4)V9(2) COMP.
                   04  YTDMUNT     PIC S9(4)V9(2) COMP.
                   04  YTDDAMT     PIC S9(6)V9(2) COMP.
                   04  YTDDUNT     PIC S9(4)V9(2) COMP.
                   04  YTDSHFPRE   PIC S9(4)V9(2) COMP.
               03  ALL-QTD.
                   04  QTDRPAY     PIC S9(6)V9(2) COMP.
                   04  QTDSHFPRE   PIC S9(4)V9(2) COMP.
                   04  QTDOPAY     PIC S9(6)V9(2) COMP.
                   04  QTDMPAY     PIC S9(6)V9(2) COMP.
                   04  QTDGPAY     PIC S9(6)V9(2) COMP.
                   04  QTDDAMT     PIC S9(6)V9(2) COMP.
               03  ALL-FTD.
                   04  FTDRPAY     PIC S9(6)V9(2) COMP.
                   04  FTDSHFPRE   PIC S9(4)V9(2) COMP.
                   04  FTDOPAY     PIC S9(6)V9(2) COMP.
                   04  FTDMPAY     PIC S9(6)V9(2) COMP.
                   04  FTDGPAY     PIC S9(6)V9(2) COMP.
                   04  FTDDAMT     PIC S9(6)V9(2) COMP.
               03  EMP-ALL-CTD.
                   04  EMP-CTDRPAY PIC S9(6)V9(2) COMP.
                   04  EMP-CTDOPAY PIC S9(6)V9(2) COMP.
                   04  EMP-CTDMPAY PIC S9(6)V9(2) COMP.
                   04  EMP-CTDGRPAY PIC S9(6)V9(2) COMP.
                   04  EMP-CTDRUNT PIC S9(4)V9(2) COMP.
                   04  EMP-CTDOUNT PIC S9(4)V9(2) COMP.
                   04  EMP-CTDMUNT PIC S9(4)V9(2) COMP.
                   04  EMP-CTDDAMT PIC S9(6)V9(2) COMP.
                   04  EMP-CTDDUNT PIC S9(4)V9(2) COMP.
                   04  EMP-CTDSHFPRE PIC S9(4)V9(2) COMP.
               03  EMP-PAY-GRP     PIC X(2).
               03  EMP-USPS-36-AREA.
                   04  EMP-CONTRACT-AMT-EARNED PIC S9(6)V9(2) COMP.
                   04  EMP-RETRO-NEXT-PAY PIC S9(6)V9(2) COMP.
                   04  EMP-SALARY-SCHED-ID PIC X(6).
                   04  EMP-SALARY-SCHED-COLUMN PIC S9(4) COMP.
                   04  EMP-SALARY-SCHED-STEP PIC S9(4) COMP.
                   04  EMP-NON-CASH-QTD PIC S9(6)V9(2) COMP.
                   04  EMP-NON-CASH-YTD PIC S9(6)V9(2) COMP.
                   04  EMP-NON-CASH-FTD PIC S9(6)V9(2) COMP.
               03  EMP-USER-DEFINED-AREA.
                   04  EMP-USER-MONEY-1 PIC S9(6)V9(2) COMP.
                   04  EMP-USER-MONEY-2 PIC S9(6)V9(2) COMP.
                   04  EMP-USER-MONEY-3 PIC S9(6)V9(2) COMP.
                   04  EMP-USER-MONEY-4 PIC S9(6)V9(2) COMP.
                   04  EMP-USER-CODE-1 PIC X(2).
                   04  EMP-USER-CODE-2 PIC X(2).
                   04  EMP-USER-CODE-3 PIC X(2).
                   04  EMP-USER-CODE-4 PIC X(2).
                   04  EMP-USER-TEXT PIC X(30).
                   04  EMP-USER-TEXT-2 PIC X(30).
                   04  EMP-USER-DATE PIC X(8).
                   04  EMP-USER-DATE-2 PIC X(8).
               03  PRSL-USER-DEFINED-AREA.
                   04  PRSL-USER-MONEY-1 PIC S9(6)V9(2) COMP.
                   04  PRSL-USER-MONEY-2 PIC S9(6)V9(2) COMP.
                   04  PRSL-USER-MONEY-3 PIC S9(6)V9(2) COMP.
                   04  PRSL-USER-MONEY-4 PIC S9(6)V9(2) COMP.
                   04  PRSL-USER-CODE-1 PIC X(2).
                   04  PRSL-USER-CODE-2 PIC X(2).
                   04  PRSL-USER-CODE-3 PIC X(2).
                   04  PRSL-USER-CODE-4 PIC X(2).
                   04  PRSL-USER-TEXT PIC X(30).
                   04  PRSL-USER-TEXT-2 PIC X(30).
                   04  PRSL-USER-DATE PIC X(8).
                   04  PRSL-USER-DATE-2 PIC X(8).
           02  USPJOB-EMIS-DATA-ITEMS.
               03  POSITION-CODE   PIC 9(4).
               03  BUILDING-IRN    PIC X(6).
               03  POSITION-FTE    PIC 9(2)V9(5).
               03  POSITION-FUND-SOURCE OCCURS 3 TIMES.
                   04  FUND-SOURCE-PERCENT PIC 9(4).
                   04  FUND-SOURCE-CODE PIC X(2).
                   04  APPROVED-PERCENT PIC S9(4)V9(2) COMP.
               03  POSITION-TYPE   PIC X(2).
               03  POSITION-STATUS PIC X(2).
               03  EXP-CURRENT-CLASS PIC 9(2).
               03  EXTENDED-SERVICE PIC 9(2).
               03  ASSIGNMENT-AREA-TABLE OCCURS 3 TIMES.
                   04  ASSIGNMENT-AREA PIC 9(6).
               03  SEPARATION-REASON PIC X(2).
               03  CERT-APPLICATION PIC X(2).
               03  APPOINTMENT-TYPE PIC X(2).
               03  USPJOB-REPORT-TO-EMIS PIC X(2).
           02  USPJOB-CONTRACT-TYPE PIC X(5).
           02  USPJOB-EMIS-FIELDS.
               03  USPJOB-EMIS-HRSINDAY PIC S9(2)V9(2) COMP.
               03  USPJOB-EMIS-CONTAMT PIC S9(6)V9(2) COMP.
               03  USPJOB-EMIS-WRKDYCT PIC 9(3)V9(3).
               03  USPJOB-EMIS-FTE PIC 9(2)V9(5).
           02  USPJOB-CAL-TYPE     PIC X(3).
           02  USPJOB-CK-STUB-DESCRIP PIC X(8).
           02  USPJOB-OVERTIME-RATE PIC S9(4)V9(3) COMP.
           02  USPJOB-CAL-STOP-DATE PIC X(8).
           02  USPJOB-PAYCODE      PIC X(3).
           02  USPJOB-TYPE         PIC X(4).
           02  USPJOB-EMIS-LOW-GRD PIC X(2).
           02  USPJOB-EMIS-HI-GRD  PIC X(2).
           02  USPJOB-HQPD         PIC X.
           02  USPJOB-PARAPROF     PIC X.
           02  USPJOB-SUB-PAY-GRP  PIC X(2).
           02  USPJOB-LAST-DATE-PAID PIC X(8).
           02  USPJOB-SEPARATION-DATE PIC X(8).
           02  USPJOB-PARA-HIRE-DATE PIC X(8).
           02  USPJOB-SUPERVISOR-ID PIC X(9).
           02  USPJOB-RETIRE-HRS   PIC S9(2)V9(2) COMP.
           02  USPJOB-EMIS-SPED-FTE PIC 9V99.
           02  FILLER              PIC X(58).

Field Validations

  • No labels