CAR_IDEFFDTDefault Value: %date
0010=New Cars (00)
0020=No Stop Day (0)
0030=One Stop Day (1)
0040=Multiple Stop Day (2)
0010=Monday
0020=Tuesday
0030=Wednesday
0040=Thursday
0050=Friday
CAR_MAINT_MEX(SQL Table) |
Index Back |
|---|---|
Car MaintenanceCar Maintenance HR Mexico |
| # | 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 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | TYPE_INSP_MEX | Character(4) | VARCHAR2(4) NOT NULL |
Inspection Type HR Mexico
0010=New Cars (00) 0020=No Stop Day (0) 0030=One Stop Day (1) 0040=Multiple Stop Day (2) |
| 4 | STOP_DAY_MEX | Character(4) | VARCHAR2(4) NOT NULL |
Stop Day HR Mexico
0010=Monday 0020=Tuesday 0030=Wednesday 0040=Thursday 0050=Friday |