XREF_PSRECDEFN (SQL View)	Index Back
Records

XREF_PSRECDEFN

(SQL View)

Records

Select a.recname, a.rectype, b.sqltext From PSRECDEFN a, PSSQLTEXTDEFN b where a.recname = b.sqlid and b.sqltype='2'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OBJ_RECNAME Character(15) VARCHAR2(15) NOT NULL Object Recname

2 RECTYPE Number(1,0) SMALLINT NOT NULL Record Type
0=SQL Table
1=SQL View
2=Derived Work/Record
3=Subrecord
5=Dynamic View
6=Query View
7=Temporary Table

3 VIEWTEXT Long Character(8192) CLOB SQL View Text

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OBJ_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Object Recname
2	RECTYPE	Number(1,0)	SMALLINT NOT NULL	Record Type 0=SQL Table 1=SQL View 2=Derived Work/Record 3=Subrecord 5=Dynamic View 6=Query View 7=Temporary Table
3	VIEWTEXT	Long Character(8192)	CLOB	SQL View Text