Emp TA Transaction Summary
Contains a summary of the transactions that occurred during the calendar year for the plan, by employee.
REFERENCED BY
| HR170 | HR70.1 | PR160 | PR180 | PR80.2 | TA260 |
| TA290 | TA65.2 |
| TA148 | TA310 | TA80.1 | TA81.1 | TA341 | TA50.1 |
| TA60.1 |
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||
|---|---|---|---|---|---|---|
| EMT-COMPANY Element: Company Hr | Numeric 4 Contains the number that represents an established company. |
|
||||
| EMT-EMPLOYEE Element: Employee | Numeric 9 Contains the employee number which is used to correlate all information related to the employee. |
|
||||
| EMT-PLAN-NAME Element: Plan Name | Alpha 10 Contains the plan name. This is verified in the Time Accrual Plan file. |
|
||||
| EMT-YEAR Element: Year | Numeric 4 Contains the year during which the summarized transactions occurred. |
|
||||
| EMT-YTD-ACR-HRS Element: Ytd Acr Hrs | Signed 9.4 Contains the calendar year-to-date accrued hours. If this is the current year, these hours were last updated when TA199 (Time Accrual Close) was run. |
|
||||
| EMT-YTD-ELIG-HRS Element: Ytd Elig Hrs | Signed 9.4 Contains the calendar year-to-date eligible hours. If this is the current year, these hours were last updated when TA199 (Time Accrual Close) was run. |
|
||||
| EMT-END-ACR-HRS Element: End Acr Hrs | Signed 9.4 Contains the balance of accrued hours for this calendar year. If this is the current year, these hours were last updated when TA199 (Time Accrual Close) was run. |
|
||||
| EMT-END-ELIG-HRS Element: End Elig Hrs | Signed 9.4 Contains the eligible hours year-end balance. If current year, these hours were last updated when TA199 (Time Accrual Close) was run. |
|
||||
| EMT-HRS-USED Element: Hrs Used | Signed 7.2 Contains the total eligible hours the employee used. |
|
||||
| EMT-LOST-ELIG-HRS Element: Lost Elig Hrs | Signed 9.4 Contains the total eligible hours that exceeded the eligible limit. The employee loses these hours. |
|
||||
| EMT-YTD-ACCR-DOL Element: Ytd Accr Dol | Signed 12.2 |
|
||||
| EMT-YTD-ELIG-DOL Element: Ytd Elig Dol | Signed 12.2 |
|
||||
| EMT-END-ACCR-DOL Element: End Accr Dol | Signed 12.2 |
|
||||
| EMT-END-ELIG-DOL Element: End Elig Dol | Signed 12.2 |
|
||||
| EMT-YTD-DOL-USED Element: Ytd Dol Used | Signed 12.2 |
|
||||
| EMT-BEG-BAL-DOL Element: Beg Bal Dol | Signed 12.2 |
|
||||
| EMT-BEG-ACR-HRS Element: Beg Acr Hrs | Signed 9.4 |
|
||||
| EMT-BEG-ELIG-HRS Element: Beg Elig Hrs | Signed 9.4 |
|
||||
| EMT-COUNTRY-CODE Element: Country Code | Alpha 2 The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance). |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| EMTSET1 |
COMPANY EMPLOYEE PLAN-NAME YEAR |
|
| ||||||||||||||||||||
| EMTSET2 |
COMPANY PLAN-NAME EMPLOYEE YEAR |
|
| ||||||||||||||||||||
| EMTSET3 |
COMPANY COUNTRY-CODE EMPLOYEE PLAN-NAME YEAR |
|
| ||||||||||||||||||||
| EMTSET4 |
COMPANY COUNTRY-CODE PLAN-NAME EMPLOYEE YEAR |
|
| ||||||||||||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Company | PRSYSTEM |
Required
| |||||||||
| Employee | EMPLOYEE |
Required
| |||||||||
| Employee Plan | EMTAMASTR |
Required
| |||||||||
| Plan | PLANMASTER |
Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Transactions | EMTATRANS |
Delete Cascades
|
All trademarks and registered trademarks are the property of their
respective owners.