EP_REVW_MGR_VW(SQL View) |
Index Back |
|---|---|
Document Type for Mgr Doc InitDocument Type: Initiate Used to create document types accessible to the Manager |
| SELECT EP_REVIEW_TYPE , EFFDT , EP_REVW_DESCR , EP_REVW_DESCRSHORT , EFF_STATUS , EP_DOC_USAGE_IND , EP_INITIATE_MGR_SW , EP_TEMPLATE_SRC , EP_DFLT_TEMPLATE , APPR_RULE_SET , EP_OFFICIAL_SW , EP_HISTORY_ONLY_SW FROM PS_EP_REVW_TYP_TBL WHERE EP_INITIATE_MGR_SW = 'Y' AND 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 |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | EP_REVW_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Review description |
| 4 | EP_REVW_DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Review short description |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 6 | EP_DOC_USAGE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Indicator used to determine what document types are available for performance assessments and which are available for development assessments.
D=Development P=Performance Default Value: P |
| 7 | EP_INITIATE_MGR_SW | Character(1) | VARCHAR2(1) NOT NULL |
Switch that determines if a manager can initiate the document process.
Y/N Table Edit Default Value: N |
| 8 | EP_TEMPLATE_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Source used to determine what templates are available (from job profile)
J=Profile Management U=User Specified Default Value: U |
| 9 | EP_DFLT_TEMPLATE | Character(8) | VARCHAR2(8) NOT NULL |
Default template to use
Prompt Table: EP_TMPL_DEFN |
| 10 | APPR_RULE_SET | Character(30) | VARCHAR2(30) NOT NULL |
Approval Rule Set
Prompt Table: EP_APPR_RULE_VW |
| 11 | EP_OFFICIAL_SW | Character(1) | VARCHAR2(1) NOT NULL |
This Yes/No switch can be set to "Y" by the user to denote that the review is "Official". The setting of this field has no real significance in the application, it is primarily a user-controlled informational field.
Y/N Table Edit Default Value: N |
| 12 | EP_HISTORY_ONLY_SW | Character(1) | VARCHAR2(1) NOT NULL |
This flag is used on the ePerformance Management Review Type Table to indicate that this Review Type was upgraded from the customer's legacy Employee_Review" data. The system turns this switch on automatically at upgrade time, and these review Types are considered to be "frozen", unless the customer inserts a new effective-dated row to "re-activate" the Review Type so that it can be used in ePerformance Management.
Y/N Table Edit Default Value: N |