EP_TMPL_DIST_VW

(SQL View)
 Index Back

Template Definitions - ePerf

Search View used to display only template definition's defined for usage within ePerformance for Document type of Performance

SELECT EP_REVIEW_TYPE ,EP_TEMPLATE_ID ,EFFDT ,DESCR FROM PS_EP_TMPL_DEFN WHERE EP_TMPL_USE_FLG = 'E' AND PS_EP_TMPL_DEFN.EP_REVIEW_TYPE IN ( SELECT PS_EP_REVW_TYP_TBL.EP_REVIEW_TYPE FROM PS_EP_REVW_TYP_TBL WHERE EP_DOC_USAGE_IND = 'P')

  • Related Language Record: EP_MDIST_VW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EP_REVIEW_TYPE Character(8) VARCHAR2(8) NOT NULL Review type

    Prompt Table: EP_REVW_TYP_VW

    2 EP_TEMPLATE_ID Character(8) VARCHAR2(8) NOT NULL Template unique identifier
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description