SCC_CAF_ATTR_VW

(SQL View)
Index Back

Attribute Table View

The Attribute Table stores Attributes information. Item Attributes are typically for informational purposes only.

SELECT A.SCC_CAF_ATTRIB_NM , A.DESCR , A.SCC_CAF_ATTR_TYPE , B.DESCR FROM PS_SCC_CAF_ATTRIBS A , PS_SCC_CAF_ATTRTYP B WHERE A.SCC_CAF_ATTR_TYPE = B.SCC_CAF_ATTR_TYPE

  • Related Language Record: SCC_CAF_AT_VW_L
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_CAF_ATTRIB_NM Character(20) VARCHAR2(20) NOT NULL Common Attribute
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 SCC_CAF_ATTR_TYPE Character(2) VARCHAR2(2) NOT NULL Attribute Type

    Prompt Table: SCC_CAF_ATTRTYP

    4 SCC_CAF_DESCR Character(30) VARCHAR2(30) NOT NULL Attribute Type