EP_APPRAISAL_VW(SQL View) |
Index Back |
|---|---|
Approve Search for AppraisalsThis is the search record used for the Approve Appraisals transaction. |
| SELECT A.EP_APPRAISAL_ID , A.EMPLID , A.EMPL_RCD , E.NAME_DISPLAY , E.FIRST_NAME_SRCH , E.LAST_NAME_SRCH , A.EP_REVIEW_TYPE , A.PERIOD_BEGIN_DT , A.PERIOD_END_DT , A.EP_MANAGER_ID , F.NAME_DISPLAY , F.FIRST_NAME_SRCH , F.LAST_NAME_SRCH , A.EP_REVIEW_STATUS , A.EP_APPROVAL_STATUS , A.PTAFDEFN_ID FROM PS_EP_APPR A , PS_NAMES E , PS_NAMES F WHERE A.EP_APPROVAL_STATUS IN ('APRV','DENY','SUBM') AND E.EMPLID = A.EMPLID AND E.NAME_TYPE = 'PRI' AND E.EFFDT = ( SELECT MAX(EE.EFFDT) FROM PS_NAMES EE WHERE EE.EMPLID = E.EMPLID AND EE.NAME_TYPE = E.NAME_TYPE AND EE.EFFDT <= %CurrentDateIn) AND F.EMPLID = A.EP_MANAGER_ID AND F.NAME_TYPE = 'PRI' AND F.EFFDT = ( SELECT MAX(FF.EFFDT) FROM PS_NAMES FF WHERE FF.EMPLID = F.EMPLID AND FF.NAME_TYPE = F.NAME_TYPE AND FF.EFFDT <= %CurrentDateIn) |
| # | 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 Rcd Nbr |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 5 | EP_EE_FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Work field used to search for a evaluatee's first name.. |
| 6 | EP_EE_LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Work field used to search for a evaluatee's last name.. |
| 7 | EP_REVIEW_TYPE | Character(8) | VARCHAR2(8) NOT NULL | Review type |
| 8 | PERIOD_BEGIN_DT | Date(10) | DATE | Period Begin Date |
| 9 | PERIOD_END_DT | Date(10) | DATE | Period End Date |
| 10 | EP_MANAGER_ID | Character(11) | VARCHAR2(11) NOT NULL | Manager/Mentor ID. |
| 11 | EP_MANAGER_NAME | Character(60) | VARCHAR2(60) NOT NULL | Used to display the manager/mentor's name in ePerformance. |
| 12 | EP_MGR_FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Work field used to search for a evaluatee's first name.. |
| 13 | EP_MGR_LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Work field used to search for a manager's last name.. |
| 14 | 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=Available for Review CA=Cancelled CO=Completed IP=In Progress NS=Not Started RH=Review Held Default Value: IP |
| 15 | EP_APPROVAL_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
This field tracks the current approval status of a review. This is separate from the review's lifecycle status, which is tracked separately.
APRV=Approved DENY=Denied ERRO=Approval Error NREQ=Not Required OPEN=Not Submitted SUBM=Submitted Default Value: OPEN |
| 16 | PTAFDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL | Definition ID |