HSC_PRCSRUN_TBL(SQL Table) |
Index Back |
|---|---|
Batch process runstatusThis table stores the status of batch process defined on Map Batch Process page which uses source and process records and their correspoing staging tables for generating reports and files which includes mask field information.This table is used by Encryption Configuration Framework. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 2 | USERID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 3 | PRCSINSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 4 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: HSC_SRCREC_VW |
| 5 | HSC_STGREC |
Character(15) | VARCHAR2(15) NOT NULL |
Staging Record
Prompt Table: PSRECDEFNPVW |
| 6 | HSC_MASKREC |
Character(15) | VARCHAR2(15) NOT NULL |
Application Process Record
Prompt Table: PSRECDEFNPVW |
| 7 | PRCSTYPE | Character(30) | VARCHAR2(30) NOT NULL |
Process Type
Prompt Table: PMN_PRCSTYPE_VW |
| 8 | PRCSNAME | Character(12) | VARCHAR2(12) NOT NULL | Process Name |
| 9 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 10 | RUNCNTLID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 11 | RUNDTTM | DateTime(26) | TIMESTAMP | Run Date/Time |
| 12 | HSC_PRCSSTGREC | Character(15) | VARCHAR2(15) NOT NULL |
Process Stage Record
Prompt Table: PSRECDEFNPVW |
| 13 | HSC_PRCSSTS | Character(1) | VARCHAR2(1) NOT NULL |
Data Status
C=Clean I=Initiated M=Masked U=Unmasked |
| 14 | HSC_SELFLD | Character(3) | VARCHAR2(3) NOT NULL |
Select Fields
Y/N Table Edit |