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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET2 SET3
SHIFT		Numeric 1Contains the shift number associated with the pay.PR24.1
#PSB-JOB-CODE SET2 SET3
JOB_CODE		Alpha 9Contains a user-defined code that represents a type of job.PR24.1
#PSB-INDICATOR SET2 SET3
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 SET2 SET3
SCHEDULE		Alpha 9Contains the shift's schedule.PR24.1
#PSB-PAY-GRADE SET2 SET3
PAY_GRADE		Alpha 3Contains the pay grade.PR24.1
#PSB-PAY-STEP SET2 SET3
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 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
PSBSET1
  1. COMPANY
  2. SHIFT-CODE
  3. EFFECT-DATE
  4. OBJ-ID
PrimaryZH230, ZH500, PA95.1, PR24.1
PSBSET2
  1. COMPANY
  2. SHIFT-CODE
  3. EFFECT-DATE
  4. SHIFT
  5. JOB-CODE
  6. INDICATOR
  7. SCHEDULE
  8. PAY-GRADE
  9. PAY-STEP
KeyChangePR220, PR24.1
PSBSET3
  1. COMPANY
  2. SHIFT-CODE
  3. SHIFT
  4. EFFECT-DATE
  5. JOB-CODE
  6. INDICATOR
  7. SCHEDULE
  8. PAY-GRADE
  9. PAY-STEP
KeyChangeBN150, PR521, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +22 more (list truncated in source)
PSBSET4
  1. OBJ-ID
PR195, PR197, PR582, PR82.1, PR85.1

Relations

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

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
PSB-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Job CodeJOBCODERequired
PSB-COMPANY→JBC-COMPANY
PSB-JOB-CODE→JBC-JOB-CODE
Shift HeaderPRSHIFTHDRRequired
PSB-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 GradePRSAGHEAD
PSB-COMPANY→SGH-COMPANY
PSB-INDICATOR→SGH-INDICATOR
PSB-SCHEDULE→SGH-SCHEDULE
—→SGH-EFFECT-DATE
Step Grade DtlPRSAGDTL
PSB-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)