SCC_CRYPT_VLTVW (SQL View)	Index Back
Encrypted Value Vault Where encrypted values are stored

SCC_CRYPT_VLTVW

(SQL View)

Encrypted Value Vault

Where encrypted values are stored

SELECT '?' , 0 , '?' , '?' , '?' , '' FROM PS_INSTALLATION_SA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCC_CRYPT_VAULT_ID Character(36) VARCHAR2(36) NOT NULL Encrypted Value Vault Foreign Key. Store this foreign key in lieu of an encrypted value. Retrieve the actual encrypted value from the encryption vault using this key. This is a UUID.

2 SCC_ALG_ID Number(10,0) DECIMAL(10) NOT NULL Algorithm ID

3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

5 SCC_CRYPT_CFG_ID Character(30) VARCHAR2(30) NOT NULL Encryption Configuration ID

6 SCC_ENCRYPTED_TEXT Long Character(1033) VARCHAR2(1033) Encrypted Text

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_CRYPT_VAULT_ID	Character(36)	VARCHAR2(36) NOT NULL	Encrypted Value Vault Foreign Key. Store this foreign key in lieu of an encrypted value. Retrieve the actual encrypted value from the encryption vault using this key. This is a UUID.
2	SCC_ALG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Algorithm ID
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
4	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
5	SCC_CRYPT_CFG_ID	Character(30)	VARCHAR2(30) NOT NULL	Encryption Configuration ID
6	SCC_ENCRYPTED_TEXT	Long Character(1033)	VARCHAR2(1033)	Encrypted Text