submission_status_code

-1 rows


Description

A code indicating the status of a client creation submission request. Examples of possible statuses include Approved, Rejected, and others.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
submission_status_code varchar 5 null
submission.submission_status_code submission_submission_status_code_fk R

A code representing the status of a submission request.
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)
submission_status_code_pk Primary key Asc submission_status_code

Relationships

Close relationships within degrees of separation