|
SELECT EP_APPRAISAL_ID ,EMPLID ,EMPL_RCD ,PERIOD_BEGIN_DT ,PERIOD_END_DT ,EP_REVIEW_TYPE ,EP_EST_STATUS ,EP_NOM_STATUS ,EP_TRK_STATUS ,EP_NOM_DUE_DATE ,EP_REVIEW_STATUS ,EP_NOM_STEP_SW ,EP_NOM_UPD_EE_SW ,EP_NOM_UPD_MGR_SW ,EP_NOM_SUB_ROLE ,EP_NOM_TRK_EE_SW ,EP_NOM_TRK_MGR_SW ,EP_NOM_DUE_DAYS ,EP_NOM_DUE_TYPE FROM PS_EP_APPR
|
| # |
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 |
EP_REVIEW_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Review type
Prompt Table:
EP_REVW_TYP_VW
|
| 7 |
EP_EST_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
Translate field that determines the state (status) of the establish criteria step.
CO=Completed
IP=In Progress
NA=Not Applicable
NS=Not Started
|
| 8 |
EP_NOM_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
Translate field that determines the state (status) of the nominate participants step.
CO=Completed
IP=In Progress
NA=Not Applicable
NS=Not Started
Default Value: NA
|
| 9 |
EP_TRK_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
Translate field that determines the state (status) of the track participants step.
CO=Completed
IP=In Progress
NA=Not Applicable
NS=Not Started
|
| 10 |
EP_NOM_DUE_DATE |
Date(10) |
DATE |
Date the nominate participants step is due to be completed.
|
| 11 |
EP_REVIEW_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
This field tracks the status of a review document through it's life cycle. This is separate from the approval status of the review, which is tracked separately.
AK=Acknowledged
AR=Shared with Employee
CA=Canceled
CO=Completed
EC=Define Criteria
IP=Evaluation in Progress
NS=Not Started
PA=Approval
RH=Pending Acknowledgement
TP=Track Progress
Default Value: IP
|
| 12 |
EP_NOM_STEP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Switch that determines if the nomination process is enabled.
Y/N Table Edit
Default Value: N
|
| 13 |
EP_NOM_UPD_EE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Switch that determines if an employee can update the nominations list during the nominate participants process.
Y/N Table Edit
Default Value: N
|
| 14 |
EP_NOM_UPD_MGR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Switch that determines if a manager can update the nominations list during the nominate participants process.
Y/N Table Edit
Default Value: N
|
| 15 |
EP_NOM_SUB_ROLE |
Character(8) |
VARCHAR2(8) NOT NULL |
Role that determines if an employee or manager can submit nominations document during the nominate participant process.
Prompt Table:
EP_ROLE_VW1
|
| 16 |
EP_NOM_TRK_EE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Switch that determines if an employee can track the nomination acceptance/denial/cancellation during the nominate participants process.
Y/N Table Edit
Default Value: N
|
| 17 |
EP_NOM_TRK_MGR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Switch that determines if a manager can track the nomination acceptance/denial/cancellation during the nominate participants process.
Y/N Table Edit
Default Value: N
|
| 18 |
EP_NOM_DUE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Amount of days in which the nominate participants process is due.
|
| 19 |
EP_NOM_DUE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of due date - Before or After the period end date.
Used for the nominate participants process.
A=After Period End Date
B=Before Period End Date
|