Base type for a string Used for a text field. Legal Characters: printable characters from ! to ~ plus symbols from ¡ to ¿ plus Spanish characters and single space. Illegal Character: leading space, trailing space, adjacent spaces. 4-digit decimal typically used by a decimal amount field (Percentage field). Max 100, Min 0 2-digit decimal typically used by a decimal amount field. Type for a amount field with dollars and cents A short explanation field that allows up to 255 characters. Used for an email address Domain Name Email Address Version of the schema file used. Used for a phone no. - 10 digits Used for a phone Extension number - 5 digits Used for a phone no. - 10 digits Used for a phone no. - 10 digits Checkbox Type 0 1 Transaction Type New Business Additional Premium Return Premium Cancellation Renewal Reinstatement Backout Of New Business Backout Of Additional Premium Backout Of Return Premium Backout Of Cancellation Backout Of Renewal Backout Of Reinstatement Used for a street address. Legal Characters: A-Z, a-z, 0-9, hyphen , hash, hyphen, ampersand and single space. Illegal Character: leading space, trailing space, adjacent spaces, and other symbols. Used for a city. Legal Characters: A-Z, a-z, and single space. Illegal Character: leading space, trailing space, adjacent spaces, and symbols. ZIP Code - 5 digits plus optional 4. No dashes List of Washington Counties Adams Asotin Benton Chelan Clallam Clark Columbia Cowlitz Douglas Ferry Franklin Garfield Grant Grays Harbor Island Jefferson King Kitsap Kittitas Klickitat Lewis Lincoln Mason Okanogan Pacific Pend Oreille Pierce San Juan Skagit Skamania Snohomish Spokane Stevens Thurston Wahkiakum Walla Walla Whatcom Whitman Yakima List of Document Classifications Other Affadavit/Certification Used for Brokerage Number. 4 numbers 0000 - 9999 Brokerage Name Insurer Name State abbreviations, a.k.a. state codes. Alabama Alaska American Samoa Arizona Arkansas California Colorado Connecticut Delaware District of Columbia Federated States of Micronesia Florida Georgia Guam Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Marshall Islands Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota North Mariana Islands Ohio Oklahoma Oregon Palau Pennsylvania Puerto Rico Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virgin Islands Virginia Washington West Virginia Wisconsin Wyoming Armed Forces the Americas Armed Forces Europe Armed Forces Pacific State abbreviations, a.k.a. state codes. Only WA is accepted Washington Address line 1 Address line 2 The name of the city. State Zip Code Address line 1 Address line 2 The name of the city. State Zip Code Address line 1 Address line 2 City State Zip Code Insurer Information Insurer NAIC Number. Insurer Name Percentage Waiver Exception Must be unique within the return Typically used for a person's name. Legal Characters: A-Z, a-z, hyphen, apostrophe and single space. Illegal Character: leading space, trailing space, adjacent spaces, and other symbols. Typically used for a business name. Legal Characters: A-Z, a-z, 0-9, hash, hyphen, parentheses, ampersand, apostrophe and single space. Illegal Character: leading space, trailing space, adjacent spaces, and other symbols. Retail Producer Type. Either an Individual or Business Insured Name field that allows up to 100 characters The first name of the person. The middle name of the person. The last name of the person. Person suffix File extensions allowed to be included in the zip file. 100 chars file length plus the extension Document Name The name of the person who did or will do the ACTUAL submission of this file. The submission contact email address' Submission Contact Address SLA Broker Batch submission XML Import file format. Mailing Address SLA Brokerage number. The reporting Brokerage's name The Policy Number Broker information The first name of the broker. The last name of the broker. Broker WAOIC Number. Retail Producer information Retail Producer ID used by brokerages internally. The name of retail producer. Retail Producer Address. Description of Coverage regarding the policy The term expiration date of the policy If checked (=1) no expiration date. First Named Insured or DBA information First named Insured or DBA. Insured Washington mailing address The name of the county of risk for the policy. If checked (=1) then it is a master policy. If checked (=1) then it is a multi-state. If checked (=1) then it is an exempt commercial purchaser If checked (=1) then it is a risk purchasing group Risk Purchasing Group name if the policy is a risk purchasing group Insurers for this policy Transaction identifier used by brokerages internally. Transaction Type. The amount charged/returned to the insured minus any fees. Any fees charged/returned to the insured. The effective date of the transaction. The Procurement date of the transaction. The Certificate Number Certificate holder name Must be unique within the file Must be unique within the file Policy Number and Insurer NAIC combination is unique within the file. Policy Number is unique within the file. Brokerage Transaction Number is unique within the file.