Encrypted Database Columns

Siebel Business Applications provide a number of database columns that are encrypted by default. The following table shows the database table columns encrypted by default in the Siebel database. For information on how to encrypt a database column, see Configuring Encryption and Search on Encrypted Data.

Table	Table Column
S_AGREE_TERMS	CC_NUMBER
S_CM_CNCTR_PARM	ENCRYPTED_VALUE
S_CONTACT_FNX	YL_PASSWD
S_DOC_ORDER	CC_NUMBER
	CCV_NUMBER
S_INV_PROF	CC_NUMBER
	CCV_NUMBER
S_ORDER	CC_NUMBER
S_PTY_PAY_PRFL	PAY_ACCNT_NUM
	VERIFICATION_NUM
S_SMQ_ADDR	SECURITY_TOKEN
S_SRC_PAYMENT	CC_NUM
S_SSO_SYS_USER	SSO_PASSWORD
S_USER	CHALLENGE_ANSWER
	CHALLENGE_QUESTION
T_DETAIL	ENCRPTD_COL

The CC_NUMBER and CC_NUM columns listed in the table are used to store credit card number data. The Payment Card Industry (PCI) Data Security Standard (DSS) is a set of standards designed to enhance the security of credit card data in organizations that process such data. It is contrary to the PCI standards to store credit card numbers in a database. The CC_NUMBER and CC_NUM columns are provided for backwards-compatibility purposes only and might be removed in a future release.