PP501MOJEF – DMV data load

This is an SQL loader program that loads the vehicle values from the State into PP43. This program will load the values based on the product code, tax year, and year manufactured.

This report also produces exception reports after the program is run so that the user can verify any issues that may have occurred during the data load.

Exception report includes the following:

  1. DUPLICATE RECORDS IN THE INPUT FILE: Records from the input file that are duplicated.  The records will print along with the product code, product type, make, model, and body.
  2. UPDATING NEW VALUES GREATER THAN OLD VALUES: Records from PP43 where the values increased.  The records will print along with the product code, product type, make, model, body, year manufactured, old value, and new value where the new values increased from the State file.
  3. ERROR IN UPDATE TO VALUE TABLE: Records that did not get updated a caused an error.  The records will print along with the product code, make, model, body, new value, and the message for which it did not get updated. 
  4. VEHICLE VALUES (WITH PROD_CODE) NOT UPDATED BY INPUT FILE:  Records from PP43 (VEH_VALUES) where who not equal to PP501MOSTL.  The records will print along with the product code, product type, make, model, body, year manufactured, and new value where there was a product code in PP43 that did not get update from the State file.
  5. INFORMATION ON PROD_CODE IN VEH_VICCODE TABLE: This will list the count of records with product codes that were updated and also the count for the product codes that were not updated.
  6. VEHICLE VALUES EQUAL TO ZERO: Records from the input file that are zero values.  The records will print along with the product code, vic code, product type, make, year manufactured, old value and new value.
  7. UPDATING NEW VALUES DECREASED BY 10% OR GREATER: Records from the input file decreased by more than 10%.  The records will print along with the product code,  product type, make, year manufactured, old value, and new value.

 

Job: Report name should always appear here. For example, PP501MOJEF.

Server Name: Keep the server name that first appears.

Printer_Name: Select a valid printer or keep the displayed printer if one is present.

Jurisdiction: Enter your jurisdiction.

Tax Year: Enter the tax year for which you are running the batch report..

Spool File Name: Enter PP501MOJEF.LIS to create the file in text format.

FCU: Formatting code. Keep the default printer setting that is present when the screen appears. If blank, enter PSL132.

INPUT DATA FILE: Enter the full path and filename of where the file is located to load the data into PP43. This must be a comma-delimited file. (e.g., c:\pvg_2003.csv)

CONTROL FILE: Enter the full path and filename of where the control file is located. The default path is the start in path and this is usually the daemon folder.

Commit(Y/N): Commit Data. Enter Y to commit data after the program is run, enter N not to commit the data after the program is run. The default is N.

 

Updated 8/21/2008