EP_REVW_TYP_VW

(SQL View)
 Index Back

Performance Review Type View

Performance Review Type - Used to create/update review types.

SELECT EP_REVIEW_TYPE ,EFFDT ,EP_REVW_DESCR ,EP_REVW_DESCRSHORT ,EFF_STATUS ,EP_TEMPLATE_SRC ,EP_DFLT_TEMPLATE ,APPR_RULE_SET ,EOAWDEFN_ID ,EP_OFFICIAL_SW ,EP_HISTORY_ONLY_SW ,EP_INITIATE_EE_SW ,EP_INITIATE_MGR_SW ,EP_EE_ELECT_MGR_SW ,EP_J_JP_TYPE FROM PS_EP_REVW_TYP_TBL WHERE EP_HISTORY_ONLY_SW<>'Y'

  • Related Language Record: EP_REVWTYP_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EP_REVIEW_TYPE Character(8) VARCHAR2(8) NOT NULL Review type
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 EP_REVW_DESCR Character(30) VARCHAR2(30) NOT NULL Review description
    4 EP_REVW_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Review short description
    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 EP_TEMPLATE_SRC Character(1) VARCHAR2(1) NOT NULL Source used to determine what templates are available (from job profile)
    J=Profile Management
    U=User Specified

    Default Value: U

    7 EP_DFLT_TEMPLATE Character(8) VARCHAR2(8) NOT NULL Default template to use

    Prompt Table: EP_REVW_TYP_TBL

    8 APPR_RULE_SET Character(30) VARCHAR2(30) NOT NULL Approval Rule Set

    Prompt Table: EP_APPR_RULE_VW

    9 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID

    Prompt Table: EP_PTAFAW_PRCS

    10 EP_OFFICIAL_SW Character(1) VARCHAR2(1) NOT NULL This Yes/No switch can be set to "Y" by the user to denote that the review is "Official". The setting of this field has no real significance in the application, it is primarily a user-controlled informational field.

    Y/N Table Edit

    Default Value: N

    11 EP_HISTORY_ONLY_SW Character(1) VARCHAR2(1) NOT NULL This flag is used on the ePerformance Management Review Type Table to indicate that this Review Type was upgraded from the customer's legacy Employee_Review" data. The system turns this switch on automatically at upgrade time, and these review Types are considered to be "frozen", unless the customer inserts a new effective-dated row to "re-activate" the Review Type so that it can be used in ePerformance Management.

    Y/N Table Edit

    Default Value: N

    12 EP_INITIATE_EE_SW Character(1) VARCHAR2(1) NOT NULL Switch that determines if an employee can initiate the document process.
    13 EP_INITIATE_MGR_SW Character(1) VARCHAR2(1) NOT NULL Switch that determines if a manager can initiate the document process.
    14 EP_EE_ELECT_MGR_SW Character(1) VARCHAR2(1) NOT NULL Can employee select a manager when creating an appraisal.
    15 EP_J_JP_TYPE Character(12) VARCHAR2(12) NOT NULL ePerformance specific field for Profile Type

    Prompt Table: EP_J_JP_TMPL_I