Navigation:  Deposit Reports > Deposit Reports - Numerical Order >

History Pre-Drop Report (FPSDR124)

Navigation:  Deposit Reports > Deposit Reports - Numerical Order >

History Pre-Drop Report (FPSDR124)

Previous pageReturn to chapter overviewNext page  Print this Topic

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.

 

honeycombgoldgpsonly

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.

©2021 GOLDPoint Systems. All rights reserved.