Navigation:  Deposit Reports > Deposit Reports - Numerical Order >

Verafin Master File Report (FPSDR230)

Navigation:  Deposit Reports > Deposit Reports - Numerical Order >

Verafin Master File Report (FPSDR230)

Previous pageReturn to chapter overviewNext page  Print this Topic

Availability

This file must process daily, and your company must have a license for the Verafin® third-party interface for Bank Secrecy Act (BSA) compliance.

 

Purpose

Verafin is a product used to help financial institutions comply with BSA, OFAC, and USA Patriot Act requirements. Verafin accumulates data that is supplied from GOLDPoint Systems loan and deposit systems and performs various calculations using the data. This data can then be accessed through features of Verafin that identify risks specific to the customer. New name records in CIF are checked each day against the OFAC and other required lists, including new names added to the government lists.

 

There is no paper report created with this program, but multiple files are uploaded for your company each day. Account numbers are sent based on your company’s format. All the names on each account are sent in the files. The fields sent in this file are listed below.

 

The initial files that are created for your company are processed manually during the day. GOLDPoint Systems will send master and transaction data for the period you specify. This time frame is contingent upon how much history you store for your accounts. The default is 90 days.

 

GOLDPoint Systems Mnemonic (CIF)

GOLDPoint Systems Description

Verafin Fields

 

0 + institution number

Institution Number

DMOFCD

Account representative (deposits)

Primary Officer Code

NDAPAC

Additional phone area code

Cell Phone

NDPHAD

Address line 1–physical address

Address 1

NDPHAD

Address line 2–physical address

Address 2

NDPHAD

Address line 3–physical address

Address 3

 

Institution Employee

Employee Indicator

NDBDAT

Birth date

Birth Date

DMACTO

Branch of the account number

Branch Code

NDCTYP

Name type CIF 2nd position (0 = SSN, 1 = EIN)

TIN Type

NDCTYP

Resident foreigner

CIF 1st position = 1 or 2

Alien/Foreign Customer Flag

NDCTYP

CIF name/address type

(0 = Personal, 1 = Business)

Customer Type (Personal/Non-Personal)

NACITY

City name

City

NACTRY

Country abbreviation

Country

PDCDAT

Current run date

Last Processing Date

 

Customer number (0 - Social Security number; 1 - Employer Identification number

TIN Type

NDLIC# or NDID2#

ID number/driver's license number

Identification Number

NDLIST

ID state code/driver's license state

Identification Issuer

NDEMAD

email address

Email Address

NDEMPL

Employer

Employer

NMCONT

First contact date

Date Customer Added

NDFNAM

First name

First Name

NDHPHN

Home phone number

Home Phone

MNSEIN

Household number

Household Key

NDISEM

Is an employee?

Employee Indicator

NDISOF

Is an officer?

Employee Indicator

NDLNAM

Last name

Last Name

NDMNAM

Middle name

Middle Name

 

N/A

Exemption Amount

 

N/A

Secondary Officer Code

 

N/A

TIN Status Code

NDCTYP

Non-resident foreigner

CIF 3rd position = 2

Customers who are NRA

 

Not mandatory

Cost Center

NDOCCU

Job title/Occupation

Profession/Occupation Description

MLLSOR

Servicing officer (loans)

Primary Officer Code

NDCSSN

Social Security number

Customer Unique ID Number

NASTAB

State abbreviation

State

NDCSSN

Tax ID number

Taxpayer ID Number

Aggregate

Title, first, middle, last, suffix

Customer Name

NDWPEX

Work phone extension

Business Phone Extension

NDWPPF

Work phone prefix

Business Phone

NAZIP4

ZIP + 4

ZIP Code (4 Digit)

NAZIPC

ZIP code

ZIP Code (5 Digit)

 

Date expires

ID Expiration Date

NDLIC# or NDID2#

ID Type

1 - Driver's License (Driver's License/State ID)

2 - Passport

3 - Non-Citizen ID (Alien Registration)

4 - Credit Card (Other)

5 - Student ID (Other)

6 - Library Card (Other)

7 - Known by (Other)

255 - Other

Identification Type

A - Driver's License/State ID

B - Passport

C - Alien Registration

D - Other

 

honeycombgoldgpsonly

GOLDPoint Systems Only: Input Records should be " DM," and "MN."

 

Miscellaneous Options:

Check Option 1 to use the Master file for CIF (Account Ownership).

Check Option 2 to use the Checking file.

Check Option 3 to use the Savings file.

Check Option 4 to use the Certificate file.

Check Option 9 to pull all records, not just changed ones. This should be checked for the initial file setup. It shouldnot be checked for daily transmissions.

 

The JCL must be set up for the Verafin files to process. The deposit Verafin Transaction Files Report (FPSDR231) and the configuration for each institution must be set up on the Verafin server for in-house processing or in Tumbleweed® for offsite processing.

 

FPVERAFN is the program used to send all name and address information to the Verafin database. FPVERAFN processes with Verafin each day, sending the names and addresses changed that day. To catch up any records not previously sent, the prior run date can be changed to incorporate all the records needed by using it as the new start date.

©2021 GOLDPoint Systems. All rights reserved.