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 |
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 |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
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). |
|
||||||||||||||||||||
EAD-REMAIN-OCCUR Element: Remain Occur | Numeric 3 Contains the value that indicates the remaining number of times a distribution is to be taken. |
|
||||||||||||||||||||
EAD-EBANK-ID Element: Bank ID | Numeric 9 Contains the employee's bank DFI (Depository Financial Institution) identification number. |
|
||||||||||||||||||||
EAD-EBNK-ACCT-NBR Element: Account | Alpha 17 Contains the employee's bank account number where payments are deposited. |
|
||||||||||||||||||||
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 |
|
||||||||||||||||||||
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 |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
EAD-DESCRIPTION Element: Description | Alpha 30 (Lower Case) Contains the ACH distribution description. |
|
||||||||||||||||||||
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). |
|
||||||||||||||||||||
EAD-BEG-DATE Element: Begin Date | Numeric 8 (yyyymmdd) Contains the effective date deposits can be made to the entered account. |
|
||||||||||||||||||||
EAD-END-DATE Element: End Date | Numeric 8 (yyyymmdd) Contains the last date deposits can be made to the entered account. |
|
||||||||||||||||||||
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 |
|
||||||||||||||||||||
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 |
|
||||||||||||||||||||
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) |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
EAD-CA-INST-NBR Element: Ca Inst Nbr | Numeric 4 Contains the value that identifies the Canadian institution for the employees direct deposit. |
|
||||||||||||||||||||
EAD-CA-TRANSIT-NBR Element: Ca Transit Nbr | Numeric 5 Contains the Canadian transit number for the employees direct deposit. |
|
||||||||||||||||||||
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 |
|
||||||||||||||||||||
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 |
|
||||||||||||||||||||
EAD-NON-STD-ENTRY Element: Non Std Entry | Numeric 1 0 1 = Split 2 = NatWest 3 = Co-Op |
|
||||||||||||||||||||
EAD-ORIG-ACCT-NBR Element: Orig Acct Nbr | Alpha 17 |
|
||||||||||||||||||||
EAD-PAYABLE-TO Element: Payable To | Alpha 38 (Lower Case) |
|
||||||||||||||||||||
EAD-PRINT-RCPT Element: Print Rcpt | Alpha 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. |
|
||||||||||||||||||||
EAD-CREATE-TIME Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||||||||||||||||||||
EAD-CREATE-USER-ID Element: User Id | Alpha 10 (Lower Case) Contains the user ID of the person who last changed this record. |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
EAD-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||||||||||||||||||||
EAD-USER-ID Element: User Id | Alpha 10 (Lower Case) Contains the user ID of the person who last changed this record. |
|
||||||||||||||||||||
EAD-OBJ-ID Element: Obj Id | Numeric 12 |
|
||||||||||||||||||||
EAD-IAT-ACH Element: Flag | Alpha 1 N Y |
|
||||||||||||||||||||
EAD-IN-MICR-NO Element: Micr No | Numeric 9 |
|
||||||||||||||||||||
EAD-IFSC Element: Ifs Code | Alpha 11 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
EADSET1 |
COMPANY EMPLOYEE ACH-DIST-NBR |
|
| ||||||||||||||||||||||||||||||||||||
EADSET10 |
IN-MICR-NO COMPANY EMPLOYEE ACH-DIST-NBR |
|
|||||||||||||||||||||||||||||||||||||
EADSET11 |
IFSC COMPANY EMPLOYEE ACH-DIST-NBR |
|
| ||||||||||||||||||||||||||||||||||||
EADSET2 |
COMPANY EMPLOYEE DEFAULT-FLAG ACH-DIST-ORDER ACH-DIST-NBR |
|
| ||||||||||||||||||||||||||||||||||||
EADSET3 |
COMPANY EMPLOYEE ACH-DIST-NBR |
|
| ||||||||||||||||||||||||||||||||||||
EADSET4 |
COMPANY EMPLOYEE ACH-DIST-ORDER ACH-DIST-NBR |
|
| ||||||||||||||||||||||||||||||||||||
EADSET5 |
COMPANY EMPLOYEE ACH-DIST-NBR |
|
| ||||||||||||||||||||||||||||||||||||
EADSET6 |
COMPANY EMPLOYEE COUNTRY-CODE ACH-DIST-NBR |
|
| ||||||||||||||||||||||||||||||||||||
EADSET7 |
COMPANY EMPLOYEE PENS-SEQ-NBR ACH-DIST-NBR |
|
| ||||||||||||||||||||||||||||||||||||
EADSET8 |
COMPANY EMPLOYEE PENS-SEQ-NBR ACH-DIST-NBR |
|
| ||||||||||||||||||||||||||||||||||||
EADSET9 |
OBJ-ID |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Company | PRSYSTEM |
Required
| |||||||||||||||
Employee | EMPLOYEE |
Required
| |||||||||||||||
Prempbankca | PREMPBANK |
Required
| |||||||||||||||
Prempbankus | PREMPBANK |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Hrhistory | HRHISTORY |
|
All trademarks and registered trademarks are the property of their
respective owners.