Navigation: Deposit Reports > Deposit Reports - Numerical Order >
Availability
This deposit report is available to process weekly on Thursday in the afterhours. It is only to be used if you have a business arrangement made with HHC Direct.
Purpose
This report setup actually creates an ASCII file, a tape transmittal, and a report for HHC Direct. The tape is used by HHC Direct for purposes that are not known to GOLDPoint Systems. You would need to contact HHC Direct to find out the services they provide.
The report contains the following information:
•Account number
•Short name
•SSN/EIN
•Account balance
•Product code
•Alternate account
•Check amount
This report and file are sorted in account number order.
GOLDPoint Systems Only: The file is created from a tape that is converted into an ASCII format. It is retrieved by HHC Direct on the FTP site. The report can be processed by placing the word "detail" in the Misc Parm field. |
---|
Report Column Information
See FPSDR124 Example for an example of this report.
Column Heading |
Description |
---|---|
Account Number |
This is the office number (DMACTO), account number (DMACTA), and check digit (DMCKDG) for the deposit account. |
Short Name |
This is the short name of the first name on the account (MNSNM1). |
SSN/EIN # |
This is the social security or employee identification number without dashes for the first name on the account (MNSSN#1). |
Account Balance |
This is the current balance of the deposit account without a decimal taken from the current balance field (DMCRBL) on the Deposit Master Fields screen (function 1/2). |
Prod Code |
This is the product code (DMPDCD) used by this deposit account on the Deposit Master Fields screen (function 1/2). |
Alt Account |
This is the alternate account number field that represents the last account number interest dividends posted to. |
Check Amount |
This is the check amount for the last amount of interest dividends. |
Transmittal Information
See FPSDR124 Example for an example of this report.
File Information
Field ID |
Length |
Tape Position |
Description |
HHC STATUS |
001 |
001-001 |
*Account status (O=opened, C=closed) |
HHC ACCT# |
016 |
002-017 |
*Account number |
HHC OFFICE |
004 |
002-005 |
*Office |
HHC ACCOUNT |
010 |
006-015 |
*Account |
HHC CKDIGIT |
002 |
016-017 |
*Check digit |
HHC DTOPEN |
008 |
018-025 |
*Date opened (YYYYMMDD) |
HHC ACCR2DT |
008 |
026-033 |
Interest accrued to date (YYYYMMDD) |
HHC BDATE |
008 |
034-041 |
*IRS owner birth date (YYYYMMDD) |
HHC MATDATE |
008 |
042-049 |
CD maturity date (YYYYMMDD) |
HHC ACCTBAL |
012 |
050-061 |
*Account balance |
HHC ACCRINT |
012 |
062-073 |
Accrued interest |
HHC AVAILIN |
012 |
074-085 |
Available interest |
HHC CAMAMT |
012 |
086-097 |
Monthly check amount |
HHC INTRATE |
007 |
098-104 |
*Interest rate |
HHC ICALCCD |
002 |
105-106 |
Interest calculation code |
HHC PRODCDE |
004 |
107-110 |
Product code |
HHC TERM |
004 |
111-114 |
Term of account |
HHC TERMTYP |
001 |
115-115 |
Term type month (m), day (d), year (y) |
HHC ALTACCT |
022 |
116-137 |
Alternative interest account number, left justified |
HHC ROUTTRN |
009 |
138-146 |
Out house routing/transfer number |
HHC NOMAIL |
001 |
147-147 |
*No mail |
HHC INTCHK |
001 |
148-148 |
Mail dividend check, yes (y) or no (n) |
HHC MATCHK |
001 |
149-149 |
Mail check at maturity, yes (y) or no (n) |
HHC CDNOTR |
001 |
150-150 |
No CD renewal, yes (y) or no (n) |
HHC MONINT |
001 |
151-151 |
Monthly interest, yes (y) or no (n) |
HHC KEOGH |
001 |
152-152 |
KEOGH/BRP IRA account, yes (y) or no (n) |
HHC IRAACCT |
001 |
153-153 |
Contributory IRA, yes (y) or no (n) |
HHC ROLLOVR |
001 |
154-154 |
Rollover IRA account, yes (y) or no (n) |
HHC SEPP |
001 |
155-155 |
Sepp IRA account, yes (y) or no (n) |
HHC CHKAMTH |
001 |
156-156 |
Check a month, yes (y) or no (n) |
HHC TAXCD |
001 |
157-157 |
*Tax ID format code, S=SSN, E=EIN |
HHC TAXID |
009 |
158-166 |
*Tax ID |
HHC TITLECD |
003 |
167-169 |
Title code |
HHC SHORTNM |
023 |
170-192 |
*Short name |
HHC NAME1 |
045 |
193-237 |
*Name line 1 |
HHC NAME2 |
045 |
238-282 |
*Name line 2 |
HHC NAME3 |
045 |
283-327 |
*Name line 3 |
HHC STREET |
045 |
328-372 |
*Street address |
HHC CITY |
020 |
373-392 |
*City |
HHC STATECD |
002 |
393-394 |
*State code |
HHC ZIPCDE |
005 |
395-399 |
*ZIP code zero filled |
HHC ZIP4 |
004 |
400-403 |
*ZIP plus 4 zero filled |
HHC PHONE |
010 |
404-413 |
*Phone number |
HHC INDISB |
001 |
414-414 |
In periodic distribution, yes (y) or no (n) |
HHC HH# |
012 |
415-426 |
*Household number |
HHC OCOD1 |
003 |
427-429 |
*Ownership code 1 - print |
HHC OCOD2 |
003 |
430-432 |
*Ownership code 2 - print |
HHC OCOD3 |
003 |
433-435 |
*Ownership code 3 - print |
HHC CJC1 |
002 |
436-437 |
*Conjunction code, name 1 |
HHC CJC2 |
002 |
438-439 |
*Conjunction code, name 2 |
HHC CJC3 |
002 |
440-441 |
*Conjunction code, name 3 |
HHC SOURCE |
008 |
442-449 |
Deposit source of funds |
HHC TELLER |
010 |
450-459 |
Referring teller |
HHC USER2 |
014 |
460-473 |
User-defined field 2 |
HHC USER3 |
014 |
474-487 |
User-defined field 3 |
HHC ACTP |
001 |
488-488 |
*Account type (D/L) |
HHC LNTYPE |
002 |
489-490 |
+Loan type (LNTYPE) |
HHC LNPMTH |
001 |
491-491 |
+Loan payment method |
HHC DTCLSD |
008 |
492-499 |
+Date closed (CCYYMMDD) |
HHC IRSOWN |
045 |
500-544 |
*IRS owner name |
HHC EMPACC |
001 |
545-545 |
Employee Account (Y/N) |
HHC SPARE |
005 |
546-550 |
Spare |
* Both loan and deposit fields
+ Loan fields only
No mark - deposit fields only
Totals
This report only totals number of accounts.