PSC_BNP_DEPOSIT

Details

Schema: FUSION
Object owner: PSC_CC
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
PSC_BNP_DEPOSIT_ACCOUNT_PK	DEPOSIT_ACCOUNT_KEY

Columns

Name	Datatype	Length	Precision	Not-null	Comments
DEPOSIT_ACCOUNT_KEY	NUMBER		18	Yes	Indicates a unique identifying key for each deposit account.
DEPOSIT_ACCOUNT_NUMBER	VARCHAR2	30		Yes	Indicates a unique identifier for each deposit account that is generted using a numbering schema.
ACCOUNT_TYPE	VARCHAR2	30		Yes	Indicates the type of the desposit account.
ACCOUNT_STATUS	VARCHAR2	30		Yes	Indicates the status of the deposit account.
ACCOUNT_DESCRIPTION	VARCHAR2	360			Indicates the purpose for which the deposit account is setup.
VERIFICATION_STATUS	VARCHAR2	30		Yes	Indicates the verification status of deposit account.
CURRENCY_CODE	VARCHAR2	3		Yes	Indicates the currency code of the deposit account funds.
INITIAL_DEPOSIT	NUMBER			Yes	Indicates the initial amount that should be deposited into the desposit account.
MINIMUM_DEPOSIT	NUMBER			Yes	Indicates the minimum deposit increments that should be deposited into the deposit account.
MINIMUM_BALANCE	NUMBER			Yes	Indicates the minimum balance that should be held in the deposit account.
AVAILABLE_BALANCE	NUMBER				Indicates the available balance in the deposit account.
BALANCE_NOTIFICATION	VARCHAR2	1		Yes	Indicates whether a notification should be sent when deposit account balance is below the minimum balance.
FEE_CHARGE_OPTION	VARCHAR2	30		Yes	Indicates options to utilize the money deposited in a Deposit Account.
PURPOSE	VARCHAR2	30			Indicates purpose for which the Deposit Account is created.
DEPOSIT_ACCOUNT_NAME	VARCHAR2	35		Yes	Indicates the Deposit Account Name.
DEPOSIT_ACCOUNT_PUID	VARCHAR2	480		Yes	Indicates the Deposit Account PUID.
MIGRATED_DATA_FLAG	VARCHAR2	3		Yes	Migrated data flag.
LOCK_ACCOUNT	VARCHAR2	1		Yes	Lock Account.
AUTOPAY_FLAG	VARCHAR2	1		Yes	Indicates automated process can charge fee to the account.
TRANSFER_FLAG	VARCHAR2	1		Yes	Indicates money can be transferred from the account or to the account.
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.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
psc_bnp_deposit_account_fund	psc_bnp_deposit_account	DEPOSIT_ACCOUNT_KEY
psc_bnp_deposit_account_proj	psc_bnp_deposit_account	DEPOSIT_ACCOUNT_KEY
psc_bnp_deposit_account_attach	psc_bnp_deposit_account	DEPOSIT_ACCOUNT_KEY
psc_bnp_deposit_account_actvty	psc_bnp_deposit_account	DEPOSIT_ACCOUNT_KEY
psc_bnp_deposit_account_access	psc_bnp_deposit_account	DEPOSIT_ACCOUNT_KEY
psc_bnp_deposit_account_record	psc_bnp_deposit_account	DEPOSIT_ACCOUNT_KEY
psc_bnp_deposit_account_user	psc_bnp_deposit_account	DEPOSIT_ACCOUNT_KEY
psc_bnp_deposit_account_owner	psc_bnp_deposit_account	DEPOSIT_ACCOUNT_KEY

Indexes

Index	Uniqueness	Tablespace	Columns
PSC_BNP_DEPOSIT_ACCOUNT_PK	Unique	Default	DEPOSIT_ACCOUNT_KEY
PSC_BNP_DEPOSIT_ACCOUNT_U1	Unique	Default	DEPOSIT_ACCOUNT_NUMBER
PSC_BNP_DEPOSIT_ACCOUNT_U2	Unique	PSC_BNP_DEPOSIT_ACCOUNT_U2	DEPOSIT_ACCOUNT_NAME
PSC_BNP_DEPOSIT_ACCOUNT_U3	Unique	PSC_BNP_DEPOSIT_ACCOUNT_U3	DEPOSIT_ACCOUNT_PUID