Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EMTATRNSUM


                            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     TA260     TA290
TA65.2

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
Element: Company Hr    Contains the number that represents an    TA181   TA198
                       established company.                      TA199   TA80.1
                                                                 TA81.1

EMT-EMPLOYEE           Numeric 9                                 TA148   TA180
Element: 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
Element: From Plan NameContains 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
Element: Last Closed YeContains 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
Element: End Accrual HoContains 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
Element: End Eligible HContains 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                                TA180   TA181
Element: Hours Used    Contains the total eligible hours the     TA198   TA199
                       employee used.

EMT-LOST-ELIG-HRS      Signed 9.4                                TA180   TA199
Element: Lost Eligible Contains the total eligible hours that
                       exceeded the eligible limit. The
                       employee loses these hours.

EMT-YTD-ACCR-DOL       Signed 12.2
Element: Ytd Accr Dol

EMT-YTD-ELIG-DOL       Signed 12.2                               TA148   TA181
Element: Ytd Elig Dol                                            TA198   TA50.1
                                                                 TA81.1

EMT-END-ACCR-DOL       Signed 12.2
Element: End Accr Dol

EMT-END-ELIG-DOL       Signed 12.2                               TA181   TA81.1
Element: End Elig Dol

EMT-YTD-DOL-USED       Signed 12.2                               TA181   TA198
Element: Ytd Dol Used

EMT-BEG-BAL-DOL        Signed 12.2                               TA148   TA181
Element: Beg Bal Dol                                             TA198   TA81.1

EMT-BEG-ACR-HRS        Signed 9.4
Element: Beg Acr Hrs

EMT-BEG-ELIG-HRS       Signed 9.4                                TA148   TA181
Element: Beg Elig Hrs                                            TA198   TA81.1

EMT-COUNTRY-CODE       Alpha 2                                   TA148   TA181
Element: 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                                              TA148   TA180
          YEAR                                                   TA181   TA198
                                                                 TA199   TA260
                                                                 TA341   TA50.1
                                                                 TA60.1  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