Legacy Base RDFs
The Legacy Base RDFs (formerly the standard or default RDFs) are fixed-width files that contain only a subset of all possible fields for the RDFs. Galileo recommends that you instead use the new Base RDFs, which are CSV files that contain all possible fields for each RDF.
Field descriptions for the legacy base RDFs:
Customer Master RDF
The Customer Master RDF is a list of all of your primary account holders. The first Customer Master RDF that you receive contains all of your account records. The RDFs after that contain only the new records and the changed records from the previous day.
This table contains the default fields for the Customer Master RDF. All fields are strings unless otherwise specified.
- The primary key for this file is
GALILEO ACCOUNT ID+UNIQUE PROGRAM ID. - The filename format is
customermasterfile_yyyymmdd.txt.
| RDF field name | Length | Description |
|---|---|---|
RECORD TYPE | 1 | The type of record. D — Detail; H — Header; T — Trailer |
UNIQUE PROGRAM ID | 15 | Numeric. The identifier that Galileo has assigned to your program. |
ISSUED DATE | 8 | The date-time when the customer account was first changed to status: N (active). Called start_date in other contexts. |
ID | 50 | The customer's ID that was used for KYC/CIP, usually the SSN. You can see an SSN only if you are PCI compliant; otherwise, you get blank spaces. See the Customer ID Types enumeration for the possible values. |
ID TYPE | 5 | The type of identifier in the ID field, such as SSN or driver license. See the Customer ID Types enumeration or the Lookup file for the possible values. |
PRIMARY CARDHOLDER'S FIRST NAME | 20 | The customer's first name |
PRIMARY CARDHOLDER'S LAST NAME | 20 | The customer's last name |
ADDRESS LINE 1 | 40 | The first line of the customer's primary address |
ADDRESS LINE 2 | 40 | The second line of the customer's primary address, if any. |
CITY | 20 | The city of the customer's primary address |
STATE | 2 | The state or province of the customer's primary address |
ZIP CODE | 9 | The postal code of the customer's primary address |
PRIMARY PHONE NUMBER | 10 | The phone number that the customer gave as their primary number. |
SECONDARY PHONE NUMBER | 10 | The phone number that the customer gave as their secondary number, if any |
STATUS | 5 | The status of the account. |
CURRENT BALANCE | 13 | The balance of the account as of 23:59:59 on the previous day. This is the ledger balance, which is the total of all posted transactions. Pending transactions such as authorization holds are not subtracted out. This field is blank if there have been no transactions since account creation. |
CURRENT BALANCE SIGN | 1 | A + or - sign to indicate whether the account balance is positive or negative. |
CREATED DATE | 8 | The date-time when a customer first applied for an account, regardless of whether the application is approved or denied. Called application_date in other contexts. |
NEGATIVE BALANCE DATE | 8 | Date on which the available balance was driven negative. |
NEGATIVE BALANCE FEE AMOUNT | 13 | Fee assessed to an account that was driven negative. |
RELOADABLE INDICATOR | 1 | Numeric. Boolean (0 or 1) to indicate whether the card is reloadable. 1 means reloadable. |
GALILEO ACCOUNT ID | 30 | Numeric. The balance ID, which is different from the account ID (PRN). It is possible for two or more accounts to share the same balance ID. |
TYPE OF ACCOUNT | 5 | The name given to the product, such as "Mastercard Debit" or "Visa Instant Issue." |
AVAILABLE BALANCE | 13 | The available balance as of 23:59:59 on the previous day. This is the CURRENT BALANCE minus pending transactions such as authorization holds. This field is blank if there have been no transactions since account creation. |
AVAILABLE BALANCE SIGN | 1 | A + or - sign to indicate whether the available balance is positive or negative. |
EXTERNAL ACCOUNT NUMBER | 30 | An identifier that you provide for your own tracking purposes. You pass this value in the externalAccountId parameter of the Create Account or Update Account endpoint. |
LAST TRANS DATE | 8 | The date of the last posted transaction on this account as of 23:59:59 on the previous day, including payments, settlements, adjustments, and fees. This value does not include unsettled authorizations or pending transactions. |
DATE OF BIRTH | 8 | Account holder date of birth, encrypted. Decrypted only for PCI-compliant clients. |
BILL CYCLE DAY | 2 | Numeric. Day of the month for the billing cycle. |
LOCATION ID | 20 | Location at which the account was created, if applicable. Value can be provided by you or by Galileo. |
AGENT USER ID | 2 | ID of the agent who created the account. |
ID 2 | 50 | Secondary identity number, if provided, such as driver license or SSN. See the Customer ID Types enumeration for the possible values. |
ID TYPE 2 | 5 | The type of identifier in the ID 2 field, such as SSN or driver license. See the Customer ID Types enumeration or the Lookup file for the possible values. |
PRN | 12 | The payment reference number, a unique Galileo-generated identifier for an account. |
Account Card RDF
The Account Card RDF is a list of all cards that you have issued. The first Account Card RDF that you receive contains all of your card records. The RDFs after that contain only the new records and the changed records from the previous day.
Note
Any changes to a card record, including resetting the PIN fail count by a backend process, results in the card record being included in the differential file. Some of these changes are not reflected in the data in the RDF.
This table contains the default fields for the Account Card RDF. All fields are strings unless otherwise specified.
- The primary key for this file is
UNIQUE PROGRAM ID+CARD ID. - The filename format is
accountcard_yyyymmdd.txt.
| RDF field name | Length | Description |
|---|---|---|
RECORD TYPE | 1 | The type of record. D — Detail; H — Header; T — Trailer |
UNIQUE PROGRAM ID | 15 | Numeric. The identifier that Galileo has assigned to your program. |
GROUP ID | 15 | Source or affiliate ID. Usually the same as LOCATION ID in the Customer Master RDF. |
PRODUCT ID | 15 | Numeric. The code that is assigned to the product the card belongs to. |
GALILEO ACCOUNT ID | 30 | Numeric. The balance ID, which is different from the account ID (PRN). It is possible for multiple accounts to share the same balance ID. |
PRN | 12 | The payment reference number, a Galileo-generated ID for the card's account. |
EXPIRATION DATE | 8 | The card's expiration date. If you are not PCI compliant you will receive empty spaces for this value. |
CARD STATUS | 5 | The card status, such as N (active), S (stolen) or C (canceled) |
CARD IDENTIFIER | 30 | Numeric. Sometimes called the CAD, this identifier is given to each unique card that is issued to an account. There is a one-to-one relationship between a card ID and a PAN. If you are not PCI compliant, you can use this identifier instead of the PAN. |
CARD NUMBER | 16 | The card's PAN. If you are not PCI compliant you will get empty spaces for this value. |
TYPE OF CARD | 10 | The branded network to which the card belongs, such as Mastercard or Visa, as well as the type of card, such as personalized or instant issue. |
Authorized Transactions RDF
The Authorized Transactions RDF contains transactions that passed through the authorization stream during the previous day. These transactions include authorization requests, AVS-only checks, reversal advices and completion advices. This RDF does not always include these authorization events:
- Mastercard Banknet merchant credits (adjustments)
- Visa Money Transfer and ReadyLink card loads (payments)
Only a subset of the transactions in this RDF will also be included in a Posted Transactions RDF. For example, authorization reversals, AVS-only checks, and denied transactions are not in the Posted Transactions RDF because they do not settle.
Note
By default, denied transactions are included with the Authorized Transactions RDF. As desired, you can ask Galileo to omit denied transactions from the file.
Foreign authorizations
When a transaction takes place in a country that is foreign relative to the account's country, the AUTHORIZATION AMOUNT is in the currency of the account. For example, if an account is located in the United States and the cardholder makes a purchase in Canada, the AUTHORIZATION AMOUNT is in U.S. dollars and the TRANSACTION CURRENCY CODE is 124 (Canadian dollar). The currency conversion is performed by the card network, and it reflects the conversion rate at the time of the authorization.
Keep in mind that some online merchants conduct business in the currency of the customer instead of the location of the merchant, depending on where the customer is located. For example, a website that is based in the U.K. could have a U.S. version of its website, and so transactions on that version would be conducted in U.S. dollars.
For examples of foreign transactions see International transaction in Card Transaction Examples and these scenarios:
Authorized Transactions RDF fields
This table contains the default fields for the Authorized Transactions RDF. The primary key for this file is UNIQUE PROGRAM ID + AUTHORIZATION CODE + NETWORK CODE.
- The filename format is
authorizedtransactions_yyyymmdd.txt. - The Source column indicates where the value came from: Galileo-provided or a data element (DE) in the ISO 8583 message from the network. The actual DE number for a field may vary by network, and not all DEs are present for all networks.
- All fields are strings unless otherwise specified.
| RDF field name | Source | Length | Description |
|---|---|---|---|
RECORD TYPE | Galileo | 1 | The type of record. D — Detail; H — Header; T — Trailer |
UNIQUE PROGRAM ID | Galileo | 15 | Numeric. The identifier that Galileo has assigned to your program. |
GALILEO ACCOUNT ID | Galileo | 30 | Numeric. The balance ID, which is different from the account ID (PRN). It is possible for two or more accounts to share the same balance ID. |
CARD IDENTIFIER | Galileo | 30 | Numeric. Sometimes called the CAD, this identifier is given to each unique card that is issued to an account. If you are not PCI compliant, you can use this identifier instead of the PAN. |
TRANSACTION DATE/TIME | Galileo | 17 | The time that Galileo responded to the authorization request. MMDDYYYY HH24:MM:SS |
TRANSACTION CURRENCY CODE | DE049 | 3 | The currency code at the point of sale. |
ADDRESS VERIFICATION RESPONSE | Galileo | 1 | The single-character result of the AVS check that Galileo passed to the network. See AVS Codes for valid values. |
AUTHORIZATION RESPONSE | DE039 | 2 | The response code that you or Galileo returned to the network. See the Authorization Response Codes enumeration for possible values. |
TRANSACTION AMOUNT | DE004 times the conversion rate in DE009 | 13 | The amount that you or Galileo authorized for the transaction. This amount may be different from the amount of the authorization request in the case of a partial authorization. If AUTHORIZATION RESPONSE is 10 or 87, the amount is a partial authorization. This amount is in the currency of the account. |
AUTHORIZATION AMOUNT SIGN | Galileo | 1 | A + or - sign to indicate whether the amount is to be debited (-) or credited (+) to the cardholder account. |
AUTHORIZATION CODE | Galileo | 10 | Numeric. A Galileo-generated identifier (auth_id). See Transaction IDs for information about unique identifiers and ID collisions. |
NETWORK CODE | Galileo | 1 | A single-letter identifier to specify the subnetwork over which the authorization request arrived. See Network Codes for possible values. |
MERCHANT NUMBER | DE042 | 30 | An identifier that each network assigns to a merchant location. |
MERCHANT DESCRIPTION | DE043 | 50 | Descriptive text provided by the merchant to identify the merchant name and location and sometimes the transaction type. |
MERCHANT CATEGORY CODE | DE018 | 4 | The ISO 18245 four-digit identifier that specifies the type of merchant, such as ATM, gas pump, bookseller, airline, hotel, and so on. |
TRANSACTION CODE_ | Galileo | 15 | A numeric value that corresponds to the type of transaction that is being attempted. |
MERCHANT COUNTRY CODE | DE049 | 5 | The ISO 3166-1 three-digit code for the country where the merchant is officially located. |
PRN | Galileo | 12 | The payment reference number, a unique Galileo-generated identifier for an account. |
* The TRANSACTION CODE field in the Authorized Transactions RDF does not correspond to the TRANSACTION CODE/TYPE field in the Posted Transactions RDF. The data in the TRANSACTION CODE is unique to the Authorized Transactions RDF. See the Authorization types table in the Transactions Types enumeration for the values or consult the Lookup file for the RDFs.
Posted Transactions RDF
The Posted Transactions RDF contains every transaction that has posted to a customer account during a 24-hour period: settlements, payments, adjustments and fees. To match a settlement with its corresponding authorization, use the AUTHORIZATION CODE or SOURCE ID (which are identical for card transactions).
These types of transactions do not have corresponding entries in the Authorized Transactions RDF:
- Adjustments
- Most payments, except for Mastercard and Maestro loads (
PMML,PMMX) - Visa, Green Dot, and MoneyGram card loads
- Account transfers
- Mastercard Banknet merchant credits
- Most fees.
- The authorization request amount from an ATM includes all fees.
- ATM fees that you assess are broken out separately in the Posted Transactions RDF. The
ORIGINAL AUTH CODEfor the fee contains theAUTHORIZATION CODEof the original ATM authorization.
- ACH transactions
- Direct deposit
- Bill pay
- Chargebacks, second presentments, provisional credit, and arbitration
- Charge offs
- Force-posted settlements
- Roundups
Post time for completions
The timestamp for a posted transaction usually corresponds to the time Galileo posts the transaction to the cardholder account. However, in the case of completions (transaction type C), the completion time in the Posted Transactions RDF is the time of the completion, whereas the amount is settled later, after Galileo receives the batch settlement file.
For example, a cardholder gets a preauthorization at a gas pump for 75.00 at 09:00:01 and Galileo places a 75.00 hold on the account. The completion for 35.00 arrives through the authorization stream at 09:04:30. Galileo backs out the 75.00 and places a 35.00 hold on the account. The timestamp for the completion in the Authorized Transactions RDF and the Posted Transactions RDF is 09:04:30, but the actual settlement will be a day or so later. This later settlement is visible in the CST and Program API responses but not in the Posted Transactions RDF.
For an example of a completion at a gas pump see Five-step sequence in Card Transaction Examples and Scenario 2: Preauthorization with Completion.
Foreign settlements
When a foreign transaction is settled, TRANSACTION AMOUNT is in the currency of the account rather than the currency of the merchant. The currency conversion is performed by the card network, and it reflects the conversion rate at the time the transaction cleared, which may be a different rate than when the transaction was authorized.
See Foreign authorizations for more information.
Posted Transactions RDF fields
This table contains the default fields for the Posted Transactions RDF.
- The primary key for this file is
UNIQUE PROGRAM ID+AUTHORIZATION CODE+TRANSACTION CODE/TYPE. - The filename format is
postedtransactions_yyyymmdd.txt. - The Source column indicates where the value came from: Galileo-provided or a data element (DE) in the ISO 8583 message from the network. The actual DE number for a field may vary by network, and not all DEs are present for all networks.
- All fields are strings unless otherwise specified.
| RDF field name | Source | Length | Description |
|---|---|---|---|
RECORD TYPE | Galileo | 1 | The type of record. D — Detail; H — Header; T — Trailer |
UNIQUE PROGRAM ID | Galileo | 15 | Numeric. The identifier that Galileo has assigned your program. |
GALILEO ACCOUNT ID | Galileo | 30 | Numeric. The balance ID, which is different from the account ID (PRN). It is possible for two or more accounts to share the same balance ID. |
CARD IDENTIFIER | Galileo | 30 | Numeric. Sometimes called the CAD, this identifier is given to each unique card that is issued to an account. If you are not PCI compliant, you can use this identifier instead of the PAN. |
TRANSACTION DATE/TIME | Galileo | 17 | The time that Galileo responds to the authorization request. MMDDYYYY HH24:MM:SS |
TRANSACTION CODE/TYPE | Galileo | 10 | The concatenation of the activity type (act_type) and the transaction type (otype). For an explanation of transaction codes see Classifying transactions in the About Transactions guide. |
TRANSACTION AMOUNT | Galileo | 13 | The amount that was posted to the account. In the case of a settlement, the amount may be different from its corresponding authorization amount. This amount is in the currency of the account. |
TRANSACTION AMOUNT SIGN | Galileo | 1 | A + or - sign to indicate whether the amount was debited (-) or credited (+) to the cardholder account. |
TRANSACTION CURRENCY CODE | DE049 | 3 | The currency code at the point of sale, in the case of card transactions. |
AUTHORIZATION CODE | Galileo | 10 | Numeric. A Galileo-generated identifier (auth_id). See Transaction IDs for information about unique identifiers and ID collisions. |
POST DATE | Galileo | 8 | The date when Galileo posted the transaction to the customer account. MMDDYYYY |
NETWORK CODE | Galileo | 1 | A single-letter identifier to specify the subnetwork over which the authorization request arrived. This field is populated only for card transactions. See Network Codes for possible values. |
MERCHANT NUMBER | DE042 | 30 | An identifier that each network assigns to a merchant location. This field is populated only for card transactions. |
MERCHANT DESCRIPTION | DE043 | 50 | Descriptive text provided by the merchant to identify the merchant name and location and sometimes the transaction type. This field is populated only for card transactions. |
MERCHANT CATEGORY CODE | DE018 | 4 | The ISO 18245 four-digit identifier that specifies the type of merchant, such as ATM, gas pump, bookseller, airline, hotel, and so on. This field is populated only for card transactions. |
MERCHANT COUNTRY CODE | DE049 | 5 | The ISO 3166-1 three-digit code for the country where the merchant is officially located. This field is populated only for card transactions. |
INTERCHANGE FEE AMOUNT | Galileo | 9 | The amount of interchange or fee associated with this transaction. ATM fees and interchange reversals are negative; interchange earned is positive. This field is populated only for card transactions. |
EXTERNAL TRANSACTION ID | varies | 20 | For network transactions, the authorization identification response in DE038, which is a numeric code that Galileo returns to a merchant to verify that the transaction was authorized. This number is often printed on customer receipts. For other transactions initiated by the Program API, this is the transactionId of the API request. This field may be populated in other ways according to your setup and the transaction type. |
USER DATA | varies | 20 | Custom data field. Contact Galileo to populate this field. |
USER DATA | varies | 20 | Custom data field. Contact Galileo to populate this field. |
PRN | Galileo | 12 | The payment reference number, a unique Galileo-generated identifier for an account. |
Lookup file
Use the Lookup file to interpret the codes in some of the RDF fields. The Lookup file for a particular day contains only those values that are included with the other RDFs on that day, so this file will include some values on one day that it does not include on other days.
The DESCRIPTION field contains a short description rather than a long description, because the specific meaning for some fields is different for each Galileo client according to their setup.
The primary key for this table is FILE TYPE + FIELD NAME + CODE. There is no foreign key to link this file to the other RDFs. All fields are strings.
| Field | Length | Description |
|---|---|---|
RECORD TYPE | 1 | The type of record. D — Detail; H — Header; T — Trailer |
FILE TYPE | 1 | The RDF that contains the field: A (Authorized Transactions), C (Customer Master), D (Account Card), or P (Posted Transactions) |
FIELD NAME | 30 | Name of the field in the RDF |
CODE | 10 | Possible values for the field |
DESCRIPTION | 50 | Description of the CODE value |