oats_alr_application_parties

-1 rows


Description

An ALR APPLICATION PARTY is the inclusion of a PERSON ORGANIZATION as a party to an ALR APPLICATION, taking on a role as defined by APPLICATION ROLE CODE. The parties to an application may change over time, but are retained for historical purposes.

Columns

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

System generated sequence number to uniquely identify an ALR APPLICATION PARTY
alr_appl_role_code varchar 10 null
oats_alr_appl_role_codes.alr_appl_role_code oats_appy_aprc_fk R

User supplied value to uniquely identify an ALR APPL ROLE CODE
alr_application_id int8 19 null
oats_alr_applications.alr_application_id oats_appy_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.
person_organization_id int8 19 null
oats_person_organizations.person_organization_id oats_appy_pog_fk R

PERSON ORGANIZATION ID is the system generated unique identifier for PERSON ORGANIZATION.
effective_date timestamp 29,6 null

Date the party became an active on the ALR APPLICATION
expiry_date timestamp 29,6 √ null

Date the party is no longer effective on the ALR APPLICATION, but is retained for historical purposes.
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_alr_application_parties_pkey Primary key Asc alr_application_party_id
oats_appy_appl_fk_i Performance Asc alr_application_id
oats_appy_aprc_fk_i Performance Asc alr_appl_role_code
oats_appy_pog_fk_i Performance Asc person_organization_id
oats_appy_sk1_i Performance Asc/Asc/Asc alr_application_id + alr_appl_role_code + person_organization_id
oats_appy_uk1_i Must be unique

Relationships

Close relationships within degrees of separation