Table Detail Report

CHART_DIST_FILTER_VALUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table defines the values included or excluded for each selection criteria
Definition: chart distribution filter value
Table Type: REFERENCE





Column Detail - CHART_DIST_FILTER_VALUE


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.
DESCRIPTION VARCHAR(60) Y The description of the data that is defined to be included or exclude for a particular selection criteria
DISTRIBUTION_ID DOUBLE N The id uniquely defined for the chart distribution
KEY_SEQUENCE DOUBLE N Provides the ability to define multiple filters per distribution and selection criteria
PARENT_ENTITY_ID DOUBLE N This is the code for the data that is being included or excluded for the selection criteria. The code set that this code comes from varies based onthe selection criteria.
PARENT_ENTITY_NAME VARCHAR(30) Y Contains the name of the table to which value of parent_entity_id fields belongs
QUALIFIER VARCHAR(10) Y not used at this time
RELTN_TYPE_CD DOUBLE N This field coupled with the type_flag = 2 and parent_entity_id field shows the relationship type chosen with that particular provider.
TYPE_FLAG DOUBLE N This defines the type of criteria that will be included or excluded from a distribution
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - CHART_DIST_FILTER_VALUE


Child Column in CHART_DIST_FILTER_VALUE(FK) Parent Table Name Parent Column Name
Parents: DISTRIBUTION_ID CHART_DISTRIBUTION DISTRIBUTION_ID


CHART_DIST_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Used to log distribution processing messages.
Definition: chart_dist_log
Table Type: ACTIVITY





Column Detail - CHART_DIST_LOG


Column Name Type Null? Definition
BATCH_SELECTION VARCHAR(100) Y Name of the Batch Job
CHART_LOG_NUM DOUBLE N Unique Key to the table.
DISTRIBUTION_ID DOUBLE N unique identifier of the chart_distribution table.
DIST_RUN_DT_TM DATETIME Y distribution run date and time
DIST_RUN_TYPE_CD DOUBLE N distribution run type
LOG_DT_TM DATETIME Y Log message date and time
MESSAGE_TEXT VARCHAR(200) Y Message Text
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - CHART_DIST_LOG


Child Column in CHART_DIST_LOG(FK) Parent Table Name Parent Column Name
Parents: DISTRIBUTION_ID CHART_DISTRIBUTION DISTRIBUTION_ID


CHART_DOC_FORMAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: CHART DOC FORMAT
Definition: The table stores parameters for document section in a chart format.
Table Type: REFERENCE





Column Detail - CHART_DOC_FORMAT


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.
CHART_GROUP_ID DOUBLE N Foreign key from the CHART_GROUP table
DOC_TYPE_FLAG DOUBLE N The type of Document sections. 0 - Documents related to Encounter. 1 - Document related to Patient level.
EXCLUDE_IMG_MDOC_IND DOUBLE Y Indicates whether or not to display the document table for each separate document containing only images.
INCLUDE_ECG_IMG_IND DOUBLE N ** OBSOLETE ** - Due to requirements change, this NEW column is no longer needed. It is now logically obsolete.Indicates whether or not to display the hard-coded Image on a page containing a CDI image.
INCLUDE_IMG_FOOTER_IND DOUBLE Y Indicates whether or not to display the hard-coded footer on a page containing a CDI image.
INCLUDE_IMG_HEADER_IND DOUBLE Y Indicates whether or not to display the hard-coded header on a page containing a CDI image.
PAGE_BRK_IND DOUBLE Y Indicator for a page break after each document.
RESULT_SEQ_FLAG DOUBLE Y The flag for sorting results.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - CHART_DOC_FORMAT


Child Column in CHART_DOC_FORMAT(FK) Parent Table Name Parent Column Name
Parents: CHART_GROUP_ID CHART_GROUP CHART_GROUP_ID


CHART_DYN_ZONE_FORM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Charting Dynamic Zone Format parameters
Definition: Defines the parameters for the new version of the zonal section.
Table Type: REFERENCE





Column Detail - CHART_DYN_ZONE_FORM


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.
CHART_GROUP_ID DOUBLE N This is a number that uniquely identifies a chart group
PROC_COL DOUBLE Y The number of the column where procedure names are placed. If column number is 0, it does not appear on the chart.
PROC_LBL VARCHAR(32) Y The column header of the procedure column.
REF_RANGE_COL DOUBLE Y The number of the column where reference ranges are placed. If column number is 0, it does not appear on the chart.
REF_RANGE_LBL VARCHAR(32) Y The column header of the reference range column.
UNITS_COL DOUBLE Y The number of the column where units are placed. If column number is 0, it does not appear on the chart.
UNITS_LBL VARCHAR(32) Y The column header of the units column.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
ZONE_SEQ DOUBLE N The order sequence of the zone, starting at the left with a sequence of 1.



Relationship Detail - CHART_DYN_ZONE_FORM


Child Column in CHART_DYN_ZONE_FORM(FK) Parent Table Name Parent Column Name
Parents: CHART_GROUP_ID CHART_GROUP CHART_GROUP_ID




Parent Column in CHART_DYN_ZONE_FORM (PK) Child Table Name Child Column Name
Children: CHART_GROUP_ID CHART_ZN_RESULT_COL CHART_GROUP_ID
ZONE_SEQ CHART_ZN_RESULT_COL ZONE_SEQ


CHART_ENCNTR_DISCHARGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: CHART ENCNTR DISCHARGE
Definition: This table stores the information regarding the encounter discharge_dt_tm.
Table Type: ACTIVITY





Column Detail - CHART_ENCNTR_DISCHARGE


Column Name Type Null? Definition
CHART_ENCNTR_DISCHARGE_ID DOUBLE N A unique id to track each row in this table.
DISCHARGE_DT_TM DATETIME N The discharge date time of the encounter.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
TRANSACT_DT_TM DATETIME N The date time at which the transaction was entered into the system.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - CHART_ENCNTR_DISCHARGE


Child Column in CHART_ENCNTR_DISCHARGE(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID