SCHEDULE A HEADERS
|
Column
|
Field Name
|
Example
|
Description
|
|
A
|
Unique Number
|
1
|
first column must contain the line number
|
|
B
|
First_Name
|
John
|
required
|
|
C
|
Last_Name
|
Doe
|
required
|
|
D
|
Address_Number
|
3334
|
required
|
|
E
|
Sub_Number
|
1/2 or A
|
|
|
F
|
Prefix_Direction
|
E
|
if included, must be E, S, SE, SW, N, NE, NW, W
|
|
G
|
Street_Name
|
CEDAR
|
required
|
|
H
|
Suffix_Direction
|
W
|
if included, must be E, S, N, W
|
|
I
|
Street_Type
|
AVE
|
if included, must be AVE, BLVD, CIR, CT, DR, HWY, LN, PK, PKY, PL, PLZ, RD, SQ, ST, TER, TFW, TRL, WAY
|
|
J
|
Unit_Number
|
300
|
|
|
K
|
City
|
Topeka
|
required
|
|
L
|
Zip1
|
66633
|
required
|
|
M
|
Zip2
|
1114
|
|
|
N
|
Type_of_Tender
|
Cash
|
required, must be Cash, Check, Loan, Refund, or Other
|
|
O
|
Amount
|
44.99
|
required
|
|
P
|
Date
|
2/9/2008
|
required
|
|
Q
|
PAC_Name
|
John's PAC
|
required if no first name, last name, or Business Name entered
|
|
R
|
Other
|
PO Box 332
|
required if no Address No. or Street Name entered
|
|
S
|
State
|
KS
|
required, must be two-letter state abbreviation
|
|
T
|
Occupation & Industry
|
Attorney - Legal Services
|
required if amount is over $150
|
|
U
|
Unit_Type
|
STE
|
if included, must be APT, STE, BLDG, FLOOR, UNIT, LOT, CONDO
|
|
V
|
Business_Name
|
Signs R Us
|
required if no first name, last name, or PAC Name entered
|
SCHEDULE B HEADERS
|
Column
|
Field Name
|
Example
|
Description
|
|
A
|
Unique Number
|
1
|
first column must contain the line number
|
|
B
|
First_Name
|
John
|
required
|
|
C
|
Last_Name
|
Doe
|
required
|
|
D
|
Address_Number
|
3334
|
required
|
|
E
|
Sub_Number
|
1/2 or A
|
|
|
F
|
Prefix_Direction
|
E
|
if included, must be E, S, SE, SW, N, NE, NW, W
|
|
G
|
Street_Name
|
CEDAR
|
required
|
|
H
|
Suffix_Direction
|
W
|
if included, must be E, S, N, W
|
|
I
|
Street_Type
|
AVE
|
if included, must be AVE, BLVD, CIR, CT, DR, HWY, LN, PK, PKY, PL, PLZ, RD, SQ, ST, TER, TFW, TRL, WAY
|
|
J
|
Unit_Number
|
300
|
|
|
K
|
City
|
Topeka
|
required
|
|
L
|
Zip1
|
66633
|
required
|
|
M
|
Zip2
|
1114
|
|
|
N
|
In_kind_description
|
website design
|
required
|
|
O
|
In_kind_Amount
|
44.99
|
required
|
|
P
|
Date
|
2/9/2008
|
required
|
|
Q
|
PAC_Name
|
John's PAC
|
required if no first name, last name, or Business Name entered
|
|
R
|
Other
|
PO Box 332
|
required if no Address No. or Street Name entered
|
|
S
|
State
|
KS
|
required, must be two-letter state abbreviation
|
|
T
|
Occupation & Industry
|
Attorney - Legal Services
|
required if amount is over $150
|
|
U
|
Unit_Type
|
STE
|
if included, must be APT, STE, BLDG, FLOOR, UNIT,LOT, CONDO
|
|
V
|
Business_Name
|
Signs R Us
|
required if no first name, last name, or PAC Name entered
|
SCHEDULE C HEADERS - CANDIDATE
|
Column
|
Field Name
|
Example
|
Description
|
|
A
|
Unique Number
|
1
|
first column must contain the line number
|
|
B
|
First_Name
|
John
|
required
|
|
C
|
Last_Name
|
Doe
|
required
|
|
D
|
Address_Number
|
3334
|
required
|
|
E
|
Sub_Number
|
1/2 or A
|
|
|
F
|
Prefix_Direction
|
E
|
if included, must be E, S, SE, SW, N, NE, NW, W
|
|
G
|
Street_Name
|
CEDAR
|
required
|
|
H
|
Suffix_Direction
|
W
|
if included, must be E, S, N, W
|
|
I
|
Street_Type
|
AVE
|
if included, must be AVE, BLVD, CIR, CT, DR, HWY, LN, PK, PKY, PL, PLZ, RD, SQ, ST, TER, TFW, TRL, WAY
|
|
J
|
Unit_Number
|
300
|
|
|
K
|
City
|
Topeka
|
required
|
|
L
|
Zip1
|
66633
|
required
|
|
M
|
Zip2
|
1114
|
|
|
N
|
Purpose_of_expenditure
|
Tickets
|
required, must be Candidate (self), Cell Phone, Consultant, Donation/Contrib, Electronics/Computers, Filing Fee, Fundraising Expenses, Gift, Meeting/Travel, Mileage, Miscellaneous, Newspaper Ads, Newsletter, Polling, Postage/Shipping, Printing, Radio/TV, Reimbursement/Refund, Rental, Subscription, Supplies, Tickets, Voter file, Yard signs
|
|
O
|
Expenditure_amount
|
44.99
|
required
|
|
P
|
Date
|
2/9/2008
|
required
|
|
Q
|
PAC_Name
|
John's PAC
|
required if no first name, last name, or Business Name entered
|
|
R
|
Other
|
PO Box 332
|
required if no Address No. or Street Name entered
|
|
S
|
State
|
KS
|
required, must be two-letter state abbreviation
|
|
T
|
Description_of_Expenditure
|
Reimbursement
|
|
|
U
|
Unit_Type
|
STE
|
if included, must be APT, STE, BLDG, FLOOR, UNIT, LOT, CONDO
|
|
V
|
Business_Name
|
Signs R Us
|
required if no first name, last name, or PAC Name entered
|
SCHEDULE C HEADERS - PAC OR PARTY COMMITTEE
|
Column
|
Field Name
|
Example
|
Description
|
|
A
|
Line Number
|
1
|
first column must contain the line number
|
|
B
|
First_Name
|
John
|
required
|
|
C
|
Last_Name
|
Doe
|
required
|
|
D
|
Address_Number
|
3334
|
required
|
|
E
|
Sub_Number
|
1/2 or A
|
|
|
F
|
Prefix_Direction
|
E
|
if included, must be E, S, SE, SW, N, NE, NW, W
|
|
G
|
Street_Name
|
CEDAR
|
required
|
|
H
|
Suffix_Direction
|
W
|
if included, must be E, S, N, W
|
|
I
|
Street_Type
|
AVE
|
if included, must be AVE, BLVD, CIR, CT, DR, HWY, LN, PK, PKY, PL, PLZ, RD, SQ, ST, TER, TFW, TRL, WAY
|
|
J
|
Unit_Number
|
300
|
|
|
K
|
City
|
Topeka
|
required
|
|
L
|
Zip1
|
66633
|
required
|
|
M
|
Zip2
|
1114
|
|
|
N
|
Purpose_of_expenditure
|
Tickets
|
required, must be Candidate (self), Cell Phone, Consultant, Donation/Contrib, Electronics/Computers, Filing Fee, Fundraising Expenses, Gift, Meeting/Travel, Mileage, Miscellaneous, Newspaper Ads, Newsletter, Polling, Postage/Shipping, Printing, Radio/TV, Reimbursement/Refund, Rental, Subscription, Supplies, Tickets, Voter file, Yard signs
|
|
O
|
Expenditure_amount
|
44.99
|
required
|
|
P
|
Date
|
2/9/2008
|
required
|
|
Q
|
PAC_Name
|
John's PAC
|
required if no first name, last name, or Business Name entered
|
|
R
|
Other
|
PO Box 332
|
required if no Address No. or Street Name entered
|
|
S
|
State
|
KS
|
required, must be two-letter state abbreviation
|
|
T
|
Description_of_Expenditure
|
Reimbursement
|
|
|
U
|
Unit_Type
|
STE
|
if included, must be APT, STE, BLDG, FLOOR, UNIT, LOT, CONDO
|
|
V
|
Business_Name
|
Signs R Us
|
required if no first name, last name, or PAC Name entered
|
If Expenditure Amount is over $300.00 then some of the fields below are required
|
W
|
Candidate_First_Name
|
Jane
|
required
|
|
X
|
Candidate_Last_Name
|
Doe
|
required
|
|
Y
|
Candidate_Address_Number
|
3334
|
required
|
|
Z
|
Candidate_Sub Number
|
1/2 or A
|
|
|
AA
|
Candidate_Prefix_Direction
|
E
|
if included, must be E, S, SE, SW, N, NE, NW, W
|
|
AB
|
Candidate_Street_Name
|
CEDAR
|
required
|
|
AC
|
Candidate_Suffix_Direction
|
W
|
if included, must be E, S, N, W
|
|
AD
|
Candidate_Street_Type
|
AVE
|
if included, must be AVE, BLVD, CIR, CT, DR, HWY, LN, PK, PKY, PL, PLZ, RD, SQ, ST, TER, TFW, TRL, WAY
|
|
AE
|
Candidate_Unit_Number
|
300
|
|
|
AF
|
Candidate_City
|
Topeka
|
required
|
|
AG
|
Candidate_Other
|
PO Box 332
|
required if no Address No. or Street Name entered
|
|
AH
|
Candidate_State
|
KS
|
required, must be two-letter state abbreviation
|
|
AI
|
Candidate_Unit_Type
|
STE
|
if included, must be APT, STE, BLDG, FLOOR, UNIT, LOT, CONDO
|
|
AJ
|
Candidate_Zip1
|
65544
|
required
|
|
AK
|
Candidate_Zip2
|
1114
|
|
SCHEDULE D HEADERS
|
Column
|
Field Name
|
Example
|
Description
|
|
A
|
Unique Number
|
1
|
first column must contain the line number
|
|
B
|
First_Name
|
John
|
required
|
|
C
|
Last_Name
|
Doe
|
required
|
|
D
|
Address_Number
|
3334
|
required
|
|
E
|
Sub_Number
|
1/2 or A
|
|
|
F
|
Prefix_Direction
|
E
|
if included, must be E, S, SE, SW, N, NE, NW, W
|
|
G
|
Street_Name
|
CEDAR
|
required
|
|
H
|
Suffix_Direction
|
W
|
if included, must be E, S, N, W
|
|
I
|
Street_Type
|
AVE
|
if included, must be AVE, BLVD, CIR, CT, DR, HWY, LN, PK, PKY, PL, PLZ, RD, SQ, ST, TER, TFW, TRL, WAY
|
|
J
|
Unit_Number
|
300
|
|
|
K
|
City
|
Topeka
|
required
|
|
L
|
Zip1
|
66633
|
required
|
|
M
|
Zip2
|
1114
|
|
|
N
|
Nature_of_account
|
loan
|
required
|
|
O
|
Amount
|
44.99
|
required
|
|
P
|
Date
|
2/9/2008
|
required
|
|
Q
|
PAC_Name
|
John's PAC
|
required if no first name, last name, or Business Name entered
|
|
R
|
Other
|
PO Box 332
|
required if no Address No. or Street Name entered
|
|
S
|
State
|
KS
|
required, must be two-letter state abbreviation
|
|
T
|
Unit_Type
|
STE
|
if included, must be APT, STE, BLDG, FLOOR, UNIT,LOT, CONDO
|
|
U
|
Business_Name
|
Signs R Us
|
required if no first name, last name, or PAC Name entered
|
|