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
Default Value: HJPM |
| 2 | JPM_SRCH_SUB_ID |
Character(4) | VARCHAR2(4) NOT NULL |
Sub Application Id
SP=Succession Planning |
| 3 | JPM_SRCH_ID |
Character(18) | VARCHAR2(18) NOT NULL | Search Id |
| 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(100) | VARCHAR2(100) 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_RANK_MTHD | Character(1) | VARCHAR2(1) NOT NULL |
Rating Relevancy
F=Closest Fit R=Relative to Person Rating Default Value: F |
| 11 | JPM_DISP_EMPLID | Character(1) | VARCHAR2(1) NOT NULL |
Empl ID
Y/N Table Edit Default Value: Y |
| 12 | JPM_DISP_INT_LIST | Character(1) | VARCHAR2(1) NOT NULL |
Add to Interest List Button
Y/N Table Edit Default Value: N |
| 13 | JPM_CSC_PCFG_ID | Character(10) | VARCHAR2(10) NOT NULL |
Person Compare ID
Prompt Table: JPM_CSC_PCFG_VW |
| 14 | JPM_CSC_NPCFG_ID | Character(10) | VARCHAR2(10) NOT NULL |
Non-Person Compare ID
Prompt Table: JPM_CSC_NPCFG_V |
| 15 | 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 |