Schedule A column documentation

This is a plain language explanation of what each column of the schedule A table represents. Originally posted here

Schedule A column names	description
sa.cmte_id,	committee id
sa.cmte_nm,	committee name
sa.contbr_id,	contributor id
sa.contbr_nm,	contributor name
sa.contbr_nm_first,	contributor first name
sa.contbr_m_nm,	contributor middle name
sa.contbr_nm_last,	contributor last name
sa.contbr_prefix,	contributor name prefix
sa.contbr_suffix,	contributor name suffix
sa.contbr_st1,	contributor street 1
sa.contbr_st2,	contributor street 2
sa.contbr_city,	contributor city
sa.contbr_st,	contributor state
sa.contbr_zip,	contributor zip code
sa.entity_tp,	entity type
sa.entity_tp_desc,	entity type description
sa.contbr_employer,	contributor employer
sa.contbr_occupation,	contributor occupation
sa.election_tp,	election type
sa.fec_election_tp_desc,	fec election type description
sa.fec_election_yr,	fec election year
sa.election_tp_desc,	election type description
sa.contb_aggregate_ytd,	contribution aggregate year to date
sa.contb_receipt_dt,	contribution receipt date
sa.contb_receipt_amt,	contribution receipt amount
sa.receipt_tp,	receipt type
sa.receipt_tp_desc,	receipt type description
sa.receipt_desc,	receipt description
sa.memo_cd,	memo code
sa.memo_cd_desc,	memo code description
sa.memo_text,	memo text
sa.cand_id,	candidate id
sa.cand_nm,	candidate name
sa.cand_nm_first,	candidate first name
sa.cand_m_nm,	candidate middle name
sa.cand_nm_last,	candidate last name
sa.cand_prefix,	candidate name prefix
sa.cand_suffix,	candidate name suffix
sa.cand_office,	candidate office
sa.cand_office_desc,	candidate office description
sa.cand_office_st,	candidate office state
sa.cand_office_st_desc,	candidate office state description
sa.cand_office_district,	candidate office district
sa.conduit_cmte_id,	counduit committee id
sa.conduit_cmte_nm,	conduit committee name
sa.conduit_cmte_st1,	conduit committee street 1
sa.conduit_cmte_st2,	conduit committee street 2
sa.conduit_cmte_city,	conduit committee city
sa.conduit_cmte_st,	conduit committee state
sa.conduit_cmte_zip,	conduit committee zip code
sa.donor_cmte_nm,	donor committee name
sa.national_cmte_nonfed_acct,	national committee nonfederal account
sa.increased_limit,	increased limit
sa.amndt_ind as action_cd,	action code
sa.amndt_ind_desc as action_cd_desc,	action code description
(case when substr(sa.sub_id,1,1) = 4 then sa.tran_id else null end) as tran_id,	transaction id
(case when substr(sa.sub_id,1,1) = 4 then sa.back_ref_tran_id else null end) as back_ref_tran_id,	back reference transaction id
sa.back_ref_sched_nm,	schedule name
vs.form_tp_cd as filing_form,	filing form
sa.form_tp as schedule_type,	schedule type
sa.form_tp_desc as schedule_type_desc,	schedule type description
sa.line_num,	line number
sa.image_num,	image number
sa.file_num,	file number
sa.sub_id,	sub_id
sa.link_id,	link_id
sa.orig_sub_id	original sub_Id