SCC_CAF_ATTRIB_NMSSR_CLS_CAF_VW(SQL View) |
Index Back |
|---|
| 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 , PS_SCC_CAF_RECATTR R WHERE A.SCC_CAF_ATTR_TYPE = B.SCC_CAF_ATTR_TYPE AND R.RECNAME = 'CLASS_ASSOC' AND A.SCC_CAF_ATTRIB_NM = R.SCC_CAF_ATTRIB_NM |
| # | 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 |
| 4 | SCC_CAF_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Attribute Type |