EP_APPRAISAL_IDLANGUAGE_CDEP_APPR_DTLLVW(SQL View) |
Index Back |
|---|---|
HTML Email Email HdrRecord view used to provide header data to HTMl Email Approval template. |
| SELECT A.EP_APPRAISAL_ID , D.LANGUAGE_CD , D.EP_REVW_DESCR , E.DESCR , E.DESCR FROM PS_EP_APPR A LEFT OUTER JOIN PS_REVW_RATINGEFLW E ON A.RATING_MODEL<>' ' AND A.REVIEW_RATING<>' ' AND A.REVIEW_RATING=E.REVIEW_RATING AND A.RATING_MODEL=E.RATING_MODEL , PS_EP_REVWTYP_LANG D WHERE A.EP_REVIEW_TYPE = D.EP_REVIEW_TYPE AND %EffdtCheck(EP_REVWTYP_LANG D1, D, %Currentdatein) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EP_APPRAISAL_ID |
Number(8,0) | INTEGER NOT NULL | Document ID |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | EP_REVW_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Review description |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | RATING_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Overall Rating Decription |