EMPLIDLAST_NAME_SRCHEP_APPRAISAL_IDEP_ROLEPrompt Table: EP_ROLE_TBL
EP_DEBUG_HDR_VW(SQL View) |
Index Back |
|---|---|
Calculation Debug HeaderHeader record for a Review's calculation debug/trace records |
| SELECT DISTINCT A.EMPLID , B.LAST_NAME_SRCH , C.EP_APPRAISAL_ID , C.EP_ROLE , B.NAME FROM PS_EP_APPR A , PS_PERSON_NAME B , PS_EP_DEBUG_DTL C WHERE A.EMPLID = B.EMPLID AND A.EP_APPRAISAL_ID = C.EP_APPRAISAL_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | LAST_NAME_SRCH |
Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 3 | EP_APPRAISAL_ID |
Number(8,0) | INTEGER NOT NULL | Document ID |
| 4 | EP_ROLE |
Character(8) | VARCHAR2(8) NOT NULL |
Role unique identifier
Prompt Table: EP_ROLE_TBL |
| 5 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |