|
|
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 Hr PR29.1 PR512
PR529 PR560
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
Element: Occurances Contains the total number of times you PR29.1 PR512
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
Element: Remain Occur Contains the value that indicates the PR12.3 PR140
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. PR36.1 PR512
When you run PR160 (Payment Print) to PR529 PR560
create prenotifications, the status PR80.1 PR82.1
changes to Prenotified. When the bank PR89.1 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
UK = United Kingdom
GB = Great Britain
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
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
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
EAD-DED-CYCLE-GRP Derived
Element: Ded Cycle Grp
EAD-DED-CYCLE-1 Derived
Element: Ded Cycle 1
EAD-DED-CYCLE-2 Derived
Element: Ded Cycle 2
EAD-DED-CYCLE-3 Derived
Element: Ded Cycle 3
EAD-DED-CYCLE-4 Derived
Element: Ded Cycle 4
EAD-DED-CYCLE-5 Derived
Element: Ded Cycle 5
EAD-DED-CYCLE-6 Derived
Element: Ded Cycle 6
EAD-DED-CYCLE-7 Derived
Element: Ded Cycle 7
EAD-DED-CYCLE-8 Derived
Element: Ded Cycle 8
EAD-DED-CYCLE-9 Derived
Element: Ded Cycle 9
EAD-CREATE-DATE Numeric 8 (yyyymmdd) PR12.1 PR12.3
Element: Date Stamp This field contains the server date PR29.1 PR512
(month, date, and year) of the last PR529 PR560
change to this record. PR82.1 UK560
EAD-CREATE-TIME Numeric 6 (hhmmss) PR12.1 PR12.3
Element: Time Stamp Contains the server time (hour, minute, PR29.1 PR512
and second) when the record was last PR529 PR560
changed. PR82.1 UK560
EAD-CREATE-USER-ID Alpha 10 (Lower Case) PR12.1 PR12.3
Element: User Id Contains the user ID of the person who PR29.1 PR512
last changed this record. PR529 PR560
PR82.1 UK560
EAD-DATE-STAMP Numeric 8 (yyyymmdd) BN66.1 PR12.1
Element: Date Stamp This field contains the server date PR12.3 PR140
(month, date, and year) of the last PR160 PR189
change to this record. PR195 PR29.1
PR36.1 PR45.1
PR512 PR529
PR560 PR80.1
PR82.1 PR89.1
UK560
EAD-TIME-STAMP Numeric 6 (hhmmss) BN66.1 PR12.1
Element: Time Stamp Contains the server time (hour, minute, PR12.3 PR140
and second) when the record was last PR160 PR189
changed. PR195 PR29.1
PR36.1 PR45.1
PR512 PR529
PR560 PR80.1
PR82.1 PR89.1
UK560
EAD-USER-ID Alpha 10 (Lower Case) BN66.1 PR12.1
Element: User Id Contains the user ID of the person who PR12.3 PR140
last changed this record. PR160 PR189
PR195 PR29.1
PR36.1 PR45.1
PR512 PR529
PR560 PR80.1
PR82.1 PR89.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
|
