ca_state_province

Contains a list of states and provinces which can be used in location addresses

Column Name Column Datatype Column Null Option Column Comment
id integer not null Primary key. State/province id.
inactive integer not null Flag representing whether this record is active or inactive. 0=False (Active), 1=True (Inactive)
symbol nvarchar(100) not null State/province symbol (e.g. AB, AK, AL).
creation_user nvarchar(64) with null User or process that created the record.
creation_date integer with null Date the record was created.
last_update_user nvarchar(64) with null User or process that last updated the record.
last_update_date integer with null Date the record was last updated.
version_number integer with null Version number for transaction integrity.
description nvarchar(255) with null State/province name (e.g. Alberta, Alaska, Alabama).
exclude_registration integer with null Exclude Registration
delete_time integer with null Delete Time

Product Name: Asset

Table Type: Table

Relationships:

Primary Key Related Table Related Column
id    


Copyright © 2006 CA. All rights reserved.