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

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 Yes Encryption mode for credit card instruments Active
EXT_BA_ENCRYPTION_MODE VARCHAR2 30 Yes External bank account encryption mode; values taken from IBY_ENCRYPTION_MODE Active
INSTR_SEC_CODE_ENCRYPTION_MODE VARCHAR2 30 Yes Instrument security code encryption mode; values taken from IBY_ENCRYPTION_MODE Active
CREDIT_CARD_MASK_SETTING VARCHAR2 30 Yes 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 Yes 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 Yes 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 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes 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 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
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
ORA_SEED_SET1 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Indexes

Index Uniqueness Tablespace Columns
IBY_SYS_SECURITY_OPTIONS_U1 Unique Default SECURITY_OPTION_ID, ORA_SEED_SET1
IBY_SYS_SECURITY_OPTIONS_U11 Unique Default SECURITY_OPTION_ID, ORA_SEED_SET2