PRPAYCODE

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
BN215 BN305 HR11.1 HR11.2 HR11.4 HR28.1
HR511 ZH510 EX13.1 PA02.1 PA100 PA102
PA115 PA13.1 PA13.2 PA502 PA513 PA52.1
PA52.3 PA52.4 PA52.5 HS36.1 PR110 PR113
PR12.6 PR120 PR13.1 PR13.5 PR13.6 PR13.8
PR13.9 PR160 PR180 PR220 PR229 PR24.1
PR30.1 PR30.2 PR512 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 PR46.2 PR47.1 PR514 TA40.2 TA40.3
TM01.1 BN134 BN66.1 HR170 HR70.1 PA495
PA82.1 PR138 PR140 PR141 PR198 PR260
PR261 PR262 PR295 PR50.1 PR70.1 PR89.1
PRAT.1 HS19.2 LP03.1 LP03.2 LP03.3 LP03.4
LP03.5 LP03.6 LP10.1 LP100 LP101 LP102
LP103 LP131 LP151 LP180 LP197 LP31.1
LP80.1


UPDATED BY
BN06.1 BN15.1 HR25.1 PR195 PR197 PR20.4
PR20.2 PR560 PR582 PR82.1 PR85.1 BN150
HR00.1 HR01.1 HR06.1 HR506 LT101 LT111
PR521 EXI2.1 EXI4.1 LP08.2 LP130 PR128
PR131 PR132 PR134 PR135 PR136 PR137
PR189 PR29.1 PR32.1 PR32.2 PR33.1 PR33.2
PR33.3 PR35.1 PR35.2 PR35.3 PR35.4 PR35.5
PR35.6 PR35.8 PR35.9 PR36.1 PR36.4 PR37.1
PR45.1 PR529 PR530 PR80.1 PR80.4 UK102
TA147

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PCD-COMPANY
Element: Company Hr		Numeric 4
HR25.1 PR20.4
PCD-PROCESS-LEVEL
Element: Process Lev Hr		Alpha 5
Contains the process level. You define the same pay code for different process levels or limit the use of the pay code to a specific process level.
BN150 EXI2.1
EXI4.1 HR25.1
LP130 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 PR20.4
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
PCD-JOB-CODE
Element: Job Code		Alpha 9
Contains the job code. You can define the same pay code for different job codes, or limit the use of the pay code to a specific process level.
BN150 EXI2.1
EXI4.1 HR25.1
LP130 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 PR20.4
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
PCD-PAY-CODE
Element: Pay Code		Alpha 4
Contains the user-defined pay code.
BN150 EXI2.1
EXI4.1 HR25.1
LP130 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 PR20.4
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR70.1
PR80.1 PR80.4
PR82.1 TA147
UK102
PCD-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
Contains the pay code description.
HR25.1 PR20.4
PCD-NORM-RATE
Element: Norm Rate		Signed 13.4
Contains the rate for the pay code. The calculation type defined for the pay code determines the way the system uses this field.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR20.4 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
PCD-SHIFT1
Element: Shift1		Signed 13.4
Contains the premium rate for shift 1.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR20.4 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
PCD-SHIFT2
Element: Shift2		Signed 13.4
Contains the premium rate for shift 2.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR20.4 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
PCD-SHIFT3
Element: Shift3		Signed 13.4
Contains the premium rate for shift 3.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR20.4 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
PCD-SHIFT4
Element: Shift4		Signed 13.4
Contains the premium rate for shift 4.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR20.4 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
PCD-CALC-TYPE
Element: Calc Type		Alpha 1
Contains the calculation type for the pay code. For a detailed description of how this field is used, see the Payroll Procedures Manual.
D = Rate Shift Differential
F = Non-cash Income
H = Hours Only
P = Normal with percent rate
Q = Percentage With Rate Shft Diff
R = Normal Rate
X = Custom Calculation
S = Percent Shift Differential
B = Percentage With Percent Shft D
A = Additional Flat Rate
C = Percentage of Current Earnings
1 = Rate X Unit
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR20.4 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
PCD-PAY-SUM-GRP
Element: Pay Sum Grp		Alpha 3
Contains the pay summary group. The value in this field must be valid in the Pay Summary Groups file. The system creates all payroll hours and wage amount history by pay summary group, not by pay code.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR20.4 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
PCD-WE-DIST-CO
Element: Company		Numeric 4
Contains the distribution company to which the wage expense is posted.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR20.4 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
PCD-WE-ACCT-UNIT
Element: Acct Unit		Alpha 15
Contains the accounting unit to which wage expense is posted.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR20.4 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
PCD-WE-ACCOUNT
Element: Account		Numeric 6
Contains the account to which wage expense is posted.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR20.4 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
PCD-WE-SUB-ACCT
Element: Sub Acct		Numeric 4
Contains the subaccount to which wage expense is posted.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR20.4 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
PCD-CR-DIST-CO
Element: Company		Numeric 4
Contains the distribution company for calculation type F (Non-Cash Income) pay codes.
PR20.4
PCD-CR-ACCT-UNIT
Element: Acct Unit		Alpha 15
Contains the credit accounting unit for calculation type F (Non-Cash Income) pay codes.
PR20.4
PCD-CR-ACCOUNT
Element: Account		Numeric 6
Contains the credit account for calculation type F (Non-Cash Income) pay codes.
PR20.4
PCD-CR-SUB-ACCT
Element: Sub Acct		Numeric 4
Contains the credit subaccount for calculation type F (Non-cash Income) pay codes.
PR20.4
PCD-EXCLUDE-FLAG
Exclude From
Disposable Income		Alpha 1
Contains the value that indicates if 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
PR20.4
PCD-OT-PREM-RATE
Element: Ot Prem Rate		Signed 13.4
Contains the rate used to calculate the overtime premium portion of pay. The system includes the resulting amount in the gross pay for the payment and stores it in a separate field for workers' compensation purposes.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR20.4 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
PCD-OT-ACCOUNT
Element: Account		Numeric 6
Contains the account to which the premium expense is posted.
PR20.4
PCD-OT-SUB-ACCT
Element: Sub Acct		Numeric 4
Contains the subaccount to which the premium expense is posted.
PR20.4
PCD-SH-ACCOUNT
Element: Account		Numeric 6
Contains the account to which the shift expense is posted.
PR20.4
PCD-SH-SUB-ACCT
Element: Sub Acct		Numeric 4
Contains the subaccount to which the shift expense is posted.
PR20.4
PCD-SEQ-NBR
Element: Seq Nbr		Numeric 4
An automatically assigned sequence number.
BN150 EXI2.1
EXI4.1 HR25.1
LP130 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 PR20.4
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
PCD-USED-FLAG
Element: Used Flag		Alpha 1
Indicates if the record has been accessed by some source after creation.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
PCD-BN-USED-FLAG
Element: Bn Used Flag		Alpha 1
Contains the value that indicates if the pay code is used by the Benefits system.
Y = Yes
N = No
BN06.1 BN15.1
PCD-ACTIVITY
Element: Activity		Alpha 15
Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR20.4 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
PCD-ACCT-CATEGORY
Element: Acct Category		Alpha 5
Account 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
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR20.4 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
PCD-SHIFT-CODE
Element: Shift Code		Alpha 4
Contains the shift table that applies to this pay code.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR20.4 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
PCD-CURRENCY-CODE
Element: Currency Code		Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR20.4 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
PCD-CURR-ND
Element: Acct Nd		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR20.4 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
PCD-ATTEND-CODE
Element: Attend Code		Alpha 2
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.
PR20.4
PCD-PAY-CLASS
Element: Pay Class		Alpha 3
PR20.4
PCD-ACTIVE-FLAG
Element: Active Flag		Alpha 1
The Active flag of the credit card type.
" " = Active
I = Inactive
A = Active
HR25.1 PR20.4
PCD-ALLOW-HOURS
Element: Allow Hours		Numeric 1

0 = No
1 = Yes
PR20.4
PCD-NON-EARNINGS
Element: Non Earnings		Numeric 1

0 = No - wages
1 = Yes - other remuneration
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR20.4 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
PCD-UNIT-MEASURE
Element: Unit Measure		Alpha 12
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR20.4 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
PCD-SERVICE-CODE
Element: Ta Service Cd		Alpha 10
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR20.4 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
PCD-CREATE-DATE
Element: Date Stamp		Numeric 8 (yyyymmdd)
HR25.1 PR20.4
PCD-CREATE-TIME
Element: Time Stamp		Numeric 6 (hhmmss)
HR25.1 PR20.4
PCD-CREATE-USER-ID
Element: User Id		Alpha 10 (Lower Case)
HR25.1 PR20.4
PCD-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
HR25.1 PR20.4
PCD-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
HR25.1 PR20.4
PCD-USER-ID
Element: User Id		Alpha 10 (Lower Case)
HR25.1 PR20.4
PCD-OVR-DED-EXP
Element: Ovr Ded Exp		Alpha 1
Add field for PR197 processing of company paid deduction expenses.
1 = No
2 = Yes
BN150 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR20.4 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
PCD-POST-HOURS
Element: Post Hours		Alpha 1
Add field for PR197 processing of company paid deduction expenses.
1 = No
2 = Yes
PR20.4
PCD-PCD-SEQ-NBR
Element: Pcd Seq Nbr		Numeric 8
BN150 EXI2.1
EXI4.1 HR25.1
LP130 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 PR20.4
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
PCD-OVRD-JOIN-LEAV
Element: Join Leave Flg		Alpha 1

1 = No
2 = Yes
PCD-ROUND-METH-DOL
Element: Cw Method		Numeric 1

0 = None
1 = Normal
2 = High
3 = Low
PCD-ROUND-TO-DOL
Element: Cw Round To		Signed 18.6
PCD-STD-HRS-FLG
Element: Std Hrs Flg		Numeric 1

0 = No
1 = Yes
PCD-BASE-PAY-FLG
Element: Base Pay Flg		Alpha 1

B = Base
S = Stipend


PRPAYCODE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PCDSET1 COMPANY
PROCESS-LEVEL
JOB-CODE
PAY-CODE
...
BN150 BN215
BN305 HR00.1
HR01.1 HR06.1
HR11.1 HR11.2
HR11.4 HR28.1
HR506 HR511
LT101 LT111
PR521 ZH510
EX13.1 EXI2.1
EXI4.1 LP08.2
LP130 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PCDSET3 COMPANY
PAY-SUM-GRP
PAY-CODE
PROCESS-LEVEL
JOB-CODE
KeyChange
PR115 PR160
PR180 PR20.2
PR20.4 PR220
PR52.1 PR80.2
PCDSET4 COMPANY
PAY-CODE
PROCESS-LEVEL
JOB-CODE
...
BN06.1 BN15.1
BN150 BN206
HPCD.1 HR14.1
HR25.1 HR250
HR514 PR21.1
PR521 EXI2.1
EXI4.1 LP130
HS01.1 HS02.1
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR139
PR189 PR195
PR197 PR20.4
PR23.1 PR23.3
PCDSET5 COMPANY
SEQ-NBR
Subset
WherePCD-SEQ-NBR =Zeroes
...
BN134 BN150
BN66.1 HR170
HR25.1 HR70.1
PR521 EXI2.1
EXI4.1 LP130
PA495 PA82.1
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR138
PR139 PR140
PR141 PR189
PR195 PR197
PR198 PR20.4
PR229 PR24.1
PCDSET6 COMPANY
SERVICE-CODE
PROCESS-LEVEL
JOB-CODE
PAY-CODE
Subset
Where(SERVICE-CODE !=Spaces)
...
BN150 HR11.1
HR511 HS19.2
LT101 LT111
PR521 EXI2.1
EXI4.1 LP03.1
LP03.2 LP03.3
LP03.4 LP03.5
LP03.6 LP10.1
LP100 LP101
LP102 LP103
LP130 LP131
LP151 LP180
LP197 LP31.1
LP80.1 PA100
PA52.4 PR128
PCDSET7 COMPANY
PCD-SEQ-NBR
Subset
WherePCD-SEQ-NBR >9999
...
BN134 BN150
BN66.1 HR170
HR25.1 HR70.1
PR521 EXI2.1
EXI4.1 LP130
PA495 PA82.1
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR138
PR139 PR140
PR141 PR189
PR195 PR197
PR198 PR20.4
PR229 PR24.1


PRPAYCODE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
OrPCD-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
NAME		 RELATED 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
Valid When PCD-PCD-SEQ-NBR =Zeroes
PCD-COMPANY->TRD-COMPANY
PCD-SEQ-NBR->TRD-PCD-SEQ-NBR
  TRD-EMPLOYEE
  TRD-TIME-SEQ
Time Records2 TIMERECORD Delete Restricted
Valid When PCD-PCD-SEQ-NBR >9999
PCD-COMPANY->TRD-COMPANY
PCD-PCD-SEQ-NBR->TRD-PCD-SEQ-NBR
  TRD-EMPLOYEE
  TRD-TIME-SEQ

File created: Thu Jun 09 02:30:39 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.