SETIDDefault Value: OPR_DEF_TBL_RB.SETID
Prompt Table: SP_SETID_NONVW
SOLUTION_IDDefault Value: 999999999999999
RBT_TRBSOLDT_VW(SQL View) |
Index Back |
|---|
| SELECT A.SETID ,A.SOLUTION_ID ,A.SYMPTOM_DESCR ,A.SOLUTION_DESCR ,A.ROW_LASTMANT_DTTM 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.
Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW |
| 2 | SOLUTION_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
Solution ID
Default Value: 999999999999999 |
| 3 | SYMPTOM_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Symptom Description |
| 4 | SOLUTION_DESCR | Long Character | CLOB | Solution Description |
| 5 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |