microbiomedata / metadata-template-transformation

ETL between NMDC submission portal study records and user facility templates
0 stars 0 forks source link

Does Month need to be written out? Is the digit ok? #17

Closed mslarae13 closed 1 year ago

mslarae13 commented 1 year ago

The JGI template captures collection month spelled out. In the JGI template an enumeration of the 12 months spelled out is provided. NMDC collection_date collects month as MM digits.

@aclum , @emileyfadrosh : can you inform, how does JGI use this / store this? Do we need to convert the month digit to be spelled out when we export the JGI template?

aclum commented 1 year ago

This is stored as is in the project management system, there are web links that pull up the original submission based on a sample id. In other places, for example the data warehouse postgres database the information is converted into a timestamp (schema dw, table samples column collection_time) example of internal web view of metadata submission Screenshot 2023-05-31 at 10 24 12 AM

For now we should export this in the current JGI format, otherwise the JGI metadata forms won't be consistent.

mslarae13 commented 1 year ago

thank you! https://github.com/microbiomedata/metadata-template-transformation/issues/28