Check types on `audit` tables

[iangow]

• [x] - Mergers and Acquisitions (feed18_merger_acquisition)
• [x] - IPO (ipo): To be renamed feed19_ipo?
• [x] - Bankruptcy Notification (feed21_bankruptcy_notification)
• [x] - Comment Letter (commlett): To be renamed feed25_comment_letters?
• [x] - Comment Letter Conversations (feed26_comment_letter_conversati)
• [x] - Shareholder Activism (feed31_shareholder_activism)
• [x] - Form D (feed37_form_d)
• [x] - Form D Most Recent Report (feed38_form_d_most_recent_offeri)
• [x] - Comment Threading (feed40_comment_letter_threads)
• [x] - Transfer Agents (feed41_transfer_agents)

[iangow]

feed26_comment_letter_conversati:

• col_types = {'cl_con_id': 'integer', 'con_time_span': 'integer'}
• list columns: list_ref_ftp_fkey, list_form_dates, list_of_taxon, list_of_ciks, list_ppl_add_to, list_ppl_sent_letter, list_ppl_copied, list_cl_ftp_fkeys

[iangow]

feed40_comment_letter_threads:

• col_types = {'comment_response_key': 'integer', 'ques_cl_comment_fkey': 'integer', 'eventdate_aud_fkey': 'integer'}
• list columns: question_issue_key_list, question_issue_text_list, question_fasb_key_list, question_fasb_text_list, answer_issue_key_list, answer_issue_text_list, answer_fasb_key_list, answer_fasb_text_list

[iangow]

feed41_transfer_agents:

• drop="match: closest: prior:"

[iangow]

feed38_form_d_most_recent_offeri:

• col_types = {'over_100_issuers_flag': 'boolean', 'authorized_representative': 'boolean', 'gross_proceeds_use_est': 'boolean'. 'finders_fees_is_estimate': 'boolean', 'has_non_accredited_investors': 'boolean', 'is_business_com_tra': 'boolean'}

Check is_amendment on WRDS PostgreSQL.

[iangow]

feed37_form_d:

• col_types = {'file_accepted': 'timestamp'}