Form460ScheduleB2Item

Guarantees of loans and lines of credit received by campaign filers.

Fields

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

amount_guaranteed_this_period Decimal number

Amount guaranteed for the period covered by the filing (from LOAN_CD.LOAN_AMT1)

balance_outstanding_to_date Decimal number

Outstanding balance for which the guarantor is liable at the close of the reporting period (from LOAN_CD.LOAN_AMT2)

cumulative_ytd_amount Decimal number

Cumulative amount guaranteed during the calendar year covered by the statement (from LOAN_CD.LOAN_AMT3)

filing Foreign Key (type determined by related field)

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

guarantor_city String (up to %(max_length)s)

City of the guarantor (from LOAN_CD.LOAN_CITY)

guarantor_code String (up to %(max_length)s)

Code describing the guarantor (from LOAN_CD.ENTITY_CD)

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

guarantor_employer String (up to %(max_length)s)

Employer of the guarantor (from LOAN_CD.LOAN_EMP)

guarantor_firstname String (up to %(max_length)s)

First name of the guarantor (from LOAN_CD.LNDR_NAMF)

guarantor_is_self_employed Boolean (Either True or False)

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

guarantor_lastname String (up to %(max_length)s)

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

guarantor_name_suffix String (up to %(max_length)s)

Name suffix of the guarantor (from LOAN_CD.LNDR_NAMS)

guarantor_occupation String (up to %(max_length)s)

Occupation of the guarantor (from LOAN_CD.LOAN_OCC)

guarantor_state String (up to %(max_length)s)

State of the guarantor (from LOAN_CD.LOAN_ST)

guarantor_title String (up to %(max_length)s)

Name title of the guarantor (from LOAN_CD.LNDR_NAMT)

guarantor_zip String (up to %(max_length)s)

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

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)

lender_name String (up to %(max_length)s)

Name of the lender (from LOAN_CD.INTR_NAML)

line_item Integer

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

loan_date Date (without time)

Date of the loan or date the line of credit was established(from LOAN_CD.LOAN_DATE1)

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)

reported_on_b1 Boolean (Either True or False)

Indicates if the item was actually reported on Part 1 of Schedule B. Until 2001, campaign filers were required to report guarantors of loans or lines of credit on Part 1 of Schedule B.

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)