...

A list of all the columns used in the importer and a description of what the field is used for in the system.

• Unique ID fields are required, and are used to identify a record as being a unique entity in the system before it has been imported and an ID can be assigned to it.

  • They contain the bare-minimum information needed to import the record.

• Recommended fields are not technically required, and a record can be made without them, but they contain information that make the record a useful entity in the system.

  • This is information like the first and last names of a user or the value of the fine on a violation.

  • A record is able to exist in the system without these fields, but it won’t do much without them.

• Optional fields are not required, and a record without them can still function as a useful entity in the system.

  • They contain supplemental information that can be filled in later or aren’t needed for the basic functionality of the record, such as the year a vehicle was made.

Importer Columns

UserProfile Table

...