identification_type_code

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identification_type_code varchar 4 null
submission_detail.identification_type_code identification_type_code_fk R

A code indicating the identification type of a client. Examples of possible ID types include Canadian Birth Certificate, Canadian Passport, and others.
description varchar 100 null

The description of the code value.
country_code varchar 2 √ null
country_code.country_code Implied Constraint R

A code representing the country to which the ID type belongs. If the country code is populated, a province or state will be required.
effective_date date 13 null

The date that the code value has become or is expected to become effective. Default is the data that the code value is created.
expiry_date date 13 to_date('99991231'::text, 'YYYYMMDD'::text)

The date on which the code value has expired or is expected to expire. Default 9999-12-31.
create_timestamp timestamp 29,6 CURRENT_TIMESTAMP

The date and time the record was created.
update_timestamp timestamp 29,6 √ CURRENT_TIMESTAMP

The date and time the record was created or last updated.
create_user varchar 60 null

The user or proxy account that created the record.
update_user varchar 60 √ null

The user or proxy account that created or last updated the record.

Indexes

Constraint Name Type Sort Column(s)
identification_type_code_pk Primary key Asc identification_type_code

Relationships

Close relationships within degrees of separation