HSC_CRYPFL_VW1

(SQL View)
 Index Back

Encryption profiles prompt

Prompt table for listing encryption profiles on Define Source Record page.This table is used by Encryption Configuration Framework.

SELECT DISTINCT CRYPT_PRFL_ID,DESCR FROM PSCRYPTPRFL WHERE CRYPT_CHAIN_ID NOT IN ( SELECT DISTINCT CRYPT_CHAIN_ID FROM PSCRYPTALGCHAIN WHERE (CRYPT_ALG_ID LIKE '%_ccm_%' OR CRYPT_ALG_ID LIKE '%_gcm_%'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CRYPT_PRFL_ID Character(30) VARCHAR2(30) NOT NULL Encryption Profile ID
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description