RBT_TBL_SOL_VW(SQL View) |
Index Back |
---|
SELECT A.SETID ,A.SOLUTION_ID ,A.LIBRARY_ID ,A.SYMPTOM_DESCR ,A.EXPIRY_DATE FROM PS_RC_SOLUTION A , PS_RC_SOLN_LIB_TBL B , PS_RC_SOLN_LIB_LIB C WHERE A.SETID=B.SETID AND A.LIBRARY_ID=B.LIBRARY_ID AND B.SEARCHABLE_IND='Y' AND B.LIBRARY_ID=C.LIBRARY_ID AND C.DEFAULT_LIBRARY_ID='TROUB' AND A.EXPIRY_IND <> 'Y' AND A.SOLN_STATUS NOT IN ( 'EXPR','SUPR') AND A.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.
Prompt Table: SP_SETID_NONVW |
2 | SOLUTION_ID | Number(15,0) | DECIMAL(15) NOT NULL | Solution ID |
3 | LIBRARY_ID | Character(5) | VARCHAR2(5) NOT NULL |
Solution Library ID or Troubleshooting Guide ID
Prompt Table: RC_SOLN_LIB_TBL |
4 | SYMPTOM_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Symptom Description |
5 | EXPIRY_DATE | Date(10) | DATE | Expiry Date |