CAR_IDCAR_FREE_VW(SQL View) |
Index Back |
|---|---|
Company Cars Available ViewCompany Cars Available View |
| SELECT A.CAR_ID ,A.REGISTRATION_NUM ,A.VIN ,A.MANUFACT_CD ,A.MODEL_DESCR FROM PS_CAR_DATA A WHERE A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_CAR_DATA A1 WHERE A1.CAR_ID = A.CAR_ID AND A1.EFFDT <= %CurrentDateIn) AND NOT EXISTS( SELECT B.CAR_ID FROM PS_CAR_ALLOC B WHERE B.CAR_ID = A.CAR_ID AND ( B.END_DT IS NULL OR B.END_DT >= %CurrentDateIn)) AND NOT EXISTS( SELECT C.CAR_ID FROM PS_CAR_POOL C WHERE C.CAR_ID = A.CAR_ID AND (C.END_DT IS NULL OR C.END_DT >= %CurrentDateIn)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAR_ID |
Character(7) | VARCHAR2(7) NOT NULL | Car Identification Number used in Administer Company Cars module. |
| 2 | REGISTRATION_NUM | Character(8) | VARCHAR2(8) NOT NULL | Registration Number |
| 3 | VIN | Character(17) | VARCHAR2(17) NOT NULL | Vehicle Identification Number |
| 4 | MANUFACT_CD | Character(4) | VARCHAR2(4) NOT NULL | Manufacturer |
| 5 | MODEL_DESCR | Character(40) | VARCHAR2(40) NOT NULL | Model Description |