Specification for SchB
COL SEQ |
FIELD DESCRIPTION |
TYPE |
REQUIRED |
SAMPLE DATA |
VALUE REFERENCE |
RULE REFERENCE |
FIELD FORM ASSOCIATION |
VALIDATION RULES |
1 |
FORM TYPE |
A/N-8 |
X (error) |
SB17 |
SB[line# ref] |
Appendix C. SB3L must be used
with the F3L |
F3 | F3X | F3P | F3L |
- REQUIRED
- type: string
- min length: 1
- max length: 8
- regex: ^[ -~]{0,8}$
|
2 |
FILER COMMITTEE ID NUMBER |
A/N-9 |
X (error) |
C00123456 |
|
Must be either "CXXXXXXXX" where X is a numeric value (C, then 8 numbers) or "PXXXXXXXX" where X is a numeric value (P, then 8 numbers) or [H|S][0-9]{1}[A-Z]{2}[0-9]{5} (H or S, 1 number, 2 letters, 5 numbers) |
F3 | F3X | F3P | F3L |
- REQUIRED
- type: string
- min length: 1
- max length: 9
- regex: ^[ -~]{0,9}$
|
|
TRANSACTION TYPE IDENTIFIER |
|
X (error) |
|
|
OPERATING_EXPENDITURE |
|
|
3 |
TRANSACTION ID |
A/N-20 |
X (error) |
B56123456789-1234 |
|
must be unique for the life of the report (original + all amendments) |
F3 | F3X | F3P | F3L |
- REQUIRED
- type: string
- min length: 1
- max length: 20
- regex: ^[ -~]{0,20}$
|
4 |
BACK REFERENCE TRAN ID NUMBER |
A/N-20 |
|
B123456789-1234 |
|
Reference to the Tran ID of a Related Record |
F3 | F3X | F3P | F3L |
- type: ['string', 'null']
- min length: 0
- max length: 20
- regex: ^[ -~]{0,20}$
|
5 |
BACK REFERENCE SCHED NAME |
A/N-8 |
|
SB21 |
SB[line# ref] |
Ref to the Schedule that has the Related Record. SB3L must be used
with the F3L |
F3 | F3X | F3P | F3L |
- type: ['string', 'null']
- min length: 0
- max length: 8
- regex: ^[ -~]{0,8}$
|
6 |
ENTITY TYPE |
A/N-3 |
X (error) |
CCM |
[IND|ORG|COM] |
[IND|ORG|COM] |
F3 | F3X | F3P | F3L |
- REQUIRED
- type: string
- min length: 1
- max length: 3
- regex: ^[ -~]{0,3}$
|
7 |
PAYEE ORGANIZATION NAME |
A/N-200 |
X (error) |
John Smith & Co. |
|
Required if [ORG|COM] |
F3 | F3X | F3P | F3L |
- REQUIRED
- type: string
- min length: 1
- max length: 200
- regex: ^[ -~]{0,200}$
|
8 |
PAYEE LAST NAME |
A/N-30 |
X (error) |
Smith |
|
Required if [IND] |
F3 | F3X | F3P | F3L |
- REQUIRED
- type: string
- min length: 1
- max length: 30
- regex: ^[ -~]{0,30}$
|
9 |
PAYEE FIRST NAME |
A/N-20 |
X (error) |
John |
|
Required if [IND] |
F3 | F3X | F3P | F3L |
- REQUIRED
- type: string
- min length: 1
- max length: 20
- regex: ^[ -~]{0,20}$
|
10 |
PAYEE MIDDLE NAME |
A/N-20 |
|
W |
|
Optional if [IND] |
F3 | F3X | F3P | F3L |
- type: ['string', 'null']
- min length: 0
- max length: 20
- regex: ^[ -~]{0,20}$
|
11 |
PAYEE PREFIX |
A/N-10 |
|
Dr |
|
Optional if [IND] |
F3 | F3X | F3P | F3L |
- type: ['string', 'null']
- min length: 0
- max length: 10
- regex: ^[ -~]{0,10}$
|
12 |
PAYEE SUFFIX |
A/N-10 |
|
Jr |
|
Optional if [IND] |
F3 | F3X | F3P | F3L |
- type: ['string', 'null']
- min length: 0
- max length: 10
- regex: ^[ -~]{0,10}$
|
13 |
PAYEE STREET 1 |
A/N-34 |
X (error) |
Suite 16 |
|
|
F3 | F3X | F3P | F3L |
- type: ['string', 'null']
- min length: 0
- max length: 34
- regex: ^[ -~]{0,34}$
|
14 |
PAYEE STREET 2 |
A/N-34 |
|
30 Oak Street |
|
|
F3 | F3X | F3P | F3L |
- type: ['string', 'null']
- min length: 0
- max length: 34
- regex: ^[ -~]{0,34}$
|
15 |
PAYEE CITY |
A/N-30 |
X (error) |
Springfield |
|
|
F3 | F3X | F3P | F3L |
- type: ['string', 'null']
- min length: 0
- max length: 30
- regex: ^[ -~]{0,30}$
|
16 |
PAYEE STATE |
A/N-2 |
X (error) |
MA |
|
|
F3 | F3X | F3P | F3L |
- type: ['string', 'null']
- min length: 0
- max length: 2
- regex: ^[ -~]{0,2}$
|
17 |
PAYEE ZIP |
A/N-9 |
X (error) |
1012 |
|
|
F3 | F3X | F3P | F3L |
- type: ['string', 'null']
- min length: 0
- max length: 9
- regex: ^[ -~]{0,9}$
|
18 |
ELECTION CODE |
A/N-5 |
|
P2012 |
G,P,O[YYYY] |
Values: [G|P|R|S|C|E|O]+Year{YYYY} |
F3 | F3X | F3P |
- type: ['string', 'null']
- min length: 0
- max length: 5
- regex: ^[ -~]{0,5}$
|
19 |
ELECTION OTHER DESCRIPTION |
A/N-20 |
|
|
|
Req if Item Election Code = O |
F3 | F3X | F3P |
- type: ['string', 'null']
- min length: 0
- max length: 20
- regex: ^[ -~]{0,20}$
|
20 |
EXPENDITURE DATE |
NUM-8 |
X (error) |
20120720 |
YYYYMMDD |
|
F3 | F3X | F3P |
- type: string
- min length: 10
- regex: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$
|
21 |
EXPENDITURE AMOUNT |
AMT-12 |
X (error) |
1500 |
|
Expenditure (F3L Bundled Refund) Amt |
F3 | F3X | F3P | F3L |
- type: ['number', 'null']
- minimum: -99999999.99
- maximum: 999999999.99
|
22 |
SEMI-ANNUAL REFUNDED BUNDLED AMT |
AMT-12 |
|
2500 |
|
Used for F3L only. Semi-annual Bundled Refund. |
F3L |
- type: ['number', 'null']
- minimum: -99999999.99
- maximum: 999999999.99
|
23 |
EXPENDITURE PURPOSE DESCRIP |
A/N-100 |
|
Repay Loan |
|
|
F3 | F3X | F3P |
- type: ['string', 'null']
- min length: 0
- max length: 100
- regex: ^[ -~]{0,100}$
|
|
AGGREGATION AMOUNT |
AMT-12 |
X (error) |
1000 |
|
|
|
- type: ['number', 'null']
- minimum: -99999999.99
- maximum: 999999999.99
|
|
AGGREGATION GROUP |
A/N-100 |
X (error) |
GENERAL_DISBURSEMENT |
|
|
|
|
24 |
CATEGORY CODE |
A/N-3 |
|
1 |
001, 002, ... 012;
and
101 - 107 |
Codes 001-012 are for use by, and only by, non-Presidential Committees.
Codes 101-107 are used only by Presidential Committees |
F3 | F3X | F3P |
- type: ['string', 'null']
- min length: 0
- max length: 3
- regex: ^[ -~]{0,3}$
|
25 |
BENEFICIARY COMMITTEE FEC ID |
A/N-9 |
|
C00654323 |
|
Used if CCM, PAC or PTY |
F3 | F3X | F3P | F3L |
- type: ['string', 'null']
- min length: 0
- max length: 9
- regex: ^(?:[PC][0-9]{8}|[HS][0-9]{1}[A-Z]{2}[0-9]{5})$
|
26 |
BENEFICIARY COMMITTEE NAME |
A/N-200 |
X (conditional error) |
John Smith & Co. |
|
Req if Candidate FEC ID is selected |
F3 | F3X | F3P | F3L |
- type: ['string', 'null']
- min length: 0
- max length: 200
- regex: ^[ -~]{0,200}$
|
27 |
BENEFICIARY CANDIDATE FEC ID |
A/N-9 |
X (conditional error) |
H98765431 |
|
Req if Candidate FEC ID is selected |
F3 | F3X | F3P | F3L |
- type: ['string', 'null']
- min length: 0
- max length: 9
- regex: ^[ -~]{0,9}$
|
28 |
BENEFICIARY CANDIDATE LAST NAME |
A/N-30 |
X (conditional error) |
|
|
Req if Candidate FEC ID is selected |
F3 | F3X | F3P | F3L |
- type: ['string', 'null']
- min length: 0
- max length: 30
- regex: ^[ -~]{0,30}$
|
29 |
BENEFICIARY CANDIDATE FIRST NAME |
A/N-20 |
X (conditional error) |
|
|
Req if Candidate FEC ID is selected |
F3 | F3X | F3P | F3L |
- type: ['string', 'null']
- min length: 0
- max length: 20
- regex: ^[ -~]{0,20}$
|
30 |
BENEFICIARY CANDIDATE MIDDLE NAME |
A/N-20 |
|
|
|
|
F3 | F3X | F3P | F3L |
- type: ['string', 'null']
- min length: 0
- max length: 20
- regex: ^[ -~]{0,20}$
|
31 |
BENEFICIARY CANDIDATE PREFIX |
A/N-10 |
|
|
|
|
F3 | F3X | F3P | F3L |
- type: ['string', 'null']
- min length: 0
- max length: 10
- regex: ^[ -~]{0,10}$
|
32 |
BENEFICIARY CANDIDATE SUFFIX |
A/N-10 |
|
|
|
|
F3 | F3X | F3P | F3L |
- type: ['string', 'null']
- min length: 0
- max length: 10
- regex: ^[ -~]{0,10}$
|
33 |
BENEFICIARY CANDIDATE OFFICE |
A/N-1 |
|
H |
H,S,P |
|
F3 | F3X | F3P | F3L |
- type: ['string', 'null']
- min length: 0
- max length: 1
- regex: ^[ -~]{0,1}$
|
34 |
BENEFICIARY CANDIDATE STATE |
A/N-2 |
X (conditional error) |
FL |
AK,AL,... |
|
F3 | F3X | F3P | F3L |
- type: ['string', 'null']
- min length: 0
- max length: 2
- regex: ^[ -~]{0,2}$
|
35 |
BENEFICIARY CANDIDATE DISTRICT |
NUM-2 |
X (conditional error) |
35 |
01 ... 99 |
|
F3 | F3X | F3P | F3L |
- type: ['string', 'null']
- min length: 2
- max length: 2
- regex: ^\d{2}$
|
36 |
CONDUIT NAME |
A/N-200 |
|
Middle Organization |
If Conduit |
|
F3 | F3X | F3P |
- type: ['string', 'null']
- min length: 0
- max length: 200
- regex: ^[ -~]{0,200}$
|
37 |
CONDUIT STREET 1 |
A/N-34 |
|
45 E Street |
|
|
F3 | F3X | F3P |
- type: ['string', 'null']
- min length: 0
- max length: 34
- regex: ^[ -~]{0,34}$
|
38 |
CONDUIT STREET 2 |
A/N-34 |
|
|
|
|
F3 | F3X | F3P |
- type: ['string', 'null']
- min length: 0
- max length: 34
- regex: ^[ -~]{0,34}$
|
39 |
CONDUIT CITY |
A/N-30 |
|
Springfield |
|
|
F3 | F3X | F3P |
- type: ['string', 'null']
- min length: 0
- max length: 30
- regex: ^[ -~]{0,30}$
|
40 |
CONDUIT STATE |
A/N-2 |
|
MA |
|
|
F3 | F3X | F3P |
- type: ['string', 'null']
- min length: 0
- max length: 2
- regex: ^[ -~]{0,2}$
|
41 |
CONDUIT ZIP |
A/N-9 |
|
10111 |
|
|
F3 | F3X | F3P |
- type: ['string', 'null']
- min length: 0
- max length: 9
- regex: ^[ -~]{0,9}$
|
42 |
MEMO CODE |
A/N-1 |
|
|
X |
X = True |
F3 | F3X | F3P | F3L |
- type: ['boolean', 'null']
|
43 |
MEMO TEXT/DESCRIPTION |
A/N-100 |
|
|
|
|
F3 | F3X | F3P | F3L |
- type: ['string', 'null']
- min length: 0
- max length: 100
- regex: ^[ -~]{0,100}$
|
44 |
Reference to SI or SL system code that identifies the Account |
A/N-9 |
|
123xyzABC |
|
Must contain a valid system code used in a Schedule I or L. |
F3 | F3X | F3P |
- type: ['string', 'null']
- min length: 0
- max length: 9
- regex: ^[ -~]{0,9}$
|