Specification for SchD
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) SD9, SD10 SD9, SD10 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) C2_LOAN_GUARANTOR DEBT_OWED_TO_COMMITTEE DEBT_OWED_BY_COMMITTEE
  • type: string
3 TRANSACTION ID A/N-20 X (error) D123456789-3456 Must be unique for the life of a report (original + amendments) within each committee account. Letters, if included, must be uppercase.
  • REQUIRED
  • type: string
  • min length: 1
  • max length: 20
  • regex: ^[ -~]{0,20}$
4 ENTITY TYPE A/N-3 IND IND, ORG, COM IND, ORG, COM
  • type: ['string', 'null']
  • min length: 0
  • max length: 3
  • regex: ^[ -~]{0,3}$
5 CREDITOR ORGANIZATION NAME A/N-200 X (conditional error) The Bank of Banks Required if NOT [IND]
  • REQUIRED
  • type: string
  • min length: 1
  • max length: 200
  • regex: ^[ -~]{0,200}$
6 CREDITOR LAST NAME A/N-30 X (conditional error) Smith Required if [IND]
  • REQUIRED
  • type: string
  • min length: 1
  • max length: 30
  • regex: ^[ -~]{0,30}$
7 CREDITOR FIRST NAME A/N-20 X (conditional error) John Required if [IND]
  • REQUIRED
  • type: string
  • min length: 1
  • max length: 20
  • regex: ^[ -~]{0,20}$
8 CREDITOR MIDDLE NAME A/N-20 W Optional if [IND]
  • type: ['string', 'null']
  • min length: 0
  • max length: 20
  • regex: ^[ -~]{0,20}$
9 CREDITOR PREFIX A/N-10 Dr Optional if [IND]
  • type: ['string', 'null']
  • min length: 0
  • max length: 10
  • regex: ^[ -~]{0,10}$
10 CREDITOR SUFFIX A/N-10 Jr Optional if [IND]
  • type: ['string', 'null']
  • min length: 0
  • max length: 10
  • regex: ^[ -~]{0,10}$
11 CREDITOR STREET 1 A/N-34 X (error) The Bank Tower
  • type: ['string', 'null']
  • min length: 0
  • max length: 34
  • regex: ^[ -~]{0,34}$
12 CREDITOR STREET 2 A/N-34 100 Broadway
  • type: ['string', 'null']
  • min length: 0
  • max length: 34
  • regex: ^[ -~]{0,34}$
13 CREDITOR CITY A/N-30 X (error) New York
  • type: ['string', 'null']
  • min length: 0
  • max length: 30
  • regex: ^[ -~]{0,30}$
14 CREDITOR STATE A-2 X (error) NY
  • type: ['string', 'null']
  • min length: 0
  • max length: 2
  • regex: ^[ -~]{0,2}$
15 CREDITOR ZIP A/N-9 X (error) 10011
  • type: ['string', 'null']
  • min length: 0
  • max length: 9
  • regex: ^[ -~]{0,9}$
16 PURPOSE OF DEBT OR OBLIGATION A/N-100 X (error)
  • type: ['string', 'null']
  • min length: 0
  • max length: 100
  • regex: ^[ -~]{0,100}$
17 BEGINNING BALANCE (This Period) AMT-12 X (error) Auto-calculated from previous reports "Balance at Close"
  • type: ['number', 'null']
  • minimum: -99999999.99
  • maximum: 999999999.99
18 INCURRED AMOUNT (This Period) AMT-12 X (error)
  • type: ['number', 'null']
  • minimum: -99999999.99
  • maximum: 999999999.99
19 PAYMENT AMOUNT (This Period) AMT-12 X (error) Auto-calculated from debt repayments.
  • type: ['number', 'null']
  • minimum: -99999999.99
  • maximum: 999999999.99
20 BALANCE AT CLOSE (This Period) AMT-12 X (error) Auto-calculated for the user. Beginning Balance + (Incurred amount - Payment amount) All amounts from current report period.
  • type: ['number', 'null']
  • minimum: -99999999.99
  • maximum: 999999999.99