HSC_PRCSMSK_TBL

(SQL Table)
Index Back

Batch process mapping

Process and Source records are defined with their corresponding staging tables to be used in the batch process for generating files and reports. These batch process are mapped with source and process tables as these process outputs refer masked field informtion on the reports.This table is used by Encryption Configuration Framework.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_NAME Character(12) VARCHAR2(12) NOT NULL Process Name
2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
3 HSC_MASKREC Character(15) VARCHAR2(15) NOT NULL Application Process Record
4 HSC_PRCSSTGREC Character(15) VARCHAR2(15) NOT NULL Process Stage Record

Prompt Table: PSRECDEFNPVW

5 HSC_SELECT Character(3) VARCHAR2(3) NOT NULL Select
N=None
U=Unmask

Default Value: N

6 DESCRLONG Long Character CLOB Long Description