Search Iowa Ethics:

State of Iowa

Additional info:

Our FAQ

For more information on how to use this site, go here.

Information for County Auditors is here.

Lobbyists and Clients need to register with the General Assembly. The legislative website is here.

More links:

 

| home | board | campaigns| ethics| reports | filing | laws |

 

XML/CSV Format for Schedule B Expenditures*

View of all tag elements w/out values.

<?xml version="1.0" encoding="UTF-8"?>(not used in CSV)
<expenditures>
<expenditure>
<committeename></committeename>
<committeecode></committeecode>
<contacttype></contacttype>
<contactfirstname></contactfirstname>
<contactmiddleinitial></contactmiddleinitial>
<contactlastname></contactlastname>
<contactrelationship></contactrelationship>
<contactname></contactname>
<trustee></trustee>
<trustor></trustor>
<trustaffirmationreceived></trustaffirmationreceived>
<contactaddress1></contactaddress1>
<contactaddress2></contactaddress2>
<contactcity></contactcity>
<contactstate></contactstate>
<contactzip></contactzip>
<contactprimaryphone></contactprimaryphone>
<contactsecondaryphone></contactsecondaryphone>
<contactemail></contactemail>
<date></date>
<type></type>
<amount></amount>
<checknumber></checknumber>
<explanation></explanation>
</expenditure>
</expenditures>

To think about the structure of this file one should have the understanding of its hierarchy. The following shows the overall relationship between the tags.

<?xml version="1.0" encoding="UTF-8"?> (not used in CSV)
<expenditures>

----><expenditure>

--->rest of tags

• The xml tag declares the file type, which contains expenditures held within the expenditures tag. Each expenditure is made up by several elements.
• XML HAS Expenditures / Expenditures HAVE Expenditure(one or many) / Expenditure HAS ELEMENTS(rest of tags)

<?xml version="1.0" encoding="UTF-8"?>(not used in CSV)
Required Tag - This tag denotes that the file is that of xml type and sets some parameters. It does not have a corresponding end tag.

<expenditures>
Required Tag - This tag is the starting point for all the transactions. Its corresponding end tag must be the last tag in the xml file.

<expenditure>
Required Tag - This tag is the starting point for one Schedule B Expenditure transaction. Its corresponding end tag must be the last tag before starting another transaction.

<committeename></committeename>
Required Tag - * Optional Value - Full Committee name of the payee committee. (See IECDB Web site for current committee names listing: http://www.state.ia.us/government/iecdb/lists/index.html)

<committeecode></committeecode>
Required Tag - * Optional Value - Committee code of the payee committee. (See IECDB Web site for current committee code listing: http://www.state.ia.us/government/iecdb/lists/index.html)

<contacttype></contacttype>
Required Tag - Required Value - Name of the type of payee. (See contact types list below.)

<contactfirstname></contactfirstname>
Required Tag - * Optional Value - First name of the payee.

<contactmiddleinitial></contactmiddleinitial>
Required Tag - * Optional Value - Middle single character initial of the payee.

<contactlastname></contactlastname>
Required Tag - * Optional Value - Last name of the payee.

<contactrelationship></contactrelationship>
Required Tag - Required Value - Two digit Relationship type code of payee to candidate. (See relationship type list below.)

<contactname></contactname>
Required Tag - * Optional Value - Name of the payee if type other than Individual or Committee.

<trustee></trustee>
Required Tag - * Optional Value - Name of trustee.

<trustor></trustor>
Required Tag - * Optional Value - Name of trustor.

<trustaffirmationreceived></trustaffirmationreceived>
Required Tag - * Optional Value
- Use a Y for Yes or a N for No as the value.

<contactaddress1></contactaddress1>
Required Tag - * Required Value
- Mailing address of contributor.

<contactcity></contactcity>
Required Tag - * Required Value
- City name of contributor’s residence.

<contactstate></contactstate>
Required Tag - * Required Value
- State of residence of the contributor. Must be state abbreviation code Example= IA or NE

<contactzip></contactzip>
Required Tag - * Required Value
- Zip code of the residence of the contributor. Can be 5 digit zip or a 9 digit zip separated with a - Example= 50156 or 50156-1478

<contactprimaryphone></contactprimaryphone>
Required Tag - Optional Value
-

<contactsecondaryphone></contactsecondaryphone>
Required Tag - Optional Value
-

<contactemail></contactemail>
Required Tag - Optional Value
- Full valid email address. Example= ContactName@aol.com

<date></date>
Required Tag - Required Value
- Must be entered in following format MM/DD/YYYY

<type></type>
Required Tag - Required Value
- Name of the type of expenditure. (See expenditure types list below.)

<amount></amount>
Required Tag - Required Value
- Do not use any special characters other than .

<checknumber></checknumber>
Required Tag - * Optional Value
- Required if contributor is another committee

<explanation></explanation>
Required Tag - Optional Value
- Value should be the description of the transaction. Free form text can have any data as value.

</expenditure>
Required Tag
- End tag denoting end of one contribution.

</expenditures>
Required Tag
- End tag denoting end of all contributions. Should be last tag in your xml file.


* NOTE: Some optional value tags are only optional when certain other optional tags have value. Also, some required value tags may only be required when other optional tags are used. The following shows the different options.

<committeename></committeename>
required if type of contributor is another committee
<committeecode></committeecode>
required if type of contributor is another committee
<contactfirstname></contactfirstname>
required if type of contributor is an individual
<contactmiddleinitial></contactmiddleinitial>
optional if type of contributor is an individual else not required
<contactlastname></contactlastname>
required if type of contributor is an individual
<contactname></contactname>
needed if type of contributor any type other than a committee or individual type
<trustee></trustee>
needed if type of contributor is trust
<trustor></trustor>
needed if type of contributor is trust
<trustaffirmationreceived></trustaffirmationreceived>
needed if type of contributor is trust
<contactaddress1></contactaddress1>
required if type of contributor is an individual
<contactcity></contactcity>
required if type of contributor is an individual
<contactstate></contactstate>
required if type of contributor is an individual
<contactzip></contactzip>
required if type of contributor is an individual
<checknumber></checknumber>
required if type of contributor is a committee

Contact Types List

Individual (use this for single persons)
Organization (use this for committees only, requires committee id as well)
Trust
(use this if expenditure is to a trust and fill out required trustee/trustor information)
Vendor (use this for organizations that do not have a commmittee id)
Misc (use this for un-itemized expenditures)

You must keep the same case (upper/lower)as shown below:

<contacttype>Individual</contacttype>
<contacttype>Organization</contacttype>
<contacttype>Trust</contacttype>
<contacttype>Vendor</contacttype>
<contacttype>Misc</contacttype>


Relationship Type Codes and Descriptions

01 None
02 Spouse
03 Child
04 Parent
05 Brother
06 Sister
07 Half-brother
08 Half-sister
09 Grandchild
10 Grandparent
11 Uncle
12 Aunt
13 Nephew
14 Niece
15 Great-grandparent
16 Great-grandchild
17 Stepchild
18 Stepmother
19 Stepfather
20 Mother-in-law
21 Father-in-law
22 Stepbrother
23 Stepsister
24 Brother-in-law
25 Sister-in-law
26 Stepgrandchild
27 Stepgrandparent
28 Stepuncle
29 Stepaunt
30 Stepnephew
31 Stepniece
32 Stepgreat-grandparent
33 Stepgreat-grandchild
34 Self
35 Father
36 Mother

Expenditure Types List

Advertising
Bank Charges
Campaign Merchandise
Charitable Contributions
Civil Penalty, Hearing Cost
Constituency Expenses
Consultant Services
Debt Forgiven
Dissolution Distribution
Fund-Raiser (Attended)
Fund-Raiser (Holding)
Gifts or Meals for Volunteers
HQ Expenses
Interest on Loan
Loans Forgiven
Meals Reimbursement
Mileage
Miscellaneous or Unitemized
Office Equipment
Office Holder Expenses
Office Supplies
Other Expenditure
Photography
Political Contribution
Postage, Shipping, Delivery
Printing & Reproduction
Professional Fees
Reverse Transaction
Salary & Gratuity
Travel
If you have certain special characters in one of your values they may cause problems.

BAD <type>Salary &amp; Gratuity</type>
GOOD <type><![CDATA[Salary & Gratuity]]></type>

Click here for tags with sample data (XML) or here for structure with sample data (CSV)