SCC_CAF_ATTRIB_NMSSR_HE_RSCAFAVW(SQL View) |
Index Back |
|---|---|
Research CAF Attributes Prompt |
| SELECT A.SCC_CAF_ATTRIB_NM , A.DESCR FROM %Table(SCC_CAF_ATTRIBS) A , %Table(SCC_CAF_RECATTR) b WHERE b.recname = 'SSR_RS_CONSMPTN' AND a.SCC_CAF_ATTRIB_NM = b.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 |