RT_XCOLUMN_VW

(SQL View)
 Index Back

Fields on CALL LIST View

This view shows fields on record RT_CALL_LIST_VW and their long names.

SELECT A.FIELDNUM , A.FIELDNAME , B.LONGNAME FROM PSRECFIELD A , PSDBFLDLABL B WHERE A.RECNAME = 'RT_CALL_LIST_VW' AND A.FIELDNAME = B.FIELDNAME AND (A.LABEL_ID = ' ' AND B.DEFAULT_LABEL = 1 OR A.LABEL_ID <> ' ' AND A.LABEL_ID = B.LABEL_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
3 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name