TACALC

Absence Plan Rule Calculations

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 LP140 LP145 LP198
LP201 LP203 LP206 LP207


UPDATED BY
LP07.1 HR00.1 HR01.1 LP08.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 02:22:01 2016

Home
Contact Us



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