GL_PE_KCF_VW

(SQL View)
 Index Back

SELECT A.FIELDNAME ,C.LONGNAME FROM PS_FS_CF_TEMPLATE A , PSDBFLDLABL_VW C , PSDBFIELD D WHERE A.FIELDNAME = C.FIELDNAME AND C.FIELDNAME=D.FIELDNAME AND D.FLDNOTUSED = 0 AND A.FIELDNAME <> 'ALTACCT'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
2 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name