EOCF_TPRULE_VW

(SQL View)
Index Back

Intell. Actions for Events

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