TAFORMULA FILE
Time Accrual Formula
Contains the formula used to calculate accrued hours. A formula can be
assigned to one or more plans.
REFERENCED BY
TA170 TA20.2 TA230
UPDATED BY
TA30.1 TA30.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TAF-COMPANY Numeric 4 TA30.1 TA30.2
Company Contains the number that represents an
established company.
TAF-CALC-NAME Alpha 10 TA30.1 TA30.2
Calculation Name Contains the formula calculation name.
This field is user-defined.
TAF-FRMLA-TYPE Alpha 1 TA30.1 TA30.2
Formula Type Contains the value that identifies the
formula type.
A = Flat amount
R = Ratio per hour
TAF-DESCRIPTION Alpha 30 (Lower Case) TA30.1 TA30.2
Description Contains the formula description.
TAF-A-PAY-CLASS Alpha 3 TA30.1
A Pay Class Contains the pay class that represents
the hours used in Flat amount formula
types. Validated in the Payclass file.
TAF-A-FRM-HRS Numeric 5 Occurs 24 Times TA30.1
A From Hours Contains the From hours.
TAF-A-TO-HRS Numeric 5 Occurs 24 Times TA30.1
A to Hours Contains the To hours.
TAF-A-FLAT-HRS Signed 9.4 Occurs 24 Times TA30.1
A Flat Hours Contains the flat amount of hours that
accrue for hours worked, in the defined
pay class, between the defined From and
To hours for the cycle.
TAF-A-NUMER-PC Alpha 3 Occurs 24 Times TA30.1
A Number Pay Class Contains the pay class that represents
the hours used for the calculation
method of accrual.
TAF-A-UA-HRS Numeric 5 Occurs 24 Times TA30.1
A User Assigned Contains the hours associated with the
Hours plan's accrual cycle in TA20.2 (Accrual
Schedule).
TAF-A-UA-FACTOR Signed 9.4 Occurs 24 Times TA30.1
A User Assigned Contains the calculation factor. This
Factor rate is used to calculate the accrual
amount.
TAF-A-UA-HR-DESC Alpha 30 Occurs 24 Times TA30.1
A User Assigned Contains the description of the hours
Hour Desc used in the calculation method of
accrual.
TAF-A-UA-FCT-DESC Alpha 30 Occurs 24 Times TA30.1
A User Assigned Contains the description of the factor
Factor Desc used in the calculation method of
accrual.
TAF-R-RATIO Signed 11.4 Occurs 10 Times TA30.2
R Ratio Contains the ratio by which hours
worked in the pay class are multiplied
to arrive at the accrued hours using the
Accrual Ratio Formula.
TAF-R-PAY-CLASS Alpha 3 Occurs 10 Times TA30.2
R Pay Class Contains the pay class that represents
the hours multiplied by the ratio to
arrive at the accrued hours using the
Accrual Ratio Formula.
TAF-A-FRM-HRS-1 Derived
A Frm Hrs 1
TAF-A-FRM-HRS-2 Derived
A Frm Hrs 2
TAF-A-FRM-HRS-3 Derived
A Frm Hrs 3
TAF-A-FRM-HRS-4 Derived
A Frm Hrs 4
TAF-A-FRM-HRS-5 Derived
A Frm Hrs 5
TAF-A-FRM-HRS-6 Derived
A Frm Hrs 6
TAF-A-FRM-HRS-7 Derived
A Frm Hrs 7
TAF-A-FRM-HRS-8 Derived
A Frm Hrs 8
TAF-A-FRM-HRS-9 Derived
A Frm Hrs 9
TAF-A-FRM-HRS-10 Derived
A Frm Hrs 10
TAF-A-FRM-HRS-11 Derived
A Frm Hrs 11
TAF-A-FRM-HRS-12 Derived
A Frm Hrs 12
TAF-A-FRM-HRS-13 Derived
A Frm Hrs 13
TAF-A-FRM-HRS-14 Derived
A Frm Hrs 14
TAF-A-FRM-HRS-15 Derived
A Frm Hrs 15
TAF-A-FRM-HRS-16 Derived
A Frm Hrs 16
TAF-A-FRM-HRS-17 Derived
A Frm Hrs 17
TAF-A-FRM-HRS-18 Derived
A Frm Hrs 18
TAF-A-FRM-HRS-19 Derived
A Frm Hrs 19
TAF-A-FRM-HRS-20 Derived
A Frm Hrs 20
TAF-A-FRM-HRS-21 Derived
A Frm Hrs 21
TAF-A-FRM-HRS-22 Derived
A Frm Hrs 22
TAF-A-FRM-HRS-23 Derived
A Frm Hrs 23
TAF-A-FRM-HRS-24 Derived
A Frm Hrs 24
TAF-A-TO-HRS-1 Derived
A To Hrs 1
TAF-A-TO-HRS-2 Derived
A To Hrs 2
TAF-A-TO-HRS-3 Derived
A To Hrs 3
TAF-A-TO-HRS-4 Derived
A To Hrs 4
TAF-A-TO-HRS-5 Derived
A To Hrs 5
TAF-A-TO-HRS-6 Derived
A To Hrs 6
TAF-A-TO-HRS-7 Derived
A To Hrs 7
TAF-A-TO-HRS-8 Derived
A To Hrs 8
TAF-A-TO-HRS-9 Derived
A To Hrs 9
TAF-A-TO-HRS-10 Derived
A To Hrs 10
TAF-A-TO-HRS-11 Derived
A To Hrs 11
TAF-A-TO-HRS-12 Derived
A To Hrs 12
TAF-A-TO-HRS-13 Derived
A To Hrs 13
TAF-A-TO-HRS-14 Derived
A To Hrs 14
TAF-A-TO-HRS-15 Derived
A To Hrs 15
TAF-A-TO-HRS-16 Derived
A To Hrs 16
TAF-A-TO-HRS-17 Derived
A To Hrs 17
TAF-A-TO-HRS-18 Derived
A To Hrs 18
TAF-A-TO-HRS-19 Derived
A To Hrs 19
TAF-A-TO-HRS-20 Derived
A To Hrs 20
TAF-A-TO-HRS-21 Derived
A To Hrs 21
TAF-A-TO-HRS-22 Derived
A To Hrs 22
TAF-A-TO-HRS-23 Derived
A To Hrs 23
TAF-A-TO-HRS-24 Derived
A To Hrs 24
TAF-A-FLAT-HRS-1 Derived
A Flat Hrs 1
TAF-A-FLAT-HRS-2 Derived
A Flat Hrs 2
TAF-A-FLAT-HRS-3 Derived
A Flat Hrs 3
TAF-A-FLAT-HRS-4 Derived
A Flat Hrs 4
TAF-A-FLAT-HRS-5 Derived
A Flat Hrs 5
TAF-A-FLAT-HRS-6 Derived
A Flat Hrs 6
TAF-A-FLAT-HRS-7 Derived
A Flat Hrs 7
TAF-A-FLAT-HRS-8 Derived
A Flat Hrs 8
TAF-A-FLAT-HRS-9 Derived
A Flat Hrs 9
TAF-A-FLAT-HRS-10 Derived
A Flat Hrs 10
TAF-A-FLAT-HRS-11 Derived
A Flat Hrs 11
TAF-A-FLAT-HRS-12 Derived
A Flat Hrs 12
TAF-A-FLAT-HRS-13 Derived
A Flat Hrs 13
TAF-A-FLAT-HRS-14 Derived
A Flat Hrs 14
TAF-A-FLAT-HRS-15 Derived
A Flat Hrs 15
TAF-A-FLAT-HRS-16 Derived
A Flat Hrs 16
TAF-A-FLAT-HRS-17 Derived
A Flat Hrs 17
TAF-A-FLAT-HRS-18 Derived
A Flat Hrs 18
TAF-A-FLAT-HRS-19 Derived
A Flat Hrs 19
TAF-A-FLAT-HRS-20 Derived
A Flat Hrs 20
TAF-A-FLAT-HRS-21 Derived
A Flat Hrs 21
TAF-A-FLAT-HRS-22 Derived
A Flat Hrs 22
TAF-A-FLAT-HRS-23 Derived
A Flat Hrs 23
TAF-A-FLAT-HRS-24 Derived
A Flat Hrs 24
TAFORMULA FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TAFSET1 COMPANY TA170 TA20.2
CALC-NAME TA230 TA30.1
TA30.2
TAFSET2 COMPANY TA230 TA30.1
FRMLA-TYPE TA30.2
CALC-NAME
TAFORMULA FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amt Pay Class PAYCLASS Required
When TAF-FRMLA-TYPE = "A"
TAF-COMPANY -> PCL-COMPANY
TAF-A-PAY-CLASS -> PCL-PAY-CLASS
Company PRSYSTEM Required
TAF-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Numer Pay Cl PAYCLASS Required
When TAF-FRMLA-TYPE = "A"
And TAF-A-NUMER-PC != Spaces
TAF-COMPANY -> PCL-COMPANY
TAF-A-NUMER-PC -> PCL-PAY-CLASS
Ratio Pay Cl PAYCLASS Required
When TAF-FRMLA-TYPE = "R"
And TAF-R-PAY-CLASS != Spaces
TAF-COMPANY -> PCL-COMPANY
TAF-R-PAY-CLASS -> PCL-PAY-CLASS
|
