1. Tables and Views for Financials
  2. IBY_SYS_SECURITY_OPTIONS_

IBY_SYS_SECURITY_OPTIONS_

IBY_SYS_SECURITY_OPTIONS stores the system security options that are used for funds capture processing and funds disbursement processing.

Details

  • Schema: FUSION

  • Object owner: IBY

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

IBY_SYS_SECURITY_OPTIONS_PK_

LAST_UPDATE_DATE, SECURITY_OPTION_ID

Columns

Name Datatype Length Precision Not-null Comments Status
SYS_KEY_FILE_LOCATION VARCHAR2 500 Location of the system password file Active
SYS_KEY_HASH RAW 100 Hash of the system key; used for verification purposes Active
CC_ENCRYPTION_MODE VARCHAR2 30 Encryption mode for credit card instruments Active
EXT_BA_ENCRYPTION_MODE VARCHAR2 30 External bank account encryption mode; values taken from IBY_ENCRYPTION_MODE Active
INSTR_SEC_CODE_ENCRYPTION_MODE VARCHAR2 30 Instrument security code encryption mode; values taken from IBY_ENCRYPTION_MODE Active
CREDIT_CARD_MASK_SETTING VARCHAR2 30 Credit card masking setting; values taken from lookup IBY_PMT_INSTR_MASKING Active
CREDIT_CARD_UNMASK_LEN NUMBER 2 Number of digits exposed for masked credit card numbers Active
EXT_BA_MASK_SETTING VARCHAR2 30 External bank account masking setting; values taken from lookup IBY_PMT_INSTR_MASKING Active
EXT_BA_UNMASK_LEN NUMBER 2 Number of digits exposed for masked bank account numbers Active
SUBKEY_USE_MAXIMUM NUMBER 10 Maximum use count for security sub-keys Active
COMPRESS_FC_FILE_FLAG VARCHAR2 1 Compress funds capure file flag Active
ENCRYPT_FC_FILE_FLAG VARCHAR2 1 Encrypt funds capure file flag Active
COMPRESS_FD_FILE_FLAG VARCHAR2 1 Compress payment file flag Active
ENCRYPT_FD_FILE_FLAG VARCHAR2 1 Encrypt payment file flag Active
ASYMM_CERT_DNAME VARCHAR2 500 Asymmetric certificate distinguished name, with components separated by commas. Active
ASYMM_ENCRYPT_KEY_HASH RAW 128 Asymetric encryption key hash Active
ASYMM_ENCRYPT_KEY_FILE_PATH VARCHAR2 255 Asymetric encryption key file path Active
ASYMM_ENC_KEY_FILE_PASSWD VARCHAR2 50 Asymetric encryption key file password Active
ASYMM_DECRYPT_KEY_HASH RAW 128 Asymetric decryption key hash Active
ASYMM_DECRYPT_KEY_FILE_PATH VARCHAR2 255 Asymetric decryption key file path Active
ASYMM_DCR_KEY_FILE_PASSWD VARCHAR2 50 Asymetric decryption key file password Active
MEMORY_STORE_TRESHOLD NUMBER 10 Memory store threshold Active
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
OBJECT_VERSION_NUMBER NUMBER 9 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
SALT_VERSION NUMBER 2 Salt version Active
SECURITY_OPTION_ID NUMBER 18 Yes Security option identifier
ENTERPRISE_ID NUMBER 18 Enterprise identifier to support multi-tenancy.
SUBKEY_AGE_MAXIMUM NUMBER 3 Sub-key maximum age (in days) after which the sub-key will be rotated.
TOKEN_PROFILE_ID NUMBER 18 Active tokenization profile identifier. Foreign key to IBY_BEPKEY.BEP_ACCOUNT_ID.
CIPHER_TYPE VARCHAR2 30 Active cipher type.
HASH_TYPE VARCHAR2 30 Active hash type.
SEC_KEY_HASH_UPG RAW 100 Upgrade system key hash value.
SEC_KEY_CREATE_DATE DATE System key creation date.
AUDIT_ACTION_TYPE VARCHAR2 10 Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP VARCHAR2 1000 Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_ACTION_TYPE_ VARCHAR2 10 Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Used to store a bit map of 1s and 0s for each column in the table.

Indexes

Index Uniqueness Tablespace Columns
IBY_SYS_SECURITY_OPTIONS_N__ Non Unique SECURITY_OPTION_ID
IBY_SYS_SECURITY_OPTIONS_U1_ Unique Default LAST_UPDATE_DATE, SECURITY_OPTION_ID