Data Dictionary

Data Element Section Master Field Name Description Type Sub Type Example Data Type
DDL-001 Contractor Company Details Company Name Name Of Company contractor_company_details company_name SIEMENS string
DDL-002 Contractor Company Details Contact Name Contact Person In Company contractor_company_details contact_name DAN EDWARDS string
DDL-003 Contractor Company Details Contractor Email Contractor Email Address contractor_company_details contractor_email EDWARDS@UGSOLUTIONS.COM string
DDL-004 Contractor Company Details Contractor Phone Contractor phone number contractor_company_details contractor_phone 6786913946 string
DDL-005 Contractor Company Details Contractor Address Contractor Address contractor_company_details contractor_address 1335 RIDGELAND PKWY ALPHARETTA GA 30004-0728 string
DDL-006 Contractor Company Details County Company County contractor_company_details county FORSYTH string
DDL-007 Contractor Company Details Sic Code Sic Code of Company contractor_company_details sic_code 171131 string
DDL-008 Contractor Company Details Number Of Employee Employee Count in Company contractor_company_details number_of_employee 1 To 4 string
DDL-009 Contractor Company Details Annual Sales Annual Sales Of Comapany contractor_company_details annual_sales $500,000 To $1 Million string
DDL-010 Contractor Company Details Contact Role Contact Person Role In Company contractor_company_details contact_role MANAGER string
DDL-011 Contractor Company Details Industry Industry Type contractor_company_details industry ENERGY MANAGEMENT SYSTEMS & PRODUCTS string
DDL-012 Applicant Details Applicant Full Name Full name of the Applicant applicant_details applicant_name Donna Kirkpatrick string
DDL-013 Applicant Details Applicant Organization Organization the applicant is associated with. applicant_details applicant_organization - string
DDL-014 Applicant Details Applicant Phone Applicant Phone Number applicant_details applicant_phone 5123264223 string
DDL-015 Applicant Details Applicant Address Line 1 Applicant Address Line 1 applicant_details applicant_address_line_1 7901 string
DDL-016 Applicant Details Applicant Address Line 2 Applicant Address Line 2 applicant_details applicant_address_line_2 E Riverside string
DDL-017 Applicant Details Applicant Address Line 3 Applicant Address Line 3 applicant_details applicant_address_line_3 - string
DDL-018 Applicant Details Applicant City Applicant City applicant_details city Austin  string
DDL-019 Applicant Details Applicant Zip Applicant Zip Code applicant_details zip 3001 string
DDL-020 Building Location Job Street Address Property address associated with the permit. address_details street S CONGRESS AVE string
DDL-021 Building Location Job City City of the property associated with the permit. address_details city JACKSONVILLE string
DDL-022 Building Location Job State State of the property associated with the permit. address_details state TX string
DDL-023 Building Location Job Zip Zip of the property associated with the permit. address_details zip 78704 string
DDL-024 Building Location Latitude The Latitude of the property's primary address. address_details latitude 30.23209318 float
DDL-025 Building Location Longitude The Longitude of the property's primary address. address_details longitude -97.75713136 float
DDL-026 Building Permits Permit Type Raw values indicating type of permit in abbreviated format. permit_details permit_type Electrical string
DDL-027 Building Permits Permit Sub-Type Sub Type of the permit. permit_details permit_sub_type Single Family Attached string
DDL-028 Building Permits Master Permit Number If the permit is listed as the child of another permit, this is the Project ID of that parent permit. A building permit's (BP) master permit number will reference the Plan Review Project ID, while trades under that BP will reference the BP's ID as their master. This may also be called the "parent folderRSN". permit_details master_permit_number 10743354 string
DDL-029 Building Permits Permit # Permit number for the scheduled work. permit_details permit_number 140904314 string
DDL-030 Building Permits Permit Class Indicates if the permit is intended for Residential or Commercial. This mapping is derived from the PermitClass field (if the Class starts with "R", it is residential, otherwise it is commercial). permit_details permit_class Residential string
DDL-031 Building Permits Work Description Detailed description of work permitted. permit_details work_description Addition for new bedroom, bath & closet to unit A-331 SF string
DDL-032 Building Permits Permit Applied Date Date on which the permit was applied. This relates to the original Plan Review application submission where applicable. permit_details permit_applied_date 2020-06-19 string
DDL-033 Building Permits Permit Issue Date Date on which the permit was issued. permit_details permit_issued_date 2020-06-19 string
DDL-034 Building Permits Permit Status Current Current status of permit. permit_details - - string
DDL-035 Building Permits Status Date Date on which the permit status was reported. permit_details permit_status_date 2020-06-20 string
DDL-036 Building Permits Permit Expiry Date Date on which the permit will/would have expire(d). permit_details permit_expiry_date 2020-11-05 string
DDL-037 Building Permits Stories # Number of stories of the primary building against which the permit is applied. permit_details stories 4 string
DDL-038 Building Permits Units Number of household units for a given building. permit_details units 1 string
DDL-039 Building Permits Total SqFt Total square feet of the property location. permit_details total_sqft 175 -
DDL-040 Building Permits Valuation Valuation of building or property. permit_details valuation 90000 -
DDL-041 Building Permits Comments Additional comments on the building permit. permit_details comments - -
DDL-042 Building Permits PIN Property identification number. permit_details pin 1077286 -
DDL-043 Building Permits Parcel ID A Parcel Identifier or PID is a number that uniquely identifies a parcel in the land title. permit_details - - -
DDL-044 Building Permits Permit Fees Sum of subtotal paid, subtotal unpaid and subtotal waived. permit_details permit_fees - -
DDL-045 Contractor Details Contractor Organization Company name of the Contractor. contractor_details contractor_organization Tumlinson Electric string
DDL-046 Contractor Details Contractor Name Full name of the Contractor. contractor_details contractor_name Kenneth Tumlinson string
DDL-047 Contractor Details Contractor Contact # Contractor phone number. contractor_details contractor_phone 5128450606 string
DDL-048 Contractor Details Contractor Address Line 1 Contractor street address line 1 contractor_details contractor_address_line_1 40 -
DDL-049 Contractor Details Contractor Address Line 2 Contractor street address line 2 contractor_details contractor_address_line_2 LA JOLLA CIR -
DDL-050 Contractor Details Contractor Address City Contractor City contractor_details city MONTGOMERY -
DDL-051 Contractor Details Contractor Address State Contractor State contractor_details state TX -
DDL-052 Contractor Details Contractor Address Zip Contractor Zip contractor_details zip 77356 -
DDL-053 Contractor Details Contractors License Type Permittee's / Contractor License Type contractor_details contractor_license_type GC string
DDL-054 Contractor Details Contractors License number Permittee's/Contractor License # contractor_details contractor_license_number 613010 string
DDL-055 Contractor Details Contractors License Expiry Date Expiry date of the contractor's license. contractor_details - - -
DDL-056 Owner Details Owner Full Name Owner Full Name owner_details owner_name Thomas Madden, Jr. string
DDL-057 Owner Details Owner Organization Owner Organization owner_details owner_organization RCPI TRUST string
DDL-058 Owner Details Owner Phone Owner Phone Number owner_details owner_contact_number 2123326521 string
DDL-059 Owner Details Owner Address Line 1 Owner Address Line 1 owner_details owner_address_line_1 - -
DDL-060 Owner Details Owner Address Line 2 Owner Address Line 2 owner_details owner_address_line_2 - -
DDL-061 Owner Details Owner Address Line 3 Owner Address Line 3 owner_details owner_address_line_3 - -
DDL-062 Owner Details Owner City Owner City owner_details city - -
DDL-063 Owner Details Owner Zip Owner Zip owner_details zip - -

Downloads