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
PR141 PR155 PR162 PR180 PR260 UK141


UPDATED BY
BN66.1 PR12.1 PR12.3 PR12.5 PR12.2 PR140
PR160 PR189 PR195 PR29.1 PR36.1 PR45.1
PR512 PR529 PR560 PR582 PR80.1 PR80.4
PR82.1 PR89.1 UK560 HR11.1 HR170 HR70.1
PA115 PR212 PR712 PR229

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EAD-COMPANY
Element: Company Hr		Numeric 4
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
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.
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
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.
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
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).
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
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
PR189 PR195
PR29.1 PR36.1
PR45.1 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 UK560
EAD-EBANK-ID
Element: Bank ID		Numeric 9
Contains the employee's bank DFI (Depository Financial Institution) identification number.
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
EAD-EBNK-ACCT-NBR
Element: Account		Alpha 17
Contains the employee's bank account number where payments are deposited.
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
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
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
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 PR512
PR529 PR560
PR582 PR80.1
PR80.4 PR82.1
PR89.1 UK560
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.
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
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.
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
EAD-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
Contains the ACH distribution description.
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
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).
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
EAD-BEG-DATE
Element: Begin Date		Numeric 8 (yyyymmdd)
Contains the effective date deposits can be made to the entered account.
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
EAD-END-DATE
Element: End Date		Numeric 8 (yyyymmdd)
Contains the last date deposits can be made to the entered account.
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
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
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
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
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
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)
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
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.
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
EAD-CA-INST-NBR
Element: Ca Inst Nbr		Numeric 4
Contains the value that identifies the Canadian institution for the employees direct deposit.
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
EAD-CA-TRANSIT-NBR
Element: Ca Transit Nbr		Numeric 5
Contains the Canadian transit number for the employees direct deposit.
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
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
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
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
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
EAD-NON-STD-ENTRY
Element: Non Std Entry		Numeric 1

0
1 = Split
2 = NatWest
3 = Co-Op
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
EAD-ORIG-ACCT-NBR
Element: Orig Acct Nbr		Alpha 17
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
EAD-PAYABLE-TO
Element: Payable To		Alpha 38 (Lower Case)
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
EAD-PRINT-RCPT
Element: Print Rcpt		Alpha 1
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
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.
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
EAD-CREATE-TIME
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
EAD-CREATE-USER-ID
Element: User Id		Alpha 10 (Lower Case)
Contains the user ID of the person who last changed this record.
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
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 PR45.1
PR512 PR529
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
UK560
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 PR45.1
PR512 PR529
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
UK560
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 PR45.1
PR512 PR529
PR560 PR582
PR80.1 PR80.4
PR82.1 PR89.1
UK560


EMACHDEPST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EADSET1 COMPANY
EMPLOYEE
ACH-DIST-NBR
...
BN66.1 HR11.1
HR170 HR70.1
PA115 PR12.1
PR12.3 PR12.5
PR140 PR141
PR155 PR160
PR162 PR180
PR189 PR195
PR212 PR260
PR29.1 PR36.1
PR45.1 PR512
PR529 PR560
PR582 PR712
PR80.1 PR80.4
PR82.1 PR89.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
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
PR12.1 PR12.3
PR29.1 PR512
PR529 PR560
PR582 PR82.1
UK560
EADSET5 COMPANY
EMPLOYEE
ACH-DIST-NBR
KeyChange, Subset
WhereOCCURANCES !=Zeroes
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1
EADSET6 COMPANY
EMPLOYEE
COUNTRY-CODE
ACH-DIST-NBR
PR12.1 PR12.2
PR12.3 PR29.1
PR512 PR529
PR560 PR582
PR82.1 UK560
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 UK560


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

File created: Wed Jun 08 20:51:07 2016

Home
Contact Us



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