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