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 |