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