PRTIMEDATE FILE
The Time Date file contains the valid Web time entry date ranges and lock out
date ranges for the pay period date ranges in a pay plan.
REFERENCED BY
HS535 HS20.1 HS21.1 HS22.1 HS22.3 HS36.1
UPDATED BY
HS03.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PTM-COMPANY Numeric 4 HS03.1
Element: Company Hr
PTM-PLAN-CODE Alpha 4 HS03.1
Element: Plan Code Contains the user-defined code that
represents a pay plan.
PTM-EFFECT-DATE Numeric 8 (yyyymmdd) HS03.1
Element: Effect Date Contains the effective date of the pay
plan.
PTM-PAY-START-DATE Numeric 8 (yyyymmdd) HS03.1
Element: Pay Start DateContains the pay period start date.
PTM-PAY-STOP-DATE Numeric 8 (yyyymmdd) HS03.1
Element: Pay Stop Date Contains the pay period stop date.
PTM-TIME-REC-START Numeric 8 (yyyymmdd) HS03.1
Element: Time Rec StartContains the Web time entry start date.
PTM-TIME-REC-STOP Numeric 8 (yyyymmdd) HS03.1
Element: Time Rec Stop Contains the Web time entry stop date.
PTM-LOCK-OUT-START Numeric 8 (yyyymmdd) HS03.1
Element: Lock Out StartContains the Web lock out start date.
PTM-LOCK-OUT-STOP Numeric 8 (yyyymmdd) HS03.1
Element: Lock Out Stop Contains the Web lock out stop date.
PRTIMEDATE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PTMSET1 COMPANY HS03.1 HS535
PLAN-CODE
EFFECT-DATE
PAY-START-DATE
PTMSET2 COMPANY HS20.1 HS21.1
PLAN-CODE HS22.1 HS22.3
EFFECT-DATE HS36.1
PAY-START-DATE*
PRTIMEDATE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PTM-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Overtime Plan PROVERTIME Required
PTM-COMPANY -> PRO-COMPANY
PTM-PLAN-CODE -> PRO-PLAN-CODE
PTM-EFFECT-DATE -> PRO-EFFECT-DATE
Protpayprd PROTPAYPRD Required
PTM-COMPANY -> PRY-COMPANY
PTM-PLAN-CODE -> PRY-PLAN-CODE
PTM-EFFECT-DATE -> PRY-EFFECT-DATE
PTM-PAY-START-DATE -> PRY-PAY-START-DATE
|
