RC_ASG_C_DTL_VW(SQL View) |
Index Back |
|---|---|
My Assigned Case DetailsView for case details of assigned cases |
| SELECT A.OPRID , A.CASE_ID , A.BUSINESS_UNIT , C.DISP_TMPL_FAM_CD ,A.RC_ASSIGNMENT_TYPE , C.RC_VERTICAL , C.CASE_TYPE , C.BO_ID_CUST , C.BO_ID_CONTACT , C.RC_STATUS , D.STATUS_CATEGORY , C.RC_PRIORITY , B.RC_PROVIDER_GRP_ID , B.RC_ER_ASSIGNED_TO , C.RC_SUMMARY , C.TARGET_CLOSE_DATE ,%Dttm(C.RC_REST_DATE, C.RC_REST_TIME) ,C.RC_REST_DATE , C.RC_REST_TIME , C.ROW_ADDED_DTTM , C.ROW_ADDED_OPRID , C.ROW_LASTMANT_DTTM , C.ROW_LASTMANT_OPRID , C.SYNCID , C.SYNCDTTM FROM PS_RC_CASE_ASGN_VW A INNER JOIN PS_RC_CASE_ASSIGN B ON ( A.CASE_ID= B.CASE_ID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.PRIMARY_FLG='Y' ) INNER JOIN PS_RC_CASE C ON(A.CASE_ID= C.CASE_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT) , PS_RC_STATUS_TBL D WHERE D.RC_STATUS = C.RC_STATUS AND D.SETID = ( SELECT F.SETID FROM PS_SET_CNTRL_REC F WHERE F.SETCNTRLVALUE = C.BUSINESS_UNIT AND F.RECNAME = 'RC_STATUS_TBL') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | 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. |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | DISP_TMPL_FAM_CD |
Character(30) | VARCHAR2(30) NOT NULL | Display Template Family Code |
| 5 | RC_ASSIGNMENT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Assignment Type identifies the type of person, or group assigned to the case
G=Group I=Individual |
| 6 | RC_VERTICAL | Character(4) | VARCHAR2(4) NOT NULL |
Specifies the CallCenter type.
See translates for valid values.
HD=HelpDesk SW=Support |
| 7 | CASE_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Case Type
Prompt Table: RC_CASETYPE_TBL |
| 8 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL |
This field stores the Business Object ID for the customer.
Prompt Table: BO |
| 9 | BO_ID_CONTACT | Number(31,0) | DECIMAL(31) NOT NULL |
This field indicates the Business Object ID for the contact.
Prompt Table: BO |
| 10 | RC_STATUS | Character(5) | VARCHAR2(5) NOT NULL |
Case Status
Prompt Table: RC_STATUS_TBL |
| 11 | STATUS_CATEGORY | Character(1) | VARCHAR2(1) NOT NULL |
Categories for Case Status.
These drive processing.
C=Closed D=Canceled H=Case is on hold O=Case is Open |
| 12 | RC_PRIORITY | Character(5) | VARCHAR2(5) NOT NULL |
Case Priority
Prompt Table: RC_PRIORITY_TBL |
| 13 | PROVIDER_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL | Identification number for the provider group. |
| 14 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 15 | RC_SUMMARY | Character(80) | VARCHAR2(80) NOT NULL | Typically a summary of a long field. |
| 16 | TARGET_CLOSE_DATE | Date(10) | DATE | Target close date |
| 17 | RC_REST_DTTM | DateTime(26) | TIMESTAMP | Entitled restore date time. Used for SLA. |
| 18 | RC_REST_DATE | Date(10) | DATE | Restore Date |
| 19 | RC_REST_TIME | Time(15) | TIMESTAMP | Restore Time |
| 20 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 21 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 22 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 23 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 24 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 25 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |