RB_SQLTBL_VW (SQL View)	Index Back
View to get SQL Tables View to fecth SQL Tables to update the version

RB_SQLTBL_VW

(SQL View)

View to get SQL Tables

View to fecth SQL Tables to update the version

SELECT RECNAME , RECTYPE FROM PSRECDEFN WHERE RECTYPE = 3

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
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