LOAN_CD

AMEND_ID   Integer · Unique

Amendment identification number. A number of 0 is the original filing and 1 to 999 amendments.

BAKREF_TID   String (up to 20)

Back Reference to transaction identifier of parent record

CMTE_ID   String (up to 9)

Committee identification number

ENTITY_CD   String (up to 3)

Entity code describing the lender

FILING_ID   Integer · Unique

Unique filing identification number

FORM_TYPE   String (up to 2) · Unique

Name of the source filing form or schedule

INTR_CITY   String (up to 30)

Intermediary's city

INTR_NAMF   String (up to 45)

Intermediary's first name

INTR_NAML   String (up to 200)

Intermediary's last name

INTR_NAMS   String (up to 10)

Intermediary's suffix

INTR_NAMT   String (up to 10)

Intermediary's title or prefix

INTR_ST   String (up to 2)

Intermediary's state

INTR_ZIP4   String (up to 10)

Intermediary's ZIP Code

LINE_ITEM   Integer · Unique

Line item number of this record

LNDR_NAMF   String (up to 45)

Lender's first name

LNDR_NAML   String (up to 200)

Lender's last name or business name

LNDR_NAMS   String (up to 10)

Lender's suffix

LNDR_NAMT   String (up to 10)

Lender's title or prefix

LOAN_AMT1   Decimal number

Repaid or forgiven amount; Original loan amount. The content of this column varies based on the schedule/part that the record applies to. See the CAL document for a description of the value of this field.

LOAN_AMT2   Decimal number

Outstanding Principal; unpaid balance. The content of this column varies based on the schedule/part that the record applies to. See the CAL document for a description of the value of this field.

LOAN_AMT3   Decimal number

Interest Paid; Unpaid interest; Interest received. The content of this column varies based on the schedule/part that the record applies to. See the CAL document for a description of the value of this field.

LOAN_AMT4   Decimal number

Cumulative Amount/Other. The content of this column varies based on the schedule/part that the record applies to. See the CAL document for a description of the value of this field.

LOAN_AMT5   Decimal number

This field is undocumented

LOAN_AMT6   Decimal number

This field is undocumented

LOAN_AMT7   Decimal number

This field is undocumented

LOAN_AMT8   Decimal number

This field is undocumented

LOAN_CITY   String (up to 30)

Lender's city

LOAN_DATE1   Date (without time)

Date the loan was made or received. The content of this column varies based on the schedule/part that the record applies to. See the CAL document for a description of the value.

LOAN_DATE2   Date (without time)

Date repaid/forgiven; date loan due. The content of this column varies based on the schedule/part that the record applies to. See the CAL document for a description of the value of this field.

LOAN_EMP   String (up to 200)

Loan employer. Applies to the Form 460 Schedule B Part 1.

LOAN_OCC   String (up to 60)

Loan occupation. Applies to the Form 460 Schedule B Part 1.

LOAN_RATE   String (up to 30)

Interest Rate. The content of this column varies based on the schedule/part that the record applies to. See the CAL document for a description of the value of this field.

LOAN_SELF   String (up to 1)

Self-employed checkbox

LOAN_ST   String (up to 2)

Lender's state

LOAN_TYPE   String (up to 3)

Type of loan

LOAN_ZIP4   String (up to 10)

Lender's ZIP Code

MEMO_CODE   String (up to 1)

Memo amount flag

MEMO_REFNO   String (up to 20)

Reference to text contained in a TEXT record

REC_TYPE   String (up to 4) · Unique

Record Type Value: LOAN

TRAN_ID   String (up to 20)

Permanent value unique to this item

TRES_CITY   String (up to 30)

Treasurer or responsible officer's city

TRES_NAMF   String (up to 45)

Treasurer or responsible officer's first name

TRES_NAML   String (up to 200)

Treasurer or responsible officer's last name

TRES_NAMS   String (up to 10)

Treasurer or responsible officer's suffix

TRES_NAMT   String (up to 10)

Treasurer or responsible officer's title or prefix

TRES_ST   String (up to 2)

Treasurer or responsible officer's street address

TRES_ZIP4   String (up to 10)

Treasurer or responsible officer's ZIP Code

XREF_MATCH   String (up to 1)

Related item on other schedule has same transaction identifier. "X" indicates this condition is true.

XREF_SCHNM   String (up to 2)

Related record is included on Form 460 Schedule 'A' or 'E'

Form 460: Campaign Disclosure Statement (Recipient Committee)

Schedule B, Part 1, Loans Received

Schedule B, Part 2, Loan Guarantors

Schedule B, Part 3, Outstanding Balance

Schedule H, Loans Made to Others

Schedule H, Part 1, Loans Made

Schedule H, Part 2, Repayments Rcvd

Schedule H, Part 3, Outstanding Loans