CE_INDEX_BANK_BRANCHES

Details

Schema: FUSION
Object owner: CE
Object type: TABLE
Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CE_INDEX_BANK_BRANCHES_PK	BRANCH_PARTY_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
BRANCH_PARTY_ID	NUMBER		18	Yes	Identifier of the bank branch.	Active
BANK_PARTY_ID	NUMBER		18	Yes	Identifier of a bank party.	Active
BANK_BRANCH_NAME	VARCHAR2	360		Yes	Name of the bank branch.	Active
BANK_BRANCH_NAME_ALT	VARCHAR2	360			Alternate name of the bank branch.	Active
BRANCH_NUMBER	VARCHAR2	30			Numerical value assigned to the bank branch.	Active
BRANCH_PARTY_NUMBER	VARCHAR2	30		Yes	Numerical value assigned to the bank branch party.
HOME_COUNTRY_CODE	VARCHAR2	2			Country of the bank branch.
START_DATE	DATE			Yes	First date that the bank branch is active.	Active
END_DATE	DATE				Last date that the bank branch is active.	Active
BANK_BRANCH_TYPE	VARCHAR2	30			The type of banking institution to which the branch belongs. The valid values are ABA, CHIPS, Other, SWIFT.	Active
EFT_SWIFT_CODE	VARCHAR2	30			Bank Identifier Code (BIC) used by SWIFT to identify a bank or a bank branch. The BIC is a universal method of identifying financial institutions to facilitate the automated processing of telecommunication messages in banking and related financial environments.	Active
EFT_USER_NUMBER	VARCHAR2	30			Number used for identification and validation in electronic funds transfer.	Active
EDI_ID_NUMBER	VARCHAR2	30			Number used by the bank in electronic data interchange.	Active
BANK_CODE	VARCHAR2	30			Numerical value assigned to the bank.	Active
EDI_LOCATION	VARCHAR2	40			Name of the location of the electronic data interchange for the bank.	Active
RFC_CODE	VARCHAR2	30			Code of the Regional Finance Center (RFC). RFC is considered a bank branch of the U.S. Treasury bank and is responsible for the disbursement of public monies on behalf of some federal agencies.
BRANCH_INSTITUTION_TYPE	VARCHAR2	30		Yes	Institution type of the bank branch. For example, bank branch and clearing house branch.	Active
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.

Foreign Keys

Table	Foreign Table	Foreign Key Column
ce_payment_instruments	ce_index_bank_branches	BRANCH_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CE_INDEX_BANK_BRANCHES_N1	Non Unique	Default	BANK_PARTY_ID
CE_INDEX_BANK_BRANCHES_N2	Non Unique	Default	BANK_BRANCH_NAME
CE_INDEX_BANK_BRANCHES_N3	Non Unique	Default	UPPER("BANK_BRANCH_NAME")
CE_INDEX_BANK_BRANCHES_N4	Non Unique	Default	BRANCH_NUMBER
CE_INDEX_BANK_BRANCHES_N5	Non Unique	Default	HOME_COUNTRY_CODE, BANK_BRANCH_NAME
CE_INDEX_BANK_BRANCHES_N6	Non Unique	Default	BRANCH_PARTY_NUMBER
CE_INDEX_BANK_BRANCHES_N7	Non Unique	Default	BRANCH_INSTITUTION_TYPE
CE_INDEX_BANK_BRANCHES_N8	Non Unique	Default	REQUEST_ID
CE_INDEX_BANK_BRANCHES_U1	Unique	Default	BRANCH_PARTY_ID