Hi Jenn,

I think you've found all the documentation we have. You're right that this isn't well documented at the moment- we'll try to improve this in coming releases. Here's a brief overview of where data goes, by file in the specimen import archive:
labs.tsv: this data is loaded directly into the study.site table.
primary_types.tsv: this data is loaded directly into the study.specimenprimarytype table.
derivatives.tsv: this data is loaded directly into the study.specimenderivative table.
additives.tsv: this data is loaded directly into the study.additive table.

specimen.tsv is the most complex. All fields from this file go into the study.specimenevent table, which is accessed through the 'history' links in the vial view or directly via the specimenevent table in the schema browser. The subset of fields that should be constant across locations (such as vial ID, vial volume, etc.) are also inserted into the study.vial table. Fields that are not expected to be the same across location (freezer information, for example) are found only in specimenevent. Aggregating up one more level from study.vial, the study.specimen table (accessible via the 'grouped vials' links in 11.3 and later) summarizes the data by collection. This table contains all fields from study.vial that are expected to be the same across all vials from a given collection (such as subject ID, visit, type, and draw timestamp).

Note that study.vial and study.specimen also contain a number of calculated fields that are not found in the import data- these are used in a variety of places within the system.

Hopefully this overview is helpful- please let me know if you have questions about specific fields in the import process.

Thanks,
Britt