RC_SOLN_RLT_SVW

(SQL View)
Index Back

Related Solution View for SS

Related Solution View for SS. Copied from RC_SOLN_RLT_VW

SELECT C.SETID , A.SOLUTION_ID , C.SOLUTION_ID , A.SOLN_RELATE_TYPE , B.RELATIONSHIP_NAME , C.RC_SUMMARY , A.LINK_SOURCE , A.ROW_ADDED_DTTM FROM PS_RC_SOLN_RELATED A , PS_RC_SOLN_RLT_TBL B , PS_RC_SOLUTION C WHERE A.SOLUTION_ID_RLTD = C.SOLUTION_ID AND A.SOLN_RELATE_TYPE = B.SOLN_RELATE_TYPE AND C.RC_SOLN_VISIBILITY = 'A'

# 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.
2 SOLUTION_ID Number(15,0) DECIMAL(15) NOT NULL Solution ID

Default Value: 999999999999999

3 SOLUTION_ID_RLTD Number(15,0) DECIMAL(15) NOT NULL Solution ID
4 SOLN_RELATE_TYPE Character(5) VARCHAR2(5) NOT NULL Solution Relationship Type
5 RELATIONSHIP_NAME Character(30) VARCHAR2(30) NOT NULL Relationship field to store relationship value
6 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.
7 LINK_SOURCE Character(4) VARCHAR2(4) NOT NULL Link Source
MAN=Manual
SYS=System
8 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.