SETIDEFFDTDefault Value: %date
LM_ROLE_PROF_VW(SQL View) |
Index Back |
|---|---|
Non Person Profile ViewNon Person Profile View |
| SELECT A.SETID , E.EFFDT , A.LM_RLAT_NAME , A.LM_RLAT_KEY1 , C.LM_PROFILE_ID , D.LM_CAT_TYPE , E.LM_CAT_ITEM_ID , E.LM_CAT_ITEM_QUAL , E.LM_RATING_MODEL , E.LM_REVIEW_RATING FROM PS_LM_PROF_RVAL A , PS_LM_JP_TYPES B , PS_LM_PROFILES C , PS_LM_PROFILE_CAT D , PS_LM_PROFILE_ITEM E WHERE A.LM_PROFILE_ID = C.LM_PROFILE_ID AND A.LM_PROFILE_ID = D.LM_PROFILE_ID AND A.LM_PROFILE_ID = E.LM_PROFILE_ID AND B.LM_JP_TYPE = C.LM_JP_TYPE AND B.LM_JP_TYPE = 'ROLE' AND D.LM_CAT_TYPE = E.LM_CAT_TYPE AND D.LM_CAT_TYPE = 'COMPETENCY' AND B.LM_PROFILE_USAGE = 'J' AND A.LM_JP_RLAT_TYPE = 'PIDO' AND B.EFFDT=( SELECT MAX(F.EFFDT) FROM PS_LM_JP_TYPES F WHERE B.LM_JP_TYPE=F.LM_JP_TYPE AND F.EFFDT<=%CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | LM_RLAT_NAME | Character(30) | VARCHAR2(30) NOT NULL | Relationship Name |
| 4 | LM_RLAT_KEY1 | Character(30) | VARCHAR2(30) NOT NULL | Rlat Key |
| 5 | LM_PROFILE_ID | Character(12) | VARCHAR2(12) NOT NULL | Profile ID |
| 6 | LM_CAT_TYPE | Character(12) | VARCHAR2(12) NOT NULL | Category Type |
| 7 | LM_CAT_ITEM_ID | Character(15) | VARCHAR2(15) NOT NULL | Category Item field |
| 8 | LM_JP_QUAL_SET | Character(12) | VARCHAR2(12) NOT NULL | Qualifier Set |
| 9 | LM_RATING_MODEL | Character(4) | VARCHAR2(4) NOT NULL | Used in Competency Sync messages |
| 10 | LM_REVIEW_RATING | Character(1) | VARCHAR2(1) NOT NULL | REview points for Rating models from HRMS |