EP_J_CAT_ITEM_I(SQL View) |
Index Back |
---|---|
Catalog Items: Item MapePerformance Interface view for JPM Catalog Items. Used to map the fields in the JPM Catalog Item record to the fields used as ePerformance Items. |
SELECT A.JPM_CAT_TYPE , A.JPM_CAT_ITEM_ID , A.EFFDT , A.EFF_STATUS , %Substring(A.JPM_DESCR90, 1, 60) , A.RATING_MODEL , A.JPM_DATE_1 , A.JPM_DATE_2 , A.JPM_TEXT1325_1 , A.JPM_TEXT1325_2 FROM PS_JPM_CAT_ITEMS_I A WHERE A.JPM_DESCR90 <> ' ' AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_JPM_CAT_ITEMS_I A1 WHERE A1.JPM_CAT_TYPE = A.JPM_CAT_TYPE AND A1.JPM_CAT_ITEM_ID = A.JPM_CAT_ITEM_ID AND A1.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' |
# | 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_ITEM_ID | Character(12) | VARCHAR2(12) NOT NULL | Item unique identifier |
3 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
5 | EP_TITLE | Character(60) | VARCHAR2(60) NOT NULL | Title of an item |
6 | RATING_MODEL | Character(4) | VARCHAR2(4) NOT NULL | Rating Model |
7 | EP_ITEM_DUE_DT | Date(10) | DATE | Date that an item is due. |
8 | EP_ITEM_REMIND_DT | Date(10) | DATE | Date to remind an item is due. |
9 | EP_DESCR254 | Long Character(1325) | VARCHAR2(1325) | 1325 character description field used in ePerformance |
10 | EP_MEASURE | Long Character(1325) | VARCHAR2(1325) | 1325 Character Item measurement description |