|
|
TACALC FILE
REFERENCED BY
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 LP08.1 LP140 LP145
LP198 LP201 LP203 LP206 LP207
UPDATED BY
LP07.1 HR00.1 HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TCA-COMPANY Numeric 4 LP07.1
Element: Company Hr
TCA-CALCULATION Alpha 10 LP07.1
Element: Ta Calculation
TCA-DESCRIPTION Alpha 30 (Lower Case) LP07.1
Element: Ta Description
TCA-CUSTOM-CALC Numeric 2 LP07.1
Element: Ta Custom Calc00 = No
01 = Yes
TCA-AMOUNT Signed 18.6 LP07.1
Element: Ta Amount
TCA-MULT-FACTOR Numeric 3 LP07.1
Element: Ta Factor 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
TCA-MULT-SRV-CLS Alpha 3 LP07.1
Element: Ta Service Cls
TCA-MULT-AMOUNT Signed 18.6 LP07.1
Element: Ta Amount
TCA-MULT-USER-NBR Alpha 2 LP07.1
Element: Ta User Key
TCA-DIV-FACTOR Numeric 3 LP07.1
Element: Ta Factor 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
TCA-DIV-SRV-CLS Alpha 3 LP07.1
Element: Ta Service Cls
TCA-DIV-AMOUNT Signed 18.6 LP07.1
Element: Ta Amount
TCA-DIV-USER-NBR Alpha 2 LP07.1
Element: Ta User Key
TCA-DATE-STAMP Numeric 8 (yyyymmdd) LP07.1
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
TCA-TIME-STAMP Numeric 6 (hhmmss) LP07.1
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
TCA-USER-ID Alpha 10 (Lower Case) LP07.1
Element: User
TCA-MULT-USER-NAME Derived
Element: Mult User Name
TCA-DIV-USER-NAME Derived
Element: Div User Name
TCA-M-SRV-CLS-NM Derived
Element: M Srv Cls Nm
TCA-D-SRV-CLS-NM Derived
Element: D Srv Cls Nm
TCA-USER-ALPHA-1 Alpha 20 (Lower Case) LP07.1
Element: Ta User Alpha
TCA-USER-ALPHA-2 Alpha 20 (Lower Case) LP07.1
Element: Ta User Alpha
TCA-USER-ALPHA-3 Alpha 20 (Lower Case) LP07.1
Element: Ta User Alpha
TCA-USER-ALPHA-4 Alpha 20 (Lower Case) LP07.1
Element: Ta User Alpha
TCA-USER-ALPHA-5 Alpha 20 (Lower Case) LP07.1
Element: Ta User Alpha
TCA-USER-NUM-1 Signed 18.6 LP07.1
Element: Ta Amount
TCA-USER-NUM-2 Signed 18.6 LP07.1
Element: Ta Amount
TCA-USER-NUM-3 Signed 18.6 LP07.1
Element: Ta Amount
TCA-USER-NUM-4 Signed 18.6 LP07.1
Element: Ta Amount
TCA-USER-NUM-5 Signed 18.6 LP07.1
Element: Ta Amount
TACALC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TCASET1 COMPANY HR00.1 HR01.1
CALCULATION 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 RELATED
NAME 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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Absence Plan TAPLAN Delete Cascades
TCA-COMPANY -> TAP-COMPANY
TAP-PLAN
|
