RC_CASE_PRSN_VW

(SQL View)
 Index Back

Persons Related to Case Cust's

People related to a case through Customer.

SELECT A.BO_ID_CUST , A.BUSINESS_UNIT , A.CASE_ID , DISP_TMPL_FAM_CD , A.BO_ID_PARTNER , A.BO_ID_PART_CONT , A.BO_ID_CONTACT , A.BO_ID_REPORTED_BY , A.CASE_TYPE , A.CASE_SUBTYPE ,A.PRODUCT_GROUP , A.PRODUCT_ID , A.PROBLEM_TYPE , A.INST_PROD_ID , A.RC_TRACKING_NBR , A.RC_SUMMARY , A.RC_STATUS , A.SECURE_CASE_FLG , B.STATUS_CATEGORY , A.RC_CATEGORY , A.RC_TYPE , A.RC_DETAIL , A.RC_PRIORITY , A.URGENCY , A.RC_SEVERITY , A.CREATION_DATE , A.CLOSED_DATE , A.CASE_VISIBILITY , A.ROW_ADDED_DTTM , A.ROW_ADDED_OPRID , A.ROW_LASTMANT_DTTM , A.ROW_LASTMANT_OPRID ,A.RC_DESCRLONG FROM PS_RC_CASE A , PS_RC_STATUS_TBL B WHERE B.RC_STATUS = A.RC_STATUS AND A.CASE_VISIBILITY <> 'INTL' AND B.SETID = ( SELECT D.SETID FROM PS_SET_CNTRL_REC D WHERE D.SETCNTRLVALUE = A.BUSINESS_UNIT AND D.RECNAME = 'RC_STATUS_TBL')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 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.
4 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code
5 BO_ID_PARTNER Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID of Partner Company.
6 BO_ID_PART_CONT Signed Number(32,0) DECIMAL(31) NOT NULL This is the business object identifier for the partner contact.
7 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
8 BO_ID_REPORTED_BY Number(31,0) DECIMAL(31) NOT NULL Reported By Field. This is used in Case Record to store BO_ID of Reported By Person.
9 CASE_TYPE Character(5) VARCHAR2(5) NOT NULL Case Type
10 CASE_SUBTYPE Character(5) VARCHAR2(5) NOT NULL Field to capture the case subtype.
11 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group
12 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: PROD_ITEM

13 PROBLEM_TYPE Character(8) VARCHAR2(8) NOT NULL Problem Type for Support Cases
14 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)
15 RC_TRACKING_NBR Character(30) VARCHAR2(30) NOT NULL Customer Tracking Number Field.
16 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.
17 RC_STATUS Character(5) VARCHAR2(5) NOT NULL Case Status
18 SECURE_CASE_FLG Character(1) VARCHAR2(1) NOT NULL Used in HRHD to Secure the case so that only people in the provider group assigned to the case can access the case.
N=No
Y=Yes
19 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
20 RC_CATEGORY Character(5) VARCHAR2(5) NOT NULL CallCenter Category. Used in HD.
21 RC_TYPE Character(5) VARCHAR2(5) NOT NULL Specialty type. Used on HD case.
22 RC_DETAIL Character(5) VARCHAR2(5) NOT NULL Detail field on HD Case. Used in Quick Code.
23 RC_PRIORITY Character(5) VARCHAR2(5) NOT NULL Case Priority
24 URGENCY Character(5) VARCHAR2(5) NOT NULL Case Urgency
25 RC_SEVERITY Character(5) VARCHAR2(5) NOT NULL Case severity
26 CREATION_DATE Date(10) DATE Creation date of the case.
27 CLOSED_DATE Date(10) DATE Date Closed
28 CASE_VISIBILITY Character(4) VARCHAR2(4) NOT NULL Field to capture the case visibility.
EXCL=Internal, exclude Case Contact
EXTL=External
INTL=Internal
29 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
30 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
31 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
32 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
33 RC_DESCRLONG Long Character CLOB Long description used in CallCenter for Problem, Solution...