TAU_PRCS_APP_VW (SQL View)	Index Back
TAU Applications (by PRCS) This is a view of SQR, COBOL, and AppEngine applications available for selection on the Table Access Utility Run Control.

TAU_PRCS_APP_VW

(SQL View)

TAU Applications (by PRCS)

This is a view of SQR, COBOL, and AppEngine applications available for selection on the Table Access Utility Run Control.

SELECT DISTINCT P.PRCSNAME , P.DESCR , G.OBJECTOWNERID , %Substring(P.PRCSTYPE,1,3) FROM PS_PRCSDEFN P , PS_PRCSDEFNPNL C , PSPNLGRPDEFN G WHERE C.PRCSNAME=P.PRCSNAME AND G.PNLGRPNAME=C.PNLGRPNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TAU_APPNAME Character(128) VARCHAR2(128) NOT NULL This field is used to specify the Application to be analyzed for the Table Access Utility.

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier

4 TAU_APPTYPE Character(3) VARCHAR2(3) NOT NULL This field identifies the type of application (program) to be analyzed by the Table Access Utility..
AEP=AppEngine Programs
CBL=COBOL Programs
QRY=Queries
SQR=SQR Reports

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TAU_APPNAME	Character(128)	VARCHAR2(128) NOT NULL	This field is used to specify the Application to be analyzed for the Table Access Utility.
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier
4	TAU_APPTYPE	Character(3)	VARCHAR2(3) NOT NULL	This field identifies the type of application (program) to be analyzed by the Table Access Utility.. AEP=AppEngine Programs CBL=COBOL Programs QRY=Queries SQR=SQR Reports