SCC_CRYPT_VAULT_IDPrompt Table: SCC_ALGORITHMS
Prompt Table: SCC_CRYPT_CFG
Default Value: %datetime
SCC_CRYPT_VAULT(SQL Table) |
Index Back |
|---|---|
Encrypted Value VaultWhere encrypted values are stored |
| # | 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
Prompt Table: SCC_ALGORITHMS |
| 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
Prompt Table: SCC_CRYPT_CFG |
| 6 | LASTUPDDTTM | DateTime(26) | TIMESTAMP NOT NULL |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %datetime |
| 7 | SCC_ENCRYPTED_TEXT | Long Character(1033) | VARCHAR2(1033) | Encrypted Text |