Data Characterization: Metadata Table
The Metadata table provides dates representing the earliest and latest dates of complete data availability, stratified by table minimum and maximum and data partner. The Metadata table contains one record per data partner.
METADATA Table Specification | ||
---|---|---|
Field Name | Data Type | Description |
DP | nvarchar(200) | Data partner identifier. |
ETL | smallint | Data refresh identifier; number represents the number of data refreshes completed by the data partner. Most current ETL is included in the database. |
DIA_MIN | Date/Time | Earliest available complete data in the MSDD Diagnosis table. |
DIA_MAX | Date/Time | Latest available complete data in the MSDD Diagnosis table. |
DIS_MIN | Date/Time | Earliest available complete data in the MSDD Dispensing table. |
DIS_MAX | Date/Time | Latest available complete data in the MSDD Dispensing table. |
ENC_MIN | Date/Time | Earliest available complete data in the MSDD Encounter table. |
ENC_MAX | Date/Time | Latest available complete data in the MSDD Encounter table. |
ENR_MIN | Date/Time | Earliest available complete data in the MSDD Enrollment table. |
ENR_MAX | Date/Time | Latest available complete data in the MSDD Enrollment table. |
PRO_MIN | Date/Time | Earliest available complete data in the MSDD Procedure table. |
PRO_MAX | Date/Time | Latest available complete data in the MSDD Procedure table. |
DP_MIN | Date/Time | Earliest available complete data in the data partner’s MSDD database. |
DP_MAX | Date/Time | Latest available complete data in the data partner’s MSDD database. |
MSDD_MIN | Date/Time | Earliest available complete data across all data partners’ MSDD databases. |
MSDD_MAX | Date/Time | Latest available complete data across all data partners’ MSDD databases. |