IBY_BANK_ACCT_OWNER_CHNG

Details

Schema: FUSION
Object owner: IBY
Object type: TABLE
Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
IBY_ACCT_OWNER_CHNG_HIST_PK	ACCT_OWNER_CHANGE_HISTORY_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ACCT_OWNER_CHANGE_HISTORY_ID	NUMBER		18	Yes	Owner change history identifier for the external bank account.
PREV_ACCT_OWNER_CHANGE_HIST_ID	NUMBER		18		Last owner change request identifier.
ACCOUNT_OWNER_ID	NUMBER		18	Yes	Owner identifier for the external bank account.
ACCOUNT_OWNER_PARTY_ID	NUMBER		18	Yes	Foreign key to party at HZ_PARTIES_ALL.PARTY_ID.
OWNER_VERIF_STATUS_CODE	VARCHAR2	30		Yes	Bank account owner verification status. Values are from lookup ORA_IBY_OWNER_VERIF_STATUS.
PROVIDER_VERIF_RESPONSE_CODE	VARCHAR2	30			Bank account owner verification response code retuned by the validation service provider.
PROVIDER_VERIF_RESPONSE_MSG	VARCHAR2	255			Bank account owner verification response message retuned by the validation service provider.
STATUS_CODE	VARCHAR2	30			Indicates if the change history record is in draft status or has been published into the main table.
INTERNAL_OWNER_VERIF_RESP_CODE	VARCHAR2	30			Internal translatable response code. Values are from lookup ORA_IBY_INTRNL_OWNER_VERIF_RES.
PAYMENT_SYSTEM_ACCOUNT_ID	NUMBER		18		Payment system account identifier for the validation service provider.
VERIFICATION_REQ_REFERENCE_ID	VARCHAR2	80			Reference identifier for the request shared with the validation service provider.
APPROVAL_STATUS	VARCHAR2	30		Yes	Bank account owner approval status. Values are from lookup ORA_IBY_OWNER_APPROVAL_STATUS.
PRIMARY_FLAG	VARCHAR2	1			Indicates whether this is the primary bank account owner.
ORIGIN_APPLICATION_ID	NUMBER				Application used to create or update the bank account record.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
CREATED_FROM	VARCHAR2	30			Program or UI from which this row is created. Oracle internal use only.
START_DATE	DATE				Date of bank account activation.
END_DATE	DATE				Date of bank account deactivation.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
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.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
ACCT_OWNER_ENTITY_TYPE_CODE	VARCHAR2	30			Indicates the source of ACCOUNT_OWNER_ID. Values are from lookup ORA_IBY_ACCTOWNER_ENTITY_TYPE.
ORIGINAL_VERIF_STATUS_CODE	VARCHAR2	30			Used to preserve the original bank account owner verification status code value when the status was manually overridden. Values are from lookup ORA_IBY_OWNER_VERIF_STATUS.
VERIFICATION_REQUEST_TIMESTAMP	TIMESTAMP				Date and time when the bank account verification request to the service provider was initiated.
VERIFICATION_RESP_TIMESTAMP	TIMESTAMP				Date and time when the bank account verification response from the service provider was received.
EXT_BANK_ACCT_CHANGE_HIST_ID	NUMBER		18		Foreign key to IBY_EXT_BANK_ACCT_CHANGE_HIST.

Foreign Keys

Table	Foreign Table	Foreign Key Column
IBY_BANK_ACCT_OWNER_CHNG_HIST	iby_bank_acct_owner_chng_hist	PREV_ACCT_OWNER_CHANGE_HIST_ID
IBY_BANK_ACCT_OWNER_CHNG_HIST	iby_account_owners	ACCOUNT_OWNER_ID
IBY_BANK_ACCT_OWNER_CHNG_HIST	HZ_PARTIES"	ACCOUNT_OWNER_PARTY_ID
IBY_BANK_ACCT_OWNER_CHNG_HIST	IBY_BEPKEYS"	PAYMENT_SYSTEM_ACCOUNT_ID
IBY_BANK_ACCT_OWNER_CHNG_HIST	iby_ext_bank_acct_change_hist	EXT_BANK_ACCT_CHANGE_HIST_ID
iby_bank_acct_owner_chng_hist	iby_bank_acct_owner_chng_hist	PREV_ACCT_OWNER_CHANGE_HIST_ID
iby_account_owners	iby_bank_acct_owner_chng_hist	LAST_CHANGE_HIST_ID

Indexes

Index	Uniqueness	Tablespace	Columns
IBY_ACCT_OWNER_CHNG_HIST_N1	Non Unique	Default	REQUEST_ID
IBY_ACCT_OWNER_CHNG_HIST_N2	Non Unique	Default	EXT_BANK_ACCT_CHANGE_HIST_ID
IBY_ACCT_OWNER_CHNG_HIST_U1	Unique	Default	ACCT_OWNER_CHANGE_HISTORY_ID
IBY_ACCT_OWNER_CHNG_HIST_U2	Unique	Default	ACCOUNT_OWNER_ID, ACCT_OWNER_ENTITY_TYPE_CODE, PREV_ACCT_OWNER_CHANGE_HIST_ID