About the Data Requirements for the Sample Application

The following items are currently being captured on forms and manually entered into spreadsheets in Motor Loaner's current environment. The new system should be set up to manage all of this data:

• DR1: Associate Contact Information
  • DR1a. Name
  • DR1b. Job Title
  • DR1c. Mailing Address
  • DR1d. Home Phone Number
  • DR1f. Home Email Address
    
    
• DR2: Manufacturer Contact Information
  • DR2a. Name
  • DR2b. Mailing Address
  • DR2c. Main Office Phone Number
    
    
• DR3: Model Specific Vehicle Information
  • DR3a. Model Name
  • DR3b. Manufacturer
  • DR3c. Model Year
  • DR3d. Type of Vehicle
    • Coupe (2-door)
    • Sedan (4-door)
    • Truck-Regular Cab (2-door)
    • Truck-SuperCab (4-door)
    • Convertible (2-door)
    • Other
    • Exotic
    • Sports Utility Vehicle (SUV)
      
      
  • DR3e. Fuel Type
    • Gas
    • Diesel
    • Electric
    • Gas-Electric Hybrid
      
      
  • DR3f. Engine Size
    
    
  • DR3g. Transmission Type
    • Automatic
    • Automatic with Select Shift
    • Manual
      
      
  • DR3h. Drive Type
    • Front Wheel Drive
    • Rear Wheel Drive
    • All Wheel Drive
      
      
  • DR3i. Four Wheel Drive (yes/no)
  • DR3j. Fuel Capacity
  • DR3k. City MPG
  • DR3l. Highway MPG
  • DR3m. Passenger Capacity
  • DR3n. Cargo Capacity
  • DR3o. Towing Capacity
  • DR3p. Maintenance Schedule for this Vehicle Model
    
    
• DR4: Vehicle Maintenance Schedule Information
  • DR4a. Name of Maintenance Schedule
  • DR4b. Oil Change Servicing Mileage Interval
    • 3000 miles
    • 5000 miles
    • 15000 miles
      
      
  • DR4c. Major Tune Up Mileage Interval\
    • 15000 miles
    • 30000 miles
    • 45000 miles
    • 60000 miles
      
      
  • DR4d. Comments
    
    
• DR5: Vehicle Specific Information
  • DR5a. Vehicle Identification Number (VIN)
  • DR5b. Vehicle Model
  • DR5c. Date Vehicle was Acquired
  • DR5d. Method Vehicle was Acquired
    • Purchase
    • Lease
    • Transfer
    • Other
      
      
  • DR5e. Date Vehicle was Disposed
  • DR5f. Method Vehicle was Disposed
    • N/A
    • Sold
    • Donated
    • Salvaged
    • Other
      
      
  • DR5g. Vehicle's Current Mileage
  • DR5h. Exterior Color of Vehicle
  • DR5i. Interior Color of Vehicle
  • DR5j. Type of Interior
    • Cloth
    • Leather
      
      
  • DR5k. Vehicle's Current Status
    • Available for Rent
    • Servicing
    • Discarded
    • Rented
      
      
• DR6: Rental Agreements Form Information
  • DR6a. Vehicle for Rent
  • DR6b. Check Out Rental Clerk
  • DR6c. Customer Name
  • DR6d. Customer Email Address
  • DR6e. Customer Main Mailing Address
  • DR6f. Customer Other Address(es)
  • DR6g. Customer Main Contact Phone Number
  • DR6h. Other Phone Number(s)
  • DR6i. Rental Date
  • DR6j. Expected Return Date
  • DR6k. Vehicle's Starting Mileage
  • DR6l. Vehicle's Starting Fuel Level
    • Empty
    • 1/4 tank
    • 1/2 tank
    • 3/4 tank
    • Full tank
      
      
  • DR6m. Vehicle's Starting Condition
    • Acceptable
    • Existing Damage
      
      
  • DR6n. Check In Rental Clerk
  • DR6o. Vehicle's Return Date
  • DR6p. Vehicle's Return Mileage
  • DR6q. Vehicle's Return Fuel Level
    • Empty
    • 1/4 tank
    • 1/2 tank
    • 3/4 tank
    • Full tank
      
      
  • DR6r. Vehicle's Return Condition
    • Acceptable
    • Returned Damaged
      
      
  • DR6s. Check Out Comments
  • DR6t. Check In Comments
  • DR6u. Rented Accessories
    • Baby Car Seat
    • DVD Player
    • Trailer
    • Tow Hitch
    • Bike Rack
    • Ski Rack
    • Luggage Rack
      
      
  • DR6v. Quantity of Each Rented Accessory
  • DR6w. Rented Accessories Present on Return
  • DR6x. Rental Accessory Comments
    
    
• DR7: Service Form Information
  • DR7a. Service Status
    • Servicing
    • Completed
      
      
  • DR7b. Vehicle to Service
  • DR7c. Date Damaged Reported or Service Ticket Created
  • DR7d. Associate who Reported Damage (if applicable)
  • DR7e. Vehicle Mileage
  • DR7f. Service Type
    • Scheduled Maintenance
    • Damage
      
      
  • DR7g. Service Date
  • DR7h. Service Technician
  • DR7i. Description of Servicing Required
  • DR4j. Technician Comments
  • DR4k. Release to Fleet (check box)
    
    
• DR8: Required Reports
  • DR8a. Vehicle Damage Report (for past 7 days)
  • DR8b. Damage Report for a Particular Time Frame
  • DR8c. Most Popular Vehicles Rented
  • DR8d. Least Popular Vehicles Rented
  • DR8e. Rented Vehicles in order of Expected Return Date
  • DR8f. All Vehicles Grouped by Status
  • DR8g. Service Tickets Pending Approval
  • DR8h. Detailed Report of Rental History
  • DR8i. Vehicle Rental Check-Outs by Associate
  • DR8j. Vehicle Rental Check-Ins by Associate
  • DR8k. Vehicles Available for Rent
  • DR8l. High Mileage Vehicles