RA_MKT_ROLE_IDPrompt Table: BO_ROLE_TYP_IND
Y/N Table Edit
Prompt Table: BO_ROLE_TYP_ORG
RA_MKT_ROLE_VW(SQL View) |
Index Back |
|---|---|
Active Marketing RolesTable containing active marketing roles and descriptions used by audience |
| SELECT RA_MKT_ROLE_ID , RA_MKT_ROLE_DESCR , ROLE_TYPE_ID_IND , RA_RELATED_TO_ORG , ROLE_TYPE_ID_ORG FROM PS_RA_MKT_ROLE WHERE ACTIVE_FLAG = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RA_MKT_ROLE_ID |
Number(12,0) | DECIMAL(12) NOT NULL | Marketing Role ID |
| 2 | RA_MKT_ROLE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description of marketing role |
| 3 | ROLE_TYPE_ID_IND | Number(12,0) | DECIMAL(12) NOT NULL |
Individual Role Type ID
Prompt Table: BO_ROLE_TYP_IND |
| 4 | RA_RELATED_TO_ORG | Character(1) | VARCHAR2(1) NOT NULL |
Related to organization
Y/N Table Edit |
| 5 | ROLE_TYPE_ID_ORG | Number(12,0) | DECIMAL(12) NOT NULL |
Organization Role Type ID
Prompt Table: BO_ROLE_TYP_ORG |