|
|
PROVERTIME FILE
Overtime Pay Plan
This file contains information about pay plans, identifying pay and work week
periods and pay frequency. If the plan is an overtime plan, this file
identifies the number of hours worked after which point overtime is paid,
either weekly or daily, and if overtime is based on a fixed or fluctuating
work period.
REFERENCED BY
BN150 PR221 PA532 HS03.1 HS535 PR128
PR130 PR131 PR132 PR134 PR136 PR137
PR160 PR180 PR20.4 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 PR39.1 PR45.1
PR529 PR530 PR560 PR82.1 UK102 UK141
UK145 UK201 UK85.1 UK85.3 TA147 TP135
BN100 BN101 BN102 BN103 BN105 BN145
BN245 BN31.1 BN31.2 BN32.1 BN32.2 BN32.3
BN45.1 BN531 BN71.1 BN72.1 BS12.1 BS13.1
BS14.1 BS15.1 BS32.1 HPRO.1 HR11.1 HR11.2
HR211 HR511 PA02.1 PA100 PA102 PA103
PA202 PA502 PA52.1 PA52.3 PA52.4 PA52.5
HS20.1 HS21.1 HS22.1 HS22.2 HS22.3 HS36.1
PR110 PR113 PR120 PR13.1 PR13.5 PR13.6
PR13.8 PR22.1 PR289 PR999 PREN.1
UPDATED BY
PR21.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRO-COMPANY Numeric 4 PR21.1
Element: Company Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
PRO-PLAN-CODE Alpha 4 PR21.1
Element: Plan Contains the user-defined code that
represents a pay plan.
PRO-EFFECT-DATE Numeric 8 (yyyymmdd) PR21.1
Element: Effective DateContains the effective date of the pay
plan.
PRO-DESCRIPTION Alpha 30 (Lower Case) PR21.1
Element: Description Contains the pay plan description.
PRO-OT-PLAN Alpha 1 PR21.1
Element: Ot Plan Contains the value that indicates if
the pay plan is an overtime pay plan.
Y = Yes
N = No
PRO-PER-END-DATE Numeric 8 (yyyymmdd) PR21.1
Element: Period End DatContains the end date of the first pay
period.
PRO-PAY-FREQUENCY Numeric 1 PR21.1
Element: Pay Frequency Contains the pay frequency defined for
the pay plan.
1 = Weekly
2 = Bi-Weekly
3 = Semi-Monthly
4 = Monthly
5 = UK Four-Weekly
PRO-WRK-END-DATE Numeric 8 (yyyymmdd) PR21.1 PR289
Element: Wrk End Date Contains the end date of the first work
period.
PRO-NBR-DAYS Numeric 2 PR21.1
Element: Number of DaysContains the number of days in the work
period.
07
28
PRO-STD-HOURS Signed 5.2 PR21.1
Element: Std Hours Contains the number of hours in the
work period after which point overtime
is paid.
PRO-MAX-HOURS-DAY Signed 4.2 PR21.1
Element: Max Hours Day Contains the number of hours in a day
after which point overtime is paid. This
value is used for plans that pay
overtime for hours worked in excess of a
daily limit.
PRO-OT-PREM-RATE Signed 13.4 PR21.1
Element: Ot Prem Rate Contains the overtime premium rate. If
a premium rate is not defined for an
overtime plan, the premium rate defined
for the pay code defaults.
PRO-PAY-CODE Alpha 4 PR21.1
Element: Payment Code Contains the overtime pay code. If the
pay plan is an overtime plan, PR132
(FLSA Overtime Calculation)
automatically calculates the overtime
and creates a time record for the
overtime pay code.
PRO-WORK-PRD-FLAG Alpha 1 PR21.1
Element: Work Prd Flag Contains the value that indicates if
overtime pay is based on a fixed or
fluctuating work period.
F = Fixed
L = Fluctuating
PRO-FIXED-HOURS Numeric 3 PR21.1
Element: Fixed Hours Contains the number of hours a salaried
employee's pay is intended to compensate
for the work period. The system uses
this field for fixed work week plans.
PRO-CALC-OT-HOURS Alpha 1 PR21.1
Element: Calc Ot Hours Contains the option that indicates
whether or not the system calculates
overtime hours.
N = No
Y = Yes
PRO-PAY-PER-OVR Alpha 1 PR21.1
Element: Pay Per Ovr Indicates whether or not the pay periods
are overridden to be 27 or 53 instead of
26 or 52.
N = No
Y = Yes
PRO-DFLT-PAY-DATE Numeric 8 (yyyymmdd) PR21.1
Element: Dflt Pay Date
PROVERTIME FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PROSET1 COMPANY BN150 PR21.1
PLAN-CODE PR21.2 PR21.3
EFFECT-DATE PR221 PA532
HS03.1 HS535
PR128 PR130
PR131 PR132
PR134 PR136
PR137 PR160
PR180 PR20.4
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
...
PROSET2 COMPANY BN100 BN101
PLAN-CODE BN102 BN103
EFFECT-DATE* BN105 BN145
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN71.1 BN72.1
BS12.1 BS13.1
BS14.1 BS15.1
BS32.1 HPRO.1
HR11.1 HR11.2
HR211 HR511
PA02.1 PA100
PA102 PA103
...
PROVERTIME FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PRO-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Pay Code PRPAYCODE Required
PRO-COMPANY -> PCD-COMPANY
PRO-PAY-CODE -> PCD-PAY-CODE
Spaces -> PCD-PROCESS-LEVEL
Spaces -> PCD-JOB-CODE
PROVERTIME FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Employees PATHFIND Delete Restricted
PRO-COMPANY -> PTF-COMPANY
106 -> PTF-FLD-NBR
PRO-PLAN-CODE -> PTF-FLD-VALUE
PTF-EMPLOYEE
PTF-POS-LEVEL
Pay Prd Sched PROTPAYPRD Delete Cascades
PRO-COMPANY -> PRY-COMPANY
PRO-PLAN-CODE -> PRY-PLAN-CODE
PRO-EFFECT-DATE -> PRY-EFFECT-DATE
PRY-PAY-START-DATE
Wrk Prd Sched PROTWRKPRD Delete Cascades
PRO-COMPANY -> PRW-COMPANY
PRO-PLAN-CODE -> PRW-PLAN-CODE
PRO-EFFECT-DATE -> PRW-EFFECT-DATE
PRW-WRK-START-DATE
|
