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 |
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 |