Changes

Jump to navigation Jump to search
515 bytes removed ,  12:26, 22 September 2019
The old files from [[VentureXpert Database]] are in the subfolder '''Student Work''', and their latest work is in '''Updated'''.
We need the following a set of pulls (according to E:\projects\vcdb3\OriginalSQL\LoadingScriptsV1.sql):*Roundbase: USVC1980-2018q2-Good.txt *IPOs: IPO1980-2018q2-NoFoot-normal.txt*Branchoffices: USVCFirmBranchOffices1980-2018q2-NoFoot-normal.txt*Roundline: USVCRound1980-2018q2-NoFoot-normal-normal.txt *FundBase: USVCFund1980-2018q2-NoFoot-normal.txt *CompanyBase: USPortCo1980-2018q2-NoFoot-normal.txt*MAs: MAUSTargetComp100pc1985-July2018-normal.txt*FirmBase: USVCFirms1980-2018q2-NoFoot-Normal.txt*LongDesc: PortCoLongDesc-Ready-normal-fixed.txt*CoPeople: Executives-NoFoot-normal.txt*FundPeople: Executives-Funds-NoFoot-normal.txt As , which are documented below, as well as some lookup tables (CPI may need updating) and some joined tables (which would have to be updated separately) in MatchingEntrepsV3.sql:
*PortCoSBIR: PortCoSBIR.txt
*PortCoPatent: PortCoPatent.txt

Navigation menu