PSCRYPTALGPRMVW

(SQL View)
 Index Back

Encryption Algorithm Chain

This record stores the Algorithim IDs associated with each Chain

SELECT A.CRYPT_CHAIN_ID , A.CRYPT_CHAIN_SEQ , A.CRYPT_ALG_ID , B.CRYPT_PARAM_NM , B.CRYPT_PARAM_VAL , B.CRYPT_FROMKEY FROM PSCRYPTALGCHAIN A , PSCRYPTALGPARAM B WHERE A.CRYPT_aLG_ID = B.CRYPT_aLG_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CRYPT_CHAIN_ID Character(30) VARCHAR2(30) NOT NULL Algorithm Chain ID
2 CRYPT_CHAIN_SEQ Number(2,0) SMALLINT NOT NULL Chain Sequence
3 CRYPT_ALG_ID Character(40) VARCHAR2(40) NOT NULL Algorithm ID

Prompt Table: PSCRYPTALG_VW

4 CRYPT_PARAM_NM Character(30) VARCHAR2(30) NOT NULL Parameter Name
5 CRYPT_PARAM_VAL Long Character CLOB Parameter Value
6 CRYPT_FROMKEY Character(1) VARCHAR2(1) NOT NULL From Keyset