PROCESS_INSTANCEPROCESS_NAMEPrompt Table: HSC_PRCSDEFN_VW
RECNAMEPrompt Table: HSC_SRCREC_VW
HSC_STGRECPrompt Table: PSRECDEFNPVW
HSC_MASKRECPrompt Table: PSRECDEFNPVW
Prompt Table: PSRECDEFNPVW
C=Clean
I=Initiated
M=Masked
U=Unmasked
HSC_PRCSTAT_TBL(SQL Table) |
Index Back |
|---|---|
Batch process status detailsThis table stores the information of source record and process record staging table data set status when pre batch process is run as a part of PSJob. Pre batch process populates the staging table with decrypted field values which is further used by main batch process for generating reports and files.This table is used by Encryption Configuration Framework. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | PROCESS_NAME |
Character(12) | VARCHAR2(12) NOT NULL |
Process Name
Prompt Table: HSC_PRCSDEFN_VW |
| 3 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: HSC_SRCREC_VW |
| 4 | HSC_STGREC |
Character(15) | VARCHAR2(15) NOT NULL |
Staging Record
Prompt Table: PSRECDEFNPVW |
| 5 | HSC_MASKREC |
Character(15) | VARCHAR2(15) NOT NULL |
Application Process Record
Prompt Table: PSRECDEFNPVW |
| 6 | HSC_PRCSSTGREC | Character(15) | VARCHAR2(15) NOT NULL |
Process Stage Record
Prompt Table: PSRECDEFNPVW |
| 7 | HSC_PRCSSTS | Character(1) | VARCHAR2(1) NOT NULL |
Data Status
C=Clean I=Initiated M=Masked U=Unmasked |
| 8 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 9 | DESCRLONG | Long Character | CLOB | Long Description |