SCC_CAF_ATTRIB_NMSADPDLPRSCAF_VW(SQL View) |
Index Back |
|---|---|
Prospect Attribute PromptProspect Attribute Prompt |
| SELECT A.SCC_CAF_ATTRIB_NM , B.DESCR FROM PS_SCC_CAF_RAT_VW A , PS_SCC_CAF_ATTRIBS B WHERE A.RECNAME='ADM_PRSPCT_CAR' AND (A.SCC_ENTITY_ID IS NULL OR A.SCC_ENTITY_ID IN ( SELECT DISTINCT X.SCC_ENTITY_ID FROM PS_SCC_CAF_RAT_ENT X WHERE X.RECNAME = 'ADM_PRSPCT_CAR' AND A.SCC_ENTITY_ID = X.SCC_ENTITY_ID)) AND B.SCC_CAF_ATTRIB_NM = A.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 |