Specification for C1_LOAN_AGREEMENT
FIELD DESCRIPTION TYPE REQUIRED SAMPLE DATA VALUE REFERENCE RULE REFERENCE FIELD FORM ASSOCIATION VALIDATION RULES
REPORT TYPE A/N-100
  • type: string
  • max length: 5
FORM TYPE A/N-8 X (error) SC1/10 SC1/10 SC1/10
  • REQUIRED
  • type: string
  • min length: 1
  • max length: 8
  • regex: ^[ -~]{0,8}$
FILER COMMITTEE ID NUMBER A/N-9 X (error) C00123456
  • REQUIRED
  • type: string
  • min length: 1
  • max length: 9
  • regex: ^(?:[PC][0-9]{8}|[HS][0-9]{1}[A-Z]{2}[0-9]{5})$
TRANSACTION TYPE IDENTIFIER A/N-12 X (error) C1_LOAN_AGREEMENT
  • REQUIRED
  • must equal: C1_LOAN_AGREEMENT
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}$
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}$
LENDER ORGANIZATION NAME A/N-200 X (error) The Bank of Banks Auto-pulled from LOAN_RECEIVED_FROM_BANK
  • REQUIRED
  • type: string
  • min length: 1
  • max length: 200
  • regex: ^[ -~]{0,200}$
LENDER STREET 1 A/N-34 X (error) The Bank Tower Auto-pulled from LOAN_RECEIVED_FROM_BANK
  • REQUIRED
  • type: string
  • min length: 1
  • max length: 34
  • regex: ^[ -~]{0,34}$
LENDER STREET 2 A/N-34 100 Broadway Auto-pulled from LOAN_RECEIVED_FROM_BANK
  • type: ['string', 'null']
  • min length: 0
  • max length: 34
  • regex: ^[ -~]{0,34}$
LENDER CITY A/N-30 X (error) New York Auto-pulled from LOAN_RECEIVED_FROM_BANK
  • REQUIRED
  • type: string
  • min length: 1
  • max length: 30
  • regex: ^[ -~]{0,30}$
LENDER STATE A/N-2 X (error) NY Auto-pulled from LOAN_RECEIVED_FROM_BANK
  • REQUIRED
  • type: string
  • min length: 1
  • max length: 2
  • regex: ^[ -~]{0,2}$
LENDER ZIP A/N-9 X (error) 10011 Auto-pulled from LOAN_RECEIVED_FROM_BANK
  • REQUIRED
  • type: string
  • min length: 1
  • max length: 9
  • regex: ^[ -~]{0,9}$
LOAN AMOUNT AMT-12 X (error) 10000.0 If Original C1, auto-pulled from LOAN_RECEIVED_FROM_BANK
  • REQUIRED
  • type: number
  • minimum: -99999999.99
  • maximum: 999999999.99
LOAN INTEREST RATE % A/N-15 X (error) .0565 If Original C1, auto-pulled from LOAN_RECEIVED_FROM_BANK
  • REQUIRED
  • type: string
  • min length: 1
  • max length: 15
  • regex: ^[ -~]{0,15}$
LOAN INCURRED DATE NUM-8 X (error) 20120101 YYYYMMDD If Original C1, auto-pulled from LOAN_RECEIVED_FROM_BANK
  • REQUIRED
  • type: string
  • min length: 10
  • regex: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$
LOAN DUE DATE A/N-15 X (error) 20121231 YYYYMMDD If Original C1, auto-pulled from LOAN_RECEIVED_FROM_BANK
  • REQUIRED
  • type: string
  • min length: 1
  • max length: 15
  • regex: ^[ -~]{0,15}$
A1.YES/NO (Loan Restructured) A/N-1 X (error) N Y,N
  • REQUIRED
  • type: boolean
A2. DATE (Of Original Loan) NUM-8 X (conditional error) 20120101 YYYYMMDD Req if Loan Restructured is YES
  • REQUIRED if LOAN_RESTRUCTURED equals True
  • type: ['string', 'null']
  • min length: 10
  • regex: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$
B.1. CREDIT AMOUNT THIS DRAW AMT-12 500.0
  • type: ['number', 'null']
  • minimum: -99999999.99
  • maximum: 999999999.99
B.2. TOTAL BALANCE AMT-12 X (conditional error) 10000.0 Req if B.1 Credit Amount this Draw is populated
  • REQUIRED if CREDIT_AMOUNT_THIS_DRAW is populated
  • type: ['number', 'null']
  • minimum: -99999999.99
  • maximum: 999999999.99
C. YES/NO (Others liable?) A/N-1 X (error) Y Y,N
  • REQUIRED
  • type: boolean
D. YES/NO (Collateral?) A/N-1 X (error) Y Y,N
  • REQUIRED
  • type: boolean
D.1 DESC (Collateral) A/N-100 X (conditional error) House & Car Req if Collateral is YES
  • REQUIRED if COLLATERAL equals True
  • type: ['string', 'null']
  • min length: 0
  • max length: 100
  • regex: ^[ -~]{0,100}$
D.2 COLLATERAL VALUE/AMOUNT AMT-12 X (conditional error) 95000.0 Req if Collateral is YES
  • REQUIRED if COLLATERAL equals True
  • type: ['number', 'null']
  • minimum: -99999999.99
  • maximum: 999999999.99
D.3 YES/NO (Perfected Interest?)) A/N-1 N Y,N
  • type: ['boolean', 'null']
E.1 YES/NO (Future Income) A/N-1 X (error) N Y,N
  • REQUIRED
  • type: boolean
E.2 DESC (Specification of the above) A/N-100 X (conditional error) Req if Future Income is YES
  • REQUIRED if FUTURE_INCOME equals True
  • type: ['string', 'null']
  • min length: 0
  • max length: 100
  • regex: ^[ -~]{0,100}$
E.3 ESTIMATED VALUE AMT-12 X (conditional error) Req if Future Income is YES
  • REQUIRED if FUTURE_INCOME equals True
  • type: ['number', 'null']
  • minimum: -99999999.99
  • maximum: 999999999.99
E.4 DATE (Depository account established) NUM-8 X (conditional error) Req if Future Income is YES
  • REQUIRED if FUTURE_INCOME equals True
  • type: ['string', 'null']
  • min length: 10
  • regex: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$
E.5 IND/NAME (Account Location) A/N-200 X (conditional error) Req if Future Income is YES
  • REQUIRED if FUTURE_INCOME equals True
  • type: ['string', 'null']
  • min length: 0
  • max length: 200
  • regex: ^[ -~]{0,200}$
E.6 STREET 1 A/N-34 X (conditional error) Req if Future Income is YES
  • REQUIRED if FUTURE_INCOME equals True
  • type: ['string', 'null']
  • min length: 0
  • max length: 34
  • regex: ^[ -~]{0,34}$
E.7 STREET 2 A/N-34
  • type: ['string', 'null']
  • min length: 0
  • max length: 34
  • regex: ^[ -~]{0,34}$
E.8 CITY A/N-30 X (conditional error) Req if Future Income is YES
  • REQUIRED if FUTURE_INCOME equals True
  • type: ['string', 'null']
  • min length: 0
  • max length: 30
  • regex: ^[ -~]{0,30}$
E.9 STATE A/N-2 X (conditional error) Req if Future Income is YES
  • REQUIRED if FUTURE_INCOME equals True
  • type: ['string', 'null']
  • min length: 0
  • max length: 2
  • regex: ^[ -~]{0,2}$
E.10 ZIP A/N-9 X (conditional error) Req if Future Income is YES
  • REQUIRED if FUTURE_INCOME equals True
  • type: ['string', 'null']
  • min length: 0
  • max length: 9
  • regex: ^[ -~]{0,9}$
F. BASIS OF LOAN DESCRIPTION A/N-100 Handshake
  • type: ['string', 'null']
  • min length: 0
  • max length: 100
  • regex: ^[ -~]{0,100}$
G. TREASURER LAST NAME A/N-30 X (error) Smith
  • REQUIRED
  • type: string
  • min length: 1
  • max length: 30
  • regex: ^[ -~]{0,30}$
G. TREASURER FIRST NAME A/N-20 X (error) Patrick
  • REQUIRED
  • type: string
  • min length: 1
  • max length: 20
  • regex: ^[ -~]{0,20}$
G. TREASURER MIDDLE NAME A/N-20 Thomas
  • type: ['string', 'null']
  • min length: 0
  • max length: 20
  • regex: ^[ -~]{0,20}$
G. TREASURER PREFIX A/N-10 Mr.
  • type: ['string', 'null']
  • min length: 0
  • max length: 10
  • regex: ^[ -~]{0,10}$
G. TREASURER SUFFIX A/N-10 Jr.
  • type: ['string', 'null']
  • min length: 0
  • max length: 10
  • regex: ^[ -~]{0,10}$
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}$
H. AUTHORIZED LAST NAME A/N-30 X (error) Smith
  • REQUIRED
  • type: string
  • min length: 1
  • max length: 30
  • regex: ^[ -~]{0,30}$
H. AUTHORIZED FIRST NAME A/N-20 X (error) Patrick
  • REQUIRED
  • type: string
  • min length: 1
  • max length: 20
  • regex: ^[ -~]{0,20}$
H. AUTHORIZED MIDDLE NAME A/N-20 Thomas
  • type: ['string', 'null']
  • min length: 0
  • max length: 20
  • regex: ^[ -~]{0,20}$
H. AUTHORIZED PREFIX A/N-10 Mr.
  • type: ['string', 'null']
  • min length: 0
  • max length: 10
  • regex: ^[ -~]{0,10}$
H. AUTHORIZED SUFFIX A/N-10 Jr.
  • type: ['string', 'null']
  • min length: 0
  • max length: 10
  • regex: ^[ -~]{0,10}$
H. AUTHORIZED TITLE A/N-20 X (error) Treasurer
  • REQUIRED
  • type: string
  • min length: 1
  • max length: 20
  • regex: ^[ -~]{0,20}$
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}$