SF_CHARTFLD_VW2

(SQL View)
 Index Back

View of Fields from psrecfield


SELECT A.FIELDNAME , B.LONGNAME FROM PSRECFIELD A , PSDBFLDLABL B , PS_INSTALLATION D 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','LEDGER','BUSINESS_UNIT') OR (A.FIELDNAME IN ('EXT_GL_CHARTFLD') AND D.GL <> 'Y')))

# 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