RC_CASE_ROPN_VW(SQL View) |
Index Back |
|---|---|
Cases that are ReopenedThis view fetches the cases that are reopened. This view is used in RCC2008 Query to report the number cases that are reopened. |
| SELECT B.CASE_ID , B.RC_STATUS , B.STATUS_CHANGE_OPID , B.STATUS_CHANGE_DTTM , B.BUSINESS_UNIT FROM PS_RC_STATUS_LOG A , PS_RC_STATUS_LOG B WHERE A.CASE_ID = B.CASE_ID AND A.STATUS_CATEGORY = 'C' AND B.STATUS_CATEGORY = 'O' AND B.STATUS_CHANGE_DTTM > A.STATUS_CHANGE_DTTM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CASE_ID | Number(15,0) | DECIMAL(15) NOT NULL | Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table. |
| 2 | RC_STATUS | Character(5) | VARCHAR2(5) NOT NULL | Case Status |
| 3 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 4 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |