RTBL_CAF_ACF_VW

(SQL View)
 Index Back

SELECT DISTINCT A.CHARTFIELD , A.LONGNAME FROM PS_CHARTFIELD_VW A , PS_FS_CF_TMPLT_VW B WHERE A.CHARTFIELD = B.FIELDNAME AND B.CF_ACTIVE_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RTBL_CAF_PRS_FLDNM Character(18) VARCHAR2(18) NOT NULL Personalization Field Name
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description