BUSINESS_UNITPrompt Table: SP_BU_RA_NONVW
RAE_EVENT_IDRAE_SUB_EVENT_IDSEQNOPrompt Table: RAE_TEAM_SES_VW
RAE_SUBEVT_TEAM(SQL Table) |
Index Back |
|---|---|
Sub Event TeamSub Event Team Memebers selected from Team Members on Event |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_RA_NONVW |
| 2 | RAE_EVENT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Marketing - Campaign Identification field. Character field that will contain a generated campaign or free form entered campaign id. |
| 3 | RAE_SUB_EVENT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Marketing - SUB EVENTIdentification field. Character field that will contain a generated EVENT ID . |
| 4 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 5 | BO_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL |
Business Object ID
Prompt Table: RAE_TEAM_SES_VW |
| 6 | BO_ROLE_TYPE_ID | Number(12,0) | DECIMAL(12) NOT NULL | BO_ROLE_TYPE_ID |
| 7 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| 8 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |