SAD_CA_APCFT_VW (SQL View)	Index Back
Caf attr for CA-ketenID Holds name of custom added CAF attribute to store text value of on SAD_APPL_CAF record

SAD_CA_APCFT_VW

(SQL View)

Caf attr for CA-ketenID

Holds name of custom added CAF attribute to store text value of on SAD_APPL_CAF record

SELECT A.SCC_CAF_ATTRIB_NM FROM PS_SCC_CAF_RECATTR A ,PS_SCC_CAF_ATTRIBS B WHERE A.RECNAME = 'ADM_APPL_DATA' AND A.EFF_STATUS = 'A' AND A.SCC_CAF_ATTRIB_NM = B.SCC_CAF_ATTRIB_NM AND B.SCC_CAF_ATTR_TYPE = '02'

Parent record: SCC_CAF_RATRHDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCC_CAF_ATTRIB_NM Character(20) VARCHAR2(20) NOT NULL Common Attribute