RC_CASE_DTL_VW

(SQL View)
 Index Back

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 , STAT.RC_DESCR_SS , SSRC.SETID , A.RC_SOURCE , A.GLOBAL_FLAG , A.SIN , SPGRP.SETID , A.PRODUCT_GROUP , SPROD.SETID , A.PRODUCT_ID , A.INST_PROD_ID , SCATG.SETID , A.RC_CATEGORY , A.RC_TYPE , A.RC_DETAIL , A.SECURE_CASE_FLG , A.CASE_VISIBILITY , A.RC_SUMMARY , A.RC_DESCRLONG , %subrec(RB_AUDIT_SBR, A) FROM PS_RC_CASE A , PS_SET_CNTRL_REC SCTL , PS_RC_STATUS_TBL STAT , PS_SET_CNTRL_REC SSRC , PS_SET_CNTRL_REC SPGRP , PS_SET_CNTRL_REC SPROD , PS_SET_CNTRL_REC SCATG WHERE A.SECURE_CASE_FLG IN (' ', 'N') AND A.BUSINESS_UNIT = SCTL.SETCNTRLVALUE AND SCTL.RECNAME = 'RC_STATUS_TBL' AND SCTL.SETID = STAT.SETID AND A.RC_STATUS = STAT.RC_STATUS AND A.BUSINESS_UNIT = SSRC.SETCNTRLVALUE AND SSRC.RECNAME = 'RC_SOURCE_TBL' AND A.BUSINESS_UNIT = SPGRP.SETCNTRLVALUE AND SPGRP.RECNAME = 'PROD_GROUP_TBL' AND A.BUSINESS_UNIT = SPROD.SETCNTRLVALUE AND SPROD.RECNAME = 'PROD_ITEM' AND A.BUSINESS_UNIT = SCATG.SETCNTRLVALUE AND SCATG.RECNAME = 'RC_CATEGORY_TBL'

# 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 GLOBAL_FLAG Character(1) VARCHAR2(1) NOT NULL Global Case flag for relationship
9 SIN Character(40) VARCHAR2(40) NOT NULL This field is used to represent the Site Identification Number
10 SETID_PROD_GRP Character(5) VARCHAR2(5) NOT NULL Product Group setid field
11 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group
12 SETID_PRODUCT Character(5) VARCHAR2(5) NOT NULL Product SetID
13 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
14 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)
15 SETID_CATEGORY Character(5) VARCHAR2(5) NOT NULL Field used to hold the Setid of a Category field for use in reports.
16 RC_CATEGORY Character(5) VARCHAR2(5) NOT NULL CallCenter Category. Used in HD.
17 RC_TYPE Character(5) VARCHAR2(5) NOT NULL Specialty type. Used on HD case.
18 RC_DETAIL Character(5) VARCHAR2(5) NOT NULL Detail field on HD Case. Used in Quick Code.
19 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
20 CASE_VISIBILITY Character(4) VARCHAR2(4) NOT NULL Field to capture the case visibility.
EXCL=Internal, exclude Case Contact
EXTL=External
INTL=Internal
21 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.
22 RC_DESCRLONG Long Character CLOB Long description used in CallCenter for Problem, Solution...
23 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
24 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
25 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
26 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
27 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.
28 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time