EP_APPR_SECTION(SQL Table) |
Index Back |
---|---|
Document SectionePerformance table used to store Evaluation Section information. |
# | 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_ROLE | Character(8) | VARCHAR2(8) NOT NULL |
Role unique identifier
Prompt Table: EP_ROLE_TBL |
3 | EP_REVIEWER_ID | Character(11) | VARCHAR2(11) NOT NULL |
Reviewer ID
Prompt Table: EP_REVWR_ID_VW |
4 | EP_SECTION_TYPE | Character(8) | VARCHAR2(8) NOT NULL |
Section type
Prompt Table: EP_SECTION_DEFN |
5 | EP_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL |
Sequence number
Default Value: 1 |
6 | 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 |
7 | 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 |
8 | 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 |
9 | 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 |
10 | EP_SPCL_PROCESS | Character(1) | VARCHAR2(1) NOT NULL |
Special processing used for a review section
E=Employee Comments L=Learning M=Manager Comments N=None O=Overall Summary S=Signatures Default Value: N |
11 | 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 |
12 | 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 |
13 | 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 |
14 | 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 |
15 | 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 |
16 | 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 |
17 | 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 |
18 | EP_ITEM_OWNER_SW | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No switch used to
Y/N Table Edit Default Value: N |
19 | 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 |
20 | 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 |
21 | 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 |
22 | 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 |
23 | 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 |
24 | 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 |
25 | EP_J_JP_TYPE | Character(12) | VARCHAR2(12) NOT NULL |
ePerformance specific field for Profile Type
Prompt Table: EP_J_JP_NPERS_I |
26 | EP_ITEM_PROMPT | Character(15) | VARCHAR2(15) NOT NULL |
Prompt table used to populate an item
Prompt Table: EP_REC_ITEM_VW |
27 | 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 |
28 | 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 |
29 | 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 |
30 | EP_SUB_PROMPT | Character(15) | VARCHAR2(15) NOT NULL |
Sub-Item prompt record
Prompt Table: EP_REC_SUB_VW |
31 | RATING_MODEL | Character(4) | VARCHAR2(4) NOT NULL |
Rating Model
Prompt Table: RATING_MDL_TBL |
32 | EP_CALC_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Calculation method used - Summary, Average, Review Band
A=Average R=Review Band S=Summation |
33 | EP_LINK_SECTION | Character(8) | VARCHAR2(8) NOT NULL |
The section to link items to
Prompt Table: EP_SECTION_DEFN |
34 | 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 |
35 | 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 |
36 | EP_WEIGHT | Number(3,0) | SMALLINT NOT NULL | Weight factor |
37 | EP_MIN_WEIGHT | Number(3,0) | SMALLINT NOT NULL | Minumum weight used (percentage) |
38 | 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 |
39 | 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 |
40 | 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 |
41 | 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 |
42 | EP_ITEM_ADD_EST_SW | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if items can be added for a section by a specific role during the Establish Criteria process.
Y/N Table Edit Default Value: N |
43 | 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 |
44 | 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 |
45 | 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 |
46 | 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 |
47 | 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 |
48 | 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 |
49 | 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 |
50 | 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 |
51 | 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 |
52 | 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 |
53 | 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 |
54 | 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 |
55 | 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 |
56 | EP_SEC_WRT_PRF_SW | Character(1) | VARCHAR2(1) NOT NULL |
Performance Notes
Y/N Table Edit Default Value: N |
57 | 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 |
58 | 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 |
59 | 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 |
60 | EP_ITEM_WRT_PRF_SW | Character(1) | VARCHAR2(1) NOT NULL |
Performance Notes
Y/N Table Edit Default Value: N |
61 | 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 |
62 | 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 |
63 | 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 |
64 | EP_J_UPD_JP_TYPE | Character(12) | VARCHAR2(12) NOT NULL |
ePerformance specific field for Profile Type
Prompt Table: EP_J_JP_PERS_I |
65 | 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 |
66 | EP_RATING | Number(6,2) | DECIMAL(5,2) NOT NULL | Rating |
67 | REVIEW_POINTS | Number(3,0) | SMALLINT NOT NULL | Review Points |
68 | REVIEW_RATING | Character(1) | VARCHAR2(1) NOT NULL |
Review Rating
Prompt Table: REVW_RATING_TBL |
69 | 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 |
70 | EP_RESULTS | Long Character | CLOB | Results statement |