1.  Think Globally, Act Locally

2.  Focus and don't get too far ahead of yourself when planning the data that will populate the table you are currently working on- don't lose sight of the task at hand!

3.  Follow the recommended order in which the tables should be planned/configured.

1.  Departments & Divisions
2.  Contract Types
3.  Contract Categories
4.  Contract Statuses
5.  Locations
7.  Occurrences/Term

4.  Please be mindful of the fact that Contract Insight is created upon a Relational Database Platform (SQL Server).  As such, the database has been designed as a set of relational tables which are related to each other in support of the application’s purpose, objective and strategy.  There is a strict hierarchy and sequence associated with entering data into the application’s database and related tables.

5.  After the Initial Application Setup Tables have been planned successfully, the next step is to plan what initial fields may need to be added in addition to the "out-of-the-box" fields in order to capture any additional information/data for the following tables:

1.  Employees/Users
2.  Vendors/Companies
3.  Contract Details Table

6.  Once any/all additional fields that need to be added have been identified, the next step is to populate the Employee/User spreadsheet and the Vendor/Customer spreadsheet.