JOB_FAMILYEFFDTDefault Value: %date
JPM_JOBFM_PRF_I(SQL View) |
Index Back |
|---|---|
Job Family ViewView that contains Job Family and Jpm Profile ID |
| SELECT A.JOB_FAMILY ,A.EFFDT , B.JPM_PROFILE_ID ,' ' FROM PS_JOB_FAMILY_TBL A , PS_JPM_JP_X_RLAT_I B WHERE A.JOB_FAMILY=B.JPM_RLAT_KEY1 AND B.JPM_JP_TYPE='JOB' AND B.JPM_RLAT_NAME='JOB_FAMILY' AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_JPM_JP_X_RLAT_I C WHERE C.JPM_RLAT_NAME=B.JPM_RLAT_NAME AND C.JPM_JP_TYPE=B.JPM_JP_TYPE AND C.JPM_PROFILE_ID=B.JPM_PROFILE_ID AND C.JPM_RLAT_KEY1 = B.JPM_RLAT_KEY1 AND C.EFFDT <=%CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | JOB_FAMILY |
Character(6) | VARCHAR2(6) NOT NULL | Job Family |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | JOB_PROFILE_ID | Character(12) | VARCHAR2(12) NOT NULL | Job Profile ID |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |