 |
Lawson Insight Technical Documentation |
|
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
AC541 AC550 AC57.1 BN150 BN215 PR128
PR130 PR131 PR132 PR134 PR136 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 PR36.1
PR45.1 PR529 PR530 PR560 PR80.1 UK102
TA147 UK120 UK60.1 UK60.2 UK70.1 PR115
BN206 HPCD.1 HR14.1 HR514 HS01.1 HS02.1
PR139 PR21.1 PR23.1 PR23.3 PR25.2 PR26.1
PR28.1 PR37.1 PR46.2 PR47.1 PR514 TA40.2
TA40.3 TM01.1 UK20.1 UK20.2 UK220 BN134
BN66.1 HR170 HR70.1 PR135 PR140 PR141
PR198 PR260 PR295 PR70.1 PR89.1 PRSA.1
TA146 UK260
UPDATED BY
AC542 BN06.1 BN09.2 BN15.1 PR195 PR197
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 AC541 AC542
Process Level Contains the process level. You define BN09.2 BN150
the same pay code for different process PR128 PR130
levels or limit the use of the pay code PR131 PR132
to a specific process level. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
PCD-JOB-CODE Alpha 9 AC541 AC542
Job Code Contains the job code. You can define BN09.2 BN150
the same pay code for different job PR128 PR130
codes, or limit the use of the pay code PR131 PR132
to a specific process level. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
PCD-PAY-CODE Alpha 4 AC541 AC542
Payment Code Contains the user-defined pay code. BN09.2 BN150
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 PR36.1
PR45.1 PR529
PR530 PR560
PR70.1 PR80.1
PR82.1 TA147
UK102 UK120
PCD-DESCRIPTION Alpha 30 (Lower Case) BN09.2 PR20.4
Description Contains the pay code description.
PCD-NORM-RATE Signed 13.4 AC541 AC542
Normal Rate Contains the rate for the pay code. The BN09.2 BN150
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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
PCD-SHIFT1 Signed 13.4 AC541 AC542
Shift One Contains the premium rate for shift 1. BN09.2 BN150
Differential 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
PCD-SHIFT2 Signed 13.4 AC541 AC542
Shift Two Contains the premium rate for shift 2. BN09.2 BN150
Differential 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
PCD-SHIFT3 Signed 13.4 AC541 AC542
Shift Three Contains the premium rate for shift 3. BN09.2 BN150
Differential 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
PCD-SHIFT4 Signed 13.4 AC541 AC542
Shift Four Contains the premium rate for shift 4. BN09.2 BN150
Differential 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
PCD-CALC-TYPE Alpha 1 AC541 AC542
Calculation Type Contains the calculation type for the BN09.2 BN150
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 PR36.1
S = Percent Shift Differential PR45.1 PR529
B = Percentage With Percent Shft D PR530 PR560
A = Additional Flat Rate PR80.1 PR82.1
C = Percentage of Current Earnings TA147 UK102
1 = Rate X Unit UK120
PCD-PAY-SUM-GRP Alpha 3 AC541 AC542
Payment Summary Contains the pay summary group. The BN09.2 BN150
Group 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
PCD-WE-DIST-CO Numeric 4 AC541 AC542
We Dist Co Contains the distribution company to BN150 PR128
which the wage expense is posted. 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
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK120
PCD-WE-ACCT-UNIT Alpha 15 AC541 AC542
Wage Expense Contains the accounting unit to which BN09.2 BN150
Accounting Unit 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
PCD-WE-ACCOUNT Numeric 6 AC541 AC542
Wage Expense Account Contains the account to which wage BN09.2 BN150
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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
PCD-WE-SUB-ACCT Numeric 4 AC541 AC542
Wage Expense Contains the subaccount to which wage BN09.2 BN150
Subaccount 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
PCD-CR-DIST-CO Numeric 4 AC542 PR195
Cr Dist Co 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 AC542 BN09.2
Non-Cash Income Contains the credit accounting unit for PR195 PR197
Credit Acct Un calculation type F (Non-Cash Income) pay PR20.4 PR82.1
codes. PR85.1
PCD-CR-ACCOUNT Numeric 6 AC542 BN09.2
Non-Cash Income Contains the credit account for PR195 PR197
Credit Account calculation type F (Non-Cash Income) PR20.4 PR82.1
pay codes. PR85.1
PCD-CR-SUB-ACCT Numeric 4 AC542 BN09.2
Cr Sub Acct Contains the credit subaccount for PR195 PR197
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 AC541 AC542
Ot Prem Rate Contains the rate used to calculate the BN09.2 BN150
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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
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 AC541 AC542
Sequence Number An automatically assigned sequence BN09.2 BN150
number. 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
PCD-USED-FLAG Alpha 1 AC542 BN09.2
Used Indicates if the record has been PR195 PR197
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 AC541 AC542
Activity Activities are the processes or BN09.2 BN150
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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120
PCD-ACCT-CATEGORY Alpha 5 AC541 AC542
Account Category Account categories are groupings of BN150 PR128
costs, revenues, or a combination of PR130 PR131
both used for reporting and inquiries PR132 PR134
for activities in the Activity PR136 PR189
Management system. All transactions are PR20.4 PR29.1
posted to an account category within an PR32.2 PR33.2
activity. You can assign a specific PR33.3 PR35.1
General Ledger account or range of PR35.2 PR35.3
accounts (company, accounting unit, PR35.4 PR35.5
account, and subaccount) that make up PR35.6 PR35.8
the transactions posted to an account PR36.1 PR45.1
category using AC07.1 (Account PR529 PR530
Assignment). PR560 PR80.1
PR82.1 TA147
Period-to-date, year-to-date, and UK102 UK120
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.
PCD-SHIFT-CODE Alpha 4 AC541 AC542
Shift Code Contains the shift table that applies BN150 PR128
to this pay code. 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
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK120
PCD-CURRENCY-CODE Alpha 5 PR20.4
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PCD-CURR-ND Numeric 1 PR20.4
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
PCD-ATTEND-CODE Alpha 2
Attendance 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
Payment Class
PCD-ACTIVE-FLAG Alpha 1
Status The Active flag of the credit card
type.
" " = Active
I = Inactive
PCD-ALLOW-HOURS Numeric 1
Allow Hours 0 = No
1 = Yes
PCD-NON-EARNINGS Numeric 1
Non Earnings 0 = No - wages
1 = Yes - other remuneration
PRPAYCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PCDSET1 COMPANY AC541 AC542
PROCESS-LEVEL AC550 AC57.1
JOB-CODE BN09.2 BN150
PAY-CODE BN215 HR00.1
HR01.1 PBIP.1
PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR197
PR20.4 PR20.7
PR220 PR229
PR24.1 PR29.1
PR30.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
...
PCDSET3 COMPANY KeyChange PR115 PR20.2
PAY-SUM-GRP PR20.4 PR220
PAY-CODE
PROCESS-LEVEL
JOB-CODE
PCDSET4 COMPANY AC550 AC57.1
PAY-CODE BN06.1 BN15.1
PROCESS-LEVEL BN150 BN206
JOB-CODE HPCD.1 HR14.1
HR514 HS01.1
HS02.1 PR128
PR131 PR134
PR136 PR139
PR189 PR20.4
PR21.1 PR23.1
PR23.3 PR25.2
PR26.1 PR28.1
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
...
PCDSET5 COMPANY AC542 BN09.2
SEQ-NBR BN134 BN66.1
HR170 HR70.1
PR130 PR131
PR132 PR134
PR135 PR139
PR140 PR141
PR189 PR195
PR197 PR198
PR20.4 PR229
PR24.1 PR260
PR29.1 PR295
PR32.2 PR35.1
PR35.2 PR35.6
PR36.1 PR530
...
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
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
|