EOCF_EVENT_IDRA_ACTV_EVNT_VW(SQL View) |
Index Back |
|---|---|
Events valid for an activityEvents valid for a campaign activity |
| SELECT DISTINCT A.EOCF_EVENT_ID , EOCF_EVENT_NAME FROM PS_EOCF_ACT_VALEVT A , PS_EOCF_EVENTSELVW B WHERE A.EOCF_EVENT_ID = B.EOCF_EVENT_ID AND A.EOCF_EVENT_TYPE_ID = B.EOCF_EVENT_TYPE_ID AND EOCF_ACTION_TYP_ID IN (401612897988378621413714032206,3552623019903702202491574041089) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOCF_EVENT_ID |
Number(31,0) | DECIMAL(31) NOT NULL | unique identifier for an event definition |
| 2 | EOCF_EVENT_NAME | Character(80) | VARCHAR2(80) NOT NULL | user-defined name to identify the characteristics of a particular action |