Table Detail Report
DIAGNOSIS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Diagnosis |
Definition: | The diagnoses table stores medical diagnosis information for a patient encounter. This information describes symptoms the patient was experiencing at the time of the encounter. |
Table Type: | ACTIVITY |
Column Detail - DIAGNOSIS
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. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | Y | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
ASSERTED_DT_CD | DOUBLE | Y | Indicate to what level of accuracy the ASSERTED_CYCLE_DT_TM has been set (from code set 25320) |
ASSERTED_DT_FLAG | DOUBLE | Y | Indicates to what precision (Day, Month, Year, Week ) of the ASSERTED_CYCLE_DT_TM has been set |
ASSERTED_DT_TM | DATETIME | Y | The asserted date refers to the date when a patient or their caregiver reported or asserted the presence of a condition(Diagnosis) or problem; |
ASSERTED_TZ | DOUBLE | Y | Time zone associated with the ASSERTED_CYCLE_DT_TM column |
ATTESTATION_DT_TM | DATETIME | Y | The date by when the diagnosis was attested. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | 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. |
CERTAINTY_CD | DOUBLE | N | Description of the certainty level of the clinical diagnosis to be valid. |
CLASSIFICATION_CD | DOUBLE | N | Classification of the clinical diagnosis by the area of focus. |
CLINICAL_DIAG_PRIORITY | DOUBLE | Y | The priority of the diagnosis. |
CLINICAL_SERVICE_CD | DOUBLE | N | Associates the clinical diagnosis to a particular setting of care within an encounter. |
CONDITIONAL_QUAL_CD | DOUBLE | N | Supports the ability to further describe the clinical diagnosis by a qualifier that provides context information. |
CONFID_LEVEL_CD | DOUBLE | N | Indicates the confidentiality of the diagnosis data. |
CONFIRMATION_STATUS_CD | DOUBLE | N | Describes the definitiveness and clinical status of the diagnosis. |
CONTRIBUTOR_SYSTEM_CD | DOUBLE | N | Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
DIAGNOSIS_DISPLAY | VARCHAR(255) | Y | A denormalized, and possibly annotated description of the clinical diagnosis. This will default from the description of the chosen codified diagnosis code, and can be annotated (extended) by the clinician. This will be the column used when displaying this clinical diagnosis back to the user. |
DIAGNOSIS_GROUP | DOUBLE | N | The unique identifier for the clinical diagnosis. The diagnosis_group can be associated with multiple diagnosis instances. When a new diagnosis is added to the diagnosis table the diagnosis group is assigned to the diagnosis_id |
DIAGNOSIS_ID | DOUBLE | N | The primary key for the Diagnosis table. |
DIAGNOSTIC_CATEGORY_CD | DOUBLE | N | The category to which the diagnosis is assigned. |
DIAG_CLASS_CD | DOUBLE | N | The class to which the diagnosis is assigned. |
DIAG_DT_TM | DATETIME | Y | Date/time for which the Diagnosis was saved |
DIAG_FTDESC | VARCHAR(255) | Y | A free text diagnosis description. |
DIAG_NOTE | VARCHAR(255) | Y | Additional diagnosis information that may be added by user |
DIAG_PRIORITY | DOUBLE | Y | Priority of diagnoses as determined by application. |
DIAG_PRSNL_ID | DOUBLE | N | Prsnl_id of person that added the diagnosis. |
DIAG_PRSNL_NAME | VARCHAR(100) | Y | The name of the person that added the diagnosis. |
DIAG_TYPE_CD | DOUBLE | N | The type of diagnosis. |
ENCNTR_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
ENCNTR_SLICE_ID | DOUBLE | N | Identifies an Encounter as it relates to a time slice. |
END_EFFECTIVE_DT_TM | DATETIME | N | 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. |
HAC_IND | DOUBLE | N | Indicates whether the diagnosis was a hospital acquired condition and contributed to a change in the grouper that likely resulted in a lower reimbursement. |
LATERALITY_CD | DOUBLE | N | Identifies the code value associated with the laterality of the clinical diagnosis. Code set 4002375. |
LIFE_CYCLE_DT_CD | DOUBLE | Y | Indicate to what level of accuracy the LIFE_CYCLE_DT_TM has been set; |
LIFE_CYCLE_DT_FLAG | DOUBLE | Y | Indicates to what precision (Day, Month, Year, Week Of) the LIFE_CYCLE_DT_TM has been set. |
LIFE_CYCLE_DT_TM | DATETIME | Y | The effective date and time of the condition's clinical status (life_cycle_status_cd) |
LIFE_CYCLE_STATUS_CD | DOUBLE | Y | The current status of the Diagnosis. - from code set 12030 |
LIFE_CYCLE_TZ | DOUBLE | Y | Time zone associated with the LIFE_CYCLE_DT_TM column |
LONG_BLOB_ID | DOUBLE | N | If there are additional free text comments associated with the clinical diagnosis, this will contain the pointer to those comments on the long_blob table. |
MOD_NOMENCLATURE_ID | DOUBLE | N | Contains the nomenclature ID from the nomenclature table for the nomenclature modifier. |
NOMENCLATURE_ID | DOUBLE | N | This is the value of the unique primary identifier of the nomenclature table. It is an internal system assigned number. |
ORIGINATING_NOMENCLATURE_ID | DOUBLE | N | The originating nomenclature id of the diagnosis. This is used to record the source nomenclature id of the diagnosis. |
PAC_CD | DOUBLE | Y | Indicates the post acute care coding value assigned to the diagnosis. |
PARENT_ENTITY_ID | DOUBLE | N | Primary key ID from the parent table. |
PARENT_ENTITY_NAME | VARCHAR(30) | N | Parent table name. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
PRESENT_ON_ADMIT_CD | DOUBLE | N | Describes whether diagnosis is present on admission. |
PROBABILITY | DOUBLE | Y | Numeric percentage to reflect probability of validity of clinical diagnosis. |
RANKING_CD | DOUBLE | N | Codified ranking description. |
REFERENCE_NBR | VARCHAR(100) | Y | The combination of the reference nbr and the contributor system code provides a unique identifier to the origin of the data. |
SEG_UNIQUE_KEY | VARCHAR(100) | Y | This field contains a unique identifier for one of the multiple repetitions of the HL7 segment. |
SEVERITY_CD | DOUBLE | N | Codified severity of a condition identified by the clinical diagnosis |
SEVERITY_CLASS_CD | DOUBLE | N | Severity classification system by which the severity code is based on. |
SEVERITY_FTDESC | VARCHAR(40) | Y | Free text severity of a condition identified by clinical diagnosis |
SVC_CAT_HIST_ID | DOUBLE | N | This is the unique identifier for the service category history table. |
UPDT_APPLCTX | DOUBLE | N | 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 | N | 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 | N | 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 | DOUBLE | N | 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. |
Relationship Detail - DIAGNOSIS
Child Column in DIAGNOSIS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DIAGNOSIS_GROUP | DIAGNOSIS | DIAGNOSIS_ID |
ENCNTR_SLICE_ID | ENCNTR_SLICE | ENCNTR_SLICE_ID | |
ENCNTR_ID | ENCOUNTER | ENCNTR_ID | |
LONG_BLOB_ID | LONG_BLOB | LONG_BLOB_ID | |
MOD_NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID | |
NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID | |
ORIGINATING_NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID | |
PERSON_ID | PERSON | PERSON_ID | |
SVC_CAT_HIST_ID | SERVICE_CATEGORY_HIST | SVC_CAT_HIST_ID |
Parent Column in DIAGNOSIS (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DIAGNOSIS_ID | CLRFCTN_ACTION | DIAGNOSIS_ID |
DIAGNOSIS | DIAGNOSIS_GROUP | ||
DIAGNOSIS_ACTION | DIAGNOSIS_ID | ||
DIAGNOSIS_DETAIL | DIAGNOSIS_ID | ||
DIAGNOSIS_DIAGNOSIS_RELTN | CHILD_DIAGNOSIS_ID | ||
DIAGNOSIS_DIAGNOSIS_RELTN | PARENT_DIAGNOSIS_ID | ||
DIAGNOSIS_PROCEDURE_RELTN | CHILD_DIAGNOSIS_ID | ||
DIAGNOSIS_SEC_LBL | DIAGNOSIS_GROUP_ID | ||
ORDER_PROPOSAL_DIAG_RELTN | DIAGNOSIS_ID | ||
PM_WAIT_LIST_HIST | DIAGNOSIS_ID | ||
PROCEDURE_DIAGNOSIS_RELTN | PARENT_DIAGNOSIS_ID | ||
SCD_STORY_CONCEPT | DIAGNOSIS_GROUP_ID | ||
VISITCODING_DX | DIAGNOSIS_ID |
DIAGNOSIS_DETAIL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Diagnosis Detail |
Definition: | Stores detail information about Hospital Acquired Conditions for diagnosis. |
Table Type: | ACTIVITY |
Column Detail - DIAGNOSIS_DETAIL
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | 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 | N | 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. |
DIAGNOSIS_DETAIL_ID | DOUBLE | N | Unique generated number that identifies a single row on the Diagnosis_Detail table. |
DIAGNOSIS_ID | DOUBLE | N | The Diagnosis ID this detail row is related to. |
END_EFFECTIVE_DT_TM | DATETIME | N | 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. |
HAC_COMPLICATION1_CD | DOUBLE | N | First Hospital Acquired Condition complication associated to the diagnosis. |
HAC_COMPLICATION2_CD | DOUBLE | N | Second Hospital Acquired Condition complication associated to the diagnosis. |
UPDT_APPLCTX | DOUBLE | N | 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 | N | 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 | N | 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 | DOUBLE | N | 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. |
Relationship Detail - DIAGNOSIS_DETAIL
Child Column in DIAGNOSIS_DETAIL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DIAGNOSIS_ID | DIAGNOSIS | DIAGNOSIS_ID |
DIAGNOSIS_DIAGNOSIS_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Diagnosis Diagnosis Relation |
Definition: | Relates Millennium concept Diagnosis to a Diagnosis |
Table Type: | ACTIVITY |
Column Detail - DIAGNOSIS_DIAGNOSIS_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | 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 | N | 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. |
CHILD_DIAGNOSIS_ID | DOUBLE | N | Forgein key, Unique generated number that identifies a single row on the DIAGNOSIS table [Primary key id from the DIAGNOSIS table] |
DIAGNOSIS_DIAGNOSIS_RELTN_ID | DOUBLE | N | Unique generated number that identifies a single row on the DIAGNOSIS_DIAGNOSIS_RELTN table. |
END_EFFECTIVE_DT_TM | DATETIME | N | 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. |
PARENT_DIAGNOSIS_ID | DOUBLE | N | Forgein key, Unique generated number that identifies a single row on the DIAGNOSIS table |
UPDT_APPLCTX | DOUBLE | N | 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 | N | 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 | N | 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 | DOUBLE | N | 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. |
Relationship Detail - DIAGNOSIS_DIAGNOSIS_RELTN
Child Column in DIAGNOSIS_DIAGNOSIS_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CHILD_DIAGNOSIS_ID | DIAGNOSIS | DIAGNOSIS_ID |
PARENT_DIAGNOSIS_ID | DIAGNOSIS | DIAGNOSIS_ID |
DIAGNOSIS_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Diagnosis History |
Definition: | Used to store history of diagnoses in Chart Coding |
Table Type: | ACTIVITY |
Column Detail - DIAGNOSIS_HIST
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | 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. |
CONTRIBUTOR_SYSTEM_CD | DOUBLE | N | Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
DIAGNOSIS_HIST_ID | DOUBLE | N | This is the unique identifier for a diagnosis history row. It is an internal, system-assigned number. |
DIAGNOSIS_ID | DOUBLE | N | This is the unique identifier for the diagnosis. It is an internal, system-assigned number. |
DIAG_DT_TM | DATETIME | Y | Date/time when the diagnosis was made. |
DIAG_PRIORITY | DOUBLE | N | The priority of the diagnosis. |
DIAG_TYPE_CD | DOUBLE | N | The type of diagnosis (final, admitting, reason for visit, etc¿) |
ENCNTR_ID | DOUBLE | N | This is the value of the unique identifier of the encounter table. It is an internal, system-assigned number |
ENCNTR_SLICE_ID | DOUBLE | N | Identifies an Encounter as it relates to a time slice. |
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. |
HAC_IND | DOUBLE | N | Indicates that the diagnosis was a Hospital Acquired Condition (HAC) and contributed to a change in the grouper that likely resulted in a lower reimbursement. |
NOMENCLATURE_ID | DOUBLE | N | This is the value of the primary identifier of the nomenclature table. It is an internal, system-assigned number. |
PAC_CD | DOUBLE | Y | Indicates the post acute care coding value assigned to the diagnosis. |
PARENT_ENTITY_ID | DOUBLE | N | Primary key ID from the parent table. |
PARENT_ENTITY_NAME | VARCHAR(30) | N | Parent table name. |
PERSON_ID | DOUBLE | N | This is the value of the primary identifier of the person table. It is an internal, system-assigned number |
PRESENT_ON_ADMIT_CD | DOUBLE | N | Identifies whether the diagnosis was present on admission. |
SVC_CAT_HIST_ID | DOUBLE | N | This field is a unique identifier for the service category history table. |
UPDT_APPLCTX | DOUBLE | N | 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 | N | 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 | N | 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 | DOUBLE | N | 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. |
Relationship Detail - DIAGNOSIS_HIST
Child Column in DIAGNOSIS_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_SLICE_ID | ENCNTR_SLICE | ENCNTR_SLICE_ID |
ENCNTR_ID | ENCOUNTER | ENCNTR_ID | |
NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID | |
PERSON_ID | PERSON | PERSON_ID | |
SVC_CAT_HIST_ID | SERVICE_CATEGORY_HIST | SVC_CAT_HIST_ID |
DIAGNOSIS_PROCEDURE_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Diagnosis Procedure Relation |
Definition: | Relates Millennium concept Diagnosis to a Procedure |
Table Type: | ACTIVITY |
Column Detail - DIAGNOSIS_PROCEDURE_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | 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 | N | 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. |
CHILD_DIAGNOSIS_ID | DOUBLE | Y | Foreign key, Unique generated number that identifies a single row on the DIAGNOSIS table [Primary key id from the DIAGNOSIS table]. |
DIAGNOSIS_PROCEDURE_RELTN_ID | DOUBLE | N | Unique generated number that identifies a single row on the DIAGNOSIS_PROCEDURE_RELTN table. |
END_EFFECTIVE_DT_TM | DATETIME | N | 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. |
PARENT_PROCEDURE_ID | DOUBLE | Y | Foreign key, Unique generated number that identifies a single row on the PROCEDURE table [Primary key id from the PROCEDURE table]. |
UPDT_APPLCTX | DOUBLE | N | 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 | N | 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 | N | 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 | DOUBLE | N | 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. |
Relationship Detail - DIAGNOSIS_PROCEDURE_RELTN
Child Column in DIAGNOSIS_PROCEDURE_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CHILD_DIAGNOSIS_ID | DIAGNOSIS | DIAGNOSIS_ID |
PARENT_PROCEDURE_ID | PROCEDURE | PROCEDURE_ID |