TALIMIT

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 LT101 LP100 LP101 LP102
LP103 LP131 LP140 LP145 LP180 LP188
LP197 LP31.1 LP80.1 PA100 PA52.4 LP02.1
LP04.2 LP04.3 LP04.4 LP04.5 LP04.6 LP04.7
LP04.8 LP04.9 LP201 LP203


UPDATED BY
HR00.1 HR01.1 LP03.4

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TLM-COMPANY
Element: Company Hr
Numeric 4
LP03.4
TLM-LIMIT-RULE
Element: Ta Rule
Alpha 10
LP03.4
TLM-DESCRIPTION
Element: Ta Description
Alpha 30 (Lower Case)
LP03.4
TLM-RESET-DT-CD
Element: Ta Date Code
Numeric 2

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
LP03.4
TLM-RESET-POINT
Element: Ta Point
Numeric 4 (mmdd)
LP03.4
TLM-BAL-HRS-TBL
Element: Ta Table
Alpha 10
LP03.4
TLM-BAL-ERN-TBL
Element: Ta Table
Alpha 10
LP03.4
TLM-BAL-LIMIT-TYPE
Element: Ta Type
Numeric 2
Contains the units of measure for the summarized totals.
01 = Plan
02 = Plan employee group
03 = Plan; emp grp; position
04 = Plan category
LP03.4
TLM-BAL-BYPASS-FLG
Element: Bypass Flag
Numeric 1

0 = No bypass
1 = Bypass hours limit
2 = Bypass earnings limit
3 = Bypass both limits
LP03.4
TLM-ACRLIM-HRS-TBL
Element: Ta Table
Alpha 10
LP03.4
TLM-ACRLIM-ERN-TBL
Element: Ta Table
Alpha 10
LP03.4
TLM-ACR-LIMIT-TYPE
Element: Ta Type
Numeric 2
Contains the units of measure for the summarized totals.
01 = Plan
02 = Plan; employee group
03 = Plan; emp group; position
04 = Plan category
LP03.4
TLM-CARRY-HRS-TBL
Element: Ta Table
Alpha 10
LP03.4
TLM-CARRY-ERN-TBL
Element: Ta Table
Alpha 10
LP03.4
TLM-CARRY-PERIOD
Element: Ta Period
Numeric 4
LP03.4
TLM-CARRYOVER-UNIT
Element: Ta Unit
Numeric 2

02 = Days
03 = Weeks
04 = Semi months
05 = Months
LP03.4
TLM-RSV-HRS-TBL
Element: Ta Table
Alpha 10
TLM-RSV-ERN-TBL
Element: Ta Table
Alpha 10
TLM-PAYOUT-HRS-TBL
Element: Ta Table
Alpha 10
TLM-PAYOUT-ERN-TBL
Element: Ta Table
Alpha 10
TLM-DON-HRS-TBL
Element: Ta Table
Alpha 10
TLM-DON-ERN-TBL
Element: Ta Table
Alpha 10
TLM-PURCH-HRS-TBL
Element: Ta Table
Alpha 10
TLM-PURCH-ERN-TBL
Element: Ta Table
Alpha 10
TLM-GIFT-HRS-TBL
Element: Ta Table
Alpha 10
TLM-GIFT-ERN-TBL
Element: Ta Table
Alpha 10
TLM-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
LP03.4
TLM-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
LP03.4
TLM-USER-ID
Element: User
Alpha 10 (Lower Case)
LP03.4


TALIMIT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TLMSET1 COMPANY
LIMIT-RULE
...
HR00.1 HR01.1
HR11.1 HR511
LT101 LP02.1
LP03.4 LP04.2
LP04.3 LP04.4
LP04.5 LP04.6
LP04.7 LP04.8
LP04.9 LP100
LP101 LP102
LP103 LP131
LP140 LP145
LP180 LP188
LP197 LP201
LP203 LP31.1
LP80.1 PA100


TALIMIT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TLM-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL


TALIMIT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:19:46 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.