SCC_CAF_ATTRIB_NMA=Active
I=Inactive
SSR_FCT_CAF_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.EFF_STATUS ,B.DESCR FROM PS_SCC_CAF_RECATTR A , PS_SCC_CAF_ATTRIBS B WHERE A.scc_caf_attrib_nm = B.scc_caf_attrib_nm AND A.RECNAME = 'CLASS_ASSOC' AND A.EFF_STATUS = 'A' AND B.SCC_CAF_ATTR_TYPE <> '01' AND B.SCC_CAF_ATTR_TYPE <> '02' AND B.SCC_CAF_ATTR_TYPE <> '03' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_CAF_ATTRIB_NM |
Character(20) | VARCHAR2(20) NOT NULL | Common Attribute |
| 2 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |