PSSQLTEXTDEFN

This table is the child of PSSQLDEFN. It specifies the SQL text for the object so that PeopleTools can specify different SQL strings for different platforms. This table corresponds to DBA_VIEWS for SQLTYPE = 2.

PSSQLTEXTDEFN	DBA_VIEWS	Description of PeopleTools Column
PeopleSoft Field Name	Corresponding Oracle Column Name
SQLID		see PSSQLDEFN.SQLID
SQLTYPE		see PSSQLDEFN.SQLTYPE
MARKET		Market GBL=Global product USF=US Federal product
DBTYPE		Database Type 0=SQLBase (inactive) 1=DB2 2=Oracle 3=Informix 4=DB2/UNIX 5=AllBase (inactive) 6=Sybase 7=Microsoft 8=DB2/400 (inactive)
EFFDT		Date from which definition is effective. Only used on SQLTYPE 0 (SQL Objects) and 1 (Application Engine steps).
SEQNUM		Sequence Number
SQLTEXT		Text of the SQL query part of the view. However, SQLTEXT can contain PeopleSoft %functions that either reference other SQL objects, or expand to database specific functions.