EP_CALENDAR_DTL

(SQL Table)
 Index Back

Calender detail

ePerformance table used to storePerformance Calendar information in detail.

  • Parent record: EP_CALENDAR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EP_CALENDAR_ID Character(8) VARCHAR2(8) NOT NULL Calendar id
    2 EP_PERIOD_ID Character(8) VARCHAR2(8) NOT NULL This field stores the Period specified for a Calendar ID.
    3 EP_DUEDATE_TYPE Character(1) VARCHAR2(1) NOT NULL This field stores the various phases of a document for which due dates can be stored in a Performance Calendar.
    1=Approve Criteria
    2=Checkpoint Due
    3=Finalize Criteria
    4=Nomination Due
    5=Evaluation Due

    Default Value: 2

    4 EP_CHKPT_SEQ Character(2) VARCHAR2(2) NOT NULL This field stores the sequence checkpoints for Performance Calendar.
    1=Checkpoint 01
    10=Checkpoint 10
    11=Checkpoint 11
    2=Checkpoint 02
    3=Checkpoint 03
    4=Checkpoint 04
    5=Checkpoint 05
    6=Checkpoint 06
    7=Checkpoint 07
    8=Checkpoint 08
    9=Checkpoint 09
    5 EP_ROLE Character(8) VARCHAR2(8) NOT NULL Role unique identifier

    Prompt Table: EP_ROLE_TBL

    6 EP_DUE_DT Date(10) DATE NOT NULL Date a review is due