EMPLIDREGISTRATION_NUMEXTRA_DESCRGPGB_CAR_EXT_VW(SQL View) |
Index Back |
|---|---|
Car Extras ViewCar Extras View |
| SELECT A.EMPLID ,B.REGISTRATION_NUM ,C.EXTRA_DESCR ,C.INSTALL_DT ,C.REMOVE_DT ,C.EXTRA_COST FROM PS_CAR_ALLOC A ,PS_CAR_DATA B ,PS_CAR_EXTRA C WHERE B.CAR_ID = A.CAR_ID AND C.CAR_ID = B.CAR_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | REGISTRATION_NUM |
Character(8) | VARCHAR2(8) NOT NULL | Registration Number |
| 3 | EXTRA_DESCR |
Character(40) | VARCHAR2(40) NOT NULL | Extra Description |
| 4 | INSTALL_DT | Date(10) | DATE | Installation date |
| 5 | REMOVE_DT | Date(10) | DATE | Removal Date |
| 6 | EXTRA_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Cost of Extra |