{% docs table_aasysjur %}
Control table for asmt admin module - multi-jurisdiction version.
Primary Key: jur
{% enddocs %}
{% docs table_addn %}
Residential additions. Stores data about Home Improvement Exemptions (HIEs)
and other information about iasworld.dweldat properties.
- In order to isolate HIEs, condition on
lline > 0 - HIEs from
addncan be joined to dweldat by card - The characteristic changes in
addnare applied immediately to the correspondingdweldatcharacteristics rather then when HIEs "roll off". - Individual HIEs are defined within start/end year and card
Primary Key: jur, taxyr, parid, card, lline
{% enddocs %}
{% docs table_addrindx %} Address lookup tied to a table/column/line.
Primary Key: jur, taxyr, parid, card, lline, tble, tabseq
{% enddocs %}
{% docs table_aprval %} Summary of market values (no assessed values).
Primary Key: jur, taxyr, parid
{% enddocs %}
{% docs table_asmt_all %}
Main assessment table, union of iasworld.asmt and iasworld.asmt_hist.
Provides the latest assessed value for each PIN and used heavily in
Data Department views.
- Unlike most
iasworldtables, this table does not usecur = 'Y'to identify the most recent record (it usesprocnameinstead).
Primary Key: jur, rolltype, valclass, valyear, distcode,
seq taxyr, parid, card
{% enddocs %}
{% docs table_asmt_hist %}
History table for assessments that stores non-current records. Same schema
as iasworld.asmt_all.
Primary Key: jur, rolltype, valclass, valyear, distcode,
seq taxyr, parid, card
{% enddocs %}
{% docs table_cname %} Owner code table for owner names.
Primary Key: jur, ownnum
{% enddocs %}
{% docs table_comdat %} Major building table for commercial properties, which includes basically any non-class 2 property besides land.
Primary Key: jur, taxyr, parid, card
{% enddocs %}
{% docs table_comnt %} Unlimited notes table.
Primary Key: jur, parid, code, comtno, caseno
{% enddocs %}
{% docs table_cvleg %} Conveyance/sales information. Holds additional info about each sale, such as PTAX-203 data.
Primary Key: jur, taxyr, parid, conveyno
{% enddocs %}
{% docs table_cvown %} Conveyance/owner information.
Primary Key: jur, taxyr, conveyno, ownseq
{% enddocs %}
{% docs table_cvtran %} Header table for conveyance transactions.
Primary Key: jur, taxyr, conveyno
{% enddocs %}
{% docs table_dedit %} CCAO land use code descriptions + edit code descriptions.
Primary Key: tbl1, fld1, tbl2, fld2, val1, val2
{% enddocs %}
{% docs table_dweldat %} Residential property characteristics table (excluding residential condominiums).
Primary Key: jur, taxyr, parid, lline
{% enddocs %}
{% docs table_enter %} Field inspection tracking table.
Primary Key: jur, taxyr, parid
{% enddocs %}
{% docs table_exadmn %} Exemption applications table.
Primary Key: jur, taxyr, parid, caseno
{% enddocs %}
{% docs table_exapp %} Exemption applicant information table.
Primary Key: jur, taxyr, parid, caseno
{% enddocs %}
{% docs table_excode %} Exemption code table. In order to match these codes to our commonly defined exemptions we aggregate them (for 2024 and later) as below:
- homestead exemption
C-HO: GENERAL HOMESTEAD EXEMPTION - COOPHO: GENERAL HOMESTEAD EXEMPTION
- senior homestead exemption
C-SR: SENIOR HOMESTEAD - COOPSR: SENIOR HOMESTEAD
- senior freeze exemption
C-SF: SENIOR FREEZE - COOPSF: SENIOR FREEZE
- long-time homeowner exemption
C-LT: LONG-TIME HOMEOWNER - COOPLT: LONG-TIME HOMEOWNER
- returning veterans exemption
C-RTV: RETURNING VETERAN - COOPRTV: RETURNING VETERANS
- disabled persons exemption
C-DP: DISABLED PERSONS - COOPDP: DISABLED PERSON HOMESTD EX
- veterans with disabilites exemption
C-DV1: DISABLED VETERAN 30-49% - COOPC-DV2: DISABLED VETERAN 50-69% - COOPDV1: DISABLED VETERAN 30-49%DV2: DISABLED VETERAN 50-69%DV3: DISABLED VETERAN 70% OR GREATERDV3-M: DV3 MULTI-UNITDV4: DISABLED VETERAN 100%, TOTALLY AND PERMANENTLY DISABLEDDV4-M: DV4 MULTI-UNIT
- municipality-built gradual exemption
MUNI: MUNICIPALITY-BUILT GRADUAL EXEMPTION
- world war 2 veteran exemption
WW2: WORLD WAR 2 VETERAN 100%
NOTE: Some exemption codes are not included in these aggregations since they
apply to AV rather than EAV, the most notable being
DV5: DISABLED VETERAN IDOR 100%. For more information see exemptions.xlsx.
Primary Key: jur, taxyr, excode
{% enddocs %}
{% docs table_exdet %} Exemption administration detail lines tied to all or part of a parcel.
Primary Key: jur, taxyr, parid, card, lline, excode,
lineno, scrn, fld
{% enddocs %}
{% docs table_htagnt %} Agent/attorney code maintenance and name storage.
Primary Key: jur, agent
{% enddocs %}
{% docs table_htdates %} Hearing date and note maintenance.
Primary Key: jur, taxyr, parid, heartyp, subkey
{% enddocs %}
{% docs table_htpar %} Appeals are currently unavailable pre-2021. We expect to have them back by the end of 2025.
Main appeal tracking table. Used in the construction of Data Department appeal views.
Primary Key: jur, taxyr, parid, heartyp, subkey,
caseno, hrreas
{% enddocs %}
{% docs table_htval %} Appeal actions, i.e. value changes that the CCAO makes upon appeal.
Similar to asmt tables, you must filter this table for valclass IS NULL
in order to retrieve the final version of each action.
This table is still relatively new to us, and we are working on documenting it.
Primary Key: taxyr, parid, caseno, subkey, valclass
{% enddocs %}
{% docs table_land %} Main land information table. Stores the land size, number of lines, proration, etc. of all parcels.
Primary Key: jur, taxyr, parid, lline
{% enddocs %}
{% docs table_legdat %} Parcel legal descriptions and addresses. Stores township, property address, and other location information about each parcel.
Primary Key: jur, taxyr, parid
{% enddocs %}
{% docs table_lpmod %} Calp model.
Primary Key: jur, ltype, lcode, ver, nmod, zmod, lmod,
smod, umod
{% enddocs %}
{% docs table_lpnbhd %} Neighborhood parameter table for calp, valuation models, etc.
Primary Key: jur, ver, nbhd
{% enddocs %}
{% docs table_maildat %} Taxpayer information such as name and mailing address.
- Taxpayer mailing addresses are not necessarily the same as property owner
mailing addresses. For property owner addresses, see
iasworld.owndat.
Primary Key: jur, taxyr, parid
{% enddocs %}
{% docs table_oby %} Outbuilding table. This is the main storage table for condo unit-level data. It also stores other miscellaneous sub-PIN information like HIEs.
- In order to isolate HIEs, condition on
class = '288' - HIEs from
obycannot necessarily be joined todweldatby card, though that is the intended behavior - The characteristic changes in
obyare applied immediately to the correspondingdweldatcharacteristics rather then when HIEs "roll off". - Individual HIEs are defined within start/end year and card
Primary Key: jur, taxyr, parid, card, lline
{% enddocs %}
{% docs table_owndat %} Property owner information such as name and mailing address.
- Mailing addresses and owner names have not been regularly updated since 2017.
- Property owner mailing addresses are not necessarily the same as taxpayer
mailing addresses. For taxpayer addresses, see
iasworld.maildat.
Primary Key: jur, taxyr, parid
{% enddocs %}
{% docs table_pardat %}
Universe of all Cook County parcels for each tax year. This is the base
table, along with iasworld.legdat.
Primary Key: jur, taxyr, parid
{% enddocs %}
{% docs table_permit %} Building permit ingestion and processing.
See default.vw_pin_permit
for a view of this table that selects active rows and relevant columns.
Primary Key: parid, num
{% enddocs %}
{% docs table_rcoby %} Outbuilding cost table.
Primary Key: ver, code
{% enddocs %}
{% docs table_sales %} Main table for tracking property sales. Sales are ingested and populated manually from IDOR's MyDec platform.
Primary Key: jur, parid, saledt, instruno
{% enddocs %}
{% docs table_splcom %} Split tracking AKA divisions table.
Primary Key: jur, taxyr, splitno
{% enddocs %}
{% docs table_valclass %} Class definitions and assessment levels.
Primary Key: jur, taxyr, rolltype, class, luc, vclass
{% enddocs %}