|
|
TAACCRUAL FILE
Accrual Rules define the accrual and allotment rules for each employee accrual
record. "Accruals" are calculated over time, whereas "allotments" are
calculated up front, and may or may not be adjusted over time.
REFERENCED BY
HR04.4 HR04.5 HR04.6 HR11.1 HR511 LP02.1
LP04.2 LP04.3 LP04.4 LP04.5 LP04.6 LP04.7
LP04.8 LP04.9 LP08.1 LP100 LP101 LP140
LP145 LP180 LP188 LP197 LP201 LP203
LP31.1 LP570 LP70.1 LP70.2 LP80.1 PA100
PA52.4
UPDATED BY
LP03.2 HR00.1 HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TAR-COMPANY Numeric 4 LP03.2
Element: Company Hr
TAR-ACCRUAL-RULE Alpha 10 LP03.2
Element: Ta Rule
TAR-DESCRIPTION Alpha 30 (Lower Case) LP03.2
Element: Ta Description
TAR-ACCR-DT-CD Numeric 2 LP03.2
Element: Ta Date Code 01 = Hire Date
02 = Adjusted Hire Date
03 = Anniversary Date
04 = Seniority Date
05 = First Day Worked
06 = Birthdate
11 = Benefit Date 1
12 = Benefit Date 2
13 = Benefit Date 3
14 = Benefit Date 4
15 = Benefit Date 5
31 = Plan Entry Date
32 = Service Begin Date
TAR-ACCR-USER-DT Alpha 2 LP03.2
Element: Ta User Key
TAR-ACCR-WAIT-STRT Numeric 2 LP03.2
Element: Ta Date Code 01 = Hire Date
02 = Adjusted Hire Date
03 = Plan Entry Date
04 = Service Begin Date
05 = Accrual Requirement Date
TAR-ACCR-WAIT-PER Numeric 5 LP03.2
Element: Ta Wait Per
TAR-ACCR-WAIT-UNIT Numeric 2 LP03.2
Element: Ta Unit 01 = Hours
02 = Days
03 = Weeks
04 = Semi months
05 = Months
TAR-ACCR-W-SRV-CLS Alpha 3 LP03.2
Element: Ta Service Cls
TAR-ACCR-W-HRS-TYP Numeric 2 LP03.2
Element: Ta Type Contains the units of measure for the
summarized totals.
01 = Plan
02 = Plan; employee group
03 = Plan; emp group; position
04 = All hours
TAR-ACCR-DT-FLAG Numeric 1 LP03.2
Element: Ta Date Flag 1 = Earliest date met
2 = Latest date met
TAR-ACCR-NEAR-PT Numeric 1 LP03.2
Element: Ta Point Code 1 = After requirements are met
2 = Before requirements are met
TAR-ACCR-W-POINT Numeric 4 (mmdd) Occurs 13 Times LP03.2
Element: Ta Point
TAR-PAY-CYCLE-ADJ Numeric 1 LP03.2
Element: Ta Cycle Adj 0 = No
1 = Yes
TAR-ACCR-BEGIN-OPT Numeric 1 LP03.2
Element: Ta Option 1 = Accrual Start Date
2 = Accrual Requirement Date
TAR-ACCR-PARTIAL Numeric 1
Element: Ta Partial 01 = No
12 = Yes
TAR-ACCR-HRS-TBL Alpha 10 LP03.2
Element: Ta Table
TAR-ACCR-ERN-TBL Alpha 10 LP03.2
Element: Ta Table
TAR-ALLOT-DT-CD Numeric 2 LP03.2
Element: Ta Date Code 01 = Hire Date
02 = Adjusted Hire Date
03 = Anniversary Date
04 = Seniority Date
05 = First Day Worked
06 = Birthdate
11 = Benefit Date 1
12 = Benefit Date 2
13 = Benefit Date 3
14 = Benefit Date 4
15 = Benefit Date 5
31 = Plan Entry Date
32 = Service Begin Date
33 = Accrual From Date
34 = Accrual Start Date
TAR-ALLOT-USER-DT Alpha 2 LP03.2
Element: Ta User Key
TAR-ALLOT-DATE Numeric 8 (yyyymmdd) LP03.2
Element: Ta Date
TAR-ALLT-WAIT-STRT Numeric 2 LP03.2
Element: Ta Date Code 01 = Hire Date
02 = Adjusted Hire Date
03 = Plan Entry Date
04 = Service Begin Date
05 = Accrual From Date
06 = Accrual Start Date
07 = Allotment Requirement Date
TAR-ALLOT-WAIT-PER Numeric 5 LP03.2
Element: Ta Wait Per
TAR-ALLT-WAIT-UNIT Numeric 2 LP03.2
Element: Ta Unit 01 = Hours
02 = Days
03 = Weeks
04 = Semi months
05 = Months
TAR-ALLT-W-SRV-CLS Alpha 3 LP03.2
Element: Ta Service Cls
TAR-ALLT-W-HRS-TYP Numeric 2 LP03.2
Element: Ta Type Contains the units of measure for the
summarized totals.
01 = Plan
02 = Plan; employee group
03 = Plan; emp group; position
04 = All hours
TAR-ALLOT-DT-FLAG Numeric 1 LP03.2
Element: Ta Date Flag 1 = Earliest date met
2 = Latest date met
TAR-ALLOT-NEAR-PT Numeric 1 LP03.2
Element: Ta Point Code 1 = After requirements are met
2 = Before requirements are met
TAR-ALLOT-W-POINT Numeric 4 (mmdd) Occurs 13 Times LP03.2
Element: Ta Point
TAR-ALLOT-POINT Numeric 4 (mmdd) LP03.2
Element: Ta Point
TAR-ALLOT-PERIOD Numeric 4 LP03.2
Element: Ta Period
TAR-ALLOT-UNIT Numeric 2 LP03.2
Element: Ta Unit 01 = Weeks
02 = Two weeks
03 = Semi months
04 = Four weeks
05 = Months
06 = Two months
07 = Quarters
08 = Four months
09 = Semi years
10 = Years
TAR-ALLOT-OCCUR Numeric 2 LP03.2
Element: Ta Occur 01 = Annual
02 = One time
TAR-ALLOT-PARTIAL Numeric 1
Element: Ta Partial 01 = No
12 = Yes
TAR-ALLOT-PRORATE Numeric 1
Element: Ta Prorate 01 = No(do not prorate for service)
12 = Yes (prorate for service)
TAR-ALLOT-ADJUST Numeric 1 LP03.2
Element: Ta Adjust 01 = No (do not adjust for change)
12 = Yes (adjust for change)
TAR-ALLOT-ACCR-REL Numeric 1 LP03.2
Element: Ta Relation 11 = Independent of accrual tables
22 = First allotment ends accruals
33 = Adjust allotment by accruals
TAR-ALLOT-ELIG-REL Numeric 1 LP03.2
Element: Ta Relation 1 = Independent of eligibility
2 = Apply Eligibility Begin Date
TAR-ALLOT-HRS-TBL Alpha 10 LP03.2
Element: Ta Table
TAR-ALLOT-ERN-TBL Alpha 10 LP03.2
Element: Ta Table
TAR-DATE-STAMP Numeric 8 (yyyymmdd) LP03.2
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
TAR-TIME-STAMP Numeric 6 (hhmmss) LP03.2
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
TAR-USER-ID Alpha 10 (Lower Case) LP03.2
Element: User
TAACCRUAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TARSET1 COMPANY HR00.1 HR01.1
ACCRUAL-RULE HR04.4 HR04.5
HR04.6 HR11.1
HR511 LP02.1
LP03.2 LP04.2
LP04.3 LP04.4
LP04.5 LP04.6
LP04.7 LP04.8
LP04.9 LP08.1
LP100 LP101
LP140 LP145
LP180 LP188
LP197 LP201
LP203 LP31.1
LP570 LP70.1
...
TAACCRUAL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accr User Dt HRUSERFLDS Required
When (TAR-ACCR-USER-DT != Spaces )
TAR-ACCR-USER-DT -> HRU-FIELD-KEY
Accr W Srv Cls TASERVCLSS Required
When TAR-ACCR-W-SRV-CLS != Spaces
TAR-COMPANY -> TSL-COMPANY
TAR-ACCR-W-SRV-CLS -> TSL-SERVICE-CLASS
Allot User Dt HRUSERFLDS Required
When (TAR-ALLOT-USER-DT != Spaces )
TAR-ALLOT-USER-DT -> HRU-FIELD-KEY
Allt W Srv Cls TASERVCLSS Required
When TAR-ALLT-W-SRV-CLS != Spaces
TAR-COMPANY -> TSL-COMPANY
TAR-ALLT-W-SRV-CLS -> TSL-SERVICE-CLASS
Company PRSYSTEM Required
TAR-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
TAACCRUAL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accr Ern Tbl TATABLE
Valid When (TAR-ACCR-ERN-TBL != Spaces )
TAR-COMPANY -> TBL-COMPANY
TAR-ACCR-ERN-TBL -> TBL-TABLE
TBL-EFFECTIVE-DATE
Accr Hrs Tbl TATABLE
Valid When (TAR-ACCR-HRS-TBL != Spaces )
TAR-COMPANY -> TBL-COMPANY
TAR-ACCR-HRS-TBL -> TBL-TABLE
TBL-EFFECTIVE-DATE
Allot Ern Tbl TATABLE
Valid When (TAR-ALLOT-ERN-TBL != Spaces )
TAR-COMPANY -> TBL-COMPANY
TAR-ALLOT-ERN-TBL -> TBL-TABLE
TBL-EFFECTIVE-DATE
Allot Hrs Tbl TATABLE
Valid When (TAR-ALLOT-HRS-TBL != Spaces )
TAR-COMPANY -> TBL-COMPANY
TAR-ALLOT-HRS-TBL -> TBL-TABLE
TBL-EFFECTIVE-DATE
|
