CDF Reference

Custom data files (CDFs) are made available through the same method as RDFs. In general, CDFs are available a few hours after the RDFs. CDF data sets are securely delivered via SFTP in CSV format.

This document contains details about each of the standard RDFs, including field descriptions:

Expired Auth CDF

The Expired Auth CDF provides the expired authorizations for the prior day.

This table contains default fields for the Expired Auth CDF. The primary key for this file is Program ID + Transaction ID + Network Code.

📘

Note

The Expired Auth CDF contains data from these networks only: Mastercard debit, Mastercard credit, Visa, STAR.

CDF field nameLengthDescription
Account NumberNUMBERGalileo account ID, balance ID
Card IDNUMBERCard identifier
PRNCHAR (12)Payment reference number
Program IDNUMBERProgram ID
ProductNUMBERProduct ID
Transaction IDNUMBERAuthorization ID, ‘auth_id’
Authorization TSDATEDatetime timestamp of when the transaction was authorized
Expired TSDATEDatetime when the authorization expired
AmountNUMBERAuthorization amount
Trans Currency CodeCHAR (3)Currency code for auth_amt
Merchant NumberCHAR (15)Merchant ID
Merchant DescriptionCHAR (40)Merchant description
Network CodeCHAR (1)Network code
Retrieval Reference NumberVARCHAR (12)Retrieval reference number

Early ACH CDF

The Early ACH CDF provides the ACH details along with the number of days of early posting.

This table contains standard fields for the Early ACH CDF. The primary key for this file is Transaction ID.

CDF field nameLengthDescription
Transaction IDVARCHAR2 (2)Maps as identifier for the source of load/payment or source of the adjustment
Transaction TypeCHAR (6)Concatenation of activity type (act_type) and transaction type (otype)
Source IDNUMBER (18)For PMxx transaction types, this field contains the payment ID (pmt_id), and for 'ADxx' transaction types, this field contains the adjustment ID (adj_id)
External Transaction IDVARCHAR2 (60)ACH transaction ID provided by client or partner
Transaction TimeDATETransaction time of the ACH record
Authorization CodeNUMBERUnique identifier for the transaction
Number of Days EarlyNUMBERThe number of days early the ACH transaction is
Posted EarlyCHAR (1)Flag for early ACH ('Y' for early ACH)
Effective DateDATEACH effective date (when the Nacha file says it would have posted without early ACH)
Settlement DateDATEThe date the transaction was settled/posted
Receive DateDATEACH file date (the date the Nacha file was received)
Load DateDATEACH load date (the date the ACH transaction was loaded to a Nacha file)
AmountNUMBERAmount of the ACH transaction
PRNCHAR (12)Payment reference number
Trace NumberNUMBERACH trace number as received by Galileo

ACH Returns CDF

The ACH Returns CDF provides details on returned ACH for the prior day.

This table contains default fields for the ACH Returns CDF. The primary key for this file is TransID.

CDF field nameLengthDescription
NameVARCHAR2 (80)Name
SourceNameVARCHAR (30)Source institution name
AmountNUMBERAmount of the ACH transaction
DebCredIndicatorCHAR (1)Debit/credit indicator. D = debit; C = credit
ReceivedDateDATEDate that Galileo received the returned transaction
EffectiveDateDATEDate when the ACH transaction was to take effect (without early ACH)
ReturnDateDATEDate the transaction was returned
ReturnReasonCodeCHAR (3)Return reason code
ReturnReasonDescriptionVARCHAR2 (255)Return reason description
TransIDCHAR (2)Transaction ID
XIDNUMBERInternal Galileo account ID

Incoming ACH CDF

The Incoming ACH CDF provides all incoming ACH for the prior day.

This table contains default fields for the Incoming ACH CDF. The primary key for this file is Authorization Code + Transaction Type.

CDF field nameLengthDescription
Company NameVARCHAR2 (20)Company name
Company IDNUMBERCompany ID
Company DescriptionVARCHAR2 (15)Company description
Individual NameVARCHAR2 (80)Individual name
Individual IDNUMBERIndividual ID
Authorization CodeNUMBERAuthorization code
Transaction TypeVARCHAR2 (2)Transaction type
AmountNUMBERAmount
Trace NumberNUMBERTrace number
PRNCHAR (12)Payment reference number

Overdraft CDF

The Overdraft (OD) CDF provides information related to overdraft DDA accounts for prior days.

This table contains default fields for the OD CDF. The primary key for this file is GPR_XID.

CDF field nameLengthDescription
ODProgramIDNUMBERCompany name
ODAccountIDNUMBER (18)Galileo account ID, balance ID
GPRAccountIDNUMBERGPR Galileo account ID
ODAccountStatusVARCHAR2 (2)Overdraft account status
ODEligibilityStatusVARCHAR2 (2)Overdraft eligibility status
ODOpt-InDateDATEOverdraft opt-in date
ODOpt-OutDateDATEOverdraft opt-out date
ODTotalBalanceNUMBERTotal overdraft balance
ODLimitNUMBEROverdraft limit
GPR_XIDNUMBER (13)Unique account identifier within a program

Settlement CDF

The Settlement CDF provides a BIN settlement summary report (similar to gAnalytics).

This table contains default fields for the Settlement CDF. The primary key for this file is Basebin + Date + Network.

📘

Note

This report looks back one day for Visa, Mastercard, and Discover; two days for Pulse, Allpoint and STAR; and three days for Maestro/Cirrus. In comparison, the gAnalytics report looks back one day for all.

CDF field nameLengthDescription
BasebinCHAR (8)Base BIN
DateDATEDate
NetworkVARCHAR2 (255)Card network
LoadNUMBERLoad amount
Load ReversalNUMBERLoad reversal amount
Cash DisbNUMBERCash disbursement amount
Cash Disb FeeNUMBERCash disbursement fee amount
Retail SalesNUMBERRetail sales amount
CreditsNUMBERCredits amount
Unique TransNUMBERUnique transaction amount
ATM DisbNUMBERATM disbursement amount
ATM Disb FeeNUMBERATM disbursement fee amount
Interchange FeeNUMBERInterchange fee amount
Special TransNUMBERSpecial transaction amount
Misc TransNUMBERMiscellaneous transaction amount
ChargebacksNUMBERChargebacks amount
Sec PresentNUMBERSecond presentments amount
ArbitrationNUMBERArbitration amount
Switch FeeNUMBERSwitch fee amount
Net SettleNUMBERNet settlement amount
Net TransNUMBERNet transaction amount
Settle TotalNUMBERSettlement total amount
Net Interchange FeeNUMBERNetwork interchange fee amount

MC SAFE Report CDF

The MC SAFE Report CDF provides a BIN settlement summary report (similar to gAnalytics).

This table contains default fields for the MC Safe Report CDF. The primary key for this file is ARN.

CDF field nameLengthDescription
RECORD_TYPECHAR (3)Record type
ISSUER_CUSTOMER_NUMBERCHAR (6)Issuer customer number
AUDIT_CONTROL_NUMBERNUMBERAudit control number
ACQ_IDCHAR (11)Acquirer ID
ARNCHAR (23)Acquirer reference number
FRAUD_POSTED_DTDATEFraud posted date
ENPVARCHAR2 (53)Encrypted PAN
TRANS_DATEVARCHAR2 (8)Date when the transaction was authorized
TRANS_AMTVARCHAR2 (10)Amount of the authorization
TRANS_CRNCY_CDNUMBERCurrency code for TRANS_AMT
TRANS_AMT_CH_BILL_CRNCYVARCHAR2 (9)Billing amount of the transaction
CH_BILL_CRNCY_CDCHAR (3)Currency code for TRANS_AMT_CH_BILL_CRNCY
CARD_PROD_CODECHAR (3)Card product code
MERCHANT_NAMEVARCHAR2 (22)Name of the merchant from DE043
MERCHANT_IDVARCHAR2 (15)Merchant ID from DE042
MERCHANT_CITYVARCHAR2 (50)Merchant city from DE043
MERCHANT_STATE_CDVARCHAR2 (3)Merchant state or province, two-character abbreviation
MERCHANT_COUNTRYVARCHAR2 (3)ISO 3166-1 three-digit merchant country code
MERCHANT_POSTAL_CODEVARCHAR2 (5)Merchant postal code from DE043
MCCNUMBERMerchant category code
POS_TERM_ATTD_INDVARCHAR2 (1)
POS_CARD_PRES_INDVARCHAR2 (1)Point-of-sale card-present indicator
CAT_LEVEL_INDVARCHAR2 (1)Category level indicator
POS_CDTIC_INDVARCHAR2 (1)
ELEC_COM_INDCHAR (1)E-commerce indicator (3-D Secure)
POS_ENTRY_MODEVARCHAR2 (1)Point-of-sale entry mode, first two characters of DE022
TERMINAL_IDVARCHAR2 (8)ID for the card-reading device
FRAUD_TYPE_CODEVARCHAR2 (8)Fraud type
SUB_FRAUD_TYPE_CODECHAR (1)Sub-fraud type code
CHARGEBACK_INDNUMBERWhether the transaction has been charged back
SETTLE_DATEVARCHAR2 (8)Date when the transaction was settled
AUTH_RESP_CDCHAR (2)Response code for the authorization request
PROC_DATEVARCHAR2 (8)
CVC_INDVARCHAR2 (1)CVC indicator
ACCT_DEVICE_TYPECHAR (1)Account device type
SECURE_CDCHAR (1)Secure code
AVS_RESP_CDCHAR (1)Address verification service response code
CARD_PRESENT_INDNUMBERCard-present indicator
TERM_OPER_CDCHAR (1)

Fleet Data CDF

The Fleet Data CDF contains the fleet data for the posted transactions for a given program/client. See Fleet Cards for more information.

This table contains default fields for the Fleet Data CDF. The primary key for this file is auth_code + network_code.

CDF Field NameLengthDescription
prog_idNUMBERProgram ID
bal_idNUMBERBalance ID
cadNUMBERCard ID
trans_tsDATETransaction timestamp
trans_typeCHAR (6)Transaction type
auth_codeNUMBERAuthorization code
post_tsDATEPosted timestamp
network_codeVARCHAR2 (1)Network code
pmt_ref_noCHAR (12)Payment reference number
prod_idNUMBER (18)Product ID
card_acceptor_typeCHAR (8)Card acceptor type
card_acceptor_tax_idVARCHAR2 (21)Card acceptor tax ID
oil_company_brand_nameCHAR (4)Oil company brand name
purchase_timeCHAR (4)Purchase time
motor_fuel_service_typeCHAR (1)Motor fuel service type
product_codeVARCHAR2 (15)Product code
item_descriptionVARCHAR2 (35)Item description
item_quantityCHAR (13)Item quantity
item_unit_of_measureVARCHAR2 (12)Item unit of measure
extended_item_amountVARCHAR2 (14)Extended item amount
debit_or_credit_indicatorCHAR (1)Debit or credit indicator
motor_fuel_informationVARCHAR2 (35)Motor fuel information
odometer_readingVARCHAR2 (7)Odometer reading
vehicle_numberVARCHAR2 (17)Vehicle number
id_numberVARCHAR2 (17)ID number
product_type_codeCHAR (1)Product type code
motor_fuel_product_codeVARCHAR2 (35)Motor fuel product code
motor_fuel_unit_of_measureVARCHAR2 (35)Motor fuel unit of measure
motor_fuel_quantityVARCHAR2 (35)Motor fuel quantity

Chargeback and Dispute CDF

The Chargeback and Dispute CDF provides chargeback and dispute information for the prior day. It is similar to the Dispute Tracker Log report in gAnalytics.

This table contains default fields for the Chargeback and Dispute CDF. The primary key for this file is DISPUTE_ID.

CDF field nameLengthDescription
PROG_IDVARCHAR2 (250)Program ID
PROGRAMVARCHAR2 (250)Program name
AGENTVARCHAR2 (250)Dispute agent name
DISPUTE_CASEVARCHAR2 (250)Case number for all disputes files
SYSTEM_CASE_NOVARCHAR2 (250)Not used
DISPUTE_IDVARCHAR2 (250)ID assigned to each disputed transaction
BAL_IDVARCHAR2 (250)Galileo ID or balance ID
XIDVARCHAR2 (250)Internal Galileo account ID
BASE_BINVARCHAR2 (250)Base BIN (6-8 digits)
CH_NOTICE_DATEVARCHAR2 (250)Cardholder notification date
LTR_DATEVARCHAR2 (250)Date when the written confirmation letter was received
DATE_LOGGEDVARCHAR2 (250)Date when the dispute was logged in the system
WRITTEN_CONFIRMATION_REQUESTVARCHAR2 (250)Date when the written confirmation was requested
LOST_STOLENVARCHAR2 (250)Whether the dispute is for a card after it was lost or stolen
CH_DISCOVERY_DTVARCHAR2 (250)Date when the cardholder noticed the erroneous transaction
ERROR_DESCRIPTIONNVARCHAR2 (250)Description of dispute reason (selected from drop-down)
TRANSACTION_TYPEVARCHAR2 (250)Transaction type from drop-down menu: NEW (account <30 days from first load) FOR (foreign-initiated), ATM, POS, OTH (other)
FOLLOWUP_DATEVARCHAR2 (250)Follow-up date
reg_eVARCHAR2 (250)Whether the dispute falls under Regulation E
REGE_RESOLUTIONVARCHAR2 (250)Date when the Regulation E dispute should be resolved: 45 or 90 days
MERCHANT_NAMEVARCHAR2 (250)Merchant where the transaction took place
SETTLE_DATEVARCHAR2 (250)Date on which the disputed transaction settled
DISPUTE_AMOUNTVARCHAR2 (250)Amount disputed
PC_DATEVARCHAR2 (250)Date when provisional credit was issued
PC_AMTVARCHAR2 (250)Amount of provisional credit issued
PC_LETTER_DATEVARCHAR2 (250)Date when a provisional credit letter was sent
PC_REVERSAL_DATEVARCHAR2 (250)Date when a provisional credit was reversed
CH_LIABILITY_AMTVARCHAR2 (250)Amount for which the cardholder is liable
RESOLUTIONVARCHAR2 (250)How the dispute was resolved
DATE_COMPLETEVARCHAR2 (250)Date the dispute was resolved
CURRENT_STATUSVARCHAR2 (250)Current status of the dispute
MCCVARCHAR2 (250)Merchant category code for the transaction under dispute
CB_DATEVARCHAR2 (250)Chargeback date
CB_AMTVARCHAR2 (250)Chargeback amount
CB_REASON_CODEVARCHAR2 (250)Chargeback reason code
SEC_PRESENTMENT_DATEVARCHAR2 (250)Date of the second presentment
PRE_ARB_DATEVARCHAR2 (250)Arbitration chargeback date
ENDING_STATUSVARCHAR2 (250)Final status of dispute
FINAL_STATUS_DATEVARCHAR2 (250)Date when ENDING_STATUS was input
CRED_RESOLUTIONVARCHAR2 (250)Date when provisional credit was finalized
AUTH_DATEVARCHAR2 (250)Date when disputed transaction was authorized
AUTHORIZATION_CODEVARCHAR2 (250)Authorization ID (auth_id) of the disputed transaction
SETTLE_DTL_IDVARCHAR2 (250)Settlement detail ID
ASSOCIATIONVARCHAR2 (250)Association
PRNVARCHAR2 (250)Payment reference number

Direct Deposit Switch CDF

The Direct Deposit Switch CDF provides data on direct deposit switch transactions.

This table contains default fields for the Direct Deposit Switch CDF. The primary key for this file is galileo_guid.

CDF field nameLengthDescription
prod_idNUMBER(10,0)Product ID
xidNUMBER(12,0)Internal Galileo account ID
ddswitch_idVARCHAR(32)Sequence number that is the primary key in the backend database
galileo_guidVARCHAR(32)Unique ID for the direct deposit switch transaction
galileo_timestampTIMESTAMPTransaction timestamp in UTC of when the transaction was completed in ISO 8601 format
event_statusVARCHAR(30)Final status of the direct deposit switch transaction: COMPLETED or FAILURE. Incomplete transactions are not included.
distribution_typeVARCHAR(10)Type of distribution in distribution_amount: Fixed, Percentage, Total
distribution_amountNUMBER(20,2)Amount of the deposit.
event_status_reasonVARCHAR(50)The reason for the status when event_status: FAILURE. See Direct Deposit Switch Failure Status Reasons for valid values.
vendor_selectionVARCHAR(10)Direct deposit switch vendor: Atomic or Pinwheel