1.Address Table #

Address Table

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)

Suggest edit
Last updated on November 26, 2018

2.Account Table #

Account Table

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

Suggest edit
Last updated on November 26, 2018

3.Assessment Bill Table #

Assessment_Bill Table

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

Suggest edit
Last updated on November 26, 2018

4.Bill Table #

Bill Table

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

Suggest edit
Last updated on November 26, 2018

5.Bill Payments Due Table #

Bill_payments_due Table

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

Suggest edit
Last updated on November 26, 2018

6.Change of Owner Table #

Chg_of_owner Table

Contains ownership transfer information

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

Suggest edit
Last updated on November 26, 2018

7.Change of Owner Prop Assoc Table #

Chg_of_owner_prop_assoc Table

Contains property information related to an ownership transfer

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

Suggest edit
Last updated on November 26, 2018

8.Collection Transaction Table #

Coll_transaction Table

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

Suggest edit
Last updated on November 26, 2018

9.Fee Table #

Fee Table

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

Suggest edit
Last updated on November 26, 2018

10.Fee Payments Due Table #

Fee_payments_due Table

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

Suggest edit
Last updated on November 26, 2018

11.Levy Table #

Levy Table

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

Suggest edit
Last updated on November 26, 2018

12.Levy Bill Table #

Levy_bill 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

 

 

 

Suggest edit
Last updated on November 26, 2018

13.Owner Table #

Owner Table

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

 

Suggest edit
Last updated on November 26, 2018

14.Improvement Table #

Imprv Table

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)

economic_pct numeric (5,2) YES Improvement economic percentage
 

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

Suggest edit
Last updated on November 26, 2018

15.Improvement Detail Table #

Imprv_detail Table

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

Suggest edit
Last updated on November 26, 2018

16.Land Detail Table #

Land_detail Table

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

Suggest edit
Last updated on November 26, 2018

17.Payment Table #

Payment Table

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

Suggest edit
Last updated on November 26, 2018

18.Payment Transaction Table #

Payment_transaction_assoc

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

 

Suggest edit
Last updated on November 26, 2018

19.Property Table #

Property Table

Contains general property information that is not stored by year

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

Suggest edit
Last updated on November 26, 2018

20.Property Exemption Table #

Property_exemption Table

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

Suggest edit
Last updated on November 26, 2018

21.Property Profile #

Property_profile Table

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

 

 

 

Suggest edit
Last updated on November 26, 2018

22.Property Special Assessment Table #

Property_special_assessment Table

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.

Suggest edit
Last updated on November 26, 2018

23.Property Val Table #

Property_val Table

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

numeric (8,0)

YES

Abated percentage

abated_amt

numeric (14,0)

YES

Abated amount

abated_yr

numeric (5,0)

YES

Abated year

eff_size_acres

numeric (14,4)

YES

The property’s effective size in terms of acres

shared_prop_val

numeric (14,0)

YES

Shared property value

shared_prop_cad_code

varchar (5)

YES

Shared property CAD code

legal_acreage

numeric (14,4)

YES

The property’s legal acreage

vit_flag

char (1)

YES

VIT flag (for personal property only; valid values would be ‘T’ and ‘F’ but this is not used)

recalc_flag

char (1)

YES

Recalculation status flag; values are ‘E’ (Error), ‘M’ (modified), and ‘C’ (Current)`

vit_declaration_filed_dt

datetime

YES

Datetime VIT declaration was filed); would be used with VIT personal property but is not used in WA)

prev_sup_num

int

YES

The previous supplement number for this property and year; to set, use SetPrevSupNum stored procedure

sup_cd

char (10)

YES

The supplement code; valid values are stored in dbo.supp

 

sup_desc

varchar (500)

YES

Supplement description entered by user

sup_dt

datetime

YES

Datetime when property was supplemented

sup_action

char (1)

YES

Supplement action; valid values are ‘A’ (Add), ‘M’ (Modify), and ‘D’ (Delete)

appr_company_id

int

YES

The ID of the appraisal company that reported the value; IDs are stored in dbo.appr_company

prop_inactive_dt

datetime

YES

Datetime when the property was inactivated (if this is not NULL, then the supplement action code should be ‘D’)

hscap_qualify_yr

numeric (4,0)

YES

Homestead Cap qualify year

hscap_override_prevhsval_flag

char (1)

YES

Indicates the Homesite cap previous year value was overridden; can be ‘T’ or ‘F’

hscap_prevhsval

numeric (14,0)

YES

The previous Homesite cap value on the property

hscap_prevhsval_pacsuser

numeric (14,0)

YES

The PACS ID of the user who overrode the previous year Homesite cap value

hscap_prevhsval_comment

varchar (255)

YES

Comment left by the user when the Homesite cap was overridden

hscap_prevhsval_date

datetime

YES

Datetime the previous year’s homesite cap value was overridden

hscap_override_newhsval_flag

char (1)

YES

Indicates the new Homesite value has been overridden

hscap_newhsval

numeric (14,0)

YES

The New Homesite cap value

 

hscap_newhsval_pacsuser

numeric (14,0)

YES

The PACS ID of the user who overrode the New Homestead Cap Value

hscap_newhsval_comment

varchar (255)

YES

The user comment regarding the override on the New Homesite cap value

hscap_newhsval_date

datetime

YES

The new Homesite value override date

last_appraisal_yr

numeric (4,0)

YES

The last year the property was appraised

oil_wells

numeric (14,0)

YES

The number of oil wells recorded on the property

irr_wells

numeric (14,0)

YES

The number of irrigation wells found on the property

irr_acres

numeric (14,4)

YES

The number of irrigated acres on the property

irr_capacity

numeric (14,0)

YES

The irrigation capacity on the property; not used

oil_well_apply_adjust

char (1)

YES

not used

oil_wells_apply_adjust

char (1)

YES

not used

tif_imprv_val

numeric (14,0)

YES

Tax Increment Fund Improvement value

tif_land_val

numeric (14,0)

YES

Tax Increment Fund Land value

tif_flag

char (1)

YES

Indicates whether the Tax Increment Fund is flagged on the property; values can be ‘T’ or ‘F’

accept_create_id

int

YES

The PACS ID of the user who supplemented and accepted the property at the property level

accept_create_dt

datetime

YES

The datetime the property was supplemented and accepted

 

abs_subdv_cd

varchar (10)

YES

The Abstract/Subdivision code; codes are from dbo.abs_subdiv and dbo.abs_subdiv.abs_subdiv_yr = dbo.property_val.prop_val_yr

hood_cd

varchar (10)

YES

Then Neighborhood code; codes are from dbo.neighborhood where dbo.neighborhood.hood_yr = dbo.property_val.prop_val_yr

block

varchar (50)

YES

Block the property is on

tract_or_lot

varchar (50)

YES

Tract or lot of the property

mbl_hm_park

varchar (50)

YES

Mobile Home Park where the property is located (for Mobile Home property only)

mbl_hm_space

varchar (50)

YES

Mobile Home space

rgn_cd

varchar (5)

YES

The region code; codes are from dbo.region.rgn_cd

subset_cd

varchar (5)

YES

Subset code; codes are from dbo.subset.subset_code

map_id

varchar (20)

YES

Map ID in which the property is located

auto_build_legal

varchar (1)

YES

Indicates whether the the Autobuild Legal configuration is active on this property; values can be ‘T’ or ‘F’

image_path

varchar (255)

YES

The fully qualified file path where the property’s primary image is stored; if not image, then this can be NULL

hscap_prev_reappr_yr

numeric (4,0)

YES

Homesite cap previous appraisal year

 

hscap_base_yr

numeric (4,0)

YES

Homesite cap base year; reference RecalcHSCap stored procedure for how this column is calculated

hscap_base_yr_override

char (1)

YES

Indicates whether the Homestead cap base year has been overridden

hscap_base_yr_pacsuser

numeric (14,0)

YES

PACS ID of the user who has overridden the HS cap base year

hscap_base_yr_comment

varchar (255)

YES

The user-entered comment regarding the override on the HS cap base year

hscap_base_yr_date

datetime

YES

The date the HS cap base year was overridden

mapsco

varchar (20)

YES

The Mapsco coordinates of the property

cost_value

numeric (14,0)

YES

Total cost value (use cost_* columns)

income_value

numeric (14,0)

YES

Total income value (use income_* columns)

shared_value

numeric (14,0)

YES

Total shared value (use shared_* columns)

appr_method

char (5)

YES

Appraisal valuation method; valid values are ‘C’ (Cost), ‘S’ (Chared), ‘I’ (Income), and ‘A’ (ARB)

cost_land_hstd_val

numeric (14,0)

YES

Cost valuation Land Homesite value

cost_land_non_hstd_val

numeric (14,0)

YES

Cost valuation Land Non-Homesite value

cost_imprv_hstd_val

numeric (14,0)

YES

Cost valuation Improvement Homesite value

cost_imprv_non_hstd_val

numeric (14,0)

YES

Cost valuation Improvement Non-Homesite value

 

cost_market

numeric (14,0)

YES

Cost valuation market value

cost_ag_use_val

numeric (14,0)

YES

Cost valuation agricultural use value

cost_ag_market

numeric (14,0)

YES

Cost valuation agricultural market value

cost_ag_loss

numeric (14,0)

YES

Cost valuation agricultural loss value

cost_timber_market

numeric (14,0)

YES

Cost valuation timber market value

cost_timber_use

numeric (14,0)

YES

Cos valuation Timber use value

cost_timber_loss

numeric (14,0)

YES

Cost valuation timber loss value

income_land_hstd_val

numeric (14,0)

YES

Income valuation land Homesite value

income_land_non_hstd_val

numeric (14,0)

YES

Income valuation Land Non-Homesite value

income_imprv_hstd_val

numeric (14,0)

YES

Income valuation Improvement Homesite value

income_imprv_non_hstd_val

numeric (14,0)

YES

Income valuation Improvement Non-Homesite value

income_market

numeric (14,0)

YES

Income valuation Market value

income_ag_use_val

numeric (14,0)

YES

Income valuation Ag Use value

income_ag_market

numeric (14,0)

YES

Income valuation Ag market value

income_ag_loss

numeric (14,0)

YES

Income valuation Ag Loss value

 

income_timber_market

numeric (14,0)

YES

Income valuation Timber market value

income_timber_use

numeric (14,0)

YES

Income valuation Timber Use value

income_timber_loss

numeric (14,0)

YES

Income valuation Timber Loss value

shared_land_hstd_val

numeric (14,0)

YES

Shared valuation Land Homesite value

shared_land_non_hstd_val

numeric (14,0)

YES

Shared valuation Land Non-Homesite value

shared_imprv_hstd_val

numeric (14,0)

YES

Shared valuation Improvement Homesite value

shared_imprv_non_hstd_val

numeric (14,0)

YES

Shared valuation Improvement Non-Homesite value

shared_market

numeric (14,0)

YES

Shared valuation Market value

shared_ag_use_val

numeric (14,0)

YES

Shared valuation Ag Use value

shared_ag_market

numeric (14,0)

YES

Shared valuation Ag Market value

shared_ag_loss

numeric (14,0)

YES

Shared valuation Ag Loss value

shared_timber_market

numeric (14,0)

YES

Shared valuation Timber market value

shared_timber_use

numeric (14,0)

YES

Shared valuation Timber use value

shared_timber_loss

numeric (14,0)

YES

Shared valuation Timber Loss value

last_appraiser_id

int

YES

ID of the last appraiser to have recorded values on the property; ID comes from dbo.appraiser.appraiser_id

 

next_appraiser_id

int

YES

ID of the next appraiser assigned to the property; IDs from dbo.appraiser.appraiser_id

last_appraisal_dt

datetime

YES

Datetime of the last appraisal recorded

next_appraisal_dt

datetime

YES

The date on which this property is scheduled for an appraisal

next_appraisal_rsn

varchar (500)

YES

Reason comments regarding the next scheduled appraisal

value_appraiser_id

int

YES

Value appraiser ID; ID from dbo.appraiser.appraiser_id

land_appraiser_id

int

YES

The Land appraiser ID; ID from dbo.appraiser.appraiser_id

sub_market_cd

varchar (10)

YES

Sub-Market code; codes come from dbo.sub_market.sub_market_cd

property_use_cd

varchar (10)

YES

Property Use code; codes come from dbo.property_use.property_use_cd

visibility_access_cd

varchar (10)

YES

Visibility Access code on the property; codes come from dbo.visibility_access.visibility_access_cd

last_pacs_user_id

int

YES

The PACS ID of the last user; ID comes from dbo.pacs_user.pacs_user_id

recalc_dt

datetime

YES

Datetime the property was last recalculated

new_val_hs

numeric (14,0)

YES

Total new homesite value

new_val_nhs

numeric (14,0)

YES

Total new non-homesite value

 

new_val_p

numeric (14,0)

YES

Total new personal value; only used for personal property

owner_update_dt

datetime

YES

Datetime the owner info on the property was last modified/updated

agent_update_dt

datetime

YES

Datetime the agent info on the property was last updated/modified

penpad_comments

varchar (256)

YES

Penpad comments on the record

last_actual_appraisal_dt

datetime

YES

Datetime of the last actual appraisal

last_owner_id

int

YES

Not used

cad_value_option

varchar (5)

YES

Not used

condo_pct

numeric (13,10)

YES

Condominium percentage

reviewed_dt

smalldatetime

YES

Datetime the property was reviewed

reviewed_appraiser

int

YES

Reviewed appraiser ID; ID is from dbo.appraiser.appraiser_id

arb_land_hstd_val

numeric (14,0)

YES

ARB valuation Land Homesite value

arb_land_non_hstd_val

numeric (14,0)

YES

ARB valuation Land Non-Homesite value

arb_imprv_hstd_val

numeric (14,0)

YES

ARB valuation Improvement Homesite value

arb_imprv_non_hstd_val

numeric (14,0)

YES

ARB valuation Improvement Non-Homesite value

arb_market

numeric (14,0)

YES

ARB valuation Market value

arb_ag_use_val

numeric (14,0)

YES

ARB valuation Ag Use value

 

arb_ag_market

numeric (14,0)

YES

ARB valuation Ag Market value

arb_timber_market

numeric (14,0)

YES

ARB valuation Timber Market value

arb_timber_use

numeric (14,0)

YES

ARB valuation Timber Use value

arb_timber_loss

numeric (14,0)

YES

ARB valuation Timber Loss value

shared_other_val

numeric (14,2)

YES

Shared valuation Other value

udi_parent

char (1)

YES

Indicates whether the property_val entry is a UDI parent property; values can be ‘T’, ‘D’, or null. If ‘T’ (True), the property should have an inactive hate. If ‘D’, then the property is parent property hat has been deleted.

udi_parent_prop_id

int

YES

Indicates whether the property is a child UDI property

udi_status

varchar (5)

YES

Indicates whether the property is in ‘Suspended’ status, thus allowing the property to be functionally treated as in independent property (often used when processing a protest from one owner of a property with multiple owners)

udi_child_legal_desc

bit

YES

If the property is a UDI child property, this may have the legal description and the designation ‘Undivided Interest’ added on the end.

image_id

int

YES

The ID of the primary image on the property

 

dist_land_hstd_val

numeric (14,0)

YES

Distribution valuation Land Homesite value

dist_land_non_hstd_val

numeric (14,0)

YES

Distribution valuation Land Non-Homesite value

dist_imprv_hstd_val

numeric (14,0)

YES

Distribution valuation Improvement Homesite value

dist_imprv_non_hstd_val

numeric (14,0)

YES

Distribution valuation Improvement Non-Homesite value

dist_market

numeric (14,0)

YES

Distribution valuation Market value

dist_ag_use_val

numeric (14,0)

YES

Distribution valuation Ag Use value

dist_ag_market

numeric (14,0)

YES

Distribution valuation Ag Market value

dist_timber_market

numeric (14,0)

YES

Distribution valuation Timber Market value

dist_timber_use

numeric (14,0)

YES

Distribution valuation Timber Use value

dist_timber_loss

numeric (14,0)

YES

Distribution valuation Timber Loss value

tsRowVersion

timestamp

NO

 

last_arb_appr_method

char (5)

YES

Last appraisal valuation method used/reported by the BOE

udi_original_property_id

int

YES

The property ID of the parent or original property

pp_sq_ft

numeric (14,4)

YES

Personal Property square footage

pp_rentable_sq_ft_rate

numeric (14,4)

YES

Personal Property rentable square footage rate

dist_vit_val

numeric (18,0)

YES

Distribute VIT value

 

secondary_use_cd

varchar (10)

YES

Secondary Use code

assessment_use_cd

varchar (10)

YES

Assessment Use code

state_district_cd

varchar (25)

YES

State District code

tax_area_mileage

numeric (9,2)

YES

Tax Area Mileage

total_mileage

numeric (9,2)

YES

Total Mileage

dor_value

numeric (15,2)

YES

DOR value

apply_miscellaneous_codes

bit

YES

Apply Miscellaneous codes

book_page

varchar (10)

YES

Book page number

sup_comment

varchar (3000)

YES

Comments on the supplementing of the property

change_of_value_form

bit

YES

Change of value form

sub_type

varchar (5)

YES

Sub type

urban_growth_cd

varchar (10)

YES

Orban Growth Code

cycle

int

YES

Cycle Code

cycle_override

bit

YES

Indicates whether the Cucle code entry has been overridden

pp_farm

numeric (14,0)

YES

Personal Property farm value

pp_non_farm

numeric (14,0)

YES

Personal Property Non-Farm value

ag_hs_use_val

numeric (14,0)

YES

Agricultural Homesite Use value

 

ag_hs_mkt_val

numeric (14,0)

YES

Agricultural Homesite Market value

ag_hs_loss

numeric (14,0)

YES

Agricultural Homesite Loss value

timber_hs_use_val

numeric (14,0)

YES

Timber Homesite Use value

timber_hs_mkt_val

numeric (14,0)

YES

Timber Homesite Market value

timber_hs_loss

numeric (14,0)

YES

Timber Homesite Loss value

cost_ag_hs_use_val

numeric (14,0)

YES

Cost valuation Ag Homesite Use value

cost_ag_hs_mkt_val

numeric (14,0)

YES

Cost valuation Homesite Market value

cost_ag_hs_loss

numeric (14,0)

YES

Cost valuation Ag Homesite Loss value

cost_timber_hs_use_val

numeric (14,0)

YES

Cost valuation Timber Homesite Use value

cost_timber_hs_mkt_val

numeric (14,0)

YES

Cost valuation Timber Homesite Market value

cost_timber_hs_loss

numeric (14,0)

YES

Cost valuation Timber Homesite Loss value

shared_ag_hs_use_val

numeric (14,0)

YES

Shared valuation Ag Homesite Use value

shared_ag_hs_mkt_val

numeric (14,0)

YES

Shared valuation Ag Homesite Market value

shared_ag_hs_loss

numeric (14,0)

YES

Shared valuation Ag Homesite Loss value

shared_timber_hs_use_val

numeric (14,0)

YES

Shared valuation Timber Homesite Use value

 

shared_timber_hs_mkt_val

numeric (14,0)

YES

Shared valuation Timber Homesite Market value

shared_timber_hs_loss

numeric (14,0)

YES

Shared valuation Timber Homesite Loss value

arb_ag_hs_use_val

numeric (14,0)

YES

ARB (BOE) valuation Ag Homesite Use value

arb_ag_hs_mkt_val

numeric (14,0)

YES

ARB (BOE) valuation Ag Homesite Market value

arb_ag_hs_loss

numeric (14,0)

YES

ARB (BOE) valuation Ag Homesite Loss value

arb_timber_hs_use_val

numeric (14,0)

YES

ARB (BOE) valuation Timber Homesite Use value

arb_timber_hs_mkt_val

numeric (14,0)

YES

ARB (BOE) valuation Timber Homesite Market value

arb_timber_hs_loss

numeric (14,0)

YES

ARB (BOE) valuation Timber Homesite Loss value

dist_ag_hs_use_val

numeric (14,0)

YES

Distribution valuation Ag Homesite Use value

dist_ag_hs_mkt_val

numeric (14,0)

YES

Distribution valuation Ag Homesite Market value

dist_ag_hs_loss

numeric (14,0)

YES

Distribution valuation Ag Homesite Loss value

dist_timber_hs_use_val

numeric (14,0)

YES

Distribution valuation Timber Homesite Use value

dist_timber_hs_mkt_val

numeric (14,0)

YES

Distribution valuation Timber Homesite Market value

dist_timber_hs_loss

numeric (14,0)

YES

Distribution valuation Timber Homesite Loss value

sup_verified_user

int

YES

ID of user that verified the supplement

new_val_imprv_hs

numeric (14,0)

YES

New value on Improvement Homesite

 

new_val_imprv_nhs

numeric (14,0)

YES

New value on Improvement Non-Homesite

new_val_land_hs

numeric (14,0)

YES

New value on Land Homesite

new_val_land_nhs

numeric (14,0)

YES

New value on Land Non-Homesite

sup_verified_date

datetime

YES

Date the supplement was verified

change_form_printed

bit

YES

Indicates whether the change of value form was generated

exclude_change_of_value_form

bit

YES

Indicates whether the change of value form was marked for exclusion

gis_real_coord_x

numeric (17,9)

YES

X coordinates

gis_real_coord_y

numeric (17,9)

YES

y coordinates

late_filing_penalty_pct

numeric (5,2)

YES

The late rendition filing penalty percentage

fraud_penalty_pct

numeric (5,2)

YES

The fraud penalty percentage

prop_state

char (1)

YES

The property state

imprv_val

numeric (15,0)

YES

The Improvement value

remodel_val_curr_yr

numeric (14,0)

YES

Remodel value in current year

collections_only

bit

NO

Indicates whether this is a Collections-only property

suppress_notice_prior_year_values

bit

NO

Configurable flag to print prior year values on appraisal notice

retain_notice_prior_year_value_setting

bit

NO

Configurable flag to maintain suppress_notice_prior_year_values

 

township_code

varchar (20)

YES

township code file

township_section

varchar (50)

YES

township section info

township_q_section

varchar (50)

YES

township 1/4 section info

range_code

varchar (20)

YES

range Code

non_taxed_mkt_val

numeric (14,0)

YES

Market value for non-taxable land segments

mktappr_market

numeric (14,0)

YES

Contains the market approach value for Total Market

mktappr_imprv_hstd_val

numeric (14,0)

YES

Contains the market approach value for Improvement HS

mktappr_imprv_non_hstd_val

numeric (14,0)

YES

Contains the market approach value for Improvement non-HS

mktappr_land_hstd_val

numeric (14,0)

YES

Contains the market approach value for Land HS

mktappr_land_non_hstd_val

numeric (14,0)

YES

Contains the market approach value for Land non-HS

mktappr_ag_use_val

numeric (14,0)

YES

Contains the market approach value for AG/CU non-HS Use

mktappr_ag_market

numeric (14,0)

YES

Contains the market approach value for AG/CU non-HS Market

mktappr_ag_loss

numeric (14,0)

YES

Contains the market approach value for AG/CU non-HS Loss

mktappr_timber_use

numeric (14,0)

YES

Contains the market approach value for Timber non-HS Use

mktappr_timber_market

numeric (14,0)

YES

Contains the market approach value for Timber non-HS Market

 

mktappr_timber_loss

numeric (14,0)

YES

Contains the market approach value for Timber non-HS Loss

mktappr_ag_hs_use_val

numeric (14,0)

YES

Contains the market approach value for AG/CU HS Use

mktappr_ag_hs_mkt_val

numeric (14,0)

YES

Contains the market approach value for AG/CU HS Market

mktappr_ag_hs_loss

numeric (14,0)

YES

Contains the market approach value for AG/CU HS Loss

mktappr_timber_hs_use_val

numeric (14,0)

YES

Contains the market approach value for Timber HS Use

mktappr_timber_hs_mkt_val

numeric (14,0)

YES

Contains the market approach value for Timber HS Market

mktappr_timber_hs_loss

numeric (14,0)

YES

Contains the market approach value for Timber HS Loss

prepared_by_id

int

YES

The user id of the person that prepared the change of value report

ubi_number

varchar (50)

YES

New UBI number for BPP

tax_registration

varchar (50)

YES

New Tax Registration number for BPP

business_start_dt

datetime

YES

Business dates for appraiser info panel in BPP

business_close_dt

datetime

YES

Business dates for appraiser info panel in BPP

business_sold_dt

datetime

YES

Business dates for appraiser info panel in BPP

has_locked_values

bit

NO

Indicates whether a property has locked values

 

Suggest edit
Last updated on November 26, 2018

24.Sale Table #

Sale Table

Column Name

Attribute

Allows Null

Description

chg_of_owner_id

int

NO

Change of Owner ID established by PACS at the time of sale; key constraint to dbo.chg_of_owner.chg_of_owner_id

sl_ratio

numeric (5,2)

YES

Sale ratio percentage; calculated from sale price divided by property market value times 100 percent (i.e., 75000/800000)*100 = 93.75

sl_financing_cd

char (5)

YES

sale financing code entered by user; value from dbo.sl_financing.sl_financing_cd

sl_ratio_type_cd

char (5)

YES

sale ratio type code entered by user (dbo.sale_ratio_type.sale_ratio_type_cd)

sl_adj_cd

char (5)

YES

sales price adjustment reason code

sl_type_cd

char (5)

YES

sale type code

sl_state_cd

char (5)

YES

primary state code of the property

sl_class_cd

char (10)

YES

primary class code of the property

sl_land_type_cd

char (10)

YES

primary land type code on the property

sl_price

numeric (14,0)

YES

sales price

sl_dt

datetime

YES

date of sale

adjusted_sl_price

numeric (14,0)

YES

adjusted sales price – if sale adjusted.  This is the price we normally use in comps/ratios/search results

realtor

varchar (30)

YES

realtor involved in sale

finance_comment

varchar (50)

YES

comment specific to financing

amt_down

numeric (18,0)

YES

dollar amount placed down on the sale

amt_financed

numeric (18,0)

YES

dollar amount financed for the sale

 

interest_rate

numeric (14,3)

YES

interest rate

finance_yrs

numeric (4,1)

YES

number of years financed

suppress_on_ratio_rpt_cd

char (5)

YES

T/F if the sale will be included on the ratio report

suppress_on_ratio_rsn

varchar (30)

YES

Reason the sale will be suppressed

sl_adj_sl_pct

numeric (8,4)

YES

sale price adjustment percentage

sl_adj_sl_amt

numeric (14,0)

YES

sale price adjustment amount

sl_adj_rsn

varchar (50)

YES

sale price adjustment reason

sl_comment

varchar (500)

YES

sale comment

sl_yr_blt

numeric (4,0)

YES

primary year built on the property

sl_living_area

numeric (14,0)

YES

total living area on the property

sl_imprv_unit_price

numeric (14,2)

YES

living area unit price

sl_land_sqft

numeric (18,2)

YES

total land square footage

sl_land_acres

numeric (18,4)

YES

sale land acres

sl_land_front_feet

numeric (18,2)

YES

total land front feet on the property at time of sale

sl_land_depth

numeric (18,2)

YES

total land depth on the property at time of sale

 

sl_land_unit_price

numeric (14,2)

YES

land unit price on the property at time of sale

sl_school_id

int

YES

school entity code on the property at time of sale – does not work with WA, as they do not have entities

sl_city_id

int

YES

city entity code on the property at time of sale – does not work with WA, as they do not have entities

sl_qualifier

varchar (10)

YES

Sale qualifier code

include_no_calc

char (1)

YES

flag to indicate the sale should be in the ratio report, but not included in the calculations

sl_ratio_cd

char (5)

YES

Sale ratio code (dbo.sale_ratio_type.sl_ratio_type_cd

import_dt

datetime

YES

date property characteristics were imported into the sale

include_reason

varchar (30)

YES

why the sale, if marked include_no_calc, was excluded from calcs

sales_exclude_calc_cd

varchar (10)

YES

code selected when include_no_calc is selected

amt_financed_2

numeric (18,0)

YES

second amount financed

interest_rate_2

numeric (14,2)

YES

second interest rate

finance_yrs_2

numeric (4,1)

YES

second loan term

sl_sub_class_cd

varchar (10)

YES

sub-class code on the property at the time of sale or last import

sl_imprv_type_cd

varchar (5)

YES

improvement type code on the property at the time of sale or last import

confidential_sale

char (1)

YES

bit flag to indicate if sale is confidential

 

frozen_characteristics

char (1)

YES

indicates if the user selected the charactersistics of this property are current flag

num_days_on_market

numeric (3,0)

YES

days the property was available for sale

sl_exported_flag

char (1)

YES

sale exported to the State flag – Texas only

land_only_sale

bit

YES

the sale should be reflected as a land only sale

monthly_income

numeric (14,0)

YES

If rental property, the monhtly income received

annual_income

numeric (14,0)

YES

Annual income

sl_ratio_cd_reason

varchar (100)

YES

ratio code reason

continue_current_use

bit

YES

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

sl_county_ratio_cd

varchar (10)

YES

county sales ratio code

primary_use_cd

varchar (10)

YES

primary use code on the property at the time of sale or last import

secondary_use_cd

varchar (10)

YES

secondary use code on the property at the time of sale or last import

listing_price

numeric (14,0)

YES

listing price of the sale

listing_dt

datetime

YES

listing date of the sale

pers_prop_val

numeric (14,0)

YES

Personal property amount from REET record

exemption_amount

numeric (14,0)

YES

Exemption amount from REET record

wac_cd

varchar (32)

YES

WAC code from REET record

Suggest edit
Last updated on November 26, 2018

25.Situs Table #

Situs Table

Column Name

Attribute

Allows Null

Description

prop_id

int

NO

Property ID

situs_id

int

NO

Situs ID

primary_situs

char (1)

YES

Indicates whether the situs displayed is the primary situs

situs_num

varchar (15)

YES

Situs number

situs_street_prefx

varchar (10)

YES

Situs street prefix

situs_street

varchar (50)

YES

Situs street

situs_street_sufix

varchar (10)

YES

Situs street suffix

situs_unit

varchar (5)

YES

Situs unit

situs_city

varchar (30)

YES

Situs City

situs_state

char (2)

YES

Situs State

situs_zip

varchar (10)

YES

Situs Zip code

situs_display

varchar (173)

YES

Situs displayed–a combination of the other situs fields

building_num

varchar (15)

YES

Building number

sub_num

varchar (15)

YES

Sub number

Suggest edit
Last updated on November 26, 2018

26.Special Assessment Table #

Special_assessment Table

Column Name

Attribute

Allows Null

Description

year

numeric (4,0)

NO

Year

agency_id

int

NO

The ID of the taxing agency

calculate_fee

bit

NO

Indicates whether a calculated fee is configured

flat_fee

bit

NO

Indicates whether a flat fee is configured

has_additional_fee

bit

NO

Indicates whether an additional fee is configured in the assessment

has_flat_additional_fee

bit

NO

indicates whether the assessment has an additional flat fee

fee_type_cd

varchar (10)

YES

The fee type code set on the assessment

assessment_fee_amt

numeric (10,2)

YES

The assessment fee amount

additional_fee_amt

numeric (10,2)

YES

The amount of the additional fee set on the assessment

recalculate_during_supplement

bit

NO

Indicates whether the assessment is set to recalculated upon being supplemented

calc_source

image

YES

Calculation source

status_cd

varchar (10)

YES

Status code set on the assessment

created_date

datetime

YES

The date the assessment was created/recorded

calculated_date

datetime

YES

The date the assessment was calculated

bill_create_date

datetime

YES

The date on which bills from the assessment were created

Special_assessment Table, cont.

createdby

varchar (50)

YES

The ID of the user who had the bills created

calculatedby

varchar (50)

YES

the ID of the user who calculated the bills

bills_createdby

varchar (50)

YES

The ID of the user who created bills

has_additional_fee_as_percent

bit

NO

Indicates whether the additional fee is calculated as a percentage

additional_fee_as_percent

numeric (10,2)

YES

The percentage of the addition fee (when set)

disburse

bit

NO

Indicates whether funds have been disbursed

disburse_acct_id

int

YES

The account number that funds are disbursed to

rule_id

int

YES

Rule ID

import_or_calculate

bit

NO

Indicates whether the assessment was imported or manually entered/calculated

end_year

numeric (4,0)

YES

The end year set on the assessment ()expiration date)

Suggest edit
Last updated on November 26, 2018

27.Special Assessment Agency Table #

Special_assessment_agency Table

Column Name

Attribute

Allows Null

Description

agency_id

int

NO

Distinct ID for the agency; primary key; from dbo.next_account_id.next_account_id

assessment_cd

varchar (50)

NO

The code for agency

assessment_type_cd

varchar (50)

NO

assessment agency type code; from dbo.assessment_type.assessment_type_cd

 

assessment_description

varchar (50)

YES

user-entered description of the agency

resolution_num

varchar (50)

YES

The agency’s resolution number

resolution_date

datetime

YES

The resolution date entered in the agency record

start_date

datetime

YES

The start date entered in the agency record

end_date

datetime

YES

The end date for the agency’s distribution run

fin_vendor_id

int

YES

The vendor mapped to the special assessment agency

fin_vendor_site_id

int

YES

The mapped site id for the vendor

Suggest edit
Last updated on November 26, 2018

28.Tax Area Table #

Tax_area Table

Column Name

Attribute

Allows Null

Description

tax_area_id

int

NO

The unique ID of the tax area

tax_area_number

varchar (23)

NO

The tax area’s number

tax_area_state

varchar (50)

YES

The current state or status of the tax area

tax_area_description

varchar (255)

NO

The user-entered description of the tax area

comment

varchar (2048)

YES

Comments recorded on the tax area record

is_inactive_after_year

bit

NO

Whether or not this Tax Area becomes inactive after a certain year

inactive_after_year

numeric (4,0)

YES

The year after which this Tax Area becomes inactive

Suggest edit
Last updated on November 26, 2018

29.Tax District Table #

Tax_district Table

Column Name

Attribute

Allows Null

Description

tax_district_id

int

NO

The ID of the taxing district

tax_district_cd

varchar (20)

NO

The tax district code

tax_district_desc

varchar (50)

YES

The description of the taxing district

tax_district_type_cd

varchar (10)

NO

The codefile on the tax district

fin_vendor_id

int

YES

Vendor recorded on the assessment agency

fin_vendor_site_id

int

YES

The vendor site

location_code

varchar (10)

YES

Location Code

location_desc

varchar (30)

YES

Location Description

Suggest edit
Last updated on November 26, 2018

30.Tender Table #

Tender Table

Column Name

Attribute

Allows Null

Description

tender_id

int

NO

The tender ID

payment_id

int

YES

The payment ID (identifies payment source)

tender_type_cd

varchar (50)

YES

The tender type, or, type of tendered payment

amount

numeric (14,2)

YES

The amount tendered

ref_number

varchar (12)

YES

The reference number of the payment

 

description

varchar (30)

YES

A description of the tender payment transaction

dl_number

int

YES

The license number of the license used in the tender transaction

dl_state

varchar (5)

YES

The state issuing the driver’s license used in the tender transaction

credit_amount

numeric (14,2)

YES

The credit amount remaining after the tender transaction

credit_refund_type_cd

varchar (20)

YES

This is the refund type code of applied adjustment credit tenders.

credit_refund_type_year

numeric (4,0)

YES

This is the refund type year of applied adjustment credit tenders.

credit_interest

numeric (14,2)

NO

This is the refund interest amount of applied adjustment credit tenders.

credit_override_refund_interest

bit

NO

This is the refund interest amount override flag for applied adjustment credit tenders.

Suggest edit
Last updated on November 26, 2018

31.Wash Prop Owner Val Table #

Wash_prop_owner_val Table

Column Name

Attribute

Allows Null

Description

year

numeric (4,0)

NO

The property year

sup_num

int

NO

Supplement number

prop_id

int

NO

Property ID (unique)

owner_id

int

NO

Owner ID

land_hstd_val

numeric (14,0)

NO

Land homesite value

 

land_non_hstd_val

numeric (14,0)

NO

Land non-homesite value

imprv_hstd_val

numeric (14,0)

NO

Improvement homesite value

imprv_non_hstd_val

numeric (14,0)

NO

Improvement non-homesite value

ag_use_val

numeric (14,0)

NO

Agricultural use value for the property

ag_market

numeric (14,0)

NO

Agricultural market value for the property

ag_loss

numeric (14,0)

NO

Agricultural loss value for the property

ag_hs_use_val

numeric (14,0)

NO

Agricultural use value for homesite elements

ag_hs_market

numeric (14,0)

NO

Agricultural market value on homesite elements

ag_hs_loss

numeric (14,0)

NO

Ag loss value for homesite elements

timber_use_val

numeric (14,0)

NO

Timber use value

timber_market

numeric (14,0)

NO

Timber market value

timber_loss

numeric (14,0)

NO

Timber loss value

timber_hs_use_val

numeric (14,0)

NO

Timber use value for homestead elements

timber_hs_market

numeric (14,0)

NO

Timber market value for homestead elements

timber_hs_loss

numeric (14,0)

NO

Timber loss value for homestead elements

new_val_hs

numeric (14,0)

NO

New value on homestead elements

 

new_val_nhs

numeric (14,0)

NO

New value on non-homestead elements

new_val_p

numeric (14,0)

NO

Totals new personal value (only for Personal property)

appraised

numeric (14,0)

NO

Appraised value

market

numeric (14,0)

NO

Market value

snr_frz_imprv_hs

numeric (14,0)

NO

Senior freeze ceiling value on homesite improvement

snr_frz_land_hs

numeric (14,0)

NO

Senior freeze ceiling on land homesite

appraised_classified

numeric (14,0)

NO

appraised values that are classified

appraised_non_classified

numeric (14,0)

NO

appraised values that are not classified

taxable_classified

numeric (14,0)

NO

taxable value on property that is classified

taxable_non_classified

numeric (14,0)

NO

non-classified taxable value

state_assessed

numeric (14,0)

NO

value of state assessed (utilities)

destroyed_prop

bit

NO

Indicates whether the Destroyed Property option is selected

destroyed_jan1_value

numeric (14,0)

NO

The Destroyed Property value recorded as of January 1

destroyed_prorate_pct

decimal

YES

The percentage to which destroyed property is devalued

 

prorate_type

varchar (5)

YES

The type of proration that is set on the property

prorate_begin

datetime

YES

The begin date from which a value is prorated

prorate_end

datetime

YES

The end date through which a value is prorated

boe_status

bit

NO

The property’s BOE status

destroyed_jan1_classified_value

numeric (14,0)

NO

Destroyed value – classified portion

destroyed_jan1_non_classified_value

numeric (14,0)

NO

Destroyed value – non-classified portion

non_taxed_mkt_val

numeric (14,0)

YES

Market value for non-taxable land segments

Suggest edit
Last updated on November 26, 2018

32.Wash Prop Val Table #

Wash_prop_val Table

Column Name

Attribute

Allows Null

Description

sup_num

int

NO

The supplement number

prop_id

int

NO

The property ID

appraised_classified

numeric (14,0)

NO

The classified (private) appraised value

appraised_non_classified

numeric (14,0)

NO

The non-classified appraised value

snr_imprv

numeric (14,0)

NO

Improvement value exempted via Senior exemption

snr_land

numeric (14,0)

NO

Land value exempted via senior exemption

snr_new_val

numeric (14,0)

NO

New value exempted via senior exemption

 

snr_qualify_yr

numeric (14,0)

NO

Year property qualified for senior exemption

snr_qualify_yr_override

bit

NO

Indicates whether a property’s senior exemption set-up is overridden

snr_frz_imprv_hs

numeric (14,0)

NO

Senior freeze value on a property’s homesite improvement

snr_frz_land_hs

numeric (14,0)

NO

Senior freeze value on homesite land

snr_frz_imprv_hs_override

bit

NO

Indicates whether the Senior freeze set-up is overridden on the homesite improvement

snr_frz_land_hs_override

bit

NO

Indicates whether the Senior freeze set-up is overridden on the Land homesite

snr_taxable_portion

numeric (14,0)

NO

Portion of the property’s taxable value subject to the Senior exemption

snr_exempt_loss

numeric (14,0)

NO

Taxable value loss due to Senior exemption

snr_portion_applied

numeric (14,0)

NO

Portion of the Senior exemption applied to the property’s value

snr_new_val_override

bit

YES

Indicates whether the property’s Senior New Value set-up is overridden

comment_update_date

datetime

YES

Date on which a comment was recorded on the property

comment_update_user

varchar (35)

YES

User who recorded the comment

snr_comment

varchar (5000)

YES

Comment regarding Senior Exemption data on the property

tsRowVersion

timestamp

NO

 

 

snr_imprv_lesser

numeric (14,0)

YES

Senior Improvement lesser value

snr_land_lesser

numeric (14,0)

YES

Senior Land lesser value

snr_frz_loss_land

numeric (15,0)

YES

Contains the freeze loss allocated to land

snr_frz_loss_imprv

numeric (15,0)

YES

Contains the freeze loss allocated to improvement

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

dist_val_reason_cd

varchar (5)

YES

Stores the most recent Reason Code entered by the user at the Distribute Values dialog

 

Suggest edit
Last updated on November 26, 2018
Suggest Edit
WordPress PopUp Plugin