SAD_CA_APCFN_VW

(SQL View)
Index Back

Caf attr for seq nbr

Holds name of custom added CAF attribute to store numerical 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 = '04'

  • 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