LIBRARY_SETIDDefault Value: OPR_DEF_TBL_RB.SETID
Prompt Table: SP_SETID_OPRVW
LIBRARY_IDY/N Table Edit
Default Value: N
Y/N Table Edit
RC_SOLNLIB_VW(SQL View) |
Index Back |
|---|---|
Solutions LibrariesSolution Libraries are a way to organize your solutions. A solution can have one or many libraries. |
| SELECT SETID , LIBRARY_ID , LIBRARY_NAME , LIBRARY_DESCR , SEARCHABLE_IND , DEFAULT_IND FROM PS_RC_SOLN_LIB_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LIBRARY_SETID |
Character(5) | VARCHAR2(5) NOT NULL |
This is the field for solution library setid value.
Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_OPRVW |
| 2 | LIBRARY_ID |
Character(5) | VARCHAR2(5) NOT NULL | Solution Library ID or Troubleshooting Guide ID |
| 3 | LIBRARY_NAME | Character(30) | VARCHAR2(30) NOT NULL | Library Name |
| 4 | LIBRARY_DESCR | Character(254) | VARCHAR2(254) NOT NULL | solution setup - field to contain the description of the library |
| 5 | SEARCHABLE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Setting to determine if a library is searchable in Solution Advisor
Y/N Table Edit Default Value: N |
| 6 | DEFAULT_IND | Character(1) | VARCHAR2(1) NOT NULL |
Default Election
Y/N Table Edit |