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 AC541 AC542 BN150 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 PR36.1 PR45.1
PR529 PR530 PR560 PR80.1 PR82.1 UK102
TA147 UK120 PR195 PR197 PR85.1
UPDATED BY
PR24.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PSB-COMPANY Numeric 4 PR24.1
Company Contains the company number.
PSB-SHIFT-CODE Alpha 4 PR24.1
Shift Code Contains the shift table.
PSB-EFFECT-DATE Numeric 8 (yyyymmdd) PR24.1
Effective Date Contains 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
Shift Contains the shift number associated
with the pay.
PSB-JOB-CODE Alpha 9 PR24.1
Job Code Contains a user-defined code that
represents a type of job.
PSB-INDICATOR Alpha 1 PR24.1
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
Schedule Contains the shift's schedule.
PSB-PAY-GRADE Alpha 3 PR24.1
Grade Contains the pay grade.
PSB-PAY-STEP Numeric 2 PR24.1
Step Contains the pay step.
PSB-RATE Signed 13.4 PR24.1
Rate Contains a flat rate or percentage that
the shift differential rate is based on.
PSB-PERCENT-OF Numeric 1 PR24.1
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 AC542 PR195
Sh Account Contains the account to which shift PR197 PR24.1
expenses should be posted. PR82.1 PR85.1
PSB-SH-SUB-ACCT Numeric 4 AC542 PR195
Sh 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 AC541 AC542
SHIFT-CODE BN150 PR128
SHIFT PR130 PR131
EFFECT-DATE PR132 PR134
JOB-CODE PR136 PR189
INDICATOR PR29.1 PR32.2
SCHEDULE PR33.2 PR33.3
PAY-GRADE PR35.1 PR35.2
PAY-STEP PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
UK102 TA147
...
PSBSET4 OBJ-ID AC542 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
|
