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 |