Previous Topic: ca_site TableNext Topic: ca_tenant Table


ca_state_province Table

State/Province information associated with a specific location.

Field

Data Type

Reference

Remarks

creation_date

INTEGER

 

Specifies the date of when this record was created.

creation_user

nvarchar(64)

 

Indicates the user or process that created this record.

delete_time

INTEGER

 

Indicates the time of deletion.

description

nvarchar
(255)

 

Specifies the state or province name, such as Alberta, Alaska, Alabama, and so on.

exclude_
registration

INTEGER

 

Specifies to exclude registration.

id

INTEGER

 

Primary key that is also the unique, state or province ID.

inactive

INTEGER

Active_Boolean_
Table::enum

Sets the Active flag, as follows:
0—False (Active)
1—True (Inactive)

last_update_date

INTEGER

 

Specifies the date of when this record was last updated.

last_update_user

nvarchar(64)

 

Specifies the user or process that last updated the record.

symbol

nvarchar
(100)

 

Identifies the state or province symbol, such as AB, AK, AL, and so on.

version_number

INTEGER

 

Specifies the version number for transaction integrity.