HSC_PRCSRUN_WRK

(SQL View)
Index Back

Batch process work table

This 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