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


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

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
ZH502 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
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: Thu Jun 09 11:27:00 2016

Home
Contact Us



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