| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EP_REVIEW_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Review type
Prompt Table:
EP_REVW_TYP_VW
|
| 2 |
EP_TEMPLATE_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Template unique identifier
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
|
| 4 |
EP_SECTION_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Section type
Prompt Table:
EP_SECTION_DEFN
|
| 5 |
EP_ROLE |
Character(8) |
VARCHAR2(8) NOT NULL |
Role unique identifier
Prompt Table:
EP_NO_ROLES_VW
|
| 6 |
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
|
| 7 |
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
|
| 8 |
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
|
| 9 |
EP_CPY_OBJ_TP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy Objective Items
Y/N Table Edit
Default Value: N
|
| 10 |
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
|
| 11 |
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
|
| 12 |
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
|
| 13 |
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
|
| 14 |
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
|
| 15 |
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
|
| 16 |
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
|
| 17 |
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
|
| 18 |
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
|
| 19 |
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
|