EMACHDEPST

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 HR94.1 PR141 PR155 PR162
PR180 PR212 PR260 PR712 PR229


UPDATED BY
BN66.1 PR12.1 PR12.3 PR140 PR160 PR189
PR195 PR29.1 PR36.1 PR36.4 PR45.1 PR512
PR529 PR560 PR582 PR80.1 PR80.4 PR82.1
PR89.1 PRAT.1 HR11.1 PA115

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EAD-COMPANY
Element: Company Hr
Numeric 4
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-EMPLOYEE
Element: Employee
Numeric 9
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.
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-ACH-DIST-NBR
Element: ACH Distribution
Numeric 2
Contains the ACH distribution account numbers defined for an employee. You can define up to nine different accounts for an employee.
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-OCCURANCES
Element: Occurances
Numeric 3
Contains the total number of times you 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).
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-REMAIN-OCCUR
Element: Remain Occur
Numeric 3
Contains the value that indicates the remaining number of times a distribution is to be taken.
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-EBANK-ID
Element: Bank ID
Numeric 9
Contains the employee's bank DFI (Depository Financial Institution) identification number.
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-EBNK-ACCT-NBR
Element: Account
Alpha 17
Contains the employee's bank account number where payments are deposited.
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-ACCOUNT-TYPE
Element: Account Type
Alpha 1
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
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-ACH-PRENOTIFY
Element: Prenotify Status
Alpha 1
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
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-NET-PERCENT
Element: Percent of Net
Signed 7.3
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.
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-DEPOSIT-AMT
Element: Amount
Signed 13.2
Contains the flat amount to be deposited into the account. Each account has either a flat amount or a percent indicated.
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
Contains the ACH distribution description.
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-CHECK-DESC
Element: Check Description
Alpha 8 (Lower Case)
Contains the ACH distribution identifier that prints on the payment stub or pay receipt and on reports generated by PR140 (Earnings and Deductions Calculation).
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-BEG-DATE
Element: Begin Date
Numeric 8 (yyyymmdd)
Contains the effective date deposits can be made to the entered account.
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
Contains the last date deposits can be made to the entered account.
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-DED-CYCLE
Element: Deduction Cycles
Alpha 1 Occurs 9 Times
Contains the value that indicates the payroll cycles in which the system takes the ACH distribution.
X
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-DEFAULT-FLAG
Element: Default Flag
Alpha 1
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
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-BANK-ROLL-NO
Element: Bank Roll No
Alpha 20
Contains additional bank information needed if an employee's bank is a building society. Informational only. (UK requirement)
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-ACH-DIST-ORDER
Element: Ach Dist Order
Numeric 2
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.
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-CA-INST-NBR
Element: Ca Inst Nbr
Numeric 4
Contains the value that identifies the Canadian institution for the employees direct deposit.
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-CA-TRANSIT-NBR
Element: Ca Transit Nbr
Numeric 5
Contains the Canadian transit number for the employees direct deposit.
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-COUNTRY-CODE
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
" " = USA
CA = Canada
US = USA
UK = United Kingdom
GB = Great Britain
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
EAD-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
EAD-PENS-SEQ-NBR
Element: Pens Seq Nbr
Numeric 4
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-NON-STD-ENTRY
Element: Non Std Entry
Numeric 1

0
1 = Split
2 = NatWest
3 = Co-Op
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-ORIG-ACCT-NBR
Element: Orig Acct Nbr
Alpha 17
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-PAYABLE-TO
Element: Payable To
Alpha 38 (Lower Case)
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-PRINT-RCPT
Element: Print Rcpt
Alpha 1
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-DED-CYCLE-GRP
Element: Ded Cycle Grp
Derived
EAD-DED-CYCLE-1
Element: Ded Cycle 1
Derived
EAD-DED-CYCLE-2
Element: Ded Cycle 2
Derived
EAD-DED-CYCLE-3
Element: Ded Cycle 3
Derived
EAD-DED-CYCLE-4
Element: Ded Cycle 4
Derived
EAD-DED-CYCLE-5
Element: Ded Cycle 5
Derived
EAD-DED-CYCLE-6
Element: Ded Cycle 6
Derived
EAD-DED-CYCLE-7
Element: Ded Cycle 7
Derived
EAD-DED-CYCLE-8
Element: Ded Cycle 8
Derived
EAD-DED-CYCLE-9
Element: Ded Cycle 9
Derived
EAD-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-CREATE-USER-ID
Element: User Id
Alpha 10 (Lower Case)
Contains the user ID of the person who last changed this record.
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-USER-ID
Element: User Id
Alpha 10 (Lower Case)
Contains the user ID of the person who last changed this record.
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-OBJ-ID
Element: Obj Id
Numeric 12
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-IAT-ACH
Element: Flag
Alpha 1

N
Y
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-IN-MICR-NO
Element: Micr No
Numeric 9
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EAD-IFSC
Element: Ifs Code
Alpha 11
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1


EMACHDEPST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EADSET1 COMPANY
EMPLOYEE
ACH-DIST-NBR
...
BN66.1 HR11.1
HR170 HR70.1
HR94.1 PA115
PR12.1 PR12.3
PR12.5 PR140
PR141 PR155
PR160 PR162
PR180 PR189
PR195 PR212
PR260 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR712
PR80.1 PR80.4
EADSET10 IN-MICR-NO
COMPANY
EMPLOYEE
ACH-DIST-NBR
EADSET11 IFSC
COMPANY
EMPLOYEE
ACH-DIST-NBR
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EADSET2 COMPANY
EMPLOYEE
DEFAULT-FLAG
ACH-DIST-ORDER
ACH-DIST-NBR
KeyChange, Subset
WhereACH-DIST-ORDER !=Zeroes
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1 PRAT.1
EADSET3 COMPANY
EMPLOYEE
ACH-DIST-NBR
KeyChange, Subset
WhereACH-PRENOTIFY ="N"
PR160
EADSET4 COMPANY
EMPLOYEE
ACH-DIST-ORDER
ACH-DIST-NBR
KeyChange, Subset
WhereACH-DIST-ORDER !=Zeroes
BN66.1 PR12.1
PR12.3 PR140
PR160 PR189
PR195 PR29.1
PR36.1 PR36.4
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EADSET5 COMPANY
EMPLOYEE
ACH-DIST-NBR
KeyChange, Subset
WhereOCCURANCES !=Zeroes
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1 PRAT.1
EADSET6 COMPANY
EMPLOYEE
COUNTRY-CODE
ACH-DIST-NBR
BN66.1 PR12.1
PR12.2 PR12.3
PR140 PR160
PR189 PR195
PR29.1 PR36.1
PR36.4 PR45.1
PR512 PR529
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
PRAT.1
EADSET7 COMPANY
EMPLOYEE
PENS-SEQ-NBR
ACH-DIST-NBR
KeyChange, Subset
WherePENS-SEQ-NBR =Zeroes
PR12.1
EADSET8 COMPANY
EMPLOYEE
PENS-SEQ-NBR
ACH-DIST-NBR
KeyChange, Subset
WherePENS-SEQ-NBR !=Zeroes
BN66.1 PR140
PR189 PR195
PR229 PR29.1
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 PRAT.1
EADSET9 OBJ-ID
Subset
Where(OBJ-ID !=Zeroes)
HR94.1


EMACHDEPST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


EMACHDEPST FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Hrhistory HRHISTORY
Valid When (EAD-OBJ-ID !=Zeroes )
EAD-COMPANY->HRH-COMPANY
EAD-EMPLOYEE->HRH-EMPLOYEE
EAD-OBJ-ID->HRH-OBJ-ID
  HRH-FLD-NBR
  HRH-POS-LEVEL
  HRH-BEG-DATE
  HRH-SEQ-NBR


File created: Thu Jun 09 02:30:21 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.