SSR_HE_DFCAFAVW

(SQL View)
 Index Back

CAF Attributes Prompt

CAF Attributes Prompt for Data Futures

SELECT B.RECNAME , A.SCC_CAF_ATTRIB_NM , A.DESCR FROM %Table(SCC_CAF_ATTRIBS) A , %Table(SCC_CAF_RECATTR) b WHERE a.SCC_CAF_ATTRIB_NM = b.SCC_CAF_ATTRIB_NM

  • Related Language Record: SSR_HE_DFCFLANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    2 SCC_CAF_ATTRIB_NM Character(20) VARCHAR2(20) NOT NULL Common Attribute
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description