layouttitle
schemacustomer

Customer Extended Schema


Extended customer schema containing all jurisdiction-specific extensions.

Properties

NameDescriptionTypeEnum
annual_debit_turnover
The annual debit turnover in the business account of the entity. Monetary type represented as a naturally positive integer number of cents/pence.
integer-
clearing_threshold
Status of the clearing threshold as defined in EMIR
string
abovebelow
df_ccp
The pre-funded financial resources of the CCP in accordance with Article 50c of Regulation (EU) No 648/2012
integer-
df_cm
The sum of pre-funded contributions of all clearing members of the QCCP in accordance with Article 50c of Regulation (EU) No 648/2012.
integer-
incurred_cva
The amount of credit valuation adjustments being recognised by the institution as an incurred write-down, calculated without taking into account any offsetting debit value adjustment attributed to the firm’s own credit risk, that has been already excluded from own funds.
integer-
k_ccp
Hypothetical capital of the QCCP in accordance with Article 50c of Regulation (EU) No 648/2012
integer-
mic_code
The market identifier code as defined by the International Standards Organisation.
string-
pd_irb_ec
The probability of default as determined by internal ratings-based approach. Expressed as a percentage between 0 and 1. This value is used in economic capital calculations.
number-
product_count
The number of active products/trades this customer has with the firm.
integer-
risk_profile
The evaluation of the customer’s willingness and/or capacity to take on financial risk.
integer-
start_date
The date that the customer first became a customer. YYYY-MM-DDTHH:MM:SSZ in accordance with ISO 8601.
string-
status
The status of the relationship with the customer from the firm’s point of view.
string
established
accounts_payable
From the entity’s financial statements: The obligations owed to creditors arising from the entity’s ongoing operations, including the purchase of goods, materials, supplies, and services. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-
accounts_payable_prev
From the entity’s financial statements: The obligations owed to creditors arising from the entity’s ongoing operations, including the purchase of goods, materials, supplies, and services from the previous reporting period. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-
accounts_receivable
From the entity’s financial statements: The money owed to the entity for merchandise or services or services sold on open account. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-
accounts_receivable_prev
From the entity’s financial statements: The money owed to the entity for merchandise or services or services sold on open account from the previous reporting period. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-
audit_date
The date of the last audited financial statements. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
string-
capital_exp
From the entity’s financial statements: The funds used to acquire a long-term asset resulting in depreciation deductions over the life of the acquired asset, gross of depreciation. This should include the trailing twelve month period ended one year prior to the financials_date. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-
cash_securities
From the entity’s financial statements: The cash, depository accounts and marketable securities of the entity that can be easily sold and readily converted into cash. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-
credit_score
The credit score of the borrower. Also see [credit_score_vendor], [credit_score_version] and [credit_score_date]. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14M for more information.
string-
credit_score_date
The date on which the commercially available credit bureau score was obtained. Also see [credit_score_vendor], [credit_score_version] and [credit_score]. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14M for more information.
string-
credit_score_vendor
The vendor of the commercially available credit bureau score. Also see [credit_score_date], [credit_score_version] and [credit_score]. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14M for more information.
string
ficoothervantage
credit_score_version
The version of the commercially available credit bureau score. Also see [credit_score_vendor], [credit_score_date] and [credit_score]. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14M for more information.
string-
curr_assets
From the entity’s financial statements: The cash, accounts receivable, inventory, and other assets of the entity that are likely to be converted into cash, sold, exchanged, or expensed in the normal course of business, usually within one year and other assets expected to be converted to cash within a year. Examples include accounts receivable, prepaid expenses, and many negotiable securities as of the financials_date. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-
curr_assets_prev
From the entity’s financial statements: The cash, accounts receivable, inventory, and other assets of the entity that are likely to be converted into cash, sold, exchanged, or expensed in the normal course of business, usually within one year and other assets expected to be converted to cash within a year. This is the data one year prior to the financials_date. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-
curr_liabilities
From the entity’s financial statements: The short-term debt, accounts payable and other current liabilities of the entity that are due within one year. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-
curr_liabilities_prev
From the entity’s financial statements: The short-term debt, accounts payable and other current liabilities of the entity that are due within one year. This is the data one year prior to financials_date. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-
curr_long_term_debt
From the entity’s financial statements: The portion of long-term debt of the entity due within one year. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-
cusip
CUSIPs are identifiers created and delivered by the CSB (CUSIP Service Bureau). The CSB is managed on behalf of the American Bankers Association by Standard & Poor’s. Customer codes are assigned alphabetically from a series that includes deliberate built-in ‘gaps’ for future expansion. The first six characters which are known as the base (or CUSIP-6) uniquely identify the customer. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
string-
depr_amort
From the entity’s financial statements: The total depreciation and amortisation costs of the entity of tangible and intangible assets allocated against revenue for the current period. This is the data for the trailing twelve month (TTM) period ended on the financials_date. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-
financials_date
The as of date of the financial information. Also see [accounts_payable], [accounts_receivable], [capital_exp], [cash_securities], [curr_assets], [curr_liabilities], [depr_amort], [fixed_assets], [interest_expense], [inventory], [long_term_debt], [long_term_debt_maturity_amount], [net_income], [net_sales], [operating_income], [retained_earnings], [short_term_debt], [tangible_assets], [total_assets], [total_liabilities]
Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
string-
fixed_assets
From the entity’s financial statements: The tangible property of the entity used in the business and not for resale, net of depreciation. This includes, but is not limited to, buildings, furniture, fixtures, equipment, and land. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-
interest_expense
From the entity’s financial statements: The periodic expense to the entity of securing short and long-term debt. This is the data for the trailing twelve month (TTM) period ended on the financials_date. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-
inventory
From the entity’s financial statements: The value of the raw materials, work in process, supplies used in operations, finished goods, and merchandise bought for resale of the entity . Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-
inventory_prev
From the entity’s financial statements: The value of the raw materials, work in process, supplies used in operations, finished goods, and merchandise bought for resale of the entity . This is the data one year prior to financials_date. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-
long_term_debt
From the entity’s financial statements: The liabilities of the entity that are due in one year or more. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-
mailing_address
The borrower’s mailing street address. Must include street prefixes, suffixes, and unit number for condos and co-ops. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14M for more information.
string-
mailing_city
The borrower’s mailing city. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14M for more information.
string-
mailing_postal_code
The borrower’s mailing zip code. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
string-
mailing_state
The borrower’s mailing state. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14M for more information.
string-
minority_interest
The interest of shareholders who, in the aggregate, own less than half the shares in a corporation. On the consolidated balance sheets of companies whose subsidiaries are not wholly owned, the minority interest is shown as a separate equity account or as a liability of indefinite term. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
number-
net_income
From the entity’s financial statements: The income (or loss) reported by the entity after expenses and losses have been subtracted from all revenues and gains for the fiscal period including discontinued operations. This is the data for the trailing twelve month (TTM) period ended on the financials_date. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-
net_income_prev
From the entity’s financial statements: The income (or loss) reported by the entity after expenses and losses have been subtracted from all revenues and gains for the fiscal period including discontinued operations. This is the data for the trailing twelve month (TTM) period ended one year prior to the financials_date. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-
net_sales
From the entity’s financial statements: The gross sales of the entity reduced by cash discounts, trade discounts, and returned sales and allowances for which credit is given to customers less returns and allowances, freight out, and cash discounts allowed for the designated period. This is the data for the trailing twelve month (TTM) period ended on the financials_date. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-
net_sales_prev
From the entity’s financial statements: The gross sales of the entity reduced by cash discounts, trade discounts, and returned sales and allowances for which credit is given to customers less returns and allowances, freight out, and cash discounts allowed for the designated period. This should include the trailing twelve month period ended one year prior to the financials_date. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-
noi
From the entity’s financial statements: The most recent annualized net operating income as of the report date that serves as the primary source of repayment. Also see [noi_date]. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-
noi_date
The date of the current Net Operating Income (NOI). Also see [noi]. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
string-
operating_income
From the entity’s financial statements: The amount of profit (or loss) realized from continuing operations of the entity; typically represented as sales less items such as cost of goods sold, operating expenses, amortisation and depreciation. This is the data for the trailing twelve month (TTM) period ended on the financials_date. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-
orig_noi
The Net Operating Income (NOI) at origination.
integer-
regulator
Report the federal regulator of the entity. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14M for more information.
string
fdicfrbocc
retained_earnings
From the entity’s financial statements: The cumulative retained earnings of the entity less total dividend distributions to shareholders. Typically, it is the prior year’s retained earnings plus net income less distributions. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-
rssd_id
The RSSD ID of the national bank that has a financial interest in the loan. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14M for more information.
string-
short_term_debt
From the entity’s financial statements: The debt obligations of the entity with a term of less than one year. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-
stock_symbol
The Stock Symbol for stocks listed and traded on the regulated exchange. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
string-
tangible_assets
From the entity’s financial statements: The assets of the entity having a physical existence, such as cash, equipment, real estate, real property, and personal property such as buildings and machinery; accounts receivable are also usually considered tangible assets for accounting purposes. Tangible assets are distinguished from intangible assets, such as trademarks, copyrights, and goodwill, and natural resources (timberlands, oil reserves, and coal deposits). Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-
tin
The Taxpayer Identification Number (TIN) assigned to the guarantor by the U.S. Internal Revenue Service (IRS) in the administration of tax laws. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
string-
total_assets_prev
From the entity’s financial statements: The sum of the current assets of the entity plus net property, plant, and equipment plus other non-current assets (including, but not limited to, intangible assets, deferred items, and investments and advances). This is the data one year prior to financials_date. Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-
total_liabilities
From the entity’s financial statements: The sum of current liabilities plus long-term debt plus other non-current liabilities (including deferred taxes, investment tax credit, and minority interest) of the entity . Refer to https://www.federalreserve.gov/apps/reportingforms/Report/Index/FR_Y-14Q for more information.
integer-