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) |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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. |
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 |
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 |
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 |
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) |
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 |
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 |
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 |
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. |
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 |
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 |