RC_RESOLUT_VW

(SQL View)
Index Back

Resolutions

Cases that are resolved, have resolutions

SELECT A.CASE_ID , A.BUSINESS_UNIT , A.RSLN_SEQ_NBR , A.SOLUTION_ID , A.RSLN_SUMMARY , A.RSLN_STATE , A.ROW_ADDED_DTTM , A.ROW_ADDED_OPRID , A.ROW_LASTMANT_DTTM , A.ROW_LASTMANT_OPRID FROM PS_RC_RESOLUTION A

# 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: RC_CASE.CASE_ID

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

Default Value: RC_CASE.BUSINESS_UNIT

3 RSLN_SEQ_NBR Number(8,0) INTEGER NOT NULL Resolution Sequence Number

Default Value: 1

4 SOLUTION_ID Number(15,0) DECIMAL(15) NOT NULL Solution ID

Prompt Table: RC_SOLUTION_VW

5 RSLN_SUMMARY Character(80) VARCHAR2(80) NOT NULL Resolution Summary
6 RSLN_STATE Character(1) VARCHAR2(1) NOT NULL Resolution Status for Call Center application.
0=Viewed
1=Successful Resolution
2=Waiting on Customer
3=In Consideration
4=Failed Resolution
5=Withdrawn

Default Value: 3

7 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
8 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
9 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
10 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.