PRSHIFTTBL – This detail file contains shift differential rates by shift code and can be assigned by job code, grade range schedule…

System
Payroll (PR)
Prefix
PSB
Primary key
COMPANY, SHIFT-CODE, EFFECT-DATE, OBJ-ID
Fields
14
Updated by
2 programs
Referenced by
46 programs

PRSHIFTTBL is the This detail file contains shift differential rates by shift code and can be assigned by job code, grade range schedule… table in Lawson Payroll (prefix PSB). It is indexed by COMPANY, SHIFT-CODE, EFFECT-DATE, OBJ-ID (PSBSET1); alternate indexes: PSBSET2, PSBSET3 and PSBSET4. It is related 1:1 to PRSYSTEM, JOBCODE and PRSHIFTHDR and 1:M to PRSAGHEAD and PRSAGDTL. It is updated by PA95.1 and PR24.1 and referenced by BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 and 38 more. The table has 14 fields, 4 indexes and 5 documented relations.

About PRSHIFTTBL

This detail file contains shift differential rates by shift code and can be assigned by job code, grade range schedule, and step and grade schedule. The shift differential rates can be defined as amounts or percents.

Fields (14)

Column = COBOL field name without the PSB- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
PSB-COMPANY PK
COMPANY		Numeric 4Contains the company number.PR24.1
PSB-SHIFT-CODE PK
SHIFT_CODE		Alpha 4Contains the shift table.PR24.1
PSB-EFFECT-DATE PK
EFFECT_DATE		Numeric 8 (yyyymmdd)Contains the date the shift takes effect.PR24.1
PSB-OBJ-ID PK
OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.PR24.1
PSB-SHIFT
SHIFT		Numeric 1Contains the shift number associated with the pay.PR24.1
PSB-JOB-CODE
JOB_CODE		Alpha 9Contains a user-defined code that represents a type of job.PR24.1
PSB-INDICATOR
INDICATOR		Alpha 1Indicates whether pay for this shift is based on a grade range or a step and grade schedule.
  • G Grade Range
  • S Step and Grade
PR24.1
PSB-SCHEDULE
SCHEDULE		Alpha 9Contains the shift's schedule.PR24.1
PSB-PAY-GRADE
PAY_GRADE		Alpha 3Contains the pay grade.PR24.1
PSB-PAY-STEP
PAY_STEP		Numeric 2Contains the pay step.PR24.1
PSB-RATE
RATE		Signed 13.4Contains a flat rate or percentage that the shift differential rate is based on.PR24.1
PSB-PERCENT-OF
PERCENT_OF		Numeric 1Indicates whether the shift differential percentage should be based on the minimum, midpoint, or maximum rate for the shift.
  • 1 Minimum
  • 2 Midpoint
  • 3 Maximum
PR24.1
PSB-SH-ACCOUNT
SH_ACCOUNT		Numeric 6Contains the account to which shift expenses should be posted.PR195, PR197, PR24.1, PR582, PR82.1, PR85.1
PSB-SH-SUB-ACCT
SH_SUB_ACCT		Numeric 4Contains the subaccount to which the shift expenses should be posted.PR195, PR197, PR24.1, PR582, PR82.1, PR85.1

Indexes (4)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PSBSET1COMPANY, SHIFT-CODE, EFFECT-DATE, OBJ-IDPrimaryZH230, ZH500, PA95.1, PR24.1
PSBSET2COMPANY, SHIFT-CODE, EFFECT-DATE, SHIFT, JOB-CODE, INDICATOR, SCHEDULE, PAY-GRADE, PAY-STEPKeyChangePR220, PR24.1
PSBSET3COMPANY, SHIFT-CODE, SHIFT, EFFECT-DATE, JOB-CODE, INDICATOR, SCHEDULE, PAY-GRADE, PAY-STEPKeyChangeBN150, PR521, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +22 more (list truncated in source)
PSBSET4OBJ-IDPR195, PR197, PR582, PR82.1, PR85.1

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredPSB-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
Job CodeJOBCODERequiredPSB-COMPANY → JBC-COMPANY, PSB-JOB-CODE → JBC-JOB-CODE
Shift HeaderPRSHIFTHDRRequiredPSB-COMPANY → PSH-COMPANY, PSB-SHIFT-CODE → PSH-SHIFT-CODE, PSB-EFFECT-DATE → PSH-EFFECT-DATE

One to many (2) — child tables

RelationTableRulesConditionField map
Step And GradePRSAGHEADPSB-COMPANY → SGH-COMPANY, PSB-INDICATOR → SGH-INDICATOR, PSB-SCHEDULE → SGH-SCHEDULE, → SGH-EFFECT-DATE
Step Grade DtlPRSAGDTLPSB-COMPANY → SGD-COMPANY, PSB-SCHEDULE → SGD-SCHEDULE, PSB-PAY-GRADE → SGD-PAY-GRADE, PSB-PAY-STEP → SGD-PAY-STEP, → SGD-EFFECT-DATE

Programs

Updated by (2)

Referenced by (46)