TV_FIELDNAME_VW

(SQL View)
Index Back

SELECT A.RECNAME , B.FIELDNAME FROM PS_TV_RECNAME_VW A , PSRECFIELD 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).

Prompt Table: TV_RECNAME_VW

2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).