SRCH_TYPE_CDD=Daily Summarization
M=No Summarization
N=No Availability Calculation
Default Value: N
Default Value: 300
Default Value: 21
RS_SRCH_HDR(SQL Table) |
Index Back |
|---|---|
Search - Configuration |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SRCH_TYPE_CD |
Character(5) | VARCHAR2(5) NOT NULL | Search Type |
| 2 | SRCH_VERITY_IDX | Character(18) | VARCHAR2(18) NOT NULL | Key Field |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | SRCH_STY_LOCATION | Character(100) | VARCHAR2(100) NOT NULL | Style Files |
| 5 | SRCH_RESUME_LOC | Character(100) | VARCHAR2(100) NOT NULL | Resume Files |
| 6 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL | Product ChartField |
| 7 | AVA_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Availability Method
D=Daily Summarization M=No Summarization N=No Availability Calculation Default Value: N |
| 8 | VERITY_MODEL | Character(1) | VARCHAR2(1) NOT NULL | Model |
| 9 | SRCH_CREATION_DTTM | DateTime(26) | TIMESTAMP | Search Creation Date Time |
| 10 | SRCH_UPDATE_DTTM | DateTime(26) | TIMESTAMP | Search Update Date Time |
| 11 | RSLTSET_SIZE | Number(4,0) | SMALLINT NOT NULL |
Buffer Resultset Size(in rows)
Default Value: 300 |
| 12 | DAYSTOCACHE | Number(3,0) | SMALLINT NOT NULL |
Nbr of Days to store in cache
Default Value: 21 |
| 13 | DEBUG_CODE | Number(4,0) | SMALLINT NOT NULL | Debug Code for Panel Trace |