RA_PRFCNSTCP_VW(SQL View) |
Index Back |
|---|---|
Constituent Profile ViewConstituent profile view containing career and program attributes. Use as prompt table in marketing center definition page. |
| SELECT RA_PROFILE_ID , RA_ATTRIBUTE_ID , RA_ATTRIB_NAME , DESCR100 FROM PS_RA_ATTRIBUTE WHERE RA_PROFILE_ID=1304 AND RA_ATTRIBUTE_ID IN(3,4) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RA_PROFILE_ID | Number(18,0) | DECIMAL(18) NOT NULL | Profile - profile ID |
| 2 | RA_ATTRIBUTE_ID | Number(18,0) | DECIMAL(18) NOT NULL | Profile / Attribute ID |
| 3 | RA_ATTRIB_NAME | Character(90) | VARCHAR2(90) NOT NULL | Profile - Attribute name |
| 4 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |