TAFORMULAS

REFERENCED BY
LP08.1 LP140 LP145 LP198 LP04.2 LP04.3
LP04.4 LP04.5 LP04.6 LP04.7 LP04.8 LP04.9
LP201 LP203 LP206


UPDATED BY
HR00.1 HR01.1 LP06.2 LP06.3 LP06.4 LP06.5

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TFO-COMPANY
Element: Company Hr
Numeric 4
LP06.2 LP06.3
LP06.4 LP06.5
TFO-FORMULA
Element: Ta Formula
Alpha 10
LP06.2 LP06.3
LP06.4 LP06.5
TFO-DESCRIPTION
Element: Ta Description
Alpha 30 (Lower Case)
LP06.2 LP06.3
LP06.4 LP06.5
TFO-FORMULA-TYPE
Element: Ta Type
Numeric 2
Contains the units of measure for the summarized totals.
01 = Cycle Amount
02 = Hours Amount
03 = Ratio
04 = Date
LP06.2 LP06.3
LP06.4 LP06.5
TFO-HOURS-SRV-CLS
Element: Ta Service Cls
Alpha 3
LP06.2
TFO-HOURS-SRV-TYPE
Element: Ta Type
Numeric 2
Contains the units of measure for the summarized totals.
01 = Life to date (LTD)
02 = Year to date (YTD)
03 = Prior year total (PYT)
LP06.3
TFO-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.
LP06.2 LP06.3
LP06.4 LP06.5
TFO-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
LP06.2 LP06.3
LP06.4 LP06.5
TFO-USER-ID
Element: User
Alpha 10 (Lower Case)
LP06.2 LP06.3
LP06.4 LP06.5


TAFORMULAS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TFOSET1 COMPANY
FORMULA
HR00.1 HR01.1
LP04.2 LP04.3
LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
LP06.2 LP06.3
LP06.4 LP06.5
LP08.1 LP140
LP145 LP198
LP201 LP203
LP206
TFOSET2 COMPANY
FORMULA-TYPE
FORMULA
Subset
Where(FORMULA-TYPE =1)
LP06.2 LP206
TFOSET3 COMPANY
FORMULA-TYPE
FORMULA
Subset
Where(FORMULA-TYPE =2)
LP06.3 LP206
TFOSET4 COMPANY
FORMULA-TYPE
FORMULA
Subset
Where(FORMULA-TYPE =3)
LP06.4 LP206
TFOSET5 COMPANY
FORMULA-TYPE
FORMULA
Subset
Where(FORMULA-TYPE =4)
LP06.5 LP206


TAFORMULAS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TFO-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Hours Srv Cls TASERVCLSS Required
When (TFO-HOURS-SRV-CLS !=Spaces )
TFO-COMPANY->TSL-COMPANY
TFO-HOURS-SRV-CLS->TSL-SERVICE-CLASS


TAFORMULAS FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Formulax TAFORMULAX Delete Cascades
TFO-COMPANY->TFX-COMPANY
TFO-FORMULA->TFX-FORMULA
  TFX-FROM-HOURS
  TFX-RATIO-SRV-CLS
  TFX-FORMULA-DATE


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

Home
Contact Us



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