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 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"?>

<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"?>

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.htm)

Required if payee is a committee

<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.htm)

Required if payee is a committee

<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.

Required if payee is an individual

<contactmiddleinitial></contactmiddleinitial>

Required Tag - * Optional Value - Middle single character initial of the payee.

Value is not required

<contactlastname></contactlastname>

Required Tag - * Optional Value - Last name of the payee.

Required if payee is an individual.

<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.

Required if payee is not a committe or an individual.  Use this for Vendor or Misc type

<trustee></trustee>

Required Tag - * Optional Value- Name of trustee.

Required if payee is a trust

<trustor></trustor>

Required Tag - * Optional Value - Name of trustor.

Required if payee is a trust

<trustaffirmationreceived></trustaffirmationreceived>

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

Required if payee is a trust

<contactaddress1></contactaddress1>

Required Tag - Required Value - Mailing address of contributor.

Required for all payees

<contactcity></contactcity>

Required Tag - Required Value - City name of contributor’s residence.

Required for all payees

<contactstate></contactstate>

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

Required for all payees

<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

Required for all payees

<contactprimaryphone></contactprimaryphone>

Required Tag - Optional Value

Optional on payees

<contactsecondaryphone></contactsecondaryphone>

Required Tag - * Optional Value

Optional on payees

<contactemail></contactemail>

Required Tag - * Optional Value- Full valid email address. Example: ContactName@aol.com

Optional on payees

<date></date>

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

Required on all payees

<type></type>

Required Tag - Required Value - Name of the type of expenditure.

(See expenditure types list below.) Some types also require an explanation

<amount></amount>

Required Tag - Required Value - numeric value

Use only numbers, no $ only . as character

<checknumber></checknumber>

Required Tag - * Optional Value - Required if contributor is another committee

Required if type of payee 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.

Required on certain types of transactions, otherwise optional but a good idea.

</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.

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)

Important: 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