SCC_CAF_ATTR_VW(SQL View) |
Index Back |
---|---|
Attribute Table ViewThe 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 |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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 |