PRSHIFTTBL

This detail file contains shift differential rates by shift code and can be assigned by job code, grade range schedule, and step and grade schedule. The shift differential rates can be defined as amounts or percents.

REFERENCED BY
ZH230 ZH500 PR220 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 PR195 PR197 PR85.1


UPDATED BY
PR24.1 PA95.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PSB-COMPANY
Element: Company Hr		Numeric 4
Contains the company number.
PR24.1
PSB-SHIFT-CODE
Element: Shift Code		Alpha 4
Contains the shift table.
PR24.1
PSB-EFFECT-DATE
Element: Effect Date		Numeric 8 (yyyymmdd)
Contains the date the shift takes effect.
PR24.1
PSB-OBJ-ID
Element: Obj Id		Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
PR24.1
PSB-SHIFT
Element: Shift		Numeric 1
Contains the shift number associated with the pay.
PR24.1
PSB-JOB-CODE
Element: Job Code		Alpha 9
Contains a user-defined code that represents a type of job.
PR24.1
PSB-INDICATOR
Element: Indicator		Alpha 1
Indicates whether pay for this shift is based on a grade range or a step and grade schedule.
G = Grade Range
S = Step and Grade
PR24.1
PSB-SCHEDULE
Element: Schedule		Alpha 9
Contains the shift's schedule.
PR24.1
PSB-PAY-GRADE
Element: Pay Grade		Alpha 3
Contains the pay grade.
PR24.1
PSB-PAY-STEP
Element: Pay Step		Numeric 2
Contains the pay step.
PR24.1
PSB-RATE
Element: Rate		Signed 13.4
Contains a flat rate or percentage that the shift differential rate is based on.
PR24.1
PSB-PERCENT-OF
Element: Percent Of		Numeric 1
Indicates whether the shift differential percentage should be based on the minimum, midpoint, or maximum rate for the shift.
1 = Minimum
2 = Midpoint
3 = Maximum
PR24.1
PSB-SH-ACCOUNT
Element: Account		Numeric 6
Contains the account to which shift expenses should be posted.
PR195 PR197
PR24.1 PR582
PR82.1 PR85.1
PSB-SH-SUB-ACCT
Element: Sub Acct		Numeric 4
Contains the subaccount to which the shift expenses should be posted.
PR195 PR197
PR24.1 PR582
PR82.1 PR85.1


PRSHIFTTBL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PSBSET1 COMPANY
SHIFT-CODE
EFFECT-DATE
OBJ-ID
ZH230 ZH500
PA95.1 PR24.1
PSBSET2 COMPANY
SHIFT-CODE
EFFECT-DATE
SHIFT
JOB-CODE
INDICATOR
SCHEDULE
PAY-GRADE
PAY-STEP
KeyChange
PR220 PR24.1
PSBSET3 COMPANY
SHIFT-CODE
SHIFT
EFFECT-DATE
JOB-CODE
INDICATOR
SCHEDULE
PAY-GRADE
PAY-STEP
KeyChange
...
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
PSBSET4 OBJ-ID
PR195 PR197
PR582 PR82.1
PR85.1


PRSHIFTTBL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PSB-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Job Code JOBCODE Required
PSB-COMPANY->JBC-COMPANY
PSB-JOB-CODE->JBC-JOB-CODE
Shift Header PRSHIFTHDR Required
PSB-COMPANY->PSH-COMPANY
PSB-SHIFT-CODE->PSH-SHIFT-CODE
PSB-EFFECT-DATE->PSH-EFFECT-DATE


PRSHIFTTBL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Step And Grade PRSAGHEAD
PSB-COMPANY->SGH-COMPANY
PSB-INDICATOR->SGH-INDICATOR
PSB-SCHEDULE->SGH-SCHEDULE
  SGH-EFFECT-DATE
Step Grade Dtl PRSAGDTL
PSB-COMPANY->SGD-COMPANY
PSB-SCHEDULE->SGD-SCHEDULE
PSB-PAY-GRADE->SGD-PAY-GRADE
PSB-PAY-STEP->SGD-PAY-STEP
  SGD-EFFECT-DATE

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

Home
Contact Us



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