PRPAYCODE – Pay Code

System
Payroll (PR)
Prefix
PCD
Primary key
COMPANY, PROCESS-LEVEL, JOB-CODE, PAY-CODE
Fields
55
Updated by
55 programs
Referenced by
97 programs

PRPAYCODE is the Pay Code table in Lawson Payroll (prefix PCD). It is indexed by COMPANY, PROCESS-LEVEL, JOB-CODE, PAY-CODE (PCDSET1); alternate indexes: PCDSET3, PCDSET4, PCDSET5, PCDSET6 and PCDSET7. It is related 1:1 to ACACCTCAT, ACACTIVITY, ATTENDCODE, PRSYSTEM, GLMASTER, JOBCODE, PAYSUMGRP, PSGRELATE and 1 more and 1:M to PSGRELATE, PROTACCTS and TIMERECORD. It is updated by BN06.1, BN15.1, BN150, EXI2.1, EXI4.1, HR00.1, HR01.1, HR06.1 and 47 more and referenced by BN134, BN206, BN215, BN305, BN66.1, EX13.1, HPCD.1, HR11.1 and 89 more. The table has 55 fields, 6 indexes and 16 documented relations.

About PRPAYCODE

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.

Fields (55)

Column = COBOL field name without the PCD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PCD-COMPANY PK
COMPANY		Numeric 4—HR25.1, PR20.4
#PCD-PROCESS-LEVEL PK
PROCESS_LEVEL		Alpha 5Contains 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 +34 more
#PCD-JOB-CODE PK
JOB_CODE		Alpha 9Contains 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 +34 more
#PCD-PAY-CODE PK
PAY_CODE		Alpha 4Contains the user-defined pay code.BN150, EXI2.1, EXI4.1, HR25.1, LP130, PR128, PR131, PR132 +35 more
#PCD-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)Contains the pay code description.HR25.1, PR20.4
#PCD-NORM-RATE
NORM_RATE		Signed 13.4Contains 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 +33 more
#PCD-SHIFT1
SHIFT1		Signed 13.4Contains the premium rate for shift 1.BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +33 more
#PCD-SHIFT2
SHIFT2		Signed 13.4Contains the premium rate for shift 2.BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +33 more
#PCD-SHIFT3
SHIFT3		Signed 13.4Contains the premium rate for shift 3.BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +33 more
#PCD-SHIFT4
SHIFT4		Signed 13.4Contains the premium rate for shift 4.BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +33 more
#PCD-CALC-TYPE
CALC_TYPE		Alpha 1Contains 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 +33 more
#PCD-PAY-SUM-GRP SET3
PAY_SUM_GRP		Alpha 3Contains 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 +33 more
#PCD-WE-DIST-CO
WE_DIST_CO		Numeric 4Contains the distribution company to which the wage expense is posted.BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +33 more
#PCD-WE-ACCT-UNIT
WE_ACCT_UNIT		Alpha 15Contains the accounting unit to which wage expense is posted.BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +33 more
#PCD-WE-ACCOUNT
WE_ACCOUNT		Numeric 6Contains the account to which wage expense is posted.BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +33 more
#PCD-WE-SUB-ACCT
WE_SUB_ACCT		Numeric 4Contains the subaccount to which wage expense is posted.BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +33 more
#PCD-CR-DIST-CO
CR_DIST_CO		Numeric 4Contains the distribution company for calculation type F (Non-Cash Income) pay codes.PR20.4
#PCD-CR-ACCT-UNIT
CR_ACCT_UNIT		Alpha 15Contains the credit accounting unit for calculation type F (Non-Cash Income) pay codes.PR20.4
#PCD-CR-ACCOUNT
CR_ACCOUNT		Numeric 6Contains the credit account for calculation type F (Non-Cash Income) pay codes.PR20.4
#PCD-CR-SUB-ACCT
CR_SUB_ACCT		Numeric 4Contains the credit subaccount for calculation type F (Non-cash Income) pay codes.PR20.4
#PCD-EXCLUDE-FLAG
EXCLUDE_FLAG		Alpha 1Contains 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
OT_PREM_RATE		Signed 13.4Contains 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 +33 more
#PCD-OT-ACCOUNT
OT_ACCOUNT		Numeric 6Contains the account to which the premium expense is posted.PR20.4
#PCD-OT-SUB-ACCT
OT_SUB_ACCT		Numeric 4Contains the subaccount to which the premium expense is posted.PR20.4
#PCD-SH-ACCOUNT
SH_ACCOUNT		Numeric 6Contains the account to which the shift expense is posted.PR20.4
#PCD-SH-SUB-ACCT
SH_SUB_ACCT		Numeric 4Contains the subaccount to which the shift expense is posted.PR20.4
#PCD-SEQ-NBR SET5
SEQ_NBR		Numeric 4An automatically assigned sequence number.BN150, EXI2.1, EXI4.1, HR25.1, LP130, PR128, PR131, PR132 +34 more
#PCD-USED-FLAG
USED_FLAG		Alpha 1Indicates if the record has been accessed by some source after creation.PR195, PR197, PR560, PR582, PR82.1, PR85.1
#PCD-BN-USED-FLAG
BN_USED_FLAG		Alpha 1Contains the value that indicates if the pay code is used by the Benefits system.
  • Y Yes
  • N No
BN06.1, BN15.1
#PCD-ACTIVITY
ACTIVITY		Alpha 15Activities 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 +33 more
#PCD-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5Account 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 thruBN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +33 more
#PCD-SHIFT-CODE
SHIFT_CODE		Alpha 4Contains the shift table that applies to this pay code.BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +33 more
#PCD-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +33 more
#PCD-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +33 more
#PCD-ATTEND-CODE
ATTEND_CODE		Alpha 2A 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
PAY_CLASS		Alpha 3—PR20.4
#PCD-ACTIVE-FLAG
ACTIVE_FLAG		Alpha 1The Active flag of the credit card type. " " = Active
  • I Inactive
  • A Active
HR25.1, PR20.4
#PCD-ALLOW-HOURS
ALLOW_HOURS		Numeric 1—
  • 0 No
  • 1 Yes
PR20.4
#PCD-NON-EARNINGS
NON_EARNINGS		Numeric 1—
  • 0 No - wages
  • 1 Yes - other remuneration
BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +33 more
#PCD-UNIT-MEASURE
UNIT_MEASURE		Alpha 12—BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +33 more
#PCD-SERVICE-CODE SET6
SERVICE_CODE		Alpha 10—BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +33 more
#PCD-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)—HR25.1, PR20.4
#PCD-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)—HR25.1, PR20.4
#PCD-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)—HR25.1, PR20.4
#PCD-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)—HR25.1, PR20.4
#PCD-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)—HR25.1, PR20.4
#PCD-USER-ID
USER_ID		Alpha 10 (Lower Case)—HR25.1, PR20.4
#PCD-OVR-DED-EXP
OVR_DED_EXP		Alpha 1Add field for PR197 processing of company paid deduction expenses.
  • 1 No
  • 2 Yes
BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 +33 more
#PCD-POST-HOURS
POST_HOURS		Alpha 1Add field for PR197 processing of company paid deduction expenses.
  • 1 No
  • 2 Yes
PR20.4
#PCD-PCD-SEQ-NBR SET7
PCD_SEQ_NBR		Numeric 8—BN150, EXI2.1, EXI4.1, HR25.1, LP130, PR128, PR131, PR132 +34 more
#PCD-OVRD-JOIN-LEAV
OVRD_JOIN_LEAV		Alpha 1—
  • 1 No
  • 2 Yes
—
#PCD-ROUND-METH-DOL
ROUND_METH_DOL		Numeric 1—
  • 0 None
  • 1 Normal
  • 2 High
  • 3 Low
—
#PCD-ROUND-TO-DOL
ROUND_TO_DOL		Signed 18.6——
#PCD-STD-HRS-FLG
STD_HRS_FLG		Numeric 1—
  • 0 No
  • 1 Yes
—
#PCD-BASE-PAY-FLG
BASE_PAY_FLG		Alpha 1—
  • B Base
  • S Stipend
—

Indexes (6)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PCDSET1
  1. COMPANY
  2. PROCESS-LEVEL
  3. JOB-CODE
  4. PAY-CODE
PrimaryBN150, BN215, BN305, HR00.1, HR01.1, HR06.1, HR11.1, HR11.2 +22 more (list truncated in source)
PCDSET3
  1. COMPANY
  2. PAY-SUM-GRP
  3. PAY-CODE
  4. PROCESS-LEVEL
  5. JOB-CODE
KeyChangePR115, PR160, PR180, PR20.2, PR20.4, PR220, PR52.1, PR80.2
PCDSET4
  1. COMPANY
  2. PAY-CODE
  3. PROCESS-LEVEL
  4. JOB-CODE
BN06.1, BN15.1, BN150, BN206, HPCD.1, HR14.1, HR25.1, HR250 +22 more (list truncated in source)
PCDSET5
  1. COMPANY
  2. SEQ-NBR
SubsetWhere PCD-SEQ-NBR = ZeroesBN134, BN150, BN66.1, HR170, HR25.1, HR70.1, PR521, EXI2.1 +22 more (list truncated in source)
PCDSET6
  1. COMPANY
  2. SERVICE-CODE
  3. PROCESS-LEVEL
  4. JOB-CODE
  5. PAY-CODE
SubsetWhere (SERVICE-CODE != Spaces)BN150, HR11.1, HR511, HS19.2, LT101, LT111, PR521, EXI2.1 +22 more (list truncated in source)
PCDSET7
  1. COMPANY
  2. PCD-SEQ-NBR
SubsetWhere PCD-SEQ-NBR > 9999BN134, BN150, BN66.1, HR170, HR25.1, HR70.1, PR521, EXI2.1 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACCTCATACACTIVITYATTENDCODEPRSYSTEMGLMASTERJOBCODEPAYSUMGRPPSGRELATETASERVCODEPSGRELATEPROTACCTSTIMERECORDPRPAYCODE

One to one (12) — lookups and parents

RelationTableRulesConditionField map
Acct CategoryACACCTCATRequiredWhen PCD-ACCT-CATEGORY != Spaces
PCD-ACCT-CATEGORY→AAX-ACCT-CATEGORY
ActivityACACTIVITYRequiredWhen PCD-ACTIVITY != Spaces
PCD-ACTIVITY→ACV-ACTIVITY
Attend CodeATTENDCODERequiredWhen PCD-ATTEND-CODE != Spaces
PCD-COMPANY→ATC-COMPANY
PCD-ATTEND-CODE→ATC-ATTEND-CODE
CompanyPRSYSTEMRequired
PCD-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Credit AccountGLMASTERRequiredWhen 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 CodeJOBCODERequiredWhen PCD-JOB-CODE != Spaces
PCD-COMPANY→JBC-COMPANY
PCD-JOB-CODE→JBC-JOB-CODE
Pay Sum GrpPAYSUMGRPRequiredWhen PCD-PAY-SUM-GRP != Spaces
PCD-COMPANY→PSG-COMPANY
PCD-PAY-SUM-GRP→PSG-PAY-SUM-GRP
Pik Pay ClassPSGRELATENot RequiredValid 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 LevelPRSYSTEMRequiredWhen PCD-PROCESS-LEVEL != Spaces
PCD-COMPANY→PRS-COMPANY
PCD-PROCESS-LEVEL→PRS-PROCESS-LEVEL
Service CodeTASERVCODERequiredWhen (PCD-SERVICE-CODE != Spaces)
PCD-COMPANY→TSC-COMPANY
PCD-SERVICE-CODE→TSC-SERVICE-CODE
Tip Pay ClassPSGRELATENot RequiredValid When PCD-PAY-SUM-GRP != Spaces
PCD-COMPANY→PSR-COMPANY
PRS-TIPS→PSR-PAY-CLASS
PCD-PAY-SUM-GRP→PSR-PAY-SUM-GRP
We AccountGLMASTERRequiredWhen 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

One to many (4) — child tables

RelationTableRulesConditionField map
Pay ClassesPSGRELATEValid When PCD-PAY-SUM-GRP != Spaces
PCD-COMPANY→PSR-COMPANY
PCD-PAY-SUM-GRP→PSR-PAY-SUM-GRP
—→PSR-PAY-CLASS
ProtacctsPROTACCTSDelete 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 RecordsTIMERECORDDelete RestrictedValid When PCD-PCD-SEQ-NBR = Zeroes
PCD-COMPANY→TRD-COMPANY
PCD-SEQ-NBR→TRD-PCD-SEQ-NBR
—→TRD-EMPLOYEE
—→TRD-TIME-SEQ
Time Records2TIMERECORDDelete RestrictedValid When PCD-PCD-SEQ-NBR > 9999
PCD-COMPANY→TRD-COMPANY
PCD-PCD-SEQ-NBR→TRD-PCD-SEQ-NBR
—→TRD-EMPLOYEE
—→TRD-TIME-SEQ

Programs

Updated by (55)

Referenced by (97)