This section of the guide will cover the actual creation of a dataset. Due to the amount of customization available on OneGov, table names and fields are often times different however, there are a number of consistencies.

• appstatus
  • This table contains information on all of the default and custom statuses used in the site
  • Includes (but not limited to)
    • Status ID (Unique Primary Key)
    • Status Name
• appvaluesbytypeid

  • For each of the applications set up in your OneGov site, there is a corresponding appvaluesbytypeid table

  • Each appvaluesbytypeid table ends in a number that is determined by the Type ID

  • These tables contains all of the applicant supplied values for each application whether or not the application was completed

    To find the Type ID for an application, follow the instructions on our How-To Article.

    
    

• contacts
  • This table contains all of the information from the Contact Data Types in all of the applications
  • Includes (but not limited to)
    • Contact ID (Unique Primary Key)
    • Application ID (Foreign Key)
    • Field ID (Foreign Key)
    • Contact Name
    • Contact Email
• permitappfieldcustomoptions
  • This table contains information about the selection from a single select or drop down data type
  • Includes (but not limited to)
    • Application ID (Foreign Key)
    • Field ID (Foreign Key)
    • Custom Table ID (Foreign Key)
    • Custom Record ID (Foreign Key)
• permitappfieldselectedoptions
  • This table contains information about selections from a multi-select data type
  • Includes (but not limited to)
    • Application ID (Foreign Key)
    • Field ID (Foreign Key)
    • Option ID (Foreign Key)
• permitappfieldvalues
  • This table contains the information from a majority of the custom fields in each of the applications
  • Includes (but not limited to)
    • Application ID (Foreign Key)
    • Field ID (Foreign Key)
    • Field Value
• permitapps
  • This table contains the information from all of the started applications
  • Includes (but not limited to)
    
    • Application ID (Unique Primary Key)
    • permittypeid (Foreign Key)
    • Statusid (Foreign Key)
    • Userid (Foreign Key)
    • Date/Time application started
    • Date/Time application last modified
    • Date/Time application approved (If Applicable)
    • Date/Time application canceled
• permitappsignatures
  • Contains information about the signatures on an application
  • Includes (but not limited to)
    • Signature ID (Unique Primary Key)
    • Application ID (Foreign Key)
    • Userid (Foreign Key)
    • Approval Name
    • Signature Date