TATRANSUM

REFERENCED BY
LP140 LP264 PR160 PR180 PR80.2


UPDATED BY
LP180 LP197 LP331 LP64.2

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

Home
Contact Us



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