Table Detail Report
QMD_LH_QRDA_AGGREGATION
Column Section | Top of Page |
Table-level Detail
Description: | QMD_LH_QRDA_AGGREGATION |
Definition: | A table that stores the aggregated data for electronic hospital quality submissions that is leveraged by Quality Clearinghouse |
Table Type: | ACTIVITY |
Column Detail - QMD_LH_QRDA_AGGREGATION
Column Name | Type | Null? | Definition |
---|---|---|---|
ADMIT_DT_TM | DATETIME | Y | An identifier that denotes admit date time from the submissison tables |
CCN_NBR_TXT | VARCHAR(150) | Y | An identifier for the facilty number of a hospital for center of medicare and medicaid |
CODE | VARCHAR(100) | Y | An identifier that denotes code key from the submissison tables |
CODE_DISPLAY | VARCHAR(500) | Y | An identifier that denotes code display key from the submissison tables |
CODE_DISPLAY_NEG | VARCHAR(500) | Y | An identifier that denotes code display negate key from the submissison tables |
CODE_NEG | VARCHAR(100) | Y | An identifier that denotes code negate key from the submissison tables |
CODE_SDTC | VARCHAR(50) | Y | An identifier that denotes code sdtc key from the submissison tables |
CODE_SDTC_NEG | VARCHAR(50) | Y | An identifier that denotes code sdtc negate key from the submissison tables |
CODE_SYSTEM | VARCHAR(100) | Y | An identifier that denotes code system key from the submissison tables |
CODE_SYSTEM_NAME | VARCHAR(100) | Y | An identifier that denotes code system name key from the submissison tables |
CODE_SYSTEM_NAME_NEG | VARCHAR(50) | Y | An identifier that denotes code system name negate key from the submissison tables |
CODE_SYSTEM_NEG | VARCHAR(50) | Y | An identifier that denotes code system negate key from the submissison tables |
DISCHARGE_DT_TM | DATETIME | Y | An identifier that denotes discharge date time from the submissison tables |
ENCNTR_ID | DOUBLE | N | An identifier that denotes an encounter id from the submissison tables |
ENTRY_ID | DOUBLE | N | An identifier that denotes an entry id from the submissison tables |
ENTRY_TYPE | VARCHAR(50) | Y | An identifier that denotes an entry type from the submissison tables |
ERROR_IND | DOUBLE | Y | AN identiifier to denote if there is any errors found in submission tables |
FINANCIAL_NBR_TXT | VARCHAR(50) | Y | An identifier that denotes FIN number |
HCO_NBR | DOUBLE | Y | An identifier for the facilty number of a hospital for Joint commission |
HIGH_TIME | DATETIME | Y | An identifier that denotes high time from the submissison tables |
HIGH_TIME_EXTRA | DATETIME | Y | An identifier that denotes high time extra from the submissison tables |
HIGH_TIME_NEG | DATETIME | Y | An identifier that denotes high time negate from the submissison tables |
LOW_TIME | DATETIME | Y | An identifier that denotes low time from the submissison tables |
LOW_TIME_EXTRA | DATETIME | Y | An identifier that denotes low time extra from the submissison tables |
LOW_TIME_NEG | DATETIME | Y | An identifier that denotes low time negate from the submissison tables |
METRIC_ID | DOUBLE | N | An identifier that denotes an metric id from the submissison tables |
METRIC_TYPE | VARCHAR(50) | Y | An identifier that denotes an metric type from the submissison tables |
NEG_IND | DOUBLE | N | An identifier that denotes negate id from the submissison tables |
NICU_IND | DOUBLE | Y | An identifier that denotes NICU id from the submissison tables |
PARENT_ID2 | DOUBLE | N | An identifier that denotes an parent id from the submissison tables |
PARENT_NAME2 | VARCHAR(50) | Y | An identifier that denotes an parent name from the submissison tables |
PERSON_ID | DOUBLE | N | An identifier that denotes an person id from the submissison tables |
PERSON_NAME | VARCHAR(100) | Y | A column for person name |
PRINCIPAL_IND | DOUBLE | Y | An identifier that denotes principal indicator from the submissison tables |
RESULTS_UNITS | VARCHAR(50) | Y | An identifier that denotes result units value from the submissison tables |
RESULT_VALUE | VARCHAR(255) | Y | An identifier that denotes result value from the submissison tables |
ROUTE_CODE | VARCHAR(50) | Y | An identifier that denotes route code from the submissison tables |
TEMPLATE | VARCHAR(50) | Y | An identifier that denotes the QRDA template from the submissison tables |
UPDT_DT_TM | DATETIME | Y | The date and time of ETL record to be updated |
UPDT_TASK | VARCHAR(50) | Y | The person who updated the record |
QMD_QRDA_TABLES_META
Column Section | Top of Page |
Table-level Detail
Description: | QMD_QRDA_TABLES_META |
Definition: | A meta table that stores electronic hospital quality submisison information that is leveraged by the Qualiyt Clearinghouse |
Table Type: | ACTIVITY |
Column Detail - QMD_QRDA_TABLES_META
Column Name | Type | Null? | Definition |
---|---|---|---|
CODE_DISPLAY_KEY | VARCHAR(30) | Y | A column that serves as an identifier for a code display from the submission tables |
CODE_DISPLAY_NEG_KEY | VARCHAR(30) | Y | A column that serves as an identifier for a code display negator from the submission tables |
CODE_KEY | VARCHAR(30) | Y | A column that serves as an identifier for a code from the submission tables |
CODE_NEG_KEY | VARCHAR(30) | Y | A column that serves as an identifier for a code negator from the submission tables |
CODE_SDTC_KEY | VARCHAR(30) | Y | A column that serves as an identifier for a code sdtc from the submission tables |
CODE_SDTC_NEG_KEY | VARCHAR(30) | Y | A column that serves as an identifier for a code sdtc negator from the submission tables |
CODE_SYSTEM_KEY | VARCHAR(30) | Y | A column that serves as an identifier for a code system negator from the submission tables |
CODE_SYSTEM_NAME_KEY | VARCHAR(30) | Y | A column that serves as an identifier for a code system name from the submission tables |
CODE_SYSTEM_NAME_NEG_KEY | VARCHAR(30) | Y | A column that serves as an identifier for a code system name negator from the submission tables |
CODE_SYSTEM_NEG_KEY | VARCHAR(30) | Y | A column that serves as an identifier for a code system negator from the submission tables |
DISCHARGE_DT_TM_KEY | VARCHAR(30) | Y | A column that serves as an identifier for the discharge data time from the submission tables |
ENCNTR_ID_KEY | VARCHAR(30) | Y | A column that serves as an identifier for an encounter id from the submission tables |
ENTRY_ID_KEY | VARCHAR(30) | Y | A column that serves as an identifier for an entry id from the submission tables |
ENTRY_TYPE | VARCHAR(30) | Y | A column that serves as an identifier for an entry type from the submission tables |
HIGH_TIME_EXTRA_KEY | VARCHAR(30) | Y | A column that serves as an identifier for a hihg time extra indicator from the submission tables |
HIGH_TIME_KEY | VARCHAR(30) | Y | A column that serves as an identifier for a high time indicator from the submission tables |
HIGH_TIME_NEG_KEY | VARCHAR(30) | Y | A column that serves as an identifier for a high time negator indicator from the submission tables |
LOW_TIME_EXTRA_KEY | VARCHAR(30) | Y | A column that serves as an identifier for a low time extra indicator from the submission tables |
LOW_TIME_KEY | VARCHAR(30) | Y | A column that serves as an identifier for a low time key indicator from the submission tables |
LOW_TIME_NEG_KEY | VARCHAR(30) | Y | A column that serves as an identifier for a low time negator indicator from the submission tables |
METRIC_ID_KEY | VARCHAR(30) | Y | A column that serves as an identifier for the metric key from the submission tables |
METRIC_TYPE | VARCHAR(30) | Y | A column that serves as an identifier for the metric type from the submission tables |
NEG_IND_KEY | VARCHAR(30) | Y | A column that serves as an identifier for a negator indicator from the submission tables |
NICU_IND_KEY | VARCHAR(30) | Y | A column that serves as an identifier for a NICU indicator from the submission tables |
PARENT_ID2_KEY | VARCHAR(30) | Y | A column that serves as an identifier for the parent id from the submission tables |
PARENT_NAME2_KEY | VARCHAR(30) | Y | A column that serves as an identifier for the parent id name from the submission tables |
PERSON_ID_KEY | VARCHAR(30) | Y | A column that serves as an identifier for the person id from the submission tables |
PRINCIPAL_IND_KEY | VARCHAR(30) | Y | A column that serves as an identifier for a principal indicator from the submission tables |
RESULTS_UNITS_KEY | VARCHAR(30) | Y | A column that serves as an identifier for a result units from the submission tables |
RESULT_VALUE_KEY | VARCHAR(30) | Y | A column that serves as an identifier for a result value from the submission tables |
ROUTE_CODE_KEY | VARCHAR(30) | Y | A column that serves as an identifier for a route code indicator from the submission tables |
TABLE_NAME | VARCHAR(30) | Y | A column that identifies the table name for different submission measures |
TEMPLATE | VARCHAR(30) | Y | A column that serves as an identifier for a qrda template from the submission tables |
WH_BR_CCN_EXTENSION
Column Section | Top of Page |
Table-level Detail
Description: | WH_BR_CCN_EXTENSION |
Definition: | This table contains attributes of a CCN that require history to be kept. |
Table Type: | ACTIVITY |
Column Detail - WH_BR_CCN_EXTENSION
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
BR_CCN_EXTENSION_ID | DOUBLE | N | Unique generated number that identifies a single row on the BR_CCN_EXTENSION table. |
BR_CCN_ID | DOUBLE | N | Identifies the CCN that is the main source for the data on this table. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
EXTRACT_DT_TM | DATETIME | Y | The date and time for which extracts were run. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time that the first ETL process started that created this record. |
HEALTH_SYSTEM_ID | DOUBLE | N | The unique identifier that identifies a client health system id |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | The unique identifier that identifies a client health system source id |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
MEDICAID_STAGE_CD | DOUBLE | N | Stores the stage and year for the Medicaid program enrollment |
MEDICARE_YEAR | DOUBLE | Y | The effective year for the Medicare program associated to this CCN |
ORIG_BR_CCN_EXTENSION_ID | DOUBLE | N | The PK value of the Original (Effective) Row for this versioned set |
PROGRAM_TYPE_TXT | VARCHAR(50) | Y | Identifies what type of program this CCN is associated to. |
SRC_UPDT_DT_TM | DATETIME | Y | The date and time for which records have been updated on the source side |
UPDT_APPLCTX | DOUBLE | Y | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_CNT | DOUBLE | Y | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | VARCHAR(40) | Y | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_USER | VARCHAR(40) | Y | The user that performs the insert or update to the record |
WH_BR_CCN_LOC_PTSVC_RELTN
Column Section | Top of Page |
Table-level Detail
Description: | WH_BR_CCN_LOC_PTSVC_RELTN |
Definition: | This table stores point of service information associated to locations that are associated to CCNs. |
Table Type: | ACTIVITY |
Column Detail - WH_BR_CCN_LOC_PTSVC_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
BR_CCN_LOC_PTSVC_RELTN_ID | DOUBLE | N | Unique, generated number that identifies a single row on the BR_CCN_LOC_PTSVC_RELTN table. |
BR_CCN_LOC_RELTN_ID | DOUBLE | N | The location and CCN that this Point of service code and Encounter Type pertain to. |
ENCNTR_TYPE_CD | DOUBLE | N | Stores the encounter associated encounter type. The combination of point of service, encounter type, and location drive how the data is submitted to CMS. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
EXTRACT_DT_TM | DATETIME | Y | The date and time when ETL extract was run |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time that the first ETL process started that created this record. |
HEALTH_SYSTEM_ID | DOUBLE | N | The systen id generated for the health system |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | The systen id generated for the health system source |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
ORIG_BR_CCN_LOC_PTSVC_R_ID | DOUBLE | N | Used for versioning. Contains the original PK from BR_CCN_LOC_PTSVC_RELTN |
PTSVC_CODE_NBR | DOUBLE | Y | Stores the point of service code used on professional claims to specify the entity where service(s) were rendered. |
UPDT_APPLCTX | DOUBLE | Y | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_CNT | DOUBLE | Y | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | VARCHAR(40) | Y | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
WH_BR_CCN_LOC_RELTN
Column Section | Top of Page |
Table-level Detail
Description: | WH_BR_CCN_LOC_RELTN |
Definition: | This table Stores locations associated to a CMS Certification Number. |
Table Type: | ACTIVITY |
Column Detail - WH_BR_CCN_LOC_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
BR_CCN_ID | DOUBLE | N | Identifies the CCN that is associated to this location |
BR_CCN_LOC_RELTN_ID | DOUBLE | N | Unique, generated number that identifies a single row on the BR_CCN_LOC_RELTN table. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
EXTRACT_DT_TM | DATETIME | Y | The date and time when ETL extract was run |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time that the first ETL process started that created this record. |
HEALTH_SYSTEM_ID | DOUBLE | N | The id that identifies health system |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | The id that identifies health system source |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LOCATION_CD | DOUBLE | N | The location associated to this CMS Certification Number. |
ORIG_BR_CCN_LOC_RELTN_ID | DOUBLE | N | Used for versioning. Contains the original PK value for BR_CCN_LOC_RELTN. |
UPDT_CNT | DOUBLE | Y | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | VARCHAR(50) | Y | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |