client_type_code

-1 rows


Description

A code indicating the type of a client. Examples include, but are not limited to: Corporation, Individual, Association, and others.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
client_type_code varchar 5 null
submission_detail.client_type_code submission_detail_client_type_code_fk R

A code representing the type of a client.
description varchar 100 null

The description of the code value.
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)
client_type_code_pk Primary key Asc client_type_code

Relationships

Close relationships within degrees of separation