TATRANSUM

REFERENCED BY
LP264


UPDATED BY
LP197 LP331 BN150 PR521 EXI2.1 EXI4.1
LP130 LP140 LP180 PR128 PR130 PR131
PR132 PR134 PR135 PR136 PR137 PR189
PR29.1 PR32.1 PR32.2 PR33.1 PR33.2 PR33.3
PR35.1 PR35.2 PR35.3 PR35.4 PR35.5 PR35.6
PR35.8 PR35.9 PR36.1 PR37.1 PR45.1 PR529
PR530 PR560 PR582 PR80.1 PR80.4 PR82.1
UK102 UK560 TA147 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
...
BN150 PR521
EXI2.1 EXI4.1
LP130 LP140
LP180 LP197
LP264 LP331
PR128 PR130
PR131 PR132
PR134 PR135
PR136 PR137
PR189 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
TTSSET2 COMPANY
EMPLOYEE
PLAN
EMPLOYEE-GROUP
POSITION
TA-TYPE
RESET-DATE*
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: Wed Jun 08 20:50:02 2016

Home
Contact Us



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