TAFORMULA

Time Accrual Formula

Contains the formula used to calculate accrued hours. A formula can be assigned to one or more plans.

REFERENCED BY
TA20.2 TA230


UPDATED BY
TA30.1 TA30.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TAF-COMPANY
Element: Company Hr
Numeric 4
Contains the number that represents an established company.
TA30.1 TA30.2
TAF-CALC-NAME
Element: Calc Name
Alpha 10
Contains the formula calculation name. This field is user-defined.
TA30.1 TA30.2
TAF-FRMLA-TYPE
Element: Frmla Type
Alpha 1
Contains the value that identifies the formula type.
A = Flat amount
R = Ratio per hour
TA30.1 TA30.2
TAF-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
Contains the formula description.
TA30.1 TA30.2
TAF-A-PAY-CLASS
Element: A Pay Class
Alpha 3
Contains the pay class that represents the hours used in Flat amount formula types. Validated in the Payclass file.
TA30.1
TAF-A-FRM-HRS
Element: A Frm Hrs
Numeric 5 Occurs 24 Times
Contains the From hours.
TA30.1
TAF-A-TO-HRS
Element: A To Hrs
Numeric 5 Occurs 24 Times
Contains the To hours.
TA30.1
TAF-A-FLAT-HRS
Element: A Flat Hrs
Signed 9.4 Occurs 24 Times
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.
TA30.1
TAF-A-NUMER-PC
Element: A Numer Pc
Alpha 3 Occurs 24 Times
Contains the pay class that represents the hours used for the calculation method of accrual.
TA30.1
TAF-A-UA-HRS
Element: A Ua Hrs
Numeric 5 Occurs 24 Times
Contains the hours associated with the plan's accrual cycle in TA20.2 (Accrual Schedule).
TA30.1
TAF-A-UA-FACTOR
Element: A Ua Factor
Signed 9.4 Occurs 24 Times
Contains the calculation factor. This rate is used to calculate the accrual amount.
TA30.1
TAF-A-UA-HR-DESC
Element: A Ua Hr Desc
Alpha 30 Occurs 24 Times
Contains the description of the hours used in the calculation method of accrual.
TA30.1
TAF-A-UA-FCT-DESC
Element: A Ua Fct Desc
Alpha 30 Occurs 24 Times
Contains the description of the factor used in the calculation method of accrual.
TA30.1
TAF-R-RATIO
Element: R Ratio
Signed 11.4 Occurs 10 Times
Contains the ratio by which hours worked in the pay class are multiplied to arrive at the accrued hours using the Accrual Ratio Formula.
TA30.2
TAF-R-PAY-CLASS
Element: R Pay Class
Alpha 3 Occurs 10 Times
Contains the pay class that represents the hours multiplied by the ratio to arrive at the accrued hours using the Accrual Ratio Formula.
TA30.2
TAF-A-FRM-HRS-1
Element: A Frm Hrs 1
Derived
TAF-A-FRM-HRS-2
Element: A Frm Hrs 2
Derived
TAF-A-FRM-HRS-3
Element: A Frm Hrs 3
Derived
TAF-A-FRM-HRS-4
Element: A Frm Hrs 4
Derived
TAF-A-FRM-HRS-5
Element: A Frm Hrs 5
Derived
TAF-A-FRM-HRS-6
Element: A Frm Hrs 6
Derived
TAF-A-FRM-HRS-7
Element: A Frm Hrs 7
Derived
TAF-A-FRM-HRS-8
Element: A Frm Hrs 8
Derived
TAF-A-FRM-HRS-9
Element: A Frm Hrs 9
Derived
TAF-A-FRM-HRS-10
Element: A Frm Hrs 10
Derived
TAF-A-FRM-HRS-11
Element: A Frm Hrs 11
Derived
TAF-A-FRM-HRS-12
Element: A Frm Hrs 12
Derived
TAF-A-FRM-HRS-13
Element: A Frm Hrs 13
Derived
TAF-A-FRM-HRS-14
Element: A Frm Hrs 14
Derived
TAF-A-FRM-HRS-15
Element: A Frm Hrs 15
Derived
TAF-A-FRM-HRS-16
Element: A Frm Hrs 16
Derived
TAF-A-FRM-HRS-17
Element: A Frm Hrs 17
Derived
TAF-A-FRM-HRS-18
Element: A Frm Hrs 18
Derived
TAF-A-FRM-HRS-19
Element: A Frm Hrs 19
Derived
TAF-A-FRM-HRS-20
Element: A Frm Hrs 20
Derived
TAF-A-FRM-HRS-21
Element: A Frm Hrs 21
Derived
TAF-A-FRM-HRS-22
Element: A Frm Hrs 22
Derived
TAF-A-FRM-HRS-23
Element: A Frm Hrs 23
Derived
TAF-A-FRM-HRS-24
Element: A Frm Hrs 24
Derived
TAF-A-TO-HRS-1
Element: A To Hrs 1
Derived
TAF-A-TO-HRS-2
Element: A To Hrs 2
Derived
TAF-A-TO-HRS-3
Element: A To Hrs 3
Derived
TAF-A-TO-HRS-4
Element: A To Hrs 4
Derived
TAF-A-TO-HRS-5
Element: A To Hrs 5
Derived
TAF-A-TO-HRS-6
Element: A To Hrs 6
Derived
TAF-A-TO-HRS-7
Element: A To Hrs 7
Derived
TAF-A-TO-HRS-8
Element: A To Hrs 8
Derived
TAF-A-TO-HRS-9
Element: A To Hrs 9
Derived
TAF-A-TO-HRS-10
Element: A To Hrs 10
Derived
TAF-A-TO-HRS-11
Element: A To Hrs 11
Derived
TAF-A-TO-HRS-12
Element: A To Hrs 12
Derived
TAF-A-TO-HRS-13
Element: A To Hrs 13
Derived
TAF-A-TO-HRS-14
Element: A To Hrs 14
Derived
TAF-A-TO-HRS-15
Element: A To Hrs 15
Derived
TAF-A-TO-HRS-16
Element: A To Hrs 16
Derived
TAF-A-TO-HRS-17
Element: A To Hrs 17
Derived
TAF-A-TO-HRS-18
Element: A To Hrs 18
Derived
TAF-A-TO-HRS-19
Element: A To Hrs 19
Derived
TAF-A-TO-HRS-20
Element: A To Hrs 20
Derived
TAF-A-TO-HRS-21
Element: A To Hrs 21
Derived
TAF-A-TO-HRS-22
Element: A To Hrs 22
Derived
TAF-A-TO-HRS-23
Element: A To Hrs 23
Derived
TAF-A-TO-HRS-24
Element: A To Hrs 24
Derived
TAF-A-FLAT-HRS-1
Element: A Flat Hrs 1
Derived
TAF-A-FLAT-HRS-2
Element: A Flat Hrs 2
Derived
TAF-A-FLAT-HRS-3
Element: A Flat Hrs 3
Derived
TAF-A-FLAT-HRS-4
Element: A Flat Hrs 4
Derived
TAF-A-FLAT-HRS-5
Element: A Flat Hrs 5
Derived
TAF-A-FLAT-HRS-6
Element: A Flat Hrs 6
Derived
TAF-A-FLAT-HRS-7
Element: A Flat Hrs 7
Derived
TAF-A-FLAT-HRS-8
Element: A Flat Hrs 8
Derived
TAF-A-FLAT-HRS-9
Element: A Flat Hrs 9
Derived
TAF-A-FLAT-HRS-10
Element: A Flat Hrs 10
Derived
TAF-A-FLAT-HRS-11
Element: A Flat Hrs 11
Derived
TAF-A-FLAT-HRS-12
Element: A Flat Hrs 12
Derived
TAF-A-FLAT-HRS-13
Element: A Flat Hrs 13
Derived
TAF-A-FLAT-HRS-14
Element: A Flat Hrs 14
Derived
TAF-A-FLAT-HRS-15
Element: A Flat Hrs 15
Derived
TAF-A-FLAT-HRS-16
Element: A Flat Hrs 16
Derived
TAF-A-FLAT-HRS-17
Element: A Flat Hrs 17
Derived
TAF-A-FLAT-HRS-18
Element: A Flat Hrs 18
Derived
TAF-A-FLAT-HRS-19
Element: A Flat Hrs 19
Derived
TAF-A-FLAT-HRS-20
Element: A Flat Hrs 20
Derived
TAF-A-FLAT-HRS-21
Element: A Flat Hrs 21
Derived
TAF-A-FLAT-HRS-22
Element: A Flat Hrs 22
Derived
TAF-A-FLAT-HRS-23
Element: A Flat Hrs 23
Derived
TAF-A-FLAT-HRS-24
Element: A Flat Hrs 24
Derived


TAFORMULA FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TAFSET1 COMPANY
CALC-NAME
TA20.2 TA230
TA30.1 TA30.2
TAFSET2 COMPANY
FRMLA-TYPE
CALC-NAME
TA230 TA30.1
TA30.2


TAFORMULA FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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"
AndTAF-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"
AndTAF-R-PAY-CLASS !=Spaces
TAF-COMPANY->PCL-COMPANY
TAF-R-PAY-CLASS->PCL-PAY-CLASS


TAFORMULA FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Taeemaster TAEEMASTER
TAF-COMPANY->TEM-COMPANY
  TEM-EMPLOYEE
  TEM-PLAN
  TEM-EMPLOYEE-GROUP
  TEM-POSITION


File created: Thu Jun 09 02:32:53 2016

Home
Contact Us



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