EOCF_TPRULE_VW (SQL View)	Index Back
Intell. Actions for Events Intell. Actions for Trigger Points

EOCF_TPRULE_VW

(SQL View)

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 This field is used to store the value of SetID on various setup tables.
Prompt Table: EO_SETID_NONVW

#	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	This field is used to store the value of SetID on various setup tables. Prompt Table: EO_SETID_NONVW