Lawson Insight Technical Documentation |
|
PRSHIFTHDR
PRSHIFTHDR FILE
Contains the shift table code definitions.
REFERENCED BY
PR20.4 PR220 AC541 AC542 BN150 PR128
PR130 PR131 PR132 PR134 PR136 PR189
PR29.1 PR32.2 PR33.2 PR33.3 PR35.1 PR35.2
PR35.3 PR35.4 PR35.5 PR35.6 PR35.8 PR36.1
PR45.1 PR529 PR530 PR560 PR80.1 PR82.1
UK102 UK560 TA147 UK120
UPDATED BY
PR24.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PSH-COMPANY Numeric 4 PR24.1
Element: Company The company number represents an
established company and is entered on
all function codes.
PSH-SHIFT-CODE Alpha 4 PR24.1
Element: Shift Code Contains the shift table.
PSH-EFFECT-DATE Numeric 8 (yyyymmdd) PR24.1
Element: Date Contains the date the shift takes
effect.
PSH-GRADE-RNG-PCT Alpha 1 PR24.1
Element: Grade Rng Pct Indicates whether the rates are a
percent of grade range.
Y = Yes
N = No
PSH-DESCRIPTION Alpha 30 (Lower Case) PR24.1
Element: Description Contains the shift description.
PSH-CURRENCY-CODE Alpha 5 PR24.1
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PSH-CURR-ND Numeric 1 PR24.1
Account Currency
Code
PRSHIFTHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PSHSET1 COMPANY PR20.4 PR220
SHIFT-CODE PR24.1
EFFECT-DATE
PSHSET2 COMPANY AC541 AC542
SHIFT-CODE BN150 PR128
EFFECT-DATE* PR130 PR131
PR132 PR134
PR136 PR189
PR20.4 PR220
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
...
PRSHIFTHDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PSH-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
PRSHIFTHDR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Shift Table PRSHIFTTBL Delete Cascades
PSH-COMPANY -> PSB-COMPANY
PSH-SHIFT-CODE -> PSB-SHIFT-CODE
PSH-EFFECT-DATE -> PSB-EFFECT-DATE
PSB-SHIFT
PSB-JOB-CODE
PSB-INDICATOR
PSB-SCHEDULE
PSB-PAY-GRADE
PSB-PAY-STEP
|