CRYPT_PROFILE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID Default Value: 1
3	ENCRYPT_PRFL_ID	Character(30)	VARCHAR2(30) NOT NULL	Encryption Profile ID Prompt Table: PSCRYPTDEFN_SRC
4	DECRYPT_PRFL_ID	Character(30)	VARCHAR2(30) NOT NULL	Decryption Profile ID Prompt Table: PSCRYPTDEFN_SRC
5	PROFILE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Profile Status N=Not Valid P=Pending V=Valid
6	PROFILE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Profile Selected N=Un-Check Y=Check Default Value: N
7	PROFILE_UPDATE	Character(1)	VARCHAR2(1) NOT NULL	Update Profile N=Un-Check Y=Check
8	CRYPT_ROLE	Character(30)	VARCHAR2(30) NOT NULL	Role Name Prompt Table: PSROLEDEFN_VW
9	ENCRYPT_CHAIN_ID	Character(30)	VARCHAR2(30) NOT NULL	Algorithm Chain ID
10	ENCRYPT_ALG_ID	Character(40)	VARCHAR2(40) NOT NULL	Algorithm ID
11	ENCRYPT_PARAM_NM1	Character(30)	VARCHAR2(30) NOT NULL	Parameter Name
12	ENCRYPT_PARAM_VAL1	Long Character	CLOB	Parameter Value
13	ENCRYPT_PARAM_NM2	Character(30)	VARCHAR2(30) NOT NULL	Parameter Name
14	ENCRYPT_PARAM_VAL2	Long Character	CLOB	Parameter Value
15	ENCRYPT_KEYSET_ID	Character(30)	VARCHAR2(30) NOT NULL	Keyset ID
16	ENCRYPT_KEY	Long Character	CLOB	Key Value
17	DECRYPT_CHAIN_ID	Character(30)	VARCHAR2(30) NOT NULL	Algorithm Chain ID
18	DECRYPT_ALG_ID	Character(40)	VARCHAR2(40) NOT NULL	Algorithm ID
19	DECRYPT_PARAM_NM1	Character(30)	VARCHAR2(30) NOT NULL	Parameter Name
20	DECRYPT_PARAM_NM2	Character(30)	VARCHAR2(30) NOT NULL	Parameter Name
21	DECRYPT_PARAM_VAL1	Long Character	CLOB	Parameter Value
22	DECRYPT_PARAM_VAL2	Long Character	CLOB	Parameter Value
23	DECRYPT_KEYSET_ID	Character(30)	VARCHAR2(30) NOT NULL	Keyset ID
24	DECRYPT_KEY	Long Character	CLOB	Key Value