RC_AAF_UPD_VW(SQL View) |
Index Back |
|---|---|
Check Urgency dependencyView to Check Urgency dependency in Case updated action. |
| SELECT PS_EOCF_EVENT_SEQ.SETID , PS_RC_CASE_ACT_CFG.URGENCY FROM PS_RC_CASE_ACT_CFG ,PS_EOCF_ACTION_SET ,PS_EOCF_RULE_DEFN ,PS_EOCF_RSET_SEQ ,PS_EOCF_EVENT_SEQ WHERE PS_RC_CASE_ACT_CFG.EOCF_ACTION_ID = PS_EOCF_ACTION_SET.EOCF_ACTION_ID AND PS_EOCF_ACTION_SET.EOCF_ACTION_SET_ID = PS_EOCF_RULE_DEFN.EOCF_ACTION_SET_ID AND PS_EOCF_RULE_DEFN.EOCF_RULE_ID = PS_EOCF_RSET_SEQ.EOCF_RSET_ITEM_ID AND PS_EOCF_EVENT_SEQ.EOCF_RULESET_ID = PS_EOCF_RSET_SEQ.EOCF_RULESET_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 2 | URGENCY | Character(5) | VARCHAR2(5) NOT NULL | Case Urgency |