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

REFERENCED BY

LP270

LP271

UPDATED BY

LP130	LP131	LP138	LP140	LP145	LP180
LP197	LP198	LP331	LP370	LP570	LP70.1
LP70.2	LP80.1	HR11.1	HR511	LP100	LP101
LP102	LP103	LP264	LP31.1	LP64.3	LP64.1
PA100	PA52.4	LP240	PR160	PR180	PR80.2

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 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 06 = Manual Use 11 = Sell from Available 12 = Purchase for Available 21 = Accrual 22 = Allotment 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 Carryover Balance 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	LP130 LP131 LP138 LP140 LP145 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 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 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 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.	LP130 LP138 LP140 LP145 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 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 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 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 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 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 LP180 LP197 LP198 LP370 LP570 LP70.1 LP70.2 LP80.1
TTR-TA-ACCR-RATE Element: Ta Accr Rate	Signed 18.6 An amount per hour that is used to compute the accrual for any given period

TAEMPTRANS FILE INDEX

TAEMPTRANS FILE RELATIONS

ONE TO ONE RELATIONS

TAEMPTRANS FILE RELATIONS

ONE TO MANY RELATIONS

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