EP_J_PROFILE_IDEP_J_ITEM_CAT_TYPEEP_ITEM_IDEFFDTDefault Value: %date
LANGUAGE_CDA=Active
I=Inactive
Default Value: A
Prompt Table: REVW_RATING_TBL
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
EP_J_JP_IT_L_I(SQL View) |
Index Back |
|---|---|
Profile Items: Item Map RLangePerformance Interface view for JPM Profile Items Related Language record. Used to map the fields in the JPM Profile Item record to the fields used as ePerformance Items. |
| SELECT A.JPM_PROFILE_ID , A.JPM_CAT_TYPE , A.JPM_CAT_ITEM_ID , A.EFFDT , B.LANGUAGE_CD , A.EFF_STATUS , %Substring(B.JPM_DESCR90, 1, 60) , A.RATING_MODEL , A.JPM_RATING1 , A.JPM_DATE_1 , A.JPM_DATE_2 , A.JPM_PCT_1 , A.JPM_PCT_2 , A.JPM_MANDATORY , A.JPM_YN_1 , B.JPM_TEXT1325_1 , B.JPM_TEXT1325_2 FROM PS_JPM_JP_ITEM_VW2 A , PS_JPM_CAT_ITM_L_I B WHERE A.JPM_CAT_TYPE = B.JPM_CAT_TYPE AND A.JPM_CAT_ITEM_ID = B.JPM_CAT_ITEM_ID AND A.JPM_PARENT_KEY_ID = 0 AND %EffdtCheck(JPM_CAT_ITM_L_I, B, A.EFFDT) AND B.JPM_DESCR90 <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EP_J_PROFILE_ID |
Character(12) | VARCHAR2(12) NOT NULL | Profile ID |
| 2 | EP_J_ITEM_CAT_TYPE |
Character(12) | VARCHAR2(12) NOT NULL | ePerformance specific version of the JPM Catalog Type field. |
| 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 7 | EP_TITLE | Character(60) | VARCHAR2(60) NOT NULL | Title of an item |
| 8 | RATING_MODEL | Character(4) | VARCHAR2(4) NOT NULL | Rating Model |
| 9 | EP_TARGET_RATING | Character(1) | VARCHAR2(1) NOT NULL |
Target Rating Field
Prompt Table: REVW_RATING_TBL |
| 10 | EP_ITEM_DUE_DT | Date(10) | DATE | Date that an item is due. |
| 11 | EP_ITEM_REMIND_DT | Date(10) | DATE | Date to remind an item is due. |
| 12 | EP_WEIGHT | Number(3,0) | SMALLINT NOT NULL | Weight factor |
| 13 | EP_MIN_WEIGHT | Number(3,0) | SMALLINT NOT NULL | Minumum weight used (percentage) |
| 14 | EP_ITEM_MANDTRY_SW | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the mandatory field is available
Y/N Table Edit Default Value: N |
| 15 | EP_ITEM_CRIT_SW | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the critical field is available
Y/N Table Edit Default Value: N |
| 16 | EP_DESCR254 | Long Character(1325) | VARCHAR2(1325) | 1325 character description field used in ePerformance |
| 17 | EP_MEASURE | Long Character(1325) | VARCHAR2(1325) | 1325 Character Item measurement description |