SETIDSOLUTION_IDDefault Value: 999999999999999
SOLUTION_ID_RLTDLANGUAGE_CDRC_SOLN_RL_VLNG(SQL View) |
Index Back |
|---|
| SELECT C.SETID , A.SOLUTION_ID , C.SOLUTION_ID , D.LANGUAGE_CD , E.RELATIONSHIP_NAME , D.RC_SUMMARY FROM PS_RC_SOLN_RELATED A , PS_RC_SOLN_RLT_TBL B , PS_RC_SOLUTION C , PS_RC_SOLUTION_LNG D , PS_RC_SOLN_RLT_LNG E WHERE A.SOLUTION_ID_RLTD = C.SOLUTION_ID AND A.SOLN_RELATE_TYPE = B.SOLN_RELATE_TYPE AND B.SOLN_RELATE_TYPE = E.SOLN_RELATE_TYPE AND C.SOLUTION_ID = D.SOLUTION_ID AND C.SETID = D.SETID AND D.LANGUAGE_CD = E.LANGUAGE_CD |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 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. |