EOCF_RULE_IDLANGUAGE_CDPrompt Table: EOCF_EVTDFN_LVW
Prompt Table: EOCF_CTXDFN_LVW
EOCF_RULEVT_LVW(SQL View) |
Index Back |
|---|---|
IA Event Search Lang ViewIA Event Search Lang View |
| SELECT C.EOCF_RSET_ITEM_ID , B.LANGUAGE_CD , B.EOCF_EVENT_NAME , D.EOCF_CTX_NAME FROM PS_EOCF_EVENT_SEQ A , PS_EOCF_EVENT_LNG B , PS_EOCF_RSET_SEQ C , PS_EOCF_CTX_LANG D , PS_EOCF_EVENT_DEFN E WHERE A.EOCF_EVENT_ID = B.EOCF_EVENT_ID AND B.EOCF_EVENT_ID = E.EOCF_EVENT_ID AND A.EOCF_RULESET_ID = C.EOCF_RULESET_ID AND C.EOCF_RULE_ITEM_TYP = '00' AND E.EOCF_CONTEXT_ID = D.EOCF_CONTEXT_ID AND B.LANGUAGE_CD = D.LANGUAGE_CD |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | EOCF_EVENT_NAME | Character(80) | VARCHAR2(80) NOT NULL |
user-defined name to identify the characteristics of a particular action
Prompt Table: EOCF_EVTDFN_LVW |
| 4 | EOCF_CTX_NAME | Character(50) | VARCHAR2(50) NOT NULL |
context name
Prompt Table: EOCF_CTXDFN_LVW |