EP_APPR_SECTION

(SQL Table)
Index Back

Document Section

ePerformance table used to store Evaluation Section information.

  • Parent record: EP_APPR_ROLE
  • # 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