7,612
edits
Changes
Jump to navigation
Jump to search
no edit summary
*100pc owned after the acquisition (eliminated, see below)
Note that the MA pull from 1985 of the basics only fails. Delete the script and move on! The other pull adds data to an older pull. I redid the M&A queries, pulling more info from 1980 to 2020H1 in four goes. This removed the 100pc owned constraint from the search. It can be added back later. I also included completed vs. withdrawn, pc cash and stock, and some other useful measures. The four pulls were normalized and then combined to create: USMAPrivate80-20H1-normal.txt
We might want to take a look at what NOT venture related deals might yield...
*Copy to USVCPortCoLongDesc1980Cleaned.txt and make any manual fixes necessary to load
Do some clean up:
*Remove quotes from fund, fund execs and description field of portco.
Issue:
*It appears that Thomson-Reuters have drastically redefined their 'venture related' flag, as about 25% of the data appears missing now.
==Dbase==
Check the filespace on the dbserver (see [[Posgres Server Configuration]]): The /data mount is at 23% (845 1K blocks free) and vcdb4 used 37Gb, so we are all good.
Create the new dbase '''vcdb20h1''' as researcher. Copy Then copy over Load.sql and update it.
In addition to the processed SDC requests, copy over the following filesto mother (/bulk/vcdb20h1):
*StateLookup.txt
