EQTX_SQ_EXE_SEC (SQL View)	Index Back
Equation SQL Execute Vw Equation SQL Execute Authority Security Search Vw

EQTX_SQ_EXE_SEC

(SQL View)

Equation SQL Execute Vw

Equation SQL Execute Authority Security Search Vw

SELECT A.EQTN_SQ_AUTH_CLASS ,A.EQTN_OPERAND_SQL ,B.DESCR50 FROM PS_EQTN_SQ_SQLAUTH A , PS_EQTN_SQL_VW B WHERE A.EQTN_AUTH_LEVEL IN ('E', 'R', 'W') AND A.EQTN_OPERAND_SQL = B.EQTN_OPERAND_SQL

Related Language Record: EQTXSQEXESECLNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EQTN_SQ_AUTH_CLASS Character(30) VARCHAR2(30) NOT NULL Equation SQL Authorization Class.

2 EQTN_OPERAND_SQL Character(30) VARCHAR2(30) NOT NULL Equation Processor SQL that can be called. This sqlid will dovetail into potential merging with the sqlid field of tools 8.

3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EQTN_SQ_AUTH_CLASS	Character(30)	VARCHAR2(30) NOT NULL	Equation SQL Authorization Class.
2	EQTN_OPERAND_SQL	Character(30)	VARCHAR2(30) NOT NULL	Equation Processor SQL that can be called. This sqlid will dovetail into potential merging with the sqlid field of tools 8.
3	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50