 |
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 AC542 AC550 AC57.1 BN150 BN215
PR128 PR131 PR132 PR134 PR136 PR220
PR229 PR24.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 PR530 PR560
UK102 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 TM01.1
UK20.1 UK20.2 UK220 BN134 HR170 HR70.1
PR130 PR135 PR141 PR260 PR295 PR70.1
PRSA.1 UK260
UPDATED BY
BN06.1 BN09.2 BN15.1 PR195 PR197 PR20.4
PR82.1 PR85.1 HR00.1 HR01.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 PR131
levels or limit the use of the pay code PR132 PR134
to a specific process level. PR136 PR20.4
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR530
PR82.1 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 PR131
codes, or limit the use of the pay code PR132 PR134
to a specific process level. PR136 PR20.4
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR530
PR82.1 UK102
UK120
PCD-PAY-CODE Alpha 4 AC541 AC542
Payment Code Contains the user-defined pay code. BN09.2 BN150
PR128 PR131
PR132 PR134
PR136 PR20.4
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR530
PR70.1 PR82.1
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 PR131
code determines the way the system uses PR132 PR134
this field. PR136 PR20.4
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR530
PR82.1 UK102
UK120
PCD-SHIFT1 Signed 13.4 AC541 AC542
Shift One Contains the premium rate for shift 1. BN09.2 BN150
Differential PR128 PR131
PR132 PR134
PR136 PR20.4
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR530
PR82.1 UK102
UK120
PCD-SHIFT2 Signed 13.4 AC541 AC542
Shift Two Contains the premium rate for shift 2. BN09.2 BN150
Differential PR128 PR131
PR132 PR134
PR136 PR20.4
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR530
PR82.1 UK102
UK120
PCD-SHIFT3 Signed 13.4 AC541 AC542
Shift Three Contains the premium rate for shift 3. BN09.2 BN150
Differential PR128 PR131
PR132 PR134
PR136 PR20.4
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR530
PR82.1 UK102
UK120
PCD-SHIFT4 Signed 13.4 AC541 AC542
Shift Four Contains the premium rate for shift 4. BN09.2 BN150
Differential PR128 PR131
PR132 PR134
PR136 PR20.4
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR530
PR82.1 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 PR131
how this field is used, see the Payroll PR132 PR134
Procedures Manual. PR136 PR20.4
D = Rate Shift Differential PR32.2 PR33.2
F = Non-cash Income PR33.3 PR35.1
H = Hours Only PR35.2 PR35.3
P = Normal with percent rate PR35.4 PR35.5
Q = Percentage With Rate Shft Diff PR35.6 PR35.8
R = Normal Rate PR36.1 PR530
X = Custom Calculation PR82.1 UK102
S = Percent Shift Differential UK120
B = Percentage With Percent Shft D
A = Additional Flat Rate
C = Percentage of Current Earnings
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 PR131
Pay Summary Groups file. The system PR132 PR134
creates all payroll hours and wage PR136 PR20.4
amount history by pay summary group, not PR32.2 PR33.2
by pay code. PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR530
PR82.1 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. PR131 PR132
PR134 PR136
PR20.4 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR530 PR82.1
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 PR131
PR132 PR134
PR136 PR20.4
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR530
PR82.1 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 PR131
PR132 PR134
PR136 PR20.4
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR530
PR82.1 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 PR131
PR132 PR134
PR136 PR20.4
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR530
PR82.1 UK102
UK120
PCD-CR-DIST-CO Numeric 4 PR195 PR197
Cr Dist Co Contains the distribution company for PR20.4 PR82.1
calculation type F (Non-Cash Income) pay PR85.1
codes.
PCD-CR-ACCT-UNIT Alpha 15 BN09.2 PR195
Non-Cash Income Contains the credit accounting unit for PR197 PR20.4
Credit Acct Un calculation type F (Non-Cash Income) pay PR82.1 PR85.1
codes.
PCD-CR-ACCOUNT Numeric 6 BN09.2 PR195
Non-Cash Income Contains the credit account for PR197 PR20.4
Credit Account calculation type F (Non-Cash Income) PR82.1 PR85.1
pay codes.
PCD-CR-SUB-ACCT Numeric 4 BN09.2 PR195
Cr 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 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 PR131
system includes the resulting amount in PR132 PR134
the gross pay for the payment and stores PR136 PR20.4
it in a separate field for workers' PR32.2 PR33.2
compensation purposes. PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR530
PR82.1 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 PR131
PR132 PR134
PR136 PR20.4
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR530
PR82.1 UK102
UK120
PCD-USED-FLAG Alpha 1 BN09.2 PR195
Used Indicates if the record has been PR197 PR82.1
accessed by some source after creation. 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 PR131
objects (products, services, customers, PR132 PR134
and so on) are the reasons for PR136 PR20.4
performing the activity. PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR530
PR82.1 UK102
UK120
PCD-ACCT-CATEGORY Alpha 5 AC541 AC542
Account Category Account categories are groupings of BN150 PR128
costs, revenues, or a combination of PR131 PR132
both used for reporting and inquiries PR134 PR136
for activities in the Activity PR20.4 PR32.2
Management system. All transactions are PR33.2 PR33.3
posted to an account category within an PR35.1 PR35.2
activity. You can assign a specific PR35.3 PR35.4
General Ledger account or range of PR35.5 PR35.6
accounts (company, accounting unit, PR35.8 PR36.1
account, and subaccount) that make up PR530 PR82.1
the transactions posted to an account UK102 UK120
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.
PCD-SHIFT-CODE Alpha 4 AC541 AC542
Shift Code Contains the shift table that applies BN150 PR128
to this pay code. PR131 PR132
PR134 PR136
PR20.4 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR530 PR82.1
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
Payment Class
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 PR128
PR131 PR132
PR134 PR136
PR197 PR20.4
PR20.7 PR220
PR229 PR24.1
PR30.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
...
PCDSET3 COMPANY KeyChange AC550 AC57.1
PAY-SUM-GRP PR115 PR20.2
PAY-CODE PR20.4 PR220
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
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
...
PCDSET5 COMPANY BN09.2 BN134
SEQ-NBR HR170 HR70.1
PR130 PR131
PR132 PR134
PR135 PR139
PR141 PR195
PR197 PR20.4
PR229 PR24.1
PR260 PR295
PR32.2 PR35.1
PR35.2 PR35.6
PR36.1 PR530
PR70.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
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
|