PSRECDEFNVW3 (SQL View)	Index Back
Record Defintion Prompt View It includes View, Table, Working record.

PSRECDEFNVW3

(SQL View)

Record Defintion Prompt View

It includes View, Table, Working record.

SELECT RECNAME ,RECDESCR FROM PSRECDEFN WHERE RECTYPE NOT IN (3,7)

Related Language Record: PSRECDEFNLANG1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: PSRECDEFNRVW
2	RECDESCR	Character(30)	VARCHAR2(30) NOT NULL	Record Description