RC_CASE_SW_VW

(SQL View)
 Index Back

Support Cases

Case view used for Support Vertical. Shows problem summary and Business Unit for a specific case.

SELECT CASE_ID , RC_SUMMARY ,BUSINESS_UNIT FROM PS_RC_CASE WHERE RC_VERTICAL = 'SW'

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

Default Value: 999999999999999

2 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT

Prompt Table: SP_BU_RC_NONVW