BUSINESS_UNITRA_CAMPAIGN_IDRA_CMPGN_WAVE_IDEOCF_ACTION_IDA=Active
U=In Design
RA_WAVE_CLA_VW(SQL View) |
Index Back |
|---|---|
CLA Actions for a Wave 1This view will list all CLA actions for a given wave - part 1 |
| SELECT A.BUSINESS_UNIT , A.RA_CAMPAIGN_ID , A.RA_CMPGN_WAVE_ID , A.EOCF_ACTION_ID , B.EOCF_ACTION_NAME , D.EOCF_RULE_ID , D.EOCF_RULE_NAME , D.EOCF_RULE_STATUS , C.EOCF_ACTION_SET_ID FROM PS_RA_WAVE_CLA A , PS_EOCF_ACTION_DEF B , PS_EOCF_ACTION_SET C , PS_EOCF_RULE_DEFN D WHERE A.EOCF_ACTION_ID = B.EOCF_ACTION_ID AND B.EOCF_ACTION_ID = C.EOCF_ACTION_ID AND C.EOCF_ACTION_SET_ID = D.EOCF_ACTION_SET_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | RA_CAMPAIGN_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 | RA_CMPGN_WAVE_ID |
Character(15) | VARCHAR2(15) NOT NULL | Used to uniquely identify a Marketing - Campaign Activity (wave) ID |
| 4 | EOCF_ACTION_ID |
Number(31,0) | DECIMAL(31) NOT NULL | Active Analytics Framework Action ID field |
| 5 | EOCF_ACTION_NAME | Character(80) | VARCHAR2(80) NOT NULL | user-defined name to identify the characteristics of a particular action |
| 6 | EOCF_RULE_ID | Number(31,0) | DECIMAL(31) NOT NULL | Active Analytics Framework unique identifier for a policy |
| 7 | EOCF_RULE_NAME | Character(80) | VARCHAR2(80) NOT NULL | the name of a policy if the policy is named |
| 8 | EOCF_RULE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
data library term status, possible values are Active, Inactive, Under Construction
A=Active U=In Design |
| 9 | EOCF_ACTION_SET_ID | Number(31,0) | DECIMAL(31) NOT NULL | set of actions to be run from an event |