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

Back