JPM_CAT_TYPEJPM_JP_QUAL_SETJPM_CAT_ITEM_QUALY/N Table Edit
Default Value: Y
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: Y
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: Y
Y/N Table Edit
Default Value: N
JPM_JP_Q_INS_I(SQL View) |
Index Back |
|---|---|
JPM Instance Qual InterfaceJPM Instance Qualifier Interface view |
| SELECT JPM_CAT_TYPE , JPM_JP_QUAL_SET , JPM_CAT_ITEM_QUAL , SEQNO , DESCR , JPM_JP_EMP_VW_IND , JPM_JP_EMP_DEF_IND , JPM_JP_MGR_VW_IND , JPM_JP_MGR_DEF_IND , JPM_SRCH_FLG , SYSTEM_DATA_FLG FROM PS_JPM_JP_QUAL_INS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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. |
| 2 | JPM_JP_QUAL_SET |
Character(12) | VARCHAR2(12) NOT NULL | 1st Instance Qualifier Set Name for a JPM Profile Item |
| 3 | JPM_CAT_ITEM_QUAL |
Character(12) | VARCHAR2(12) NOT NULL | Low Order Item key for Catalog Items when appearing in a Profile. For most Catalog Types, this will be blank - but is available if an Item needs to have multiple instances for a given Effdt in a Profile. Example: for CatalogType = Compentency, there can be multiple instances for a particular Competency, each representing a different evaluation source (Self-Eval, Mgr Eval, Approved/Official, Learning, Recruiting). |
| 4 | SEQNO | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | JPM_JP_EMP_VW_IND | Character(1) | VARCHAR2(1) NOT NULL |
JPM - Employee View
Y/N Table Edit Default Value: Y |
| 7 | JPM_JP_EMP_DEF_IND | Character(1) | VARCHAR2(1) NOT NULL |
Employee Default
Y/N Table Edit Default Value: N |
| 8 | JPM_JP_MGR_VW_IND | Character(1) | VARCHAR2(1) NOT NULL |
JPM - Manager View
Y/N Table Edit Default Value: Y |
| 9 | JPM_JP_MGR_DEF_IND | Character(1) | VARCHAR2(1) NOT NULL |
JPM - Manager Default
Y/N Table Edit Default Value: N |
| 10 | 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 |
| 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.
Y/N Table Edit Default Value: N |