EP_J_ITEM_CAT_TYPEEP_J_CONTENT_GRP_TEP_ITEM_IDEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
EPO_JCAT_IT_GTY(SQL View) |
Index Back |
|---|---|
Catalog Items-Content GrpTypeePerformance Objective Management Interface view for JPM Catalog Items. Used to map the fields in the JPM Catalog Item record to the fields used as Objective Management Items. This view lists items that belong to a Content Group Type. |
| SELECT A.JPM_CAT_TYPE ,B.JPM_CAT_GROUP_TYPE , A.JPM_CAT_ITEM_ID , A.EFFDT , A.EFF_STATUS , %Substring(A.JPM_DESCR90, 1, 60) , A.JPM_DATE_1 , A.JPM_TEXT1325_1 , A.JPM_TEXT1325_2 FROM PS_JPM_CAT_ITEMS_I A , PS_JPM_CAT_GMEMB B WHERE A.JPM_DESCR90 <> ' ' AND A.JPM_CAT_TYPE = B.JPM_CAT_TYPE AND A.JPM_CAT_ITEM_ID = B.JPM_CAT_ITEM_ID |
| # | 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_CONTENT_GRP_T |
Character(15) | VARCHAR2(15) NOT NULL | Content Group Type |
| 3 | EP_ITEM_ID |
Character(12) | VARCHAR2(12) NOT NULL | Item unique identifier |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 6 | EP_TITLE | Character(60) | VARCHAR2(60) NOT NULL | Title of an item |
| 7 | EP_ITEM_DUE_DT | Date(10) | DATE | Date that an item is due. |
| 8 | EP_DESCR254 | Long Character | CLOB | 1325 character description field used in ePerformance |
| 9 | EP_MEASURE | Long Character | CLOB | 1325 Character Item measurement description |