RC_SOLN_REL_VW(SQL View) |
Index Back |
---|
SELECT A.SETID , A.SOLUTION_ID , C.SOLN_RELATE_TYPE , C.SOLUTION_ID , C.SOLUTION_ID_RLTD , C.ROW_ADDED_DTTM FROM PS_RC_SOLUTION A , PS_RC_SOLN_RLT_TBL B , PS_RC_SOLN_RELATED C WHERE ((A.SOLUTION_ID = C.SOLUTION_ID) OR (A.SOLUTION_ID = C.SOLUTION_ID_RLTD)) AND B.SOLN_RELATE_TYPE = C.SOLN_RELATE_TYPE |
# | 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 |
3 | SOLN_RELATE_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Solution Relationship Type
Prompt Table: RC_SOLN_RLT_TBL |
4 | RC_SOLN_ID_PARENT | Number(15,0) | DECIMAL(15) NOT NULL | Parent Solution ID |
5 | SOLUTION_ID_RLTD | Number(15,0) | DECIMAL(15) NOT NULL | Solution ID |
6 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |