JPM_SRCH_CFG(SQL Table) |
Index Back |
|---|---|
JPM Search Configuration |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OBJECTOWNERID |
Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 2 | JPM_SRCH_SUB_ID |
Character(4) | VARCHAR2(4) NOT NULL | Sub Application Id |
| 3 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | JPM_SOURCE_JP | Character(12) | VARCHAR2(12) NOT NULL |
Source Profile
Prompt Table: JPM_IDX_TYPE_VW |
| 6 | JPM_TARGET_JP | Character(12) | VARCHAR2(12) NOT NULL |
Target Profile
Prompt Table: JPM_IDX_TYPE_VW |
| 7 | JPM_DISPLAY_MAX | Number(4,0) | SMALLINT NOT NULL |
Search Display Maximum
Default Value: 10 |
| 8 | JPM_SRCH_NAME | Character(50) | VARCHAR2(50) NOT NULL | Search Name |
| 9 | JPM_CRITERIA_RULE | Character(1) | VARCHAR2(1) NOT NULL |
Search Criteria Rule
A=No Default, Display (Adhoc) D=Default and Display N=Default, No Display Default Value: A |
| 10 | JPM_SRCH_ALGORITHM | Character(4) | VARCHAR2(4) NOT NULL |
Search Algorithm
1=Ratings in excess get < 100% 2=Ratings in excess get 100% Default Value: 1 |
| 11 | SYSTEM_DATA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Default Value: N |