Table Detail Report

CHART_AP_FORMAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: CHART AP FORMAT
Definition: Stores info for formatting Anatomic Pathology chart sections
Table Type: REFERENCE





Column Detail - CHART_AP_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.
AP_CPT_LONG_TEXT_ID DOUBLE N Anatomic Pathology CPT ID Number - Stores an ID from the LONG_TEXT_REFERENCE table where the CPT options are stored.
AP_HISTORY_FLAG DOUBLE Y Print or don't print history
CHART_GROUP_ID DOUBLE N FK to chart_group table
GROUP_STYLE VARCHAR(255) Y Style to apply to group heading
IMAGE_FLAG DOUBLE Y the flag for including image in ap section.
RESULT_SEQUENCE DOUBLE Y Sequencing of results
SNOMED_CD_LBL_STYLE VARCHAR(255) Y Style to apply to snomed code labels
SNOMED_CODES_IND DOUBLE Y Print or don't print snomed codes
SNOMED_CODES_LBL VARCHAR(100) Y Label for snomed codes
SNOMED_DESC_IND DOUBLE Y Print or don't print snomed descriptions
TCC_CD_LBL_STYLE VARCHAR(255) Y Style for TCC labels
TCC_CODES_IND DOUBLE Y Print or don't print TCC codes
TCC_CODES_LBL VARCHAR(100) Y Label for TCC codes
TCC_DESC_IND DOUBLE Y Print or don't print TCC descriptions
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_AP_FORMAT


Child Column in CHART_AP_FORMAT(FK) Parent Table Name Parent Column Name
Parents: CHART_GROUP_ID CHART_GROUP CHART_GROUP_ID
AP_CPT_LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID


CHART_CATEGORY



Column Section Top of Page


Table-level Detail

Description: Contains all categories that are added through the MRP DB Tool.
Definition: Stores all categories and their associated properties. (sensitivity, expandable, and parent_category)
Table Type: REFERENCE





Column Detail - CHART_CATEGORY


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.
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.
CATEGORY_NAME VARCHAR(50) Y Name of the category added through the MRP DB Tool
CATEGORY_SEQ DOUBLE Y Sequence that the category is to be displayed in the MRP DB Tool as well as the MRP Dll
CHART_CATEGORY_ID DOUBLE N This is the primary key of the chart_category id. It uniquely identifies the row on the 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.
EXPANDABLE_DOC_IND DOUBLE Y Identifies if the category on the table is able to be expanded in the MRP Dll
PARENT_CATEGORY_ID DOUBLE N Identifies the parent category by the unique id of the parent category
SENSITIVE_IND DOUBLE Y Identifies if a category is to be listed as sensitive in the MRP Dll
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.


CHART_DISCERN_REQUEST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Chart Discern Request
Definition: This table stores the Discern Requests that are available to pull into the Discern Section.
Table Type: REFERENCE





Column Detail - CHART_DISCERN_REQUEST


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.
CHART_DISCERN_REQUEST_ID DOUBLE N This is the id that uniquely defines the discern request
DISPLAY_TEXT VARCHAR(60) N Display name to display to the user for selection criteria.
PROCESS_FLAG DOUBLE Y Stores option to process chart by line by line text or as a postscript file. 0: Line-by-line text, 1: postscript
PROCESS_SYSTEM_FLAG DOUBLE Y Indicates which system can process the script (0 = Win32 reporting, 1=XR reporting, 2= Win32 and XR)
QUALIFICATION_DATE_FLAG DOUBLE N This flag will be set to 0 if the script intends to use the begin_dt_tm and end_dt_tm to qualify clinical events. This flag will be set to 1 if the script intends to use the begin_dt_tm and end_dt_tm to qualify non-clinical events.
REQUEST_NUMBER DOUBLE N This is the id that identifies the request number to utilize for the discern request
SCOPE_BIT_MAP DOUBLE Y Bitmap for valid scopes. 0: No Valid Scopes 1:Person 10:Encounter 100: Order 1000: Accession 10000:X-Ecnounter 100000:Document
SCRIPT_NAME VARCHAR(50) Y The object name of the script to execute (do not add .prg)
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_DISCERN_REQUEST




Parent Column in CHART_DISCERN_REQUEST (PK) Child Table Name Child Column Name
Children: CHART_DISCERN_REQUEST_ID CHART_GENERIC_FORMAT CHART_DISCERN_REQUEST_ID


CHART_DISTRIBUTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table stores the distribution parameters defined for a given distribution
Definition: chart distribution
Table Type: REFERENCE





Column Detail - CHART_DISTRIBUTION


Column Name Type Null? Definition
ABSOLUTE_LOOKBACK_IND DOUBLE N Absolute qualification look back indicator. 0:Date, 3:Days
ABSOLUTE_QUALIFICATION_DAYS DOUBLE N Absolute qualification look back days.
ABSOLUTE_QUALIFICATION_DT_TM DATETIME N Absolute qualification look back date.
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.
BANNER_PAGE VARCHAR(256) Y Location of the banner page which is a cover page that prints before the charts within the distribution print.
CUTOFF_AND_OR_IND DOUBLE Y When cutoff logic is being used this defines whether pages and days; or, pages or days will be used in determining when a cutoff chart should be produced
CUTOFF_DAYS DOUBLE Y This defines the number of days to wait before a cutoff chart should be produced
CUTOFF_PAGES DOUBLE Y This defines the number of pages that need to exist in a patient's chart before producing a cutoff chart.
DAYS_TILL_CHART DOUBLE Y This defines the number of days after discharge that the system should wait in producing a chart
DELETE_OLD_DISTR_FLAG DOUBLE Y This field indicates either previous rows for the encounters that received a chart during the current distribution run have to be deleted from chart_request table or not based on this field value (1 - indicates delete during distribution run, 0 - indicated delete old rows when running from operations)
DISTRIBUTION_ID DOUBLE N The id uniquely assigned to a chart distribution
DIST_DESCR VARCHAR(100) Y The description of the chart distribution
DIST_TYPE DOUBLE Y This defines whether patients should be included in a distribution based on their status (i.e. discharged, non-discharged, both)
FIRST_QUALIFICATION_DAYS DOUBLE N First qualification look back days.
FIRST_QUALIFICATION_DT_TM DATETIME N First qualification look back date.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
MAX_LOOKBACK_DAYS DOUBLE Y Initial distribution look back days.
MAX_LOOKBACK_DT_TM DATETIME N Initial distribution look back date.
MAX_LOOKBACK_IND DOUBLE N Initial distribution look back indicator. 0: Date, 3: Days
PRINT_LOOKBACK_IND DOUBLE Y Indicator used for First qualification. 0:Date, 1:Exclude Data From Previous Distribution Run, 2:Patient Admit Date, 3:Days
READER_GROUP VARCHAR(15) Y This field, if defined, will associate this distribution with any other distribution that has the same chart reader group
SORT_SEQUENCE_FLAG DOUBLE Y This is how the charts will be sorted for a given distribution
UNIQUE_IDENT VARCHAR(60) Y A Unique Identifier
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_DISTRIBUTION


Child Column in CHART_DISTRIBUTION(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID




Parent Column in CHART_DISTRIBUTION (PK) Child Table Name Child Column Name
Children: DISTRIBUTION_ID CHART_ACTIVITY_TEMP DISTRIBUTION_ID
CHART_DIST_FILTER DISTRIBUTION_ID
CHART_DIST_FILTER_VALUE DISTRIBUTION_ID
CHART_DIST_LOG DISTRIBUTION_ID
CHART_PRINT_QUEUE DISTRIBUTION_ID
CHART_REQUEST DISTRIBUTION_ID
CHART_TEMP DISTRIBUTION_ID
CR_DIST_EXEC DISTRIBUTION_ID
CR_REPORT_REQUEST DISTRIBUTION_ID


CHART_DIST_FILTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: This tables defines which selection criteria is being used within a distribution
Definition: chart distribution filter
Table Type: REFERENCE





Column Detail - CHART_DIST_FILTER


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.
DISTRIBUTION_ID DOUBLE N The id that uniquely identifies a chart distribution
INCLUDED_FLAG DOUBLE Y This defines whether the data defined for a given selection criteria should be included in or excluded from the chart distribution
TYPE_FLAG DOUBLE N The selection criteria type
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


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