CAR_IDMAINT_DTPrompt Table: CAR_MG_LOCA_VW
INT=Intermediate Service
REP=General Repair
SER=Full Service
VAL=Wash/Valet
KMT=Kilometers
MIL=Miles
Default Value: MIL
CAR_MAINT(SQL Table) |
Index Back |
|---|---|
Car MaintenanceCar Maintenance |
| # | 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 | MAINT_DT |
Date(10) | DATE NOT NULL | Maintenance Date |
| 3 | MGMT_LOCATION_NAME | Character(40) | VARCHAR2(40) NOT NULL |
Location
Prompt Table: CAR_MG_LOCA_VW |
| 4 | ACTION_CD | Character(3) | VARCHAR2(3) NOT NULL |
Action Code
INT=Intermediate Service REP=General Repair SER=Full Service VAL=Wash/Valet |
| 5 | DISTANCE_SCALE_CD | Character(3) | VARCHAR2(3) NOT NULL |
Distance Scale
KMT=Kilometers MIL=Miles Default Value: MIL |
| 6 | PRESENT_DISTANCE | Number(6,0) | INTEGER NOT NULL | Present Distance |
| 7 | NEXT_SERV_DISTANCE | Number(6,0) | INTEGER NOT NULL | Next Service Distance |
| 8 | NEXT_SERV_DT | Date(10) | DATE | Next Service Date |
| 9 | DESCRLONG | Long Character | CLOB | Long Description |