RC_CASELIST_VW

(SQL View)
Index Back

Case list view

Case list view to display results when drillling on a chart.

SELECT BUSINESS_UNIT , CASE_ID , RC_SUMMARY , RC_PRIORITY , RC_STATUS FROM PS_RC_CASE

# 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 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.
4 RC_PRIORITY Character(5) VARCHAR2(5) NOT NULL Case Priority
5 RC_STATUS Character(5) VARCHAR2(5) NOT NULL Case Status