SCC_VLTCNV_AET (SQL Table)	Index Back
ENCRYPTION VAULT CONVERT AET

SCC_VLTCNV_AET

(SQL Table)

ENCRYPTION VAULT CONVERT AET

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
Prompt Table: EO_PSRECDEFN_VW

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

6 SCC_CRYPT_CFG_ID Character(30) VARCHAR2(30) NOT NULL Encryption Configuration ID
Prompt Table: SCC_CRYPT_CFG

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

8 SCC_COMMIT_FREQ Number(10,0) DECIMAL(10) NOT NULL Commit Frequency

9 SCC_NOT_UPD_SINCE DateTime(26) TIMESTAMP NOT NULL Not Updated Since

10 SCC_STOP_PROCESS Character(1) VARCHAR2(1) NOT NULL Stop Process
Y/N Table Edit
Default Value: N

11 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: EO_PSRECDEFN_VW
5	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
6	SCC_CRYPT_CFG_ID	Character(30)	VARCHAR2(30) NOT NULL	Encryption Configuration ID Prompt Table: SCC_CRYPT_CFG
7	SCC_ALG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Algorithm ID
8	SCC_COMMIT_FREQ	Number(10,0)	DECIMAL(10) NOT NULL	Commit Frequency
9	SCC_NOT_UPD_SINCE	DateTime(26)	TIMESTAMP NOT NULL	Not Updated Since
10	SCC_STOP_PROCESS	Character(1)	VARCHAR2(1) NOT NULL	Stop Process Y/N Table Edit Default Value: N
11	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.