oats_financial_institute_codes

-1 rows


Description

A FINANCIAL INSTITUTE CODE identifies the major banks, credit unions, or other financial institutes at the corporate level. The details of any specific bank branch will be held on the actual financial instrument. For example: - CIBC: Canadian Imperial Bank of Commerce - RBC: Royal Bank of Canada - Scotiabank

Columns

Column Type Size Nulls Auto Default Children Parents Comments
financial_institute_code varchar 10 null
oats_financial_instruments.financial_institute_code oats_fiin_finc_fk R

User supplied value to uniquely identify a FINANCIAL INSTITUTE CODE
description varchar 100 null

Description of the FINANCIAL INSTITUTE CODE
system_required_ind varchar 1 null

Indicates whether or not the code is required by the system. If yes, the users would be prevented from updating or deleting the code value.
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_institute_codes_pkey Primary key Asc financial_institute_code

Check Constraints

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

Relationships

Close relationships within degrees of separation