Table Detail Report

CHART_TEMP



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table is used with charting distributions to hold encounters that qualify.
Definition: This table is used with charting distributions to hold encounters that qualify and meet the demographic criteria. It is a temporary table.
Table Type: ACTIVITY





Column Detail - CHART_TEMP


Column Name Type Null? Definition
BEGIN_DT_TM DATETIME Y The beginning date and time to post for the chart request.
CREATE_DT_TM DATETIME Y Encounter create_dt_tm
DISTRIBUTION_ID DOUBLE N Uniquely identifies the distribution_id running.
DONT_USE_IND DOUBLE Y Indicator on whether this encounter should be used or not. Also used for cross-encounter logic for determining which items to use based on exclude law logic.
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_TYPE_CD DOUBLE N identifies the type of Encounter
LOC_BED_CD DOUBLE N Encounter loc_bed_cd
LOC_BUILDING_CD DOUBLE N Encounter loc_building_cd
LOC_FACILITY_CD DOUBLE N Encounter loc_facility_cd
LOC_NURSE_UNIT_CD DOUBLE N Encounter loc_nurse_unit_cd
LOC_ROOM_CD DOUBLE N Encounter loc_room_cd
LOOKBACK_DT_TM DATETIME Y Represents the lookback date and time to use when qualifying the encounter against the clinical_event table.
NON_CE_BEGIN_DT_TM DATETIME Y This date/time is stored temporarily during distribution processing to indicate this encounter's begin_dt_tm for non-clinical_event results.
ORGANIZATION_ID DOUBLE N Encounter organization_id
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
USE_IND DOUBLE Y Used for cross-encounter logic for determining which items to use based on include law logic.



Relationship Detail - CHART_TEMP


Child Column in CHART_TEMP(FK) Parent Table Name Parent Column Name
Parents: DISTRIBUTION_ID CHART_DISTRIBUTION DISTRIBUTION_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID


CHART_TRIGGER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Chart Trigger
Definition: The chart_trigger table is used to store the general information about a given trigger
Table Type: REFERENCE





Column Detail - CHART_TRIGGER


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.
ADDITIONAL_COPY_NBR DOUBLE N number of additional copies
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.
CHART_FORMAT_ID DOUBLE N The chart format unique identifier
CHART_TRIGGER_ID DOUBLE N Primary key for a given trigger
COMPLETE_FLAG DOUBLE N The complete flag denotes whether to trigger on complete accessions, complete orders, etc.
DATE_DT_TM DATETIME Y Stores the start date of printed chart to be requested.
DAYS_NBR DOUBLE N The number of days used for a request window.
DEFAULT_OUTPUT_DEST_CD DOUBLE N The default output destination
DISCHARGE_TYPE_FLAG DOUBLE N Discharge type flat denote whether to qualify discharged, non-discharged or both type of patients
DMS_SERVICE_NAME VARCHAR(64) Y The dms service name
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.
EXPIRED_RELTN_IND DOUBLE N The expired relationship indicator notes to include or exclude expired relationships when determining the recipients of the charts.
FILE_STORAGE_CD DOUBLE N The file storage code notes the type of files to be produced
FILE_STORAGE_LOCATION VARCHAR(225) Y The location in which to place electronic copies of a given request
NAME_IDENT VARCHAR(167) N Unique Identifier used for merge processes. A concatenation of the name key and date column. MUI.
PENDING_FLAG DOUBLE N Selection in which to print verified events only, verified and pending, etc.
PREV_CHART_TRIGGER_ID DOUBLE N Trigger Identifier. Required for RDDS type-2 versioning.
PRINT_RANGE_FLAG DOUBLE N The print range flag denotes whether to produce a chart for the specific result, cumulative, etc.
REPORT_TEMPLATE_ID DOUBLE N The report template unique identifier from CR_REPORT_TEMPLATE
ROUTE_LOCATION_BIT_MAP DOUBLE N The route location bitmap denotes the locations in which a chart should be produced (assigned device, patient location order location, etc.)
SCOPE_FLAG DOUBLE N The scope of the request to be made
SENDING_ORG_ID DOUBLE N Indicates the sending organization for the trigger
TRIGGER_NAME VARCHAR(150) N The name of the trigger
TRIGGER_NAME_KEY VARCHAR(150) N The name key of the trigger
TRIGGER_TYPE_FLAG DOUBLE N Trigger type flag defines if a given trigger is to trigger now or trigger later
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 - CHART_TRIGGER


Child Column in CHART_TRIGGER(FK) Parent Table Name Parent Column Name
Parents: CHART_FORMAT_ID CHART_FORMAT CHART_FORMAT_ID
PREV_CHART_TRIGGER_ID CHART_TRIGGER CHART_TRIGGER_ID
REPORT_TEMPLATE_ID CR_REPORT_TEMPLATE REPORT_TEMPLATE_ID
SENDING_ORG_ID ORGANIZATION ORGANIZATION_ID




Parent Column in CHART_TRIGGER (PK) Child Table Name Child Column Name
Children: CHART_TRIGGER_ID CHART_REQUEST CHART_TRIGGER_ID
CHART_TRIGGER PREV_CHART_TRIGGER_ID
CHART_TRIGGER_PARAM CHART_TRIGGER_ID
CR_REPORT_REQUEST CHART_TRIGGER_ID


CHART_TRIGGER_PARAM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Chart Trigger Parameters
Definition: The chart trigger parameters table is used to store a give set of parameters for a given trigger.
Table Type: REFERENCE





Column Detail - CHART_TRIGGER_PARAM


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.
CHART_TRIGGER_ID DOUBLE N Primary key for a given trigger. From the CHART_TRIGGER table.
CHART_TRIGGER_PARAM_ID DOUBLE N Primary key for 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.
INCLUDE_IND DOUBLE N Include/exclude a parameter. 0 = exclude, 1 = include
PARAM_TYPE_FLAG DOUBLE N Type flag to note the parameter type stored (encounter type, location, organization, etc.)
PARENT_ENTITY_ID DOUBLE N The id of the parent entity (table)
PARENT_ENTITY_NAME VARCHAR(30) N The name of the parent entity (table)
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_TRIGGER_PARAM


Child Column in CHART_TRIGGER_PARAM(FK) Parent Table Name Parent Column Name
Parents: CHART_TRIGGER_ID CHART_TRIGGER CHART_TRIGGER_ID


CHART_VERT_FORMAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table defines attributes for vertical section formatting
Definition: chart vertical format
Table Type: REFERENCE





Column Detail - CHART_VERT_FORMAT


Column Name Type Null? Definition
ABNML_HILITE_FLAG DOUBLE Y This field identifies the type of highlighting that is used for abnormal results
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 which uniquely identifies a chart group
CRIT_HILITE_FLAG DOUBLE Y This field identifies the type of highlighting used for a critical result
DATE_FORMAT_CD DOUBLE N This code identifies the format that should be used when printing the date
DATE_LBL VARCHAR(32) Y This is the label that should print for the date
DATE_MASK VARCHAR(50) Y This field stores a date mask to be used on all date within this group.
DATE_ORDER DOUBLE Y This is the order in which the date should print
ENCNTR_ALIAS_LBL VARCHAR(32) Y encounter alias column label
ENCNTR_ALIAS_ORDER DOUBLE Y the order of encounter alias column
FLOWSHEET_IND DOUBLE Y This tells us if the user selected Vertical section or Vertical Flowsheet section.
FTNOTE_LOC_FLAG DOUBLE Y This is the location where footnotes should print
INTERP_LOC_FLAG DOUBLE Y This is the location where the interpretive data should print
PERFID_LBL VARCHAR(32) Y This is the label that should print to identify the performed_id
PERFID_LBL_ORDER DOUBLE Y This defines the order that the performed_id label should display on the format.
PERFID_LBL_POS DOUBLE Y This defines the position of the performed_id label (i.e. right side or left side)
REFER_LBL_ORDER DOUBLE Y This defines the order that the reference range label should print
REFER_LBL_POS DOUBLE Y This defines the position of the reference range label (i.e. right side or left side)
REF_RANGE_LBL VARCHAR(32) Y This defines what should print on the chart as the reference range label
REF_RNG_FORM_FLAG DOUBLE Y This is the format that the reference range should use to print
RESLT_START_COL DOUBLE Y This field is not used at this time
RSLT_SEQ_FLAG DOUBLE Y This is the order that the results should print in (newest to oldest or oldest to newest)
STAYDAYS_FORM_FLAG DOUBLE Y This is the format in which the day of stay should print
STAYDAYS_LBL VARCHAR(32) Y This is the label that should print for the day of stay field
STAYDAYS_ORDER DOUBLE Y This is the order in which the day of stay field should print
TEST_LBL VARCHAR(32) Y This is the label that should print to identify the procedure
TEST_LBL_ORDER DOUBLE Y This field identifies the order in which the test should print
TEST_LBL_POS DOUBLE Y This field defines where the test name and label will print on the chart (right side or left side)
TIME_FORMAT_FLAG DOUBLE Y This field identifies the format that is used when printing the time on the chart
TIME_LBL VARCHAR(32) Y This is the label that should print for the time on the chart
TIME_MASK VARCHAR(32) Y This field stores time mask used to format all times within this group.
TIME_ORDER DOUBLE Y This is the order in which the time should print
UNITS_LBL VARCHAR(32) Y This is the label that should be printed on the chart for the units
UNITS_LBL_ORDER DOUBLE Y This is the order in which the units and the label should print
UNITS_LBL_POS DOUBLE Y This is the position in which the units should print on the chart (right side or left side)
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_VERT_FORMAT


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


CHART_XENCNTR_FORMAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table defines the attributes for a cross encounter summary section.
Definition: chart_xencntr_format
Table Type: REFERENCE





Column Detail - CHART_XENCNTR_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.
ADMIT_DT_LBL VARCHAR(32) Y admit date column label
ADMIT_DT_ODR DOUBLE Y the order of admit date column
BUILDING_LBL VARCHAR(32) Y building column label
BUILDING_ODR DOUBLE Y the order of building column
CHART_GROUP_ID DOUBLE N This is a unique number that identifies a chart group
CLIENT_LBL VARCHAR(32) Y client column label
CLIENT_ODR DOUBLE Y the order of client column
DIAGNOSIS_LBL VARCHAR(32) Y admitting diagnosis column label
DIAGNOSIS_ODR DOUBLE Y the order of admitting diagnosis column
DISCHG_DT_LBL VARCHAR(32) Y discharge date column label
DISCHG_DT_ODR DOUBLE Y the order of discharge date column
EA_PREFIX_FORMAT VARCHAR(15) Y encounter alias format
EA_PREFIX_FORMAT_FLAG DOUBLE Y encounter alias format flag
ENCNTR_ALIAS_LBL VARCHAR(32) Y encounter alias column label
ENCNTR_ALIAS_ODR DOUBLE Y the order of encounter alias column
FACILITY_LBL VARCHAR(32) Y facility column label
FACILITY_ODR DOUBLE Y the order of facility column
FIN_NBR_LBL VARCHAR(32) Y finacial number column label
FIN_NBR_ODR DOUBLE Y the order of finacial number column
MRN_LBL VARCHAR(32) Y medical record number column label
MRN_ODR DOUBLE Y the order of medical record number column
NURSE_UNIT_LBL VARCHAR(32) Y nurse unit column label
NURSE_UNIT_ODR DOUBLE Y the order of nurse unit column
RSLT_SEQ_FLAG DOUBLE Y sort sequence flag for encounters
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_XENCNTR_FORMAT


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