HSC_MSKKEY_MAP

(SQL Table)
Index Back

Mask key field mapping

Mapping source record and process record key fields when data set is used as Join Key on Define Process Records page. This key field mapping acts as a where clause join between source and process record for selecting data required for masking in process record.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 HSC_MASKREC Character(15) VARCHAR2(15) NOT NULL Application Process Record

Prompt Table: PSRECDEFNPVW

3 HSC_SRCKEYPOSN Number(3,0) SMALLINT NOT NULL Source Key Position
4 HSC_MSKKEY Character(18) VARCHAR2(18) NOT NULL Process Record Key
5 HSC_SRCKEY Character(18) VARCHAR2(18) NOT NULL Source Record Key

Prompt Table: HSC_SRKEYFLD_VW