Core data specifications

Introduction

Green Check’s Account Monitoring feature relies on the ingestion of key data from the core system.  This data must be in a consistent, readable format as outlined below (Table 1.). The Green Check data ingestion process is capable of filtering unneeded data from reports it receives as well as mapping your source report structure to our data schema. Assuming your source report structure is consistent between uploads, this mapping will only have to be done once.

Field Definitions

All fields must be free of leading or trailing spaces, as well as any non-ASCII Characters. Exact field names are not important as data will be mapped upon upload.

 

Table 1. Core transaction import template

Field Name

Definition

Format

AcctID *

Unique identifier, e.g. account #, CIF, EIN, etc.

Required, Alphanumeric

AcctName 

Name of Account Holder

Optional, Alphanumeric

TranID

Unique id of the transaction, if applicable

Optional, Numeric

TranDateTime *

Date and time stamp of the transaction

Required, Date/Time (see Table 2.)

TranName

Internal name of the transaction, if applicable

Optional, Alphanumeric

TranDesc

Descriptive transaction details

Optional, Alphanumeric

TranCode *

Identifying code which determines transaction type

Required, Alphanumeric

TranAmt *

Dollar amount of the transactions

Required, numeric

PostDate

Date transaction was posted to the account

Optional, Date (see Table 2.)

StartBal

Beginning account balance, prior to transaction completing

Optional, numeric

EndBal

Ending account balance, after transaction clears

Optional, numeric

Acceptable Date Formats

Green Check uses the Luxon date library which supports most common date formats (Table 2.).  

Table 2. Acceptable date formats

 

      "MM/dd/yyyy hh:mm:ss:a",
"M/dd/yyyy hh:mm:ssa",
"M/dd/yyyy hh:mm:ssa",
"M/dd/yyyy hh:mm:ss a",
"MM/dd/yyyy hh:mm:ssa",
"MM/dd/yyyy hh:mm:ss a",
"M/d/yyyy h:mm:ssa",
"M/d/yyyy h:mm:ss a",
"M/d/yyyy HH:mm",
"M/dd/yyyy HH:mm",
"MM/d/yyyy HH:mm",
"MM/dd/yyyy HH:mm",
"M/d/yy HH:mm",
"M/dd/yy HH:mm",
"MM/d/yy HH:mm",
"MM/dd/yy HH:mm",
"M/d/yyyy H:mm",
"M/dd/yyyy H:mm",
"MM/d/yyyy H:mm",
"MM/dd/yyyy H:mm",
"yyyy-MM-dd hh:mm:ss a",
"yyyy-MM-dd-HH.mm.ss",
"yyyy-MM-dd-H.mm.ss",
"yyyy-MM-dd-hh.mm.ss",
"yyyy-MM-dd-h.mm.ss",
"yyyy-M-dd-HH.mm.ss",
"yyyy-M-dd-H.mm.ss",
"yyyy-M-dd-hh.mm.ss",
"yyyy-M-dd-h.mm.ss",
"yyyy-MM-d-HH.mm.ss",
"yyyy-MM-d-H.mm.ss",
"yyyy-MM-d-hh.mm.ss",
"yyyy-MM-d-h.mm.ss",
"yyyy-M-d-HH.mm.ss",
"yyyy-M-d-H.mm.ss",
"yyyy-M-d-hh.mm.ss",
"yyyy-M-d-h.mm.ss"

Additionally, any SQL format or ISO8601 format, in milliseconds, in seconds are also supported.

File Format

Files should be exported in .csv format.

File Transmission

Files are transmitted to Green Check securely via direct file upload within the application or SFTP (on a case by case basis).

Frequency

In order for Green Check’s functionality to be fully effective, core transaction data is needed on a recurring basis. The frequency of data will depend on the institution’s desired account review schedule (monthly, quarterly, annually).

Transaction Codes

Transaction codes must be provided at time of implementation to map existing transaction codes to standard transaction types so that Green Check will know how to apply the information received.

Please note: You will need to provide your transaction codes to Green Check before you are able to begin importing core transaction data.