EP_APPR_DTL_VW

(SQL View)
 Index Back

HTML Email Email Hdr

Record view used to provide header data to HTMl Email Approval template.

SELECT A.EP_APPRAISAL_ID , A.EMPLID , A.EMPL_RCD , A.PERIOD_BEGIN_DT , A.PERIOD_END_DT , STA.SEQNO ,STA.TRANS_DT , B.NAME , C.NAME ,A.EP_MANAGER_ID , %Sql(HR_HT_EMAIL_DATE,A.PERIOD_BEGIN_DT) , %Sql(HR_HT_EMAIL_DATE,A.PERIOD_END_DT) , A.REVIEW_RATING , A.RATING_MODEL , D.EP_REVW_DESCR , E.DESCR , E.DESCR , A.EP_APPROVAL_STATUS ,STA.COMMENTS ,'X' FROM PS_EP_APPR A LEFT OUTER JOIN PS_REVW_RATINGEFVW E ON A.RATING_MODEL<>' ' AND A.REVIEW_RATING<>' ' AND A.REVIEW_RATING=E.REVIEW_RATING AND A.RATING_MODEL=E.RATING_MODEL , PS_PERSON_NAME B , PS_PERSON_NAME C , PS_EP_REVW_TYP_TBL D ,PS_EP_APPR_STA STA WHERE A.EMPLID = B.EMPLID AND A.EP_MANAGER_ID = C.EMPLID AND A.EP_REVIEW_TYPE = D.EP_REVIEW_TYPE AND %EffdtCheck(EP_REVW_TYP_TBL D1, D, %Currentdatein) AND D.EFF_STATUS = 'A' AND A.EP_APPRAISAL_ID = STA.EP_APPRAISAL_ID AND STA.SEQNO=1

  • Related Language Record: EP_APPR_DTLLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EP_APPRAISAL_ID Number(8,0) INTEGER NOT NULL Document ID
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    4 PERIOD_BEGIN_DT Date(10) DATE NOT NULL Period Begin Date
    5 PERIOD_END_DT Date(10) DATE NOT NULL Period End Date
    6 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    7 TRANS_DT Date(10) DATE Transaction Date
    8 NAME Character(50) VARCHAR2(50) NOT NULL Name
    9 EP_MANAGER_NAME Character(60) VARCHAR2(60) NOT NULL Used to display the manager/mentor's name in ePerformance.
    10 EP_MANAGER_ID Character(11) VARCHAR2(11) NOT NULL Manager/Mentor ID.
    11 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description
    12 DESCR30 Character(30) VARCHAR2(30) NOT NULL Description
    13 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating
    14 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model
    15 EP_REVW_DESCR Character(30) VARCHAR2(30) NOT NULL Review description
    16 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    17 RATING_DESCR Character(30) VARCHAR2(30) NOT NULL Overall Rating Decription
    18 EP_APPROVAL_STATUS Character(4) VARCHAR2(4) NOT NULL This field tracks the current approval status of a review. This is separate from the review's lifecycle status, which is tracked separately.
    APRV=Approved
    DENY=Denied
    ERRO=Approval Error
    NREQ=Not Required
    OPEN=Not Submitted
    SUBM=Submitted
    19 COMMENTS Long Character CLOB Comment
    20 DESCR_COMMENTS_HIS Long Character CLOB This field is used in a complex query that shows many descr fields.