Data Dictionary

Data Element Section Master Field Name Description Type Sub Type Example Data Type
DDL-01 Applicant Details Applicant Full Name Full name of the Applicant applicant_details applicant_name Donna Kirkpatrick string
DDL-02 Applicant Details Applicant Organization Organization the applicant is associated with. applicant_details applicant_organization - string
DDL-03 Applicant Details Applicant Phone Applicant Phone Number applicant_details applicant_phone 5123264223 string
DDL-04 Applicant Details Applicant Address Applicant Address applicant_details applicant_address 7901 E Riverside Austin  03001 string
DDL-05 Building Location Job Street Address Property address associated with the permit. address_details street S CONGRESS AVE string
DDL-06 Building Location Job City City of the property associated with the permit. address_details city JACKSONVILLE string
DDL-07 Building Location Job State State of the property associated with the permit. address_details state TX string
DDL-08 Building Location Job Zip Zip of the property associated with the permit. address_details zip 78704 string
DDL-09 Building Location Latitude The Latitude of the property's primary address. address_details latitude 30.23209318 float
DDL-10 Building Location Longitude The Longitude of the property's primary address. address_details longitude -97.75713136 float
DDL-11 Building Permits Permit Type Raw values indicating type of permit in abbreviated format. permit_details permit_type Electrical string
DDL-12 Building Permits Permit Sub-Type Sub Type of the permit. permit_details permit_sub_type Single Family Attached string
DDL-13 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-14 Building Permits Permit # Permit number for the scheduled work. permit_details permit_number 140904314 string
DDL-15 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-16 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-17 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-18 Building Permits Permit Issue Date Date on which the permit was issued. permit_details permit_issued_date 2020-06-19 string
DDL-19 Building Permits Permit Category Category to which the applied permit is classified. permit_details permit_category Building Permit string
DDL-20 Building Permits Permit Status Current Current status of permit. permit_details permit_status Final string
DDL-21 Building Permits Status Date Date on which the permit status was reported. permit_details permit_status_date 2020-06-20 string
DDL-22 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-23 Building Permits Stories # Number of stories of the primary building against which the permit is applied. permit_details stories 4 string
DDL-24 Building Permits Units Number of household units for a given building. permit_details units 1 string
DDL-25 Building Permits Total SqFt Total square feet of the property location. permit_details total_sqft 175 -
DDL-26 Building Permits Valuation Valuation of building or property. permit_details valuation 90000 -
DDL-27 Building Permits Comments Additional comments on the building permit. permit_details comments - -
DDL-28 Building Permits PIN Property identification number. permit_details pin 1077286 -
DDL-29 Building Permits Parcel ID A Parcel Identifier or PID is a number that uniquely identifies a parcel in the land title. permit_details - - -
DDL-30 Building Permits Permit Fees Sum of subtotal paid subtotal unpaid and subtotal waived.1 permit_details permit_fees -
DDL-31 Contractor Details Contractor Organization Company name of the Contractor. contractor_details contractor_organization Tumlinson Electric string
DDL-32 Contractor Details Contractor Name Full name of the Contractor. contractor_details contractor_name Kenneth Tumlinson string
DDL-33 Contractor Details Contractor Contact # Contractor phone number. contractor_details contractor_phone 5128450606 string
DDL-34 Contractor Details Contractor Address Contractor address contractor_details contractor_address 40 LA JOLLA CIR MONTGOMERY TX 77356 -
DDL-35 Contractor Details Contractors License Type Permittee's / Contractor License Type contractor_details contractor_license_type GC string
DDL-36 Contractor Details Contractors License number Permittee's/Contractor License # contractor_details contractor_license_number 613010 string
DDL-37 Contractor Details Contractors License Expiry Date Expiry date of the contractor's license. contractor_details - - -
DDL-38 Owner Details Owner Full Name Owner Full Name owner_details owner_name Thomas Madden Jr. string
DDL-39 Owner Details Owner Organization Owner Organization owner_details owner_organization RCPI TRUST string
DDL-40 Owner Details Owner Phone Owner Phone Number owner_details owner_contact_number 2123326521 string
DDL-41 Owner Details Owner Address Owner Address owner_details owner_address - -

Downloads