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

EQTXSQEXESECLNG

(SQL View)

Equation SQL Execute Vw

Equation SQL Execute Authority Security Search Vw

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

Related Language Record for EQTX_SQ_EXE_SEC

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50