HSC_MASKPRC_TBL(SQL Table) |
Index Back |
|---|---|
Process Source table mappingThis table stores the Source and Process record mapping. Process record field mapping in this table is masked when corrsponding source record field is masked and encrypted.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: HSC_CRYPREC_VW |
| 2 | HSC_MASKREC |
Character(15) | VARCHAR2(15) NOT NULL |
Application Process Record
Prompt Table: PSRECDEFNPVW |
| 3 | HSC_PRCSSTGREC | Character(15) | VARCHAR2(15) NOT NULL |
Process Stage Record
Prompt Table: PSRECDEFNPVW |
| 4 | HSC_MSKDATA_SEL | Character(2) | VARCHAR2(2) NOT NULL |
Data Selection
01=Join Source Record 02=PeopleSoft Query Default Value: 01 |
| 5 | HSC_QRYNAME | Character(30) | VARCHAR2(30) NOT NULL |
Data Set Query
Prompt Table: HSC_QRYNAME_VW |
| 6 | HSC_MASK_ACTN | Character(1) | VARCHAR2(1) NOT NULL |
Mask Action
M=Mask N=None U=Unmask Default Value: N |
| 7 | HSC_MASK_STS | Character(1) | VARCHAR2(1) NOT NULL |
Mask Status
M=Masked N=None U=Unmasked Default Value: N |
| 8 | DESCRLONG | Long Character | CLOB | Long Description |