RC_ER_UNAUTHCSE

(SQL View)
 Index Back

My Assigned Case Details

View for case details of assigned cases

SELECT A.OPRID , A.CASE_ID , A.BUSINESS_UNIT , C.DISP_TMPL_FAM_CD , 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_ER_UNAUTH_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_VERTICAL Character(4) VARCHAR2(4) NOT NULL Specifies the CallCenter type. See translates for valid values.
HD=HelpDesk
SW=Support
6 CASE_TYPE Character(5) VARCHAR2(5) NOT NULL Case Type

Prompt Table: RC_CASETYPE_TBL

7 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

Prompt Table: BO

8 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

Prompt Table: BO

9 RC_STATUS Character(5) VARCHAR2(5) NOT NULL Case Status

Prompt Table: RC_STATUS_TBL

10 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
11 RC_PRIORITY Character(5) VARCHAR2(5) NOT NULL Case Priority

Prompt Table: RC_PRIORITY_TBL

12 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.
13 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
14 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.
15 TARGET_CLOSE_DATE Date(10) DATE Target close date
16 RC_REST_DTTM DateTime(26) TIMESTAMP Entitled restore date time. Used for SLA.
17 RC_REST_DATE Date(10) DATE Restore Date
18 RC_REST_TIME Time(15) TIMESTAMP Restore Time
19 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
20 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
21 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
22 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
23 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.
24 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time