EORC_PRCSS_VW2

(SQL View)
Index Back

View of COBOL Processes


SELECT A.PRCSTYPE ,C.OBJECTOWNERID , A.PRCSNAME FROM PS_PRCSDEFNPNL A LEFT JOIN PSPNLGRPDEFN C ON A.PNLGRPNAME = C.PNLGRPNAME AND C.MARKET ='GBL'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
2 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
3 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name