125
edits
Changes
Jump to navigation
Jump to search
Winner's Curse in Acquisitions (Academic Paper) (view source)
Revision as of 19:34, 15 November 2016
, 19:34, 15 November 2016→Governance_Final Table (Amir)
otherwise see the following file:
E:\McNair\Projects\Winner's Curse\Data\SQL\GOVERNANCE_NOTES.txt
or here:
BLANKCHECK NuLL/YES/NO
CARVE_OUT NULL/YES/NO
CBOARD NULL/YES/NO
CONAME
CONFVOTE NULL/YES/NO
CUMVOTE NULL/YES/NO
CUSIP
DUALCLASS NULL/YES/NO
FAIRPRICE NULL/YES/NO
GPARACHUTE NULL/YES/NO
LABYLW NULL/YES/NO
LACHTR NULL/YES/NO
LEGACYPPS_ID NO ENTRY ---> DROPPED
LSPMT NULL/YES/NO
LWCNST NULL/YES/NO/UNANIMOUS= 2
MAJ_VOTE_REQUIRED NULL/CAST=1/OUTSTANDING=2
MAJ_VOTE_REQUIREMENT NULL/NO=0/BY-LAWS=1/POLICY=2/CHARTER=3
MAJOR_VOTE_COMM USELESS ---> DROP
PPILL NULL/YES/NO
RESIGN_REQUIRE NULL/NO=0/ POLICY=1/ BYLAWS-CHARTER=2
SIC varchar(4)
TICKER varchar(5)
TIER DROPthis
UNEQVOTE NULL =0, ELSE =1 DEPOSITORY R/TIME-PHASED/GOLDEN SHARES/FIXED VOTING RI/GOLDEN SHARE/PRIORITY SHA/PRIORITY SHARES/FIXED VOTING/YES/TIME-PHASED VOT/DEPOSITORY RECE
OO_BUSCOMP NULL/YES/NO
OO_CASHOUT_PA NULL/YES/NO
OO_CSA NULL/YES/NO
OO_DUTIES NULL/YES/NO
OO_FAIRPRICE NULL/YES/NO
OO_PP NULL/YES/NO
OO_RPROFITS NULL/YES/NO
OO_STAKEHOLDER NULL/YES/NO
YEAR int
RT_ID int
MEETINGDATE date
COMPANY_ID int
STATE LEAVE AS VARCHAR
CHARTER_AMEND_VOTEPCNT real
FYEND int
LAW_AMEND_VOTEPCNT real
MTGMONTH int
PRICE real
SPINDEX LEAVE AS VARCHAR
SPL_MEET_VOTEPCNT real
SUPERMAJOR_PCNT real
WRITTEN_CONSENT_VOTEPCNT real
Merging with CRSP:
