Specification for SchC
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) |
SC/10 |
[SC/9 |SC/10 ] |
[SC/9 |SC/10 ] |
|
- 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) |
|
- REQUIRED
- type: string
- min length: 1
- max length: 9
- regex: ^[ -~]{0,9}$
|
|
TRANSACTION TYPE IDENTIFIER |
|
X (error) |
|
|
LOAN_RECEIVED_FROM_INDIVIDUAL
LOAN_RECEIVED_FROM_BANK
LOAN_BY_COMMITTEE |
|
|
3 |
TRANSACTION ID |
A/N-20 |
X (error) |
C123456789-3456 |
|
must be unique for the life of the report (original + all amendments) |
|
- REQUIRED
- type: string
- min length: 1
- max length: 20
- regex: ^[ -~]{0,20}$
|
4 |
RECEIPT LINE NUMBER |
A/N-8 |
X (conditional error) |
13 |
13A = Form 3; Sum Pg #13(a)
13B = Form 3; Sum Pg #13(b)
19A = Form 3P; Sum Pg #19(a)
19B = Form 3P; Sum Pg #19(b)
13 = Form 3X; Sum Pg #13 |
Required if a 'SC/10' record on a Form 3 or 3X or a 'SC/12' record on a Form 3P. |
|
- type: ['string', 'null']
- min length: 0
- max length: 8
- regex: ^[ -~]{0,8}$
|
5 |
ENTITY TYPE |
A/N-3 |
|
ORG |
[IND |ORG | COM] |
Edit: Entity |
|
- type: ['string', 'null']
- min length: 0
- max length: 3
- regex: ^[ -~]{0,3}$
|
6 |
LENDER ORGANIZATION NAME |
A/N-200 |
X (conditional error) |
The Bank of Banks |
|
Required if NOT [IND|CAN] |
|
- REQUIRED
- type: string
- min length: 1
- max length: 200
- regex: ^[ -~]{0,200}$
|
7 |
LENDER LAST NAME |
A/N-30 |
X (conditional error) |
Smith |
|
Required if [IND|CAN] |
|
- REQUIRED
- type: string
- min length: 1
- max length: 30
- regex: ^[ -~]{0,30}$
|
8 |
LENDER FIRST NAME |
A/N-20 |
X (conditional error) |
John |
|
Required if [IND|CAN] |
|
- REQUIRED
- type: string
- min length: 1
- max length: 20
- regex: ^[ -~]{0,20}$
|
9 |
LENDER MIDDLE NAME |
A/N-20 |
|
W |
|
Optional if [IND|CAN] |
|
- type: ['string', 'null']
- min length: 0
- max length: 20
- regex: ^[ -~]{0,20}$
|
10 |
LENDER PREFIX |
A/N-10 |
|
Dr |
|
Optional if [IND|CAN] |
|
- type: ['string', 'null']
- min length: 0
- max length: 10
- regex: ^[ -~]{0,10}$
|
11 |
LENDER SUFFIX |
A/N-10 |
|
Jr |
|
Optional if [IND|CAN] |
|
- type: ['string', 'null']
- min length: 0
- max length: 10
- regex: ^[ -~]{0,10}$
|
12 |
LENDER STREET 1 |
A/N-34 |
X (error) |
Suite 16 |
|
|
|
- type: ['string', 'null']
- min length: 0
- max length: 34
- regex: ^[ -~]{0,34}$
|
13 |
LENDER STREET 2 |
A/N-34 |
|
30 Oak Street |
|
|
|
- type: ['string', 'null']
- min length: 0
- max length: 34
- regex: ^[ -~]{0,34}$
|
14 |
LENDER CITY |
A/N-30 |
X (error) |
Springfield |
|
|
|
- type: ['string', 'null']
- min length: 0
- max length: 30
- regex: ^[ -~]{0,30}$
|
15 |
LENDER STATE |
A/N-2 |
X (error) |
MA |
|
|
|
- type: ['string', 'null']
- min length: 0
- max length: 2
- regex: ^[ -~]{0,2}$
|
16 |
LENDER ZIP |
A/N-9 |
X (error) |
1012 |
|
|
|
- type: ['string', 'null']
- min length: 0
- max length: 9
- regex: ^[ -~]{0,9}$
|
17 |
ELECTION CODE |
A/N-5 |
|
P2012 |
[G|P|R|S|C|E|O]+{YYYY} |
Values: [G|P|R|S|C|E|O]+Year{YYYY} |
|
- type: ['string', 'null']
- min length: 0
- max length: 5
- regex: ^[ -~]{0,5}$
|
18 |
ELECTION OTHER DESCRIPTION |
A/N-20 |
X (conditional error) |
|
|
Req if Item Election Code = O |
|
- type: ['string', 'null']
- min length: 0
- max length: 20
- regex: ^[ -~]{0,20}$
|
19 |
LOAN AMOUNT |
AMT-12 |
X (error) |
10000 |
|
|
|
- type: ['number', 'null']
- minimum: -99999999.99
- maximum: 999999999.99
|
20 |
LOAN PAYMENT TO DATE |
AMT-12 |
X (error) |
1000 |
|
Auto-calculated based upon user entering payments on the loan. |
|
- type: ['number', 'null']
- minimum: -99999999.99
- maximum: 999999999.99
|
21 |
LOAN BALANCE (Original) |
AMT-12 |
X (error) |
9000 |
|
Auto-calculated based upon subtracting loan payment to date from original amount of loan |
|
- type: ['number', 'null']
- minimum: -99999999.99
- maximum: 999999999.99
|
22 |
LOAN INCURRED DATE (Terms) |
NUM-8 |
X (error) |
20120101 |
YYYYMMDD |
|
|
- type: string
- min length: 10
- regex: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$
|
23 |
LOAN DUE DATE (Terms) |
A/N-15 |
X (error) |
Whenever |
|
|
|
- type: ['string', 'null']
- min length: 0
- max length: 15
- regex: ^[ -~]{0,15}$
|
24 |
LOAN INTEREST RATE % (Terms) |
A/N-15 |
X (error) |
.0565 |
|
|
|
- type: ['string', 'null']
- min length: 0
- max length: 15
- regex: ^[ -~]{0,15}$
|
25 |
YES/NO (Secured?) |
A/N-1 |
X (error) |
Y |
Y/N |
Edit: Yes/No |
|
- type: ['boolean', 'null']
|
26 |
YES/NO (Personal Funds) |
A/N-1 |
X (error) |
Y |
Y/N |
Edit: Yes/No |
|
- type: ['boolean', 'null']
|
27 |
LENDER COMMITTEE ID NUMBER |
A/N-9 |
X (conditional error) |
C00123456 |
|
Required if [COM] |
|
- type: string
- min length: 0
- max length: 9
- regex: ^[ -~]{0,9}$
|
28 |
LENDER CANDIDATE ID NUMBER |
A/N-9 |
|
H98765431 |
|
Used if CAN or CCM |
|
- type: string
- min length: 0
- max length: 9
- regex: ^[ -~]{0,9}$
|
29 |
LENDER CANDIDATE LAST NAME |
A/N-30 |
|
|
|
If either Last or First name coded; |
|
- type: ['string', 'null']
- min length: 0
- max length: 30
- regex: ^[ -~]{0,30}$
|
30 |
LENDER CANDIDATE FIRST NAME |
A/N-20 |
|
|
|
both Last & First names required. |
|
- type: ['string', 'null']
- min length: 0
- max length: 20
- regex: ^[ -~]{0,20}$
|
31 |
LENDER CANDIDATE MIDDLE NAME |
A/N-20 |
|
|
|
|
|
- type: ['string', 'null']
- min length: 0
- max length: 20
- regex: ^[ -~]{0,20}$
|
32 |
LENDER CANDIDATE PREFIX |
A/N-10 |
|
|
|
|
|
- type: ['string', 'null']
- min length: 0
- max length: 10
- regex: ^[ -~]{0,10}$
|
33 |
LENDER CANDIDATE SUFFIX |
A/N-10 |
|
|
|
|
|
- type: ['string', 'null']
- min length: 0
- max length: 10
- regex: ^[ -~]{0,10}$
|
34 |
LENDER CANDIDATE OFFICE |
A/N-1 |
|
H |
H,S,P |
Edit: OFFICE |
|
- type: ['string', 'null']
- min length: 0
- max length: 1
- regex: ^[ -~]{0,1}$
|
35 |
LENDER CANDIDATE STATE |
A/N-2 |
|
FL |
AK,AL,... |
Edit: ST (if Office = Sen or House) |
|
- type: ['string', 'null']
- min length: 0
- max length: 2
- regex: ^[ -~]{0,2}$
|
36 |
LENDER CANDIDATE DISTRICT |
NUM-2 |
|
36 |
01 ... 99 |
(if Office = House) |
|
- type: ['string', 'null']
- min length: 2
- max length: 2
- regex: ^\d{2}$
|
37 |
MEMO CODE |
A/N-1 |
|
|
X |
X = True |
|
- type: ['boolean', 'null']
|
38 |
MEMO TEXT/DESCRIPTION |
A/N-100 |
|
|
|
|
|
- type: ['string', 'null']
- min length: 0
- max length: 100
- regex: ^[ -~]{0,100}$
|