|
|
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 PR128 PR130 PR131 PR132
PR134 PR136 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 PR82.1 UK102 TA147 TP135 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: Effective DateContains the date the shift takes
effect.
PSB-OBJ-ID Numeric 12 PR24.1
Object This is the object identifier. It is
Identification 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: Grade Contains the pay grade.
PSB-PAY-STEP Numeric 2 PR24.1
Element: 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 PR197 PR24.1
Element: Account Contains the account to which shift PR82.1 PR85.1
expenses should be posted.
PSB-SH-SUB-ACCT Numeric 4 PR197 PR24.1
Element: Subaccount Contains the subaccount to which the PR82.1 PR85.1
shift expenses should be posted.
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 PR128
SHIFT-CODE PR130 PR131
SHIFT PR132 PR134
EFFECT-DATE PR136 PR29.1
JOB-CODE PR32.2 PR33.2
INDICATOR PR33.3 PR35.1
SCHEDULE PR35.2 PR35.3
PAY-GRADE PR35.4 PR35.5
PAY-STEP PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 UK102
TA147 TP135
PSBSET4 OBJ-ID 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
|
