|
|
PRSHIFTTBL FILE
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
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 PR195 PR197
PR85.1
UPDATED BY
PR24.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PSB-COMPANY Numeric 4 PR24.1
Element: Company Hr Contains the company number.
PSB-SHIFT-CODE Alpha 4 PR24.1
Element: Shift Code Contains the shift table.
PSB-EFFECT-DATE Numeric 8 (yyyymmdd) PR24.1
Element: Effect Date Contains the date the shift takes
effect.
PSB-OBJ-ID Numeric 12 PR24.1
Element: Obj Id 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.
PSB-SHIFT Numeric 1 PR24.1
Element: Shift Contains the shift number associated
with the pay.
PSB-JOB-CODE Alpha 9 PR24.1
Element: Job Code Contains a user-defined code that
represents a type of job.
PSB-INDICATOR Alpha 1 PR24.1
Element: Indicator 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
PSB-SCHEDULE Alpha 9 PR24.1
Element: Schedule Contains the shift's schedule.
PSB-PAY-GRADE Alpha 3 PR24.1
Element: Pay Grade Contains the pay grade.
PSB-PAY-STEP Numeric 2 PR24.1
Element: Pay Step Contains the pay step.
PSB-RATE Signed 13.4 PR24.1
Element: Rate Contains a flat rate or percentage that
the shift differential rate is based on.
PSB-PERCENT-OF Numeric 1 PR24.1
Element: Percent Of 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
PSB-SH-ACCOUNT Numeric 6 ET530 PR195
Element: Account Contains the account to which shift PR197 PR24.1
expenses should be posted. PR82.1 PR85.1
PSB-SH-SUB-ACCT Numeric 4 ET530 PR195
Element: Sub Acct Contains the subaccount to which the PR197 PR24.1
shift expenses should be posted. PR82.1 PR85.1
PRSHIFTTBL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PSBSET1 COMPANY PR24.1
SHIFT-CODE
EFFECT-DATE
OBJ-ID
PSBSET2 COMPANY KeyChange PR220 PR24.1
SHIFT-CODE
EFFECT-DATE
SHIFT
JOB-CODE
INDICATOR
SCHEDULE
PAY-GRADE
PAY-STEP
PSBSET3 COMPANY KeyChange BN150 ET530
SHIFT-CODE ETI2.1 LP130
SHIFT PR128 PR130
EFFECT-DATE PR131 PR132
JOB-CODE PR134 PR136
INDICATOR PR189 PR29.1
SCHEDULE PR32.2 PR33.2
PAY-GRADE PR33.3 PR35.1
PAY-STEP 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
...
PSBSET4 OBJ-ID ET530 PR195
PR197 PR82.1
PR85.1
PRSHIFTTBL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|
