EP_REVIEW_TYPEPrompt Table: EP_REVW_TYP_VW
EP_TEMPLATE_IDEFFDTDefault Value: %date
LANGUAGE_CDEP_MDIST_VW_LNG(SQL View) |
Index Back |
|---|---|
Template Definition - ePerfSearch View used to display only template definition's defined for usage within ePerformance. |
| SELECT A.EP_REVIEW_TYPE ,A.EP_TEMPLATE_ID ,A.EFFDT ,A.LANGUAGE_CD ,A.DESCR FROM PS_EP_TMPLDEF_LANG A , PS_EP_TMPL_DEFN B WHERE %Join(COMMON_KEYS, EP_TMPLDEF_LANG A, EP_TMPL_DEFN B) AND B.EP_TMPL_USE_FLG = 'E' AND B.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') |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |