WA PACS Database Guide

Column Name

Attribute

Allows Null

Description

acct_id

int

NO

Distinct account ID; created from dbo.next_account_id and cannot be zero

addr_type_cd

char (5)

NO

Address type code; values from dbo.address_type.addr_type_cd

primary_addr

char (1)

YES

primary address flag; only one adfdress record per account id can be flagged as primary. Values are ‘Y’ and ‘N’

addr_line1

varchar (60)

YES

Address line 1

addr_line2

varchar (60)

YES

Address line 2

addr_line3

varchar (60)

YES

Address line 3

addr_city

varchar (50)

YES

City

addr_state

varchar (50)

YES

State

country_cd

char (5)

YES

Country

ml_returned_dt

datetime

YES

Datetime mail was returned

ml_type_cd

char (5)

YES

Mail type code; values from dbo.mail_type.ml_type_cd

ml_deliverable

char (1)

YES

Mail deliverable flag; values are ‘Y’ or ‘N’

ml_return_type_cd

char (5)

YES

Mail return type code; values from dbo.mail_returned_type.ml_return_type_cd

ml_returned_reason

varchar (50)

YES

Mail returned reason/comment

cass_dt

datetime

YES

Datetime of Coding Accuracy Support System match/import

delivery_point

varchar (2)

YES

Address delivery point

carrier_route

varchar (5)

YES

Address carrier route

check_digit

varchar (2)

YES

Address check digit

update_flag

char (1)

YES

Address update flag

chg_reason_cd

char (5)

YES

Address change reason code; values from dbo.chg_reason.chg_reason_cd

last_change_dt

datetime

YES

Datetime the address record was last changed/modified

zip

varchar (5)

YES

Address zipcode

cass

varchar (4)

YES

Address CASS identifier

route

varchar (2)

YES

Address route

addr_zip

varchar (10)

YES

Address zipcode

zip_4_2

varchar (14)

YES

Address zipcode + 4 digits (ex. 75068-123, etc.)

is_international

bit

NO

indicates whether the address an an international address (non-US)

Column Name

Attribute

Allows Null

Description

acct_id

int

NO

Distinct account ID; created from dbo.next_account_id and cannot be zero

first_name

varchar (30)

YES

First name on the account

last_name

varchar (30)

YES

Last name on the account

Account Table, cont.

file_as_name

varchar (70)

YES

The file-as name of the person listed on the account

dl_num

varchar (10)

YES

Driver’s license number

dl_state

char (2)

YES

State listed on the account person’s driver’s license

dl_expir_dt

datetime

YES

Driver’s license expiration date

merged_acct_id

char (5)

YES

(not used)

acct_create_dt

datetime

YES

Date and time account was created

opening_balance

money (19,4)

YES

(not used)

comment

varchar (2048)

YES

Comments on the account

misc_code

varchar (50)

YES

Miscellaneous code

ref_id1

varchar (50)

YES

Reference ID 1

source

varchar (30)

YES

The origin or source of the account’s info, i.e., whether it was imported or manually entered, etc.

ref_acct_id

int

YES

(not used)

confidential_flag

char (1)

YES

Confidential flag; values here are ‘T’ or ‘F’

confidential_file_as_name

varchar (70)

YES

The file-as namke listed on an account flagged as confidential

confidential_first_name

varchar (30)

YES

The first name listed on a confidential account

confidential_last_name

varchar (30)

YES

The last name listed on a confidential account

dist_m_n_o

int

YES

(not used)

dist_i_n_s

int

YES

(not used)

dist_pi

int

YES

(not used)

dist_atty_fees

int

YES

(not used)

dist_overages

int

YES

(not used)

dist_tax_cert_fees

int

YES

(not used)

dist_misc_fees

int

YES

(not used)

dist_vit

int

YES

(not used)

email_addr

varchar (50)

YES

The email address listed on the account

web_addr

varchar (50)

YES

The web site or URL listed on or associated with the account

ftp_addr

varchar (50)

YES

The FTP URL listed on or associated with the site (FTP = File Transfer Protocol; generally, a URL that allows users to upload or download files)

update_dt

datetime

YES

Date and time the account was last updated

web_suppression

char (1)

YES

Website suppression flag; valid values are ‘Y’ or ‘N’. Suppressed sites do not display in online county databases

appr_company_id

int

YES

Appraisal company associated with the account; IDs are stored in dbo.appr_company

Column Name

Attribute

Allows Null

Description

year

numeric (4,0)

NO

The tax year on the assessment bill

agency_id

int

NO

The unique ID of the assessment agency that assessed the bill

bill_id

int

NO

The unique ID of of the bill

Column Name

Attribute

Allows Null

Description

bill_id

int

NO

The unique ID of the bill

prop_id

int

YES

The ID of the property whose value and ownership has been billed

year

numeric (4,0)

YES

The year on the bill

sup_num

int

YES

The supplement group number associated with the billing

owner_id

int

YES

The ID of the owner assessed the bill

initial_amount_due

numeric (14,2)

YES

The original amount billed for

current_amount_due

numeric (14,2)

YES

The current amount doe on the bill (after P&I, etc)

amount_paid

numeric (14,2)

YES

The amount that has been paid on the bill to date

bill_type

varchar (5)

YES

The type of bill

effective_due_date

datetime

YES

The effective payment due date of the bill

earliest_collection_date

datetime

YES

The date and time from and after which payment can be accepted

statement_id

int

YES

The unique ID of the statement associated with the bill

code

varchar (10)

YES

The bill code file on the bill

is_active

bit

NO

Indicates whether he bill has been activated

last_modified

datetime

YES

Indicates whether the bill has been adjusted/modified

adj_effective_dt

datetime

YES

The date from which an adjustment takes effect

adj_expiration_dt

datetime

YES

The date from which an adjustment to the bill is no longer effective

comment

varchar (500)

YES

Any comments on the bill

payment_status_type_cd

varchar (10)

YES

The bill’s payment status code, such as half pay, etc.

created_by_type_cd

varchar (10)

YES

rollback_id

int

YES

The rollback record associated with the bill

payment_group_id

int

YES

display_year

numeric (5,0)

YES

cnv_xref

varchar (50)

YES

is_overpaid

bit

NO

Indicates whether the bill payment was more than the amount due

Column Name

Attribute

Allows Null

Description

bill_id

int

NO

The unique ID of the bill

bill_payment_id

int

NO

The unique ID given any payment record for the bill

amount_due

numeric (14,2)

NO

The amount due on the bill

amount_paid

numeric (14,2)

NO

The amount paid on the bill

due_date

datetime

YES

The date payment on the bill is due

is_payout_payment

bit

NO

Indicates whether the bill has been structured as a payout agreement/installment agreement

Column Name

Attribute

Allows Null

Description

chg_of_owner_id

int

NO

unique id established by PACS at the time of sale

deed_type_cd

char (10)

YES

value from deed_type_cd field in deed_type table. Entered by the user

deed_num

varchar (50)

YES

deed number from the deed

deed_book_id

char (20)

YES

deed book number, if any

deed_book_page

char (20)

YES

deed page number, if any

deed_dt

datetime

YES

date of the deed

coo_sl_dt

datetime

YES

date deed was entered into PACS

consideration

char (20)

YES

from the deed, it is usually the sales price

buyer_lttr_url

varchar (50)

YES

copy of the buyer letter location after printed

seller_lttr_url

varchar (50)

YES

copy of the buyer letter location after printed

buyer_lttr_prt_dt

datetime

YES

date buyer letter was printed

seller_lttr_prt_dt

datetime

YES

date seller letter was printed

comment

varchar (500)

YES

comments entered by the clerk entering the deed

ref_id1

varchar (20)

YES

normally used for conversions to store IDs from outside databases, but does not display

grantor_cv

varchar (30)

YES

seller file as name if seller_assoc record is not populated

grantee_cv

varchar (30)

YES

buyer file as name if buyer_assoc record not populated

recorded_dt

datetime

YES

date deed recorded

coo_exported_flag

char (1)

YES

date sale was exported to the State – Texas only

lttr_id

int

YES

ID of the letter printer

print_buyer_letter

bit

YES

Indicates whether the buyer letter has been printed

print_seller_letter

bit

YES

Indicates whether the seller letter has been printed

excise_number

int

YES

number issued in the State of WA from the recorders office

override_excise

bit

NO

overriding the excise number flag

Column Name

Attribute

Allows Null

Description

chg_of_owner_id

int

NO

unique ID established by PACS at the time of sale

prop_id

int

NO

property ID

seq_num

int

NO

the most recent sale is set at sequence 0.  All other sequence numbers are set at +1 within the COOPA

sup_tax_yr

numeric (4,0)

NO

year layer of the transfer

imprv_hstd_val

numeric (14,0)

YES

improvement homestead value at time of sale

imprv_non_hstd_val

numeric (14,0)

YES

improvement non homestead value at time of sale

land_hstd_val

numeric (14,0)

YES

land homestead value at time of sale

land_non_hstd_val

numeric (14,0)

YES

land non homestead value at time of sale

ag_use_val

numeric (14,0)

YES

agricultural use value at time of sale

ag_market

numeric (14,0)

YES

agricultural market value at time of sale

ag_loss

numeric (14,0)

YES

agricultural loss value at time of sale

timber_use

numeric (14,0)

YES

timber use value at time of sale

timber_market

numeric (14,0)

YES

timber market value at time of sale

timber_loss

numeric (14,0)

YES

timber loss value at time of sale

appraised_val

numeric (14,0)

YES

appraised value at time of sale

assessed_val

numeric (14,0)

YES

assessed value at time of sale

market

numeric (14,0)

YES

market value at time of sale

bPrimary

bit

YES

if more than one property sold in a single transaction, this indicates the primary property in the transfer

continue_current_use

bit

YES

for Washington, a flag to indicate if the current use needs to continue

Column Name

Attribute

Allows Null

Description

transaction_id

int

NO

The unique ID associated with an accounting-related transaction

trans_group_id

int

NO

The ID associated with a grouping of accounting-related transactions

base_amount

numeric (14,2)

NO

The base amount value associated with a transaction

base_amount_pd

numeric (14,2)

NO

The base amount paid in an accounting-related transaction

penalty_amount_pd

numeric (14,2)

NO

The amount paid on penalties assessed in connection with a transaction

interest_amount_pd

numeric (14,2)

NO

The amount paid on interest assessed in connection with a transaction

bond_interest_pd

numeric (14,2)

NO

The amount paid on any bond interest assessed in connection with a transaction

transaction_type

varchar (25)

YES

The type of accounting-related transaction (i.e., refund, collections payment)

underage_amount_pd

numeric (14,2)

NO

The underage allowed on a transaction

overage_amount_pd

numeric (14,2)

NO

The overage allowed on a transaction

other_amount_pd

numeric (14,2)

NO

Amounts paid other than the base amount paid in a transaction

pacs_user_id

int

YES

The PACS user ID that recorded a given transaction

transaction_date

datetime

YES

The date of the accounting-related transaction

batch_id

int

NO

The batch ID associated with a transaction

create_date

datetime [ this field’s default value is (getdate()) ]

NO

The date on which a transaction record was created

Column Name

Attribute

Allows Null

Description

fee_id

int

NO

The unique ID assigned to the fee when the fee is assessed

year

numeric (4,0)

NO

The year the fee is assessed

fee_type_cd

varchar (10)

YES

The fee type code (i.e., miscellaneous fee)

owner_id

int

YES

The ID of the owner who has been assessed the fee

statement_id

int

YES

The statement on which the fee is included

initial_amount_due

numeric (14,2)

YES

The initial amount due on the fee

current_amount_due

numeric (14,2)

YES

The current amount due on the assessed fee

amount_paid

numeric (14,2)

NO

The amount paid on the fee

amount_due_override

bit

YES

Indicates whether the amount due has been overridden and modified

effective_due_date

datetime

YES

The effective date payment is due for the fee

comment

varchar (255)

YES

Comments associated with the fee record/ID

fee_create_date

datetime

YES

The date on which the fee record was created

last_modified

datetime

YES

The most recent date on which the fee record was modified/adjusted

code

varchar (10)

YES

The bill/fee code

payment_status_type_cd

varchar (10)

YES

The payment status code (i.e., whether the fee payment must be in full)

payout_agreement_id

int

YES

The ID of the payout agreement created to accomodate fee payment

sup_num

int

YES

The supplement group number used when assessing the fee, if appropriate

rollback_id

int

YES

The ID of the rollback transaction associated with the fee assessment, if any

is_active

bit

NO

Indicates whether the fee has been activated

payment_group_id

int

YES

The group ID associated with the payment

display_year

numeric (5,0)

YES

cnv_xref

varchar (50)

YES

is_overpaid

bit

NO

Indicates whether the fee payment was more than the amount due

misc_rcpt_cd

varchar (10)

YES

The MR Template code of the template used to create line items for a miscellaneous receipt fee

Column Name

Attribute

Allows Null

Description

fee_id

int

NO

The unique ID assigned when a fee is assessed

fee_payment_id

int

NO

The ID assigned to fee payment

year

numeric (4,0)

NO

The year of the fee transaction

amount_due

numeric (14,2)

NO

The amount due from the fee

amount_paid

numeric (14,2)

NO

The amount paid on the fee

due_date

datetime

YES

The date on which payment on the fee is due

is_payout_payment

bit

NO

Indicates whether a fee transaction is part of a structured payout agreement

Column Name

Attribute

Allows Null

Description

year

numeric (4,0)

NO

The year the levy is applied

tax_district_id

int

NO

The ID of the tax district associated with the levy

levy_cd

varchar (10)

NO

The abbreviation representing the subject levy

end_year

numeric (4,0)

YES

The end year on the levy record

levy_type_cd

varchar (10)

YES

The levy type code file assigned to the levy by the user

voted

bit

YES

Indicates whether the levy rate was voted on

levy_rate

numeric (13,10)

YES

The tax rate for the levy

population_count_enable

bit

YES

Indicates whether the Population Count option is selected on the levy record

population_count

int

YES

The number entered for the population count (applicable when the Population Count option is selected on the levy record)

employee_cert_enable

bit

YES

Indicates whether the Employee Cert Received option is selected on the levy record

employee_cert

datetime

YES

The date entered by the user when the Employee Cert Received option is selected on the levy record

full_time_emp

bit

YES

Indicates whether the user selected Full Time Emp on the levy record

budget_received

datetime

YES

The date entered by the user when the Budget Received option is selected on the levy record

budget_received_enable

bit

YES

Indicates whether the Budget Received option is selected on the levy record

budget_amount_enable

bit

YES

Indicates that the Budget Amount option on the levy record has been activated by the user

budget_amount

numeric (14,2)

YES

The value entered by the user when the Budget Amount option on the levy record is activated by the user

first_resolution_enable

bit

YES

Indicates whether the 1st Resolution Received option is selected on the levy

first_resolution_date

datetime

YES

The user-entered date in the 1st Resolution Received field

second_resolution_enable

bit

YES

Indicates whether the 2nd Resolution Received option is selected on the levy

second_resolution_date

datetime

YES

Indicates whether the 2nd Resolution Received option is selected on the levy

first_percent_enable

bit

YES

Indicates the Verified option is selected for the percentage increased value entered when the 1st Resolution Received option is selected

first_percent_amt

numeric (8,5)

YES

The user-entered percentage increase value for the 1st resolution

second_percent_enable

bit

YES

Indicates the Verified option is selected for the percentage increased value entered when the 2nd Resolution Received option is selected

second_percent_amt

numeric (8,5)

YES

The user-entered percentage increase value for the 1st resolution

timber_assessed_enable

bit

YES

Indicates whether the Tim Assd Value option is selected on the levy

timber_assessed_cd

varchar (10)

YES

The code selected when Tim Assd Value is enabled (i.e., Full)

timber_assessed_full

numeric (14,2)

YES

The Full Value amount entered for Timber

timber_assessed_half

numeric (14,2)

YES

The Half Value amount entered for Timber

timber_assessed_roll

numeric (14,2)

YES

The Tax Roll value entered for assessed timber value

election_date

datetime

YES

The user-entered Election Date

election_term

int

YES

The user-entered Election Term

voted_levy_amt

numeric (14,0)

YES

The user-entered Voted Levy Amt

voted_levy_rate

numeric (13,10)

YES

The user-entered Voted Levy Rate

certification_date

datetime

YES

Date the levy was certified in the system

levy_description

varchar (50)

YES

The user-entered description

include_in_levy_certification

bit

NO

Indicates the Include in Levy Certification option is selected in the Levy record’s Certification Information section

comment

varchar (255)

YES

Comments entered for the levy

primary_fund_number

numeric (14,0)

YES

The Fund Number mapped to the levy; Fund Numbers are user-configured in PACS.ADMIN Code File Maintenance and assigned to the Levy record when the levy info is entered in PACS

diversion_amount

numeric (14,2)

YES

Capture any diverted funds for a levy.

outstanding_debt

numeric (14,2)

NO

Outstanding debt from import

outstanding_debt_as_of_date

datetime

YES

Outstanding Debt As-Of Date

copy_elec_info_pacs_user_id

int

YES

The user ID of the user who copied election information to this levy from the tax_area_election_information table

copy_elec_info_date

datetime

YES

The date when a user copied election information to this levy from the tax_area_election_information_table

Column Name

Attribute

Allows Null

Description

bill_id

int

NO

The ID for the levy bill

levy_cd

varchar (10)

NO

The code identifying the levy record the bill is associated with

year

numeric (4,0)

NO

The tax year of the bill

tax_district_id

int

NO

The ID of the taxing district associated with the levy/bill

taxable_val

numeric (14,0)

YES

The taxable value of the property subjected to the levy

tax_area_id

int

YES

The ID of the taxing area associated with the levy/bill

Column Name

Attribute

Allows Null

Description

owner_id

int

NO

The unique number identifying the property owner; key constraint to dbo.account

owner_tax_yr

numeric (4,0)

NO

The tax year the owner data is drawn from (i.e., the owner year)

prop_id

int

NO

The property ID associated with the owner

updt_dt

datetime

NO

The date the owner record was most recently updated (populated from owner triggers)

pct_ownership

numeric (13,10)

YES

The percentage indicating how much ownership the owner has over the subject property (i.e., 100.00000000)

owner_cmnt

varchar (255)

YES

Comments recorded on the owner record

over_65_defer

char (1)

YES

Indicates the owner is designated as being over 65 (or otherwise entitled to benefits of the designation)

over_65_date

datetime

YES

The date on which the owner was effectively designated over 65 in the system

ag_app_filed

char (1)

YES

Indicates whether or not the owner has filed an ag application; may be ‘T’ or ‘F’

apply_pct_exemptions

char (1)

YES

Indicates whether to apply percentage of ownership to the exemption values; can be ‘T’ or ‘F’

sup_num

int

NO

The supplement numberr

type_of_int

char (5)

YES

Type of interest; value from dbo.interest_type.interest_type_cd

hs_prop

char (1)

YES

Indicates whether the owner’s property is designated as the Homestead; the values are ‘T’ and ‘F’; the HS exemption is applied when ‘T’ (True)

birth_dt

datetime

YES

The birthdate entered for the owner

roll_exemption

varchar (500)

YES

Roll exemptions (owner exemptions in comma delimited format); this is formatted with the stored procedure SetRollExemption

roll_state_code

varchar (500)

YES

Roll State Codes (state codes in comma delimited format); this is formatted with the stored procedure SetRollStateCode

roll_entity

varchar (500)

YES

Roll entities (entities in comma delimited format); this is formatted with the stored procedure SetRollEntity

pct_imprv_hs

numeric (13,10)

YES

Ownership percentage of Improvement Homesite value

pct_imprv_nhs

numeric (13,10)

YES

Ownership percentage of Improvement non-Homesite value

pct_land_hs

numeric (13,10)

YES

Ownership percentage of Land Homesite value

pct_land_nhs

numeric (13,10)

YES

Ownership percentage of Land non-Homesite value

pct_ag_use

numeric (13,10)

YES

Ownership percentage of Ag use value

pct_ag_mkt

numeric (13,10)

YES

Ownership percentage of Ag market value

pct_tim_use

numeric (13,10)

YES

Ownership percentage of Timber use value

pct_tim_mkt

numeric (13,10)

YES

Ownership percentage of Timber market value

pct_pers_prop

numeric (13,10)

YES

Ownership percentage of Personal Property value

udi_child_prop_id

int

YES

Contains the child property ID for the owner of a UDI parent property. Each owner of a UDI parent has its own child property that represents the logical ownership of the parent property. There is also an owner record for the child property, but this field allows PACS to make the connection between the UDI parent owner and his/her child

percent_type

varchar (5)

YES

Contains an ‘O’, ‘S’, or “. Which of thee three values is displayed depends on how an owner’s ownership is broken down. The ‘O’ for Overall and ” values are really the same because ” is understood as an overall owner in legacy systems (and, therefore, his/her ownership is determined by the ownership percentage). If ‘S’, then the owner is a segment owner and the ownership percentage should be ignored. The owner’s ownership-related info is contained in the imprv_owner_assoc, land_owner_assoc, and pers_prop_owner_assoc tables.

pct_ag_use_hs

numeric (13,10)

YES

Percentage of Homestead value on Ag use

pct_ag_mkt_hs

numeric (13,10)

YES

Percentage of Homestead value on Ag use market value

pct_tim_use_hs

numeric (13,10)

YES

Percentage of Homestead value on Timber use

pct_tim_mkt_hs

numeric (13,10)

YES

Percentage of Homestead value on Timber use market value

linked_cd

varchar (10)

YES

Owner link type code

Column Name

Attribute

Allows Null

Description

prop_id

int

NO

Property ID

prop_val_yr

numeric (4,0)

NO

The property year

imprv_id

int

NO

The unique ID of the Improvement; created from dbo.next_improvement_id

sup_num

int

NO

Supplement number

sale_id

int

NO

Sale ID

imprv_type_cd

char (5)

NO

The Improvement Type code file assigned to the property Improvement; the code is from dbo.imprv_type.imprv_type_cd

imprv_sl_locked

char (1)

NO

Not used

primary_imprv

char (1)

YES

Not used

imprv_state_cd

char (5)

NO

Improvement state code; code from dbo.state_code.state_cd

imprv_homesite

char (1)

YES

Indicates whether the Improvement is marked as Homesite; valid values are ‘Y’ and ‘N’

imprv_desc

varchar (255)

YES

Improvement description

imprv_val

numeric (14,0)

YES

Improvement value (the value of the Improvement)

misc_cd

char (5)

YES

Improvement miscellaneous code

imp_new_yr

numeric (4,0)

YES

Improvement new year value

imp_new_val

numeric (14,0)

YES

Improvement new value

imp_new_val_override

char (1)

YES

Indicates whether the New Value flag is selected; valid values are ‘C’ (Calculated), ‘D’ (Detail), and ‘O’ (Override). Valid values for no new value are ‘0’ (Calculated), ‘1’ (Detail), and ‘2’ (Override)

original_val

numeric (14,0)

YES

Improvement original value

base_val

numeric (14,0)

YES

Improvement base value

calc_val

numeric (14,0)

YES

Improvement calculated value

adjusted_val

numeric (14,0)

YES

Improvement adjusted value

living_area_up

numeric (14,2)

YES

Improvement living are unit price

err_flag

char (1)

YES

Not used

imprv_image_url

varchar (50)

YES

The Improvement image path

imprv_cmnt

varchar (1000)

YES

Comment on the Improvement record

mbl_hm_make

varchar (100)

YES

Mobile Home make; this applies to Mobile Home-type properties

mbl_hm_model

varchar (100)

YES

Mobile Home model; this applies to MH property-types only

mbl_hm_sn

varchar (100)

YES

Mobile Home serial number; applies to MH property-types only

mbl_hm_hud_num

varchar (100)

YES

Mobile Home HUD number; for MH property-types only

mbl_hm_title_num

varchar (100)

YES

Mobile Home title number; for MH property-types only

imp_new_pc

numeric (14,0)

YES

Not used

flat_val

numeric (14,0)

YES

Improvement flat value

value_type

char (1)

YES

Not used

imprv_adj_amt

numeric (14,0)

YES

Improvement adjustment amount/value

imprv_adj_factor

numeric (8,6)

YES

Improvement adjustment factor

imprv_mass_adj_factor

numeric (8,6)

YES

Improvement mass adjustment factor

imprv_val_source

char (1)

YES

Improvement value source; valid values are ‘A’ (adjusted) and ‘F’ (flat)

physical_pct

numeric (5,2)

YES

Improvement physical percentage

functional_pct

numeric (5,2)

YES

Improvement functional percentage

economic_cmnt

varchar (255)

YES

Comment on the Improvement’s economic percentage

physical_cmnt

varchar (255)

YES

Comment on the Improvement’s physical percentage

functional_cmnt

varchar (255)

YES

Comment on the Improvement’s functional percentage

effective_yr_blt

numeric (4,0)

YES

The Effective Year Built recorded on the Improvement record

percent_complete

numeric (5,2)

YES

The Improvement’s percentage complete

percent_complete_cmnt

varchar (255)

YES

Comments on the Improvement’s percentage complete value

ref_id1

varchar (50)

YES

Reference ID 1

num_imprv

int

YES

Sequential ID of Improvements for any given property/year/supplement/sale

mbl_hm_sn_2

varchar (100)

YES

Mobile Home serial number 2

mbl_hm_sn_3

varchar (100)

YES

Mobile Home serial number 3

mbl_hm_hud_num_2

varchar (100)

YES

Mobile Home HUD number 2

mbl_hm_hud_num_3

varchar (100)

YES

Mobile Home HUD number 3

stories

varchar (5)

NO

The number of stories recorded on the Improvement record

arb_val

numeric (14,0)

YES

Not used (value determined by the BOE)

dep_pct

numeric (5,2)

YES

The Improvement’s depreciation percentage

dep_cmnt

varchar (255)

YES

Comments on the Improvement record’s depreciation percentage

dist_val

numeric (14,0)

NO

The distributed value on the Improvement

tsRowVersion

timestamp

NO

hs_pct

numeric (13,10)

YES

The Homestead percentage of the Improvement

hs_pct_override

bit

NO

Indicates whether the Improvement’s Homestead Percentage value has been overridden

primary_use_cd

varchar (10)

YES

The Primary Use code assigned to the Improvement (from codefile)

primary_use_override

bit

NO

Indicates that the Improvement’s Primary Use selection has been overridden

secondary_use_cd

varchar (10)

YES

The Secondary Use code assigned to the Improvement

secondary_use_override

bit

NO

Indicates whether the Secondary Use selection on the Improvement has been overridden

actual_year_built

numeric (4,0)

YES

The Actual Year Built recoded on the Improvement

building_number

varchar (6)

YES

The Building Number recorded on the Improvement

building_name

varchar (50)

YES

The Building Name of the Improvement

flat_value_comment

varchar (3000)

YES

The Improvement’s flat value

flat_value_user_id

int

YES

The ID of the PACS user who recorded the flat value

flat_value_date

datetime

YES

The date the flat value was recorded

building_id

int

YES

The Improvement’s building ID

permanent_crop_land_acres

numeric (14,4)

YES

The number of permanent crop land acres recorded on the Improvement

permanent_crop_land_acres_override

bit

NO

Indicates whether the permanent crop land acres value was overridden

permanent_crop_planted_acres

numeric (14,4)

YES

The number of permanent crop acres planted  on the Improvement

permanent_crop_planted_acres_override

bit

NO

Indicates whether the permanent crop acres planted value was overridden

recalc_error_validate_flag

bit

YES

Flag to indicate the user has validated the recalc error

recalc_error_validate_date

datetime

YES

The date and time the user validated the error

recalc_error_validate_user_id

int

YES

The pacs user ID of the user who validated the error

income_val

numeric (14,0)

NO

Distributed Income Value

income_id

int

YES

Income ID for Income Value

mktappr_val

numeric (14,0)

YES

Contains the market approach value

locked_val

numeric (14,0)

YES

Locked value of this improvement

mbl_hm_year

numeric (4,0)

YES

The year in which the mobile home was built

mbl_hm_tip_out

numeric (10,0)

YES

The mobile home tip out value

Column Name

Attribute

Allows Null

Description

prop_id

int

NO

Property ID

prop_val_yr

numeric (4,0)

NO

Property year

imprv_id

int

NO

Improvement ID; key constraint on dbo.imprv.imprv_id

imprv_det_id

int

NO

Improvement detail ID; value taken from dbo.next_improvement_id.next_improvement_id

sup_num

int

NO

Supplement number

sale_id

int

NO

Sale ID; key constraint on dbo.chg_of_owner.chg_of_owner_id

imprv_det_class_cd

char (10)

NO

Class code; value from dbo.imprv_det_class.imprv_det_class_cd

imprv_det_meth_cd

char (5)

NO

Method code; value from dbo.imprv_det_meth.imprv_det_meth_cd

imprv_det_type_cd

char (10)

NO

Type code on the Detail record; value from dbo.imprv_det_type.imprv_det_type_cd

seq_num

int

YES

Sequence number; typically ordered by amount in value, starting at 1, 2, etc.

imprv_det_val

numeric (18,0)

YES

Improvement Detail Value

imprv_det_val_source

char (1)

YES

Improvement Detail Value Source; valid values are ‘C’ (Calculated) and ‘S’ (Sketch)

imprv_det_desc

varchar (100)

YES

Description on the Improvement Detail record

imprv_det_area

numeric (18,1)

YES

The Area value recorded on the Improvement Detail record

imprv_det_area_type

char (1)

YES

Improvement Detail Area Type; valid values are ‘C’ (Calculated) and ‘S’ (Sketch)

condition_cd

char (5)

YES

Improvement Detail Condition Code; value from dbo.condition.condition_cd

cubic_area

numeric (18,1)

YES

Cubic Area recorded on the record

calc_area

numeric (18,1)

YES

Calculated Area recorded on the Improvement Detail record

sketch_area

numeric (18,1)

YES

Sketch Area

override_area

char (1)

YES

Indicates whether the Calculated Area value has been overriden

override_cubic_area

char (1)

YES

Indicates whether the Cubic Area value has been overridden

override_perimeter

char (1)

YES

Indicates whether the Perimeter value has been overridden

perimeter

numeric (18,1)

YES

Perimeter value recorded on the Improvement Detail record

length

numeric (18,1)

YES

Length

width

numeric (18,1)

YES

Width

height

numeric (18,1)

YES

Height

unit_price

numeric (14,2)

YES

Improvement Detail Unit Price; this value is derived from a schedule

yr_new

numeric (4,0)

YES

Year New

yr_built

numeric (4,0)

YES

Year Built

depreciation_yr

numeric (4,0)

YES

Depreciation Year

depreciation_yr_override

char (1)

YES

Indicates whether the Depreciation Year value has been overridden

imprv_det_orig_val

numeric (14,0)

YES

Improvement Detail Original Value

imprv_det_orig_up

numeric (14,2)

YES

Improvement Detail Original Unit Price

effective_tax_yr

numeric (4,0)

YES

Improvement Detail Effective Tax Year

imprv_det_adj_factor

numeric (8,6)

YES

Improvement Detail Adjustment Factor

imprv_det_adj_amt

numeric (14,0)

YES

Improvement Detail Adjustment Amount

imprv_det_calc_val

numeric (14,0)

YES

Improvement Detail Calculated Value

imprv_det_adj_val

numeric (14,0)

YES

Improvement Detail Adjusted Value

imprv_det_flat_val

numeric (14,0)

YES

Improvement Detail Flat Value

economic_pct

numeric (5,2)

YES

Economic Percentage

physical_pct

numeric (5,2)

YES

Physical Percentage

physical_pct_source

char (1)

YES

Physical Percentage Source indicator; valid values are ‘I’ (Improvement) and ‘D’ (Depreciation Percentage)

functional_pct

numeric (5,2)

YES

Functional Percentage

economic_pct_override

char (1)

YES

Indicates the Detail’s Economic Percentage has been overridden; valid values are ‘T’ and ‘F’

physical_pct_override

char (1)

YES

Indicates the Detail’s Physical Percentage value has ben orverridden; can be ‘T’ or ‘F’

functional_pct_override

char (1)

YES

Indicates a Detail’s Functional Percentage value has been overridden; can be ‘T’ or ‘F’

economic_cmnt

varchar (255)

YES

Comment on the Details Economic Percentage

physical_cmnt

varchar (255)

YES

Comment on the Details Physical Percentage

functional_cmnt

varchar (255)

YES

Comments on the Details Functional Percentage

percent_complete

numeric (5,2)

YES

The Detail’s Percent Complete value

percent_complete_override

char (1)

YES

Indicates the Detail’s Percent Complete value has been overidden

percent_complete_cmnt

varchar (255)

YES

Comments on the Detail’s Percent Complete value

new_value_flag

char (1)

YES

Indicates whether the Detail’s New Value option is selected; can be ‘T’ or ‘F’

new_value

numeric (14,0)

YES

New Value

new_value_override

char (1)

YES

Indicates the Detail’s New Value has been ocerridden; can be ‘T’ or ‘F’

sketch_cmds

varchar (1800)

YES

Sketch Commands; this gets passed to Sketch OCX

use_up_for_pct_base

char (1)

YES

Indicates whether to Use Unit Price for Percent Base; can be ‘T’ or ‘F’

ref_id1

varchar (50)

YES

Reference ID 1

reserved1

numeric (14,0)

YES

Not used

can_close_sketch

char (1)

YES

Not used

dep_pct

numeric (5,2)

YES

Depreciation Percentage

add_factor

numeric (5,2)

YES

Add Factor

add_factor_override

char (1)

YES

Indicates whether Add Factor is overridden; can be ‘T’ or ‘F’

size_adj_pct

numeric (5,2)

YES

Size Adjustment Percentage

dep_pct_override

char (1)

YES

Indicates whether the Depreciation Percentage has been overridden

size_adj_pct_override

char (1)

YES

Indicates whether the Size Adjustment Percentage has been overridden

imprv_det_sub_class_cd

varchar (10)

YES

Improvement Detail Sub Class Code; values from dbo.imprv_det_sub_class.imprv_det_sub_cls_cd

num_units

int

YES

Number of Units

num_stories

int

YES

Number of Stories

stories_multiplier

bit

YES

tsRowVersion

timestamp

NO

lease_class

varchar (10)

YES

The Detail’s assigned Lease Class code

actual_year_built_override

bit

NO

Indicates the Detail’s Actual Year Built value is overridden

flat_value_comment

varchar (3000)

YES

Comments on the Detail’s Flat Value

flat_value_user_id

int

YES

The ID of the PACS user who entered the flat value

flat_value_date

datetime

YES

The date the flat value was entered

depreciated_replacement_cost_new

numeric (14,0)

YES

The Detail’s Depreciated Replacement Cost New

floor_number

numeric (4,0)

YES

The number of floors as indicated on the Detail’s record

load_factor

numeric (3,0)

YES

The Detail’s load factor

actual_age

numeric (4,0)

YES

The Detail’s Actual Age as recorded on the record

net_rentable_area

numeric (18,0)

YES

The Net Rental Area of the Detail

building_id

int

YES

The Building ID

permanent_crop_acres

numeric (14,4)

YES

The Permanent Crop Acres

permanent_crop_irrigation_acres

numeric (14,4)

YES

Permanent Crop Irrigation Acres

permanent_crop_age_group

varchar (15)

YES

Permanent Crop Age Group

permanent_crop_trellis

varchar (15)

YES

Permanent Crop Trellis

permanent_crop_irrigation_system_type

varchar (15)

YES

Permanent Crop Irrigation System Type code

permanent_crop_irrigation_sub_class

varchar (15)

YES

Permanent Crop Irrigation Sub Class code

permanent_crop_density

varchar (15)

YES

Permanent Crop Density

imprv_det_cost_unit_price

numeric (14,2)

YES

The Detail’s Cost Unit Price value

imprv_det_ms_val

numeric (14,0)

YES

The Detail’s Marshall & Swift value

imprv_det_ms_unit_price

numeric (14,2)

YES

The Detail’s Marshall & Swift Unit Price

recalc_error_validate_flag

bit

YES

Flag to indicate the user has validated the recalc error

recalc_error_validate_date

datetime

YES

The date and time the user validated the error

recalc_error_validate_user_id

int

YES

The PACS user ID of the user who validated the error

Column Name

Attribute

Allows Null

Description

prop_id

int

NO

Property ID

prop_val_yr

numeric (4,0)

NO

Property Year

land_seg_id

int

NO

The and Detail ID; value from dbo.next_ls_id.next_ls_id

sup_num

int

NO

Supplement Number

sale_id

int

NO

Sale ID; key constraint to dbo.chg_of_owner.chg_of_owner_id

ls_mkt_id

int

YES

Land Schedule Market ID; key constraint to dbo.land_sched.ls_id where ls_ag or mkt = ‘M’

ls_ag_id

int

YES

Land Scedule Ag ID; key constraint to dbo.land_sched.ls_id where ls_ag or mkt = ‘A’

land_type_cd

char (10)

NO

Land Type Code; values from dbo.land_type.land_type_cd

land_seg_desc

varchar (50)

YES

Description of the Land segment

land_seg_sl_lock

char (1)

NO

Land Sale Lock; valid values are ‘Y’ and ‘N’

state_cd

char (5)

NO

Land State Code; values from dbo.land_state_type.land_state_type_cd

land_seg_homesite

char (1)

YES

Land Homesite Flag; valid values are ‘T’ and ‘F’

size_acres

numeric (18,4)

YES

Value of the acreage size

size_square_feet

numeric (18,2)

YES

Land size in square feet

effective_front

numeric (18,2)

YES

Land size effective front

effective_depth

numeric (18,2)

YES

Land size effective depth

mkt_unit_price

numeric (14,2)

YES

Market unit price

land_seg_mkt_val

numeric (14,0)

YES

Land market value

mkt_calc_val

numeric (14,0)

YES

Land market calculated value

mkt_adj_val

numeric (14,0)

YES

Land market adjusted value

mkt_flat_val

numeric (14,0)

YES

Land market flat value

ag_loss

numeric (14,0)

YES

Land agricultural loss value

mkt_val_source

varchar (1)

YES

Land market value source; valid values are ‘A’ (Adjusted) and ‘F’ (Flat)

ag_use_cd

char (5)

YES

Land agricultural use code; not used

ag_unit_price

numeric (14,2)

YES

Land agricultural unit price

ag_apply

char (1)

YES

Land agricultural apply; valid values are ‘T’ and ‘F’

ag_val

numeric (14,0)

YES

Land agricultural value

ag_calc_val

numeric (14,0)

YES

Land agricultural calculated value

ag_adj_val

numeric (14,0)

YES

Land agricultural adjusted value

ag_flat_val

numeric (14,0)

YES

Land agricultural flat value

ag_val_type

varchar (5)

YES

Land agricultural value type

ag_timb_conv_dt

datetime

YES

the datetime timber information was last modified

ag_val_source

varchar (1)

YES

Land agricultural value source

ag_eff_tax_year

numeric (4,0)

YES

Land agricultural effective tax year

land_seg_comment

varchar (500)

YES

Comments recorded on the Land segment record

ag_apply_yr

numeric (4,0)

YES

Agricultural apply value

land_seg_orig_val

numeric (14,0)

YES

Land original value

land_seg_up

numeric (14,2)

YES

Land unit price

land_adj_type_cd

char (5)

YES

Land adjustment type code

width_front

numeric (18,2)

YES

Land front width

width_back

numeric (18,2)

YES

Land back width

depth_right

numeric (18,2)

YES

Land depth right

depth_left

numeric (18,2)

YES

Land left depth

eff_size_acres

numeric (18,4)

YES

Land effective size value in acres

land_adj_amt

numeric (14,0)

YES

Land adjustment amount value

land_adj_factor

numeric (8,6)

YES

Land adjustment factor percentage

land_mass_adj_factor

numeric (8,6)

YES

Land adjustment mass adjustment percentage

effective_tax_year

numeric (4,0)

YES

Effective tax year

land_new_val

numeric (14,0)

YES

Land new value

late_ag_apply

char (1)

YES

Indicates that late Ag value is applied; valid values are ‘T’ and ‘F’

ref_id1

varchar (30)

YES

Reference ID 1

oa_mkt_val

numeric (14,0)

YES

Not used

oa_ag_val

numeric (14,0)

YES

Not used

eff_size_acres_override

char (1)

YES

Indicates the Land segment’s value for effective size in acres has been overridden; valid values are ‘T’ and ‘F’

num_lots

numeric (7,2)

YES

Number of lots

new_ag

varchar (1)

YES

Indicates whether the Land segment is marked for and assigned New Ag value

new_ag_prev_val

numeric (14,0)

YES

The previous value of New Ag

new_ag_prev_val_override

varchar (1)

YES

Indicates whether the Land segment’s recorded previous New Value has been overridden

appraisal_cd

varchar (15)

YES

Appraisal Code

arb_val

numeric (14,0)

YES

The Land’s BOE value

land_class_code

char (3)

YES

Land class code; values from dbo.land_class.szLandclassCode

land_influence_code

varchar (10)

YES

Land Influence Code; values from dbo.land_influence.szlLandInfluenceCode

size_useable_acres

numeric (18,4)

YES

Land size usable acres

size_useable_square_feet

numeric (18,2)

YES

Land size usable square feet

dist_val

numeric (14,0)

NO

The Land segment’s distributed value

tsRowVersion

timestamp

NO

timber_78_val

numeric (14,0)

YES

Not used

timber_78_val_pct

numeric (13,0)

YES

Not used

hs_pct

numeric (13,10)

YES

Percentage of the Homesite value on the Land segment

hs_pct_override

bit

NO

Indicates whether the Land segment’s Homesite percentage has been overridden

land_soil_code

char (10)

YES

The Land Soil Code

ag_land_type_cd

char (10)

YES

Agricultural Land Type Code

prev_st_land_type_cd

varchar (10)

YES

flat_value_comment

varchar (3000)

YES

Comments recorded regarding the Land segment’s Flat Value

flat_value_user_id

int

YES

The PACS ID of the user who last modified/recorded the flat value

flat_value_dt

datetime

YES

The datetime the Land segment’s flat value was last modified/recorded

misc_value

numeric (14,0)

YES

Miscellaneous value recorded on the Land segment

new_construction_flag

bit

YES

Indicates the Land segment is flagged for New Contruction value

new_construction_value

numeric (14,0)

YES

The Land segment’s New Construction value

new_construction_value_override

bit

YES

Indicates whether the Land segment’s New Construction value has been overridden

last_import_date

datetime

YES

The date information on this Land segment was last imported

last_import_user_id

int

YES

The PACS ID of the user who last imported info on this Land segment

assessment_yr_qualified

numeric (4,0)

YES

The last assessment year the Land segment last qualified as having Productivity value

current_use_effective_acres

numeric (18,4)

YES

The Land segment’s current use effective acres

primary_use_cd

varchar (10)

YES

The Primary Use code assigned to the property

primary_use_override

bit

YES

Indicates whether the Land segment’s Primary Use code designation has been overridden

sub_use_cd

varchar (10)

YES

The Sub Use code assigned/recorded on the Land segment

use_type_schedule

bit

YES

The Use Schedule currently on the Land segment

type_schedule

varchar (5)

YES

The Land-type schedule on the Land segment

application_number

varchar (16)

YES

The rollback application number on the Land segment

recording_number

varchar (23)

YES

The rollback recording number

recalc_error_validate_flag

bit

YES

Flag to indicate the user has validated the recalc error

recalc_error_validate_date

datetime

YES

The date and time the user validated the error

recalc_error_validate_user_id

int

YES

The pacs userId of the user who validated the error

waterfront_footage

numeric (14,0)

NO

Amount of Waterfront Footage for Land Segment

non_taxed_mkt_val

numeric (14,0)

YES

Market value for non-taxable land segments

mktappr_val

numeric (14,0)

YES

Contains the market approach value

ag_pbrs_pct

numeric (5,2); the default value is ((100))

NO

Public Benefit Rating System Percentage

locked_val

numeric (14,0)

YES

Locked value of this land detail

locked_ag_val

numeric (14,0)

YES

Locked current use value of this land detail

locked_ag_use_cd

char (5)

YES

Locked current use code of this land detail

Column Name

Attribute

Allows Null

Description

payment_id

int

NO

The unique ID of the payment

pacs_user_id

int

YES

The PACS ID os the user who reorded the payment record

payment_source_id

int

YES

The source of the payment

batch_id

int

YES

The ID of the batch in which the payment was recorded

cash_drawer_id

int

YES

The cash drawer in which the payment was recorded

payee_id

int

YES

The ID of the person who made the payment

payee_name

varchar (70)

YES

The name of the person who made the payment

payment_code

char (5)

YES

The payment code, i.e., Full, Partial, etc.

amount_due

numeric (14,2)

YES

The amount due on the paid bill

amount_paid

numeric (14,2)

YES

The amount paid on the bill

paid_under_protest

bit

YES

Indicates whether the payment was made under protest

bill_address1

varchar (50)

YES

The first line of the billing address of the person billed for payment

bill_address2

varchar (50)

YES

The second line of the billing address

bill_address3

varchar (50)

YES

The third line of the billing address

bill_city

varchar (50)

YES

The city in the billing address

bill_state

varchar (50)

YES

The state in the billing address

bill_zip

varchar (20)

YES

The zip code in the billing address

post_date

datetime

YES

The date the payment was posted

date_paid

datetime

YES

The date the payment was recorded

receipt_num

int

YES

The number for the receipt documenting payment

receipt_secondary

varchar (20)

YES

apply_escrow_id

int

YES

ID for transaction applying escrow as payment

apply_credit_id

int

YES

ID for transaction applying account credit as payment

voided

bit

YES

Indicates whether payment was voided

void_date

datetime

YES

The date on which payment was voided

void_by_id

int

YES

The PACS ID of the user who voided payment (or recorded the voiding)

void_reason

varchar (255)

YES

The reason or comment for voiding

void_batch_id

int

YES

The ID of voiding the batch

orig_payment_id

int

YES

If more than one payment is being made, the payment amount of the original payment transaction

Column Name

Attribute

Allows Null

Description

payment_id

int

NO

The ID of the payment recordd as a transaction for accounting purposes

transaction_id

int

NO

The transaction ID of the above payment

voided

bit

YES

Indicates whether the transaction was voided

void_transaction_id

int

YES

The ID for the voiding of the transaction

year

numeric (4,0)

YES

The year the transaction is recorded/applied

sup_num

int

YES

The supplement number

prop_id

int

YES

The ID of the property associated with the transaction

receipt_owner_id

int

YES

The owner ID recorded on the transaction’s receipt

receipt_legal_acreage

numeric (14,4)

YES

The legal acreage of the property associated with the transaction

receipt_legal_desc

varchar (255)

YES

The legal description of the property associated with the transaction

payment_due_id

int

YES

The payment_due payment_id associated with the payment transaction

payment_due_date

datetime

YES

The payment_due due_date associated with the payment transaction

treasurer_rcpt_number

int

YES

Set to a unique identifier when a MISC RCPT type fee has been paid

item_paid_owner_id

int

YES

The owner of the item that was paid at the time of payment

Column Name

Attribute

Allows Null

Description

prop_id

int

NO

Unique ID assigned to the property; will never change

prop_type_cd

char (5)

NO

Property type codes; valid codes are R, MH, MN, P, A

prop_create_dt

datetime

YES

Indicates the datetime the property was created

ref_id1

varchar (50)

YES

Reference ID field 1

ref_id2

varchar (50)

YES

Reference ID field 2

geo_id

varchar (50)

YES

Geographic ID; should be unique identifier

ams_load_dt

datetime

YES

n/a

prop_cmnt

varchar (3000)

YES

Property comment

prop_sic_cd

varchar (10)

YES

Standard Industrialization Code for the property

dba_name

varchar (50)

YES

Doing Business As field; typically for Personal property

alt_dba_name

varchar (50)

YES

Alternate Doing Business As field; typically for Personal property

exmpt_reset

char (1)

YES

Flag indicating exemptions should be reset; valid codes are T, F

gpm_irrig

int

YES

Gallons per minute irrigation value

utilities

varchar (50)

YES

n/a

topography

varchar (50)

YES

n/a

road_access

varchar (50)

YES

n/a

other

varchar (50)

YES

n/a

zoning

varchar (50)

YES

n/a

remarks

varchar (3000)

YES

Property remarks field

state_cd

char (5)

YES

State code of the property; typically used for mineral property

mass_created_from

int

YES

Indicates property ID this property was mass created from

simple_geo_id

varchar (50)

YES

Geographic ID without any non-alphanumeric characters and spaces

reference_flag

char (1)

YES

n/a

penpad_run_id

int

YES

n/a

reference_desc

varchar (64)

YES

n/a

col_owner_id

int

YES

Unique ID for the Collections owner

col_agent_id

int

YES

The agent for collections, when applicable

col_owner_yr

int

YES

The tax year for collection

col_owner_override

bit

NO

Indicates the Collections Owner designated on the property has been overridden

col_agent_override

bit

NO

Indicates the Collections Agent on the property has been overridden

col_owner_update_dt

datetime

YES

The datetime the Collections Owner info was last updated

col_agent_update_dt

datetime

YES

The datetime the Collections Agent info was last updated

mass_create_run_id

int

YES

The run id for the mass create properties run that created this property.

col_autopay_id

int

YES

Auto-Pay Account ID

Column Name

Attribute

Allows Null

Description

prop_id

int

NO

Property ID

owner_id

int

NO

Owner ID

exmpt_tax_yr

numeric (4,0)

NO

prop_val.prop_val_yr

owner_tax_yr

numeric (4,0)

NO

prop_val.prop_val_yr

prop_type_cd

char (5)

NO

The Property type

exmpt_type_cd

varchar (10)

NO

The Exemption

applicant_nm

varchar (70)

YES

Name of individual/taxpayer who applied for the exemption

birth_dt

datetime

YES

The applicant’s/taxpayer’s date of birth

spouse_birth_dt

datetime

YES

Applicant’s spouse’s birth day

prop_exmpt_dl_num

varchar (20)

YES

Driver’s license number of applicant

prop_exmpt_ss_num

varchar (11)

YES

Social Security number of applicant

effective_dt

datetime

YES

The date the exemption took effect on values

termination_dt

datetime

YES

The date on which the exemption was terminated

apply_pct_owner

numeric (5,2)

YES

Not used

sup_num

int

NO

Property_val.sup_num

effective_tax_yr

numeric (4,0)

YES

The year the exemption became active

qualify_yr

numeric (4,0)

YES

Year the applicant qualified for the exemption

sp_date_approved

datetime

YES

Date the special exemption was approved for the applicant

sp_expiration_date

datetime

YES

Not used

sp_comment

varchar (5000)

YES

Comment on the special exemption granted to the applicant

sp_value_type

char (1)

YES

Not used

sp_value_option

char (1)

YES

Not used

absent_flag

bit

YES

Indicates the owner is flagged absent

absent_expiration_date

datetime

YES

Date on which the absence designation expires

absent_comment

varchar (255)

YES

Comments regarding the absence designation

deferral_date

datetime

YES

The datetime the applicant was granted the deferral

apply_local_option_pct_only

char (1)

YES

Indicates whether only local option percentages are applied

apply_no_exemption_amount

bit

YES

Indicates whether no exemption amount is applied (T or F)

exmpt_subtype_cd

varchar (10)

YES

The sub type code assigned to the exemption

exemption_pct

numeric (5,2)

YES

The percentage of the exemption

combined_disp_income

numeric (14,0)

YES

The combined income of the applicant and applicant’s spouse

exempt_qualify_cd

varchar (10)

YES

The code assigned on qualifying the applicant for the exemption

review_request_date

datetime

YES

SNR/DSBL Exemption Review Request Date

review_status_cd

varchar (10)

YES

SNR/DSBL Exemption Review Status Code

review_last_year

numeric (4,0)

YES

SNR/DSBL Exemption Review Last Year

Column Name

Attribute

Allows Null

Description

prop_id

int

NO

Property ID

prop_val_yr

numeric (4,0)

NO

Property Year

sup_num

int

NO

Supplement number

update_dt

datetime

YES

Date and time of last update to the profile record

school_id

int

YES

Account ID of the School entity in the profile

city_id

int

YES

ID of the City entity

state_cd

varchar (10)

YES

State code

class_cd

varchar (10)

YES

Class code

land_type_cd

varchar (10)

YES

Land type code on the profile

yr_blt

numeric (4,0)

YES

Year the properties meeting the profile were built

living_area

numeric (14,0)

YES

The living area recorded for properties fitting the profile

imprv_unit_price

numeric (14,2)

YES

The unit price of improvements included in the profile

imprv_add_val

numeric (14,0)

YES

Improvement added value

land_sqft

numeric (18,2)

YES

The square footage of land in the profile

land_acres

numeric (18,4)

YES

The land acres of property in the profile

land_front_feet

numeric (18,2)

YES

The front footage of land fitting the profile

land_depth

numeric (18,2)

YES

The land depth included in the profile

land_lot

varchar (1)

YES

land_unit_price

numeric (14,2)

YES

Unit price of land included in the rofile

region

varchar (5)

YES

The region code of properties fitting the profile

abs_subdv

varchar (10)

YES

The Abstract/Subdivision Code fitting the profile

neighborhood

varchar (10)

YES

Neighborhood Code in the profile

subset

varchar (5)

YES

The Subset Code

map_id

varchar (20)

YES

Map ID

appraised_val

numeric (14,0)

YES

Appraisal Value

land_num_lots

numeric (7,2)

YES

Number of lots (used only when the land schedule method is the Lot method

land_appr_method

varchar (5)

YES

Land appraisal method

land_total_sqft

numeric (18,2)

YES

Land total square footage

eff_yr_blt

numeric (4,0)

YES

The effective year built of property included in the profile

condition_cd

char (5)

YES

Condition code

percent_complete

numeric (5,2)

YES

The percent complete

ls_table

char (25)

YES

Land schedule table

main_land_unit_price

numeric (14,2)

YES

Unit price for land designated as main

main_land_total_adj

numeric (8,6)

YES

Main land total adjustments

size_adj_pct

numeric (5,2)

YES

Size adjustment percentage

heat_ac_code

varchar (75)

YES

Heating/Air Condition code in the profile

land_total_acres

numeric (18,4)

YES

Land total acreage

zoning

varchar (50)

YES

Zoning

visibility_access_cd

varchar (10)

YES

Visibility access code assigned to properties included in the property

sub_market_cd

varchar (10)

YES

Sub market code

road_access

varchar (50)

YES

Road access

land_useable_acres

numeric (18,4)

YES

Usable acres on land fitting the profile

land_useable_sqft

numeric (18,2)

YES

Usable square footage on land in the profile

property_use_cd

varchar (10)

YES

The property use code fitting the profile

last_appraisal_dt

datetime

YES

Appraisal date of land

utilities

varchar (50)

YES

Utilities

topography

varchar (50)

YES

topography

num_imprv

int

YES

Number of Improvements in the prooperty profile

imprv_type_cd

char (5)

YES

Improvement Type code

imprv_det_sub_class_cd

varchar (10)

YES

The Improvement Detail Sub Class code

class_cd_highvalueimprov

varchar (10)

YES

The highest value in the profile’s range of improvement values (profile Class Breakdown panel)

imprv_det_sub_class_cd_highvalueimprov

varchar (10)

YES

The highest value in the profile’s range of improvement detail values

living_area_highvalueimprov

numeric (14,0)

YES

The highest value in the profile’s range of improvement living area values

actual_year_built

numeric (4,0)

YES

The Improvement Actual Year Built

characteristic_zoning1

varchar (20)

YES

Characteristic primary zoning attribute

characteristic_zoning2

varchar (20)

YES

Characteristic secondary zoning attribute

characteristic_view

varchar (20)

YES

The view characteristic on the property

actual_age

int

YES

The Improvement’s Actual Age

mbl_hm_make

varchar (100)

YES

The make of the Mobile Home

mbl_hm_model

varchar (100)

YES

The Mobile Home model

mbl_hm_sn

varchar (100)

YES

The Mobile Home serial number

mbl_hm_hud_num

varchar (100)

YES

The HUB number on the Mobile Home

mbl_hm_title_num

varchar (100)

YES

The title number on the Mobile Home

imprv_det_meth_cd_highvalueimprov

char (5)

YES

The Improvement Detail appraisal method code high value

imprv_building_name_highvalueimprov

varchar (50)

YES

Highest Improvement Value Building Name

Column Name

Attribute

Allows Null

Description

year

numeric (4,0)

NO

The tax year

sup_num

int

NO

The Supplement Number

prop_id

int

NO

Property ID

agency_id

int

NO

ID of the taxing agency

assessment_use_cd

char (10)

YES

The assessment use code on the property

assessment_amt

numeric (14,2)

YES

Assessment amount

additional_fee_amt

numeric (14,2)

YES

Fees in addition to assessment

exemption_amt

numeric (14,2)

YES

Amount exempt due to exemptions

imported_assessment_amt

numeric (14,2)

YES

Stores the original imported value of a special assessment

is_locked

bit

NO

Special assessment locking flag.  If true, special assessments do not have their value changed by recalculate.

Column Name

Attribute

Allows Null

Description

prop_id

int

NO

The unique ID assigned to the property. This value never changes, and is part of the primary key.

prop_val_yr

numeric (4,0)

NO

Property year

Property_val Table, cont.

prop_val

numeric (14,0)

YES

The value of the property

chg_dt

datetime

YES

Datetime when property info was last modified

notice_mail_dt

datetime

YES

Date the last notice was generated

land_hstd_val

numeric (14,0)

YES

The land homesite value

land_non_hstd_val

numeric (14,0)

YES

The land non-homesite value

imprv_hstd_val

numeric (14,0)

YES

Improvement homesite value

imprv_non_hstd_val

numeric (14,0)

YES

Improvment non-homesite value

appraised_val

numeric (14,0)

YES

The appraised value (the sum of the land homesite value, land non-homesite value, improvement homesite value, and improvement non-homesite value)

assessed_val

numeric (14,0)

YES

Total assessed value (the sum of the appraised value and the ag use and timber use values minus the ten percent cap)

market

numeric (14,0)

YES

Total Market value (the sum of the appraised value and ag market and timber market values)

ag_use_val

numeric (14,0)

YES

Total agricultural use value

ag_market

numeric (14,0)

YES

Total agricultural market value

freeze_ceiling

numeric (14,2)

YES

Freeze ceiling amount (not used)

freeze_yr

numeric (4,0)

YES

Freeze ceiling year (not used)

ag_loss

numeric (14,0)

YES

Total agricultural loss value

ag_late_loss

numeric (14,0)

YES

agricultural late loss value

timber_78

numeric (14,0)

YES

Total timber 1978 value

timber_market

numeric (14,0)

YES

Timber market value

timber_use

numeric (14,0)

YES

Timber use

timber_loss

numeric (14,0)

YES

Timber loss value

timber_late_loss

numeric (14,0)

YES

Timber late loss value

rendered_val

numeric (14,0)

YES

Total rendered value (personal property)

rendered_yr

numeric (4,0)

YES

The rendered year (personal property)

new_val

numeric (14,0)

YES

Total New Value recorded on the property

new_yr

numeric (4,0)

YES

Year that New Value is recorded

mineral_int_pct

numeric (13,10)

YES

Mineral interest percentage (mineral property only; not used)

orig_appraised_val

numeric (14,0)

YES

The property’s original appraised value (not used)

ten_percent_cap

numeric (14,0)

YES

Ten percent cap value (not used)

sup_num

int

NO

Supplement number

legal_desc

varchar (255)

YES

The property’s primary legal description

legal_desc_2

varchar (255)

YES

Property’s secondary legal description

abated_pct