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 |
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. |
|
||||||||||||||
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. |
|
||||||||||||||
TTR-PLAN Element: Ta Plan | Alpha 10 Contains the absence plan name. |
|
||||||||||||||
TTR-EMPLOYEE-GROUP Element: Group Name | Alpha 10 Contains the accrual employee group which, when attached to a plan, represents an absence plan structure. |
|
||||||||||||||
TTR-POSITION Element: Position | Alpha 12 Contains the position code of the employee if plan balances are held at the position code level. |
|
||||||||||||||
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. |
|
||||||||||||||
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. |
|
||||||||||||||
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 |
|
||||||||||||||
TTR-BALANCE-TYPE Element: Ta Type | Numeric 2 Determines which TAEEMASTER balance to adjust. 01 = Accrual 02 = Allotment 03 = Available 04 = Reserve 05 = Carryover |
|
||||||||||||||
TTR-DESCRIPTION Element: Ta Description | Alpha 30 (Lower Case) Contains the transaction description. |
|
||||||||||||||
TTR-TA-TYPE Element: Ta Type | Numeric 2 Contains the transaction units of measure. 01 = Hours 02 = Earnings |
|
||||||||||||||
TTR-TA-HOURS Element: Ta Amount | Signed 18.6 Contains the hours associated with the transaction. Used with TA-Type = 1 (Hours). |
|
||||||||||||||
TTR-TA-EARNINGS Element: Ta Amount | Signed 18.6 Contains the earnings associated with the transaction. Used with TA-Type = 2 (Earnings). |
|
||||||||||||||
TTR-CURRENCY-CODE Element: Currency Code | Alpha 5 Contains the currency code for the transaction. Used with TA-Type = 2 (Earnings). |
|
||||||||||||||
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. |
|
||||||||||||||
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 |
|
||||||||||||||
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. |
|
||||||||||||||
TTR-PROCESS-DATE Element: Ta Tran Date | Numeric 8 (yyyymmdd) Contains the process through date of the LP140 job that processed this transaction. |
|
||||||||||||||
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. |
|
||||||||||||||
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. |
|
||||||||||||||
TTR-ALLOT-PER-BEG Element: Ta Tran Date | Numeric 8 (yyyymmdd) For allotments, contains the beginning date of the allotment period. |
|
||||||||||||||
TTR-ALLOT-PER-END Element: Ta Tran Date | Numeric 8 (yyyymmdd) For allotments, contains the end date of the allotment period. |
|
||||||||||||||
TTR-ALLOT-CYCLE-DT Element: Ta Tran Date | Numeric 8 (yyyymmdd) For cycle based allotments, contains the cycle date. |
|
||||||||||||||
TTR-CLOSE-DATE Element: Ta Tran Date | Numeric 8 (yyyymmdd) Contains the system date that LP197 closed this transaction. |
|
||||||||||||||
TTR-GL-POST-DATE Element: Ta Tran Date | Numeric 8 (yyyymmdd) For non reversing entries, this references the GL Post Date used on LP198. |
|
||||||||||||||
TTR-HM-PROC-LEVEL Element: Process Lev Hr | Alpha 5 Contains the employee's home process level. |
|
||||||||||||||
TTR-CREATE-DATE Element: Date Stamp | Numeric 8 (yyyymmdd) Holds the server date this record was originally created. |
|
||||||||||||||
TTR-CREATE-TIME Element: Time Stamp | Numeric 6 (hhmmss) Holds the server time this record was originally created. |
|
||||||||||||||
TTR-CREATE-USER-ID Element: User | Alpha 10 (Lower Case) Contains the user ID of the person who originally created this record. |
|
||||||||||||||
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. |
|
||||||||||||||
TTR-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||||||||||||||
TTR-USER-ID Element: User | Alpha 10 (Lower Case) Contains the user ID of the person who last updated this record. |
|
||||||||||||||
TTR-TA-ACCR-RATE Element: Ta Accr Rate | Signed 18.6 |
|
||||||||||||||
TTR-ORIG-RESET-DT Element: Ta Reset Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||
TTR-TRAN-CODE Element: Code | Alpha 10 |
|
||||||||||||||
TTR-ABN-OBJ-ID Element: Abn Obj Id | Numeric 12 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
TTRSET1 |
COMPANY EMPLOYEE PLAN EMPLOYEE-GROUP POSITION DATE SEQ-NBR |
|
| ||||||||||||||||||||||||||||||||
TTRSET10 |
COMPANY CREATE-DATE* DATE-STAMP* EMPLOYEE PLAN EMPLOYEE-GROUP POSITION DATE SEQ-NBR |
|
|||||||||||||||||||||||||||||||||
TTRSET2 |
COMPANY EMPLOYEE PLAN EMPLOYEE-GROUP POSITION DATE SEQ-NBR |
|
| ||||||||||||||||||||||||||||||||
TTRSET3 |
COMPANY PLAN EMPLOYEE-GROUP EMPLOYEE POSITION DATE SEQ-NBR |
|
| ||||||||||||||||||||||||||||||||
TTRSET4 |
COMPANY EMPLOYEE PLAN EMPLOYEE-GROUP POSITION DATE SEQ-NBR |
|
| ||||||||||||||||||||||||||||||||
TTRSET5 |
COMPANY HM-PROC-LEVEL EMPLOYEE PLAN EMPLOYEE-GROUP POSITION DATE SEQ-NBR |
|
| ||||||||||||||||||||||||||||||||
TTRSET6 |
COMPANY EMPLOYEE PLAN EMPLOYEE-GROUP POSITION TA-TYPE RESET-DATE DATE* SEQ-NBR |
|
| ||||||||||||||||||||||||||||||||
TTRSET7 |
COMPANY EMPLOYEE PLAN EMPLOYEE-GROUP POSITION DATE* SEQ-NBR* |
|
| ||||||||||||||||||||||||||||||||
TTRSET8 |
COMPANY EMPLOYEE PLAN EMPLOYEE-GROUP POSITION DATE SEQ-NBR |
|
| ||||||||||||||||||||||||||||||||
TTRSET9 |
COMPANY EMPLOYEE PLAN EMPLOYEE-GROUP POSITION DATE* SEQ-NBR |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Company | PRSYSTEM |
Required
| |||||||||||||||||||||
Currency | CUCODES |
Required
| |||||||||||||||||||||
Employee | EMPLOYEE |
Required
| |||||||||||||||||||||
Employee Group | PERSGROUP |
Required
| |||||||||||||||||||||
Employee Mastr | TAEEMASTER |
Required
| |||||||||||||||||||||
Hm Proc Level | PRSYSTEM |
Required
| |||||||||||||||||||||
Paemployee | PAEMPLOYEE |
Required
| |||||||||||||||||||||
Pcodes | PCODES |
Required
| |||||||||||||||||||||
Plan | TAPLAN |
Required
| |||||||||||||||||||||
Tatransum | TATRANSUM |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Position | PAPOSITION |
| |||||||||||||||
Tastructur | TASTRUCTUR |
|
All trademarks and registered trademarks are the property of their
respective owners.