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
AC750 BN150 BN215 PR128 PR131 PR132
PR134 PR136 PR137 PR140 PR220 PR24.1
PR30.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 PR36.1 PR37.1 PR45.1 PR530 PR560
PR80.1 UK102 UK330 UK120 UK60.1 UK60.2
UK70.1 BN206 HPCD.1 HR14.1 HR514 HS01.1
HS02.1 PR139 PR21.1 PR23.1 PR23.3 PR25.2
PR26.1 PR28.1 PR514 TM01.1 UK20.1 UK20.2
UK220 BN134 HR170 HR70.1 PR135 PR141
PR260 PR295 PRSA.1 UK260
UPDATED BY
BN06.1 BN09.2 BN15.1 PR150 PR195 PR199
PR20.4 PR82.1 PR85.1 HR00.1 HR01.1 PBIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PCD-COMPANY Numeric 4 BN09.2 PR20.4
Company The company number represents an
established company and is entered on
all function codes.
PCD-PROCESS-LEVEL Alpha 5 BN09.2 BN150
Process Level Contains the process level. You define PR128 PR131
the same pay code for different process PR132 PR134
levels or limit the use of the pay code PR136 PR137
to a specific process level. PR140 PR150
PR195 PR199
PR20.4 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
PCD-JOB-CODE Alpha 9 BN09.2 BN150
Job Code Contains the job code. You can define PR128 PR131
the same pay code for different job PR132 PR134
codes, or limit the use of the pay code PR136 PR137
to a specific process level. PR140 PR150
PR195 PR199
PR20.4 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
PCD-PAY-CODE Alpha 4 BN09.2 BN150
Payment Code Contains the user-defined pay code. PR128 PR131
PR132 PR134
PR136 PR137
PR140 PR150
PR195 PR199
PR20.4 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
PCD-DESCRIPTION Alpha 30 (Lower Case) BN09.2 PR20.4
Description Contains the pay code description.
PCD-NORM-RATE Signed 13.4 BN09.2 BN150
Normal Rate Contains the rate for the pay code. The PR128 PR131
calculation type defined for the pay PR132 PR134
code determines the way the system uses PR136 PR137
this field. PR140 PR150
PR195 PR199
PR20.4 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
PCD-SHIFT1 Signed 13.4 BN09.2 BN150
Shift One Contains the premium rate for shift 1. PR128 PR131
Differential PR132 PR134
PR136 PR137
PR140 PR150
PR195 PR199
PR20.4 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
PCD-SHIFT2 Signed 13.4 BN09.2 BN150
Shift Two Contains the premium rate for shift 2. PR128 PR131
Differential PR132 PR134
PR136 PR137
PR140 PR150
PR195 PR199
PR20.4 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
PCD-SHIFT3 Signed 13.4 BN09.2 BN150
Shift Three Contains the premium rate for shift 3. PR128 PR131
Differential PR132 PR134
PR136 PR137
PR140 PR150
PR195 PR199
PR20.4 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
PCD-SHIFT4 Signed 13.4 BN09.2 BN150
Shift Four Contains the premium rate for shift 4. PR128 PR131
Differential PR132 PR134
PR136 PR137
PR140 PR150
PR195 PR199
PR20.4 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
PCD-CALC-TYPE Alpha 1 BN09.2 BN150
Calculation Type Contains the calculation type for the PR128 PR131
pay code. For a detailed description of PR132 PR134
how this field is used, see the Payroll PR136 PR137
Procedures Manual. PR140 PR150
D = Rate Shift Differential PR195 PR199
F = Non-cash Income PR20.4 PR32.1
H = Hours Only PR32.2 PR33.1
P = Normal with percent rate PR33.2 PR33.3
Q = Percentage With Rate Shft Diff PR35.1 PR35.2
R = Normal Rate PR35.3 PR35.4
X = User Exit PR35.5 PR35.6
S = Percent Shift Differential PR35.8 PR36.1
B = Percentage With Percent Shft D PR37.1 PR45.1
A = Additional Flat Rate PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
PCD-PAY-SUM-GRP Alpha 3 BN09.2 BN150
Payment Summary Contains the pay summary group. The PR128 PR131
Group value in this field must be valid in the PR132 PR134
Pay Summary Groups file. The system PR136 PR137
creates all payroll hours and wage PR140 PR150
amount history by pay summary group, not PR195 PR199
by pay code. PR20.4 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
PCD-WE-DIST-CO Numeric 4 BN150 PR128
We Dist Co Contains the distribution company to PR131 PR132
which the wage expense is posted. PR134 PR136
PR137 PR140
PR150 PR195
PR199 PR20.4
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR37.1
PR45.1 PR530
PR80.1 PR82.1
PR85.1 UK102
UK120 UK330
PCD-WE-ACCT-UNIT Alpha 15 BN09.2 BN150
Wage Expense Contains the accounting unit to which PR128 PR131
Accounting Unit wage expense is posted. PR132 PR134
PR136 PR137
PR140 PR150
PR195 PR199
PR20.4 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
PCD-WE-ACCOUNT Numeric 6 BN09.2 BN150
Wage Expense Account Contains the account to which wage PR128 PR131
expense is posted. PR132 PR134
PR136 PR137
PR140 PR150
PR195 PR199
PR20.4 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
PCD-WE-SUB-ACCT Numeric 4 BN09.2 BN150
Wage Expense Contains the subaccount to which wage PR128 PR131
Subaccount expense is posted. PR132 PR134
PR136 PR137
PR140 PR150
PR195 PR199
PR20.4 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
PCD-CR-DIST-CO Numeric 4 PR150 PR195
Cr Dist Co Contains the distribution company for PR199 PR20.4
calculation type F (Non-Cash Income) pay PR82.1 PR85.1
codes.
PCD-CR-ACCT-UNIT Alpha 15 BN09.2 PR150
Non-Cash Income Contains the credit accounting unit for PR195 PR199
Credit Acct Un calculation type F (Non-Cash Income) pay PR20.4 PR82.1
codes. PR85.1
PCD-CR-ACCOUNT Numeric 6 BN09.2 PR150
Non-Cash Income Contains the credit account for PR195 PR199
Credit Account calculation type F (Non-Cash Income) PR20.4 PR82.1
pay codes. PR85.1
PCD-CR-SUB-ACCT Numeric 4 BN09.2 PR150
Cr Sub Acct Contains the credit subaccount for PR195 PR199
calculation type F (Non-cash Income) pay PR20.4 PR82.1
codes. PR85.1
PCD-EXCLUDE-FLAG Alpha 1 BN09.2 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 BN09.2 BN150
Ot Prem Rate Contains the rate used to calculate the PR128 PR131
overtime premium portion of pay. The PR132 PR134
system includes the resulting amount in PR136 PR137
the gross pay for the payment and stores PR140 PR150
it in a separate field for workers' PR195 PR199
compensation purposes. PR20.4 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
PCD-OT-ACCOUNT Numeric 6 BN09.2 PR20.4
Ot Account Contains the account to which the
premium expense is posted.
PCD-OT-SUB-ACCT Numeric 4 BN09.2 PR20.4
Ot Sub Acct Contains the subaccount to which the
premium expense is posted.
PCD-SH-ACCOUNT Numeric 6 BN09.2 PR20.4
Sh Account Contains the account to which the shift
expense is posted.
PCD-SH-SUB-ACCT Numeric 4 BN09.2 PR20.4
Sh Sub Acct Contains the subaccount to which the
shift expense is posted.
PCD-SEQ-NBR Numeric 4 BN09.2 BN150
Sequence Number An automatically assigned sequence PR128 PR131
number. PR132 PR134
PR136 PR137
PR140 PR150
PR195 PR199
PR20.4 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
PCD-USED-FLAG Alpha 1 BN09.2 PR150
Used Indicates if the record has been PR195 PR199
accessed by some source after creation. PR82.1 PR85.1
PCD-BN-USED-FLAG Alpha 1 BN06.1 BN09.2
Bn Used Flag Contains the value that indicates if BN15.1
the pay code is used by the Benefits
system.
Y = Yes
N = No
PCD-ACTIVITY Alpha 15 BN09.2 BN150
Activity Activities are the processes or PR128 PR131
procedures that produce work. Cost PR132 PR134
objects (products, services, customers, PR136 PR137
and so on) are the reasons for PR140 PR150
performing the activity. Activities and PR195 PR199
cost object activities are used PR20.4 PR32.1
synonymously in the Activity Management PR32.2 PR33.1
system. Direct costs are posted to PR33.2 PR33.3
activities, and indirect costs are PR35.1 PR35.2
allocated to activities based on PR35.3 PR35.4
activity drivers. PR35.5 PR35.6
PR35.8 PR36.1
Activities are grouped or organized by PR37.1 PR45.1
activity levels. There are two kinds of PR530 PR80.1
activities: "posting allowed" and PR82.1 PR85.1
"summary only." Use posting level UK102 UK120
activities to budget and maintain all UK330
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
PCD-ACCT-CATEGORY Alpha 5 BN150 PR128
Account Category Account categories are groupings of PR131 PR132
costs, revenues, or a combination of PR134 PR136
both used for reporting and inquiries PR137 PR140
for activities in the Activity PR150 PR195
Management system. All transactions are PR199 PR20.4
posted to an account category within an PR32.1 PR32.2
activity. You can assign a specific PR33.1 PR33.2
General Ledger account or range of PR33.3 PR35.1
accounts (company, accounting unit, PR35.2 PR35.3
account, and subaccount) that make up PR35.4 PR35.5
the transactions posted to an account PR35.6 PR35.8
category using AC07.1 (Account PR36.1 PR37.1
Assignment). PR45.1 PR530
PR80.1 PR82.1
Period-to-date, year-to-date, and PR85.1 UK102
life-to-date balances are maintained by UK120 UK330
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
PCD-SHIFT-CODE Alpha 4 BN150 PR128
Shift Code Contains the shift table that applies to PR131 PR132
this pay code. PR134 PR136
PR137 PR140
PR150 PR195
PR199 PR20.4
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR37.1
PR45.1 PR530
PR80.1 PR82.1
PR85.1 UK102
UK120 UK330
PRPAYCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PCDSET1 COMPANY AC750 BN09.2
PROCESS-LEVEL BN150 BN215
JOB-CODE HR00.1 HR01.1
PAY-CODE PBIP.1 PR128
PR131 PR132
PR134 PR136
PR137 PR140
PR150 PR195
PR199 PR20.4
PR20.7 PR220
PR24.1 PR30.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
...
PCDSET3 COMPANY KeyChange AC750 PR140
PAY-SUM-GRP PR20.2 PR220
PAY-CODE
PROCESS-LEVEL
JOB-CODE
PCDSET4 COMPANY BN06.1 BN15.1
PAY-CODE BN150 BN206
PROCESS-LEVEL HPCD.1 HR14.1
JOB-CODE HR514 HS01.1
HS02.1 PR128
PR131 PR134
PR136 PR139
PR20.4 PR21.1
PR23.1 PR23.3
PR25.2 PR26.1
PR28.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
...
PCDSET5 COMPANY BN09.2 BN134
SEQ-NBR HR170 HR70.1
PR131 PR132
PR134 PR135
PR139 PR140
PR141 PR150
PR195 PR199
PR20.4 PR24.1
PR260 PR295
PR32.2 PR35.1
PR35.2 PR35.6
PR36.1 PR530
PR80.1 PR82.1
PR82.2 PR85.1
PRSA.1 UK120
...
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
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
PCD-COMPANY -> PSG-COMPANY
PCD-PAY-SUM-GRP -> PSG-PAY-SUM-GRP
Pik Pay Class PSGRELATE Not Required
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
Tip Pay Class PSGRELATE Not Required
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
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
|