EP_REVW_CLN_VW

(SQL View)
 Index Back

Document Type: Setup

Document Type: Setup - Used to create/update document types.

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

  • Related Language Record: EP_REVWCLN_LANG

  • Parent Record Of EP_REVWCLN_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_DOC_USAGE_IND Character(1) VARCHAR2(1) NOT NULL Indicator used to determine what document types are available for performance assessments and which are available for development assessments.
    D=Development
    P=Performance
    7 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

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

    Prompt Table: EP_TMPL_DEFN

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

    Prompt Table: EP_APPR_RULE_VW

    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.

    Y/N Table Edit