Specification for SchC1
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) SC1/9 SC1/[line# ref] Appendix C
  • 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) C1_LOAN_AGREEMENT C1_LOAN_AGREEMENT
  • type: string
  • min length: 0
  • max length: 20
  • regex: ^[ -~]{0,20}$
3 TRANSACTION ID A/N-20 X (error) C123456789-3456-001 May be a combination of Parent SC/ TranID + a unique ID for this Child SC1/ record 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 BACK REFERENCE TRAN ID NUMBER A/N-20 X (error) C123456789-3456 Reference to the Tran ID of a Related SC/{***} Record
  • REQUIRED
  • type: string
  • min length: 1
  • max length: 20
  • regex: ^[ -~]{0,20}$
5 LENDER ORGANIZATION NAME A/N-200 X (error) The Bank of Banks Required if NOT [IND|CAN]
  • REQUIRED
  • type: string
  • min length: 1
  • max length: 200
  • regex: ^[ -~]{0,200}$
6 LENDER STREET 1 A/N-34 X (error) The Bank Tower
  • type: ['string', 'null']
  • min length: 0
  • max length: 34
  • regex: ^[ -~]{0,34}$
7 LENDER STREET 2 A/N-34 100 Broadway
  • type: ['string', 'null']
  • min length: 0
  • max length: 34
  • regex: ^[ -~]{0,34}$
8 LENDER CITY A/N-30 X (error) New York
  • type: ['string', 'null']
  • min length: 0
  • max length: 30
  • regex: ^[ -~]{0,30}$
9 LENDER STATE A/N-2 X (error) NY
  • type: ['string', 'null']
  • min length: 0
  • max length: 2
  • regex: ^[ -~]{0,2}$
10 LENDER ZIP A/N-9 X (error) 10011
  • type: ['string', 'null']
  • min length: 0
  • max length: 9
  • regex: ^[ -~]{0,9}$
11 LOAN AMOUNT AMT-12 X (error) 10000.0
  • REQUIRED
  • type: number
  • minimum: -99999999.99
  • maximum: 999999999.99
12 LOAN INTEREST RATE % A/N-15 X (error) .0565
  • type: ['string', 'null']
  • min length: 0
  • max length: 15
  • regex: ^[ -~]{0,15}$
13 LOAN INCURRED DATE NUM-8 X (error) 20120101 YYYYMMDD
  • REQUIRED
  • type: string
  • min length: 10
  • regex: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$
14 LOAN DUE DATE A/N-15 X (error) 20121231 YYYYMMDD
  • REQUIRED
  • type: string
  • min length: 1
  • max length: 15
  • regex: ^[ -~]{0,15}$
15 A1.YES/NO (Loan Restructured) A/N-1 X (error) N Y,N Edit: Yes/No
  • type: ['boolean', 'null']
16 A2. DATE (Of Original Loan) NUM-8 X (conditional error) 20120101 YYYYMMDD Req if Loan Restructured is YES
  • type: ['string', 'null']
  • min length: 10
  • regex: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$
17 B.1. CREDIT AMOUNT THIS DRAW AMT-12 500.0
  • type: ['number', 'null']
  • minimum: -99999999.99
  • maximum: 999999999.99
18 B.2. TOTAL BALANCE AMT-12 X (conditional error) 10000.0 Req if B.1 Credit Amount this Draw is populated
  • type: ['number', 'null']
  • minimum: -99999999.99
  • maximum: 999999999.99
19 C. YES/NO (Others liable?) A/N-1 X (error) Y Y,N Edit: Yes/No
  • type: ['boolean', 'null']
20 D. YES/NO (Collateral?) A/N-1 X (error) Y Y,N Edit: Yes/No
  • type: ['boolean', 'null']
21 D.1 DESC (Collateral) A/N-100 X (conditional error) House & Car Req if Collateral is YES
  • type: ['string', 'null']
  • min length: 0
  • max length: 100
  • regex: ^[ -~]{0,100}$
22 D.2 COLLATERAL VALUE/AMOUNT AMT-12 X (conditional error) 95000.0 Req if Collateral is YES
  • type: ['number', 'null']
  • minimum: -99999999.99
  • maximum: 999999999.99
23 D.3 YES/NO (Perfected Interest?)) A/N-1 N Y,N Edit: Yes/No
  • type: ['boolean', 'null']
24 E.1 YES/NO (Future Income) A/N-1 X (error) N Y,N Edit: Yes/No
  • type: ['boolean', 'null']
25 E.2 DESC (Specification of the above) A/N-100 X (conditional error) Req if Future Income is YES
  • type: ['string', 'null']
  • min length: 0
  • max length: 100
  • regex: ^[ -~]{0,100}$
26 E.3 ESTIMATED VALUE AMT-12 X (conditional error) Req if Future Income is YES
  • type: ['number', 'null']
  • minimum: -99999999.99
  • maximum: 999999999.99
27 E.4 DATE (Depository account established) NUM-8 X (conditional error) Req if Future Income is YES
  • type: ['string', 'null']
  • min length: 10
  • regex: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$
28 E.5 IND/NAME (Account Location) A/N-200 X (conditional error) Req if Future Income is YES
  • type: ['string', 'null']
  • min length: 0
  • max length: 200
  • regex: ^[ -~]{0,200}$
29 E.6 STREET 1 A/N-34 X (conditional error) Req if Future Income is YES
  • type: ['string', 'null']
  • min length: 0
  • max length: 34
  • regex: ^[ -~]{0,34}$
30 E.7 STREET 2 A/N-34 Opt if Future Income is YES
  • type: ['string', 'null']
  • min length: 0
  • max length: 34
  • regex: ^[ -~]{0,34}$
31 E.8 CITY A/N-30 X (conditional error) Req if Future Income is YES
  • type: ['string', 'null']
  • min length: 0
  • max length: 30
  • regex: ^[ -~]{0,30}$
32 E.9 STATE A/N-2 X (conditional error) Req if Future Income is YES
  • type: ['string', 'null']
  • min length: 0
  • max length: 2
  • regex: ^[ -~]{0,2}$
33 E.10 ZIP A/N-9 X (conditional error) Req if Future Income is YES
  • type: ['string', 'null']
  • min length: 0
  • max length: 9
  • regex: ^[ -~]{0,9}$
34 E.11 DEP ACCT AUTH DATE (Presidential) NUM-8
  • type: ['string', 'null']
  • min length: 10
  • regex: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$
35 F. BASIS OF LOAN DESCRIPTION A/N-100 Handshake
  • type: ['string', 'null']
  • min length: 0
  • max length: 100
  • regex: ^[ -~]{0,100}$
36 G. TREASURER LAST NAME A/N-30 X (error) Smith
  • REQUIRED
  • type: string
  • min length: 1
  • max length: 30
  • regex: ^[ -~]{0,30}$
37 G. TREASURER FIRST NAME A/N-20 X (error) Patrick
  • REQUIRED
  • type: string
  • min length: 1
  • max length: 20
  • regex: ^[ -~]{0,20}$
38 G. TREASURER MIDDLE NAME A/N-20 Thomas
  • type: ['string', 'null']
  • min length: 0
  • max length: 20
  • regex: ^[ -~]{0,20}$
39 G. TREASURER PREFIX A/N-10 Mr.
  • type: ['string', 'null']
  • min length: 0
  • max length: 10
  • regex: ^[ -~]{0,10}$
40 G. TREASURER SUFFIX A/N-10 Jr.
  • type: ['string', 'null']
  • min length: 0
  • max length: 10
  • regex: ^[ -~]{0,10}$
41 G. DATE SIGNED NUM-8 X (error) 20120729 YYYYMMDD
  • REQUIRED
  • type: string
  • min length: 10
  • regex: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$
42 H. AUTHORIZED LAST NAME A/N-30 X (error) Smith
  • REQUIRED
  • type: string
  • min length: 1
  • max length: 30
  • regex: ^[ -~]{0,30}$
43 H. AUTHORIZED FIRST NAME A/N-20 X (error) Patrick
  • REQUIRED
  • type: string
  • min length: 1
  • max length: 20
  • regex: ^[ -~]{0,20}$
44 H. AUTHORIZED MIDDLE NAME A/N-20 Thomas
  • type: ['string', 'null']
  • min length: 0
  • max length: 20
  • regex: ^[ -~]{0,20}$
45 H. AUTHORIZED PREFIX A/N-10 Mr.
  • type: ['string', 'null']
  • min length: 0
  • max length: 10
  • regex: ^[ -~]{0,10}$
46 H. AUTHORIZED SUFFIX A/N-10 Jr.
  • type: ['string', 'null']
  • min length: 0
  • max length: 10
  • regex: ^[ -~]{0,10}$
47 H. AUTHORIZED TITLE A/N-20 X (error) Treasurer
  • REQUIRED
  • type: string
  • min length: 1
  • max length: 20
  • regex: ^[ -~]{0,20}$
48 H. DATE SIGNED NUM-8 X (error) 20120820 YYYYMMDD
  • REQUIRED
  • type: string
  • min length: 10
  • regex: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$