EOCF_RULE_IDPrompt Table: EOCF_EVTDFN_VW
Prompt Table: EOCF_CTXDFN_VW
EOCF_RULEVT_VW(SQL View) |
Index Back |
|---|---|
IA Event Search ViewIA Event Search View |
| SELECT C.EOCF_RSET_ITEM_ID , B.EOCF_EVENT_ID , B.EOCF_EVENT_NAME , D.EOCF_CONTEXT_ID , D.EOCF_CTX_NAME , A.SETID FROM PS_EOCF_EVENT_SEQ A , PS_EOCF_EVENT_DEFN B , PS_EOCF_RSET_SEQ C , PS_EOCF_CONTEXT D WHERE A.EOCF_EVENT_ID = B.EOCF_EVENT_ID AND A.EOCF_RULESET_ID = C.EOCF_RULESET_ID AND C.EOCF_RULE_ITEM_TYP = '00' AND B.EOCF_CONTEXT_ID = D.EOCF_CONTEXT_ID |
| # | 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_EVTDFN_VW |
| 3 | EOCF_EVENT_NAME | Character(80) | VARCHAR2(80) NOT NULL | user-defined name to identify the characteristics of a particular action |
| 4 | EOCF_CONTEXT_ID | Number(31,0) | DECIMAL(31) NOT NULL |
the ID value for a configured context
Prompt Table: EOCF_CTXDFN_VW |
| 5 | EOCF_CTX_NAME | Character(50) | VARCHAR2(50) NOT NULL | context name |
| 6 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |