|
|
TALIMIT FILE
Limit Rules define maximums for ongoing balance, annual accrual and carryover
amounts. Limit Rules also define when accrual totals are reset, and if the
carryover amount is available for a limited period of time (carryover period).
A plan structure must have an annual reset point or date to determine when
totals are reset, but maximums are optional. The ongoing balance limit has an
additional option to check maximums by plan category (balance limit type).
REFERENCED BY
HR11.1 HR511 LP02.1 LP04.2 LP04.3 LP04.4
LP04.5 LP04.6 LP04.7 LP04.8 LP04.9 LP100
LP101 LP140 LP145 LP180 LP188 LP197
LP201 LP203 LP31.1 LP80.1 PA100 PA52.4
UPDATED BY
LP03.4 HR00.1 HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TLM-COMPANY Numeric 4 LP03.4
Element: Company Hr
TLM-LIMIT-RULE Alpha 10 LP03.4
Element: Ta Rule
TLM-DESCRIPTION Alpha 30 (Lower Case) LP03.4
Element: Ta Description
TLM-RESET-DT-CD Numeric 2 LP03.4
Element: Ta Date Code 01 = Hire Date
02 = Adjusted Hire Date
03 = Plan Entry Date
04 = Service Begin Date
05 = Accrual From Date
06 = Allotment Start Date
07 = Allotment Begin Date
08 = Eligibility Begin Date
TLM-RESET-POINT Numeric 4 (mmdd) LP03.4
Element: Ta Point
TLM-BAL-HRS-TBL Alpha 10 LP03.4
Element: Ta Table
TLM-BAL-ERN-TBL Alpha 10 LP03.4
Element: Ta Table
TLM-BAL-LIMIT-TYPE Numeric 2 LP03.4
Element: Ta Type Contains the units of measure for the
summarized totals.
01 = Plan
02 = Plan employee group
03 = Plan; emp grp; position
04 = Plan category
TLM-BAL-BYPASS-FLG Numeric 1 LP03.4
Element: Bypass Flag 0 = No bypass
1 = Bypass hours limit
2 = Bypass earnings limit
3 = Bypass both limits
TLM-ACRLIM-HRS-TBL Alpha 10 LP03.4
Element: Ta Table
TLM-ACRLIM-ERN-TBL Alpha 10 LP03.4
Element: Ta Table
TLM-ACR-LIMIT-TYPE Numeric 2 LP03.4
Element: Ta Type Contains the units of measure for the
summarized totals.
01 = Plan
02 = Plan; employee group
03 = Plan; emp group; position
04 = Plan category
TLM-CARRY-HRS-TBL Alpha 10 LP03.4
Element: Ta Table
TLM-CARRY-ERN-TBL Alpha 10 LP03.4
Element: Ta Table
TLM-CARRY-PERIOD Numeric 4 LP03.4
Element: Ta Period
TLM-CARRYOVER-UNIT Numeric 2 LP03.4
Element: Ta Unit 02 = Days
03 = Weeks
04 = Semi months
05 = Months
TLM-RSV-HRS-TBL Alpha 10
Element: Ta Table
TLM-RSV-ERN-TBL Alpha 10
Element: Ta Table
TLM-PAYOUT-HRS-TBL Alpha 10
Element: Ta Table
TLM-PAYOUT-ERN-TBL Alpha 10
Element: Ta Table
TLM-DON-HRS-TBL Alpha 10
Element: Ta Table
TLM-DON-ERN-TBL Alpha 10
Element: Ta Table
TLM-PURCH-HRS-TBL Alpha 10
Element: Ta Table
TLM-PURCH-ERN-TBL Alpha 10
Element: Ta Table
TLM-GIFT-HRS-TBL Alpha 10
Element: Ta Table
TLM-GIFT-ERN-TBL Alpha 10
Element: Ta Table
TLM-DATE-STAMP Numeric 8 (yyyymmdd) LP03.4
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
TLM-TIME-STAMP Numeric 6 (hhmmss) LP03.4
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
TLM-USER-ID Alpha 10 (Lower Case) LP03.4
Element: User
TALIMIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TLMSET1 COMPANY HR00.1 HR01.1
LIMIT-RULE HR11.1 HR511
LP02.1 LP03.4
LP04.2 LP04.3
LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
LP100 LP101
LP140 LP145
LP180 LP188
LP197 LP201
LP203 LP31.1
LP80.1 PA100
PA52.4
TALIMIT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TLM-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
TALIMIT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acrlim Ern Tbl TATABLE
Valid When TLM-ACRLIM-ERN-TBL != Spaces
TLM-COMPANY -> TBL-COMPANY
TLM-ACRLIM-ERN-TBL -> TBL-TABLE
TBL-EFFECTIVE-DATE
Acrlim Hrs Tbl TATABLE
Valid When TLM-ACRLIM-HRS-TBL != Spaces
TLM-COMPANY -> TBL-COMPANY
TLM-ACRLIM-HRS-TBL -> TBL-TABLE
TBL-EFFECTIVE-DATE
Bal Ern Tbl TATABLE
Valid When TLM-BAL-ERN-TBL != Spaces
TLM-COMPANY -> TBL-COMPANY
TLM-BAL-ERN-TBL -> TBL-TABLE
TBL-EFFECTIVE-DATE
Bal Hrs Tbl TATABLE
Valid When TLM-BAL-HRS-TBL != Spaces
TLM-COMPANY -> TBL-COMPANY
TLM-BAL-HRS-TBL -> TBL-TABLE
TBL-EFFECTIVE-DATE
Carry Ern Tbl TATABLE
Valid When TLM-CARRY-ERN-TBL != Spaces
TLM-COMPANY -> TBL-COMPANY
TLM-CARRY-ERN-TBL -> TBL-TABLE
TBL-EFFECTIVE-DATE
Carry Hrs Tbl TATABLE
Valid When TLM-CARRY-HRS-TBL != Spaces
TLM-COMPANY -> TBL-COMPANY
TLM-CARRY-HRS-TBL -> TBL-TABLE
TBL-EFFECTIVE-DATE
Don Ern Tbl TATABLE
Valid When TLM-DON-ERN-TBL != Spaces
TLM-COMPANY -> TBL-COMPANY
TLM-DON-ERN-TBL -> TBL-TABLE
TBL-EFFECTIVE-DATE
Don Hrs Tbl TATABLE
Valid When TLM-DON-HRS-TBL != Spaces
TLM-COMPANY -> TBL-COMPANY
TLM-DON-HRS-TBL -> TBL-TABLE
TBL-EFFECTIVE-DATE
Gift Ern Tbl TATABLE
Valid When TLM-GIFT-ERN-TBL != Spaces
TLM-COMPANY -> TBL-COMPANY
TLM-GIFT-ERN-TBL -> TBL-TABLE
TBL-EFFECTIVE-DATE
Gift Hrs Tbl TATABLE
Valid When TLM-GIFT-HRS-TBL != Spaces
TLM-COMPANY -> TBL-COMPANY
TLM-GIFT-HRS-TBL -> TBL-TABLE
TBL-EFFECTIVE-DATE
Payout Ern Tbl TATABLE
Valid When TLM-PAYOUT-ERN-TBL != Spaces
TLM-COMPANY -> TBL-COMPANY
TLM-PAYOUT-ERN-TBL -> TBL-TABLE
TBL-EFFECTIVE-DATE
Payout Hrs Tbl TATABLE
Valid When TLM-PAYOUT-HRS-TBL != Spaces
TLM-COMPANY -> TBL-COMPANY
TLM-PAYOUT-HRS-TBL -> TBL-TABLE
TBL-EFFECTIVE-DATE
Purch Ern Tbl TATABLE
Valid When TLM-PURCH-ERN-TBL != Spaces
TLM-COMPANY -> TBL-COMPANY
TLM-PURCH-ERN-TBL -> TBL-TABLE
TBL-EFFECTIVE-DATE
Purch Hrs Tbl TATABLE
Valid When TLM-PURCH-HRS-TBL != Spaces
TLM-COMPANY -> TBL-COMPANY
TLM-PURCH-HRS-TBL -> TBL-TABLE
TBL-EFFECTIVE-DATE
Rsv Ern Tbl TATABLE
Valid When TLM-RSV-ERN-TBL != Spaces
TLM-COMPANY -> TBL-COMPANY
TLM-RSV-ERN-TBL -> TBL-TABLE
TBL-EFFECTIVE-DATE
Rsv Hrs Tbl TATABLE
Valid When TLM-RSV-HRS-TBL != Spaces
TLM-COMPANY -> TBL-COMPANY
TLM-RSV-HRS-TBL -> TBL-TABLE
TBL-EFFECTIVE-DATE
|
