EP_XFER_LOG_VW(SQL View) |
Index Back |
|---|---|
Auto Transfer logePerformance log file used by the Auto Transfer process. The log will contain details of documents that were and were not transferred after a manager is terminated. |
| SELECT A.EP_TERM_EMPLID , A.EP_TERM_EMPL_RCD , A.EP_TERM_DATE , A.EMPLID , B.FIRST_NAME_SRCH , B.LAST_NAME_SRCH , B.NAME_DISPLAY , A.RUN_DTTM , C.FIRST_NAME_SRCH , C.LAST_NAME_SRCH , C.NAME_DISPLAY , A.EP_NEW_MANAGER_ID , ' ' , ' ' , ' ' , A.EP_EXCEPT_REASON , EP_REVIEW_TYPE , PERIOD_BEGIN_DT , PERIOD_END_DT , EP_APPRAISAL_ID , EP_XFER_TYPE FROM PS_EP_XFER_LOG_TBL A LEFT OUTER JOIN PS_PERSON_NAME B ON (A.EMPLID = B.EMPLID) , PS_NAMES C WHERE EP_TERM_EMPLID = C.EMPLID AND C.NAME_TYPE = 'PRI' AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_NAMES C1 WHERE C1.EMPLID = C.EMPLID AND C1.NAME_TYPE = C.NAME_TYPE AND C1.EFFDT <= A.EP_TERM_DATE ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EP_TERM_EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | ePerformance terminated employee id |
| 2 | EP_TERM_EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | ePerformance terminated empl record |
| 3 | EP_TERM_DATE |
Date(10) | DATE | ePerformance termination date |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 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_EE_NAME | Character(60) | VARCHAR2(60) NOT NULL | Used to display the manager/mentor's name in ePerformance. |
| 8 | RUN_DTTM | DateTime(26) | TIMESTAMP | Run Date and Time |
| 9 | EP_MGR_FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Work field used to search for a evaluatee's first name.. |
| 10 | EP_MGR_LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Work field used to search for a manager's last name.. |
| 11 | EP_MANAGER_NAME | Character(60) | VARCHAR2(60) NOT NULL | Used to display the manager/mentor's name in ePerformance. |
| 12 | EP_NEW_MANAGER_ID | Character(11) | VARCHAR2(11) NOT NULL | New Manager/Mentor ID. Used when transferring ownership of a document to another manager. |
| 13 | EP_NEW_MGR_FIRST_N | Character(60) | VARCHAR2(60) NOT NULL | Used to display the manager/mentor's name in ePerformance. |
| 14 | EP_NEW_MGR_LAST_N | Character(60) | VARCHAR2(60) NOT NULL | Used to display the manager/mentor's name in ePerformance. |
| 15 | EP_NEW_MGR_NAME | Character(60) | VARCHAR2(60) NOT NULL | Used to display the manager/mentor's name in ePerformance. |
| 16 | EP_EXCEPT_REASON | Character(1) | VARCHAR2(1) NOT NULL |
Identifies a reason as to why a document did not get transferred
0=Complete 1=No Supervisor found 2=Manager still has active job 4=No Manager found 5=No Reports To found 6=Within Days to Period End Date 7=Past Period End Date 8=Dept has no previous manager |
| 17 | EP_REVIEW_TYPE | Character(8) | VARCHAR2(8) NOT NULL | Review type |
| 18 | PERIOD_BEGIN_DT | Date(10) | DATE | Period Begin Date |
| 19 | PERIOD_END_DT | Date(10) | DATE | Period End Date |
| 20 | EP_APPRAISAL_ID | Number(8,0) | INTEGER NOT NULL | Document ID |
| 21 | EP_XFER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Which Auto Transfer, Manager Termination or Employee Transfer initiated the transfer of documents
E=Employee Transfer M=Manager Termination |