EP_REVIEW_TYPEPrompt Table: EP_REVW_TYP_VW
EP_TEMPLATE_IDEFFDTDefault Value: %date
EP_TMPL_DEF_VW2(SQL View) |
Index Back |
|---|---|
Template Definition - HR BasicSearch View used to display only template definition's defined for usage within HR Employee Review. |
| SELECT EP_REVIEW_TYPE ,EP_TEMPLATE_ID ,EFFDT ,DESCR FROM PS_EP_TMPL_DEFN WHERE EP_TMPL_USE_FLG = 'B' |
| # | 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 |