SF_CHARTFLD_VW

(SQL View)
 Index Back

View of Fields from psrecfield


SELECT A.FIELDNAME , B.LONGNAME FROM PSRECFIELD A , PSDBFLDLABL B , PS_INSTALLATION_SF C WHERE A.RECNAME = 'SSF_CF_MAP' AND A.FIELDNAME = B.FIELDNAME AND B.DEFAULT_LABEL = 1 AND (A.FIELDNAME IN ( SELECT C.ORIG_CF_NAME FROM PS_FS_CF_TEMPLATE C WHERE C.CF_ACTIVE_STATUS = 'A') OR A.FIELDNAME IN ('DEPTID'))

# 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