| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PSARCH_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
|
| 2 |
PSARCH_BATCHNUM |
Number(30,0) |
DECIMAL(30) NOT NULL |
Archive Batch Number
|
| 3 |
EP_APPRAISAL_ID |
Number(8,0) |
INTEGER NOT NULL |
Document ID
Prompt Table:
EP_APPR
|
| 4 |
EP_ROLE |
Character(8) |
VARCHAR2(8) NOT NULL |
Role unique identifier
Prompt Table:
EP_ROLE_TBL
|
| 5 |
EP_REVIEWER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Reviewer ID
Prompt Table:
EP_REVWR_ID_VW
|
| 6 |
EP_SECTION_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Section type
Prompt Table:
EP_SECTION_DEFN
|
| 7 |
EP_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence number
Default Value: 1
|
| 8 |
EP_SECTION_RTD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the section can be rated
Y/N Table Edit
Default Value: N
|
| 9 |
EP_SECTION_WTD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the section can be weighted
Y/N Table Edit
Default Value: N
|
| 10 |
EP_SECTION_ITEM_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the section contains items
Y/N Table Edit
Default Value: N
|
| 11 |
EP_SECTION_SUB_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the section contains subitems
Y/N Table Edit
Default Value: N
|
| 12 |
EP_SPCL_PROCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Special processing used for a review section
B=Business Objectives
C=Career Planning Summary
E=Employee Comments
L=Learning
M=Manager Comments
N=None
O=Overall Summary
R=Recognition Summary
S=Signatures
T=eSignatures
Default Value: N
|
| 13 |
EP_ITEM_DESCR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the item description field is available
Y/N Table Edit
Default Value: N
|
| 14 |
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
|
| 15 |
EP_ITEM_DUE_DT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the due date field is available
Y/N Table Edit
Default Value: N
|
| 16 |
EP_ITEM_INIT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the initialize from job profile is allowed
Y/N Table Edit
Default Value: N
|
| 17 |
EP_ITEM_LINKED_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if items can be linked
Y/N Table Edit
Default Value: N
|
| 18 |
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
|
| 19 |
EP_ITEM_MEASURE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the measure field is available
Y/N Table Edit
Default Value: N
|
| 20 |
EP_ITEM_OWNER_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to
Y/N Table Edit
Default Value: N
|
| 21 |
EP_ITEM_MIN_WT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the minimum weight field is available
Y/N Table Edit
Default Value: N
|
| 22 |
EP_ITEM_REMIND_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the reminder date field is available
Y/N Table Edit
Default Value: N
|
| 23 |
EP_ITEM_PCT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the item percentage field is available
Y/N Table Edit
Default Value: N
|
| 24 |
EP_ITEM_STATUS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the status field is available
Y/N Table Edit
Default Value: N
|
| 25 |
EP_ITEM_FREE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if items can be entered free form
Y/N Table Edit
Default Value: N
|
| 26 |
EP_J_ITEM_CAT_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
ePerformance specific version of the JPM Catalog Type field.
Prompt Table:
EP_J_CAT_T_IT_I
|
| 27 |
EP_J_JP_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
ePerformance specific field for Profile Type
Prompt Table:
EP_J_JP_TYPE_I
|
| 28 |
EP_J_CONTENT_GRP_T |
Character(15) |
VARCHAR2(15) NOT NULL |
Content Group Type
Prompt Table:
JPM_CAT_GTYPE
|
| 29 |
EP_J_CONTENT_GROUP |
Character(12) |
VARCHAR2(12) NOT NULL |
Content Group
Prompt Table:
JPM_CAT_GRPS_VW
|
| 30 |
EP_ITEM_PROMPT |
Character(15) |
VARCHAR2(15) NOT NULL |
Prompt table used to populate an item
Prompt Table:
EP_REC_ITEM_VW
|
| 31 |
EP_SUB_DESCR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the subitem description field is available
Y/N Table Edit
Default Value: N
|
| 32 |
EP_SUB_FREE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if subitems can be entered free form
Y/N Table Edit
Default Value: N
|
| 33 |
EP_J_SUB_CAT_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
ePerformance specific version of the JPM Catalog Type field.
Prompt Table:
EP_J_CAT_T_SB_I
|
| 34 |
EP_SUB_PROMPT |
Character(15) |
VARCHAR2(15) NOT NULL |
Sub-Item prompt record
Prompt Table:
EP_REC_SUB_VW
|
| 35 |
RATING_MODEL |
Character(4) |
VARCHAR2(4) NOT NULL |
Rating Model
Prompt Table:
RATING_MDL_TBL
|
| 36 |
RATING_DISPLAY |
Character(2) |
VARCHAR2(2) NOT NULL |
Rating Display
DD=Drop-Down Box
RB=Radio Buttons
ST=Stars
|
| 37 |
EP_RATING_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicate which field to sort the ratings by when using the drop-down display.
D=Rating Description
N=Numeric Rating
P=Review Points
R=Review Rating
|
| 38 |
EP_CALC_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculation method used - Summary, Average, Review Band
A=Average
R=Review Band
S=Summation
|
| 39 |
EP_LINK_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
The section to link items to
Prompt Table:
EP_SECTION_DEFN
|
| 40 |
EP_ALL_ITEMS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if all items use the same Rating Model
Y/N Table Edit
Default Value: N
|
| 41 |
EP_PRELIM_RTG_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the preliminary rating field is available
Y/N Table Edit
Default Value: N
|
| 42 |
EP_WEIGHT |
Number(3,0) |
SMALLINT NOT NULL |
Weight factor
|
| 43 |
EP_MIN_WEIGHT |
Number(3,0) |
SMALLINT NOT NULL |
Minumum weight used (percentage)
|
| 44 |
EP_JOB_PROFILE_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Determines if the job profile is used and where the it comes from
C=Job Code
F=Job Family
N=Not Used
P=Position
S=Salary Grade
Default Value: N
|
| 45 |
EP_ITEM_RTD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if items are rated
Y/N Table Edit
Default Value: N
|
| 46 |
EP_ITEM_TARGET_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if items are rated for Target Rating
Y/N Table Edit
Default Value: N
|
| 47 |
EP_ITEM_WTD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if items are weighted
Y/N Table Edit
Default Value: N
|
| 48 |
EP_ITEM_LEVEL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the Level of Difficulty field is available
Y/N Table Edit
Default Value: N
|
| 49 |
EP_EE_MEASURE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Measure switch used on ePerformance Section Definition
Y/N Table Edit
Default Value: N
|
| 50 |
EP_STRETCH_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N switch for ePerformance Section Stretch Goal
Y/N Table Edit
Default Value: N
|
| 51 |
EP_PRIVATE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N switch for ePerformance Section. Private, hide from Employees.
Y/N Table Edit
Default Value: N
|
| 52 |
EP_ITEM_START_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N switch for ePerformance Section Definition, Item State Date
Y/N Table Edit
Default Value: N
|
| 53 |
EP_ITEM_END_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N switch for ePerformance Section Definition, Item End Date
Y/N Table Edit
Default Value: N
|
| 54 |
EPO_LINK_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
Used to link Objective Pages to Content Items
Prompt Table:
EPO_SECTN_VW
|
| 55 |
EPO_ALIGN_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N switch for ePerformance Section, to allow Items to be Aligned in the Evaluation document
Y/N Table Edit
Default Value: N
|
| 56 |
JPM_C_LIST_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
JPM Custom prompt list id
Prompt Table:
EPO_CLST_ST_VW
|
| 57 |
PNLNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Page Name (see PSPNLDEFN).
|
| 58 |
TABSET_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Tab Identifier ID
|
| 59 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 60 |
TAB_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Folder Tab Identifier
Prompt Table:
EP_TABDTL_VW
|
| 61 |
TAB_LABEL_TEXT |
Character(20) |
VARCHAR2(20) NOT NULL |
Tab Label Text
|
| 62 |
EP_SEC_IN_EC_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
whether or not Establish Criteria is used for that Section
Y/N Table Edit
Default Value: Y
|
| 63 |
EP_SEC_IN_TP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
whether or not Track Progress is used for that Section
Y/N Table Edit
Default Value: Y
|
| 64 |
SUB_ITEM_LABEL |
Character(30) |
VARCHAR2(30) NOT NULL |
Sub-Item Label Text
|
| 65 |
EP_SEC_FLUID_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Fluid Section
Y/N Table Edit
Default Value: N
|
| 66 |
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
|
| 67 |
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
|
| 68 |
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
|
| 69 |
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
|
| 70 |
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
|
| 71 |
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
|
| 72 |
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
|
| 73 |
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
|
| 74 |
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
|
| 75 |
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
|
| 76 |
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
|
| 77 |
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
|
| 78 |
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
|
| 79 |
EP_SEC_WRT_PRF_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Performance Notes
Y/N Table Edit
Default Value: N
|
| 80 |
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
|
| 81 |
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
|
| 82 |
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
|
| 83 |
EP_ITEM_WRT_PRF_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Performance Notes
Y/N Table Edit
Default Value: N
|
| 84 |
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
|
| 85 |
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
|
| 86 |
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
|
| 87 |
EP_J_UPD_JP_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
ePerformance specific field for Profile Type
Prompt Table:
EP_J_JP_PERS_I
|
| 88 |
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
|
| 89 |
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
|
| 90 |
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
|
| 91 |
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
|
| 92 |
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
|
| 93 |
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
|
| 94 |
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
|
| 95 |
EP_HAS_EV_RULES_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Has Eval Role Rules
Default Value: Y
|
| 96 |
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
|
| 97 |
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
|
| 98 |
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
|
| 99 |
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
|
| 100 |
EP_RATING |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Rating
|
| 101 |
REVIEW_POINTS |
Number(3,0) |
SMALLINT NOT NULL |
Review Points
|
| 102 |
REVIEW_RATING |
Character(1) |
VARCHAR2(1) NOT NULL |
Review Rating
Prompt Table:
REVW_RATING_TBL
|
| 103 |
EP_RTG_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether the calculated Rating for this item or section has been manually overridden by the user.
Y/N Table Edit
Default Value: N
|
| 104 |
EP_RESULTS |
Long Character |
CLOB |
Results statement
|