DC_PRMPT_VW

(SQL View)
Index Back

select f.FIELDNAME, d.RECNAME, d.RECDESCR from PSRECDEFN d, PSRECFIELD f where d.RECNAME = f.RECNAME and d.RECTYPE < 2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DC_COPY_FLD1 Character(18) VARCHAR2(18) NOT NULL Copy From PanelField1
2 DC_PRMPTBL_NM Character(15) VARCHAR2(15) NOT NULL Prompt TableName
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description