oats_financial_instruments

-1 rows


Description

A FINANCIAL INSTRUMENT is the receipt of a letter of credit, bond, or cash (as identified by a FINANCIAL INSTRUMENT CODE) that will meet the request of an ALR APPL DECISION . SECURITY AMT. The total SECURITY AMT may be met by multiple FINANCIAL INSTRUMENTS provided by different PERSON ORGANIZATIONS. Once all the CONDITIONS that are bound by a FINANCIAL INSTRUMENT (CONDITION . SECURITY REQUIRED IND = ‘Y’) have been met, the ALC will release the instrument. If a CONDITION bound by a FINANCIAL INSTRUMENT has not been met, the ALC may redeem the FINANCIAL INSTRUMENT, and use the money to fund the completion of the CONDITION.

Columns

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

System generated sequence number to uniquely identify a FINANCIAL INSTRUMENT
alr_appl_decision_id int8 19 null
oats_alr_appl_decisions.alr_appl_decision_id oats_fiin_aadc_fk R

System generated sequence number to uniquely identify a ALR APPL DECISION
financial_instrument_cd varchar 10 null
oats_financial_instrument_cds.financial_instrument_cd oats_fiin_ficd_fk R

User supplied value to uniquely identify a FINANCIAL INSTRUMENT CD
financial_institute_code varchar 10 √ null
oats_financial_institute_codes.financial_institute_code oats_fiin_finc_fk R

User supplied value to uniquely identify a FINANCIAL INSTITUTE CODE
person_organization_id int8 19 √ null
oats_person_organizations.person_organization_id oats_fiin_pog_fk R

PERSON ORGANIZATION ID is the system generated unique identifier for PERSON ORGANIZATION.
bank_file_nbr varchar 50 √ null

The reference number created by the financial institute used to track the FINANCIAL INSTRUMENT
received_date timestamp 29,6 √ null

Date the ALC received the FINANCIAL INSTRUMENT
amount float8 17,17 null

The amount of the FINANCIAL INSTRUMENT
expiry_date timestamp 29,6 √ null

Date the financial institute sets the FINANCIAL INSTRUMENT to expire
auto_renew_ind varchar 1 √ null

Indicates whether or not the financial institute has set the FINANCIAL INSTRUMENT to automatically renew
renewal_notification_date timestamp 29,6 √ null

If a FINANCIAL INSTRUMENT is not set to automatically renew, this is date the ALC sent a notification to the financial institute stating the FINANCIAL INSTRUMENT needs to be renewed.
release_date timestamp 29,6 √ null

Date the FINANCIAL INSTRUMENT was released by the ALC. This is mutually exclusive with REDEEMED DATE.
redeemed_date timestamp 29,6 √ null

Date the FINANCIAL INSTRUMENT was redeemed by the ALC. This is mutually exclusive with RELEASE DATE.
payment_type_code varchar 10 √ null
oats_payment_type_codes.payment_type_code oats_fiin_payc_fk R

User supplied value to uniquely identify a PAYMENT TYPE CODE
comments varchar 4000 √ null

General comments regarding the FINANCIAL INSTRUMENT as authored by ALC staff
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_financial_instruments_pkey Primary key Asc financial_instrument_id
oats_fiin_aadc_fk_i Performance Asc alr_appl_decision_id
oats_fiin_ficd_fk_i Performance Asc financial_instrument_cd
oats_fiin_finc_fk_i Performance Asc financial_institute_code
oats_fiin_payc_fk_i Performance Asc payment_type_code
oats_fiin_pog_fk_i Performance Asc person_organization_id

Check Constraints

Constraint Name Constraint
avcon_1238100890_auto__000 (((auto_renew_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying, NULL::character varying])::text[]))) NOT VALID

Relationships

Close relationships within degrees of separation