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.