oats_related_alr_applications

-1 rows


Description

A RELATED APPLICATION is the association of one ALR APPLICATION to another.

Columns

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

System generated sequence number to uniquely identify a RELATED ALR APPLICATION
primary_alr_application_id int8 19 null
oats_alr_applications.alr_application_id oats_rlap_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.
secondary_alr_application_id int8 19 null
oats_alr_applications.alr_application_id oats_rlap_appl_fk2 R

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

User supplied value to uniquely identify a RELATIONSHIP CODE
include_in_staff_report_ind varchar 1 null

Indicates whether or not the related application is included in the ALR APPLICATION’s staff report.If so, the following information will be included in the staff report: Application Number, Applicant name, Decision Date, Proposal Description, and Decision Description
note varchar 4000 √ null

Further elaboration of the nature of the relationship between ALR APPLICATIONS.
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_related_alr_applications_pkey Primary key Asc related_alr_application_id
oats_related_alr_applications_primary_alr_application_id_se_key Must be unique Asc/Asc primary_alr_application_id + secondary_alr_application_id
oats_rlap_appl_fk2_i Performance Asc secondary_alr_application_id
oats_rlap_appl_fk_i Performance Asc primary_alr_application_id
oats_rlap_relc_fk_i Performance Asc relationship_code
oats_rlap_uk Must be unique Asc/Asc primary_alr_application_id + secondary_alr_application_id

Check Constraints

Constraint Name Constraint
avcon_1238100890_inclu_000 (((include_in_staff_report_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))

Relationships

Close relationships within degrees of separation