PRSHIFTHDR

Contains the shift table code definitions.

REFERENCED BY
BN150 PR521 EXI2.1 EXI4.1 LP130 PR128
PR130 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 PR37.1
PR45.1 PR529 PR530 PR560 PR582 PR80.1
PR80.4 PR82.1 UK102 UK560 ZP530 TA147


UPDATED BY
ZH230 PR20.4 PR220 PR24.1

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 PR130
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


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 11:27:22 2016

Home
Contact Us



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