OBJECTOWNERIDJPM_SRCH_SUB_IDSP=Succession Planning
JPM_SRCH_IDJPM_CAT_TYPEJPM_TGT_FIELDNAMEPrompt Table: JPM_SRCHPRP_DVW
Y/N Table Edit
Default Value: Y
Default Value: N
JPM_SRCH_PROPS(SQL Table) |
Index Back |
|---|---|
Talent Mgmt-Property MapSeach Property Mapping |
| # | 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
SP=Succession Planning |
| 3 | JPM_SRCH_ID |
Character(18) | VARCHAR2(18) NOT NULL | Search Id |
| 4 | JPM_CAT_TYPE |
Character(12) | VARCHAR2(12) NOT NULL | The name of the type of items that will be used in a Catalog and or in a Profile. |
| 5 | JPM_TGT_FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Target field for a search compare |
| 6 | JPM_SRC_FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Source field for a search compare.
Prompt Table: JPM_SRCHPRP_DVW |
| 7 | JPM_LABEL_TEXT | Character(30) | VARCHAR2(30) NOT NULL | User defined text to be displayed as a label for a field or property within JPM User Interfaces. |
| 8 | JPM_SRCH_FLG | Character(1) | VARCHAR2(1) NOT NULL |
When ON indicates that the item, object or property is used during Search/Match processing.
Y/N Table Edit Default Value: Y |
| 9 | 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 |