EMPLIDPrompt Table: PERSON
JPM_PROFILE_IDPrompt Table: JPM_PROFILE
SETIDJPM_RLAT_KEY1HR_CP_EMPL_INT(SQL View) |
Index Back |
|---|---|
Employee Career InterestHR_CP_EMPL_INT is a view based on Employee Position and Job profile interest data. |
| SELECT A.EMPLID , A.JPM_PROFILE_ID , C.JPM_CAT_SETID , C.JPM_RLAT_KEY1 , D.JPM_KEY_RECNAME ,B.JPM_JP_TYPE , B.DESCR FROM PS_JPM_INTEREST A , PS_JPM_PROFILE B , PS_JPM_JP_X_RLAT C , PS_JPM_RLAT_CFG D WHERE A.JPM_PROFILE_ID = B.JPM_PROFILE_ID AND B.JPM_JP_PRFL_STATUS = 'A' AND A.JPM_PROFILE_ID = C.JPM_PROFILE_ID AND C.EFFDT = ( SELECT MAX(E.EFFDT) FROM PS_JPM_JP_X_RLAT E WHERE C.JPM_PROFILE_ID = E.JPM_PROFILE_ID AND C.JPM_CAT_SETID = E.JPM_CAT_SETID AND C.JPM_RLAT_KEY1 = E.JPM_RLAT_KEY1 AND C.JPM_RLAT_NAME = E.JPM_RLAT_NAME AND E.EFFDT <= %CurrentDateIn) AND C.EFF_STATUS = 'A' AND C.JPM_RLAT_NAME = D.JPM_RLAT_NAME AND D.JPM_KEY_RECNAME IN ('JOBCODE_TBL', 'POSITION_DATA') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | JPM_PROFILE_ID |
Character(12) | VARCHAR2(12) NOT NULL |
The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile.
Prompt Table: JPM_PROFILE |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | JPM_RLAT_KEY1 |
Character(30) | VARCHAR2(30) NOT NULL | Key value identifying the external data being related to JPM data. Example- Job Codes (external data) being related to a Profile of a Job (JPM data). |
| 5 | JPM_KEY_RECNAME | Character(15) | VARCHAR2(15) NOT NULL | JPM - Record Name |
| 6 | JPM_JP_TYPE | Character(12) | VARCHAR2(12) NOT NULL | Profile Type name for a JPM Profile Type |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |