|
|
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
TA290 TA65.2
UPDATED BY
TA180 TA199 TA310 TA80.1 TA60.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EMT-COMPANY Numeric 4 TA180 TA199
Company Contains the number that represents an TA80.1
established company.
EMT-EMPLOYEE Numeric 9 TA180 TA199
Employee Contains the employee number which is TA80.1
used to correlate all information
related to the employee.
EMT-PLAN-NAME Alpha 10 TA180 TA199
From Plan Name Contains the plan name. This is TA80.1
verified in the Time Accrual Plan file.
EMT-YEAR Numeric 4 TA180 TA199
Last Closed Year Contains the year during which the TA80.1
summarized transactions occurred.
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 TA180 TA199
Year-to-date Contains the calendar year-to-date TA80.1
Eligible Hours eligible hours. If this is the current
year, these hours were last updated when
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 TA199
End Eligible Hours Contains the eligible hours year-end TA80.1
balance. If current year, these hours
were last updated when TA199 (Time
Accrual Close) was run.
EMT-HRS-USED Signed 7.2 TA180 TA199
Hours Used Contains the total eligible hours the
employee used.
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.
EMTATRNSUM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EMTSET1 COMPANY HR170 HR70.1
EMPLOYEE PR160 PR180
PLAN-NAME PR80.2 TA180
YEAR TA199 TA260
TA290 TA60.1
TA65.2 TA80.1
EMTSET2 COMPANY TA310
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
|