oats_committee_recommendations

-1 rows


Description

A COMMITTEE RECOMMENDATION is the decision a committee has rendered regarding the ALR APPLICATION. These committees are held prior to the ALR APPLICATION being submitted to the ALC.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
committee_recommendation_id int8 19 null

System generated sequence number to uniquely identify a COMMITTEE RECOMMENDATION
alr_application_id int8 19 null
oats_alr_applications.alr_application_id oats_cmrc_appl_fk R

System generated sequence number to uniquely identify an ALR APPLICATION. This is also used as the ALR APPLICATION’S external reference number.
committee_type_code varchar 10 null
oats_committee_type_codes.committee_type_code oats_cmrc_cmtc_fk R

User supplied value to uniquely identify a COMMITTEE TYPE CODE
committee_decision_code varchar 10 null
oats_committee_decision_codes.committee_decision_code oats_cmrc_cmdc_fk R

User supplied value to uniquely identify a COMMITTEE DECISION CODE
description varchar 4000 null

Further description of the COMMITTEE RECOMMENDATION
who_created varchar 32 null

WHO CREATED is the IDIR or Oracle userid of the person who created the record.
when_created timestamp 29,6 null

WHEN CREATED is the date/time that the record was created.
who_updated varchar 32 √ null

WHO UPDATED is the IDIR or Oracle userid of the person who last updated the record.
when_updated timestamp 29,6 √ null

WHEN UPDATED is the date/time that the record was last updated.
revision_count int8 19 0

REVISION COUNT is used by Hibernate to control optimistic locking

Indexes

Constraint Name Type Sort Column(s)
oats_committee_recommendations_pkey Primary key Asc committee_recommendation_id
oats_cmrc_appl_fk_i Performance Asc alr_application_id
oats_cmrc_cmdc_fk_i Performance Asc committee_decision_code
oats_cmrc_cmtc_fk_i Performance Asc committee_type_code

Relationships

Close relationships within degrees of separation