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