HSC_CRYPFLD_TBL

(SQL Table)
Index Back

Source record mapping table

Mapping table for source record field and its encrypted field.This table is used by Encryption Configuration Framework.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: PSRECDEFNPVW

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

Prompt Table: PSRECFIELDALL

3 HSC_CRYPT_FLD Character(18) VARCHAR2(18) NOT NULL Encrypt Data Field

Prompt Table: PSRECFIELDALL

4 HSC_CRYPT_ACTN Character(4) VARCHAR2(4) NOT NULL Action
DCPT=Decrypt
ENCR=Encrypt
NONE=None

Default Value: NONE

5 HSC_CRYPT_STS Character(1) VARCHAR2(1) NOT NULL Status
D=Decrypted
E=Encrypted
N=None

Default Value: N