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 B , PS_JPM_PROFILE C WHERE C.JPM_PROFILE_ID = B.JPM_PROFILE_ID AND A.JOB_FAMILY=B.JPM_RLAT_KEY1 AND C.JPM_JP_TYPE='JOB' AND B.JPM_RLAT_NAME='JOB_FAMILY' AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_JPM_JP_X_RLAT B1 WHERE B1.JPM_RLAT_NAME=B.JPM_RLAT_NAME AND B1.JPM_PROFILE_ID=B.JPM_PROFILE_ID AND B1.JPM_RLAT_KEY1 = B.JPM_RLAT_KEY1 AND B1.EFFDT <=%CurrentDateIn) AND B.EFF_STATUS='A' |
| # | 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 |