RBF_RECFIELD_VW

(SQL View)
Index Back

Record View


SELECT A.RECNAME , B.FIELDNAME FROM PSRECDEFN A , PSRECFIELD B WHERE A.RECNAME = B.RECNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 QUERY_RECORD Character(15) VARCHAR2(15) NOT NULL Query Record Name
2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).