PT_PRCS_REC_VW

(SQL View)
Index Back

SELECT DISTINCT A.RECNAME , B.RECTYPE FROM PSRECFIELD A , PSRECDEFN B WHERE A.RECNAME = B.RECNAME

# 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