PRSHIFTHDR – Contains the shift table code definitions.
- System
- Payroll (PR)
- Prefix
PSH- Primary key
COMPANY,SHIFT-CODE,EFFECT-DATE- Fields
- 7
- Updated by
- 41 programs
- Referenced by
- 3 programs
PRSHIFTHDR is the Contains the shift table code definitions. table in Lawson Payroll (prefix PSH). It is indexed by COMPANY, SHIFT-CODE, EFFECT-DATE (PSHSET1); alternate indexes: PSHSET2. It is related 1:1 to PRSYSTEM and 1:M to PRSHIFTTBL. It is updated by BN150, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132, PR134 and 33 more and referenced by PR20.4, PR220 and ZH230. The table has 7 fields, 2 indexes and 2 documented relations.
About PRSHIFTHDR
Contains the shift table code definitions.
Fields (7)
Column = COBOL field name without the PSH- 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 / column | Type | Description & values | Updated by |
|---|---|---|---|
#PSH-COMPANY PKCOMPANY | Numeric 4 | — | PR24.1 |
#PSH-SHIFT-CODE PKSHIFT_CODE | Alpha 4 | Contains the shift table. | PR24.1 |
#PSH-EFFECT-DATE PKEFFECT_DATE | Numeric 8 (yyyymmdd) | Contains the date the shift takes effect. | PR24.1 |
#PSH-GRADE-RNG-PCTGRADE_RNG_PCT | Alpha 1 | Indicates whether the rates are a percent of grade range.
| PR24.1 |
#PSH-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | Contains the shift description. | PR24.1 |
#PSH-CURRENCY-CODECURRENCY_CODE | Alpha 5 | This field contains the company base currency code established in Company (GL10.1 ). | PR24.1 |
#PSH-CURR-NDCURR_ND | Numeric 1 | The number of decimals assigned to a particular account as determined by the account currency. | PR24.1 |
Indexes (2)
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PSHSET1 |
| Primary | PR20.4, PR220, PR24.1 | |
PSHSET2 |
| BN150, PR521, ZH230, EXI2.1, EXI4.1, LP130, PR128, PR131 +22 more (list truncated in source) |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Company | PRSYSTEM | Required |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Shift Table | PRSHIFTTBL | Delete Cascades |
|
Programs
Updated by (41)
- BN150 Life Insurance Reportable Income
- EXI2.1 Invoke for PRTRDPD
- EXI4.1 Invoke for PRPRBPD
- LP130 Absence Plan Payout
- PR128 Offset Time Record Creation
- PR131 Retroactive Pay Calculation
- PR132 FLSA Overtime Calculation
- PR134 Automatic Time Records
- PR135 Time Record Edit
- PR136 Missing Time Records
- PR137 Batch Time Record Update
- PR189 Gross Up Calculation
- PR24.1 Shift Table
- PR29.1 Pension Payment Maintenance
- PR32.1 Employee Daily Time Entry
- PR32.2 Employee Daily Time Entry
- PR33.1 Speed Entry Setup
- PR33.2 Speed Entry by Number
- PR33.3 Speed Entry by Name
- PR35.1 Time Entry
- PR35.2 Detail Time Entry
- PR35.3 Speed Time Entry
- PR35.4 Step and Grade, Grade Range Time Entry
- PR35.5 Attendance Time Entry
- PR35.6 Activity Time Entry
- PR35.8 Position Time Entry
- PR35.9 Reason Code Time Entry
- PR36.1 Time Record Entry
- PR36.4 Manual Time Record Maintenance
- PR37.1 Batch Time Control
- PR45.1 Error Processing
- PR521 Nonstandard Pay and Work Period CSV Load
- PR529 Pension Payroll Conversion
- PR530 Time Record Interface CSV
- PR560 Payroll History Load CSV
- PR582 Mass Adjustment Load
- PR80.1 Manual Check
- PR80.4 Manual Payment
- PR82.1 Adjustment
- TA147 Canada Vacation Audit
- UK102 Bonus Pay Update