Skip to main content
My DOR and other online services will be down for maintenance from 5 p.m. PST Friday, January 17, 2025, to 8 a.m. PST Tuesday, January 21, 2025.
Descriptions of the Mobile Telecommunications Sourcing Act Electronic Database Fields
Descriptions of the database fields and definitions for the data:
| Field name | Field definition | Field length | Justification | Populated in DOR's database? |
|---|---|---|---|---|
| Beginning Effective Date | Date in CCYYMMDD format | 8 | right | yes |
| Ending Effective Date | Date in CCYYMMDD format | 8 | right | yes |
| Low Address Range | Beginning address range | 10 | right | yes |
| High Address Range | Ending address range | 10 | right | yes |
| Odd/Even "Range" Indicator | Left/right street side indicator | 1 | left | yes |
| Street Pre-Directional Abbr. | Prefix direction, e.g., W | 2 | left | yes |
| Street - Name | Street name, e.g., Main | 20 | left | yes |
| Street - Suffix Abbr. | Street type, e.g., St | 4 | left | yes |
| Street - Post Directional | Suffix direction, e.g., NW | 2 | left | yes |
| Address Secondary Abbr. | Secondary Address (Address Line 2) if Highrise or Firm | 4 | left | no |
| Address Secondary (Low) | Secondary Address (Address Line 2) if Highrise or Firm | 8 | right | no |
| Address Secondary (High) | Secondary Address (Address Line 2) if Highrise or Firm | 8 | right | no |
| Address Secondary (Odd/Even) | Secondary Address (Address Line 2) if Highrise or Firm | 1 | left | no |
| City Name | City | 28 | left | no |
| Zip Code | in USPS zip code format | 5 | right | yes |
| Plus4 | in USPS plus+4 format | 4 | right | yes |
| FIPS State Code | Federal Information Processing Standards state code, always 53 for Washington State | 2 | right | yes |
| FIPS County Code | Federal Information Processing Standards county code | 3 | right | yes |
| FIPS Place (Municipality) Code | Federal Information Processing Standards place code | 5 | right | no |
| FIPS Place Class Code | Federal Information Processing Standards place class code | 2 | right | no |
| Longitude Data | east/west angular distance from the prime meridian (Greenwich, England) measured in decimal degrees | 7 | right | no |
| Latitude Data | north/south angular distance from the equator measured in decimal degrees | 7 | right | no |
| Location Code Source | "ST" signifies state defined | 2 | left | yes |
| Location Code | four digit number identifying which sales tax jurisdiction address is located in | 5 | right | yes |
| Location Code's Type of Taxing Authority Code | Form X12 Data Element 1721 | 2 | right | no |
| Regional Transit Authority Code Source | "ST" signifies state defined | 2 | left | yes |
| Regional Transit Authority | 1 if in RTA, 0 if outside RTA | 5 | right | yes |
| Regional Transit Authority's Type of Taxing Authority Code | Form X12 Data Element 1721 | 2 | right | no |
| Special Tax District Code Source (#3) | Could be "VD" for vendor defined or "ST" for state defined | 2 | left | no |
| Special Tax District Code (#3) | This is the actual code from the source | 5 | right | no |
| Type of Taxing Authority Code | Form X12 Data Element 1721 | 2 | right | no |
| Special Tax District Code Source (#4) | Could be "VD" for vendor defined or "ST" for state defined | 2 | left | no |
| Special Tax District Code (#4) | This is the actual code from the source | 5 | right | no |
| Type of Taxing Authority Code | Form X12 Data Element 1721 | 2 | right | no |
| Special Tax District Code Source (#5) | Could be "VD" for vendor defined or "ST" for state defined | 2 | left | no |
| Special Tax District Code (#5) | This is the actual code from the source | 5 | right | no |
| Type of Taxing Authority Code | Form X12 Data Element 1721 | 2 | right | no |
| Special Tax District Code Source (#6) | Could be "VD" for vendor defined or "ST" for state defined | 2 | left | no |
| Special Tax District Code (#6) | This is the actual code from the source | 5 | right | no |
| Type of Taxing Authority Code | Form X12 Data Element 1721 | 2 | right | no |
| Special Tax District Code Source (#7) | Could be "VD" for vendor defined or "ST" for state defined | 2 | left | no |
| Special Tax District Code (#7) | This is the actual code from the source | 5 | right | no |
| Type of Taxing Authority Code | Form X12 Data Element 1721 | 2 | right | no |
| Special Tax District Code Source (#8) | Could be "VD" for vendor defined or "ST" for state defined | 2 | left | no |
| Special Tax District Code (#8) | This is the actual code from the source | 5 | right | no |
| Type of Taxing Authority Code | Form X12 Data Element 1721 | 2 | right | no |
| Special Tax District Code Source (#9) | Could be "VD" for vendor defined or "ST" for state defined | 2 | left | no |
| Special Tax District Code (#9) | This is the actual code from the source | 5 | right | no |
| Type of Taxing Authority Code | Form X12 Data Element 1721 | 2 | right | no |
| Special Tax District Code Source (#10) | Could be "VD" for vendor defined or "ST" for state defined | 2 | left | no |
| Special Tax District Code (#10) | This is the actual code from the source | 5 | right | no |
| Type of Taxing Authority Code | Form X12 Data Element 1721 | 2 | right | no |
