Path

Table Name

TAX_RECON

Update

Approximately monthly to include all Effective Income Tax Rate Reconciliation tables in 10-K filings to the last day of the prior month

FIELD

DESCRIPTION

CIK

Central Index Key of the company that the data relates to

ACCESSION

The ACCESSION number for the 10-K filing that this data was sourced from.

TABLE_NO

The index number for the table where the deferred tax/asset data was found in the 10-K filing. Note, tables are counted from the first table tag in the filing.

ROW_N

The row number of the data point within the table.

unitref

The unit of measurement for the value in the row. For example, the unit might be "USD" for a dollar amount, or "shares" for a number of shares of stock.

decimals

The number of decimal places used to represent the value in the row.

scale

The scale factor used to adjust the value in the row. For example, if the value is expressed in thousands of dollars, the scale factor would be 3.

name

The XBRL tag associated with this data value.

orig_row_label

The original label of the row as it appeared in the html document, if blank the table did not have a row label for this value this is not uncommon for totals and subtotals.

CURRENTYEAR

The value of the data point for the current fiscal year.

CURRENTYEAR_START_DATE

The start date of the current fiscal year.

CURRENTYEAR_END_DATE

The end date of the current fiscal year.

PRIORYEAR

The value of the data point for the prior fiscal year.

PRIORYEAR_START_DATE

The start date of the prior fiscal year.

PRIORYEAR_END_DATE

The end date of the prior fiscal year.

TWOPRIOR

The value of the data point for two fiscal years prior.

TWOPRIOR_START_DATE

The start date of the fiscal year two years prior.

TWOPRIOR_END_DATE

The end date of the fiscal year two years prior.

THREEPRIOR

The value of the data point for three fiscal years prior.

THREEPRIOR_START_DATE

The start date of the fiscal year three years prior.

THREEPRIOR_END_DATE

The end date of the fiscal year three years prior.

TABLE_TYPE

PERCENT/DOLLAR - an indicator variable to describe the units that are used in the table to report the values.

ROW_TYPE

PERCENT/DOLLAR - an indicator variable to describe the units that are used in the row to report the values. Some tables will be labeled as PERCENT/DOLLAR but one or more rows might have DOLLAR/PERCENT values to provide context.

FLAG

An indication as to whether we believe the data value or labeling could be in error or to indicate some total issue that we could not address