TAEMPTRANS

This file contains the accrual plan transactions for each plan structure for an employee.

REFERENCED BY
HR11.1 HR511 LT101 LT111 LP100 LP101
LP103 LP264 LP31.1 LP64.3 LP64.1 PA100
PA52.4 LP240


UPDATED BY
LP102 LP130 LP131 LP138 LP140 LP145
LP151 LP180 LP197 LP198 LP331 LP370
LP570 LP70.1 LP70.2 LP80.1 HS17.1 LP270
PR160 PR180 PR80.2 HS706

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TTR-COMPANY
Element: Company Hr
Numeric 4
Contains the company number.
LP130 LP131
LP138 LP140
LP145 LP180
LP370 LP570
LP70.1 LP70.2
LP80.1
TTR-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.
LP130 LP131
LP138 LP140
LP145 LP180
LP370 LP570
LP70.1 LP70.2
LP80.1
TTR-PLAN
Element: Ta Plan
Alpha 10
Contains the absence plan name.
LP130 LP131
LP138 LP140
LP145 LP180
LP370 LP570
LP70.1 LP70.2
LP80.1
TTR-EMPLOYEE-GROUP
Element: Group Name
Alpha 10
Contains the accrual employee group which, when attached to a plan, represents an absence plan structure.
LP130 LP131
LP138 LP140
LP145 LP180
LP370 LP570
LP70.1 LP70.2
LP80.1
TTR-POSITION
Element: Position
Alpha 12
Contains the position code of the employee if plan balances are held at the position code level.
LP130 LP131
LP138 LP140
LP145 LP180
LP370 LP570
LP70.1 LP70.2
LP80.1
TTR-DATE
Element: Ta Tran Date
Numeric 8 (yyyymmdd)
Contains the date of the transaction. For events, the transaction date is determined based on the date of the event. Otherwise, the transaction date is based on the plan cycle frequency or the pay period end date of service records processed.
LP130 LP131
LP138 LP140
LP145 LP151
LP180 LP370
LP570 LP70.1
LP70.2 LP80.1
TTR-SEQ-NBR
Element: Seq Nbr
Numeric 4
Contains a unique sequence number that keeps records unique. It is automatically assigned when records are created.
LP130 LP131
LP138 LP140
LP145 LP180
LP370 LP570
LP70.1 LP70.2
LP80.1
TTR-TRAN-TYPE
Element: Ta Type
Numeric 2
Contains the transaction type. Transaction type 11 and 12 are created by LP138.
01 = Manual Accrual
02 = Manual Allotment
03 = Manual Available
04 = Manual Reserve
05 = Manual Carryover
10 = Restore Used Available
11 = Sell from Available
12 = Purchase for Available
21 = Accrual
22 = Allotment
23 = Allotment Adj for Rounding
31 = Transfer from Accrual
32 = Transfer from Allotment
33 = Transfer to Avail from Accr
34 = Transfer to Avail from Allot
35 = Creation of carryover balance
42 = Lost Accr-Ongoing Limit
43 = Lost Allot-Ongoing Limit
44 = Lost Avail-Carryover Limit
45 = Lost Avail-Carry Period Limit
46 = Lost Carry-Period Limit
47 = Reset Carry-Carryover Recalc
51 = Allotment Adj for Factor Chgs
52 = Allotment Adj for Accruals
61 = Use
63 = Payout
71 = Zero Accrual
72 = Zero Allotment
73 = Zero Available
74 = Zero Reserve
75 = Zero Carryover
81 = Transfer Accrual Bal
82 = Transfer Allotment Bal
83 = Transfer Available Bal
84 = Transfer Reserve Bal
85 = Transfer Carryover Bal
91 = Purge Accrual Bal
92 = Purge Allotment Bal
93 = Purge Available Bal
94 = Purge Reserve Bal
95 = Purge Carryover Bal
48 = Lost Avail-Ongoing Limit
LP130 LP131
LP138 LP140
LP145 LP151
LP180 LP370
LP570 LP70.1
LP70.2 LP80.1
TTR-BALANCE-TYPE
Element: Ta Type
Numeric 2
Determines which TAEEMASTER balance to adjust.
01 = Accrual
02 = Allotment
03 = Available
04 = Reserve
05 = Carryover
LP130 LP131
LP138 LP140
LP145 LP180
LP370 LP570
LP70.1 LP70.2
LP80.1
TTR-DESCRIPTION
Element: Ta Description
Alpha 30 (Lower Case)
Contains the transaction description.
LP130 LP131
LP138 LP140
LP145 LP151
LP180 LP370
LP570 LP70.1
LP70.2 LP80.1
TTR-TA-TYPE
Element: Ta Type
Numeric 2
Contains the transaction units of measure.
01 = Hours
02 = Earnings
LP130 LP131
LP138 LP140
LP145 LP180
LP370 LP570
LP70.1 LP70.2
LP80.1
TTR-TA-HOURS
Element: Ta Amount
Signed 18.6
Contains the hours associated with the transaction. Used with TA-Type = 1 (Hours).
LP130 LP131
LP138 LP140
LP145 LP151
LP180 LP370
LP570 LP64.3
LP70.1 LP70.2
LP80.1 PR80.2
TTR-TA-EARNINGS
Element: Ta Amount
Signed 18.6
Contains the earnings associated with the transaction. Used with TA-Type = 2 (Earnings).
LP130 LP131
LP138 LP140
LP145 LP180
LP370 LP570
LP64.3 LP70.1
LP70.2 LP80.1
PR80.2
TTR-CURRENCY-CODE
Element: Currency Code
Alpha 5
Contains the currency code for the transaction. Used with TA-Type = 2 (Earnings).
LP130 LP131
LP138 LP140
LP145 LP180
LP370 LP570
LP70.1 LP70.2
LP80.1
TTR-TA-LOS-CALC
Element: Ta Los Calc
Signed 9.2
Contains the length of service hours or cycles used to determine the amount of this transaction.
LP130 LP138
LP140 LP145
LP180 LP370
TTR-STATUS
Element: Ta Status
Numeric 1
Contains the the status of the transaction. Updated by TA140, TA197.
0 = Unprocessed
2 = Processed
3 = Transferred
9 = Closed
LP130 LP131
LP138 LP140
LP145 LP151
LP180 LP197
LP370 LP570
LP70.1 LP70.2
LP80.1
TTR-TA-OBJ-ID
Element: Obj Id
Numeric 12
This object ID will associate transactions created by LP138 to specific benefit plan enrollments and balances in BNTAEMPBAL.
LP130 LP138
LP370
TTR-PROCESS-DATE
Element: Ta Tran Date
Numeric 8 (yyyymmdd)
Contains the process through date of the LP140 job that processed this transaction.
LP130 LP138
LP140 LP145
LP370
TTR-RESET-DATE
Element: Ta Reset Date
Numeric 8 (yyyymmdd)
Contains the Reset Date determined by the Reset Point. This is the first date of the limit year. This will be the date used by LP197 when accumulating transactions into TATRANSUM file by reset date.
LP102 LP130
LP138 LP140
LP145 LP180
LP197 LP370
TTR-PLAN-CATEGORY
Element: Ta Category
Alpha 10
Contains the category for the plan. This is needed for limit check by plan category that will read open TAEMPTRANS record.
LP130 LP138
LP140 LP145
LP180 LP370
TTR-ALLOT-PER-BEG
Element: Ta Tran Date
Numeric 8 (yyyymmdd)
For allotments, contains the beginning date of the allotment period.
LP130 LP138
LP140 LP145
LP370
TTR-ALLOT-PER-END
Element: Ta Tran Date
Numeric 8 (yyyymmdd)
For allotments, contains the end date of the allotment period.
LP130 LP138
LP140 LP145
LP370
TTR-ALLOT-CYCLE-DT
Element: Ta Tran Date
Numeric 8 (yyyymmdd)
For cycle based allotments, contains the cycle date.
LP130 LP138
LP140 LP145
LP370
TTR-CLOSE-DATE
Element: Ta Tran Date
Numeric 8 (yyyymmdd)
Contains the system date that LP197 closed this transaction.
LP130 LP138
LP197 LP370
TTR-GL-POST-DATE
Element: Ta Tran Date
Numeric 8 (yyyymmdd)
For non reversing entries, this references the GL Post Date used on LP198.
LP130 LP138
LP198 LP370
TTR-HM-PROC-LEVEL
Element: Process Lev Hr
Alpha 5
Contains the employee's home process level.
LP130 LP131
LP138 LP140
LP145 LP180
LP370 LP570
LP70.1 LP70.2
LP80.1
TTR-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
Holds the server date this record was originally created.
LP130 LP131
LP138 LP140
LP145 LP151
LP180 LP370
LP570 LP70.1
LP70.2 LP80.1
TTR-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
Holds the server time this record was originally created.
LP130 LP131
LP138 LP140
LP145 LP151
LP180 LP370
LP570 LP70.1
LP70.2 LP80.1
TTR-CREATE-USER-ID
Element: User
Alpha 10 (Lower Case)
Contains the user ID of the person who originally created this record.
LP130 LP131
LP138 LP140
LP145 LP151
LP180 LP370
LP570 LP70.1
LP70.2 LP80.1
TTR-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.
LP130 LP131
LP138 LP140
LP145 LP151
LP180 LP197
LP198 LP370
LP570 LP70.1
LP70.2 LP80.1
TTR-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
LP130 LP131
LP138 LP140
LP145 LP151
LP180 LP197
LP198 LP370
LP570 LP70.1
LP70.2 LP80.1
TTR-USER-ID
Element: User
Alpha 10 (Lower Case)
Contains the user ID of the person who last updated this record.
LP130 LP131
LP138 LP140
LP145 LP151
LP180 LP197
LP198 LP370
LP570 LP70.1
LP70.2 LP80.1
TTR-TA-ACCR-RATE
Element: Ta Accr Rate
Signed 18.6
TTR-ORIG-RESET-DT
Element: Ta Reset Date
Numeric 8 (yyyymmdd)
LP130 LP131
LP138 LP140
LP145 LP180
LP370 LP570
LP70.1 LP70.2
LP80.1
TTR-TRAN-CODE
Element: Code
Alpha 10
LP570 LP70.1
LP70.2
TTR-ABN-OBJ-ID
Element: Abn Obj Id
Numeric 12
LP140


TAEMPTRANS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TTRSET1 COMPANY
EMPLOYEE
PLAN
EMPLOYEE-GROUP
POSITION
DATE
SEQ-NBR
HR11.1 HR511
HS17.1 LT101
LT111 LP100
LP101 LP102
LP103 LP130
LP131 LP140
LP145 LP151
LP180 LP197
LP264 LP31.1
LP331 LP370
LP64.3 LP70.1
LP70.2 LP80.1
PA100 PA52.4
TTRSET10 COMPANY
CREATE-DATE*
DATE-STAMP*
EMPLOYEE
PLAN
EMPLOYEE-GROUP
POSITION
DATE
SEQ-NBR
KeyChange
TTRSET2 COMPANY
EMPLOYEE
PLAN
EMPLOYEE-GROUP
POSITION
DATE
SEQ-NBR
Subset
WhereSTATUS =Zeroes
LP140 LP270
LP80.1
TTRSET3 COMPANY
PLAN
EMPLOYEE-GROUP
EMPLOYEE
POSITION
DATE
SEQ-NBR
LP145
TTRSET4 COMPANY
EMPLOYEE
PLAN
EMPLOYEE-GROUP
POSITION
DATE
SEQ-NBR
Subset
WhereSTATUS =2
LP131 LP140
LP145 LP240
PR160 PR180
PR80.2
TTRSET5 COMPANY
HM-PROC-LEVEL
EMPLOYEE
PLAN
EMPLOYEE-GROUP
POSITION
DATE
SEQ-NBR
KeyChange
LP130
TTRSET6 COMPANY
EMPLOYEE
PLAN
EMPLOYEE-GROUP
POSITION
TA-TYPE
RESET-DATE
DATE*
SEQ-NBR
KeyChange
LP198
TTRSET7 COMPANY
EMPLOYEE
PLAN
EMPLOYEE-GROUP
POSITION
DATE*
SEQ-NBR*
HS706 LP64.1
TTRSET8 COMPANY
EMPLOYEE
PLAN
EMPLOYEE-GROUP
POSITION
DATE
SEQ-NBR
Subset
WhereSTATUS =2
OrSTATUS =3
LP197
TTRSET9 COMPANY
EMPLOYEE
PLAN
EMPLOYEE-GROUP
POSITION
DATE*
SEQ-NBR
Subset
Where((TRAN-TYPE <=12)
Or(TRAN-TYPE >=81
AndTRAN-TYPE <=85))
And(STATUS <=2)
LP70.1 LP70.2


TAEMPTRANS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TTR-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Currency CUCODES Required
When TTR-CURRENCY-CODE !=Spaces
TTR-CURRENCY-CODE->CUC-CURRENCY-CODE
Employee EMPLOYEE Required
TTR-COMPANY->EMP-COMPANY
TTR-EMPLOYEE->EMP-EMPLOYEE
Employee Group PERSGROUP Required
TTR-COMPANY->PRG-COMPANY
TTR-EMPLOYEE-GROUP->PRG-GROUP-NAME
Employee Mastr TAEEMASTER Required
TTR-COMPANY->TEM-COMPANY
TTR-EMPLOYEE->TEM-EMPLOYEE
TTR-PLAN->TEM-PLAN
TTR-EMPLOYEE-GROUP->TEM-EMPLOYEE-GROUP
TTR-POSITION->TEM-POSITION
Hm Proc Level PRSYSTEM Required
When TTR-HM-PROC-LEVEL !=Spaces
TTR-COMPANY->PRS-COMPANY
TTR-HM-PROC-LEVEL->PRS-PROCESS-LEVEL
Paemployee PAEMPLOYEE Required
TTR-COMPANY->PEM-COMPANY
TTR-EMPLOYEE->PEM-EMPLOYEE
Pcodes PCODES Required
When TTR-TRAN-CODE !=Spaces
"LC"->PCO-TYPE
TTR-TRAN-CODE->PCO-CODE
Plan TAPLAN Required
TTR-COMPANY->TAP-COMPANY
TTR-PLAN->TAP-PLAN
Tatransum TATRANSUM Required
TTR-COMPANY->TTS-COMPANY
TTR-EMPLOYEE->TTS-EMPLOYEE
TTR-PLAN->TTS-PLAN
TTR-EMPLOYEE-GROUP->TTS-EMPLOYEE-GROUP
TTR-POSITION->TTS-POSITION
TTR-TA-TYPE->TTS-TA-TYPE
TTR-RESET-DATE->TTS-RESET-DATE


TAEMPTRANS FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Position PAPOSITION
Valid When TTR-POSITION !=Spaces
TTR-COMPANY->POS-COMPANY
TTR-POSITION->POS-POSITION
  POS-EFFECT-DATE
Tastructur TASTRUCTUR
TTR-COMPANY->TST-COMPANY
TTR-EMPLOYEE-GROUP->TST-EMPLOYEE-GROUP
TTR-PLAN->TST-PLAN
  TST-BEGIN-DATE


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

Home
Contact Us



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