Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EMTAMASTR


                             EMTAMASTR FILE

                      Employee Time Accrual Master

Contains a record for each plan in which an employee is enrolled, the dates
needed for accrual and eligible hours, and time accrual balances.

TA125 (Employee Enrollment Update) and TA60.1 (Employee Plan) update this
file.

REFERENCED BY

BN100     BN101     BN102     BN103     BN105     BN245
BN31.1    BN31.2    BN32.1    BN32.2    BN32.3    BN531
BN65.1    BN71.1    BN72.1    BS13.1    BS14.1    BS15.1
BS32.1    HR170     HR70.1    PA02.1    PA102     PA502
PR110     PR113     PR120     PR13.1    PR13.5    PR13.6
PR13.8    PR134     PR135     PR160     PR180     PR32.2
PR35.1    PR35.2    PR35.3    PR35.4    PR35.5    PR35.6
PR35.8    PR35.9    PR36.1    PR530     PR82.1    PR85.1
TA147     TA175     TA265     TA290     TA65.3    TA65.2
TA65.1    TA20.1    TA20.2    TA241     TA242     TA40.1
TA195     TA196     TA260     TA300     TA340

UPDATED BY

BN138     HR11.1    HR511     PA100     PA52.4    PR130
TA125     TA145     TA146     TA148     TA170     TA180
TA181     TA198     TA199     TA310     TA341     TA42.1
TA50.1    TA542     TA570     TA60.1    TA70.1    TA70.2
TA80.1    TA81.1    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ETM-COMPANY            Numeric 4                                 HR11.1  HR511
Element: Company Hr    Contains the number that represents an    PA100   PA52.4
                       established company.                      TA125   TA145
                                                                 TA180   TA181
                                                                 TA50.1  TA60.1
                                                                 TA80.1  TA81.1

ETM-EMPLOYEE           Numeric 9                                 HR11.1  HR511
Element: Employee      Contains the employee number which is     PA100   PA52.4
                       used to correlate all information         TA125   TA145
                       related to the employee.                  TA180   TA181
                                                                 TA50.1  TA60.1
                                                                 TA80.1  TA81.1

ETM-PLAN-NAME          Alpha 10                                  HR11.1  HR511
Element: From Plan NameContains the plan name. This is           PA100   PA52.4
                       verified in the Time Accrual Plan file.   TA125   TA145
                                                                 TA180   TA181
                                                                 TA50.1  TA60.1
                                                                 TA80.1  TA81.1

ETM-PL-ENTRY-DATE      Numeric 8  (yyyymmdd)                     TA145   TA170
Element: Plan Entry DatContains the date the employee enrolled   TA180   TA181
                       in the plan.                              TA50.1  TA60.1
                                                                 TA80.1  TA81.1

ETM-PL-END-DATE        Numeric 8  (yyyymmdd)                     TA180   TA181
Element: Plan End Date Contains the date the employee is no      TA50.1  TA60.1
                       longer enrolled in the plan.              TA80.1  TA81.1

ETM-RUN-DATE           Numeric 8  (yyyymmdd)                     TA180   TA181
Element: Program Run DaContains the last pay period end date     TA198   TA199
                       the plan was processed through TA199      TA80.1  TA81.1
                       (Time Accrual Close).

ETM-FST-ACR-DATE       Numeric 8  (yyyymmdd)                     TA180   TA199
Element: First Accrual Contains the first date the employee      TA60.1
                       can accrue hours. It is updated from the
                       temporary first accrual date by TA199
                       (Time Accrual Close).

ETM-LST-ACR-DATE       Numeric 8  (yyyymmdd)                     TA170   TA180
Element: Last Accrual DContains the last date the employee       TA199   TA80.1
                       received accrual hours. TA199 (Time
                       Accrual Close) updates this field using
                       the temporary last accrual.

ETM-ACR-LMT-DATE       Numeric 8  (yyyymmdd)                     TA199
Element: Accrual Limit Contains the last date accrual limits
                       were checked. TA199 (Time Accrual Close)
                       updates this field from the temporary
                       accrual limit date.

ETM-FST-ELIG-DATE      Numeric 8  (yyyymmdd)                     TA145   TA180
Element: First EligibleContains the first date the employee      TA199   TA50.1
                       can have eligible hours or begin          TA60.1  TA81.1
                       transferring accrual hours. TA199 (Time
                       Accrual Close) updates this field from
                       the temporary first eligible date.

ETM-LST-ELIG-DATE      Numeric 8  (yyyymmdd)                     TA180   TA199
Element: Last Eligible Contains the last date the employee
                       received eligible hours. TA199 (Time
                       Accrual Close) updates this field from
                       the temporary last eligible date.

ETM-ELIG-LMT-DATE      Numeric 8  (yyyymmdd)                     TA199
Element: Eligible LimitContains the last date eligible limits
                       were checked. TA199 (Time Accrual Close)
                       updates this field from the temporary
                       eligible limit date.

ETM-ACR-BALANCE        Signed 9.4                                TA180   TA199
Element: Accrual BalancContains the employee's accrual           TA80.1
                       balance. TA199 (Time Accrual Close)
                       updates this field from the temporary
                       accrual balance.

ETM-ELIG-BALANCE       Signed 9.4                                TA148   TA180
Element: Eligible BalanContains the employee's eligible          TA181   TA198
                       balance. TA199 (Time Accrual Close)       TA199   TA80.1
                       updates this field from the temporary     TA81.1
                       eligible balance.

ETM-T-RUN-DATE         Numeric 8  (yyyymmdd)                     PR130   TA146
Element: Temporary Run Contains the date TA170 (Time Accrual     TA170   TA198
                       Update) was run.                          TA199

                       This field is the period end date from
                       PR140 (Earnings and Deductions
                       Calculation).

ETM-T-FST-AC-DATE      Numeric 8  (yyyymmdd)                     TA170   TA199
Temporary First        Contains the first date the employee
Accrual Date           can accrue hours.

ETM-T-LST-AC-DATE      Numeric 8  (yyyymmdd)                     TA170   TA199
Temporary Last         Contains the last date the employee
Accrual Date           received accrual hours.

ETM-T-AC-LMT-DATE      Numeric 8  (yyyymmdd)                     TA170   TA199
Temporary Accrual      Contains the last date accrual limits
Lim Run Date           were checked.

ETM-T-FST-EL-DATE      Numeric 8  (yyyymmdd)                     TA170   TA199
Temporary First        Contains the first date the employee
Eligibl Date           can have eligible hours or start
                       transferring from accrual.

ETM-T-LST-EL-DATE      Numeric 8  (yyyymmdd)                     TA170   TA199
Temporary Last         Contains the last date the employee
Eligible Date          received eligible hours.

ETM-T-EL-LMT-DATE      Numeric 8  (yyyymmdd)                     TA170   TA199
Temporary Eligible     Contains the last date eligible hours
Lim Date               were checked for limits.

ETM-T-ACR-BALANCE      Signed 9.4                                TA170   TA199
Temporary Accrual      Contains the employee's accrual balance.
Balance

ETM-T-ELG-BALANCE      Signed 9.4                                PR130   TA146
Temporary Eligible     Contains the employee's eligible          TA170   TA198
Balance                balance.                                  TA199   TA42.1

ETM-ACR-DIST-CO        Numeric 4                                 TA60.1  TA80.1
Element: Company

ETM-ACR-ACCT-UNIT      Alpha 15                                  TA60.1  TA80.1
Element: Accounting UniContains the GL Interface File accrual
                       accounting unit.

ETM-ACR-ACCOUNT        Numeric 6                                 TA60.1  TA80.1
Element: Account       Contains the GL Interface File accrual
                       account.

ETM-ACR-SUB-ACCT       Numeric 4                                 TA60.1  TA80.1
Element: Subaccount    Contains the GL Interface File accrual
                       subaccount.

ETM-EXP-DIST-CO        Numeric 4                                 TA60.1  TA80.1
Element: Company

ETM-EXP-ACCT-UNIT      Alpha 15                                  TA60.1  TA80.1
Element: Accounting UniContains the GL Interface File expense
                       accounting unit.

ETM-EXP-ACCOUNT        Numeric 6                                 TA60.1  TA80.1
Element: Account       Contains the GL Interface File expense
                       account.

ETM-EXP-SUB-ACCT       Numeric 4                                 TA60.1  TA80.1
Element: Subaccount    Contains the GL Interface File expense
                       subaccount.

ETM-LST-SEQ-NBR        Numeric 4                                 BN138   PR130
Element: Last Sequence Contains the sequence number of the       TA146   TA148
                       last time accrual transaction record      TA170   TA180
                       created for the employee in the plan      TA181   TA42.1
                       for.                                      TA542   TA570
                                                                 TA70.1  TA70.2
                                                                 TA80.1  TA81.1

ETM-TRANSFER-FLAG      Alpha 1                                   TA170   TA180
Element: Transfer Flag Contains the value that indicates if      TA80.1
                       the transaction was a transfer from
                       another plan. The value changes to No
                       after you run TA170 (Time Accrual
                       Update).
                       Y = Yes
                       N = No

ETM-TA-DOLLARS         Signed 12.2                               TA148   TA181
Element: Ta Dollars                                              TA198   TA81.1

ETM-T-TA-DOLLARS       Signed 12.2                               PR130   TA146
Element: T Ta Dollars                                            TA198   TA42.1

ETM-EMPL-PERCENT       Signed 5.2                                TA50.1
Element: Empl Percent

ETM-EMPL-VAC-HRS       Numeric 7                                 TA50.1
Element: Empl Vac Hrs

ETM-COUNTRY-CODE       Alpha 2                                   HR11.1  HR511
Element: Country Code  The country code.  Required for VAT and   PA100   PA52.4
                       intrastat reporting.  Must be defined in  TA145   TA181
                        IN01.1 (Country Maintenance).            TA50.1  TA81.1

                         EMTAMASTR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ETMSET1   COMPANY                                                BN100   BN101
          EMPLOYEE                                               BN102   BN103
          PLAN-NAME                                              BN105   BN138
                                                                 BN245   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN531   BN65.1
                                                                 BN71.1  BN72.1
                                                                 BS13.1  BS14.1
                                                                 BS15.1  BS32.1
                                                                 HR11.1  HR11.2
                                                                 HR170   HR511
                                                                 HR70.1  PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA502
                                                                 ...

ETMSET2   COMPANY                                                PR130   TA147
          PLAN-NAME                                              TA148   TA170
          EMPLOYEE                                               TA180   TA181
                                                                 TA20.1  TA20.2
                                                                 TA241   TA242
                                                                 TA310   TA341
                                                                 TA40.1  TA65.2

ETMSET3   COMPANY                                                TA146   TA170
          COUNTRY-CODE                                           TA195   TA196
          EMPLOYEE                                               TA198   TA199
          PLAN-NAME                                              TA241   TA260
                                                                 TA300   TA340
                                                                 TA50.1  TA60.1

ETMSET4   COMPANY                                                TA175   TA65.1
          COUNTRY-CODE
          PLAN-NAME
          EMPLOYEE

                         EMTAMASTR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accrual Acct   GLMASTER     Required
                            When ETM-ACR-ACCT-UNIT != Spaces
                            Or   ETM-ACR-ACCOUNT   != Zeroes

                            ETM-COMPANY          -> GLM-COMPANY
                            ETM-ACR-ACCT-UNIT    -> GLM-ACCT-UNIT
                            ETM-ACR-ACCOUNT      -> GLM-ACCOUNT
                            ETM-ACR-SUB-ACCT     -> GLM-SUB-ACCOUNT

Company        PRSYSTEM     Required

                            ETM-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required

                            ETM-COMPANY          -> EMP-COMPANY
                            ETM-EMPLOYEE         -> EMP-EMPLOYEE

Expense Acct   GLMASTER     Required
                            When ETM-EXP-ACCT-UNIT != Spaces
                            Or   ETM-EXP-ACCOUNT   != Zeroes

                            ETM-COMPANY          -> GLM-COMPANY
                            ETM-EXP-ACCT-UNIT    -> GLM-ACCT-UNIT
                            ETM-EXP-ACCOUNT      -> GLM-ACCOUNT
                            ETM-EXP-SUB-ACCT     -> GLM-SUB-ACCOUNT

Plan           PLANMASTER   Required

                            ETM-COMPANY          -> PLM-COMPANY
                            ETM-PLAN-NAME        -> PLM-PLAN-NAME

Plan Class     PLANCLASS    Not Required

                            ETM-COMPANY          -> PLC-COMPANY
                            PLM-PLAN-CLASS       -> PLC-PLAN-CLASS

                         EMTAMASTR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Plan Trans     EMTATRANS    Delete Restricted

                            ETM-COMPANY          -> ETT-COMPANY
                            ETM-EMPLOYEE         -> ETT-EMPLOYEE
                            ETM-PLAN-NAME        -> ETT-PLAN-NAME
                                                    ETT-DATE
                                                    ETT-SEQ-NBR

Trans Summary  EMTATRNSUM   Delete Cascades

                            ETM-COMPANY          -> EMT-COMPANY
                            ETM-EMPLOYEE         -> EMT-EMPLOYEE
                            ETM-PLAN-NAME        -> EMT-PLAN-NAME
                                                    EMT-YEAR