EQTN_SQL_VW (SQL View)	Index Back
Equation SQL View Equation SQL View

EQTN_SQL_VW

(SQL View)

Equation SQL View

SELECT A.EQTN_OPERAND_SQL ,A.DESCR50 FROM PS_EQTN_SQL_TBL A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_EQTN_SQL_TBL B WHERE B.EQTN_OPERAND_SQL = A.EQTN_OPERAND_SQL AND B.EFFDT <= %CurrentDateIn ) AND A.EFF_STATUS = 'A'

Related Language Record: EQTNSQLVWLNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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.

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50