|
|
PRSHIFTTBL FILE
Shift Table Detail
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 PR131 PR132 PR134
PR136 PR137 PR140 PR150 PR195 PR199
PR32.1 PR32.2 PR33.1 PR33.2 PR33.3 PR35.1
PR35.2 PR35.3 PR35.4 PR35.5 PR35.6 PR35.8
PR36.1 PR37.1 PR45.1 PR530 PR80.1 PR82.1
PR85.1 UK102 UK330 UK120
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 PR150 PR195
Sh Account Conains the account to which shift PR199 PR24.1
expenses should be posted. PR82.1 PR85.1
PSB-SH-SUB-ACCT Numeric 4 PR150 PR195
Sh Sub Acct Contains the subaccount to which the PR199 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 PR128
SHIFT-CODE PR131 PR132
SHIFT PR134 PR136
EFFECT-DATE PR137 PR140
JOB-CODE PR150 PR195
INDICATOR PR199 PR32.1
SCHEDULE PR32.2 PR33.1
PAY-GRADE PR33.2 PR33.3
PAY-STEP PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
...
PSBSET4 OBJ-ID PR150 PR195
PR199 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
|