Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRPAYCODE


                             PRPAYCODE FILE

                                Pay Code

The Pay Code file contains the user-defined pay codes. Pay codes define how
different types of pay are to be calculated, taxed, and where they are to be
expensed in the general ledger. The primary program that updates this file is
PR20.4 (Pay Code).

Pay is processed by assigning pay codes to time records. The process level
and job code fields are keys to the file so that multiple Pay Code Parameters
file records can exist for the same user-defined pay code. This allows use of
the same pay code with different rates or general ledger distributions. Upon
time record entry, the system looks for a pay code with all keys first, then
disregards the process level, then the job code, then both process level and
job code. The end result is that you can enter the same pay code multiple
times with the system finding the appropriate Pay Code Parameters file record
with the correct rate or general ledger distribution.

REFERENCED BY

BN150     BN215     ET700     ETI2.1    LP08.2    LP130
PR128     PR130     PR131     PR132     PR134     PR136
PR160     PR180     PR189     PR220     PR229     PR24.1
PR29.1    PR30.1    PR32.2    PR32.1    PR33.2    PR33.3
PR33.1    PR35.1    PR35.2    PR35.3    PR35.4    PR35.5
PR35.6    PR35.8    PR35.9    PR36.1    PR45.1    PR529
PR530     PR80.1    PR80.2    UK102     UK560     TA147
PR115     PR52.1    BN206     HPCD.1    HR14.1    HR250
HR514     PR21.1    HS01.1    HS02.1    PR139     PR23.1
PR23.3    PR25.2    PR26.1    PR28.1    PR37.1    PR46.2
PR47.1    PR514     UK46.2    UK47.1    TA40.2    TA40.3
TM01.1    BN134     BN66.1    HR170     HR70.1    PA495
PA82.1    PR135     PR137     PR140     PR141     PR198
PR260     PR261     PR262     PR295     PR51.3    PR70.1
PR89.1    UK141     TA146

UPDATED BY

BN06.1    BN15.1    ET530     HR25.1    PR195     PR197
PR20.4    PR560     PR82.1    PR85.1    HR00.1    HR01.1


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PCD-COMPANY            Numeric 4                                 HR25.1  PR20.4
Element: Company Hr

PCD-PROCESS-LEVEL      Alpha 5                                   BN150   ET530
Element: Process Lev HrContains the process level. You define    ETI2.1  HR25.1
                       the same pay code for different process   LP130   PR128
                       levels or limit the use of the pay code   PR130   PR131
                       to a specific process level.              PR132   PR134
                                                                 PR136   PR189
                                                                 PR20.4  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
                                                                 PR80.1  PR82.1
                                                                 TA147   UK102
                                                                 UK560

PCD-JOB-CODE           Alpha 9                                   BN150   ET530
Element: Job Code      Contains the job code. You can define     ETI2.1  HR25.1
                       the same pay code for different job       LP130   PR128
                       codes, or limit the use of the pay code   PR130   PR131
                       to a specific process level.              PR132   PR134
                                                                 PR136   PR189
                                                                 PR20.4  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
                                                                 PR80.1  PR82.1
                                                                 TA147   UK102
                                                                 UK560

PCD-PAY-CODE           Alpha 4                                   BN150   ET530
Element: Pay Code      Contains the user-defined pay code.       ETI2.1  HR25.1
                                                                 LP130   PR128
                                                                 PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR189
                                                                 PR20.4  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
                                                                 PR70.1  PR80.1
                                                                 PR82.1  TA147
                                                                 UK102   UK560

PCD-DESCRIPTION        Alpha 30  (Lower Case)                    HR25.1  PR20.4
Element: Description   Contains the pay code description.

PCD-NORM-RATE          Signed 13.4                               BN150   ET530
Element: Norm Rate     Contains the rate for the pay code. The   ETI2.1  LP130
                       calculation type defined for the pay      PR128   PR130
                       code determines the way the system uses   PR131   PR132
                       this field.                               PR134   PR136
                                                                 PR189   PR20.4
                                                                 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   PR80.1
                                                                 PR82.1  TA147
                                                                 UK102   UK560

PCD-SHIFT1             Signed 13.4                               BN150   ET530
Element: Shift1        Contains the premium rate for shift 1.    ETI2.1  LP130
                                                                 PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR189   PR20.4
                                                                 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   PR80.1
                                                                 PR82.1  TA147
                                                                 UK102   UK560

PCD-SHIFT2             Signed 13.4                               BN150   ET530
Element: Shift2        Contains the premium rate for shift 2.    ETI2.1  LP130
                                                                 PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR189   PR20.4
                                                                 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   PR80.1
                                                                 PR82.1  TA147
                                                                 UK102   UK560

PCD-SHIFT3             Signed 13.4                               BN150   ET530
Element: Shift3        Contains the premium rate for shift 3.    ETI2.1  LP130
                                                                 PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR189   PR20.4
                                                                 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   PR80.1
                                                                 PR82.1  TA147
                                                                 UK102   UK560

PCD-SHIFT4             Signed 13.4                               BN150   ET530
Element: Shift4        Contains the premium rate for shift 4.    ETI2.1  LP130
                                                                 PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR189   PR20.4
                                                                 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   PR80.1
                                                                 PR82.1  TA147
                                                                 UK102   UK560

PCD-CALC-TYPE          Alpha 1                                   BN150   ET530
Element: Calc Type     Contains the calculation type for the     ETI2.1  LP130
                       pay code. For a detailed description of   PR128   PR130
                       how this field is used, see the Payroll   PR131   PR132
                       Procedures Manual.                        PR134   PR136
                       D = Rate Shift Differential               PR189   PR20.4
                       F = Non-cash Income                       PR29.1  PR32.2
                       H = Hours Only                            PR33.2  PR33.3
                       P = Normal with percent rate              PR35.1  PR35.2
                       Q = Percentage With Rate Shft Diff        PR35.3  PR35.4
                       R = Normal Rate                           PR35.5  PR35.6
                       X = Custom Calculation                    PR35.8  PR35.9
                       S = Percent Shift Differential            PR36.1  PR45.1
                       B = Percentage With Percent Shft D        PR529   PR530
                       A = Additional Flat Rate                  PR560   PR80.1
                       C = Percentage of Current Earnings        PR82.1  TA147
                       1 = Rate X Unit                           UK102   UK560

PCD-PAY-SUM-GRP        Alpha 3                                   BN150   ET530
Element: Pay Sum Grp   Contains the pay summary group. The       ETI2.1  LP130
                       value in this field must be valid in the  PR128   PR130
                       Pay Summary Groups file. The system       PR131   PR132
                       creates all payroll hours and wage        PR134   PR136
                       amount history by pay summary group, not  PR189   PR20.4
                       by pay code.                              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   PR80.1
                                                                 PR82.1  TA147
                                                                 UK102   UK560

PCD-WE-DIST-CO         Numeric 4                                 BN150   ET530
Element: Company       Contains the distribution company to      ETI2.1  LP130
                       which the wage expense is posted.         PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR189   PR20.4
                                                                 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   PR80.1
                                                                 PR82.1  TA147
                                                                 UK102   UK560

PCD-WE-ACCT-UNIT       Alpha 15                                  BN150   ET530
Element: Acct Unit     Contains the accounting unit to which     ETI2.1  LP130
                       wage expense is posted.                   PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR189   PR20.4
                                                                 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   PR80.1
                                                                 PR82.1  TA147
                                                                 UK102   UK560

PCD-WE-ACCOUNT         Numeric 6                                 BN150   ET530
Element: Account       Contains the account to which wage        ETI2.1  LP130
                       expense is posted.                        PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR189   PR20.4
                                                                 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   PR80.1
                                                                 PR82.1  TA147
                                                                 UK102   UK560

PCD-WE-SUB-ACCT        Numeric 4                                 BN150   ET530
Element: Sub Acct      Contains the subaccount to which wage     ETI2.1  LP130
                       expense is posted.                        PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR189   PR20.4
                                                                 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   PR80.1
                                                                 PR82.1  TA147
                                                                 UK102   UK560

PCD-CR-DIST-CO         Numeric 4                                 ET530   PR195
Element: Company       Contains the distribution company for     PR197   PR20.4
                       calculation type F (Non-Cash Income) pay  PR82.1  PR85.1
                       codes.

PCD-CR-ACCT-UNIT       Alpha 15                                  ET530   PR195
Element: Acct Unit     Contains the credit accounting unit for   PR197   PR20.4
                       calculation type F (Non-Cash Income) pay  PR82.1  PR85.1
                       codes.

PCD-CR-ACCOUNT         Numeric 6                                 ET530   PR195
Element: Account       Contains the credit account for           PR197   PR20.4
                       calculation type F (Non-Cash Income)      PR82.1  PR85.1
                       pay codes.

PCD-CR-SUB-ACCT        Numeric 4                                 ET530   PR195
Element: Sub Acct      Contains the credit subaccount for        PR197   PR20.4
                       calculation type F (Non-cash Income) pay  PR82.1  PR85.1
                       codes.

PCD-EXCLUDE-FLAG       Alpha 1                                   PR20.4
Exclude From           Contains the value that indicates if
Disposable Income      the pay should be included in the
                       calculation of disposable income. The
                       system uses disposable income only with
                       calculation type N (Percent of
                       Disposable Income) garnishment
                       deductions.
                       Y = Yes
                       N = No

PCD-OT-PREM-RATE       Signed 13.4                               BN150   ET530
Element: Ot Prem Rate  Contains the rate used to calculate the   ETI2.1  LP130
                       overtime premium portion of pay. The      PR128   PR130
                       system includes the resulting amount in   PR131   PR132
                       the gross pay for the payment and stores  PR134   PR136
                       it in a separate field for workers'       PR189   PR20.4
                       compensation purposes.                    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   PR80.1
                                                                 PR82.1  TA147
                                                                 UK102   UK560

PCD-OT-ACCOUNT         Numeric 6                                 PR20.4
Element: Account       Contains the account to which the
                       premium expense is posted.

PCD-OT-SUB-ACCT        Numeric 4                                 PR20.4
Element: Sub Acct      Contains the subaccount to which the
                       premium expense is posted.

PCD-SH-ACCOUNT         Numeric 6                                 PR20.4
Element: Account       Contains the account to which the shift
                       expense is posted.

PCD-SH-SUB-ACCT        Numeric 4                                 PR20.4
Element: Sub Acct      Contains the subaccount to which the
                       shift expense is posted.

PCD-SEQ-NBR            Numeric 4                                 BN150   ET530
Element: Seq Nbr       An automatically assigned sequence        ETI2.1  HR25.1
                       number.                                   LP130   PR128
                                                                 PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR189
                                                                 PR20.4  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
                                                                 PR80.1  PR82.1
                                                                 TA147   UK102
                                                                 UK560

PCD-USED-FLAG          Alpha 1                                   ET530   PR195
Element: Used Flag     Indicates if the record has been          PR197   PR560
                       accessed by some source after creation.   PR82.1  PR85.1


PCD-BN-USED-FLAG       Alpha 1                                   BN06.1  BN15.1
Element: Bn Used Flag  Contains the value that indicates if
                       the pay code is used by the Benefits
                       system.
                       Y = Yes
                       N = No

PCD-ACTIVITY           Alpha 15                                  BN150   ET530
Element: Activity      Activities are the processes or           ETI2.1  LP130
                       procedures that produce work. Cost        PR128   PR130
                       objects (products, services, customers,   PR131   PR132
                       and so on) are the reasons for            PR134   PR136
                       performing the activity.                  PR189   PR20.4
                                                                 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   PR80.1
                                                                 PR82.1  TA147
                                                                 UK102   UK560

PCD-ACCT-CATEGORY      Alpha 5                                   BN150   ET530
Element: Acct Category Account categories are groupings of       ETI2.1  LP130
                       costs, revenues, or a combination of      PR128   PR130
                       both used for reporting and inquiries     PR131   PR132
                       for activities in the Activity            PR134   PR136
                       Management system. All transactions are   PR189   PR20.4
                       posted to an account category within an   PR29.1  PR32.2
                       activity. You can assign a specific       PR33.2  PR33.3
                       General Ledger account or range of        PR35.1  PR35.2
                       accounts (company, accounting unit,       PR35.3  PR35.4
                       account, and subaccount) that make up     PR35.5  PR35.6
                       the transactions posted to an account     PR35.8  PR35.9
                       category using AC07.1 (Account            PR36.1  PR45.1
                       Assignment).                              PR529   PR530
                                                                 PR560   PR80.1
                       Period-to-date, year-to-date, and         PR82.1  TA147
                       life-to-date balances are maintained by   UK102   UK560
                       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

PCD-SHIFT-CODE         Alpha 4                                   BN150   ET530
Element: Shift Code    Contains the shift table that applies     ETI2.1  LP130
                       to this pay code.                         PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR189   PR20.4
                                                                 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   PR80.1
                                                                 PR82.1  TA147
                                                                 UK102   UK560

PCD-CURRENCY-CODE      Alpha 5                                   BN150   ET530
Element: Currency Code This field contains the company base      ETI2.1  LP130
                       currency code established in Company      PR128   PR130
                       (GL10.1 ).                                PR131   PR132
                                                                 PR134   PR136
                                                                 PR189   PR20.4
                                                                 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   PR80.1
                                                                 PR82.1  TA147
                                                                 UK102   UK560

PCD-CURR-ND            Numeric 1                                 BN150   ET530
Element: Acct Nd       The number of decimals assigned to a      ETI2.1  LP130
                       particular account as determined by the   PR128   PR130
                       account currency.                         PR131   PR132
                                                                 PR134   PR136
                                                                 PR189   PR20.4
                                                                 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   PR80.1
                                                                 PR82.1  TA147
                                                                 UK102   UK560

PCD-ATTEND-CODE        Alpha 2                                   PR20.4
Element: Attend Code   A user-defined alphanumeric code that
                       represents a reason for an employee's
                       absence or hours worked.  Examples of
                       attendance codes are, sick, vacation,
                       overtime, on the job injury, snow day,
                       tardy, left early, and so on. Validated
                       in the Attendance Code file.

PCD-PAY-CLASS          Alpha 3                                   PR20.4
Element: Pay Class

PCD-ACTIVE-FLAG        Alpha 1                                   HR25.1  PR20.4
Element: Active Flag   The Active flag of the credit card
                       type.
                       " " = Active
                       I = Inactive
                       A = Active

PCD-ALLOW-HOURS        Numeric 1                                 PR20.4
Element: Allow Hours   0 = No
                       1 = Yes

PCD-NON-EARNINGS       Numeric 1                                 BN150   ET530
Element: Non Earnings  0 = No - wages                            ETI2.1  LP130
                       1 = Yes - other remuneration              PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR189   PR20.4
                                                                 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   PR80.1
                                                                 PR82.1  TA147
                                                                 UK102   UK560

PCD-UNIT-MEASURE       Alpha 12                                  BN150   ET530
Element: Unit Measure                                            ETI2.1  LP130
                                                                 PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR189   PR20.4
                                                                 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   PR80.1
                                                                 PR82.1  TA147
                                                                 UK102   UK560

PCD-SERVICE-CODE       Alpha 4                                   BN150   ET530
Element: Ta Service Cd                                           ETI2.1  LP130
                                                                 PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR189   PR20.4
                                                                 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   PR80.1
                                                                 PR82.1  TA147
                                                                 UK102   UK560

                         PRPAYCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PCDSET1   COMPANY                                                BN150   BN215
          PROCESS-LEVEL                                          ET530   ET700
          JOB-CODE                                               ETI2.1  HR00.1
          PAY-CODE                                               HR01.1  LP08.2
                                                                 LP130   PR128
                                                                 PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR160
                                                                 PR180   PR189
                                                                 PR195   PR197
                                                                 PR20.4  PR20.7
                                                                 PR220   PR229
                                                                 PR24.1  PR29.1
                                                                 PR30.1  PR32.2
                                                                 PR33.2  PR33.3
                                                                 ...

PCDSET3   COMPANY       KeyChange                                PR115   PR20.2
          PAY-SUM-GRP                                            PR20.4  PR220
          PAY-CODE                                               PR52.1
          PROCESS-LEVEL
          JOB-CODE

PCDSET4   COMPANY                                                BN06.1  BN15.1
          PAY-CODE                                               BN150   BN206
          PROCESS-LEVEL                                          ET530   HPCD.1
          JOB-CODE                                               HR14.1  HR25.1
                                                                 HR250   HR514
                                                                 PR21.1  HS01.1
                                                                 HS02.1  PR128
                                                                 PR131   PR134
                                                                 PR136   PR139
                                                                 PR189   PR195
                                                                 PR197   PR20.4
                                                                 PR23.1  PR23.3
                                                                 PR25.2  PR26.1
                                                                 PR28.1  PR29.1
                                                                 PR32.1  PR32.2
                                                                 ...

PCDSET5   COMPANY                                                BN134   BN66.1
          SEQ-NBR                                                ET530   HR170
                                                                 HR25.1  HR70.1
                                                                 PA495   PA82.1
                                                                 PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR135
                                                                 PR136   PR137
                                                                 PR139   PR140
                                                                 PR141   PR189
                                                                 PR195   PR197
                                                                 PR198   PR20.4
                                                                 PR229   PR24.1
                                                                 PR260   PR261
                                                                 PR262   PR29.1
                                                                 ...

PCDSET6   COMPANY       Subset                                   LP130   PR20.4
          SERVICE-CODE  Where (SERVICE-CODE != Spaces )
          PROCESS-LEVEL
          JOB-CODE
          PAY-CODE

                         PRPAYCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acct Category  ACACCTCAT    Required
                            When PCD-ACCT-CATEGORY != Spaces

                            PCD-ACCT-CATEGORY    -> AAX-ACCT-CATEGORY

Activity       ACACTIVITY   Required
                            When PCD-ACTIVITY != Spaces

                            PCD-ACTIVITY         -> ACV-ACTIVITY

Attend Code    ATTENDCODE   Required
                            When PCD-ATTEND-CODE != Spaces

                            PCD-COMPANY          -> ATC-COMPANY
                            PCD-ATTEND-CODE      -> ATC-ATTEND-CODE

Company        PRSYSTEM     Required

                            PCD-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Credit Account GLMASTER     Required
                            When PCD-CR-ACCT-UNIT != Spaces
                            Or   PCD-CR-ACCOUNT   != Zeroes

                            PCD-COMPANY          -> GLM-COMPANY
                            PCD-CR-ACCT-UNIT     -> GLM-ACCT-UNIT
                            PCD-CR-ACCOUNT       -> GLM-ACCOUNT
                            PCD-CR-SUB-ACCT      -> GLM-SUB-ACCOUNT

Job Code       JOBCODE      Required
                            When PCD-JOB-CODE != Spaces

                            PCD-COMPANY          -> JBC-COMPANY
                            PCD-JOB-CODE         -> JBC-JOB-CODE

Pay Sum Grp    PAYSUMGRP    Required
                            When PCD-PAY-SUM-GRP != Spaces

                            PCD-COMPANY          -> PSG-COMPANY
                            PCD-PAY-SUM-GRP      -> PSG-PAY-SUM-GRP

Pik Pay Class  PSGRELATE    Not Required
                            Valid When PCD-PAY-SUM-GRP != Spaces

                            PCD-COMPANY          -> PSR-COMPANY
                            PRS-PAY-IN-KIND      -> PSR-PAY-CLASS
                            PCD-PAY-SUM-GRP      -> PSR-PAY-SUM-GRP

Process Level  PRSYSTEM     Required
                            When PCD-PROCESS-LEVEL != Spaces

                            PCD-COMPANY          -> PRS-COMPANY
                            PCD-PROCESS-LEVEL    -> PRS-PROCESS-LEVEL

Service Code   TASERVCODE   Required
                            When (PCD-SERVICE-CODE != Spaces )

                            PCD-COMPANY          -> TSC-COMPANY
                            PCD-SERVICE-CODE     -> TSC-SERVICE-CODE

Tip Pay Class  PSGRELATE    Not Required
                            Valid When PCD-PAY-SUM-GRP != Spaces

                            PCD-COMPANY          -> PSR-COMPANY
                            PRS-TIPS             -> PSR-PAY-CLASS
                            PCD-PAY-SUM-GRP      -> PSR-PAY-SUM-GRP

We Account     GLMASTER     Required
                            When PCD-WE-ACCOUNT != Zeroes

                            PCD-COMPANY          -> GLM-COMPANY
                            PCD-WE-ACCT-UNIT     -> GLM-ACCT-UNIT
                            PCD-WE-ACCOUNT       -> GLM-ACCOUNT
                            PCD-WE-SUB-ACCT      -> GLM-SUB-ACCOUNT

                         PRPAYCODE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Pay Classes    PSGRELATE
                            Valid When PCD-PAY-SUM-GRP != Spaces

                            PCD-COMPANY          -> PSR-COMPANY
                            PCD-PAY-SUM-GRP      -> PSR-PAY-SUM-GRP
                                                    PSR-PAY-CLASS

Protaccts      PROTACCTS    Delete Cascades

                            PCD-COMPANY          -> OTA-COMPANY
                            PCD-PROCESS-LEVEL    -> OTA-PROCESS-LEVEL
                            PCD-JOB-CODE         -> OTA-JOB-CODE
                            PCD-PAY-CODE         -> OTA-PAY-CODE
                                                    OTA-OT-JOB-CODE

Time Records   TIMERECORD   Delete Restricted

                            PCD-COMPANY          -> TRD-COMPANY
                            PCD-SEQ-NBR          -> TRD-PCD-SEQ-NBR
                                                    TRD-EMPLOYEE
                                                    TRD-TIME-SEQ