Subscription Codes
There are a lot of codes and identifiers involved in the available subscription data. Here are some helpful explanations to break it all down.
PML Numbers & Farm Product Codes
All Farm Product Financing Statements filed with our office are maintained in a Master List. Farm products are divided into portions of the master list (PML) and assigned a PML number.
| PML Number | PML Grouping |
FP Code |
Farm Product Name |
|---|---|---|---|
| 01 | Wheat & Buckwheat | 010 | Wheat |
| 011 | Buckwheat | ||
| 02 | Feed & Oil Grains | 020 | Barley |
| 021 | Rye (including Triticale) | ||
| 022 | Oats | ||
| 023 | Sorghum Grain | ||
| 024 | Flaxseed | ||
| 025 | Safflower | ||
| 026 | Rape (including Canola) | ||
| 027 | Field Corn | ||
| 028 | Millet | ||
| 03 | Hay | 030 | Hay |
| 04 | Ensilage | 040 | Ensilage |
| 05 | Potatoes | 050 | Potatoes |
| 06 | Sugar Beets | 060 | Sugar Beets |
| 07 | Dry Beans | 070 | Dry Beans |
| 08 | Dry Peas, Lentils & Garbanzos | 080 | Dry Peas |
| 081 | Lentils | ||
| 082 | Garbanzos (Chick Peas) | ||
| 09 | Sweet Corn | 090 | Sweet Corn |
| 10 | Onions & Garlic | 100 | Onions |
| 101 | Onion Seed | ||
| 102 | Garlic | ||
| 11 | Mint | 110 | Mint |
| 12 | Hops | 120 | Hops |
| 13 | Popcorn & Sunflower Seeds | 130 | Popcorn |
| 131 | Sunflower Seeds | ||
| 14 | Soybeans | 140 | Soybeans |
| 15 | Rice | 150 | Rice |
Unit & County Codes
Unit Codes
The table of codes for units used to indicate the amount of a farm product covered is as follows:
- A = Acres
- B = Bushels
- C = Hundred Weight
- E = Cases
- F = Flats
- G = Gallons
- H = Head
- L = Pounds
- N = Bins
- S = Sacks
- T = Tons
- V = Hives
- W = Lugs
- X = Boxes
- Z = Stubs
County Codes
The table of county codes is as follows. Unless otherwise indicated, counties are in Idaho:
- 00 – All Idaho counties
- 01 – Ada
- 02 – Adams
- 03 – Bannock
- 04 – Bear Lake
- 05 – Benewah
- 06 – Bingham
- 07 – Blaine
- 08 – Boise
- 09 – Bonner
- 10 – Bonneville
- 11 – Boundary
- 12 – Butte
- 13 – Camas
- 14 – Canyon
- 15 – Caribou
- 16 – Cassia
- 17 – Clark
- 18 – Clearwater
- 19 – Custer
- 20 – Elmore
- 21 – Franklin
- 22 – Fremont
- 23 – Gem
- 24 – Gooding
- 25 – Idaho
- 26 – Jefferson
- 27 – Jerome
- 28 – Kootenai
- 29 – Latah
- 30 – Lemhi
- 31 – Lewis
- 32 – Lincoln
- 33 – Madison
- 34 – Minidoka
- 35 – Nez Perce
- 36 – Oneida
- 37 – Owyhee
- 38 – Payette
- 39 – Power
- 40 – Shoshone
- 41 – Teton
- 42 – Twin Falls
- 43 – Valley
- 44 – Washington
- 45 – Asotin, WA
- 46 – Garfield, WA
- 47 – Pend Orielle, WA
- 48 – Spokane, WA
- 49 – Whitman, WA
- 50 – Malheur, OR
- 51 – Elko, NV
- 52 – Box Elder, UT
- 53 – Cache, UT
- 54 – Rich, UT
- 55 – Lincoln, WY
- 56 – Teton, WY
- 57 – Beaverhead, MT
- 58 – Lincoln, MT
- 59 – Sanders, MT
- –
- –
- 99 – Not in Table
Unique Identifier Number (UIN) System
The Secretary of State has implemented a “unique identifier number” (UIN) system to protect debtor information, while remaining simple to implement and easy to use. This system allows us to discontinue using SSN’s (social security numbers) and TIN’s (tax identification numbers) to identify debtors listed on UCC1F Effective Financing Statements.
How it works:
The UIN is ten digits long, and derived using a combination of letters taken from the individual or organization name, coupled with the last four digits of the debtor’s social security number or federal tax identification number. The letters will be converted into numbers based upon their numeric value within the alphabet.
Should a debtor name provide less than the three required letters or numbers, missing information will be replaced with the “#” symbol, which has a numeric value of 00.
Numeric values of the alphabet
- # = 00
- A = 01
- B = 02
- C = 03
- D = 04
- E = 05
- F = 06
- G = 07
- H = 08
- I = 09
- J = 10
- K = 11
- L = 12
- M = 13
- N = 14
- O = 15
- P = 16
- Q = 17
- R = 18
- S = 19
- T = 20
- U = 21
- V = 22
- W = 23
- X = 24
- Y = 25
- Z = 26
- Number = 99
For an individual:
- First two letters of the last name individually converted to a numeric value
- First letter of the first name converted to a numeric value
- Last four digits of the social security number
Example
For a debtor named Ronald Rancher, with a SSN of 987-65-4321.
The UIN for this person is (rar4321) 1801184321.
For an organization:
- First three letters or numbers of the organization name, disregarding “A”, “An”, “The”, any character that is not a letter or number, and all spaces.
- Each letter or number converted to its numeric value.
- Last four digits of the federal tax identification number.
Example
For a debtor named The Busy Bee Ranch, with a TIN of 98-7654321.
The UIN for this organization is (bus4321) 0221194321.
For a debtor named The B2 & B Ranch, with a TIN of 98-7654321.
The UIN for this organization is (b2b4321) 0299024321.
IRS Tax File Layout
Here are some descriptions of the data available in the IRS/Tax Lien file.
| Column Name | Data Type | Length |
|---|---|---|
| d_I_type 1 | char | 1 |
| d_I_no | numeric | 12 |
| I_file_date | datetime | — |
| I_exp_date | datetime | — |
| d_ssn_tin_flag 2 | char | 1 |
| d_ssn_char | char | 9 |
| d_nm_last | char | 255 |
| d_nm_mid | char | 50 |
| d_nm_first | char | 50 |
| d_add_str | char | 30 |
| d_add_bldg | char | 30 |
| d_add_city | char | 20 |
| d_add_st | char | 2 |
| d_add_zip_5 | numeric | 5 |
| I_amount | decimal | 10.2 |
| I_tax_type 3 | char | 4 |
| Valid Values for "d_I_type" | |
|---|---|
| Internal | External |
| I | IRS |
| T | Idaho State Tax |
| Valid Values for "d_ssn_tin_flag" | |
|---|---|
| Internal | External |
| S | US Social Security Number |
| T | US Taxpayer ID Number |
| C | Canadian Business Social Insurance Number |
| I | Canadian Individual Social Insurance Number |
| Valid Values for "I_tax_type" | |
|---|---|
| Internal | External |
| 1 | Individual Income Tax |
| 4 | Unclaimed Prop Claimant |
| 5 | Business Income Tax |
| 6 | Unclaimed Property Holder |
| 8 | Sales and Use Tax |
| 9 | Withholding Tax |
| 10 | Estate Tax |
| 11 | Travel and Convention Tax |
| 12 | Greater Boise Auditorium Tax |
| 13 | Tobacco Tax |
| 14 | Fuel Distributors Tax |
| 14A | FDT Terminal |
| 15 | Cigarette Tax |
| 16 | Beer Tax |
| 17 | Wine Tax |
| 18 | Mine License Tax |
| 21 | Operating Property Tax |
| 30 | IFTA Jurisdiction |
| 31 | IFTA |
| 35 | Amusement Device Tax |
| 99 | Unidentified Money |
UCC Data Table Descriptions
Following are database table descriptions for the Idaho Secretary of State’s UCC/Liens data extract. These descriptions help UCC data recipients reconstruct our UCC/Liens database from their subscription files.
Liens File
Secured Parties File
| Keys | Field | Data Type | Length |
|---|---|---|---|
| Primary, Foreign | File Type 4 | Char | 1 |
| Primary, Foreign | File Number | Numeric | 12 |
| Primary | Sec Party ID | Numeric | 7 |
| Last or Business Name | Char | 255 | |
| First Name | Char | 50 | |
| Middle Name | Char | 50 | |
| Name Suffix | Char | 10 | |
| Address Line 1 | Char | 30 | |
| Address Line 2 | Char | 30 | |
| Address Line 3 | Char | 30 | |
| City | Char | 20 | |
| State | Char | 2 | |
| Zipcode | Char | 10 | |
| Country | Char | 20 | |
| Sec Party Action Available values: ADD, DELETE, CHANGED FROM, CHANGED TO |
Char | 12 | |
| Old File Number (When applicable) | Char | 12 | |
| Old Amend Number (When applicable) | Char | 12 |
Debtors File
| Keys | Field | Data Type | Length |
|---|---|---|---|
| Primary, Foreign | File Type 4 | Char | 1 |
| Primary, Foreign | File Number | Numeric | 12 |
| Primary | Debtor ID | Numeric | 7 |
| Amend Number | Char | 255 | |
| Last or Business Name | Char | 255 | |
| First Name | Char | 50 | |
| Middle Name | Char | 50 | |
| Name Suffix | Char | 10 | |
| Address Line 1 | Char | 30 | |
| Address Line 2 | Char | 30 | |
| Address Line 3 | Char | 30 | |
| City | Char | 20 | |
| State | Char | 2 | |
| Zipcode | Char | 10 | |
| Country | Char | 20 | |
| Debtor Action Available values: ADD, DELETE, CHANGED FROM, CHANGED TO |
Char | 15 | |
| Old File Number (When applicable) | Char | 12 | |
| Old Amend Number (When applicable) | Char | 12 |
Amendments File
| Keys | Field | Data Type | Length |
|---|---|---|---|
| Primary, Foreign | File Type 4 | Char | 1 |
| Primary, Foreign | File Number | Numeric | 12 |
| Primary | Amend Number | Numeric | 7 |
| Amend Date | DateTime | 10 | |
| Image (name of the corresponding image file, generally the same as the file number) |
Char | 20 | |
| Old File Number | Char | 12 | |
| Old Amend Number | Char | 12 |
Amendment Actions File
| Keys | Field | Data Type | Length |
|---|---|---|---|
| Primary, Foreign | File Type 4 | Char | 1 |
| Primary, Foreign | File Number | Numeric | 12 |
| Primary, Foreign | Amend Number | Numeric | 7 |
| Primary | Action ID | DateTime | 10 |
| Action Type | Char | 40 | |
| Old File Number | Char | 12 | |
| Old Amend Number | Char | 12 |
NOTE: Amendments may have multiple actions.
Lookup Tables
| File Type Values | |
|---|---|
| Code | Value |
| B | Basic (UCC) |
| C | Commodity |
| F | Farm Products (EFS) |
| I | Internal Revenue Service |
| L | Farm Labor |
| N | Medically Indigent (Idaho counties) |
| S | Seed |
| T | Idaho State (Tax, Labor, Health & Welfare) |
| Lien Status Values | |
|---|---|
| Code | Value |
| 1 | Current |
| 2 | Terminated |
| 3 | Lapsed |
| 4 | Lapsed Active* |
| 5 | Inactive |
| 6 | Released |
| 7 | Deleted |
Lapsed Active applies to Basic Liens only (File type B). This indicates the lien has not been continued, has passed its lapse date, but less than 1 year has passed since the lapse date. IDAPA 34.05.06 Sec 310.
Photo: Spokane River in Post Falls, Idaho.