HSC_PRCSRUN_WRK(SQL View) |
Index Back |
---|---|
Batch process work tableThis table stores the information of batch runs like process instance and status of staging tables data when actual bacth process is run as PSJob process. This table is used by Encryption Configuration Framework. |
SELECT DISTINCT P.PRCSINSTANCE ,P.PRCSTYPE ,P.PRCSNAME ,P.OPRID ,P.RUNCNTLID ,P.RUNDTTM ,E.HSC_PRCSSTS ,P.RUNSTATUSDESCR FROM PS_PMN_PRCSLIST P , PS_HSC_PRCSTAT_TBL E WHERE P.PRCSINSTANCE = E.PROCESS_INSTANCE |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PRCSINSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | PRCSTYPE | Character(30) | VARCHAR2(30) NOT NULL |
Process Type
Prompt Table: PMN_PRCSTYPE_VW |
3 | PRCSNAME | Character(12) | VARCHAR2(12) NOT NULL | Process Name |
4 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
5 | RUNCNTLID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
6 | RUNDTTM | DateTime(26) | TIMESTAMP | Run Date/Time |
7 | HSC_PRCSSTS | Character(1) | VARCHAR2(1) NOT NULL |
Data Status
C=Clean I=Initiated M=Masked U=Unmasked |
8 | RUNSTATUSDESCR | Character(10) | VARCHAR2(10) NOT NULL | Run Status |