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.

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
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
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
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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PCDSET1COMPANY, PROCESS-LEVEL, JOB-CODE, PAY-CODEPrimaryBN150, BN215, BN305, HR00.1, HR01.1, HR06.1, HR11.1, HR11.2 +22 more (list truncated in source)
PCDSET3COMPANY, PAY-SUM-GRP, PAY-CODE, PROCESS-LEVEL, JOB-CODEKeyChangePR115, PR160, PR180, PR20.2, PR20.4, PR220, PR52.1, PR80.2
PCDSET4COMPANY, PAY-CODE, PROCESS-LEVEL, JOB-CODEBN06.1, BN15.1, BN150, BN206, HPCD.1, HR14.1, HR25.1, HR250 +22 more (list truncated in source)
PCDSET5COMPANY, SEQ-NBRSubsetWhere PCD-SEQ-NBR = ZeroesBN134, BN150, BN66.1, HR170, HR25.1, HR70.1, PR521, EXI2.1 +22 more (list truncated in source)
PCDSET6COMPANY, SERVICE-CODE, PROCESS-LEVEL, JOB-CODE, PAY-CODESubsetWhere (SERVICE-CODE != Spaces)BN150, HR11.1, HR511, HS19.2, LT101, LT111, PR521, EXI2.1 +22 more (list truncated in source)
PCDSET7COMPANY, PCD-SEQ-NBRSubsetWhere PCD-SEQ-NBR > 9999BN134, BN150, BN66.1, HR170, HR25.1, HR70.1, PR521, EXI2.1 +22 more (list truncated in source)

Relations

One to one (12) — lookups and parents

RelationTableRulesConditionField map
Acct CategoryACACCTCATRequiredWhen PCD-ACCT-CATEGORY != SpacesPCD-ACCT-CATEGORY → AAX-ACCT-CATEGORY
ActivityACACTIVITYRequiredWhen PCD-ACTIVITY != SpacesPCD-ACTIVITY → ACV-ACTIVITY
Attend CodeATTENDCODERequiredWhen PCD-ATTEND-CODE != SpacesPCD-COMPANY → ATC-COMPANY, PCD-ATTEND-CODE → ATC-ATTEND-CODE
CompanyPRSYSTEMRequiredPCD-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
Credit AccountGLMASTERRequiredWhen PCD-CR-ACCT-UNIT != Spaces Or PCD-CR-ACCOUNT != ZeroesPCD-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 != SpacesPCD-COMPANY → JBC-COMPANY, PCD-JOB-CODE → JBC-JOB-CODE
Pay Sum GrpPAYSUMGRPRequiredWhen PCD-PAY-SUM-GRP != SpacesPCD-COMPANY → PSG-COMPANY, PCD-PAY-SUM-GRP → PSG-PAY-SUM-GRP
Pik Pay ClassPSGRELATENot RequiredValid When PCD-PAY-SUM-GRP != SpacesPCD-COMPANY → PSR-COMPANY, PRS-PAY-IN-KIND → PSR-PAY-CLASS, PCD-PAY-SUM-GRP → PSR-PAY-SUM-GRP
Process LevelPRSYSTEMRequiredWhen PCD-PROCESS-LEVEL != SpacesPCD-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 != SpacesPCD-COMPANY → PSR-COMPANY, PRS-TIPS → PSR-PAY-CLASS, PCD-PAY-SUM-GRP → PSR-PAY-SUM-GRP
We AccountGLMASTERRequiredWhen PCD-WE-ACCOUNT != ZeroesPCD-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 != SpacesPCD-COMPANY → PSR-COMPANY, PCD-PAY-SUM-GRP → PSR-PAY-SUM-GRP, → PSR-PAY-CLASS
ProtacctsPROTACCTSDelete CascadesPCD-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 = ZeroesPCD-COMPANY → TRD-COMPANY, PCD-SEQ-NBR → TRD-PCD-SEQ-NBR, → TRD-EMPLOYEE, → TRD-TIME-SEQ
Time Records2TIMERECORDDelete RestrictedValid When PCD-PCD-SEQ-NBR > 9999PCD-COMPANY → TRD-COMPANY, PCD-PCD-SEQ-NBR → TRD-PCD-SEQ-NBR, → TRD-EMPLOYEE, → TRD-TIME-SEQ

Programs

Updated by (55)

Referenced by (97)