| Field | Format | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Assessment Value | Number Field No $ sign, comma separated groups, or decimal values. Ex. $20,000.00 should be entered as 20000. |
||||||||||||||||||||
| Deed Book | String Field No comma separated groups, or decimal values. Ex. 1,127 should be entered as 1127 Ex. 551 should be entered as 0000551 |
||||||||||||||||||||
| Deed Page | String Field No comma separated groups, or decimal values. Ex. 1,127 should be entered as 1127 Ex. 551 should be entered as 0000551 |
||||||||||||||||||||
| Deed Consideration | Number Field No $ sign, comma separated groups, or decimal values. Ex. $20,000.00 should be entered as 20000. |
||||||||||||||||||||
| Deeded Acres | Number Field No comma separated groups. Ex. 0.02 acres should be entered as .02 |
||||||||||||||||||||
| Improvement Value | Number Field No $ sign, comma separated groups, or decimal values. Ex. $20,000.00 should be entered as 20000. |
||||||||||||||||||||
| Condition | String Field - Must use the LIKE operator
|
||||||||||||||||||||
| Land Value | Number Field No $ sign, comma separated groups, or decimal values. Ex. $20,000.00 should be entered as 20000. |
||||||||||||||||||||
| Property Address | String Field Ex. 1402 WOODCHUCK |
||||||||||||||||||||
| Subdivision Code | |||||||||||||||||||||
| Subdivision Lot | String Field No $ sign, comma separated groups, or decimal values. Ex. $20,000.00 should be entered as 20000. |
||||||||||||||||||||
| Total Appraised Value | Number Field No $ sign, comma separated groups, or decimal values. Ex. $20,000.00 should be entered as 20000. |
||||||||||||||||||||
| Total Area | Number Field ( First Level + Upper Level ) = Total Square Footage per Improvement. No comma separated groups, or decimal values. Ex. 1500 should be entered as 1500 Note: If you search for Total Square Footage = 1500 it can return a property that has multi improvements. Add up all of the improvements and it will have a Total Square Footage of 1500. |
| Comparator | Definition |
|---|---|
| Less Than | Something less then something else. Ex. 1 is less then 2 |
| Less Than Or Equal | Something less than or equal to something else. Ex. 1 is less then or equals 2 |
| Greater Than | Something greater then something else. Ex. 2 is greater then 1 |
| Greater Than Or Equal | Something greater than or equal to something else. Ex. 2 is greater than or equals 1 |
| Equal To | Something that is the same. Ex. Illinois = Illinois |
| Like | Something that is like something else. Ex. Ill is like Illinois, because Ill is in Illinois |
| Is Null | Something that has no value. Ex. Date sold is empty |
| Is Not Null | Something that has a value. Ex. Date sold is not empty |