TACALC

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


UPDATED BY
HR00.1 HR01.1 LP07.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TCA-COMPANY
Element: Company Hr		Numeric 4
LP07.1
TCA-CALCULATION
Element: Ta Calculation		Alpha 10
LP07.1
TCA-DESCRIPTION
Element: Ta Description		Alpha 30 (Lower Case)
LP07.1
TCA-CUSTOM-CALC
Element: Ta Custom Calc		Numeric 2

00 = No
01 = Yes
LP07.1
TCA-AMOUNT
Element: Ta Amount		Signed 18.6
LP07.1
TCA-MULT-FACTOR
Element: Ta Factor		Numeric 3

001 = Standard hours per pay period
002 = FTE for position
003 = Total FTE
004 = FTE X Annual Hrs for position
005 = Total FTE X Annual Hours
LP07.1
TCA-MULT-SRV-CLS
Element: Ta Service Cls		Alpha 3
LP07.1
TCA-MULT-AMOUNT
Element: Ta Amount		Signed 18.6
LP07.1
TCA-MULT-USER-NBR
Element: Ta User Key		Alpha 2
LP07.1
TCA-DIV-FACTOR
Element: Ta Factor		Numeric 3

001 = Standard hours per pay period
002 = FTE for position
003 = Total FTE
004 = FTE X Annual Hrs for position
005 = Total FTE X Annual Hours
LP07.1
TCA-DIV-SRV-CLS
Element: Ta Service Cls		Alpha 3
LP07.1
TCA-DIV-AMOUNT
Element: Ta Amount		Signed 18.6
LP07.1
TCA-DIV-USER-NBR
Element: Ta User Key		Alpha 2
LP07.1
TCA-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.
LP07.1
TCA-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
LP07.1
TCA-USER-ID
Element: User		Alpha 10 (Lower Case)
LP07.1
TCA-MULT-USER-NAME
Element: Mult User Name		Derived
TCA-DIV-USER-NAME
Element: Div User Name		Derived
TCA-M-SRV-CLS-NM
Element: M Srv Cls Nm		Derived
TCA-D-SRV-CLS-NM
Element: D Srv Cls Nm		Derived
TCA-USER-ALPHA-1
Element: Ta User Alpha		Alpha 20 (Lower Case)
LP07.1
TCA-USER-ALPHA-2
Element: Ta User Alpha		Alpha 20 (Lower Case)
LP07.1
TCA-USER-ALPHA-3
Element: Ta User Alpha		Alpha 20 (Lower Case)
LP07.1
TCA-USER-ALPHA-4
Element: Ta User Alpha		Alpha 20 (Lower Case)
LP07.1
TCA-USER-ALPHA-5
Element: Ta User Alpha		Alpha 20 (Lower Case)
LP07.1
TCA-USER-NUM-1
Element: Ta Amount		Signed 18.6
LP07.1
TCA-USER-NUM-2
Element: Ta Amount		Signed 18.6
LP07.1
TCA-USER-NUM-3
Element: Ta Amount		Signed 18.6
LP07.1
TCA-USER-NUM-4
Element: Ta Amount		Signed 18.6
LP07.1
TCA-USER-NUM-5
Element: Ta Amount		Signed 18.6
LP07.1


TACALC FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TCASET1 COMPANY
CALCULATION
HR00.1 HR01.1
HR04.4 HR04.5
HR04.6 LP04.2
LP04.3 LP04.4
LP04.5 LP04.6
LP04.7 LP04.8
LP04.9 LP06.2
LP06.3 LP06.4
LP06.5 LP07.1
LP08.1 LP140
LP145 LP198
LP201 LP203
LP206 LP207


TACALC FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TCA-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Div Srv Cls TASERVCLSS Required
When (TCA-DIV-SRV-CLS !=Spaces )
TCA-COMPANY->TSL-COMPANY
TCA-DIV-SRV-CLS->TSL-SERVICE-CLASS
Div User Nbr HRUSERFLDS Required
When (TCA-DIV-USER-NBR !=Spaces )
TCA-DIV-USER-NBR->HRU-FIELD-KEY
Mult Srv Cls TASERVCLSS Required
When (TCA-MULT-SRV-CLS !=Spaces )
TCA-COMPANY->TSL-COMPANY
TCA-MULT-SRV-CLS->TSL-SERVICE-CLASS
Mult User Nbr HRUSERFLDS Required
When (TCA-MULT-USER-NBR !=Spaces )
TCA-MULT-USER-NBR->HRU-FIELD-KEY


TACALC FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Absence Plan TAPLAN Delete Cascades
TCA-COMPANY->TAP-COMPANY
  TAP-PLAN

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

Home
Contact Us



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