PRSHIFTHDR

Contains the shift table code definitions.

REFERENCED BY
PR20.4 PR220 ZH230


UPDATED BY
PR24.1 BN150 PR521 EXI2.1 EXI4.1 LP130
PR128 PR131 PR132 PR134 PR135 PR136
PR137 PR189 PR29.1 PR32.1 PR32.2 PR33.1
PR33.2 PR33.3 PR35.1 PR35.2 PR35.3 PR35.4
PR35.5 PR35.6 PR35.8 PR35.9 PR36.1 PR36.4
PR37.1 PR45.1 PR529 PR530 PR560 PR582
PR80.1 PR80.4 PR82.1 UK102 TA147

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PSH-COMPANY
Element: Company Hr		Numeric 4
PR24.1
PSH-SHIFT-CODE
Element: Shift Code		Alpha 4
Contains the shift table.
PR24.1
PSH-EFFECT-DATE
Element: Effect Date		Numeric 8 (yyyymmdd)
Contains the date the shift takes effect.
PR24.1
PSH-GRADE-RNG-PCT
Element: Grade Rng Pct		Alpha 1
Indicates whether the rates are a percent of grade range.
Y = Yes
N = No
PR24.1
PSH-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
Contains the shift description.
PR24.1
PSH-CURRENCY-CODE
Element: Currency Code		Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
PR24.1
PSH-CURR-ND
Element: Acct Nd		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
PR24.1


PRSHIFTHDR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PSHSET1 COMPANY
SHIFT-CODE
EFFECT-DATE
PR20.4 PR220
PR24.1
PSHSET2 COMPANY
SHIFT-CODE
EFFECT-DATE*
...
BN150 PR521
ZH230 EXI2.1
EXI4.1 LP130
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR20.4 PR220
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9


PRSHIFTHDR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PSH-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL


PRSHIFTHDR FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 02:30:42 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.