RC_RESOLUTION

(SQL Table)
Index Back

Resolution

Case Resolution Record for attempted solutions used on a case.

# 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
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 SOURCE_CASE_ID Number(15,0) DECIMAL(15) NOT NULL Source Case ID - Case ID where the resolution was copied from.
8 SOURCE_RSLN_SEQNBR Number(5,0) INTEGER NOT NULL Source Resolution Sequence Number - Resolution Number of the Case/Resolution where the resolution was copied from.
9 NEW_SOLUTION_ID Number(15,0) DECIMAL(15) NOT NULL Superceding Solution ID
10 USAGE_COUNT Number(8,0) INTEGER NOT NULL Counter of how often this row was selected in a Search Results page and marked as 'Used'. Usage Count is incremented by the USAGE_INCREMENT amount on the Search Setup Parameters page each time the row is 'Used'.

Default Value: 0

11 LAST_USAGE_DTTM DateTime(26) TIMESTAMP Used to identify last time the record was marked 'Used' in a Search result
12 RC_SOLVED_COUNT Number(6,0) INTEGER NOT NULL Solved Count Field in Solution
13 RC_RSLN_SOURCE Character(1) VARCHAR2(1) NOT NULL Resolution Source
1=Solution ID
2=Frequently Used Solutions
3=Independent Text Solutions
4=Solution Advisor
5=Self Service
6=Cascade
7=Copy
8=Problem Solving Technique
14 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
15 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
16 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
17 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
18 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.
19 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
20 RSLN_NOTES Long Character CLOB Resolution Notes