Mini Ultra Data Dictionary

Field	Data Type	Description
PROGRAM_ID	Program ID	The unique ID Facteus generates to identify the underlying source for the data partner. The mapping is not provided to data buyers, but it allows them to group transaction based on source.
ACCOUNT_ID	Account ID	The unique ID Facteus generates and assigns to the account, using a one-way hashing algorithm.
CARD_ID	Card ID	The unique ID Facteus generates and assigns to the card, using a one-way hashing algorithm.
TRANSACTION_ID	Transaction ID	The unique ID Facteus internally generates and assigns to the transaction.
GROSS_TRANSACTION_AMOUNT	Gross transaction amount	Dollar amount of the transaction
CASH_BACK_AMOUNT
TRANSACTION_DATE	Transaction date	The date and time the transaction occurred is synthesized to protect consumer privacy, by applying randomization within a range that does not negatively impact its statistical relevance.
LOCAL_TRANSACTION_DATE	Local transaction date	The date and time the transaction occurred as of the local time where the transaction happened. Null values are where the local time zone is not clear.
TRANSACTION_TYPE	Transaction type	The transaction type as it was received from the source provider is standardized and assigned by Facteus. Possible Values: ATM Withdrawal Adjustment BPD Bill Pay Business Account Deposit Fee Funds Transfer Load Merchant Credit Non Financial Other Spend Write Off
MERCHANT_COUNTRY	Merchant country	The country location of the merchant where the transaction occurred. This is from the data provider. For the “standard” cut, these are mapped by Facteus to a standard set of values.
MERCHANT_STATE	Merchant state	The state location of the merchant where the transaction occurred. This is from the data provider. For the “standard” cut, these are mapped by Facteus to a standard set of values.
MERCHANT_CITY	Merchant city	The city location of the merchant where the transaction occurred. This is from the data provider. For the “standard” cut, these are mapped by Facteus to a standard set of values.
MERCHANT_POSTAL_CODE	Merchant postal code	The postal code location of the merchant where the transaction occurred. This is from the data provider. For the “standard” cut, these are mapped by Facteus to a standard set of values.
MERCHANT_CATEGORY_CODE	Merchant category code (MCC)	The payment card industry standard merchant category code (MCC) of the transaction, as it was received from the source data provider. This code is selected by the merchant and identifies the type of business the merchant is engaged in.
CURRENCY_CODE	Currency code	Original currency of the transaction when available. For the “standard” cut, these are mapped by Facteus to a standard set of values.
TRANSACTION_DESCRIPTION	Transaction description	The transaction description is synthesized to remove any PII, but this allows the data buyer to use a custom merchant tagging process.
CARD_TYPE	Card type	The card type as it was received from the source data provider is standardized and assigned by Facteus. Possible Values: Benefit - Health Benefit - Transit Corporate Expense Credit Debit Education General Purpose Gift Card Government Incentive Other Payroll Private Label Gift Travel
CARD_HOLDER_ZIP	Cardholder postal code	The postal code location of the cardholder, as it was received from the source data provider. The cardholder location will be as it was delivered when Facteus originally received the transaction. The cardholder’s most recent location will be available in the cardholder information file.
CARD_HOLDER_YEAR_OF_BIRTH	Cardholder year of birth range	The year of birth of the cardholder is synthesized to protect consumer privacy, by applying randomization within a range that does not negatively impact its statistical relevance.
CARD_PRESENT_INDICATOR	Card present indicator	The indicator of whether a transaction was made online or at a physical store location, as it was received from the source data provider. Values: Card Present (in-store) Card Not Present (CNP - typically interpreted as online) Null (value not available)
MERCHANT_ID	Entity ID	The unique ID for an entity assigned to the transaction by the tagging model.
MERCHANT_NAME	Entity name	The merchant, agent, or other entity assigned to the transaction by the tagging model.
MERCHANT_CONFIDENCE_SCORE	Confidence score	A number that represents the confidence in the entity tagging.
MERCHANT_TICKER	Symbol	The common stock symbol for the entity based on the entity to ticker mapping.
MERCHANT_EXCHANGE	Exchange	The primary exchange for the stock symbol based on the entity to ticker mapping.
AGENT_ID	Entity ID	The unique ID for an entity assigned to the transaction by the tagging model.
AGENT_NAME	Entity name	The merchant, agent, or other entity assigned to the transaction by the tagging model.
AGENT_CONFIDENCE_SCORE	Confidence score	A number that represents the confidence in the entity tagging.
AGENT_TICKER	Symbol	The common stock symbol for the entity based on the entity to ticker mapping.
AGENT_EXCHANGE	Exchange	The primary exchange for the stock symbol based on the entity to ticker mapping.
PAYMENT_ID	Entity ID	The unique ID for an entity assigned to the transaction by the tagging model.
PAYMENT_NAME	Entity name	The merchant, agent, or other entity assigned to the transaction by the tagging model.
PAYMENT_CONFIDENCE_SCORE	Confidence score	A number that represents the confidence in the entity tagging.
PAYMENT_TICKER	Symbol	The common stock symbol for the entity based on the entity to ticker mapping.
PAYMENT_EXCHANGE	Exchange	The primary exchange for the stock symbol based on the entity to ticker mapping.
STORE_ID	Store ID	The unique ID for a store location.
STORE_LOCATION	Store location	Details of the store location extracted from the transaction description
STORE_ADDRESS	Store address	The street address of the specific store location.
STORE_LATITUDE	Store latitude	Latitude of the store location
STORE_LONGITUDE	Store longitude	Longitude of the store location
CONSISTENT_SHOPPER	Consistent shopper	Flag for whether the account_id (or card_id if account_id is not present) currently matches Facteus’ definition of a consistent card. 2 - Accounts or cards with a transaction at least 60 months ago and within the past 28 days. 1 - Accounts or cards with a transaction at least 48 months ago and within the past 28 days. 0 - Accounts that do not fit the first two designations.
IN_SCOPE	Representative shopper	Flag for whether the card holder currently matches Facteus’ definition of a representative card. 1 - Cards with a spending pattern similar to those detailed in the Federal Reserve Payment Study on the normal distribution of transactions by card type. 0 - Cards that do not fit that spending pattern. https://www.federalreserve.gov/paymentsystems/fr-payments-study.htm
LOAD_TIME	File load time	Date and time when the files are uploaded