RC_CASE_DTL2_VW (SQL View)	Index Back
Case Details Case details view. Used to build the Case search index.

RC_CASE_DTL2_VW

(SQL View)

Case Details

Case details view. Used to build the Case search index.

SELECT A.BUSINESS_UNIT , A.CASE_ID , A.DISP_TMPL_FAM_CD , A.RC_STATUS , A.RC_DESCR_SS , A.SETID_SOURCE , A.RC_SOURCE , SRC.RC_SHORT_DESCR , A.GLOBAL_FLAG , A.SIN , A.SETID_PROD_GRP , A.PRODUCT_GROUP , PRD.DESCR , A.SETID_PRODUCT , A.PRODUCT_ID , ITM.DESCR , A.INST_PROD_ID , A.SETID_CATEGORY , A.RC_CATEGORY , CTG.RC_DESCR_SS , A.RC_TYPE , A.RC_DETAIL , A.SECURE_CASE_FLG , A.CASE_VISIBILITY , A.RC_SUMMARY , (CASE WHEN A.GLOBAL_FLAG = 'Y' THEN 'K' ELSE 'C' END) , A.RC_DESCRLONG , %subrec(RB_AUDIT_SBR, A) FROM PS_RC_CASE_DTL_VW A LEFT OUTER JOIN PS_RC_SOURCE_TBL SRC ON (A.SETID_SOURCE = SRC.SETID AND A.RC_SOURCE = SRC.RC_SOURCE) LEFT OUTER JOIN PS_RC_PRD_GRP_TMP PRD ON (A.SETID_PROD_GRP = PRD.SETID AND A.PRODUCT_GROUP = PRD.PRODUCT_GROUP) LEFT OUTER JOIN PS_PROD_ITEM ITM ON(A.SETID_PRODUCT = ITM.SETID AND A.PRODUCT_ID = ITM.PRODUCT_ID) LEFT OUTER JOIN PS_RC_CATEGORY_TBL CTG ON (A.SETID_CATEGORY = CTG.SETID AND A.RC_CATEGORY = CTG.RC_CATEGORY)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code

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

5 RC_DESCR_SS Character(30) VARCHAR2(30) NOT NULL Description to be shown on Self-Service Pages

6 SETID_SOURCE Character(5) VARCHAR2(5) NOT NULL MOC SETID Field

7 RC_SOURCE Character(5) VARCHAR2(5) NOT NULL Case Source How this case origianated

8 RC_SOURCE_DESCR Character(30) VARCHAR2(30) NOT NULL Case source description

9 GLOBAL_FLAG Character(1) VARCHAR2(1) NOT NULL Global Case flag for relationship

10 SIN Character(40) VARCHAR2(40) NOT NULL This field is used to represent the Site Identification Number

11 SETID_PROD_GRP Character(5) VARCHAR2(5) NOT NULL Product Group setid field

12 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group

13 RC_PROD_GRP_DESCR Character(30) VARCHAR2(30) NOT NULL Product group description

14 SETID_PRODUCT Character(5) VARCHAR2(5) NOT NULL Product SetID

15 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

16 PRODUCT_DESCR Character(30) VARCHAR2(30) NOT NULL Product Description

17 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)

18 SETID_CATEGORY Character(5) VARCHAR2(5) NOT NULL Field used to hold the Setid of a Category field for use in reports.

19 RC_CATEGORY Character(5) VARCHAR2(5) NOT NULL CallCenter Category. Used in HD.

20 CATEGORY_DESCR Character(30) VARCHAR2(30) NOT NULL Category Description field. Used in Text Tray

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 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

24 CASE_VISIBILITY Character(4) VARCHAR2(4) NOT NULL Field to capture the case visibility.
EXCL=Internal, exclude Case Contact
EXTL=External
INTL=Internal

25 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.

26 RC_SRCH_RSLT_CATG Character(1) VARCHAR2(1) NOT NULL Search result category
C=Case
K=Known Issue

27 RC_DESCRLONG Long Character CLOB Long description used in CallCenter for Problem, Solution...

28 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

29 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

30 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

31 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

32 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.

33 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
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	DISP_TMPL_FAM_CD	Character(30)	VARCHAR2(30) NOT NULL	Display Template Family Code
4	RC_STATUS	Character(5)	VARCHAR2(5) NOT NULL	Case Status
5	RC_DESCR_SS	Character(30)	VARCHAR2(30) NOT NULL	Description to be shown on Self-Service Pages
6	SETID_SOURCE	Character(5)	VARCHAR2(5) NOT NULL	MOC SETID Field
7	RC_SOURCE	Character(5)	VARCHAR2(5) NOT NULL	Case Source How this case origianated
8	RC_SOURCE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Case source description
9	GLOBAL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Global Case flag for relationship
10	SIN	Character(40)	VARCHAR2(40) NOT NULL	This field is used to represent the Site Identification Number
11	SETID_PROD_GRP	Character(5)	VARCHAR2(5) NOT NULL	Product Group setid field
12	PRODUCT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	PRoduct Group
13	RC_PROD_GRP_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Product group description
14	SETID_PRODUCT	Character(5)	VARCHAR2(5) NOT NULL	Product SetID
15	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
16	PRODUCT_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Product Description
17	INST_PROD_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the installed product ID (key field)
18	SETID_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Field used to hold the Setid of a Category field for use in reports.
19	RC_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	CallCenter Category. Used in HD.
20	CATEGORY_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Category Description field. Used in Text Tray
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	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
24	CASE_VISIBILITY	Character(4)	VARCHAR2(4) NOT NULL	Field to capture the case visibility. EXCL=Internal, exclude Case Contact EXTL=External INTL=Internal
25	RC_SUMMARY	Character(80)	VARCHAR2(80) NOT NULL	Typically a summary of a long field.
26	RC_SRCH_RSLT_CATG	Character(1)	VARCHAR2(1) NOT NULL	Search result category C=Case K=Known Issue
27	RC_DESCRLONG	Long Character	CLOB	Long description used in CallCenter for Problem, Solution...
28	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
29	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
30	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
31	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
32	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.
33	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time