EOCF_RULE_IDEOCF_EVENT_IDPrompt Table: EOCF_CTXDROP_VW
SETIDPrompt Table: EO_SETID_NONVW
EOCF_TPRULE_VW(SQL View) |
Index Back |
|---|---|
Intell. Actions for EventsIntell. Actions for Trigger Points |
| SELECT DISTINCT C.EOCF_RSET_ITEM_ID , A.EOCF_EVENT_ID , A.SETID FROM PS_EOCF_EVENT_SEQ A , PS_EOCF_RULESET B , PS_EOCF_RSET_SEQ C WHERE B.EOCF_RULESET_ID = C.EOCF_RULESET_ID AND A.EOCF_RULESET_ID = B.EOCF_RULESET_ID AND C.EOCF_RULE_ITEM_TYP = '00' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOCF_RULE_ID |
Number(31,0) | DECIMAL(31) NOT NULL | Active Analytics Framework unique identifier for a policy |
| 2 | EOCF_EVENT_ID |
Number(31,0) | DECIMAL(31) NOT NULL |
Active Analytics Framework unique identifier for an event definition
Prompt Table: EOCF_CTXDROP_VW |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: EO_SETID_NONVW |