7,649
edits
Changes
Jump to navigation
Jump to search
→Source Files
The build should be done as quickly but cleanly as possible, as it is needed right away but also will likely need to be updated in January of 2020 to reflect 2019's year end.
==Loading the data==
First, create a dbase:
createdb vcdb4
Then load the data, running Load.sql
The following were nuances of this process:
*Replace all double quotes with nothing in PortCo, Fund
*Renormalize firm by fixing the header -- the Capital Under Mgmt field was too close to the next field -- and remove two bad area codes (lines 931 and 11298).
==SDC Platinum Requests==
