****updated: 8/3/2009**** Hearing Files ---------- ----------- ------------ Table Name Column Name Column Length ---------- ----------- ------------ table_pdata_arb_hearings_pp acct 7 table_pdata_arb_hearings_pp Tax_Year 2 table_pdata_arb_hearings_pp Personal 1 table_pdata_arb_hearings_pp Hearing_Type 1 table_pdata_arb_hearings_pp State_Class_Code 2 table_pdata_arb_hearings_pp Owner_Name1 50 table_pdata_arb_hearings_pp Scheduled_for_Date 10 table_pdata_arb_hearings_pp Actual_Hearing_Date 10 table_pdata_arb_hearings_pp Release_Date 10 table_pdata_arb_hearings_pp Letter_Type 2 table_pdata_arb_hearings_pp Agent_Code 4 table_pdata_arb_hearings_pp Initial_Value 4 table_pdata_arb_hearings_pp Final_Value 4 table_pdata_arb_hearings_real acct 13 table_pdata_arb_hearings_real Tax_Year 2 table_pdata_arb_hearings_real Real_Personal_Property 1 table_pdata_arb_hearings_real Hearing_Type 1 table_pdata_arb_hearings_real State_Class_Code 4 table_pdata_arb_hearings_real Owner_Name 40 table_pdata_arb_hearings_real Scheduled_for_Date 10 table_pdata_arb_hearings_real Actual_Hearing_Date 10 table_pdata_arb_hearings_real Release_Date 10 table_pdata_arb_hearings_real Letter_Type 2 table_pdata_arb_hearings_real Agent_Code 6 table_pdata_arb_hearings_real Initial_Appraised_Value 9 table_pdata_arb_hearings_real Initial_Market_Value 9 table_pdata_arb_hearings_real Final_Appraised_Value 9 table_pdata_arb_hearings_real Final_Market_Value 9 table_pdata_arb_protest_pp acct 7 table_pdata_arb_protest_pp protested_by 6 table_pdata_arb_protest_pp protested_dt 8 table_pdata_arb_protest_real acct 13 table_pdata_arb_protest_real protested_by 6 table_pdata_arb_protest_real protested_dt 8 Real Files ---------- ----------- ------------ Table Name Column Name Column Length ---------- ----------- ------------ table_pdata_building_other acct 25 table_pdata_building_other property_use_cd 4 table_pdata_building_other bld_num 4 table_pdata_building_other impr_tp 4 table_pdata_building_other impr_mdl_cd 4 table_pdata_building_other structure 3 table_pdata_building_other structure_dscr 50 table_pdata_building_other noticed_Depr_Val 4 table_pdata_building_other Depr_Val 4 table_pdata_building_other MS_replacement_cost 4 table_pdata_building_other cama_replacement_cost 4 table_pdata_building_other accrued_depr_pct 5 table_pdata_building_other qa_cd 2 table_pdata_building_other dscr 50 table_pdata_building_other date_erected 2 table_pdata_building_other eff 2 table_pdata_building_other yr_remodel 4 table_pdata_building_other yr_roll 4 table_pdata_building_other appr_by 5 table_pdata_building_other appr_dt 20 table_pdata_building_other notes 8000 table_pdata_building_other im_sq_ft 4 table_pdata_building_other act_ar 4 table_pdata_building_other heat_ar 4 table_pdata_building_other gross_ar 4 table_pdata_building_other eff_ar 4 table_pdata_building_other base_ar 4 table_pdata_building_other perimeter 4 table_pdata_building_other pct 5 table_pdata_building_other category 2 table_pdata_building_other pgi_dscr 50 table_pdata_building_other prop_nm 50 table_pdata_building_other units 15 table_pdata_building_other nra 10 table_pdata_building_other lease_rt 10 table_pdata_building_other occ_rt 10 table_pdata_building_other tot_inc 10 table_pdata_building_res acct 13 table_pdata_building_res property_use_cd 4 table_pdata_building_res bld_num 4 table_pdata_building_res impr_tp 4 table_pdata_building_res impr_mdl_cd 4 table_pdata_building_res structure 3 table_pdata_building_res structure_dscr 50 table_pdata_building_res dpr_val 4 table_pdata_building_res cama_replacement_cost 4 table_pdata_building_res accrued_depr_pct 5 table_pdata_building_res qa_cd 2 table_pdata_building_res dscr 50 table_pdata_building_res date_erected 2 table_pdata_building_res eff 2 table_pdata_building_res Expr12 4 table_pdata_building_res yr_roll 4 table_pdata_building_res appr_by 5 table_pdata_building_res appr_dt 20 table_pdata_building_res notes 8000 table_pdata_building_res im_sq_ft 4 table_pdata_building_res act_ar 4 table_pdata_building_res heat_ar 4 table_pdata_building_res gross_ar 4 table_pdata_building_res eff_ar 4 table_pdata_building_res base_ar 4 table_pdata_building_res perimeter 4 table_pdata_building_res pct 5 table_pdata_building_res bld_adj 5 table_pdata_building_res rcnld 9 table_pdata_building_res size_index 5 table_pdata_building_res lump_sum_adj 4 table_pdata_exterior acct 13 table_pdata_exterior bld_num 4 table_pdata_exterior sar_cd 3 table_pdata_exterior sar_dscr 50 table_pdata_exterior area 4 table_pdata_extra_features acct 13 table_pdata_extra_features bld_num 4 table_pdata_extra_features count 4 table_pdata_extra_features grade 4 table_pdata_extra_features cd 6 table_pdata_extra_features s_dscr 10 table_pdata_extra_features l_dscr 50 table_pdata_extra_features cat 2 table_pdata_extra_features dscr 8000 table_pdata_extra_features note 8000 table_pdata_fixtures acct 13 table_pdata_fixtures bld_num 4 table_pdata_fixtures type 3 table_pdata_fixtures type_dscr 50 table_pdata_fixtures units 5 table_pdata_jur_exempt acct 13 table_pdata_jur_exempt tax_district 3 table_pdata_jur_exempt exempt_cd 3 table_pdata_jur_exempt prior_yr_rate 5 table_pdata_jur_exempt current_yr_rate 5 table_pdata_jur_exempt pct_district 5 table_pdata_jur_exemption_dscr exempt_cd 3 table_pdata_jur_exemption_dscr exemption_dscr 50 table_pdata_jur_exemption_value Tax_District 3 table_pdata_jur_exemption_value Exemption_Code 3 table_pdata_jur_exemption_value Value 4 table_pdata_jur_exemption_value Pct 5 table_pdata_jur_tax_district_rate tax_district 3 table_pdata_jur_tax_district_rate tax_district_name 100 table_pdata_jur_tax_district_rate prior_yr_rate 5 table_pdata_jur_tax_district_rate current_yr_rate 5 table_pdata_land acct 13 table_pdata_land num 4 table_pdata_land use_cd 4 table_pdata_land use_dscr 50 table_pdata_land inf_cd 4 table_pdata_land inf_dscr 50 table_pdata_land inf_adj 5 table_pdata_land tp 2 table_pdata_land uts 9 table_pdata_land sz_fact 5 table_pdata_land inf_fact 5 table_pdata_land cond 5 table_pdata_land ovr_dscr 50 table_pdata_land tot_adj 9 table_pdata_land unit_prc 10 table_pdata_land adj_unit_prc 10 table_pdata_land val 10 table_pdata_land ovr_val 10 table_pdata_land_ag acct 13 table_pdata_land_ag num 4 table_pdata_land_ag use_cd 4 table_pdata_land_ag use_dscr 50 table_pdata_land_ag inf_cd 4 table_pdata_land_ag inf_dscr 50 table_pdata_land_ag inf_adj 5 table_pdata_land_ag tp 2 table_pdata_land_ag uts 9 table_pdata_land_ag sz_fact 5 table_pdata_land_ag inf_fact 5 table_pdata_land_ag cond 5 table_pdata_land_ag ovr_dscr 50 table_pdata_land_ag tot_adj 9 table_pdata_land_ag unit_prc 10 table_pdata_land_ag adj_unit_prc 10 table_pdata_land_ag val 10 table_pdata_land_ag ovr_val 50 table_pdata_owners acct 13 table_pdata_owners ln_num 4 table_pdata_owners name 8000 table_pdata_owners aka 8000 table_pdata_owners pct_own 5 table_pdata_ownership_history acct 13 table_pdata_ownership_history purchase_date 8 table_pdata_ownership_history name 40 table_pdata_ownership_history site_address 79 table_pdata_parcel_tieback strap 13 table_pdata_parcel_tieback tp 2 table_pdata_parcel_tieback dscr 100 table_pdata_parcel_tieback rel_strap 25 table_pdata_permits acct_num 13 table_pdata_permits id 4 table_pdata_permits agency_id 4 table_pdata_permits status 1 table_pdata_permits dscr 50 table_pdata_permits dor_cd 4 table_pdata_permits permit_type 10 table_pdata_permits permit_tp_descr 50 table_pdata_permits property_tp 3 table_pdata_permits issue_date 20 table_pdata_permits yr 4 table_pdata_permits site_num 9 table_pdata_permits site_pfx 2 table_pdata_permits site_str 50 table_pdata_permits site_tp 4 table_pdata_permits site_sfx 2 table_pdata_permits site_apt 6 table_pdata_real_acct acct 13 table_pdata_real_acct yr 4 table_pdata_real_acct mailto 8000 table_pdata_real_acct mail_addr_1 8000 table_pdata_real_acct mail_addr_2 8000 table_pdata_real_acct mail_city 50 table_pdata_real_acct mail_state 10 table_pdata_real_acct mail_zip 10 table_pdata_real_acct mail_country 50 table_pdata_real_acct str_pfx 2 table_pdata_real_acct str_num 4 table_pdata_real_acct str_num_sfx 3 table_pdata_real_acct str 50 table_pdata_real_acct str_sfx 10 table_pdata_real_acct str_sfx_dir 2 table_pdata_real_acct str_unit 15 table_pdata_real_acct site_addr_1 83 table_pdata_real_acct site_addr_2 50 table_pdata_real_acct site_addr_3 10 table_pdata_real_acct state_class 4 table_pdata_real_acct school_dist 3 table_pdata_real_acct map_facet 6 table_pdata_real_acct key_map 6 table_pdata_real_acct Neighborhood_Code 5 table_pdata_real_acct Neighborhood_Grp 8 table_pdata_real_acct econ_area 100 table_pdata_real_acct econ_bld_class 100 table_pdata_real_acct center_code 100 table_pdata_real_acct yr_impr 4 table_pdata_real_acct yr_annexed 4 table_pdata_real_acct splt_dt 20 table_pdata_real_acct dsc_cd 2 table_pdata_real_acct nxt_bld 4 table_pdata_real_acct bld_ar 8 table_pdata_real_acct land_ar 8 table_pdata_real_acct acreage 9 table_pdata_real_acct Cap_acct 7 table_pdata_real_acct shared_cad 3 table_pdata_real_acct land_val 8 table_pdata_real_acct bld_val 8 table_pdata_real_acct x_features_val 8 table_pdata_real_acct ag_val 8 table_pdata_real_acct assessed_val 8 table_pdata_real_acct tot_appr_val 8 table_pdata_real_acct tot_mkt_val 8 table_pdata_real_acct prior_land_val 8 table_pdata_real_acct prior_bld_val 8 table_pdata_real_acct prior_x_features_val 8 table_pdata_real_acct prior_ag_val 8 table_pdata_real_acct prior_tot_appr_val 8 table_pdata_real_acct prior_tot_mkt_val 8 table_pdata_real_acct new_construction_val 8 table_pdata_real_acct tot_rcn_val 8 table_pdata_real_acct value_status 36 table_pdata_real_acct noticed 1 table_pdata_real_acct notice_dt 8 table_pdata_real_acct protested 1 table_pdata_real_acct certified_date 8 table_pdata_real_acct rev_dt 8 table_pdata_real_acct rev_by 5 table_pdata_real_acct new_own_dt 8 table_pdata_real_acct lgl_1 50 table_pdata_real_acct lgl_2 50 table_pdata_real_acct lgl_3 50 table_pdata_real_acct lgl_4 50 table_pdata_real_acct mill_cd 100 table_pdata_real_acct_agents acct 13 table_pdata_real_acct_agents agent_id 4 table_pdata_real_acct_agents agent_name 100 table_pdata_real_acct_agents agent_office_phone 14 table_pdata_real_acct_agents agent_addr_1 40 table_pdata_real_acct_agents agent_addr_2 40 table_pdata_real_acct_agents agent_city 30 table_pdata_real_acct_agents agent_state 2 table_pdata_real_acct_agents agent_zip 10 table_pdata_structural_elem1 acct 13 table_pdata_structural_elem1 bld_num 4 table_pdata_structural_elem1 code 2 table_pdata_structural_elem1 adj 5 table_pdata_structural_elem1 type 3 table_pdata_structural_elem1 type_dscr 50 table_pdata_structural_elem1 category_dscr 50 table_pdata_structural_elem1 dor_cd 4 table_pdata_structural_elem2 acct 13 table_pdata_structural_elem2 bld_num 4 table_pdata_structural_elem2 code 2 table_pdata_structural_elem1 adj 5 table_pdata_structural_elem2 type 3 table_pdata_structural_elem2 type_dscr 50 table_pdata_structural_elem2 category_dscr 50 table_pdata_structural_elem2 dor_cd 4 table_pdata_structural_elem3 acct 13 table_pdata_structural_elem3 bld_num 4 table_pdata_structural_elem3 code 2 table_pdata_structural_elem1 adj 5 table_pdata_structural_elem3 type 3 table_pdata_structural_elem3 type_dscr 50 table_pdata_structural_elem3 category_dscr 50 table_pdata_structural_elem3 dor_cd 4 Personal Files ---------- ----------- ------------ Table Name Column Name Column Length ---------- ----------- ------------ table_pdata_t_business_acct acct 7 table_pdata_t_business_acct tax_year 4 table_pdata_t_business_acct name 8000 table_pdata_t_business_acct bus_name 8000 table_pdata_t_business_acct site_addr 82 table_pdata_t_business_acct site_city 50 table_pdata_t_business_acct site_state 5 table_pdata_t_business_acct site_zip 10 table_pdata_t_business_acct mailto 8000 table_pdata_t_business_acct mail_addr_1 50 table_pdata_t_business_acct mail_addr_2 50 table_pdata_t_business_acct mail_city 50 table_pdata_t_business_acct mail_state 2 table_pdata_t_business_acct mail_zip 10 table_pdata_t_business_acct phone 10 table_pdata_t_business_acct dscr 80 table_pdata_t_business_acct dscr1 50 table_pdata_t_business_acct dscr2 50 table_pdata_t_business_acct dscr3 50 table_pdata_t_business_acct sched_cd 1 table_pdata_t_business_acct sched_code_dscr 50 table_pdata_t_business_acct class_code 2 table_pdata_t_business_acct class_code_dscr 50 table_pdata_t_business_acct sic 8 table_pdata_t_business_acct sic_dscr 100 table_pdata_t_business_acct sqft 100 table_pdata_t_business_acct cntr_cd 2 table_pdata_t_business_acct shared_cad 1 table_pdata_t_business_acct key_map 6 table_pdata_t_business_acct asd_val 10 table_pdata_t_business_acct prior_asd_val 10 table_pdata_t_business_acct return_cd 52 table_pdata_t_business_acct value_status 36 table_pdata_t_business_acct noticed 1 table_pdata_t_business_acct noticed_dt 8 table_pdata_t_business_acct protested 1 table_pdata_t_business_acct certified_date 8 table_pdata_t_business_acct agent_id 20 table_pdata_t_business_acct Jurs 100 table_pdata_t_business_detail acct 7 table_pdata_t_business_detail ln_num 4 table_pdata_t_business_detail dept_grp 4 table_pdata_t_business_detail dscr 50 table_pdata_t_business_detail asd_val 12 table_pdata_t_jur_exempt acct 12 table_pdata_t_jur_exempt tax_dist 6 table_pdata_t_jur_exempt name 100 table_pdata_t_jur_exempt cd 4 table_pdata_t_jur_exempt dscr 50 table_pdata_t_jur_exempt pct_exempt 5 table_pdata_t_jur_exempt pct_district 9 table_pdata_t_pp_c acct 7 table_pdata_t_pp_c sched_cd 1 table_pdata_t_pp_c pipe_usage 100 table_pdata_t_pp_c pipe_size 100 table_pdata_t_pp_c Pipe_Mileage 100 table_pdata_t_pp_c Year_Installed 100 table_pdata_t_pp_c Pipe_Type 100 table_pdata_t_pp_c Regulation 100 table_pdata_t_pp_c Usage_Factor 100 table_pdata_t_pp_c Status 100 table_pdata_t_pp_c Pipe_ID 100 table_pdata_t_pp_c HCAD_ID 100 table_pdata_t_pp_e acct 7 table_pdata_t_pp_e sched_cd 1 table_pdata_t_pp_e Div_ord 100 table_pdata_t_pp_e Type_Interest 100 table_pdata_t_pp_e Interest_Percent 100 table_pdata_t_pp_l acct 7 table_pdata_t_pp_l sched_cd 1 table_pdata_t_pp_l type_structure 100 table_pdata_t_pp_l volt_amp 100 table_pdata_t_pp_l el_mileage 100 table_pdata_t_pp_l Num_of_circuits 100 table_pdata_t_pp_l contract_acct 100