RC_DTPY_SRCH_VW(SQL View) |
Index Back |
|---|---|
Display Template Policy ViewConfigurable Search view for AAF Policies that use Display Template Action |
| SELECT A.EOCF_RULE_ID , A.EOCF_RULE_NAME , B.SETID , A.EOCF_RULE_STATUS , B.EOCF_EVENT_ID , B.EOCF_CONTEXT_ID , F.DISP_TMPL_FAM_CD , F.DISP_TMPL_ID , G.EOCF_RULESET_ID FROM PS_EOCF_RULE_DEFN A , PS_EOCF_RULEVT_VW B , PS_EOCF_RULACTYPVW C , PS_EOCF_ACTN_TYPE D , PS_EOCF_ACTION_SET E , PS_RC_DISP_TMP_CFG F , PS_EOCF_EVENT_SEQ G WHERE B.EOCF_RULE_ID = A.EOCF_RULE_ID AND C.EOCF_RULE_ID = A.EOCF_RULE_ID AND D.EOCF_ACTION_TYP_ID = C.EOCF_ACTION_TYP_ID AND E.EOCF_ACTION_SET_ID = A.EOCF_ACTION_SET_ID AND F.EOCF_ACTION_ID = E.EOCF_ACTION_ID AND D.EOCF_RT_APPCLSPATH = 'RC_AAF_ACTIONS' AND D.EOCF_RT_APPCLASSID = 'CaseDisplayTemplate' AND E.STATUS = 'A' AND G.SETID = B.SETID AND G.EOCF_EVENT_ID = B.EOCF_EVENT_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_RULE_NAME | Character(80) | VARCHAR2(80) NOT NULL | the name of a policy if the policy is named |
| 3 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 4 | EOCF_RULE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
data library term status, possible values are Active, Inactive, Under Construction
A=Active U=In Design |
| 5 | EOCF_EVENT_ID | Number(31,0) | DECIMAL(31) NOT NULL | unique identifier for an event definition |
| 6 | EOCF_CONTEXT_ID | Number(31,0) | DECIMAL(31) NOT NULL | the ID value for a configured context |
| 7 | DISP_TMPL_FAM_CD | Character(30) | VARCHAR2(30) NOT NULL | Display Template Family Code |
| 8 | DISP_TMPL_ID | Character(30) | VARCHAR2(30) NOT NULL | Template identifier to define the display template. |
| 9 | EOCF_RULESET_ID | Number(31,0) | DECIMAL(31) NOT NULL | the ID for a set of policies |