EMPLIDEMPL_RCDTRANSACTION_NBRTRANSACTION_NBR_EAHGA_PHOTO_FL_VW(SQL View) |
Index Back |
|---|---|
Extended Abs FL Appr Emp InfoExtended Absence Fluid Approvals. Employee Info View |
| SELECT AWE1.EMPLID , AWE1.EMPL_RCD , AWE1.TRANSACTION_NBR , AWE1.TRANSACTION_NBR_EA , EA.BGN_DT , EA.PIN_TAKE_NUM , EA.END_DT ,' ' , H.NAME_DISPLAY ,B.EMPLOYEE_PHOTO FROM PS_GP_ABS_EA_AWE AWE1 , PS_GP_ABS_EA EA , PS_PERSON_NAME H , %Table(USER_PH_LIST_FL) B WHERE EA.EMPLID=B.EMPLID AND EA.EMPLID = AWE1.EMPLID AND EA.EMPL_RCD = AWE1.EMPL_RCD AND ((EA.TRANSACTION_NBR = AWE1.TRANSACTION_NBR_EA) OR (EA.TRANSACTION_NBR = AWE1.TRANSACTION_NBR AND AWE1.TRANSACTION_NBR_EA = 0)) AND H.EMPLID = AWE1.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | TRANSACTION_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size. |
| 4 | TRANSACTION_NBR_EA |
Number(15,0) | DECIMAL(15) NOT NULL | The Extendned Absence transaction number |
| 5 | BGN_DT | Date(10) | DATE | Begin Date |
| 6 | PIN_TAKE_NUM | Number(8,0) | INTEGER NOT NULL | Absence Take |
| 7 | END_DT | Date(10) | DATE | end date |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 9 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 10 | EMPLOYEE_PHOTO | Image / Attachment(256) | VARCHAR2(256) | Employee Photograph |