RC_SS_SOLNOTE_V

(SQL View)
 Index Back

Solutions and Notes view

The view used for combaining solution and notes in manage case component

SELECT a.case_id ,a.business_unit ,a.note_seq_nbr ,0 ,0 ,a.rc_note_type ,A.ROW_ADDED_DTTM ,A.ROW_ADDED_OPRID ,A.ROW_LASTMANT_DTTM FROM PS_RC_CASE_NOTE a WHERE A.RC_VISIBILITY <> 'I' UNION SELECT b.case_id ,b.business_unit ,0 ,b.rsln_seq_nbr ,b.solution_id ,'SOLN' ,B.ROW_ADDED_DTTM ,B.ROW_ADDED_OPRID ,B.ROW_LASTMANT_DTTM FROM ps_rc_resolution b

# 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

Prompt Table: RC_CASE

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

Default Value: RC_CASE.BUSINESS_UNIT

Prompt Table: SP_BU_RC_NONVW

3 NOTE_SEQ_NBR Number(6,0) INTEGER NOT NULL Note ID

Default Value: 1

4 RSLN_SEQ_NBR Number(8,0) INTEGER NOT NULL Resolution Sequence Number
5 SOLUTION_ID Number(15,0) DECIMAL(15) NOT NULL Solution ID
6 RC_NOTE_TYPE Character(5) VARCHAR2(5) NOT NULL Case Note Types

Prompt Table: RC_NOTETYPE_TBL

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.