RC_SOLNATHSS_VW (SQL View)	Index Back
Solution Attachments Solution Attachment View used in Self Service Solution Search

RC_SOLNATHSS_VW

(SQL View)

Solution Attachments

Solution Attachment View used in Self Service Solution Search

SELECT SETID , SOLUTION_ID , NOTE_SEQ_NBR , ATTACH_SEQ_NBR FROM PS_RC_SOLN_ATTACH A WHERE EXISTS ( SELECT 'X' FROM PS_RC_SOLN_NOTE B WHERE A.SETID = B.SETID AND A.SOLUTION_ID = B.SOLUTION_ID AND A.NOTE_SEQ_NBR = B.NOTE_SEQ_NBR AND RC_VISIBILITY <> 'I')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
Prompt Table: SP_SETID_NONVW

2 SOLUTION_ID Number(15,0) DECIMAL(15) NOT NULL Solution ID
Prompt Table: RC_SOLUTION

3 NOTE_SEQ_NBR Number(6,0) INTEGER NOT NULL Note ID
Prompt Table: RC_SOLN_NOTE

4 ATTACH_SEQ_NBR Number(6,0) INTEGER NOT NULL Attachment Sequence Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Prompt Table: SP_SETID_NONVW
2	SOLUTION_ID	Number(15,0)	DECIMAL(15) NOT NULL	Solution ID Prompt Table: RC_SOLUTION
3	NOTE_SEQ_NBR	Number(6,0)	INTEGER NOT NULL	Note ID Prompt Table: RC_SOLN_NOTE
4	ATTACH_SEQ_NBR	Number(6,0)	INTEGER NOT NULL	Attachment Sequence Number