EP_J_ITEM_CAT_TYPEEP_J_JP_TYPEEP_J_PROFILE_IDEP_J_JP_ID_I(SQL View) |
Index Back |
|---|---|
Profile IDs |
| SELECT B.JPM_CAT_TYPE , A.JPM_JP_TYPE , C.JPM_PROFILE_ID , C.DESCR FROM PS_JPM_JP_TYPES_I A , PS_JPM_JP_SECTION B , PS_JPM_PROFILE C WHERE A.JPM_JP_TYPE = B.JPM_JP_TYPE AND A.JPM_JP_TYPE = C.JPM_JP_TYPE AND %EffdtCheck(JPM_JP_TYPES_I, A, %CurrentDateIn) AND %EffdtCheck(JPM_JP_SECTION, B, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EP_J_ITEM_CAT_TYPE |
Character(12) | VARCHAR2(12) NOT NULL | ePerformance specific version of the JPM Catalog Type field. |
| 2 | EP_J_JP_TYPE |
Character(12) | VARCHAR2(12) NOT NULL | ePerformance specific field for Profile Type |
| 3 | EP_J_PROFILE_ID |
Character(12) | VARCHAR2(12) NOT NULL | Profile ID |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |