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 PR560 PR229
UPDATED BY
PR36.1 PR45.1 PR512 PR712
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EAD-COMPANY Numeric 4 PR512
Company The company number represents an
established company and is entered on
all function codes.
EAD-EMPLOYEE Numeric 9 PR512
Employee Contains the employee number. Each
person employed by the company is
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
EAD-ACH-DIST-NBR Numeric 2 PR512
ACH Distribution Contains the ACH distribution account
numbers defined for an employee. You can
define up to nine different accounts for
an employee.
EAD-OCCURANCES Numeric 3 PR512
Total Number of Contains the total number of times you
Occurrences want the system to take the
distribution. If you do not want to
regulate the number of times the
distribution is taken, leave the
Occurrences - Original field blank in
PR12.1 (Distribution).
EAD-REMAIN-OCCUR Numeric 3 PR36.1 PR45.1
Remaining Contains the value that indicates the PR512
Occurrences remaining number of times a distribution
is to be taken.
EAD-EBANK-ID Numeric 9 PR512
Bank ID Contains the employee's bank DFI
(Depository Financial Institution)
identification number.
EAD-EBNK-ACCT-NBR Alpha 17 PR512
Account Contains the employee's bank account
number where payments are deposited.
EAD-ACCOUNT-TYPE Alpha 1 PR512
Account Type Contains the value that identifies the
bank account as a checking or savings
account. The account type is identified
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 PR512
Prenotify Status Contains the ACH prenotification status
between the account and the processing
bank. When you define an ACH account,
the prenotify status is Not Prenotified.
When you run PR160 (Payment Print) to
create prenotifications, the status
changes to Prenotified. When the bank
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 PR512
Percent of Net Contains the percent of the employee's
net pay to be deposited into the
account. Each account has either a
percent or flat amount identified.
EAD-DEPOSIT-AMT Signed 13.2 PR512
Amount Contains the flat amount to be
deposited into the account. Each account
has either a flat amount or a percent
indicated.
EAD-DESCRIPTION Alpha 30 (Lower Case) PR512
Description Contains the ACH distribution
description.
EAD-CHECK-DESC Alpha 8 (Lower Case) PR512
Check Description Contains the ACH distribution
identifier that prints on the payment
stub or pay receipt and on reports
generated by PR140 (Earnings and
Deductions Calculation).
EAD-BEG-DATE Numeric 8 (yyyymmdd) PR512
Begin Date Contains the effective date deposits
can be made to the entered account.
EAD-END-DATE Numeric 8 (yyyymmdd) PR512
End Date Contains the last date deposits can be
made to the entered account.
EAD-DED-CYCLE Alpha 1 Occurs 9 Times PR512
Deduction Cycles Contains the value that indicates the
payroll cycles in which the system takes
the ACH distribution.
X
EAD-DEFAULT-FLAG Alpha 1 PR512
Default Flag Contains the value that identifies the
account as the default account to which
the system deposits remaining amounts if
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 PR512
Bank Roll No Contains additional bank information
needed if an employee's bank is a
building society. Informational only.
(UK requirement)
EAD-ACH-DIST-ORDER Numeric 2 PR512 PR712
Ach Dist Order Contains the number that indicates the
order that ACH distributions are taken.
The ACH distribution record selected as
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 PR512
Ca Inst Nbr Contains the value that identifies the
Canadian institution for the employees
direct deposit.
EAD-CA-TRANSIT-NBR Numeric 5 PR512
Ca Transit Nbr Contains the Canadian transit number for
the employees direct deposit.
EAD-COUNTRY-CODE Alpha 2 PR512
Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
" " = USA
CA = Canada
US = USA
EAD-CURRENCY-CODE Alpha 5
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
EAD-CURR-ND Numeric 1
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
EAD-PENS-SEQ-NBR Numeric 4 PR512
Pens Seq Nbr
EMACHDEPST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EADSET1 COMPANY HR170 HR70.1
EMPLOYEE PR141 PR155
ACH-DIST-NBR PR162 PR212
PR260 PR36.1
PR45.1 PR512
PR560 PR712
EADSET2 COMPANY KeyChange, Subset
EMPLOYEE Where ACH-DIST-ORDER != Zeroes
DEFAULT-FLAG
ACH-DIST-ORDER
ACH-DIST-NBR
EADSET3 COMPANY KeyChange, Subset
EMPLOYEE Where ACH-PRENOTIFY = "N"
ACH-DIST-NBR
EADSET4 COMPANY KeyChange, Subset PR512
EMPLOYEE Where ACH-DIST-ORDER != Zeroes
ACH-DIST-ORDER
ACH-DIST-NBR
EADSET5 COMPANY KeyChange, Subset
EMPLOYEE Where OCCURANCES != Zeroes
ACH-DIST-NBR
EADSET6 COMPANY PR512
EMPLOYEE
COUNTRY-CODE
ACH-DIST-NBR
EADSET7 COMPANY KeyChange, Subset
EMPLOYEE Where PENS-SEQ-NBR = Zeroes
PENS-SEQ-NBR
ACH-DIST-NBR
EADSET8 COMPANY KeyChange, Subset PR229
EMPLOYEE Where PENS-SEQ-NBR != Zeroes
PENS-SEQ-NBR
ACH-DIST-NBR
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
|
