EMTATRNSUM

Emp TA Transaction Summary

Contains a summary of the transactions that occurred during the calendar year for the plan, by employee.

REFERENCED BY
PR160 PR180 PR80.2 TA260


UPDATED BY
TA148 TA180 TA181 TA198 TA199 TA310
TA80.1 TA81.1 HR170 HR70.1 TA290 TA341
TA50.1 TA60.1 TA65.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EMT-COMPANY
Element: Company Hr
Numeric 4
Contains the number that represents an established company.
TA148 TA180
TA181 TA198
TA199 TA80.1
TA81.1
EMT-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee number which is used to correlate all information related to the employee.
TA148 TA180
TA181 TA198
TA199 TA80.1
TA81.1
EMT-PLAN-NAME
Element: Plan Name
Alpha 10
Contains the plan name. This is verified in the Time Accrual Plan file.
TA148 TA180
TA181 TA198
TA199 TA80.1
TA81.1
EMT-YEAR
Element: Year
Numeric 4
Contains the year during which the summarized transactions occurred.
TA148 TA180
TA181 TA198
TA199 TA80.1
TA81.1
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.
TA180 TA199
TA80.1
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.
TA148 TA180
TA181 TA198
TA199 TA50.1
TA80.1 TA81.1
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.
TA180 TA199
TA80.1
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.
TA180 TA181
TA199 TA80.1
TA81.1
EMT-HRS-USED
Element: Hrs Used
Signed 7.2
Contains the total eligible hours the employee used.
PR80.2 TA180
TA181 TA198
TA199
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.
TA180 TA199
EMT-YTD-ACCR-DOL
Element: Ytd Accr Dol
Signed 12.2
EMT-YTD-ELIG-DOL
Element: Ytd Elig Dol
Signed 12.2
TA148 TA181
TA198 TA50.1
TA81.1
EMT-END-ACCR-DOL
Element: End Accr Dol
Signed 12.2
EMT-END-ELIG-DOL
Element: End Elig Dol
Signed 12.2
TA181 TA81.1
EMT-YTD-DOL-USED
Element: Ytd Dol Used
Signed 12.2
PR80.2 TA181
TA198
EMT-BEG-BAL-DOL
Element: Beg Bal Dol
Signed 12.2
TA148 TA181
TA198 TA81.1
EMT-BEG-ACR-HRS
Element: Beg Acr Hrs
Signed 9.4
EMT-BEG-ELIG-HRS
Element: Beg Elig Hrs
Signed 9.4
TA148 TA181
TA198 TA81.1
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).
TA148 TA181
TA198 TA81.1


EMTATRNSUM FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EMTSET1 COMPANY
EMPLOYEE
PLAN-NAME
YEAR
HR170 HR70.1
PR160 PR180
PR80.2 TA148
TA180 TA181
TA198 TA199
TA260 TA290
TA341 TA50.1
TA60.1 TA80.1
TA81.1
EMTSET2 COMPANY
PLAN-NAME
EMPLOYEE
YEAR
TA148
EMTSET3 COMPANY
COUNTRY-CODE
EMPLOYEE
PLAN-NAME
YEAR
TA290 TA65.2
EMTSET4 COMPANY
COUNTRY-CODE
PLAN-NAME
EMPLOYEE
YEAR
TA310


EMTATRNSUM FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
EMT-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
EMT-COMPANY->EMP-COMPANY
EMT-EMPLOYEE->EMP-EMPLOYEE
Employee Plan EMTAMASTR Required
EMT-COMPANY->ETM-COMPANY
EMT-EMPLOYEE->ETM-EMPLOYEE
EMT-PLAN-NAME->ETM-PLAN-NAME
Plan PLANMASTER Required
EMT-COMPANY->PLM-COMPANY
EMT-PLAN-NAME->PLM-PLAN-NAME


EMTATRNSUM FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Transactions EMTATRANS Delete Cascades
EMT-COMPANY->ETT-COMPANY
EMT-EMPLOYEE->ETT-EMPLOYEE
EMT-PLAN-NAME->ETT-PLAN-NAME
  ETT-DATE
  ETT-SEQ-NBR


File created: Wed Jun 08 20:51:41 2016

Home
Contact Us



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