JPM_JP_TYPEJPM_CAT_TYPEJPM_CAT_ITEM_QUAL2LANGUAGE_CDJPM_JP_EELN_VW2(SQL View) |
Index Back |
|---|---|
JPM Qual ViewJPM Qual View |
| SELECT S.JPM_JP_TYPE , I.JPM_CAT_TYPE , I.JPM_CAT_ITEM_QUAL , I.LANGUAGE_CD , I.DESCR FROM PS_JPM_JP_QINS_LNG I , PS_JPM_JP_SECTION S WHERE I.JPM_CAT_TYPE = S.JPM_CAT_TYPE AND I.JPM_JP_QUAL_SET = S.JPM_JP_QUAL_SET2 AND %EffdtCheck(JPM_JP_TYPES T, S, %CurrentdateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | JPM_JP_TYPE |
Character(12) | VARCHAR2(12) NOT NULL | Profile Type name for a JPM Profile Type |
| 2 | 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. |
| 3 | JPM_CAT_ITEM_QUAL2 |
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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |