|
|
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
UPDATED BY
PR12.1 PR12.3 PR140 PR160 PR36.1 PR45.1
PR512 PR712 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EAD-COMPANY Numeric 4 PR12.1 PR12.3
Company The company number represents an PR512
established company and is entered on
all function codes.
EAD-EMPLOYEE Numeric 9 PR12.1 PR12.3
Employee Contains the employee number. Each PR512
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 PR12.1 PR12.3
ACH Distribution Contains the ACH distribution account PR512
numbers defined for an employee. You can
define up to nine different accounts for
an employee.
EAD-OCCURANCES Numeric 3 PR12.1 PR12.3
Total Number of Contains the total number of times you PR512
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 PR12.1 PR12.3
Remaining Contains the value that indicates the PR140 PR36.1
Occurrences remaining number of times a distribution PR45.1 PR512
is to be taken.
EAD-EBANK-ID Numeric 9 PR12.1 PR12.3
Bank ID Contains the employee's bank DFI PR512
(Depository Financial Institution)
identification number.
EAD-EBNK-ACCT-NBR Alpha 17 PR12.1 PR12.3
Account Contains the employee's bank account PR512
number where payments are deposited.
EAD-ACCOUNT-TYPE Alpha 1 PR12.1 PR12.3
Account Type Contains the value that identifies the PR512
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 PR12.1 PR12.3
Prenotify Status Contains the ACH prenotification status PR140 PR160
between the account and the processing PR512
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 PR12.1 PR12.3
Percent of Net Contains the percent of the employee's PR512
net pay to be deposited into the
account. Each account has either a
percent or flat amount identified.
EAD-DEPOSIT-AMT Signed 11.2 PR12.1 PR12.3
Amount Contains the flat amount to be PR512
deposited into the account. Each account
has either a flat amount or a percent
indicated.
EAD-DESCRIPTION Alpha 30 (Lower Case) PR12.1 PR12.3
Description Contains the ACH distribution PR512
description.
EAD-CHECK-DESC Alpha 8 (Lower Case) PR12.1 PR12.3
Check Description Contains the ACH distribution PR512
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) PR12.1 PR12.3
Begin Date Contains the effective date deposits PR512
can be made to the entered account.
EAD-END-DATE Numeric 8 (yyyymmdd) PR12.1 PR12.3
End Date Contains the last date deposits can be PR512
made to the entered account.
EAD-DED-CYCLE Alpha 1 Occurs 9 Times PR12.1 PR12.3
Deduction Cycles Contains the value that indicates the PR512
payroll cycles in which the system takes
the ACH distribution.
X
EAD-DEFAULT-FLAG Alpha 1 PR12.1 PR12.3
Default Flag Contains the value that identifies the PR512
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 PR12.1 PR12.3
Bank Roll No Contains additional bank information PR512
needed if an employee's bank is a
building society. Informational only.
(UK requirement)
EAD-ACH-DIST-ORDER Numeric 2 PR12.1 PR12.3
Ach Dist Order Contains the number that indicates the PR512 PR712
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.
EMACHDEPST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EADSET1 COMPANY HR11.1 HR170
EMPLOYEE HR70.1 PA115
ACH-DIST-NBR PR12.1 PR12.2
PR12.3 PR140
PR141 PR155
PR160 PR162
PR212 PR260
PR36.1 PR45.1
PR512 PR712
EADSET2 COMPANY KeyChange, Subset PR140
EMPLOYEE Where ACH-DIST-ORDER != Zeroes
DEFAULT-FLAG
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 PR512
ACH-DIST-ORDER
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
Prempbank PREMPBANK Not Required
EAD-EBANK-ID -> PEB-EBANK-ID
|