RC_RSLN_NOTE_VW

(SQL View)
 Index Back

Resolution Notes

This view shows notes tied to the resolution table on call center case component.

SELECT A.BUSINESS_UNIT , A.CASE_ID , A.RSLN_SEQ_NBR , B.NOTE_SEQ_NBR , B.RC_SUMMARY , B.RC_VISIBILITY , B.ROW_ADDED_DTTM , B.ROW_ADDED_OPRID FROM PS_RC_RESOLUTION A , PS_RC_CASE_NOTE B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.CASE_ID = B.CASE_ID AND A.RSLN_SEQ_NBR = B.RSLN_SEQ_NBR

# 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 RSLN_SEQ_NBR Number(8,0) INTEGER NOT NULL Resolution Sequence Number
4 NOTE_SEQ_NBR Number(6,0) INTEGER NOT NULL Note ID
5 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.
6 RC_VISIBILITY Character(4) VARCHAR2(4) NOT NULL Case Visibility, used for cases and case objects/attributes.
A=All
I=Internal
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.