RA_PROFILE_IDPrompt Table: RA_PROFILE
RA_ATTRIBUTE_IDRA_CNSTCARPG_VW(SQL View) |
Index Back |
|---|---|
MC Criteria SelectionMarketing Center criteria selection - limiting view to only 2 specific profile id attribute values career and program |
| 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
Prompt Table: RA_PROFILE |
| 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 |