EMTATRNSUM FILE
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
TA65.2 TA290
UPDATED BY
TA148 TA180 TA181 TA198 TA199 TA310
TA80.1 TA81.1 TA341 TA50.1 TA60.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EMT-COMPANY Numeric 4 TA148 TA180
Company Contains the number that represents an TA181 TA198
established company. TA199 TA80.1
TA81.1
EMT-EMPLOYEE Numeric 9 TA148 TA180
Employee Contains the employee number which is TA181 TA198
used to correlate all information TA199 TA80.1
related to the employee. TA81.1
EMT-PLAN-NAME Alpha 10 TA148 TA180
From Plan Name Contains the plan name. This is TA181 TA198
verified in the Time Accrual Plan file. TA199 TA80.1
TA81.1
EMT-YEAR Numeric 4 TA148 TA180
Last Closed Year Contains the year during which the TA181 TA198
summarized transactions occurred. TA199 TA80.1
TA81.1
EMT-YTD-ACR-HRS Signed 9.4 TA180 TA199
Year-to-date Contains the calendar year-to-date TA80.1
Accrual Hours accrued hours. If this is the current
year, these hours were last updated when
TA199 (Time Accrual Close) was run.
EMT-YTD-ELIG-HRS Signed 9.4 TA148 TA180
Year-to-date Contains the calendar year-to-date TA181 TA198
Eligible Hours eligible hours. If this is the current TA199 TA50.1
year, these hours were last updated when TA80.1 TA81.1
TA199 (Time Accrual Close) was run.
EMT-END-ACR-HRS Signed 9.4 TA180 TA199
End Accrual Hours Contains the balance of accrued hours TA80.1
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 Signed 9.4 TA180 TA181
End Eligible Hours Contains the eligible hours year-end TA199 TA80.1
balance. If current year, these hours TA81.1
were last updated when TA199 (Time
Accrual Close) was run.
EMT-HRS-USED Signed 7.2 PR80.2 TA180
Hours Used Contains the total eligible hours the TA181 TA198
employee used. TA199
EMT-LOST-ELIG-HRS Signed 9.4 TA180 TA199
Lost Eligible Hours Contains the total eligible hours that
exceeded the eligible limit. The
employee loses these hours.
EMT-YTD-ACCR-DOL Signed 12.2
Ytd Accr Dol
EMT-YTD-ELIG-DOL Signed 12.2 TA148 TA181
Ytd Elig Dol TA198 TA50.1
TA81.1
EMT-END-ACCR-DOL Signed 12.2
End Accr Dol
EMT-END-ELIG-DOL Signed 12.2 TA181 TA81.1
End Elig Dol
EMT-YTD-DOL-USED Signed 12.2 PR80.2 TA181
Ytd Dol Used TA198
EMT-BEG-BAL-DOL Signed 12.2 TA148 TA181
Beg Bal Dol TA198 TA81.1
EMT-BEG-ACR-HRS Signed 9.4
Beg Acr Hrs
EMT-BEG-ELIG-HRS Signed 9.4 TA148 TA181
Beg Elig Hrs TA198 TA81.1
EMT-COUNTRY-CODE Alpha 2 TA148 TA181
Country Code The country code. Required for VAT and TA198 TA81.1
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
EMTATRNSUM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EMTSET1 COMPANY HR170 HR70.1
EMPLOYEE PR160 PR180
PLAN-NAME PR80.2 TA148
YEAR TA180 TA181
TA198 TA199
TA260 TA341
TA50.1 TA60.1
TA65.2 TA80.1
TA81.1
EMTSET2 COMPANY TA148
PLAN-NAME
EMPLOYEE
YEAR
EMTSET3 COMPANY TA290 TA65.2
COUNTRY-CODE
EMPLOYEE
PLAN-NAME
YEAR
EMTSET4 COMPANY TA310
COUNTRY-CODE
PLAN-NAME
EMPLOYEE
YEAR
EMTATRNSUM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|
