Path to Database

"S:/directEDGAR_DATA/PROXY_XBRL.db"

Table Name

PROXY_XBRL

Field

Description

CIK

Central Index Key

ACCESSION

SEC assigned accession number of the filing - the first six digits identify the entity that submitted the filing to the SEC (not necessarily the same as the registrant. The next two digits represent the year the filing was submitted to the SEC (note this may not always agree with the dissemination year). The last 6 digits represent the filing number/index in the count of all filings submitted by the particualr filer.

TABLE_NO

We index each table (defined as an html object with open () and close (

) tags) from the beginning of the document. This value represents the table index in the list of tables. This is useful when trying to collect a particualr type of table that may have some set of common tags but also unknown tags.

ROW_NO

This is the index of the row from the top of the table. We do not start collecting rows until we hit the first row with an iXBRL elements to reduce noise.

unitref

This is an attribute included in the iXBRL element that describes the unit of measure in the table.

name

This is an attribute included in the iXBRL element that identifies the namespace (the text to the left of the colon) and the value from the taxonomy (the text to the right of the colon).

child_n

This value represents the depth of the element whose value is reported in value_cal relative to the first element with data within a cell. These are normally found in row labels when the label contains tagged data. For example, if the label for equipment includes languafe such as amounts reported are net of accumlated depreciation of xxx and yyy respectively - the xxx and yyy values will be child elements of the label elements at an expected depth of 2.

orig_row_label

The row label of the row in the table.

value_cal

The value as reported in the table cell (td element) after applying all transformations indicated by the attributes of the element.

continuation_text

If the element has a continuedat attribute - this is the text of the element referenced in the continuedat attribute.

enddate

If the data value reports information that is measured across time - this is the ending date for that span.

startdate

If the data value reports information that is measured across time - this is the starting date for that span.

instant

If the data value reports information that is measured at a point in time - this is the measurement date.

explicit_member_dim_1

Dimensions provide a way to categorize information - if the contextref provides an explicitMember dimension label the value of the dimension is reported here - there might be as many as five dimentions provided - this is the first.

explicit_member_text_1

The text that is provided in the dimension is reported in this field - this text is related to the first dimensions

explicit_member_dim_2

See above

explicit_member_text_2

See above

explicit_member_dim_3

See above

explicit_member_text_3

See above

explicit_member_dim_4

See above

explicit_member_text_4

See above

explicit_member_dim_5

See above

explicit_member_text_5

See above

typed_member_dim

Similar to explicit members but these are generally company specific where the explicit member dimensional information is more standardized

typed_member_text

The text associated with the typed_member_dim