Form460ScheduleB2ItemOld

Repayments on loans/forgiven loans received by campaign filers circa 2001.

Fields

Information about the 38 fields and the definitions of any abbreviated values.


amount_repaid_or_forgiven   Decimal number

Amount paid back or forgiven during the period covered by the filing (from LOAN_CD.LOAN_AMT1)


date_of_original_loan   Date (without time)

Date the loan was orginally made (from LOAN_CD.LOAN_DATE1)


date_repaid_or_forgiven   Date (without time)

Date when the loan repayment or forgiveness occurred (from LOAN_CD.LOAN_DATE2)


filing   Foreign Key (type determined by related field)

Foreign key referring to the Form 460 on which the loan transaction was reported (from LOAN_CD.FILING_ID)


id   Integer


interest_paid   Decimal number

Amount of interest paid on the loan during the period covered by the campaign filing (from LOAN_CD.LOAN_AMT3)


interest_rate   String (up to %(max_length)s)

Interest rate of the loan. This is sometimes expressed as a decimal (e.g., 0.10) and other times as a percent (e.g., 10.0% (from LOAN_CD.LOAN_RATE)


intermediary_city   String (up to %(max_length)s)

City of the intermediary (from LOAN_CD.INTR_CITY)


intermediary_firstname   String (up to %(max_length)s)

First name of the intermediary (from LOAN_CD.INTR_NAMF)


intermediary_lastname   String (up to %(max_length)s)

Last name of the intermediary or business name (from LOAN_CD.INTR_NAML)


intermediary_name_suffix   String (up to %(max_length)s)

Name suffix of the intermediary (from LOAN_CD.INTR_NAMS)


intermediary_state   String (up to %(max_length)s)

State of the intermediary (from LOAN_CD.INTR_ST)


intermediary_title   String (up to %(max_length)s)

Name title of the intermediary (from LOAN_CD.INTR_NAMT)


intermediary_zip   String (up to %(max_length)s)

Zip code (usually zip5, sometimes zip9) of the intermediary (from LOAN_CD.INTR_ZIP4)


lender_city   String (up to %(max_length)s)

City of the lender (from LOAN_CD.LOAN_CITY)


lender_code   String (up to %(max_length)s)

Code describing the lender (from LOAN_CD.ENTITY_CD)

Code Definition
COM Committee
IND Individual
OTH Other
PTY Political Party
RCP Recipient committee
SCC Small Contributor Committee
??? Unknown value

lender_committee_id   String (up to %(max_length)s)

Lender's filer identification number, if it is a committee (from LOAN_CD.CMTE_ID)


lender_employer   String (up to %(max_length)s)

Employer of the lender (from LOAN_CD.LOAN_EMP)


lender_firstname   String (up to %(max_length)s)

First name of the lender (from LOAN_CD.LNDR_NAMF)


lender_is_self_employed   Boolean (Either True or False)

Indicates whether or not the lender is self-employed(from LOAN_CD.LOAN_SELF)


lender_lastname   String (up to %(max_length)s)

Last name of the lender or business name (from LOAN_CD.LNDR_NAML)


lender_name_suffix   String (up to %(max_length)s)

Name suffix of the lender (from LOAN_CD.LNDR_NAMS)


lender_occupation   String (up to %(max_length)s)

Occupation of the lender (from LOAN_CD.LOAN_OCC)


lender_state   String (up to %(max_length)s)

State of the lender (from LOAN_CD.LOAN_ST)


lender_title   String (up to %(max_length)s)

Name title of the lender (from LOAN_CD.LNDR_NAMT)


lender_zip   String (up to %(max_length)s)

Zip code (usually zip5, sometimes zip9) of the lender (from LOAN_CD.LOAN_ZIP4)


line_item   Integer

Line number of the filing form where the loan is itemized (from LOAN_CD.LINE_ITEM)


memo_reference_number   String (up to %(max_length)s)

A value assigned by the filer which refers to the item'sfootnote in the TEXT_MEMO_CD table (from LOAN_CD.MEMO_REFNO)


outstanding_principle   Decimal number

Outstanding principle of the loan at the end of the period covered by the filing (from LOAN_CD.LOAN_AMT2)


repayment_type   String (up to %(max_length)s)

Indicates whether the item is a loan repayment by the campaign filer, a repayment by a third-party or a loan forgiveness by the lender (from LOAN_CD.LOAN_TYPE)

Code Definition
B2F Forgiven
B2R Repay
B2T Third party payment

transaction_id   String (up to %(max_length)s)

Identifies a unique transaction across versions of the a given Form 460 filing (from LOAN_CD.TRAN_ID)


treasurer_city   String (up to %(max_length)s)

City of the lender committee's treasurer (from LOAN_CD.TRES_CITY)


treasurer_firstname   String (up to %(max_length)s)

First name of the lender committee's treasurer (from LOAN_CD.TRES_NAMF)


treasurer_lastname   String (up to %(max_length)s)

Last name of the lender committee's treasurer (from LOAN_CD.TRES_NAML)


treasurer_name_suffix   String (up to %(max_length)s)

Name suffix of the lender committee's treasurer (from LOAN_CD.TRES_NAMS)


treasurer_state   String (up to %(max_length)s)

State of the lender committee's treasurer (from LOAN_CD.TRES_ST)


treasurer_title   String (up to %(max_length)s)

Name title of the lender committee's treasurer (from LOAN_CD.TRES_NAMT)


treasurer_zip   String (up to %(max_length)s)

Zip code (usually zip5, sometimes zip9) of the lender committee's treasurer (from LOAN_CD.TRES_ZIP4)