Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EMTATRANS


                             EMTATRANS FILE

                     Emp Time Accrual Transactions

Contains time accrual transactions for each plan for an employee.

REFERENCED BY

HR170     HR70.1    PR160     PR180     TA196     TA241
TA50.1    TA60.1    TA147     TA175     TA270     TA265
TA290     TA65.3

UPDATED BY

BN138     PR130     TA146     TA148     TA170     TA180
TA181     TA198     TA199     TA300     TA310     TA340
TA341     TA42.1    TA542     TA570     TA70.1    TA70.2
TA80.1    TA81.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ETT-COMPANY            Numeric 4                                 BN138   PR130
Element: Company Hr    Contains the number that represents an    TA146   TA148
                       established company.                      TA170   TA180
                                                                 TA181   TA300
                                                                 TA340   TA42.1
                                                                 TA542   TA570
                                                                 TA70.1  TA70.2
                                                                 TA80.1  TA81.1

ETT-EMPLOYEE           Numeric 9                                 BN138   PR130
Element: Employee      Contains the employee number which is     TA146   TA148
                       used to correlate all information         TA170   TA180
                       related to the employee.                  TA181   TA300
                                                                 TA340   TA42.1
                                                                 TA542   TA570
                                                                 TA70.1  TA70.2
                                                                 TA80.1  TA81.1

ETT-PLAN-NAME          Alpha 10                                  BN138   PR130
Element: From Plan NameContains the plan name. This is           TA146   TA148
                       verified in the Time Accrual Plan file.   TA170   TA180
                                                                 TA181   TA300
                                                                 TA340   TA42.1
                                                                 TA542   TA570
                                                                 TA70.1  TA70.2
                                                                 TA80.1  TA81.1

ETT-DATE               Numeric 8  (yyyymmdd)                     BN138   PR130
Element: Date          Contains the date of the transaction.     TA146   TA148
                       The transaction date can default from     TA170   TA180
                       the end date of the payroll period, the   TA181   TA300
                       last eligible date, or the eligible       TA340   TA42.1
                       limit date defined for the plan.          TA542   TA570
                                                                 TA70.1  TA70.2
                                                                 TA80.1  TA81.1

ETT-SEQ-NBR            Numeric 4                                 BN138   PR130
Element: Sequence NumbeContains a sequence number that keeps     TA146   TA148
                       records unique. It is automatically       TA170   TA180
                       assigned when records are created.        TA181   TA300
                                                                 TA340   TA42.1
                                                                 TA542   TA570
                                                                 TA70.1  TA70.2
                                                                 TA80.1  TA81.1

ETT-TYPE               Alpha 2                                   BN138   PR130
Element: Type          Contains the transaction type.            TA146   TA148
                       A = Accrual Hours                         TA170   TA180
                       B = Beginning balance from Purge          TA181   TA300
                       LA = Lost Accrual                         TA340   TA42.1
                       LE = Lost Eligible                        TA542   TA570
                       MA = Manual Accrual                       TA70.1  TA70.2
                       ME = Manual Eligible                      TA80.1  TA81.1
                       TA = Transfer Accrual
                       TE = Transfer Eligible
                       U = Usage Hours
                       X = Accrued and Eligible Hours
                       MV = CA Manual Vac
                       XV = CA Eligible Vac
                       UV = CA Used Vac
                       BV = CA Beg Bal Vac
                       LV = CA Lost Vac

ETT-DESCRIPTION        Alpha 30  (Lower Case)                    BN138   PR130
Element: Description   Contains the transaction description.     TA146   TA148
                                                                 TA170   TA180
                                                                 TA181   TA300
                                                                 TA340   TA42.1
                                                                 TA542   TA570
                                                                 TA70.1  TA70.2
                                                                 TA80.1  TA81.1

ETT-TA-HOURS           Signed 9.4                                BN138   PR130
Element: Ta Hours      Contains the hours associated with the    TA146   TA148
                       transaction.                              TA170   TA180
                                                                 TA181   TA300
                                                                 TA340   TA42.1
                                                                 TA542   TA570
                                                                 TA65.3  TA70.1
                                                                 TA70.2  TA80.1
                                                                 TA81.1

ETT-STATUS             Numeric 1                                 BN138   PR130
Element: Status        Contains the transaction status.          TA146   TA148
                       0 = Unprocessed (Created in TA70)         TA170   TA180
                       2 = Processed (Ran TA170)                 TA181   TA198
                       9 = Closed (Ran TA199)                    TA199   TA300
                                                                 TA340   TA42.1
                                                                 TA542   TA570
                                                                 TA70.1  TA70.2
                                                                 TA80.1  TA81.1

ETT-TA-DOLLARS         Signed 12.2                               PR130   TA146
Element: Ta Dollars                                              TA148   TA181
                                                                 TA340   TA42.1
                                                                 TA542   TA81.1

ETT-VAC-PAY-CLASS      Alpha 3                                   TA146
Element: Vac Pay Class

ETT-VAC-PAY-CODE       Alpha 4                                   PR130   TA146
Element: Vac Pay Code

ETT-COUNTRY-CODE       Alpha 2                                   PR130   TA146
Element: Country Code  The country code.  Required for VAT and   TA148   TA181
                       intrastat reporting.  Must be defined in  TA42.1  TA542
                        IN01.1 (Country Maintenance).            TA70.1  TA70.2
                                                                 TA81.1

                         EMTATRANS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ETTSET1   COMPANY                                                HR170   HR70.1
          EMPLOYEE                                               PR130   PR160
          PLAN-NAME                                              PR180   TA180
          DATE                                                   TA181   TA196
          SEQ-NBR                                                TA241   TA300
                                                                 TA340   TA341
                                                                 TA50.1  TA60.1

ETTSET2   COMPANY                                                PR130   TA147
          PLAN-NAME                                              TA148
          EMPLOYEE
          DATE
          SEQ-NBR

ETTSET3   COMPANY       Subset                                   PR130   TA180
          COUNTRY-CODE  Where STATUS = 2                         TA181   TA199
          PLAN-NAME     Or    STATUS = Zeroes                    TA42.1  TA70.1
          EMPLOYEE
          DATE
          SEQ-NBR

ETTSET4   COMPANY       Subset                                   PR130   TA146
          COUNTRY-CODE  Where STATUS = 2                         TA170   TA175
          EMPLOYEE      Or    STATUS = Zeroes                    TA198   TA270
          PLAN-NAME                                              TA70.2  TA80.1
          DATE                                                   TA81.1
          SEQ-NBR

ETTSET5   COMPANY                                                TA265   TA290
          COUNTRY-CODE                                           TA300   TA340
          EMPLOYEE                                               TA65.3
          PLAN-NAME
          DATE
          SEQ-NBR

ETTSET6   COMPANY                                                TA310
          COUNTRY-CODE
          PLAN-NAME
          EMPLOYEE
          DATE
          SEQ-NBR

                         EMTATRANS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            ETT-COMPANY      -> PRS-COMPANY
                            Spaces           -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required

                            ETT-COMPANY      -> EMP-COMPANY
                            ETT-EMPLOYEE     -> EMP-EMPLOYEE

Employee Plan  EMTAMASTR    Required

                            ETT-COMPANY      -> ETM-COMPANY
                            ETT-EMPLOYEE     -> ETM-EMPLOYEE
                            ETT-PLAN-NAME    -> ETM-PLAN-NAME

Plan           PLANMASTER   Required

                            ETT-COMPANY      -> PLM-COMPANY
                            ETT-PLAN-NAME    -> PLM-PLAN-NAME