...
METADATA Table Specification | ||
---|---|---|
Field Name | Data Type | Description |
DP | Text nvarchar(6200) | Data partner identifier. |
ETL | Numbersmallint | 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. |