Form460ScheduleHItemVersion

Every version of each loan made by a campaign filer another recipient.

Fields

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

amount_forgiven   Decimal number

Amount forgiven by the campaign filer during the period covered by the filing (from LOAN_CD.LOAN_AMT6)

amount_loaned   Decimal number

Amount loaned during the period covered by the filing (from LOAN_CD.LOAN_AMT1)

amount_paid   Decimal number

Amount paid back during the period covered by the filing (from LOAN_CD.LOAN_AMT5)

begin_period_balance   Decimal number

Outstanding balance of the loan at the beginning of theperiod covered by the filing (from LOAN_CD.LOAN_AMT4)

cumulative_ytd_contributions   Decimal number

Cumulative amount of contributions (loans, monetary and nonmonetary contributions) from the campaign filer to the recipient during the calendar year covered by this statement (from LOAN_CD.LOAN_AMT3)

date_due   Date (without time)

Date that the loan is due (from LOAN_CD.LOAN_DATE2)

date_incurred   Date (without time)

Date the loan was made or received (from LOAN_CD.LOAN_DATE1)

end_period_balance   Decimal number

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

filing_version   Foreign Key (type determined by related field)

Foreign key referring to the version of the Form 460 that includes the outstanding loan

id   Integer

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)

interest_received   Decimal number

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

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)

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)

original_amount   Decimal number

Original amount loaned by the lender to the campaign filer (from LOAN_CD.LOAN_AMT8)

recipient_city   String (up to %(max_length)s)

City of the recipient (from LOAN_CD.LOAN_CITY)

recipient_code   String (up to %(max_length)s)

Code describing the recipient (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
recipient_committee_id   String (up to %(max_length)s)

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

recipient_employer   String (up to %(max_length)s)

Employer of the recipient (from LOAN_CD.LOAN_EMP)

recipient_firstname   String (up to %(max_length)s)

First name of the recipient (from LOAN_CD.LNDR_NAMF)

recipient_is_self_employed   Boolean (Either True or False)

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

recipient_lastname   String (up to %(max_length)s)

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

recipient_name_suffix   String (up to %(max_length)s)

Name suffix of the recipient (from LOAN_CD.LNDR_NAMS)

recipient_occupation   String (up to %(max_length)s)

Occupation of the recipient (from LOAN_CD.LOAN_OCC). Note that, in some cases, the value seems to actually be the recipient's committee ID.

recipient_state   String (up to %(max_length)s)

State of the recipient (from LOAN_CD.LOAN_ST)

recipient_title   String (up to %(max_length)s)

Name title of the recipient (from LOAN_CD.LNDR_NAMT)

recipient_zip   String (up to %(max_length)s)

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

reported_on_h1   Boolean (Either True or False)

Indicates if the item was actually reported on Part 1 of Schedule H. Until 2001, campaign filers were required to report loans made to others on Part 1 of Schedule H, separate from repayments or forgiveness of those loans (Schedule H, Part 2)

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 recipient committee's treasurer (from LOAN_CD.TRES_CITY)

treasurer_firstname   String (up to %(max_length)s)

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

treasurer_lastname   String (up to %(max_length)s)

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

treasurer_name_suffix   String (up to %(max_length)s)

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

treasurer_state   String (up to %(max_length)s)

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

treasurer_title   String (up to %(max_length)s)

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

treasurer_zip   String (up to %(max_length)s)

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