Home / Issuing / Generate Reports
A Credit Loan Tape report includes all transaction event activity for Consumer Revolving Credit Card products. It is account-level data and captured as a point-in-time snapshot of your portfolio.
Report ENUM: CREDIT_LOAN_TAPE
Data for this report is available as follows:
Field Name | Data Type | Description |
---|---|---|
as_of_date | DateTime (ISO 8601: YYYY-MM-DDTHH:MM:SSZ) | Effective snapshot of account, balance, transaction, or performance metrics as of the specified day for this report |
financial_account_id | String | Unique identifier of the financial account |
origination_date | DateTime (ISO 8601: YYYY-MM-DDTHH:MM:SSZ) | UTC timestamp when the financial account was opened |
card_product_id | String | Unique identifier of the card product |
card_product_name | String | Name of the card product |
account_holder_id | String | Unique identifier of the account holder |
bank_name | String | Name of the issuing bank |
financial_account_status | String | Financial account status |
is_charged_off | Boolean | True if the account is charged-off; otherwise False |
origination_credit_score | Integer | Credit score at account origination |
origination_credit_limit | Decimal | Credit limit assigned at account origination |
origination_apr | Decimal | Interest rate assigned at account origination |
current_balance | Decimal | Current balance amount on the as_of_date |
current_balance_currency_code | String | ISO 4217 currency code of current_balance |
current_delinquent_amount | Decimal | Amount by which the payment is delinquent |
current_delinquent_amount_currency_code | String | ISO 4217 currency code of current_delinquent_amount |
delinquent_days | Integer | Number of days that the payment is delinquent |
delinquency_status | String | Delinquency status |
delinquency_update_date | DateTime (ISO 8601: YYYY-MM-DDTHH:MM:SSZ) | UTC timestamp when the deliquency status was last updated |
charge_off_amount | Decimal | Total balance officially written off as a loss on the account due to delinquency, default, or other uncollectible status |
charge_off_amount_currency_code | String | ISO 4217 currency code of charge_off_amount |
charge_off_date | DateTime (ISO 8601: YYYY-MM-DDTHH:MM:SSZ) | Date of the charge_off_amount |
current_purchase_apr | Decimal | Current interest rate on the as_of_date |
current_credit_limit | Decimal | Credit limit amount on the as_of_date |
current_credit_limit_currency_code | String | ISO 4217 currency code of current_credit_limit |
is_over_limit | Boolean | True if the total purchases exceed the available credit, as of the last statement; otherwise False |
over_limit_amount | Decimal | Amount over the credit limit, as of the last statement |
over_limit_currency_code | String | ISO 4217 currency code of over_limit_amount |
current_address_state | String | State of the current address of the account holder |
last_statement_credit_utilization | Number | Credit utilization as a percentage, as of the last statement |
last_pull_credit_score | String | Account holder’s Experian credit score, as of the last credit pull |
last_pull_credit_score_date | DateTime (ISO 8601: YYYY-MM-DDTHH:MM:SSZ) | Date of last_pull_credit_score |
year_to_date_fee_amount | Decimal | Year-to-date fee amount, as of the last statement |
year_to_date_fee_currency_code | String | ISO 4217 currency code of year_to_date_fee_amount |
year_to_date_interest_amount | Decimal | Year-to-date interest amount, as of the last statement |
year_to_date_interest_currency_code | String | ISO 4217 currency code of year_to_date_interest_amount |
has_recurring_payments_scheduled | Boolean | True if the account has scheduled recurring payments set; otherwise False |
statement_id | String | Unique identifier of the statement |
statement_period_start | DateTime (ISO 8601: YYYY-MM-DDTHH:MM:SSZ) | UTC timestamp of the period start date on the last statement |
statement_period_end | DateTime (ISO 8601: YYYY-MM-DDTHH:MM:SSZ) | UTC timestamp of the period end date on the last statement |
statement_date | DateTime (ISO 8601: YYYY-MM-DDTHH:MM:SSZ) | UTC timestamp of the date when the statement was generated |
statement_payment_due_on | DateTime (ISO 8601: YYYY-MM-DDTHH:MM:SSZ) | UTC timestamp of the payment due date on the last statement |
starting_statement_balance | Decimal | Primary balance on the last statement |
starting_statement_balance_currency_code | String | ISO 4217 currency code of starting_statement_balance |
ending_statement_balance | Decimal | Ending primary balance, as of the last statement |
ending_statement_balance_currency_code | String | ISO 4217 currency code of ending_statement_balance |
statement_purchase_apr | Decimal | Annual percentage rate, as of the last statement |
period_minimum_payment_amount | Decimal | Minimum payment amount due, as of the last statement |
period_minimum_payment_currency_code | String | ISO 4217 currency code of period_minimum_payment_amount |
period_purchases_amount | Decimal | Total purchase amount, as of the last statement |
period_purchases_currency_code | String | ISO 4217 currency code of period_purchases_amount |
period_credit_amount | Decimal | Amount of total credit, as of the last statement. Includes payments, refunds, rewards and credited as statement credit, manual adjustments, etc. |
period_credit_currency_code | String | ISO 4217 currency code of period_credit_amount |
period_interest_charge_amount | Decimal | Interest amount on the last statement |
period_interest_charge_currency_code | String | ISO 4217 currency code of period_interest_charge_amount |
period_interest_credit_amount | Decimal | Interest credited amount on the last statement |
period_interest_credit_currency_code | String | ISO 4217 currency code of period_interest_credit_amount |
period_fee_charge_amount | Decimal | Fee amount on the last statement |
period_fee_charge_currency_code | String | ISO 4217 currency code of period_fee_charge_amountt |
period_fee_credit_amount | Decimal | Fee credited amount on the last closed statement |
period_fee_credit_currency_code | String | ISO 4217 currency code of period_fee_credit_amount |
statement_delinquent_amount | Decimal | Past due amount of the last statement |
statement_delinquent_amount_currency_code | String | ISO 4217 currency code of statement_delinquent_amount |
ending_reward_points | Number | Number of reward points, as of the last statement |
ending_credit_limit_amount | Decimal | Ending credit limit amount, as of the last statement |
ending_credit_limit_currency_code | String | ISO 4217 currency code of ending_credit_limit_amount |
mla_eligible | Boolean | True if the cardholder is a servicemember qualifying for MLA protection; otherwise False |
scra_eligible | Boolean | True if the cardholder is a servicemember qualifying for SCRA protection; otherwise False |
has_lifetime_bankruptcy | Boolean | True if the account holder has ever filed for bankruptcy in their lifetime as of the last credit pull; otherwise False |
has_lifetime_charge_off | Boolean | True if the account holder has ever had a credit account charge-off as of the last credit pull; otherwise False |
has_current_bankruptcy | Boolean | True if the account holder has a current bankruptcy on their credit report as of the last credit pull; otherwise False |
is_fraudulent | Boolean | True if the account was identified as fraudulent |
is_modified | Boolean | True if the account was modified |