TAFORMULAS

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


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

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
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: Wed Jun 08 20:50:01 2016

Home
Contact Us



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