submission

-1 rows


Description

A submission request to create a client.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
submission_id serial 10 √ nextval('nrfc.submission_id_seq'::regclass)
submission_contact.submission_id submission_id_fk R
submission_detail.submission_id submission_id_fk R
submission_location.submission_id submission_id_fk R
submission_matching_detail.submission_id submission_id_fk R

Incremental id generated for a submission of a client.
submission_status_code varchar 5 √ null
submission_status_code.submission_status_code submission_submission_status_code_fk R

TBD.
submission_type_code varchar 5 √ null
submission_type_code.submission_type_code submission_submission_type_code_fk R

A code indicating the status of a submission request. Examples include, but are not limited to: New, Approved, Rejected, and others.
submission_date timestamp 29,6 √ null

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.
notify_client_ind varchar 1 √ 'Y'::character varying

An indicator that determines whether the submission should be sent to the client.

Indexes

Constraint Name Type Sort Column(s)
submission_pk Primary key Asc submission_id

Relationships

Close relationships within degrees of separation