Administrative Change Table (ACT) - Table Definition
Column Name Data Type Description
key_id integer 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)
pinyin_name character (80) Name of entry in pinyin romanization.
char_name character (80) Name of entry in Chinese characters.
beg_date integer Date when a particular instance of administrative division became current.
Format: yyyymmdd
(for BCE years, format: -yyyymmdd)
end_date integer 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.