HR_OWS_JPM_VW(SQL View) |
Index Back |
|---|---|
Person OWS JPM SkillsOracle Workforce Scheduling Person Skills from Job Profile Management |
| SELECT A.EMPLID , B.JPM_CAT_TYPE , B.JPM_CAT_ITEM_ID , B.JPM_CAT_ITEM_QUAL , B.JPM_CAT_ITEM_QUAL2 , B.EFFDT , A.JPM_JP_PRFL_STATUS , B.EFF_STATUS , B.JPM_JP_QUAL_SET , B.JPM_JP_QUAL_SET2 , B.RATING_MODEL , B.JPM_RATING1 , B.JPM_RATING2 , B.JPM_RATING3 , B.JPM_INTEREST_LEVEL FROM PS_JPM_PROFILE A , PS_JPM_JP_ITEMS_I B , PS_JPM_JP_PRI_TYPE C WHERE A.JPM_PROFILE_ID = B.JPM_PROFILE_ID AND A.JPM_JP_TYPE = C.JPM_PRI_PERS_TYPE AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX (B1.EFFDT) FROM PS_JPM_JP_ITEMS_I B1 WHERE B1.JPM_PROFILE_ID = B.JPM_PROFILE_ID AND B1.JPM_CAT_TYPE = B.JPM_CAT_TYPE AND B1.JPM_CAT_ITEM_ID = B.JPM_CAT_ITEM_ID AND B1.JPM_CAT_ITEM_QUAL = B.JPM_CAT_ITEM_QUAL AND B1.JPM_CAT_ITEM_QUAL2 = B.JPM_CAT_ITEM_QUAL2 AND B1.EFF_STATUS = 'A' AND B1.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 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.
Prompt Table: JPM_CAT_TYPES |
| 3 | JPM_CAT_ITEM_ID |
Character(12) | VARCHAR2(12) NOT NULL |
Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.
Prompt Table: JPM_CAT_ITMS_VW |
| 4 | 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).
Prompt Table: JPM_JP_QUAL_INS |
| 5 | 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).
Prompt Table: JPM_JP_QUAL_VW2 |
| 6 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 7 | JPM_JP_PRFL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status of JPM Profile
A=Active I=Inactive Default Value: A |
| 8 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 9 | JPM_JP_QUAL_SET | Character(12) | VARCHAR2(12) NOT NULL | 1st Instance Qualifier Set Name for a JPM Profile Item |
| 10 | JPM_JP_QUAL_SET2 | Character(12) | VARCHAR2(12) NOT NULL | 2nd Instance Qualifier Set Name for a JPM Profile Item |
| 11 | RATING_MODEL | Character(4) | VARCHAR2(4) NOT NULL |
Rating Model
Prompt Table: RATING_MDL_TBL |
| 12 | JPM_RATING1 | Character(1) | VARCHAR2(1) NOT NULL | Generic rating field generally prompted by RATING_MODEL |
| 13 | JPM_RATING2 | Character(1) | VARCHAR2(1) NOT NULL | Generic rating field generally prompted by RATING_MODEL |
| 14 | JPM_RATING3 | Character(1) | VARCHAR2(1) NOT NULL | Generic rating field generally prompted by RATING_MODEL |
| 15 | JPM_INTEREST_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Profile item property stating intertest level of the employee in the content item
Prompt Table: INT_RATING_VW |