Lawson Insight Technical Documentation |
|
PRSHIFTHDR
PRSHIFTHDR FILE
Contains the shift table code definitions.
REFERENCED BY
PR20.4 PR220 BN150 ET530 ETI2.1 LP130
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
PR35.9 PR36.1 PR45.1 PR529 PR530 PR560
PR80.1 PR82.1 UK102 UK560 TA147
UPDATED BY
PR24.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PSH-COMPANY Numeric 4 PR24.1
Element: Company Hr
PSH-SHIFT-CODE Alpha 4 PR24.1
Element: Shift Code Contains the shift table.
PSH-EFFECT-DATE Numeric 8 (yyyymmdd) PR24.1
Element: Effect 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
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
PRSHIFTHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PSHSET1 COMPANY PR20.4 PR220
SHIFT-CODE PR24.1
EFFECT-DATE
PSHSET2 COMPANY BN150 ET530
SHIFT-CODE ETI2.1 LP130
EFFECT-DATE* PR128 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
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
...
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
|