Navigation:  Deposit Reports > Deposit Reports - Numerical Order >

Marquis File Creation Program (FPSDR159)

Navigation:  Deposit Reports > Deposit Reports - Numerical Order >

Marquis File Creation Program (FPSDR159)

Previous pageReturn to chapter overviewNext page  Print this Topic

Availability

This file can only be run at monthend because it reads through all the history for the month. There are several fields that are available on this file that are not available on the other file creation programs.

 

Purpose

The purpose of this program is to create a file to be sent to Marquis. It does not create a report. This file is sent out to the BLOB (Binary Large Object File), where it can be downloaded through the FTP server. Every open deposit account will be pulled. The fields that are included in this file are the deposit (DM), CIF (MN), safe deposit box (SB), ATM/Debit card (IC), and account history (DZ) records. There is also a corresponding loan file that is created by a loan report program (FPSRP188). Listed below is the file layout with the records that will be pulled when this report program is run.

 

honeycombgoldgpsonly

GOLDPoint Systems Only: To pull the correct information for a Call Trax daily file, a separate report must be set up with the 3rd Misc Opts field set to “Y.” Only the deposit record (DM) should be used with this option. Account history (DZ) and CIF (MN) are not used with this option.

 

To set up a Marquis file report, the 16th Misc Opts field needs to be set to “Y,” so a month’s history will be read.

 

To set up a Marquis file report that prints account names #1 (position 41), 2 (position 86), and 3 (position 131) in first-, middle-, last-format, the 2nd misc opts field needs to be set to “Y.”

 

To set up a range of Jumbo CD Product codes, the 1st Misc Opts field needs to be set to “Y.” The Jumbo CD Product code start and Product code finish need to be entered in the Misc Parm fields, separated by a space. All accounts within this range will have “JCD” in the Account Type Code (B) field (position 346).

 

File Information

 

Field Description

Position

Length

Account First Name

1

20

Account Last Name

21

20

Account Name #1 (Last, First, M)*

41

45

Account Name #2 (Last, First, M)*

86

45

Account Name #3 (Last, First, M)*

131

45

Account Formal Salutation

176

4

Address Line 1

180

45

Address Line 2

225

45

ZIP Code

270

5

ZIP Code (+4)

275

4

Gender (M/F)

279

1

Phone Number

280

12

Birth Date

292

8

Age

300

3

Account Number (DMACTA)

303

16

Household Number (MNHHLD)

319

12

Social Security Number

331

11

Account Type Code

342

4

Account Type Code (B)

346

5

Business/Retail Flag (Y/N)

351

1

Open Date (MMDDYYCC)

352

8

Maturity Date (MMDDYYCC)

360

8

Date Last Tran (MMDDYYCC)

368

8

Branch Code

376

4

Officer Code

380

4

Opening Balance (DMOBAL)

384

12

Account Balance (DMCRBL)

396

12

Average Balance (DMAVBL)

408

12

Minimum Balance (DMMNBL)

420

12

Account Term

432

3

Interest Rate (DMRATE)

435

6

ATM Card Flag (Y/N) Type #02

441

1

Debit Card Type #03 or Type #04

442

1

Safe Deposit Box (Y/N)

443

1

Credit Card (Y/N) Type #05

444

1

Employee Account (Y/N)

445

1

Mail Flag (Y/N)

446

1

Service Charges YTD (DMSVYD)

447

12

Number of Checks Cleared (DMCKCY)

459

5

Number of Deposits/Month

464

5

Number of Withdrawals/Month

469

5

Email Address (CFEMAD)

474

40

Number of ATM Usages (Debits and Credits)

514

3

Foreign Items

517

3

Number of Debit Card Usages (DMMDDC)

520

3

Number of On-Us Items

523

3

City (CACITY)

526

20

State Abbreviation (CASTAT)

546

2

YTD Deposits (DMYDDP)

548

11

YTD Withdrawals

559

11

MTD Deposits (DMMDDP)

570

11

MTD Withdrawals (DMMDWD)

581

11

Online Billpayer (Y/N)

592

1

GOLDPhone Usages per Month

593

3

Online Banking Transactions per Month

596

3

Restrict GOLDPhone? (Y/N) (DMGDPH)

599

1

GOLDPhone Active? (Y/N) (DMGBNK)

600

1

Date Account Went Negative (DMDTNG)

601

8

User-defined Field Number 8

609

14

Limit to go Negative (DMNGLM)

623

12

Referring Teller Number (DMRTLR)

635

10

Restrict Internet? (Y/N) (PCGDIN)

645

1

Source of Funds (DMSFND)

646

8

Ownership Code for Name #1

654

3

Ownership Description for Name #1

657

15

**First Opt-out/Opt-in Option for Name #1

672

1

**Second Opt-out/Opt-in Option for Name #1

673

1

**Third Opt-out/Opt-in Option for Name #1

674

1

Ownership Code for Name #2

675

3

Ownership Description for Name #2

678

15

**First Opt-out/Opt-in Option for Name #2

693

1

**Second Opt-out/Opt-in Option for Name #2

694

1

**Third Opt-out/Opt-in Option for Name #2

695

1

Ownership Code for Name #3

696

3

Ownership Description for Name #3

699

15

**First Opt-out/Opt-in Option for Name #3

714

1

**Second Opt-out/Opt-in Option for Name #3

715

1

**Third Opt-out/Opt-in Option for Name #3

716

1

Advertising Code (from CIF file) (LNSADV)

717

4

Credit Score for Name #1 (LNRSK1)

721

3

Credit Score for Name #2 (LNRSK1)

724

3

Credit Score for Name #3 (LNRSK1)

727

3

GOLD HomeBanker Active? (Y/N) (DMWWWA)

730

1

**Fourth Opt-out/Opt-in Option for Name #1

731

1

**Fourth Opt-out/Opt-in Option for Name #2

732

1

**Fourth Opt-out/Opt-in Option for Name #3

733

1

**Fifth Opt-out/Opt-in Option for Name #1

734

1

**Fifth Opt-out/Opt-in Option for Name #2

735

1

**Fifth Opt-out/Opt-in Option for Name #3

736

1

Name #1 is a Business Name? (Y/N)

737

1

 

* These fields can also be printed in first-, middle-, last-format.

** If institution option OP10 OPIN is set, then a “Y” in this field indicates Opt-in. The default is Opt-out.

 

Totals and Subtotals Provided

Institution totals are provided for the total number of accounts read and the total current balance of the accounts.

©2021 GOLDPoint Systems. All rights reserved.