Specification for LOANS
| 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) |
SC/10 |
[SC/9 |SC/10 ] |
If Transaction Type is LOAN_RECEIVED_FROM_INDIVIDUAL or LOAN_RECEIVED_FROM_BANK, then Form Type is SC/10 If Transaction Type is LOAN_BY_COMMITTEE, then Receipt Line Number is SC/9 |
|
- FORM_TYPE = 'SC/10' if TRANSACTION_TYPE_IDENTIFIER equals LOAN_RECEIVED_FROM_INDIVIDUAL
- FORM_TYPE = 'SC/10' if TRANSACTION_TYPE_IDENTIFIER equals LOAN_RECEIVED_FROM_BANK
- FORM_TYPE = 'SC/9' if TRANSACTION_TYPE_IDENTIFIER equals LOAN_BY_COMMITTEE
- REQUIRED
- must be one of: ['SC/9', 'SC/10']
|
| FILER COMMITTEE ID NUMBER |
A/N-9 |
X (error) |
C00123456 |
|
|
|
- REQUIRED
- type: string
- min length: 9
- 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) |
LOAN_RECEIVED_FROM_INDIVIDUAL |
|
LOAN_RECEIVED_FROM_INDIVIDUAL, LOAN_RECEIVED_FROM_BANK, LOAN_BY_COMMITTEE |
|
- REQUIRED
- must be one of: ['LOAN_RECEIVED_FROM_INDIVIDUAL', 'LOAN_RECEIVED_FROM_BANK', 'LOAN_BY_COMMITTEE']
|
| 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}$
|
| RECEIPT LINE NUMBER |
A/N-8 |
X (conditional error) |
13 |
[13] |
Required if Transaction Type is (LOAN_RECEIVED_FROM_INDIVIDUAL or LOAN_RECEIVED_FROM_BANK), then Receipt Line Number is 13 If Transaction Type is LOAN_BY_COMMITTEE, must be blank. |
|
- REQUIRED if TRANSACTION_TYPE_IDENTIFIER equals LOAN_RECEIVED_FROM_INDIVIDUAL
- RECEIPT_LINE_NUMBER = '13' if TRANSACTION_TYPE_IDENTIFIER equals LOAN_RECEIVED_FROM_INDIVIDUAL
- REQUIRED if TRANSACTION_TYPE_IDENTIFIER equals LOAN_RECEIVED_FROM_BANK
- RECEIPT_LINE_NUMBER = '13' if TRANSACTION_TYPE_IDENTIFIER equals LOAN_RECEIVED_FROM_BANK
- type: ['string', 'null']
|
| ENTITY TYPE |
A/N-3 |
X (error) |
ORG |
[IND | ORG | COM] |
If Transaction Type is LOAN_RECEIVED_FROM_INDIVIDUAL, then Entity is IND, ORG, or COM, If Transaction Type is LOAN_RECEIVED_FROM_BANK, then Entity is ORG, If Transaction Type is LOAN_BY_COMMITTEE, then Entity is COM |
|
- ENTITY_TYPE = 'ORG' if TRANSACTION_TYPE_IDENTIFIER equals LOAN_RECEIVED_FROM_BANK
- ENTITY_TYPE = 'COM' if TRANSACTION_TYPE_IDENTIFIER equals LOAN_BY_COMMITTEE
- REQUIRED
- must be one of: ['IND', 'ORG', 'COM']
|
| LENDER ORGANIZATION NAME |
A/N-200 |
X (conditional error) |
The Bank of Banks |
|
Required if [ORG | COM] |
|
- REQUIRED if ENTITY_TYPE equals ORG
- REQUIRED if ENTITY_TYPE equals COM
- type: ['string', 'null']
- min length: 0
- max length: 200
- regex: ^[ -~]{0,200}$
|
| LENDER LAST NAME |
A/N-30 |
X (conditional error) |
Smith |
|
Required if [IND] |
|
- REQUIRED if ENTITY_TYPE equals IND
- type: ['string', 'null']
- min length: 0
- max length: 30
- regex: ^[ -~]{0,30}$
|
| LENDER FIRST NAME |
A/N-20 |
X (conditional error) |
John |
|
Required if [IND] |
|
- REQUIRED if ENTITY_TYPE equals IND
- type: ['string', 'null']
- min length: 0
- max length: 20
- regex: ^[ -~]{0,20}$
|
| LENDER MIDDLE NAME |
A/N-20 |
|
W |
|
|
|
- type: ['string', 'null']
- min length: 0
- max length: 20
- regex: ^[ -~]{0,20}$
|
| LENDER PREFIX |
A/N-10 |
|
Dr |
|
|
|
- type: ['string', 'null']
- min length: 0
- max length: 10
- regex: ^[ -~]{0,10}$
|
| LENDER SUFFIX |
A/N-10 |
|
Jr |
|
|
|
- type: ['string', 'null']
- min length: 0
- max length: 10
- regex: ^[ -~]{0,10}$
|
| LENDER STREET 1 |
A/N-34 |
X (error) |
Suite 16 |
|
|
|
- REQUIRED
- type: string
- min length: 1
- max length: 34
- regex: ^[ -~]{0,34}$
|
| LENDER STREET 2 |
A/N-34 |
|
30 Oak Street |
|
|
|
- type: ['string', 'null']
- min length: 0
- max length: 34
- regex: ^[ -~]{0,34}$
|
| LENDER CITY |
A/N-30 |
X (error) |
Springfield |
|
|
|
- REQUIRED
- type: string
- min length: 1
- max length: 30
- regex: ^[ -~]{0,30}$
|
| LENDER STATE |
A-2 |
X (error) |
MA |
|
|
|
- REQUIRED
- type: string
- min length: 1
- max length: 2
- regex: ^[ -~]{0,2}$
|
| LENDER ZIP |
A/N-9 |
X (error) |
1012 |
|
|
|
- REQUIRED
- type: string
- min length: 1
- max length: 9
- regex: ^[ -~]{0,9}$
|
| LOAN AMOUNT |
AMT-12 |
X (error) |
10000 |
|
|
|
- REQUIRED
- type: number
- minimum: -99999999.99
- maximum: 999999999.99
|
| LOAN PAYMENT TO DATE |
AMT-12 |
X (error) |
1000 |
|
Auto-calculated based upon user entering payments on the loan. |
|
- REQUIRED
- type: number
- minimum: -99999999.99
- maximum: 999999999.99
|
| LOAN BALANCE (Original) |
AMT-12 |
X (error) |
9000 |
|
Auto-calculated based upon subtracting loan payment to date from original amount of loan |
|
- REQUIRED
- type: number
- minimum: -99999999.99
- maximum: 999999999.99
|
| LOAN INCURRED DATE (Terms) |
NUM-8 |
X (error) |
20120101 |
YYYYMMDD |
|
|
- REQUIRED
- type: string
- min length: 10
- regex: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$
|
| LOAN DUE DATE (Terms) |
A/N-15 |
X (error) |
Whenever |
|
|
|
- REQUIRED
- type: string
- min length: 1
- max length: 15
- regex: ^[ -~]{0,15}$
|
| LOAN INTEREST RATE % (Terms) |
A/N-15 |
X (error) |
.0565 |
|
|
|
- REQUIRED
- type: string
- min length: 1
- max length: 15
- regex: ^[ -~]{0,15}$
|
| YES/NO (Secured?) |
A/N-1 |
X (error) |
Y |
Y/N |
Edit: Yes/No |
|
|
| LENDER COMMITTEE ID NUMBER |
A/N-9 |
X (conditional error) |
C00123456 |
|
Required if [COM] |
|
- REQUIRED if ENTITY_TYPE equals COM
- type: ['string', 'null']
- min length: 0
- max length: 9
- regex: ^[ -~]{0,9}$
|
| MEMO CODE |
A/N-1 |
|
|
X |
X = True |
|
- type: ['boolean', 'null']
|
| MEMO TEXT/DESCRIPTION |
A/N-100 |
|
|
|
|
|
- type: ['string', 'null']
- min length: 0
- max length: 100
- regex: ^[ -~]{0,100}$
|