Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAJOBREQ


                             PAJOBREQ FILE

                            Job Requisition

The Job Requisition file contains information about job or position
requisitions.

REFERENCED BY

HPJR.1    HR170     HR70.1    PA03.2    PA111     PA231
PA241     PA242     PA243     PA244     PA406     PA52.4
PA532     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     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: Bargaining 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  PA535
                       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          Contains the user ID of the person who    PA42.1  PA42.3
                       last changed this record.                 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
Account Currency       Represents the number of decimals         PA42.1  PA42.3
Code                   defined for the currency of the object.   PA502   PA535

PJR-CURR-CODE-2        Alpha 5                                   PA44.1  PA535
Report Currency 2      Contains the currency in which
Code                   requisition costs are recorded.

PJR-CURR-CODE-ND-2     Numeric 1                                 PA44.1  PA535
Account Currency       The number of decimal positions defined
Code                   for Report Currency 2.


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
Base Number Of         The number of decimal positions defined   PA42.1  PA42.3
Decimals               for the company base currency.            PA44.1  PA502
                                                                 PA535

PJR-BASE-AMOUNT        Signed 15.2                               PA44.1  PA535
Element: Base Amount   Contains the amount in the company's
                       base currency.

PJR-APPROVAL-FLAG      Alpha 1                                   PA02.1  PA102
Element: Approval      " " = 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
                                                                 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
                                                                 PA532   PA535

PJRSET2   COMPANY       KeyChange, Subset                        PA02.1  PA102
          POSITION      Where (POSITION != Spaces )              PA211   PA272
          REQUISITION                                            PA302   PA402
                                                                 PA406   PA502
                                                                 PA64.2  PA65.2

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