Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAPOSITION


                            PAPOSITION FILE

                               Positions

The Personnel Position Parameters file contains information for each position.

REFERENCED BY

HCHP.1    HAP3.1    HEP4.1    HPOS.1    HPQC.1    HPRS.1
HR11.1    HR11.2    HR14.1    HR15.1    HR15.2    HR155
HR170     HR211     HR511     HR514     HR515     HR54.1
HR55.2    HR70.1    HRS1.1    HRSC.1    PA01.1    PA01.2
PA01.3    PA03.1    PA03.2    PA03.3    PA08.1    PA08.2
PA08.3    PA100     PA11.1    PA113     PA115     PA120
PA13.1    PA13.2    PA13.3    PA16.1    PA170     PA172
PA20.1    PA201     PA21.1    PA22.1    PA23.1    PA231
PA24.1    PA242     PA262     PA263     PA27.1    PA272
PA31.1    PA34.1    PA35.1    PA36.1    PA37.1    PA371
PA38.1    PA406     PA41.1    PA42.1    PA42.3    PA513
PA52.1    PA52.3    PA52.4    PA52.5    PA520     PA53.1
PA532     PA535     PA54.1    PA570     PA66.3    PA70.1
PA72.1    PA79.1    TR21.1    TR22.1    TR26.1    TR500
HS01.1    HS34.1    HS36.1    PR110     PR113     PR120
PR13.1    PR13.5    PR13.6    PR13.8    PR30.1    PRSC.1
BN150     HCDL.1    HCEM.1    HCPO.1    HR217     HR220
HS10.1    HS10.2    HS11.1    HS50.1    HS50.2    HS50.5
PA103     PA149     PA182     PA202     PA208     PA210
PA211     PA223     PA241     PA248     PA249     PA271
PA296     PA311     PA48.3    PA48.4    PA495     PA496
PA531     PA534     PA62.1    PA63.1    PA65.2    PA65.1
PA82.1    PA96.1    PR128     PR130     PR131     PR132
PR134     PR136     PR160     PR180     PR223     PR23.3
PR29.1    PR32.2    PR33.2    PR33.3    PR35.1    PR35.2
PR35.3    PR35.4    PR35.5    PR35.6    PR35.8    PR35.9
PR36.1    PR45.1    PR529     PR530     PR560     PR82.1
PR82.2    UK102     TA147     TM240     TM245     TM470
TP135     PA402     PA80.1    HS51.1    HS51.2    HS52.1
HS52.2    PA64.1    PA64.2    TR120     TR121     TR20.1
TR20.2    TR20.3

UPDATED BY

PA02.1    PA102     PA302     PA502     HR00.1    HR01.1
PBIP.1    PR197

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

POS-COMPANY            Numeric 4                                 PA02.1  PA170
Element: Company       Contains the company number which         PA371   PA502
                       represents an established company.

POS-POSITION           Alpha 12                                  PA02.1  PA170
Element: Position      Contains the user-defined code that       PA371   PA502
                       represents a position in the company.

POS-DESCRIPTION        Alpha 30  (Lower Case)                    PA02.1  PA102
Element: Description   Contains the description of the           PA502
                       position.

POS-POSIT-STATUS       Numeric 1                                 PA02.1  PA502
Element: Position StatuContains a value that indicates the
                       status of a position.
                       1 = Active
                       2 = Temporary
                       3 = Frozen
                       4 = Proposed
                       5 = Inactive

POS-EFFECT-DATE        Numeric 8  (yyyymmdd)                     PA02.1  PA170
Element: Effective DateContains the date the position is         PA371   PA502
                       available to be used.

POS-END-DATE           Numeric 8  (yyyymmdd)                     PA02.1  PA102
Element: End Date      Contains the ending date when the         PA502
                       position is no longer available to be
                       used.

POS-JOB-CODE           Alpha 9                                   PA02.1  PA262
Element: Job Code      Contains the job code.                    PA263   PA502

POS-PROCESS-LEVEL      Alpha 5                                   PA02.1  PA502
Element: Process Level Contains the process Level.

POS-DEPARTMENT         Alpha 5                                   PA02.1  PA502
Element: Department    Contains the department.

POS-USER-LEVEL         Alpha 10                                  PA02.1  PA502
Element: User Level    Contains the user level.

POS-EXP-COMPANY        Numeric 4                                 PA02.1  PA502
Element: Expense CompanContains the general ledger expense
                       company.

POS-EXP-ACCT-UNIT      Alpha 15                                  PA02.1  PA502
Expense Accounting     Contains the expense account unit.
Unit

POS-EXP-ACCOUNT        Numeric 6                                 PA02.1  PA502
Element: Expense AccounContains the expense account.

POS-EXP-SUB-ACCT       Numeric 4                                 PA02.1  PA502
Element: Expense SubaccContains the expense subaccount.

POS-PAY-RATE           Signed 13.4                               PA02.1  PA502
Element: Pay Rate      Contains the rate of pay for a
                       position. This can be an annual amount
                       or an hourly amount.

POS-SALARY-CLASS       Alpha 1                                   PA02.1  PA502
Element: Salary Class  Contains the code that indicates
                       whether the rate of pay is hourly or
                       salaried.
                       H = Hourly
                       S = Salaried

POS-PAY-FREQUENCY      Numeric 1                                 PA02.1  PA502
Element: Pay Frequency Contains the pay frequency.
                       1 = Weekly
                       2 = Biweekly
                       3 = Semimonthly
                       4 = Monthly
                       5 = UK Four-Weekly

POS-SCHEDULE           Alpha 9                                   PA02.1  PA502
Element: Schedule      Contains the step and grade schedule or
                       the grade range schedule.

POS-PAY-GRADE          Alpha 3                                   PA02.1  PA502
Element: Pay Grade     Contains the appropriate grade if the
                       position is paid based on a step and
                       grade schedule or is assigned to a grade
                       range schedule.

POS-PAY-STEP           Numeric 2                                 PA02.1  PA502
Element: Step          Contains the appropriate step if the
                       position is based on a step and grade
                       schedule.

POS-SUPERVISOR         Alpha 10                                  PA02.1  PA502
Element: Supervisor    Contains the supervisor code that
                       identifies the supervisor to whom the
                       position reports.

POS-SHIFT              Numeric 1                                 PA02.1  PA502
Element: Shift         Contains the shift with which the
                       position's pay is associated.
                       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

POS-UPDATE-FLAG        Alpha 1                                   PA02.1  PA102
Element: Update Flag   Contains a yes or no value that           PA502
                       indicates when the user would like to
                       update  employee and requisition records
                       to reflect changes being made to the
                       position.

                       If the user selects Yes, updates will
                       be made to employee and requisition
                       records when the change is complete. If
                       the user selects No, an update program
                       must be run to update records with the
                       changes.
                       Y = Needs to be Updated

POS-LOCAT-CODE         Alpha 10                                  PA02.1  PA502
Element: Location      Contains the default location at which
                       this position works.

POS-UNION-CODE         Alpha 10                                  PA02.1  PA502
Element: Union Code

POS-BARGAIN-UNIT       Alpha 10                                  PA02.1  PA502
Element: Bargaining Unit

POS-CHG-REASON         Alpha 10                                  PA02.1  PA502
Element: Reason        Contains the reason for a change to a
                       position.

POS-ACTIVITY           Alpha 15                                  PA02.1  PA502
Element: Activity      Activities are the processes or
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


POS-ACCT-CATEGORY      Alpha 5                                   PA02.1  PA502
Element: Account CategoAccount categories are groupings of
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

POS-OT-PLAN-CODE       Alpha 4                                   PA02.1  PA502
Element: Pay Plan      Contains the pay plan with which the
                       position is associated.

POS-SUPERVISOR-IND     Alpha 10                                  PA02.1  PA502
Element: Indirect SuperContains the supervisor code that
                       identifies the supervisor to whom the
                       position indirectly reports.

POS-SUPERVISOR-LNK     Alpha 10                                  PA02.1  PA502
Element: Supervisor LinContains the supervisor code to which
                       the position is linked. Changes to the
                       incumbents of this position will result
                       in an update to the employee assigned to
                       the supervisor code.

POS-WORK-SCHED         Alpha 10                                  PA02.1  PA502
Element: Work Schedule Contains the default work schedule for
                       this position.

POS-EXEMPT-EMP         Alpha 1                                   PA02.1  PA502
Element: Exempt        Contains a value that indicates if the
                       rate of pay is hourly or salaried.
                       Y = Yes
                       N = No

POS-SEC-LVL            Numeric 1                                 PA02.1  PA502
Element: Security LevelContains a number between 1 and 9 that
                       indicates the security level for this
                       position.

POS-SEC-LOCATION       Alpha 10                                  PA02.1  PA502
Element: Security LocatContains the security location that is
                       used in combination with the security
                       level to define employee and data item
                       security. Location can represent a
                       physical location, or it can represent a
                       group of employees, such as hourly or
                       salaried employees.

POS-DATE-STAMP         Numeric 8  (yyyymmdd)                     PA02.1  PA102
Element: Date Stamp    Contains the date (month, day, and        PA502
                       year) a change was made to the record.

POS-TIME-STAMP         Numeric 6  (hhmmss)                       PA02.1  PA102
Element: Time Stamp    Contains the time (hour, minute, and      PA502
                       second) that a change was made to the
                       record.

POS-USER-ID            Alpha 10  (Lower Case)                    PA02.1  PA102
Element: User ID       Contains the user ID of a user who has    PA502
                       made changes to the record.

POS-OBJ-ID             Numeric 12                                PA02.1  PA502
Object                 This is the object identifier.
Identification

POS-ANNUAL-HOURS       Numeric 4                                 PA02.1  PA502
Element: Annual Hours  Contains the annual hours for the
                       position.

POS-SHORT-DESC         Derived
Element: Short DescriptA short description.

POS-CURRENCY-CODE      Alpha 5                                   PA02.1  PA502
Element: Currency Code Contains the currency in which the pay
                       is recorded.

POS-CURR-ND            Numeric 1                                 PA02.1  PA502
Account Currency       Represents the number of decimals
Code                   defined for the currency of the object.

POS-BASE-CURRENCY      Alpha 5                                   PA02.1  PA502
Element: Base Currency Contains the company's base currency.

POS-BASE-ND            Numeric 1                                 PA02.1  PA502
Base Number Of         The number of decimal positions defined
Decimals               for the company base currency.

POS-BASE-PAY-RATE      Signed 13.4                               PA02.1  PA502
Element: Rate of Pay   Contains the pay in the company's base
                       currency.

POS-ENCUMBER-FLAG      Alpha 1                                   PA02.1  PA502
Element: Encumber Flag " " = No
                       N = No
                       Y = Yes

                         PAPOSITION FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

POSSET1   COMPANY                                                HCHP.1  HAP3.1
          POSITION                                               HEP4.1  HPOS.1
          EFFECT-DATE                                            HPQC.1  HPRS.1
                                                                 HR00.1  HR01.1
                                                                 HR11.1  HR11.2
                                                                 HR14.1  HR15.1
                                                                 HR15.2  HR155
                                                                 HR170   HR211
                                                                 HR511   HR514
                                                                 HR515   HR54.1
                                                                 HR55.2  HR70.1
                                                                 HRS1.1  HRSC.1
                                                                 PA01.1  PA01.2
                                                                 PA01.3  PA02.1
                                                                 PA03.1  PA03.2
                                                                 ...

POSSET2   COMPANY                                                BN150   HCDL.1
          POSITION                                               HCEM.1  HCPO.1
          EFFECT-DATE*                                           HAP3.1  HEP4.1
                                                                 HPOS.1  HPQC.1
                                                                 HPRS.1  HR11.1
                                                                 HR11.2  HR14.1
                                                                 HR15.1  HR155
                                                                 HR170   HR211
                                                                 HR217   HR220
                                                                 HR511   HR514
                                                                 HR515   HR54.1
                                                                 HR55.2  HR70.1
                                                                 HRS1.1  HRSC.1
                                                                 HS10.1  HS10.2
                                                                 HS11.1  HS50.1
                                                                 ...

POSSET3   COMPANY       KeyChange                                HPOS.1  PA402
          PROCESS-LEVEL                                          PA80.1
          DEPARTMENT
          POSITION
          EFFECT-DATE*

POSSET4   COMPANY       Subset                                   HS50.1  HS50.2
          POSITION      Where END-DATE = Zeroes                  HS51.1  HS51.2
          EFFECT-DATE                                            HS52.1  HS52.2
                                                                 PA262   PA263
                                                                 PA62.1  PA63.1
                                                                 PA64.1  PA64.2
                                                                 PA65.1  PA65.2
                                                                 TR120   TR121
                                                                 TR20.1  TR20.2
                                                                 TR20.3  TR21.1
                                                                 TR22.1  TR26.1
                                                                 TR500

POSSET6   COMPANY       KeyChange
          OBJ-ID
          EFFECT-DATE

                         PAPOSITION FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acct Cat       ACACCTCAT    Required
                            When (POS-ACCT-CATEGORY != Spaces )

                            POS-ACCT-CATEGORY     -> AAX-ACCT-CATEGORY

Activity       ACACTIVITY   Required
                            When (POS-ACTIVITY != Spaces )

                            POS-ACTIVITY          -> ACV-ACTIVITY

Assign Res     PAASSIGNED   Not Required

                            POS-COMPANY           -> PAA-COMPANY
                            POS-POSITION          -> PAA-POSITION
                            Spaces                -> PAA-PROCESS-LEVEL
                            Spaces                -> PAA-DEPARTMENT
                            Spaces                -> PAA-JOB-CODE

Bargain Unit   PCODES       Required
                            When POS-BARGAIN-UNIT != Spaces

                            "BU"                  -> PCO-TYPE
                            POS-BARGAIN-UNIT      -> PCO-CODE

Base Currency  CUCODES      Required
                            When POS-CURRENCY-CODE != Spaces

                            POS-BASE-CURRENCY     -> CUC-CURRENCY-CODE

Chg Reason     PCODES       Required
                            When (POS-CHG-REASON != Spaces )

                            "PO"                  -> PCO-TYPE
                            POS-CHG-REASON        -> PCO-CODE

Company        PRSYSTEM     Required

                            POS-COMPANY           -> PRS-COMPANY
                            Spaces                -> PRS-PROCESS-LEVEL

Currency       CUCODES      Required
                            When POS-CURRENCY-CODE != Spaces

                            POS-CURRENCY-CODE     -> CUC-CURRENCY-CODE

Department     DEPTCODE     Required
                            When (POS-DEPARTMENT != Spaces )

                            POS-COMPANY           -> DPT-COMPANY
                            POS-PROCESS-LEVEL     -> DPT-PROCESS-LEVEL
                            POS-DEPARTMENT        -> DPT-DEPARTMENT

Exp Account    GLMASTER     Required
                            When (POS-EXP-ACCT-UNIT != Spaces )
                            Or   (POS-EXP-ACCOUNT   != Zeroes )

                            POS-EXP-COMPANY       -> GLM-COMPANY
                            POS-EXP-ACCT-UNIT     -> GLM-ACCT-UNIT
                            POS-EXP-ACCOUNT       -> GLM-ACCOUNT
                            POS-EXP-SUB-ACCT      -> GLM-SUB-ACCOUNT

Indir Supv     HRSUPER      Required
                            When (POS-SUPERVISOR-IND != Spaces )

                            POS-COMPANY           -> HSU-COMPANY
                            POS-SUPERVISOR-IND    -> HSU-CODE

Job Code       JOBCODE      Required
                            When (POS-JOB-CODE != Spaces )

                            POS-COMPANY           -> JBC-COMPANY
                            POS-JOB-CODE          -> JBC-JOB-CODE

Location       PCODES       Required
                            When POS-LOCAT-CODE != Spaces

                            "LO"                  -> PCO-TYPE
                            POS-LOCAT-CODE        -> PCO-CODE

Process Level  PRSYSTEM     Required
                            When (POS-PROCESS-LEVEL != Spaces )

                            POS-COMPANY           -> PRS-COMPANY
                            POS-PROCESS-LEVEL     -> PRS-PROCESS-LEVEL

Supervisor     HRSUPER      Required
                            When POS-SUPERVISOR != Spaces

                            POS-COMPANY           -> HSU-COMPANY
                            POS-SUPERVISOR        -> HSU-CODE

Supervisor Ind HRSUPER      Required
                            When (POS-SUPERVISOR-IND != Spaces )

                            POS-COMPANY           -> HSU-COMPANY
                            POS-SUPERVISOR-IND    -> HSU-CODE

Supv Link      HRSUPER      Required
                            When (POS-SUPERVISOR-LNK != Spaces )

                            POS-COMPANY           -> HSU-COMPANY
                            POS-SUPERVISOR-LNK    -> HSU-CODE

Union Code     PCODES       Required
                            When POS-UNION-CODE != Spaces

                            "UN"                  -> PCO-TYPE
                            POS-UNION-CODE        -> PCO-CODE

User Level     PCODES       Required
                            When POS-USER-LEVEL != Spaces

                            "UL"                  -> PCO-TYPE
                            POS-USER-LEVEL        -> PCO-CODE

                         PAPOSITION FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Budget         PABUDGET

                            POS-COMPANY           -> PAB-COMPANY
                            POS-POSITION          -> PAB-POSITION
                                                     PAB-EFFECT-DATE
                                                     PAB-PROCESS-LEVEL
                                                     PAB-DEPARTMENT
                                                     PAB-JOB-CODE

Class Pos      PACLASSPOS

                            POS-COMPANY           -> PQP-COMPANY
                                                     PQP-POS-CLASS
                                                     PQP-POSITION

Emp Pos Hist   PAEMPPOS

                            POS-COMPANY           -> PEP-COMPANY
                            POS-POSITION          -> PEP-POSITION
                                                     PEP-EMPLOYEE
                                                     PEP-POS-LEVEL
                                                     PEP-EFFECT-DATE

Grade          PRSAGDTL     Required
                            When (POS-SCHEDULE  != Spaces )
                            And  (POS-PAY-GRADE != Spaces )
                            And  (POS-PAY-STEP  =  Zeroes )

                            POS-COMPANY           -> SGD-COMPANY
                            POS-SCHEDULE          -> SGD-SCHEDULE
                            POS-PAY-GRADE         -> SGD-PAY-GRADE
                                                     SGD-PAY-STEP
                                                     SGD-EFFECT-DATE

Hist Err       HISTERR

                            POS-COMPANY           -> HER-COMPANY
                            Zeroes                -> HER-EMPLOYEE
                            POS-OBJ-ID            -> HER-OBJ-ID
                                                     HER-EFFECT-DATE
                                                     HER-ACTION-CODE
                                                     HER-ACTION-NBR
                                                     HER-FLD-NBR
                                                     HER-SEQ-NBR

Hr Hist Dt     HRHISTORY    Delete Cascades

                            POS-COMPANY           -> HRH-COMPANY
                            Zeroes                -> HRH-EMPLOYEE
                            POS-OBJ-ID            -> HRH-OBJ-ID
                            Zeroes                -> HRH-POS-LEVEL
                            POS-EFFECT-DATE       -> HRH-BEG-DATE
                                                     HRH-FLD-NBR
                                                     HRH-SEQ-NBR

Hrhistory      HRHISTORY

                            POS-COMPANY           -> HRH-COMPANY
                            Zeroes                -> HRH-EMPLOYEE
                            POS-OBJ-ID            -> HRH-OBJ-ID
                                                     HRH-FLD-NBR
                                                     HRH-POS-LEVEL
                                                     HRH-BEG-DATE
                                                     HRH-SEQ-NBR

Job Auth Appl  JOBAUTH

                            POS-COMPANY           -> JBA-COMPANY
                            1                     -> JBA-EMP-APP
                            Spaces                -> JBA-JOB-CODE
                            POS-POSITION          -> JBA-POSITION
                                                     JBA-EMPLOYEE

Job Auth Emp   JOBAUTH

                            POS-COMPANY           -> JBA-COMPANY
                            Zeroes                -> JBA-EMP-APP
                            Spaces                -> JBA-JOB-CODE
                            POS-POSITION          -> JBA-POSITION
                                                     JBA-EMPLOYEE

Job Relations  JOBRELATE

                            POS-COMPANY           -> JBR-COMPANY
                            Spaces                -> JBR-PROCESS-LEVEL
                            Spaces                -> JBR-JOB-CODE
                            POS-POSITION          -> JBR-POSITION
                                                     JBR-TYPE
                                                     JBR-PERS-CODE
                                                     JBR-SUBJECT-CODE

Off Lang       PAOFFLANG

                            POS-COMPANY           -> PLA-COMPANY
                            Zeroes                -> PLA-EMPLOYEE
                            POS-POSITION          -> PLA-POSITION
                                                     PLA-REPORT-TYPE
                                                     PLA-SEQ-NBR

Ot Plan        PROVERTIME   Required
                            When (POS-OT-PLAN-CODE != Spaces )

                            POS-COMPANY           -> PRO-COMPANY
                            POS-OT-PLAN-CODE      -> PRO-PLAN-CODE
                                                     PRO-EFFECT-DATE

Paencumber     PAENCUMBER

                            POS-COMPANY           -> PEN-COMPANY
                            POS-POSITION          -> PEN-POSITION
                            Spaces                -> PEN-PROCESS-LEVEL
                            Spaces                -> PEN-DEPARTMENT
                            Spaces                -> PEN-JOB-CODE
                                                     PEN-EMPLOYEE
                                                     PEN-GLT-OBJ-ID
                                                     PEN-ATN-OBJ-ID

Pathfind       PATHFIND

                            POS-COMPANY           -> PTF-COMPANY
                            126                   -> PTF-FLD-NBR
                            POS-POSITION          -> PTF-FLD-VALUE
                                                     PTF-EMPLOYEE
                                                     PTF-POS-LEVEL

Pos Chg Error  PAPOSERR     Delete Cascades

                            POS-COMPANY           -> PPE-COMPANY
                            POS-POSITION          -> PPE-POSITION
                            POS-EFFECT-DATE       -> PPE-EFFECT-DATE
                                                     PPE-EMPLOYEE
                                                     PPE-REQUISITION
                                                     PPE-UPDATE-TYPE

Pos Classpos   PACLASSPOS

                            POS-COMPANY           -> PQP-COMPANY
                            POS-POSITION          -> PQP-POSITION
                                                     PQP-POS-CLASS

Pos Interest   PAJOBINTRS   Delete Cascades
                            Valid When POS-END-DATE = Zeroes

                            POS-COMPANY           -> PJI-COMPANY
                            Spaces                -> PJI-JOB-CODE
                            POS-POSITION          -> PJI-POSITION
                                                     PJI-EMP-APP
                                                     PJI-EMPLOYEE

Pos Rule       PAPOSRULE

                            POS-COMPANY           -> PPR-COMPANY
                            POS-PROCESS-LEVEL     -> PPR-PROCESS-LEVEL
                            POS-DEPARTMENT        -> PPR-DEPARTMENT
                                                     PPR-EFFECT-DATE

Pos User       HRPOSUSD     Delete Cascades

                            POS-COMPANY           -> HPD-COMPANY
                            "1 "                  -> HPD-TYPE
                            POS-OBJ-ID            -> HPD-OBJ-ID
                            POS-EFFECT-DATE       -> HPD-EFFECT-DATE
                                                     HPD-FIELD-KEY

Poschange      PAPOSCHG     Delete Cascades

                            POS-COMPANY           -> PPC-COMPANY
                            POS-POSITION          -> PPC-POSITION
                            POS-EFFECT-DATE       -> PPC-EFFECT-DATE
                                                     PPC-FLD-NBR

Requisition    PAJOBREQ

                            POS-COMPANY           -> PJR-COMPANY
                            POS-POSITION          -> PJR-POSITION
                                                     PJR-REQUISITION

Step And Grade PRSAGDTL     Required
                            When (POS-PAY-STEP != Zeroes )

                            POS-COMPANY           -> SGD-COMPANY
                            POS-SCHEDULE          -> SGD-SCHEDULE
                            POS-PAY-GRADE         -> SGD-PAY-GRADE
                            POS-PAY-STEP          -> SGD-PAY-STEP
                                                     SGD-EFFECT-DATE

User Fields    HRPOSUSD     Delete Cascades

                            POS-COMPANY           -> HPD-COMPANY
                            "1 "                  -> HPD-TYPE
                            POS-OBJ-ID            -> HPD-OBJ-ID
                            POS-EFFECT-DATE       -> HPD-EFFECT-DATE
                                                     HPD-FIELD-KEY

Work Sched     HRWRKSCHD
                            Valid When (POS-WORK-SCHED != Spaces )

                            POS-COMPANY           -> WSC-COMPANY
                            POS-WORK-SCHED        -> WSC-WORK-SCHED
                                                     WSC-EFFECT-DATE