RC_CASE_CLS_VW3

(SQL View)
Index Back

case class view

case class view - case security class view.

SELECT A.CASE_ID , A.BUSINESS_UNIT , A.GLOBAL_FLAG , A.BO_ID_CUST , A.DISP_TMPL_FAM_CD ,A.PRODUCT_ID , A.CREATION_DATE , O.OPRID FROM PS_RC_CASE A , PS_SEC_BU_CLS F , PSOPRDEFN O WHERE A.BUSINESS_UNIT = F.BUSINESS_UNIT AND F.OPRCLASS = O.ROWSECCLASS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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.
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 GLOBAL_FLAG Character(1) VARCHAR2(1) NOT NULL Global Case flag for relationship
4 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
5 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code
6 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
7 CREATION_DATE Date(10) DATE Creation date of the case.
8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).