Table Detail Report

CHART_NAME_HIST_FORMAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Formatting parameters for Name History section.
Definition: Stores the formatting parameters for the Name History section in the Chart Format Builder.
Table Type: REFERENCE





Column Detail - CHART_NAME_HIST_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.
BEG_EFFECTIVE_DT_TM_LBL VARCHAR(32) Y This label serves as the column heading for the beg_effective_dt_tm of when the person's name changed.
BEG_EFFECTIVE_DT_TM_ODR DOUBLE Y This is the horizontal order (sequence) of the beg_effective_dt_tm column.
CHART_GROUP_ID DOUBLE N The primary identifier for the chart group to which the formatting information belongs.
END_EFFECTIVE_DT_TM_LBL VARCHAR(32) Y This label serves as the column heading for the end_effective_dt_tm of the person's name.
END_EFFECTIVE_DT_TM_ODR DOUBLE Y This is the horizontal order (sequence) of the end_effective_dt_tm column.
NAME_LBL VARCHAR(32) Y This label serves as the column heading for the person's name.
NAME_ODR DOUBLE Y This is the horizontal order (sequence) of the end_effective_dt_tm column.
ORDER_SEQ_IND DOUBLE Y Specifies the ordering of the name changes, in either newest to oldest (1) or oldest to newest (0)
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_NAME_HIST_FORMAT


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


CHART_ORDERS_FORMAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Formatting parameters for Orders section.
Definition: Stores the formatting parameters for the Orders section in the Chart Format Builder.
Table Type: REFERENCE





Column Detail - CHART_ORDERS_FORMAT


Column Name Type Null? Definition
ACTION_IND DOUBLE Y Indicates whether or not the action will display on the chart. Other action information like comments, reviews, and details can still display even if this is 0.
ACTION_LBL VARCHAR(32) Y The label that displays next to the action on the chart. It will only display if action_ind = 1.
ACTION_SEQ_FLAG DOUBLE Y Sort direction for actions within an order. 0 = ascending, 1 = descending
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.
CANCELED_DTTM_LBL VARCHAR(32) Y The label for the cancelled date/time if LABEL_BIT_MAP has 0x4 selected
CANCEL_REASON_LBL VARCHAR(32) Y The label for the cancel reason if LABEL_BIT_MAP has 0x40 selected.
CHART_GROUP_ID DOUBLE N The primary identifier for the chart group to which the formatting information belongs.
COMMENTS_IND DOUBLE Y Indicates whether or not order comments will display on the chart.
COMMENTS_LBL VARCHAR(32) Y The label that displays next to the order comments. It will only display if comments_ind = 1.
COMMENT_ORDER DOUBLE Y The vertical order position of the order comments in relation to the review information and the order details.
COMM_TYPE_LBL VARCHAR(32) Y The label for the communication type if LABEL_BIT_MAP has 0x20 selected
DATE_MASK VARCHAR(50) N The format for dates within the section.
DATE_TIME_IND DOUBLE Y Indicates whether or not the order date and time will display on the chart for each order.
DATE_TIME_LBL VARCHAR(32) Y The label that displays next to the order date and time. It will only display if date_time_ind = 1
DEPT_STATUS_LBL VARCHAR(32) Y The label for the department status if LABEL_BIT_MAP has 0x2 selected
DETAILED_LAYOUT_IND DOUBLE N Option to flex the layout of the orders section to the detailed layout.
DETAILS_IND DOUBLE Y Indicates whether or not the order details will display on the chart.
DETAILS_LBL VARCHAR(32) Y The label that displays next to the order details. It will only display if details_ind = 1.
DETAIL_ORDER DOUBLE Y The vertical order position of the order details in relation to the review information and the order comments.
DISCONTINUED_DTTM_LBL VARCHAR(32) Y The label for the order discontinued date/time if LABEL_BIT_MAP has 0x8 selected
EXCLUDE_OSNAME_IND DOUBLE N Indicates if order set names will be excluded from order section listsings
FUTURE_DISC_DTTM_LBL VARCHAR(32) Y The label for the order future discontinue date/time if LABEL_BIT_MAP has 0x10 selected
LABEL_BIT_MAP DOUBLE N List of which labels are enabled stored in a bitmap
MNEMONIC_IND DOUBLE Y Indicates whether or not the order mnemonic will display on the chart.
MNEMONIC_LBL VARCHAR(32) Y The label that appears next to the order mnemonic. It will only display if the mnemonic_ind = 1.
ORDER_PHYS_IND DOUBLE Y Indicates whether or not the Ordering Physician will display on the chart.
ORDER_PHYS_LBL VARCHAR(32) Y The label that appears next to the ordering physician. It will only appear if the order_phys_ind = 1.
ORDER_PLACER_IND DOUBLE Y Indicates whether or not the person who placed the order is shown on the chart.
ORDER_PLACER_LBL VARCHAR(32) Y The label that appears next to the person who placed the order. It will only appear if the order_placer_ind = 1.
ORDER_SEQ_FLAG DOUBLE Y Specifies the type of sorting sequence.
ORDER_STATUS_IND DOUBLE Y Indicates whether or not the order status will display on the chart.
ORDER_STATUS_LBL VARCHAR(32) Y The label that appears next to the order status. It will only appear if the order_status_ind = 1.
ORDER_TYPE_IND DOUBLE Y Indicates whether or not the order type will display on the chart.
ORDER_TYPE_LBL VARCHAR(32) Y The label that appears next to the order type. It will only display if the order_type_ind = 1.
ORIG_ORDER_DTTM_LBL VARCHAR(32) Y The label for the original order date/time if LABEL_BIT_MAP has 0x1 selected
REVIEW_IND DOUBLE Y Indicates whether or not the review information will display on the chart.
REVIEW_LBL VARCHAR(32) Y The label that appears next to the review information. It will only display if the review_ind = 1.
REVIEW_ORDER DOUBLE Y The order position of the review information in relation to the order details and order comments.
SUPPRESS_MEDS_BIT_MAP DOUBLE Y Suppress medication types from displaying according to the selection
TIME_MASK VARCHAR(32) N The format for all time values within the section.
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_ORDERS_FORMAT


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


CHART_ORDER_SUMMARY_FORMAT



Column Section Top of Page


Table-level Detail

Description: This table defines the format of the order summary section type
Definition: chart order summary format
Table Type: REFERENCE





Column Detail - CHART_ORDER_SUMMARY_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.
CANCEL_REASON_LBL VARCHAR(32) Y This is the label for cancel reason column in a cancelled order summary section.
CANCEL_REASON_ORDER DOUBLE Y This is the order for cancel reason column in a cancelled order summary section.
CHART_GROUP_ID DOUBLE N This number uniquely identifies the chart group
DATE_LBL VARCHAR(20) Y This is the label for date column in a order summary section.
DATE_MASK VARCHAR(50) Y This is the date format mask for date column.
DATE_ORDER DOUBLE Y This is the order for date column in a order summary section.
DEPT_STATUS_LBL VARCHAR(32) Y This is the label for department status column in all orders or pending orders summary section
DEPT_STATUS_ORDER DOUBLE Y This is the order for department status column in all order or pending orders summary section.
MNEMONIC_LBL VARCHAR(32) Y This is the label for a order mnemonic column in a order summary section.
MNEMONIC_ORDER DOUBLE Y This is the order for a order mnemonic column in a order summary section.
NAME_LBL VARCHAR(32) Y This is the label for a order name column in a order summary section.
NAME_ORDER DOUBLE Y This is the order for a order name column in a order summary section.
ORDER_PROVIDER_IND DOUBLE Y This is the indicator to define whether to print the original, current, original and current, or all ordering providers
ORDER_PROVIDER_LBL VARCHAR(32) Y This is the label for ordering provider column in an orders summary section
ORDER_PROVIDER_ORDER DOUBLE Y This is the order for ordering provider column in an orders summary section
ORDER_SEQ_FLAG DOUBLE Y This flag indicates that the printed results are in the order of date/name or in the order of name/date.
ORDER_SUMMARY_TYPE DOUBLE Y This defines the type of order summary format that will print on the chart (i.e. pending, cancelled, ordered)
STATUS_LBL VARCHAR(32) Y This is the label for status column in a all orders or pending orders summary section.
STATUS_ORDER DOUBLE Y This is the order for status column in a all orders or pending orders summary section.
TIME_LBL VARCHAR(20) Y This is the label for a time column in a order summary section.
TIME_MASK VARCHAR(50) Y This is the time format for a time column in a order summary section.
TIME_ORDER DOUBLE Y This is the order for a time column in a order summary section.
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_ORD_SUM_FILTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table defines the filter for a order summary section.
Definition: chart order summary filter
Table Type: REFERENCE





Column Detail - CHART_ORD_SUM_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.
CHART_GROUP_ID DOUBLE N This is the chart group id for which the filter is used.
FILTER_CD DOUBLE N This is a filter value, which is a code value of code set 14281 or 106, for a order summary section.
FILTER_TYPE_FLAG DOUBLE Y This flag indicates that the filter is departmental order status or activity type.
SEQUENCE DOUBLE N This is a sequence value for a list of filter value in a order summary section.
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_ORD_SUM_FILTER


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


CHART_PRINTED_SECTIONS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Chart Printed Sections
Definition: Stores the sections of a chart that actually printed from a specific chart request.
Table Type: ACTIVITY





Column Detail - CHART_PRINTED_SECTIONS


Column Name Type Null? Definition
CHART_REQUEST_ID DOUBLE N Unique identifier from the CHART_SECTION table.
CHART_SECTION_ID DOUBLE N Unique identifier from the CHART_SECTION table.
PRINTED_SECTION_ID DOUBLE N A number that uniquely identifies a row on this table.
RESUBMIT_DT_TM DATETIME Y The Resubmit Date and Time
RESUBMIT_NBR DOUBLE N Represents the number of times this chart request was resubmitted.
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_PRINTED_SECTIONS


Child Column in CHART_PRINTED_SECTIONS(FK) Parent Table Name Parent Column Name
Parents: CHART_REQUEST_ID CHART_REQUEST CHART_REQUEST_ID
CHART_SECTION_ID CHART_SECTION CHART_SECTION_ID