Lawson Insight Technical Documentation |
|
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 PR128 PR130 PR131 PR132
PR134 PR136 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
PR560 UK102 TA147 TP135 PR115 PR52.1
BN206 HPCD.1 HR14.1 HR250 HR514 PR21.1
HS01.1 HS02.1 PR23.1 PR23.3 PR25.2 PR26.1
PR28.1 PR37.1 PR46.2 PR47.1 UK46.2 UK47.1
TA40.2 TA40.3 TM01.1 BN134 HR170 HR70.1
PA495 PA82.1 PR135 PR141 PR198 PR260
PR295 PR70.1 PRSA.1 UK141 TA146
UPDATED BY
BN06.1 BN15.1 HR25.1 PR197 PR20.4 PR82.1
PR85.1 HR00.1 HR01.1 PBIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PCD-COMPANY Numeric 4 HR25.1 PR20.4
Element: Company Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
PCD-PROCESS-LEVEL Alpha 5 BN150 HR25.1
Element: Process Lev HrContains the process level. You define PR128 PR130
the same pay code for different process PR131 PR132
levels or limit the use of the pay code PR134 PR136
to a specific process level. 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
PR82.1 TA147
TP135 UK102
PCD-JOB-CODE Alpha 9 BN150 HR25.1
Element: Job Code Contains the job code. You can define PR128 PR130
the same pay code for different job PR131 PR132
codes, or limit the use of the pay code PR134 PR136
to a specific process level. 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
PR82.1 TA147
TP135 UK102
PCD-PAY-CODE Alpha 4 BN150 HR25.1
Element: Payment Code Contains the user-defined pay code. PR128 PR130
PR131 PR132
PR134 PR136
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 PR82.1
TA147 TP135
UK102
PCD-DESCRIPTION Alpha 30 (Lower Case) HR25.1 PR20.4
Element: Description Contains the pay code description.
PCD-NORM-RATE Signed 13.4 BN150 PR128
Element: Normal Rate Contains the rate for the pay code. The PR130 PR131
calculation type defined for the pay PR132 PR134
code determines the way the system uses PR136 PR20.4
this field. 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 PR82.1
TA147 TP135
UK102
PCD-SHIFT1 Signed 13.4 BN150 PR128
Shift One Contains the premium rate for shift 1. PR130 PR131
Differential PR132 PR134
PR136 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 PR82.1
TA147 TP135
UK102
PCD-SHIFT2 Signed 13.4 BN150 PR128
Shift Two Contains the premium rate for shift 2. PR130 PR131
Differential PR132 PR134
PR136 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 PR82.1
TA147 TP135
UK102
PCD-SHIFT3 Signed 13.4 BN150 PR128
Shift Three Contains the premium rate for shift 3. PR130 PR131
Differential PR132 PR134
PR136 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 PR82.1
TA147 TP135
UK102
PCD-SHIFT4 Signed 13.4 BN150 PR128
Shift Four Contains the premium rate for shift 4. PR130 PR131
Differential PR132 PR134
PR136 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 PR82.1
TA147 TP135
UK102
PCD-CALC-TYPE Alpha 1 BN150 PR128
Element: Calculation TyContains the calculation type for the PR130 PR131
pay code. For a detailed description of PR132 PR134
how this field is used, see the Payroll PR136 PR20.4
Procedures Manual. PR29.1 PR32.2
D = Rate Shift Differential PR33.2 PR33.3
F = Non-cash Income PR35.1 PR35.2
H = Hours Only PR35.3 PR35.4
P = Normal with percent rate PR35.5 PR35.6
Q = Percentage With Rate Shft Diff PR35.8 PR35.9
R = Normal Rate PR36.1 PR45.1
X = Custom Calculation PR529 PR530
S = Percent Shift Differential PR560 PR82.1
B = Percentage With Percent Shft D TA147 TP135
A = Additional Flat Rate UK102
C = Percentage of Current Earnings
1 = Rate X Unit
PCD-PAY-SUM-GRP Alpha 3 BN150 PR128
Payment Summary Contains the pay summary group. The PR130 PR131
Group value in this field must be valid in the PR132 PR134
Pay Summary Groups file. The system PR136 PR20.4
creates all payroll hours and wage PR29.1 PR32.2
amount history by pay summary group, not PR33.2 PR33.3
by pay code. PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR82.1
TA147 TP135
UK102
PCD-WE-DIST-CO Numeric 4 BN150 PR128
Element: Company Contains the distribution company to PR130 PR131
which the wage expense is posted. PR132 PR134
PR136 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 PR82.1
TA147 TP135
UK102
PCD-WE-ACCT-UNIT Alpha 15 BN150 PR128
Element: Accounting UniContains the accounting unit to which PR130 PR131
wage expense is posted. PR132 PR134
PR136 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 PR82.1
TA147 TP135
UK102
PCD-WE-ACCOUNT Numeric 6 BN150 PR128
Element: Account Contains the account to which wage PR130 PR131
expense is posted. PR132 PR134
PR136 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 PR82.1
TA147 TP135
UK102
PCD-WE-SUB-ACCT Numeric 4 BN150 PR128
Element: Subaccount Contains the subaccount to which wage PR130 PR131
expense is posted. PR132 PR134
PR136 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 PR82.1
TA147 TP135
UK102
PCD-CR-DIST-CO Numeric 4 PR197 PR20.4
Element: Company Contains the distribution company for PR82.1 PR85.1
calculation type F (Non-Cash Income) pay
codes.
PCD-CR-ACCT-UNIT Alpha 15 PR197 PR20.4
Element: Accounting UniContains the credit accounting unit for PR82.1 PR85.1
calculation type F (Non-Cash Income) pay
codes.
PCD-CR-ACCOUNT Numeric 6 PR197 PR20.4
Element: Account Contains the credit account for PR82.1 PR85.1
calculation type F (Non-Cash Income)
pay codes.
PCD-CR-SUB-ACCT Numeric 4 PR197 PR20.4
Element: Subaccount Contains the credit subaccount for PR82.1 PR85.1
calculation type F (Non-cash Income) pay
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 PR128
Element: Ot Prem Rate Contains the rate used to calculate the PR130 PR131
overtime premium portion of pay. The PR132 PR134
system includes the resulting amount in PR136 PR20.4
the gross pay for the payment and stores PR29.1 PR32.2
it in a separate field for workers' PR33.2 PR33.3
compensation purposes. PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR82.1
TA147 TP135
UK102
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: Subaccount 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: Subaccount Contains the subaccount to which the
shift expense is posted.
PCD-SEQ-NBR Numeric 4 BN150 HR25.1
Element: Sequence NumbeAn automatically assigned sequence PR128 PR130
number. PR131 PR132
PR134 PR136
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
PR82.1 TA147
TP135 UK102
PCD-USED-FLAG Alpha 1 PR197 PR82.1
Element: Used Indicates if the record has been PR85.1
accessed by some source after creation.
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 PR128
Element: Activity Activities are the processes or PR130 PR131
procedures that produce work. Cost PR132 PR134
objects (products, services, customers, PR136 PR20.4
and so on) are the reasons for PR29.1 PR32.2
performing the activity. 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 PR82.1
TA147 TP135
UK102
PCD-ACCT-CATEGORY Alpha 5 BN150 PR128
Element: Account CategoAccount categories are groupings of PR130 PR131
costs, revenues, or a combination of PR132 PR134
both used for reporting and inquiries PR136 PR20.4
for activities in the Activity PR29.1 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 PR35.9
account, and subaccount) that make up PR36.1 PR45.1
the transactions posted to an account PR529 PR530
category using AC07.1 (Account PR560 PR82.1
Assignment). TA147 TP135
UK102
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
PCD-SHIFT-CODE Alpha 4 BN150 PR128
Element: Shift Code Contains the shift table that applies PR130 PR131
to this pay code. PR132 PR134
PR136 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 PR82.1
TA147 TP135
UK102
PCD-CURRENCY-CODE Alpha 5 PR20.4
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PCD-CURR-ND Numeric 1 PR20.4
Account Currency Represents the number of decimals
Code defined for the currency of the object.
PCD-ATTEND-CODE Alpha 2 PR20.4
Element: Attendance CodA 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: Payment Class
PCD-ACTIVE-FLAG Alpha 1 HR25.1 PR20.4
Element: Status 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 PR20.4
Element: Non Earnings 0 = No - wages
1 = Yes - other remuneration
PCD-UNIT-MEASURE Alpha 12 PR20.4
Element: Unit Measure
PCD-SERVICE-CODE Alpha 4 PR20.4
Element: Ta Service Cd
PRPAYCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PCDSET1 COMPANY BN150 BN215
PROCESS-LEVEL HR00.1 HR01.1
JOB-CODE PBIP.1 PR128
PAY-CODE PR130 PR131
PR132 PR134
PR136 PR197
PR20.4 PR20.7
PR220 PR229
PR24.1 PR29.1
PR30.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
...
PCDSET3 COMPANY KeyChange PR115 PR20.2
PAY-SUM-GRP PR20.4 PR220
PAY-CODE PR52.1 TP135
PROCESS-LEVEL
JOB-CODE
PCDSET4 COMPANY BN06.1 BN15.1
PAY-CODE BN150 BN206
PROCESS-LEVEL HPCD.1 HR14.1
JOB-CODE HR25.1 HR250
HR514 PR21.1
HS01.1 HS02.1
PR128 PR131
PR134 PR136
PR20.4 PR23.1
PR23.3 PR25.2
PR26.1 PR28.1
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
...
PCDSET5 COMPANY BN134 HR170
SEQ-NBR HR25.1 HR70.1
PA495 PA82.1
PR130 PR131
PR132 PR134
PR135 PR141
PR197 PR198
PR20.4 PR229
PR24.1 PR260
PR29.1 PR295
PR32.2 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
...
PCDSET6 COMPANY Subset
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
|