|
|
EMPACHDIST FILE
Employee ACH Distribution
The Employee ACH Distribution file contains the employee ACH distribution
account information. When you generate a payment, the system creates a record
in the Employee Payment file record for every employee ACH account to which
pay is distributed. Employee ACH account information is stored in the Employee
ACH Account file. PR140 (Earnings and Deductions Calculation) is the primary
program that updates this file. A record is also created in this file when the
account prenotification is created by PR160 (Payment Print).
REFERENCED BY
ET530 HR170 HR70.1 PR141 PR142 PR155
PR162 PR260 PR261 PR82.1 UK141
UPDATED BY
BN66.1 PR140 PR160 PR189 PR195 PR197
PR300 PR36.1 PR45.1 PR560 PR80.1 PR85.1
PR86.1 PR89.1 UK560
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACD-COMPANY Numeric 4 BN66.1 PR140
Element: Company Hr PR160 PR189
PR195 PR560
PR80.1 PR89.1
UK560
ACD-EMPLOYEE Numeric 9 BN66.1 PR140
Element: Employee Contains the employee number. Each PR160 PR189
person employed by the company is PR195 PR560
assigned a unique number. The system PR80.1 PR89.1
uses the employee number to correlate UK560
all of the information related to that
person.
ACD-CHECK-ID Numeric 12 BN66.1 PR140
Element: Check Id Contains the payment identification PR160 PR189
number. When you create a payment PR195 PR560
record, the system moves the payment ID PR80.1 PR85.1
to this field to serve as the link PR86.1 PR89.1
between the Employee Payment file record UK560
and the Employee Pay/Hours History file
record.
ACD-ACH-DIST-NBR Numeric 2 BN66.1 PR140
Element: Ach Dist Nbr Contains the value that identifies the PR160 PR189
default distribution account. The PR195 PR560
account that serves as the default PR80.1 PR89.1
distribution account must have 100 UK560
percent distribution to allow the system
to distribute the total balance of net
pay.
ACD-DIST-AMOUNT Signed 13.2 BN66.1 PR140
Element: Dist Amount Contains the amount of pay distributed PR189 PR195
to the account. It is determined using PR560 PR80.1
the Percent of Net and the Deposit PR85.1 PR89.1
Amount fields in the Employee ACH UK560
Account file.
ACD-BANK-ACCT-NBR Alpha 17 BN66.1 PR140
Element: Bnk Acct Nbr This field is used to retrieve PR189 PR195
information about the account to which PR560 PR80.1
the amounts from this file are posted. PR89.1 UK560
ACD-PARTIAL-ACH Alpha 1 BN66.1 PR140
Element: Partial Ach Identifies whether an ACH distribution PR189 PR195
payment is part of a system check. PR560 PR80.1
Y = Yes PR89.1 UK560
N = No
ACD-ACH-BANK Alpha 1 BN66.1 PR140
Element: Ach Bank Identifies whether the bank account PR189 PR195
number for the ACH portion of the PR560 PR80.1
payment is different than from the check PR89.1 UK560
portion of the payment.
Y = Yes
N = No
ACD-CHECK-NBR Numeric 8 PR160 PR560
Element: Check Nbr Contains the check number. PR86.1 UK560
ACD-STATUS Numeric 1 BN66.1 PR140
Element: Status This field displays the status of the PR160 PR189
transaction. PR195 PR197
1 = Created PR300 PR560
2 = Open PR80.1 PR85.1
3 = Reconciled PR86.1 PR89.1
4 = Void UK560
6 = Historical
7 = Void Reversal
ACD-RECON-DATE Numeric 8 (yyyymmdd) PR197 PR560
Element: Recon Date Represents the date the transaction PR85.1 PR86.1
cleared the bank or was voided. UK560
Y = System checked has been purged
ACD-RECON-AMOUNT Signed 13.2 PR197 PR560
Element: Recon Amount Contains the employee ACH distribution. PR85.1 PR86.1
UK560
ACD-RECON-PRT-ST Numeric 1 PR560 PR85.1
Element: Recon Prt St UK560
ACD-REVERSAL-ID Numeric 12 PR560 PR85.1
Element: Reversal Id Used if the ACH record (EMPACHDIST) is UK560
from a partial payment and the
EMPACHDIST is being voided, therefore
creating PRDISTR records.
ACD-CURRENT-FLAG Alpha 1 PR160 PR197
Element: Current Flag Y = Yes PR560 PR85.1
N = No UK560
ACD-CURRENCY-CODE Alpha 5 BN66.1 PR140
Element: Currency Code This field contains the company base PR160 PR189
currency code established in Company PR195 PR560
(GL10.1 ). PR80.1 PR89.1
UK560
ACD-CURR-ND Numeric 1 BN66.1 PR140
Element: Acct Nd The number of decimals assigned to a PR160 PR189
particular account as determined by the PR195 PR560
account currency. PR80.1 PR89.1
UK560
ACD-EBANK-ID Numeric 9 BN66.1 PR140
Element: Ebank Id The value of EAD-EBANK-ID is moved PR189 PR195
to this field. PR560 PR80.1
PR89.1 UK560
ACD-EBNK-ACCT-NBR Alpha 17 BN66.1 PR140
Element: Ebnk Acct Nbr This is the employee's bank account to PR189 PR195
which the pay is distributed. The value PR560 PR80.1
of EAD-EBNK-ACCT-NBR is moved to this PR89.1 UK560
field.
ACD-ACCOUNT-TYPE Alpha 1 BN66.1 PR140
Element: Account Type The value of the EAD-ACCOUNT-TYPE is PR189 PR195
moved to this field. The type of PR560 PR80.1
account is identified on the ACH tape PR89.1 UK560
created by PR160 (Check Print) as "23"
for checking accounts and "33" for
savings accounts.
C = Checking
S = Savings
ACD-CA-INST-NBR Numeric 4 BN66.1 PR140
Element: Ca Inst Nbr PR189 PR195
PR80.1 PR89.1
ACD-CA-TRANSIT-NBR Numeric 5 BN66.1 PR140
Element: Ca Transit Nbr PR189 PR195
PR80.1 PR89.1
ACD-BANK-ROLL-NO Alpha 20 BN66.1 PR140
Element: Bank Roll No PR189 PR195
PR80.1 PR89.1
ACD-DRILL-EBANK-ID Derived
Element: Drill Ebank Id
ACD-DRILL-EBANK-AC Derived
Element: Drill Ebank Ac
ACD-DRILL-ACCT-TYP Derived
Element: Drill Acct Typ
EMPACHDIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACDSET1 COMPANY BN66.1 ET530
EMPLOYEE HR170 HR70.1
CHECK-ID PR140 PR141
ACH-DIST-NBR PR142 PR155
PR160 PR162
PR189 PR195
PR197 PR260
PR261 PR300
PR36.1 PR45.1
PR560 PR80.1
PR82.1 PR85.1
PR85.2 PR86.1
PR89.1 UK141
UK560
ACDSET2 BANK-ACCT-NBR KeyChange, Subset PR155 PR85.1
CHECK-NBR Where PARTIAL-ACH = "Y" PR85.2
COMPANY And ACH-BANK = "Y"
EMPLOYEE
ACH-DIST-NBR
CHECK-ID
ACDSET3 COMPANY Subset BN66.1 PR140
EMPLOYEE Where STATUS = 4 PR141 PR142
CHECK-ID And CURRENT-FLAG = "Y" PR189 PR195
ACH-DIST-NBR And PARTIAL-ACH = "Y" PR197 PR80.1
PR85.1 PR89.1
UK141
EMPACHDIST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
ACD-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Emp Ach Depst EMACHDEPST Required
ACD-COMPANY -> EAD-COMPANY
ACD-EMPLOYEE -> EAD-EMPLOYEE
ACD-ACH-DIST-NBR -> EAD-ACH-DIST-NBR
Employee EMPLOYEE Required
ACD-COMPANY -> EMP-COMPANY
ACD-EMPLOYEE -> EMP-EMPLOYEE
|
