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.