Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EMACHDEPST


                            EMACHDEPST FILE

                          Employee ACH Account

This file contains information about employee Automated Clearing House (ACH)
accounts and usage. When net pay is distributed into ACH accounts, the
distribution history is recorded in the Employee ACH Distribution file. PR12.1
(ACH Distribution) is the primary program that updates this file. You can
define up to nine different accounts for an employee.

REFERENCED BY

HR170     HR70.1    PR141     PR155     PR162     PR212
PR260     PR712     UK141     PR229

UPDATED BY

BN66.1    PR12.1    PR12.3    PR140     PR160     PR189
PR195     PR29.1    PR36.1    PR45.1    PR512     PR529
PR560     PR80.1    PR82.1    PR89.1    UK560     HR11.1
PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

EAD-COMPANY            Numeric 4                                 PR12.1  PR12.3
Element: Company       The company number represents an          PR29.1  PR512
                       established company and is entered on     PR529   PR560
                       all function codes.                       PR82.1  UK560

EAD-EMPLOYEE           Numeric 9                                 PR12.1  PR12.3
Element: Employee      Contains the employee number. Each        PR29.1  PR512
                       person employed by the company is         PR529   PR560
                       assigned a unique number. The system      PR82.1  UK560
                       uses the employee number to correlate
                       all of the information related to that
                       person.

EAD-ACH-DIST-NBR       Numeric 2                                 PR12.1  PR12.3
Element: ACH DistributiContains the ACH distribution account     PR29.1  PR512
                       numbers defined for an employee. You can  PR529   PR560
                       define up to nine different accounts for  PR82.1  UK560
                       an employee.

EAD-OCCURANCES         Numeric 3                                 PR12.1  PR12.3
Total Number of        Contains the total number of times you    PR29.1  PR512
Occurrences            want the system to take the               PR529   PR560
                       distribution. If you do not want to       PR82.1  UK560
                       regulate the number of times the
                       distribution is taken, leave the
                       Occurrences - Original field blank in
                       PR12.1 (Distribution).

EAD-REMAIN-OCCUR       Numeric 3                                 BN66.1  PR12.1
Remaining              Contains the value that indicates the     PR12.3  PR140
Occurrences            remaining number of times a distribution  PR189   PR195
                       is to be taken.                           PR29.1  PR36.1
                                                                 PR45.1  PR512
                                                                 PR529   PR560
                                                                 PR80.1  PR82.1
                                                                 PR89.1  UK560

EAD-EBANK-ID           Numeric 9                                 PR12.1  PR12.3
Element: Bank ID       Contains the employee's bank DFI          PR29.1  PR512
                       (Depository Financial Institution)        PR529   PR560
                       identification number.                    PR82.1  UK560

EAD-EBNK-ACCT-NBR      Alpha 17                                  PR12.1  PR12.3
Element: Account       Contains the employee's bank account      PR29.1  PR512
                       number where payments are deposited.      PR529   PR560
                                                                 PR82.1  UK560

EAD-ACCOUNT-TYPE       Alpha 1                                   PR12.1  PR12.3
Element: Account Type  Contains the value that identifies the    PR29.1  PR512
                       bank account as a checking or savings     PR529   PR560
                       account. The account type is identified   PR82.1  UK560
                       on the tape created by PR160 (Payment
                       Print) as 23 for checking accounts and
                       33 for savings accounts.
                       C = Checking
                       S = Savings

EAD-ACH-PRENOTIFY      Alpha 1                                   BN66.1  PR12.1
Element: Prenotify StatContains the ACH prenotification status   PR12.3  PR140
                       between the account and the processing    PR160   PR189
                       bank. When you define an ACH account,     PR195   PR29.1
                       the prenotify status is Not Prenotified.  PR512   PR529
                       When you run PR160 (Payment Print) to     PR560   PR80.1
                       create prenotifications, the status       PR82.1  PR89.1
                       changes to Prenotified. When the bank     UK560
                       accepts the tape with the
                       prenotification, you must manually
                       change the status to Accepted. The
                       system does not distribute net pay to an
                       account until the status is Accepted.
                       A = Accepted
                       N = Not Prenotified
                       P = Prenotified

EAD-NET-PERCENT        Signed 7.3                                PR12.1  PR12.3
Element: Percent of NetContains the percent of the employee's    PR29.1  PR512
                       net pay to be deposited into the          PR529   PR560
                       account. Each account has either a        PR82.1  UK560
                       percent or flat amount identified.

EAD-DEPOSIT-AMT        Signed 13.2                               PR12.1  PR12.3
Element: Amount        Contains the flat amount to be            PR29.1  PR512
                       deposited into the account. Each account  PR529   PR560
                       has either a flat amount or a percent     PR82.1  UK560
                       indicated.

EAD-DESCRIPTION        Alpha 30  (Lower Case)                    PR12.1  PR12.3
Element: Description   Contains the ACH distribution             PR29.1  PR512
                       description.                              PR529   PR560
                                                                 PR82.1  UK560

EAD-CHECK-DESC         Alpha 8  (Lower Case)                     PR12.1  PR12.3
Element: Check DescriptContains the ACH distribution             PR29.1  PR512
                       identifier that prints on the payment     PR529   PR560
                       stub or pay receipt and on reports        PR82.1  UK560
                       generated by PR140 (Earnings and
                       Deductions Calculation).

EAD-BEG-DATE           Numeric 8  (yyyymmdd)                     PR12.1  PR12.3
Element: Begin Date    Contains the effective date deposits      PR29.1  PR512
                       can be made to the entered account.       PR529   PR560
                                                                 PR82.1  UK560

EAD-END-DATE           Numeric 8  (yyyymmdd)                     PR12.1  PR12.3
Element: End Date      Contains the last date deposits can be    PR29.1  PR512
                       made to the entered account.              PR529   PR560
                                                                 PR82.1  UK560

EAD-DED-CYCLE          Alpha 1 Occurs 9 Times                    PR12.1  PR12.3
Element: Deduction CyclContains the value that indicates the     PR29.1  PR512
                       payroll cycles in which the system takes  PR529   PR560
                       the ACH distribution.                     PR82.1  UK560
                       X

EAD-DEFAULT-FLAG       Alpha 1                                   PR12.1  PR12.3
Element: Default Flag  Contains the value that identifies the    PR29.1  PR512
                       account as the default account to which   PR529   PR560
                       the system deposits remaining amounts if  PR82.1  UK560
                       you do not specify 100 percent
                       distribution on the Pay form tab on
                       HR11.1 (Employee).
                       Y = Default ACH Account

EAD-BANK-ROLL-NO       Alpha 20                                  PR12.1  PR12.3
Element: Bank Roll No  Contains additional bank information      PR29.1  PR512
                       needed if an employee's bank is a         PR529   PR560
                       building society. Informational only.     PR82.1  UK560
                       (UK requirement)

EAD-ACH-DIST-ORDER     Numeric 2                                 PR12.1  PR12.3
Element: Ach Dist OrderContains the number that indicates the    PR29.1  PR512
                       order that ACH distributions are taken.   PR529   PR560
                       The ACH distribution record selected as   PR82.1  UK560
                       the default will always be the last one
                       processed. If partial auto deposit is
                       selected, the check is where the
                       remaining dollars are distributed to.

EAD-CA-INST-NBR        Numeric 4                                 PR12.1  PR12.3
Element: Ca Inst Nbr   Contains the value that identifies the    PR29.1  PR512
                       Canadian institution for the employees    PR529   PR560
                       direct deposit.                           PR82.1  UK560

EAD-CA-TRANSIT-NBR     Numeric 5                                 PR12.1  PR12.3
Element: Ca Transit NbrContains the Canadian transit number for  PR29.1  PR512
                       the employees direct deposit.             PR529   PR560
                                                                 PR82.1  UK560

EAD-COUNTRY-CODE       Alpha 2                                   PR12.1  PR12.3
Element: Country Code  The country code.  Required for VAT and   PR29.1  PR512
                       intrastat reporting.  Must be defined in  PR529   PR560
                        IN01.1 (Country Maintenance).            PR82.1  UK560
                       "  " = USA
                       CA = Canada
                       US = USA

EAD-CURRENCY-CODE      Alpha 5
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

EAD-CURR-ND            Numeric 1
Account Currency
Code

EAD-PENS-SEQ-NBR       Numeric 4                                 PR12.1  PR12.3
Element: Pens Seq Nbr                                            PR29.1  PR512
                                                                 PR529   PR560
                                                                 PR82.1  UK560

EAD-NON-STD-ENTRY      Numeric 1                                 PR12.1  PR12.3
Element: Non Std Entry 0                                         PR29.1  PR512
                       1 = Split                                 PR529   PR560
                       2 = NatWest                               PR82.1  UK560
                       3 = Co-Op

EAD-ORIG-ACCT-NBR      Alpha 17                                  PR12.1  PR12.3
Element: Orig Acct Nbr                                           PR29.1  PR512
                                                                 PR529   PR560
                                                                 PR82.1  UK560

EAD-PAYABLE-TO         Alpha 38  (Lower Case)                    PR12.1  PR12.3
Element: Payable To                                              PR29.1  PR512
                                                                 PR529   PR560
                                                                 PR82.1  UK560

                         EMACHDEPST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

EADSET1   COMPANY                                                BN66.1  HR11.1
          EMPLOYEE                                               HR170   HR70.1
          ACH-DIST-NBR                                           PA115   PR12.1
                                                                 PR12.3  PR12.5
                                                                 PR140   PR141
                                                                 PR155   PR160
                                                                 PR162   PR189
                                                                 PR195   PR212
                                                                 PR260   PR29.1
                                                                 PR36.1  PR45.1
                                                                 PR512   PR529
                                                                 PR560   PR712
                                                                 PR80.1  PR82.1
                                                                 PR89.1  UK141
                                                                 UK560

EADSET2   COMPANY       KeyChange, Subset                        BN66.1  PR140
          EMPLOYEE      Where ACH-DIST-ORDER != Zeroes           PR189   PR195
          DEFAULT-FLAG                                           PR80.1  PR89.1
          ACH-DIST-ORDER
          ACH-DIST-NBR

EADSET3   COMPANY       KeyChange, Subset                        PR160
          EMPLOYEE      Where ACH-PRENOTIFY = "N"
          ACH-DIST-NBR

EADSET4   COMPANY       KeyChange, Subset                        PR12.1  PR12.3
          EMPLOYEE      Where ACH-DIST-ORDER != Zeroes           PR29.1  PR512
          ACH-DIST-ORDER                                         PR529   PR560
          ACH-DIST-NBR                                           PR82.1  UK560

EADSET5   COMPANY       KeyChange, Subset                        BN66.1  PR140
          EMPLOYEE      Where OCCURANCES != Zeroes               PR189   PR195
          ACH-DIST-NBR                                           PR80.1  PR89.1

EADSET6   COMPANY                                                PR12.1  PR12.2
          EMPLOYEE                                               PR12.3  PR29.1
          COUNTRY-CODE                                           PR512   PR529
          ACH-DIST-NBR                                           PR560   PR82.1
                                                                 UK560

EADSET7   COMPANY       KeyChange, Subset                        PR12.1
          EMPLOYEE      Where PENS-SEQ-NBR = Zeroes
          PENS-SEQ-NBR
          ACH-DIST-NBR

EADSET8   COMPANY       KeyChange, Subset                        BN66.1  PR140
          EMPLOYEE      Where PENS-SEQ-NBR != Zeroes             PR189   PR195
          PENS-SEQ-NBR                                           PR229   PR29.1
          ACH-DIST-NBR                                           PR529   PR560
                                                                 PR80.1  PR82.1
                                                                 PR89.1  UK560

                         EMACHDEPST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            EAD-COMPANY           -> PRS-COMPANY
                            Spaces                -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required

                            EAD-COMPANY           -> EMP-COMPANY
                            EAD-EMPLOYEE          -> EMP-EMPLOYEE

Prempbankca    PREMPBANK    Required
                            When EAD-COUNTRY-CODE = "CA"

                            Zeroes                -> PEB-EBANK-ID
                            EAD-CA-INST-NBR       -> PEB-CA-INST-NBR
                            EAD-CA-TRANSIT-NBR    -> PEB-CA-TRANSIT-NBR

Prempbankus    PREMPBANK    Required

                            EAD-EBANK-ID          -> PEB-EBANK-ID
                            Zeroes                -> PEB-CA-INST-NBR
                            Zeroes                -> PEB-CA-TRANSIT-NBR