Table Detail Report

PROCEDURE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Procedure Table
Definition: Stores the coded information for procedures from the patient's chart.
Table Type: ACTIVITY





Column Detail - PROCEDURE


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.
ANESTHESIA_CD DOUBLE N Anesthesia used for this procedure
ANESTHESIA_MINUTES DOUBLE Y The number of minutes the patient was under anesthesia
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.
CATEGORY_CD DOUBLE Y This column will be used to store the category of a procedure which will be pulled from category codeset 4760259 to differentiate SDOH or NON SDOH.
CLINICAL_SERVICE_CD DOUBLE N It associates a procedure to a particular setting of care within an encounter. The unifying clinical trait of the notion of a clinical service is that it correlates to the physician's fiduciary responsibility for the patient as manifested by a formal hand-off / acceptance of care process that involves a declaration of diagnostic information that corresponds to the clinical service as the transition points.
COMMENT_IND DOUBLE Y Indicator that a comment was added about the procedure
CONSENT_CD DOUBLE N HL7 segment PR1-13 added on-the-fly.Definition: This field contains the type of consent that was obtained for permission to treat the patient. NOTE: This column is currently not being used but it may be used in the future. The Code Set for it does not exist either.
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.
DGVP_IND DOUBLE N Indicator to determine whether or not a specific procedure was the Dominant Group variable Procedure for a given encounter or service category. 0 = not DVGP, 1 = DGVP
DIAG_NOMENCLATURE_ID DOUBLE N Foreign key to the Nomenclature table.
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.
GENERIC_VAL_CD DOUBLE N A code value that is the selected for the "Generic Field" in himChartCoding.
LATERALITY_CD DOUBLE N Identifies the code value associated with the laterality of the procedure. Code set 4002375
LONG_TEXT_ID DOUBLE N This is the unique identifier to the long text table.
MOD_NOMENCLATURE_ID DOUBLE N The nomenclature Id of the nomenclature row used as a modifier
NOMENCLATURE_ID DOUBLE N Foreign Key to the Nomenclature table.
ORGANIZATION_ID DOUBLE Y This is the value of the unique primary identifier of the Organization table. It is an internal system assigned number. The organization associated with this procedure.
PARENT_ENTITY_ID DOUBLE N Primary key ID from the parent table.
PARENT_ENTITY_NAME VARCHAR(30) N Parent table name.
PROCEDURE_ID DOUBLE N Procedure id is the primary unique identification number of the procedure table. It is an internal system assigned sequence number.
PROCEDURE_NOTE VARCHAR(255) Y Free-text note for an individual procedure
PROC_DT_TM DATETIME Y The date and time when the procedure was performed.
PROC_DT_TM_PREC_CD DOUBLE N Used to indicate the precision selected by the end user when entering the procedure date & time (Before, After, About, Unknown, etc.)
PROC_DT_TM_PREC_FLAG DOUBLE N Precision flag for date and time.0 - Date or Date and Time, 1- Week, 2 - Month, 3 - Year.
PROC_END_DT_TM DATETIME Y The data and time the procedure was ended.
PROC_FTDESC VARCHAR(255) Y The free text field for a procedure.
PROC_FT_DT_TM_IND DOUBLE Y This indicator is set when a free textdata and time is entered
PROC_FT_LOC VARCHAR(255) Y This is free textlocation of the procedure.
PROC_FT_TIME_FRAME VARCHAR(40) Y This is the free texttime frame for the procedure
PROC_FUNC_TYPE_CD DOUBLE N The type of procedure function. An example would be anesthesia.
PROC_LOC_CD DOUBLE N This is the code_value associated with the location of the procedure.
PROC_LOC_FT_IND DOUBLE Y This is used to indicate if the location is a free text value.
PROC_MINUTES DOUBLE Y The amount of time in minutes the procedure took to complete.
PROC_PRIORITY DOUBLE Y The priority of the procedure compared to other procedures in the same encounter.
PROC_START_DT_TM DATETIME Y The data and time the procedure was started.
PROC_TYPE_FLAG DOUBLE N Indicated to type of procedure. 0 - Unknown 1 - encounter Procedure 2 - narrated procedure
RANKING_CD DOUBLE N Codified ranking description. The available codes are Primary and Secondary.
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.
SUPPRESS_NARRATIVE_IND DOUBLE N Indicator used to hide items from the historic procedure view. By default all of the existing data qualifies for history display.
SVC_CAT_HIST_ID DOUBLE N The service category history Id, or unique identifier, from the service category history table. It is an internal system assigned number.
TISSUE_TYPE_CD DOUBLE N The code value for the tissue type. This is an optional field. An example would be moist or supple.
UNITS_OF_SERVICE DOUBLE Y A value representing the units of service for a procedure. (e.g. units of blood)
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 - PROCEDURE


Child Column in PROCEDURE(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_SLICE_ID ENCNTR_SLICE ENCNTR_SLICE_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
DIAG_NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
MOD_NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
SVC_CAT_HIST_ID SERVICE_CATEGORY_HIST SVC_CAT_HIST_ID




Parent Column in PROCEDURE (PK) Child Table Name Child Column Name
Children: PROCEDURE_ID DIAGNOSIS_PROCEDURE_RELTN PARENT_PROCEDURE_ID
PM_OFFER_PROC_RELTN PROCEDURE_ID
PM_WAIT_LIST_HIST PROCEDURE_ID
PROCEDURE_ACTION PROCEDURE_ID
PROCEDURE_DIAGNOSIS_RELTN CHILD_PROCEDURE_ID
PROCEDURE_EXT_DATA PROCEDURE_ID
PROCEDURE_HIST PROCEDURE_ID
PROCEDURE_ORDER_RELTN PROCEDURE_ID
PROCEDURE_PROCEDURE_RELTN CHILD_PROCEDURE_ID
PROCEDURE_PROCEDURE_RELTN PARENT_PROCEDURE_ID
PROC_PRSNL_RELTN PROCEDURE_ID


PROCEDURE_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: procedure action
Definition: Each row on the table represents an action (Create, Review, etc.) that a particular clinician performed on a procedure record.
Table Type: ACTIVITY





Column Detail - PROCEDURE_ACTION


Column Name Type Null? Definition
ACTION_DT_TM DATETIME N Action date & time
ACTION_TYPE_MEAN VARCHAR(12) N Indicates the type of action performed by clinician. In the initial release it will be REVIEW.
PROCEDURE_ACTION_ID DOUBLE N Sequence: REFERENCE_SEQ Unique key for the table.
PROCEDURE_ID DOUBLE N Unique identifier for a clinical PROCEDURE record from PROCEDURE table.
PRSNL_ID DOUBLE N Unique identifier for the clinician who performed a particular action on the PROCEDURE.
UPDATE_ENCNTR_ID DOUBLE N The value of the unique primary identifierof the encounter table. Represents the last encounter id on which the procedure was modified.
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 - PROCEDURE_ACTION


Child Column in PROCEDURE_ACTION(FK) Parent Table Name Parent Column Name
Parents: UPDATE_ENCNTR_ID ENCOUNTER ENCNTR_ID
PROCEDURE_ID PROCEDURE PROCEDURE_ID
PRSNL_ID PRSNL PERSON_ID


PROCEDURE_DIAGNOSIS_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: PROCEDURE_DIAGNOSIS_RELATION
Definition: Relates Millennium concept Procedure to a Diagnosis
Table Type: ACTIVITY





Column Detail - PROCEDURE_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_PROCEDURE_ID DOUBLE N Forgein key, Unique generated number that identifies a single row on the PROCEDURE table [Primary key id from the PROCEDURE 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
PROCEDURE_DIAGNOSIS_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the PROCEDURE_DIAGNOSIS_RELTN 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 - PROCEDURE_DIAGNOSIS_RELTN


Child Column in PROCEDURE_DIAGNOSIS_RELTN(FK) Parent Table Name Parent Column Name
Parents: PARENT_DIAGNOSIS_ID DIAGNOSIS DIAGNOSIS_ID
CHILD_PROCEDURE_ID PROCEDURE PROCEDURE_ID


PROCEDURE_EXT_DATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: External staging table for Procedures concept
Definition: To temporarily hold untrested data that has come from an external source (e.g. FHIR)
Table Type: ACTIVITY





Column Detail - PROCEDURE_EXT_DATA


Column Name Type Null? Definition
ACTION_DT_TM DATETIME Y The date and time of the action.
ACTION_PRSNL_ID DOUBLE N The personnel who performed the action.
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.
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 N 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.
CLIENT_IDENT VARCHAR(100) Y A string value used to represent a specific client.
DATA_LOB_ENCODING_STR VARCHAR(10) N Used for the encoding of the external data.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data.
ENCNTR_ID DOUBLE N The encounter related to the external procedure
NOMENCLATURE_ID DOUBLE N The term that was searched by a user to add the condition.
PERSON_ID DOUBLE N The person related to the external data.
PROCEDURE_DISPLAY VARCHAR(255) Y The display value to be used for describing the procedure performed.
PROCEDURE_EXT_BLOB LONGBLOB Y The data that has come from an external interface.
PROCEDURE_EXT_DATA_ID DOUBLE N PRIMARY KEY
PROCEDURE_ID DOUBLE N ID of the procedure row in the PROCEDURE table
REQUESTED_ACTION_CD DOUBLE N Action requested for the data.
SUBMITTED_DT_TM DATETIME Y The date and time this external data was added to the staging tables.
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.
VERSION_NBR DOUBLE Y The version of the external data.



Relationship Detail - PROCEDURE_EXT_DATA


Child Column in PROCEDURE_EXT_DATA(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
PERSON_ID PERSON PERSON_ID
PROCEDURE_ID PROCEDURE PROCEDURE_ID
ACTION_PRSNL_ID PRSNL PERSON_ID


PROCEDURE_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Procedure History
Definition: Used to store history of procedures in Chart Coding
Table Type: ACTIVITY





Column Detail - PROCEDURE_HIST


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.
ANESTHESIA_CD DOUBLE N The type of anesthesia.
ANESTHESIA_MINUTES DOUBLE Y The number of minutes the patient was under anesthesia.
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.
DGVP_IND DOUBLE N The number of minutes the patient was under anesthesia.
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.
GENERIC_VAL_CD DOUBLE N Code value that is selected for the -Generic Field- in HIMChartCoding.
NOMENCLATURE_ID DOUBLE N This is the value of the primary identifier of the nomenclature table. It is an internal, system-assigned number.
ORGANIZATION_ID DOUBLE Y This is the value of the unique primary identifier of the Organization table. It is an internal system assigned number. The organization associated with this procedure.
PARENT_ENTITY_ID DOUBLE N Primary key ID from the parent table.
PARENT_ENTITY_NAME VARCHAR(30) N Parent table name.
PROCEDURE_HIST_ID DOUBLE N This is the unique identifier for a procedure history row. It is an internal, system-assigned number.
PROCEDURE_ID DOUBLE N This is the unique identifier for a procedure row. It is an internal, system-assigned number.
PROC_DT_TM DATETIME Y The date and time the procedure was performed.
PROC_LOC_CD DOUBLE N The location code of the procedure.
PROC_PRIORITY DOUBLE Y The priority of the procedure compared to other procedures in the same encounter.
SVC_CAT_HIST_ID DOUBLE N This field is a unique identifier for the service category history table.
TISSUE_TYPE_CD DOUBLE N The tissue type (for example, moist or supple). This is an optional field.
UNITS_OF_SERVICE DOUBLE Y The number of units of service for a procedure (i.e. units of blood).
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 - PROCEDURE_HIST


Child Column in PROCEDURE_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
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PROCEDURE_ID PROCEDURE PROCEDURE_ID
SVC_CAT_HIST_ID SERVICE_CATEGORY_HIST SVC_CAT_HIST_ID