EP_XFER_LOG_TBL(SQL Table) |
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. |
| # | 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_REVIEW_TYPE |
Character(8) | VARCHAR2(8) NOT NULL | Review type |
| 6 | PERIOD_BEGIN_DT |
Date(10) | DATE | Period Begin Date |
| 7 | PERIOD_END_DT |
Date(10) | DATE | Period End Date |
| 8 | EP_APPRAISAL_ID |
Number(8,0) | INTEGER NOT NULL | Document ID |
| 9 | RUN_DTTM | DateTime(26) | TIMESTAMP | Run Date and Time |
| 10 | EP_NEW_MANAGER_ID | Character(11) | VARCHAR2(11) NOT NULL | New Manager/Mentor ID. Used when transferring ownership of a document to another manager. |
| 11 | 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 |
| 12 | 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 |