| 
 | 
                             PAJOBREQ FILE
                            Job Requisition
The Job Requisition file contains information about job or position
requisitions.
REFERENCED BY
HPJR.1    HR170     HR70.1    PA03.2    PA100     PA111
PA231     PA241     PA242     PA243     PA244     PA406
PA52.4    PA532     SNEM.1    PA211     PA272     PA302
PA402     PA64.2    PA64.1    PA65.2    PA65.1
UPDATED BY
HR11.1    PA02.1    PA102     PA115     PA120     PA41.1
PA42.1    PA42.3    PA43.1    PA43.2    PA44.1    PA45.1
PA46.1    PA502     PA531     PA535
FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY
PJR-COMPANY            Numeric 4                                 PA02.1  PA102
Element: Company       Contains the company number, which        PA42.1  PA42.3
                       represents an established company.        PA502   PA535
PJR-REQUISITION        Numeric 9                                 PA02.1  PA102
Element: Requisition   Contains the system-assigned number       PA42.1  PA42.3
                       that represents the requisition.          PA502   PA535
PJR-DESCRIPTION        Alpha 30  (Lower Case)                    PA02.1  PA102
Element: Description   Contains the description of the           PA42.1  PA42.3
                       requisition.                              PA502   PA535
PJR-POSITION           Alpha 12                                  PA02.1  PA102
Element: Position      Contains the user-defined code that       PA42.1  PA42.3
                       represents a position in the company.     PA502   PA535
PJR-JOB-CODE           Alpha 9                                   PA02.1  PA102
Element: Job Code      Contains the code that represents the     PA42.1  PA42.3
                       new or open job.                          PA502   PA535
PJR-REQ-STATUS         Alpha 10                                  PA02.1  PA102
Element: Requisition StContains the status of the requisition.   PA42.1  PA42.3
                                                                 PA45.1  PA502
                                                                 PA535
PJR-OPENINGS           Numeric 3                                 PA02.1  PA102
Element: Openings      Contains the number of open jobs or       PA42.1  PA42.3
                       positions.                                PA502   PA535
PJR-REPLACEMENT        Alpha 1                                   PA02.1  PA102
Element: Replacement   Indicates whether the requisition is      PA42.1  PA42.3
                       for a replacement of a current job and    PA502   PA535
                       position.
                       Y = Yes
                       N = No
PJR-REP-EMPLOYEE       Numeric 9                                 PA02.1  PA102
Element: Replacement FoContains the number that represents the   PA42.1  PA42.3
                       employee being replaced.                  PA502   PA535
                       This field is valid only when the
                       Replacement field is Yes.
PJR-BUDGETED-FLAG      Alpha 1                                   PA02.1  PA102
Element: Budgeted      Indicates whether the requisition is      PA42.1  PA42.3
                       for a job and position that is budgeted.  PA502   PA535
                       Y = Yes
                       N = No
PJR-REQUEST-DATE       Numeric 8  (yyyymmdd)                     PA02.1  PA102
Element: Requested     Contains the date the requisition is      PA42.1  PA42.3
                       requested.                                PA502   PA535
PJR-REQUEST-BY         Numeric 9                                 PA02.1  PA102
Element: Requested By  Contains the number that represents the   PA42.1  PA42.3
                       employee who requested the requisition.   PA502   PA535
PJR-DATE-NEEDED        Numeric 8  (yyyymmdd)                     PA02.1  PA102
Element: Needed        Contains the date on which the job        PA42.1  PA42.3
                       should be filled.                         PA502   PA535
PJR-OPEN-DATE          Numeric 8  (yyyymmdd)                     PA02.1  PA102
Element: Open          Contains the date the requisition is      PA42.1  PA42.3
                       open.                                     PA502   PA535
PJR-CLOSED-DATE        Numeric 8  (yyyymmdd)                     PA02.1  PA102
Element: Closed        Contains the date the requisition was     PA42.1  PA42.3
                       closed.                                   PA45.1  PA502
                                                                 PA535
PJR-APP-STATUS         Alpha 2                                   PA02.1  PA102
Element: Employee StatuContains the employee status of the job   PA42.1  PA42.3
                       and position on the requisition.          PA502   PA535
PJR-TEMP-BEGIN         Numeric 8  (yyyymmdd)                     PA02.1  PA102
Element: Temporary BegiContains the date the temporary           PA42.1  PA42.3
                       position begins.                          PA502   PA535
PJR-TEMP-END           Numeric 8  (yyyymmdd)                     PA02.1  PA102
Element: Temporary End Contains the date the temporary           PA42.1  PA42.3
                       position ends.                            PA502   PA535
PJR-SCHEDULE           Alpha 9                                   PA02.1  PA102
Element: Schedule      Contains the step and grade schedule or   PA42.1  PA42.3
                       the grade range schedule of  the job on   PA502   PA535
                       the requisition.
PJR-PAY-GRADE          Alpha 3                                   PA02.1  PA102
Element: Grade         Contains the grade of the job on the      PA42.1  PA42.3
                       requisition.                              PA502   PA535
PJR-PAY-STEP           Numeric 2                                 PA02.1  PA102
Element: Step          Contains the step of the job on the       PA42.1  PA42.3
                       requisition.                              PA502   PA535
PJR-SALARY-CLASS       Alpha 1                                   PA02.1  PA102
Element: Salary Class  Contains the salary class of the job on   PA42.1  PA42.3
                       the requisition.                          PA502   PA535
                       H = Hourly
                       S = Salaried
PJR-BEG-PAY-RATE       Signed 13.4                               PA02.1  PA102
Element: Beginning Pay Contains the minimum pay rate an          PA42.1  PA42.3
                       employee receives in the job.             PA502   PA535
PJR-END-PAY-RATE       Signed 13.4                               PA02.1  PA102
Element: Ending Pay RatContains the maximum pay rate an          PA42.1  PA42.3
                       employee receives in the job.             PA502   PA535
PJR-EXEMPT-EMP         Alpha 1                                   PA02.1  PA102
Element: Exempt        Indicates whether an employee is exempt   PA42.1  PA42.3
                       from overtime pay when the requisition's  PA502   PA535
                       job or position.
                       Y = Yes
                       N = No
PJR-WORK-SCHED         Alpha 10                                  PA02.1  PA102
Element: Work Schedule Contains the work schedule of the job.    PA42.1  PA42.3
                                                                 PA502   PA535
                       The work schedule must be valid in the
                       Human Resource Code file.
PJR-PROCESS-LEVEL      Alpha 5                                   PA02.1  PA102
Element: Process Level Contains the process level in which the   PA42.1  PA42.3
                       job and position are needed.              PA502   PA535
PJR-DEPARTMENT         Alpha 5                                   PA02.1  PA102
Element: Department    Contains the department in which the      PA42.1  PA42.3
                       job and position are needed.              PA502   PA535
PJR-USER-LEVEL         Alpha 10                                  PA02.1  PA102
Element: User Level    Contains the user level in which the      PA42.1  PA42.3
                       job and position are needed.              PA502   PA535
PJR-LOCAT-CODE         Alpha 10                                  PA02.1  PA102
Element: Location      Contains the location at which the job    PA42.1  PA42.3
                       and position are needed.                  PA502   PA535
PJR-UNION-CODE         Alpha 10                                  PA02.1  PA102
Element: Union Code                                              PA42.1  PA42.3
                                                                 PA502   PA535
PJR-BARGAIN-UNIT       Alpha 10                                  PA02.1  PA102
Element: Bargain Unit                                            PA42.1  PA42.3
                                                                 PA502   PA535
PJR-SUPERVISOR         Alpha 10                                  PA02.1  PA102
Element: Supervisor    Contains the employee who supervises      PA42.1  PA42.3
                       the position.                             PA502   PA535
PJR-TOTAL-APPLIED      Numeric 3                                 PA115   PA120
Element: Total ApplicanContains the total number of applicants   PA43.1  PA43.2
                       who applied for the requisition.
PJR-INTERVIEWS         Numeric 3                                 PA115   PA120
Element: Interviews    Contains the total number of interviews   PA41.1
                       for the requisition.
PJR-OFFERS-EXTEND      Numeric 3                                 PA115   PA120
Element: Offers ExtendeContains the number of times an offer     PA45.1
                       was extended for the requisition.
PJR-OFFERS-ACCEPT      Numeric 3                                 PA02.1  PA102
Element: Offers AccepteContains the number of times an offer     PA115   PA120
                       was accepted for the requisition.         PA42.1  PA42.3
                                                                 PA45.1  PA502
                                                                 PA535
PJR-OFFERS-DECLINE     Numeric 3                                 PA115   PA120
Element: Offers DeclineContains the number of times an offer     PA45.1
                       was declined for the requisition.
PJR-TOT-COST           Signed 11.2                               PA115   PA120
Element: Total Cost    Contains the total cost of the            PA44.1
                       requisition.
PJR-NBR-APPROVALS      Numeric 2                                 PA02.1  PA102
Element: Number of ApprContains the number of people who need    PA42.1  PA42.3
                       to approve the requisition before         PA502   PA535
                       applicants can be hired.
PJR-APPROVAL-DESC      Alpha 30  (Lower Case)                    PA02.1  PA102
Element: Title DescriptOccurs 10 Times                           PA42.1  PA42.3
                       Contains the title or name of the         PA502   PA535
                       person who needs to approve the
                       requisition.
PJR-APPROVAL-DATE      Numeric 8  (yyyymmdd) Occurs 10 Times     PA02.1  PA102
Element: Date          Contains the date the person approved     PA42.1  PA42.3
                       the requisition.                          PA502   PA535
PJR-APPROVAL-EMP       Numeric 9 Occurs 10 Times                 PA02.1  PA102
Element: Approved By   Contains the number of the employee who   PA42.1  PA42.3
                       approved the requisition.                 PA502   PA535
PJR-INTERNAL-START     Numeric 8  (yyyymmdd)                     PA02.1  PA102
Internal Posting       Contains the first date the requisition   PA42.1  PA42.3
Dates - Start          is posted in the company.                 PA502   PA535
PJR-INTERNAL-STOP      Numeric 8  (yyyymmdd)                     PA02.1  PA102
Internal Posting       Contains the last date the requisition    PA42.1  PA42.3
Dates - Stop           is posted in the company.                 PA502   PA535
PJR-EXTERNAL-START     Numeric 8  (yyyymmdd)                     PA02.1  PA102
External Posting       Contains the first date the requisition   PA42.1  PA42.3
Dates - Start          is posted outside the company.            PA502   PA535
PJR-EXTERNAL-STOP      Numeric 8  (yyyymmdd)                     PA02.1  PA102
External Posting       Contains the last date the requisition    PA42.1  PA42.3
Dates - Stop           is posted outside the company.            PA502   PA535
PJR-CONTACT-NBR        Numeric 9                                 PA02.1  PA102
Element: Contact EmployContains the number of the employee who   PA42.1  PA42.3
                       should be contacted about the             PA502   PA535
                       requisition.
PJR-CONTACT-LAST       Alpha 30  (Lower Case)                    PA02.1  PA102
Element: Contact's LastContains the last name of the employee    PA42.1  PA42.3
                       who should be contacted about the         PA502   PA535
                       requisition.
PJR-CONTACT-FIRST      Alpha 15  (Lower Case)                    PA02.1  PA102
Element: Contact's FirsContains the first name of the employee   PA42.1  PA42.3
                       who should be contacted about the         PA502   PA535
                       requisition.
PJR-CONTACT-MI         Alpha 1                                   PA02.1  PA102
Contact's Middle       Contains the middle initial of the        PA42.1  PA42.3
Initial                employee who should be contacted about    PA502   PA535
                       the requisition.
PJR-WK-PHONE-CNTRY     Alpha 6                                   PA02.1  PA102
Work Telephone         Contains the prefix of the telephone      PA42.1  PA42.3
Country                number of the employee who should be      PA502   PA535
                       contacted about the requisition.
PJR-WK-PHONE-NBR       Alpha 15                                  PA02.1  PA102
Element: Work TelephoneContains the telephone number of the      PA42.1  PA42.3
                       employee who should be contacted about    PA502   PA535
                       the requisition.
PJR-WK-PHONE-EXT       Alpha 5                                   PA02.1  PA102
Work Telephone         Contains the extension of the telephone   PA42.1  PA42.3
Extension              number of the employee who should be      PA502   PA535
                       contacted about the requisition.
PJR-SHORT-DESC1        Alpha 30  (Lower Case)                    PA02.1  PA102
Element: Short DescriptContains the first line of either         PA42.1  PA42.3
                                                                 PA502   PA535
                       (1) a description of the job and
                       position on the requisition, or
                       (2) any other information you want.
PJR-SHORT-DESC2        Alpha 30  (Lower Case)                    PA02.1  PA102
Element: Short DescriptContains the second line of either        PA42.1  PA42.3
                                                                 PA502   PA535
                       (1) a description of the job and
                       position on the requisition, or
                       (2) any other information the you want.
PJR-SHORT-DESC3        Alpha 30  (Lower Case)                    PA02.1  PA102
Element: Short DescriptContains the third line of either         PA42.1  PA42.3
                                                                 PA502   PA535
                       (1) a description of the job and
                       position on the requisition, or
                       (2) any other information the you want.
PJR-SPEC-REQ1          Alpha 30  (Lower Case)                    PA02.1  PA102
Special                Contains the first line of either         PA42.1  PA42.3
Requirements 1                                                   PA502   PA535
                       (1) a description of the requirements
                       of the job and position on the
                       requisition, or
                       (2) any other information you want.
PJR-SPEC-REQ2          Alpha 30  (Lower Case)                    PA02.1  PA102
Special                Contains the second line of either        PA42.1  PA42.3
Requirements 2                                                   PA502   PA535
                       (1) a description of the requirements
                       of the job and position on the
                       requisition, or
                       (2) any other information the you want.
PJR-SPEC-REQ3          Alpha 30  (Lower Case)                    PA02.1  PA102
Special                Contains the first line of either         PA42.1  PA42.3
Requirements 3                                                   PA502   PA535
                       (1) a description of the requirements
                       of the job and position on the
                       requisition, or
                       (2) any other information you want.
PJR-LAST-CMT-SEQ       Numeric 4                                 PA46.1
Last Comment           Contains the sequence number of the
Sequence Number        last comment.
PJR-OPEN-FTE           Signed 11.6                               PA02.1  PA102
Element: Open FTE      Contains the total FTE for all open       PA42.1  PA42.3
                       requisitions for a job.                   PA502   PA535
PJR-FILLED-FTE         Signed 11.6                               HR11.1  PA02.1
Element: Filled FTE    Contains the FTE for requisitions which   PA102   PA42.1
                       have been filled for a job.               PA42.3  PA45.1
                                                                 PA502   PA535
PJR-SHIFT              Numeric 1                                 PA02.1  PA102
Element: Shift         Contains the shift number associated      PA42.1  PA42.3
                       with the pay.                             PA502   PA535
                       1 = Shift 1
                       2 = Shift 2
                       3 = Shift 3
                       4 = Shift 4
                       5 = Shift 5
                       6 = Shift 6
                       7 = Shift 7
                       8 = Shift 8
                       9 = Shift 9
PJR-EFFECT-DATE        Numeric 8  (yyyymmdd)                     PA02.1  PA102
Element: Effective DateContains the effective date of the        PA42.1  PA42.3
                       information about this requisition. Job   PA502   PA535
                       requisition changes are not kept
                       historically at this time. This field is
                       primarily  used to provide consistency
                       in the look of the form.
PJR-POS-EFFECT-DAT     Numeric 8  (yyyymmdd)                     PA02.1  PA102
Element: Pos Effect DatContains the effective date for the       PA42.1  PA42.3
                       position.                                 PA502   PA535
PJR-DATE-STAMP         Numeric 8  (yyyymmdd)                     PA02.1  PA102
Element: Date Stamp    This field contains the server date       PA42.1  PA42.3
                       (month, date, and year) of the last       PA45.1  PA502
                       change to this record.                    PA535
PJR-TIME-STAMP         Numeric 6  (hhmmss)                       PA02.1  PA102
Element: Time Stamp    Contains the server time (hour, minute,   PA42.1  PA42.3
                       and second) when the record was last      PA45.1  PA502
                       changed.                                  PA535
PJR-USER-ID            Alpha 10  (Lower Case)                    PA02.1  PA102
Element: User                                                    PA42.1  PA42.3
                                                                 PA45.1  PA502
                                                                 PA535
PJR-REMAINING-OPEN     Derived
Element: Remaining OpenContains the number of open
                       requisitions remaining for a job.
PJR-REMAINING-FTE      Derived
Element: Remaining FTE Contains the FTE remaining before total
                       budgeted FTE for a job is met.
PJR-CURRENCY-CODE      Alpha 5                                   PA02.1  PA102
Element: Currency Code Contains the currency in which the        PA42.1  PA42.3
                       salary is recorded.                       PA502   PA535
PJR-CURR-ND            Numeric 1                                 PA02.1  PA102
Element: Acct Nd       The number of decimals assigned to a      PA42.1  PA42.3
                       particular account as determined by the   PA502   PA535
                       account currency.
PJR-CURR-CODE-2        Alpha 5                                   PA44.1
Element: Curr Code 2   Contains the currency in which
                       requisition costs are recorded.
PJR-CURR-CODE-ND-2     Numeric 1                                 PA44.1
Element: Acct Nd       The number of decimals assigned to a
                       particular account as determined by the
                       account currency.
PJR-BASE-BEG-PAY       Signed 11.2                               PA02.1  PA102
Element: Salary        Contains the beginning pay in the         PA42.1  PA42.3
                       company's base currency.                  PA502   PA535
PJR-BASE-END-PAY       Signed 11.2                               PA02.1  PA102
Element: Salary        Contains the ending pay in the            PA42.1  PA42.3
                       company's base currency.                  PA502   PA535
PJR-BASE-CURRENCY      Alpha 5                                   PA02.1  PA102
Element: Base Currency Contains the company base currency.       PA42.1  PA42.3
                                                                 PA44.1  PA502
                                                                 PA535
PJR-BASE-ND            Numeric 1                                 PA02.1  PA102
Element: Base Nd       The number of decimal positions defined   PA42.1  PA42.3
                       for the company base currency.            PA44.1  PA502
                                                                 PA535
PJR-BASE-AMOUNT        Signed 15.2                               PA44.1
Element: Base Amt      Contains the amount in the company's
                       base currency.
PJR-APPROVAL-FLAG      Alpha 1                                   PA02.1  PA102
Element: Approval Flag " " = Yes                                 PA42.1  PA42.3
                       N = No                                    PA502   PA535
                       Y = Yes
PJR-WF-PEND-REQ        Derived
Element: Wf Pend Req
PJR-LABEL-NAME         Derived
Element: Label Name
                         PAJOBREQ FILE INDEX
NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN
PJRSET1   COMPANY                                                HPJR.1  HR11.1
          REQUISITION                                            HR170   HR70.1
                                                                 PA02.1  PA03.2
                                                                 PA100   PA102
                                                                 PA111   PA115
                                                                 PA120   PA231
                                                                 PA241   PA242
                                                                 PA243   PA244
                                                                 PA406   PA41.1
                                                                 PA42.1  PA42.3
                                                                 PA43.1  PA43.2
                                                                 PA44.1  PA45.1
                                                                 PA46.1  PA502
                                                                 PA52.4  PA531
                                                                 PA532   PA535
                                                                 ...
PJRSET2   COMPANY       KeyChange, Subset                        PA02.1  PA102
          POSITION      Where (POSITION != Spaces )              PA211   PA272
          REQUISITION                                            PA302   PA402
                                                                 PA406   PA502
                                                                 PA64.2  PA65.2
                                                                 SNEM.1
PJRSET3   COMPANY       KeyChange, Subset                        PA211   PA272
          PROCESS-LEVEL Where (POSITION = Spaces )
          DEPARTMENT
          JOB-CODE
          REQUISITION
PJRSET4   COMPANY       KeyChange                                PA64.1  PA65.1
          JOB-CODE
          REQUISITION
PJRSET5   COMPANY       KeyChange, Subset
          SUPERVISOR    Where SUPERVISOR != Spaces
          REQUISITION
                         PAJOBREQ FILE RELATIONS
ONE TO ONE RELATIONS
RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH
App Status     EMSTATUS     Required
                            When PJR-APP-STATUS != Spaces
                            PJR-COMPANY           -> EMS-COMPANY
                            PJR-APP-STATUS        -> EMS-EMP-STATUS
Approval Emp   EMPLOYEE     Required
                            When PJR-APPROVAL-EMP != Zeroes
                            PJR-COMPANY           -> EMP-COMPANY
                            PJR-APPROVAL-EMP      -> EMP-EMPLOYEE
Bargain Unit   PCODES       Required
                            When PJR-BARGAIN-UNIT != Spaces
                            "BU"                  -> PCO-TYPE
                            PJR-BARGAIN-UNIT      -> PCO-CODE
Base Currency  CUCODES      Required
                            When PJR-CURRENCY-CODE != Spaces
                            Or   PJR-CURR-CODE-2   != Spaces
                            PJR-CURRENCY-CODE     -> CUC-CURRENCY-CODE
Company        PRSYSTEM     Required
                            PJR-COMPANY           -> PRS-COMPANY
                            Spaces                -> PRS-PROCESS-LEVEL
Contact Nbr    EMPLOYEE     Required
                            When PJR-CONTACT-NBR != Zeroes
                            PJR-COMPANY           -> EMP-COMPANY
                            PJR-CONTACT-NBR       -> EMP-EMPLOYEE
Currency       CUCODES      Required
                            When (PJR-CURRENCY-CODE != Spaces )
                            PJR-CURRENCY-CODE     -> CUC-CURRENCY-CODE
Currency2      CUCODES      Required
                            When (PJR-CURR-CODE-2 != Spaces )
                            PJR-CURR-CODE-2       -> CUC-CURRENCY-CODE
Department     DEPTCODE     Required
                            When PJR-DEPARTMENT != Spaces
                            PJR-COMPANY           -> DPT-COMPANY
                            PJR-PROCESS-LEVEL     -> DPT-PROCESS-LEVEL
                            PJR-DEPARTMENT        -> DPT-DEPARTMENT
Job Code       JOBCODE      Required
                            When PJR-JOB-CODE != Spaces
                            PJR-COMPANY           -> JBC-COMPANY
                            PJR-JOB-CODE          -> JBC-JOB-CODE
Location       PCODES       Required
                            When PJR-LOCAT-CODE != Spaces
                            "LO"                  -> PCO-TYPE
                            PJR-LOCAT-CODE        -> PCO-CODE
Pos Date       PAPOSITION   Required
                            When (PJR-POSITION != Spaces )
                            PJR-COMPANY           -> POS-COMPANY
                            PJR-POSITION          -> POS-POSITION
                            PJR-POS-EFFECT-DAT    -> POS-EFFECT-DATE
Process Level  PRSYSTEM     Required
                            When PJR-PROCESS-LEVEL != Spaces
                            PJR-COMPANY           -> PRS-COMPANY
                            PJR-PROCESS-LEVEL     -> PRS-PROCESS-LEVEL
Rep Employee   EMPLOYEE     Required
                            When PJR-REP-EMPLOYEE != Zeroes
                            PJR-COMPANY           -> EMP-COMPANY
                            PJR-REP-EMPLOYEE      -> EMP-EMPLOYEE
Req Status     PCODES       Required
                            When PJR-REQ-STATUS != Spaces
                            "RQ"                  -> PCO-TYPE
                            PJR-REQ-STATUS        -> PCO-CODE
Request By     EMPLOYEE     Required
                            When PJR-REQUEST-BY != Zeroes
                            PJR-COMPANY           -> EMP-COMPANY
                            PJR-REQUEST-BY        -> EMP-EMPLOYEE
Supervisor     HRSUPER      Required
                            When PJR-SUPERVISOR != Spaces
                            PJR-COMPANY           -> HSU-COMPANY
                            PJR-SUPERVISOR        -> HSU-CODE
Union Code     PCODES       Required
                            When PJR-UNION-CODE != Spaces
                            "UN"                  -> PCO-TYPE
                            PJR-UNION-CODE        -> PCO-CODE
User Level     PCODES       Not Required
                            Valid When PJR-USER-LEVEL != Spaces
                            "UL"                  -> PCO-TYPE
                            PJR-USER-LEVEL        -> PCO-CODE
                         PAJOBREQ FILE RELATIONS
ONE TO MANY RELATIONS
RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH
Applicants     PAREQAPP     Delete Cascades
                            PJR-COMPANY           -> PRA-COMPANY
                            PJR-REQUISITION       -> PRA-REQUISITION
                                                     PRA-EMP-APP
                                                     PRA-APPLICANT
Comments       PACOMMENTS   Delete Cascades
                            PJR-COMPANY           -> PAC-COMPANY
                            2                     -> PAC-EMP-APP
                            "JR"                  -> PAC-CMT-TYPE
                            Zeroes                -> PAC-EMPLOYEE
                                                     PAC-JOB-CODE
                                                     PAC-ACTION-CODE
                                                     PAC-LN-NBR
                                                     PAC-SEQ-NBR
Cost           PAREQCOST    Delete Cascades
                            PJR-COMPANY           -> PRC-COMPANY
                            PJR-REQUISITION       -> PRC-REQUISITION
                                                     PRC-DATE
                                                     PRC-REASON
                                                     PRC-EMP-APP
                                                     PRC-APPLICANT
Ext Applicants PAREQAPP
                            PJR-COMPANY           -> PRA-COMPANY
                            PJR-REQUISITION       -> PRA-REQUISITION
                            1                     -> PRA-EMP-APP
                                                     PRA-APPLICANT
Grade Step     PRSAGDTL
                            Valid When (PJR-SCHEDULE  != Spaces )
                                  And  (PJR-PAY-GRADE != Spaces )
                                  And  (PJR-PAY-STEP  != Zeroes )
                            PJR-COMPANY           -> SGD-COMPANY
                            PJR-SCHEDULE          -> SGD-SCHEDULE
                            PJR-PAY-GRADE         -> SGD-PAY-GRADE
                            PJR-PAY-STEP          -> SGD-PAY-STEP
                                                     SGD-EFFECT-DATE
Int Applicants PAREQAPP
                            PJR-COMPANY           -> PRA-COMPANY
                            PJR-REQUISITION       -> PRA-REQUISITION
                            Zeroes                -> PRA-EMP-APP
                                                     PRA-APPLICANT
Offers         PAREQOFFER   Delete Cascades
                            PJR-COMPANY           -> PRF-COMPANY
                            PJR-REQUISITION       -> PRF-REQUISITION
                                                     PRF-EMP-APP
                                                     PRF-APPLICANT
                                                     PRF-DATE
                                                     PRF-OFFER-TYPE
Pos Chg Error  PAPOSERR     Delete Cascades
                            Valid When (PJR-POSITION != Spaces )
                            PJR-COMPANY           -> PPE-COMPANY
                            Zeroes                -> PPE-EMPLOYEE
                            PJR-REQUISITION       -> PPE-REQUISITION
                            PJR-POSITION          -> PPE-POSITION
                                                     PPE-EFFECT-DATE
                                                     PPE-UPDATE-TYPE
Pos Rules      PAPOSRULE
                            PJR-COMPANY           -> PPR-COMPANY
                            PJR-PROCESS-LEVEL     -> PPR-PROCESS-LEVEL
                            PJR-DEPARTMENT        -> PPR-DEPARTMENT
                                                     PPR-EFFECT-DATE
Position       PAPOSITION   Required
                            When (PJR-POSITION != Spaces )
                            PJR-COMPANY           -> POS-COMPANY
                            PJR-POSITION          -> POS-POSITION
                                                     POS-EFFECT-DATE
Sched Grade    PRSAGDTL
                            Valid When (PJR-SCHEDULE  != Spaces )
                                  And  (PJR-PAY-GRADE != Spaces )
                                  And  (PJR-PAY-STEP  =  Zeroes )
                            PJR-COMPANY           -> SGD-COMPANY
                            PJR-SCHEDULE          -> SGD-SCHEDULE
                            PJR-PAY-GRADE         -> SGD-PAY-GRADE
                                                     SGD-PAY-STEP
                                                     SGD-EFFECT-DATE
Schedule       PRSAGHEAD
                            Valid When (PJR-SCHEDULE != Spaces )
                                  And  (PJR-PAY-STEP =  Zeroes )
                            PJR-COMPANY           -> SGH-COMPANY
                            "G"                   -> SGH-INDICATOR
                            PJR-SCHEDULE          -> SGH-SCHEDULE
                                                     SGH-EFFECT-DATE
Work Schedule  HRWRKSCHD
                            Valid When PJR-WORK-SCHED != Spaces
                            PJR-COMPANY           -> WSC-COMPANY
                            PJR-WORK-SCHED        -> WSC-WORK-SCHED
                                                     WSC-EFFECT-DATE
 |