TATRANSUM

REFERENCED BY
LP180 LP64.2


UPDATED BY
LP102 LP197 LP331 LP140 LP264 PR160
PR180 PR80.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TTS-COMPANY
Element: Company Hr		Numeric 4
Contains the company number.
LP102 LP197
TTS-EMPLOYEE
Element: Employee		Numeric 9
Contains the employee number.
LP102 LP197
TTS-PLAN
Element: Ta Plan		Alpha 10
LP102 LP197
TTS-EMPLOYEE-GROUP
Element: Group Name		Alpha 10
LP102 LP197
TTS-POSITION
Element: Position		Alpha 12
Contains the position code of the employee if plan balances are held at the position code level.
LP102 LP197
TTS-TA-TYPE
Element: Ta Type		Numeric 2
Contains the units of measure for the summarized totals.
01 = Hours
02 = Earnings
LP102 LP197
TTS-RESET-DATE
Element: Ta Reset Date		Numeric 8 (yyyymmdd)
LP102 LP197
TTS-CURRENCY-CODE
Element: Currency Code		Alpha 5
Contains the currency code for earnings summary transactions (TA-Type = 2). This will be blank for hours summary transactions (TA-Type = 1).
LP102 LP197
TTS-HM-PROC-LEVEL
Element: Process Lev Hr		Alpha 5
LP102 LP197
TTS-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.
LP102 LP197
TTS-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
LP102 LP197
TTS-USER-ID
Element: User		Alpha 10 (Lower Case)
Contains the user ID of the person who last updated this record.
LP102 LP197
TTS-BEG-ACCR-BAL
Element: Beg Accr Bal		Signed 18.6
TTR-BALANCE-TYPE = 1
LP102 LP197
TTS-YTD-ACCRUAL
Element: Ytd Accrual		Signed 18.6
TTR-Tran-Type = 1,21
LP102 LP197
TTS-YTD-ACCR-TRAN
Element: Ytd Accr Tran		Signed 18.6
TTR-Tran-Type = 31
LP102 LP197
TTS-YTD-LSTACCROL
Element: Ytd Lstaccrol		Signed 18.6
TTR-Tran-Type = 42
LP102 LP197
TTS-END-ACCR-BAL
Element: End Accr Bal		Signed 18.6
LP102 LP197
TTS-BEG-ALLOT-BAL
Element: Beg Allot Bal		Signed 18.6
TTR-Balance-Type = 2
LP102 LP197
TTS-YTD-ALLOT
Element: Ytd Allot		Signed 18.6
TTR-Tran-Type = 2,22,51,52
LP102 LP197
TTS-YTD-ALLOT-TRAN
Element: Ytd Allot Tran		Signed 18.6
TTR-Tran-Type = 32
LP102 LP197
TTS-YTD-LSTALLOTOL
Element: Ytd Lstallotol		Signed 18.6
TTR-Tran-Type = 43
LP102 LP197
TTS-END-ALLOT-BAL
Element: End Allot Bal		Signed 18.6
LP102 LP197
TTS-BEG-AVAIL-BAL
Element: Beg Avail Bal		Signed 18.6
TTR-Balance-Type = 3
LP102 LP197
TTS-YTD-ADJ-AVAIL
Element: Ytd Adj Avail		Signed 18.6
TTR-Tran-Type = 3
LP102 LP197
TTS-YTD-AVL-ACCR
Element: Ytd Avl Accr		Signed 18.6
TTR-Tran-Type = 33
LP102 LP197
TTS-YTD-AVL-ALLOT
Element: Ytd Avl Allot		Signed 18.6
TTR-Tran-Type = 34
LP102 LP197
TTS-YTD-PURC-AVL
Element: Ytd Purc Avl		Signed 18.6
TTR-Tran-Type = 12
LP102 LP197
TTS-YTD-SELL-AVL
Element: Ytd Sell Avl		Signed 18.6
TTR-Tran-Type = 11
LP102 LP197
TTS-YTD-LSTAVLCL
Element: Ytd Lstavlcl		Signed 18.6
TTR-Tran-Type = 44
LP102 LP197
TTS-YTD-LSTAVLCP
Element: Ytd Lstavlcp		Signed 18.6
TTR-Tran-Type = 45
LP102 LP197
TTS-YTD-USE-AVAIL
Element: Ytd Use Avail		Signed 18.6
TTR-Tran-Type = 61
LP102 LP197
PR80.2
TTS-END-AVAIL-BAL
Element: End Avail Bal		Signed 18.6
LP102 LP197
TTS-BEG-RESV-BAL
Element: Beg Resv Bal		Signed 18.6
TTR-Balance-Type = 4
LP102 LP197
TTS-YTD-ADJ-RESV
Element: Ytd Adj Resv		Signed 18.6
TTR-Tran-Type = 4
LP102 LP197
TTS-YTD-USE-RESV
Element: Ytd Use Resv		Signed 18.6
TTR-Tran-Type = 61
LP102 LP197
TTS-END-RESV-BAL
Element: End Resv Bal		Signed 18.6
LP102 LP197
TTS-BEG-CARRY-BAL
Element: Beg Carry Bal		Signed 18.6
TTR-Balance-Type = 5
LP102 LP197
TTS-YTD-ADJ-CARRY
Element: Ytd Adj Carry		Signed 18.6
TTR-Tran-Type = 5
LP102 LP197
TTS-YTD-USE-CARRY
Element: Ytd Use Carry		Signed 18.6
TTR-Tran-Type = 61
LP102 LP197
TTS-YTD-LSTCARRYCL
Element: Ytd Lstcarrycl		Signed 18.6
TTR-Tran-Type = 46
LP102 LP197
TTS-END-CARRY-BAL
Element: End Carry Bal		Signed 18.6
LP102 LP197
TTS-ADJ-ACCRUE
Element: Adj Acrue		Derived
TTS-ADJ-ALLOT
Element: Adj Allot		Derived
TTS-ADJ-AVAIL
Element: Adj Avail		Derived
TTS-LOST-AVAIL
Element: Lost Avail		Derived


TATRANSUM FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TTSSET1 COMPANY
EMPLOYEE
PLAN
EMPLOYEE-GROUP
POSITION
TA-TYPE
RESET-DATE
LP102 LP140
LP180 LP197
LP264 LP331
PR160 PR180
PR80.2
TTSSET2 COMPANY
EMPLOYEE
PLAN
EMPLOYEE-GROUP
POSITION
TA-TYPE
RESET-DATE*
LP102 LP197
LP64.2
TTSSET3 COMPANY
HM-PROC-LEVEL
EMPLOYEE
PLAN
EMPLOYEE-GROUP
POSITION
TA-TYPE
RESET-DATE
LP102 LP197


TATRANSUM FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TTS-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Currency Code CUCODES Required
When TTS-CURRENCY-CODE !=Spaces
TTS-CURRENCY-CODE->CUC-CURRENCY-CODE
Employee EMPLOYEE Required
TTS-COMPANY->EMP-COMPANY
TTS-EMPLOYEE->EMP-EMPLOYEE
Employee Group PERSGROUP Required
TTS-COMPANY->PRG-COMPANY
TTS-EMPLOYEE-GROUP->PRG-GROUP-NAME
Employeemaster TAEEMASTER Required
TTS-COMPANY->TEM-COMPANY
TTS-EMPLOYEE->TEM-EMPLOYEE
TTS-PLAN->TEM-PLAN
TTS-EMPLOYEE-GROUP->TEM-EMPLOYEE-GROUP
TTS-POSITION->TEM-POSITION
Hm Proc Level PRSYSTEM Required
When TTS-HM-PROC-LEVEL !=Spaces
TTS-COMPANY->PRS-COMPANY
TTS-HM-PROC-LEVEL->PRS-PROCESS-LEVEL
Paemployee PAEMPLOYEE Required
TTS-COMPANY->PEM-COMPANY
TTS-EMPLOYEE->PEM-EMPLOYEE
Plan TAPLAN Required
TTS-COMPANY->TAP-COMPANY
TTS-PLAN->TAP-PLAN


TATRANSUM FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Position PAPOSITION
Valid When TTS-POSITION !=Spaces
TTS-COMPANY->POS-COMPANY
TTS-POSITION->POS-POSITION
  POS-EFFECT-DATE
Ta Trans TAEMPTRANS Delete Cascades
TTS-COMPANY->TTR-COMPANY
TTS-EMPLOYEE->TTR-EMPLOYEE
TTS-PLAN->TTR-PLAN
TTS-EMPLOYEE-GROUP->TTR-EMPLOYEE-GROUP
TTS-POSITION->TTR-POSITION
TTS-TA-TYPE->TTR-TA-TYPE
TTS-RESET-DATE->TTR-RESET-DATE
  TTR-DATE
  TTR-SEQ-NBR
Tastructur TASTRUCTUR
TTS-COMPANY->TST-COMPANY
TTS-EMPLOYEE-GROUP->TST-EMPLOYEE-GROUP
TTS-PLAN->TST-PLAN
  TST-BEGIN-DATE

File created: Thu Jun 09 02:22:13 2016

Home
Contact Us



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