Unique ID number, primary key. (Each number can only occur once in this table)(Records have one-to-one relationship with entries in the AFT, HACT)(Records have one-to-many relationship with entries in VNT, AHT, TST)(Records have many-to-one relationship with entries in PGT, AST, VCT,DPT)

Date when the division was next changed or ceased to exist.
Format: yyyymmdd (for BCE years, format: -yyyymmdd)

known_date

integer

Date when a particular instance of administrative division was known to exist, if not a beginning or end date.
Format: yyyymmdd (for BCE years, format: -yyyymmdd)

approx_date

integer

Approximate date when a particular instance of administrative division was known to exist to the closest year, or period (as listed in the Dynastic Period Table), and if not a beginning, end, or known date.
Format: yyyy0000 (for BCE years, format: -yyyy0000) Query mechanism should be designed for this date to be found by beginning date queries (ie. should default to yyyy0101), and also to be found by end date queries (ie. should default to yyyy1231).

date_notes

character (80)

Notes on dates, name of person who checked the source. Mandatory entry.

date_source

character (80)

Source of date information. Mandatory entry.

hac_code

character(40)

Complete Historical Administrative Code.

stv_code

character(80)

Complete Spatio-Temporal Variant Code.

place_geocode

character(24)

Location of unit if it was, at any time, a settlement or populated place. (If the location of this settlement served as a county seat, or capital of an administrative unit at any time, it will have a "YES" flag for this occurence in the "admin_seat" or "capital" fields in the Place Geocode Table, and each such occurrence will have its own record in the Administrative Seat Table or Capital Feature Table, respectively).

cap_code

character(24)

Location of capital is given as a Place Geocode.

var_feat

character(24)

Lists file names or codes for variant AFTs.

var_spat

character(24)

Lists file names or variant spatial data tables.

var_hier

character(2)

Default (NULL)= unit does not have a simultaneous status in an alternative Administrative Hierarchy (such as military, inspectorate, or other kinds of jurisdiction).
If (Y) = yes, unit does have such status as listed in the Administrative Hierarchy Table.