| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EP_APPRAISAL_ID |
Number(8,0) |
INTEGER NOT NULL |
Document ID
Prompt Table:
EP_APPR
|
| 2 |
EP_SECTION_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Section type
Prompt Table:
EP_SECTION_DEFN
|
| 3 |
EP_ROLE |
Character(8) |
VARCHAR2(8) NOT NULL |
Role unique identifier
Prompt Table:
EP_ROLE_TBL
|
| 4 |
EP_SEC_ROLE_RTD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the role for a section can rate items
Y/N Table Edit
Default Value: N
|
| 5 |
EP_ITEM_ROLE_RT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the role for a section can rate items
Y/N Table Edit
Default Value: N
|
| 6 |
EP_SUB_ROLE_RT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the role for a section can rate sub-items
Y/N Table Edit
Default Value: N
|
| 7 |
EP_RATING_OVRD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if ratings can be overriden
Y/N Table Edit
Default Value: N
|
| 8 |
EP_SEC_ROLE_WTD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the role for a section can weight items
Y/N Table Edit
Default Value: N
|
| 9 |
EP_ITEM_ROLE_WT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the role for a section can weight items
Y/N Table Edit
Default Value: N
|
| 10 |
EP_ITEM_ADD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if items can be added
Y/N Table Edit
Default Value: N
|
| 11 |
EP_ITEM_UPDATE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if items can be updated by a role for a specific section. This switch is used to lock down a document so it can't be updated (when = 'N').
Y/N Table Edit
Default Value: N
|
| 12 |
EP_SECTION_SUMM_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the section is a summary section
Y/N Table Edit
Default Value: N
|
| 13 |
EP_ITEM_RESULTS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the results field is available
Y/N Table Edit
Default Value: N
|
| 14 |
EP_SEC_WRT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag used to determine if results writer is used for a section and at what level it is used (competency or sub-competency)
C=Competency
N=Not Used
S=Sub-Competency
Default Value: N
|
| 15 |
EP_SEC_DEV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag used to determine if development tips are used for a section and at what level it is used (competency or sub-competency).
C=Competency
N=Not Used
S=Sub-Competency
Default Value: N
|
| 16 |
EP_SEC_WRT_OTH_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Switch used to determine if the section Writing Tool for Other Evaluator comments is enabled.
Y/N Table Edit
Default Value: N
|
| 17 |
EP_SEC_WRT_PRF_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Performance Notes
Y/N Table Edit
Default Value: N
|
| 18 |
EP_ITEM_WRT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag used to determine if results writer is used for a item and at what level it is used (competency or sub-competency)
C=Competency
N=Not Used
S=Sub-Competency
Default Value: N
|
| 19 |
EP_ITEM_DEV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if items have a link for development tips.
C=Competency
N=Not Used
S=Sub-Competency
Default Value: N
|
| 20 |
EP_ITEM_WRT_OTH_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Switch used to determine if the item Writing Tool for Other Evaluator comments is enabled.
Y/N Table Edit
Default Value: N
|
| 21 |
EP_ITEM_WRT_PRF_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Performance Notes
Y/N Table Edit
Default Value: N
|
| 22 |
EP_VIEW_OTHER_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if view other authors hyperlink is display on the performance review for a section.
Y/N Table Edit
Default Value: N
|
| 23 |
EP_RATING_LBL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the rating label is displayed
Y/N Table Edit
Default Value: N
|
| 24 |
EP_ITEM_UPD_JPM_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the item/sub-item content for a section should update the JPM Person Profile
Y/N Table Edit
Default Value: N
|
| 25 |
EP_J_UPD_JP_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
ePerformance specific field for Profile Type
Prompt Table:
EP_J_JP_PERS_I
|
| 26 |
EP_J_UPD_CAT_QUAL |
Character(12) |
VARCHAR2(12) NOT NULL |
ePerformance version of the JPM_CAT_ITEM_QUAL. Used to map values to the JPM_CAT_ITEM_QUAL field when updating JPM Profiles with ePerformance items.
Prompt Table:
EP_J_QUAL_VW
|
| 27 |
EP_CPY_OBJ_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N switch for ePerformance Template Role Rules to allow Objective Items to be copied to Evaluation Docs
Y/N Table Edit
Default Value: N
|
| 28 |
EP_CPY_MGR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N switch for ePerformance Section, to allow Items to be Copied from the Manager's Evaluation document
Y/N Table Edit
Default Value: N
|
| 29 |
EP_ITEM_DEL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N switch for ePerformance Section, to allow Items to be Deleted in the Evaluation document
Y/N Table Edit
Default Value: N
|
| 30 |
EP_EE_ROLE_RATE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
whether or not the role has the ability to have an Employee Rating during the Evaluation step
Y/N Table Edit
Default Value: N
|
| 31 |
EP_SEC_EE_CMNTS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
whether or not the role has the ability to have Employee Section Comments during the Evaluation Step
Y/N Table Edit
Default Value: N
|
| 32 |
EP_ITM_EE_CMNTS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
whether or not the role has the ability to have Employee Item Comments during the Evaluation step
Y/N Table Edit
Default Value: N
|
| 33 |
EP_HAS_EV_RULES_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Has Eval Role Rules
Default Value: Y
|
| 34 |
EP_CPY_ITMS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N switch for ePerformance Section, to allow Items to be Copied from another document
Y/N Table Edit
Default Value: N
|
| 35 |
EP_RATING_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if ratings can be overriden
Y/N Table Edit
Default Value: N
|
| 36 |
EP_SEC_CMT_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if ratings can be overriden
Y/N Table Edit
Default Value: N
|
| 37 |
EP_ITM_CMT_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if ratings can be overriden
Y/N Table Edit
Default Value: N
|
| 38 |
EP_ITEM_ADD_EC_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N switch for ePerformance Section, to allow Items to be Added in the Establish Criteria document
Y/N Table Edit
Default Value: N
|
| 39 |
EP_ITEM_UPD_EC_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N switch for ePerformance Section, to allow Items to be Updated in the Establish Criteria document
Y/N Table Edit
Default Value: N
|
| 40 |
EP_ITEM_DEL_EC_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N switch for ePerformance Section, to allow Items to be Deleted in the Establish Criteria document
Y/N Table Edit
Default Value: N
|
| 41 |
EP_CPY_OBJ_EC_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N switch for ePerformance Section, to allow Items to be Copied in the Establish Criteria document
Y/N Table Edit
Default Value: N
|
| 42 |
EP_CPY_MGR_EC_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N switch for ePerformance Section, to allow Items to be Copied in the Establish Criteria document
Y/N Table Edit
Default Value: N
|
| 43 |
EP_CPY_ITMS_EC_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N switch for ePerformance Section, to allow Items to be Copied in from another document
Y/N Table Edit
Default Value: N
|
| 44 |
EP_VIEW_OTHR_EC_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if Participant Feedback info is displayed on the Define Criteria page
Y/N Table Edit
Default Value: N
|
| 45 |
EP_ITEM_ADD_TP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Whether or not the role can Add Items in the Track Progress step
Y/N Table Edit
Default Value: N
|
| 46 |
EP_ITEM_UPD_TP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Whether or not the Role can Update Items in the Track Progress Step
Y/N Table Edit
Default Value: N
|
| 47 |
EP_ITEM_DEL_TP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Whether or not the Role can Delete Items during the Track Progress step
Y/N Table Edit
Default Value: N
|
| 48 |
EP_CPY_OBJ_TP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy Objective Items
Y/N Table Edit
Default Value: N
|
| 49 |
EP_CPY_MGR_TP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Whether or not the Role can copy Manager's Items during the Track Progress step
Y/N Table Edit
Default Value: N
|
| 50 |
EP_ITM_CMNTS_TP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
whether or not the role is enabled to have comments at the item level in the Track Progress step
Y/N Table Edit
Default Value: N
|
| 51 |
EP_SEC_CMNTS_TP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
whether or not the role is enabled to have comments at the Section level in the Track Progress step
Y/N Table Edit
Default Value: N
|
| 52 |
EP_ITM_NOTES_TP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
whether or not the role is enabled for Performance Notes at the Item level in the Track Progress step
Y/N Table Edit
Default Value: N
|
| 53 |
EP_SEC_NOTES_TP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
whether or not the role is enabled for Performance Notes at the Section level during the Track Progress step
Y/N Table Edit
Default Value: N
|
| 54 |
EP_CPY_ITMS_TP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Whether or not the Role can copy Items from other documents during the Track Progress step
Y/N Table Edit
Default Value: N
|
| 55 |
EP_VIEW_OTHR_TP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if Participant Feedback info is displayed on the Track Progress page
Y/N Table Edit
Default Value: N
|
| 56 |
EP_SEC_TP_RT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch track progress section rate items
Y/N Table Edit
Default Value: N
|
| 57 |
EP_ITEM_TP_RT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the role for a section can rate items
Y/N Table Edit
Default Value: N
|
| 58 |
EP_SUB_TP_RT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the role for a section can rate sub-items
Y/N Table Edit
Default Value: N
|