DASH_BREAK



Column Section Relationship Section Top of Page


Table-level Detail

Description: DASHBOARD BREAKS
Definition: Tracks if a given Provider needs a break for the current day
Table Type: ACTIVITY





Column Detail - DASH_BREAK


Column Name Type Null? Definition
DASH_BREAK_ID DOUBLE N PRIMARY KEY
EXCLUDE_IND DOUBLE N Indicates if the provider should be excluded from the chart data
POSITION_IDENT VARCHAR(100) Y A string value showing the positon for each provider put in the table
PROVIDER_ID DOUBLE N A Foreign key to the prsnl table.
PROVIDER_TYPE_FLAG DOUBLE N Identifies type of provider. 1 = Anesthesia Provider.
RECORD_DT_TM DATETIME Y Indicator of what day the row is relevant to
STATUS_DT_TM DATETIME Y Date and Time the status was updated
STATUS_FLAG DOUBLE N Indicates the current break status of the provider. 0 = A break is needed, 1 = The provider has received their break, 2 = The provider can break themselves
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 - DASH_BREAK


Child Column in DASH_BREAK(FK) Parent Table Name Parent Column Name
Parents: PROVIDER_ID PRSNL PERSON_ID


DASH_BREAK_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: DASHBOARD BREAK HISTORY
Definition: Tracks the BREAK History of a given Provider
Table Type: ACTIVITY





Column Detail - DASH_BREAK_HIST


Column Name Type Null? Definition
EXCLUDE_IND DOUBLE N Indicates if the provider should be excluded from the chart data
POSITION_IDENT VARCHAR(100) Y A string value showing the positon for each provider put in the table
PROVIDER_ID DOUBLE N A Foreign Key value from the PRSNL table
PROVIDER_TYPE_FLAG DOUBLE N Identifies type of provider. 1 = Anesthesia Provider.
RECORD_DT_TM DATETIME Y Indicator of what day the row is relevant to
STATUS_DT_TM DATETIME Y Date and Time the status was updated
STATUS_FLAG DOUBLE N Indicates the current break status of the provider. 0 = A break is needed, 1 = The provider has received their break, 2 = The provider can break themselves
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 - DASH_BREAK_HIST


Child Column in DASH_BREAK_HIST(FK) Parent Table Name Parent Column Name
Parents: PROVIDER_ID PRSNL PERSON_ID


DASH_COMPONENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: DASHBOARD COMPONENT
Definition: Dashboard Component Table
Table Type: REFERENCE





Column Detail - DASH_COMPONENT


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.
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 N 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 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.
COMPONENT_NAME VARCHAR(255) N Name of the Component.
COMPONENT_TEMPLATE_NAME VARCHAR(255) N Name of the Component Template.
CONTENT_DATA_ID DOUBLE N Foreign key to Long_Text_Reference table containing this Component's content data.
DASH_COMPONENT_ID DOUBLE N PRIMARY KEY
DASH_DASHBOARD_ID DOUBLE N Foreign key to Dashboard 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.
LAST_UPDT_PRSNL_ID DOUBLE N person last updating the dashboard component
MINI_WIKI_TXT_ID DOUBLE N Foreign key to Long_Text_Reference table containing this Component's mini wiki text.
ORG_ID DOUBLE N Foreign key to Organization table.
ORIG_DASH_COMPONENT_ID DOUBLE N Reference to Original Component Record. Required for Versioning
RECOMMENDED_DIMENSIONS_TXT VARCHAR(20) Y The recommended dimensions for this Component.
SAMPLE_DATA_TXT VARCHAR(2000) Y The sample data to be used for rendering the Component in the Config Tool.
SHIPPED_IND DOUBLE N True if shipped from Cerner.
TEMPLATE_IND DOUBLE N True if record represents a Template Component.
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 - DASH_COMPONENT


Child Column in DASH_COMPONENT(FK) Parent Table Name Parent Column Name
Parents: ORIG_DASH_COMPONENT_ID DASH_COMPONENT DASH_COMPONENT_ID
DASH_DASHBOARD_ID DASH_DASHBOARD DASH_DASHBOARD_ID
CONTENT_DATA_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
MINI_WIKI_TXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
ORG_ID ORGANIZATION ORGANIZATION_ID
LAST_UPDT_PRSNL_ID PRSNL PERSON_ID




Parent Column in DASH_COMPONENT (PK) Child Table Name Child Column Name
Children: DASH_COMPONENT_ID DASH_COMPONENT ORIG_DASH_COMPONENT_ID
DASH_COMPONENT_SETTING DASH_COMPONENT_ID
DASH_TYPE_COMPONENT_RELTN DASH_COMPONENT_ID


DASH_COMPONENT_SETTING



Column Section Relationship Section Top of Page


Table-level Detail

Description: DASHBOARD COMPONENT SETTINGS
Definition: Dashboard Component Configuration Settings Table
Table Type: REFERENCE





Column Detail - DASH_COMPONENT_SETTING


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.
CONFIG_SETTING_NAME VARCHAR(255) N Name of the Config Setting
DASH_COMPONENT_ID DOUBLE N Foreign key to Dashboard Component table.
DASH_COMPONENT_SETTING_ID DOUBLE N PRIMARY KEY
DESCRIPTION VARCHAR(1000) Y The tool-tip text for this record.
DISPLAY_NAME VARCHAR(100) Y The user-friendly name to display for this record.
INTERFACE_OPTIONS_TXT VARCHAR(1000) Y The options to display in the control, if any.
INTERFACE_TYPE CHAR(1) Y The type of control to display for this record.
ORG_ID DOUBLE N Foreign key to Organization table.
PARENT_SETTING_ID DOUBLE N Reference to another record in this table that is this record's parent record.
SETTING_DEFAULT_VALUE_TXT VARCHAR(255) Y The default value for the control, if any.
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 - DASH_COMPONENT_SETTING


Child Column in DASH_COMPONENT_SETTING(FK) Parent Table Name Parent Column Name
Parents: DASH_COMPONENT_ID DASH_COMPONENT DASH_COMPONENT_ID
PARENT_SETTING_ID DASH_COMPONENT_SETTING DASH_COMPONENT_SETTING_ID
ORG_ID ORGANIZATION ORGANIZATION_ID




Parent Column in DASH_COMPONENT_SETTING (PK) Child Table Name Child Column Name
Children: DASH_COMPONENT_SETTING_ID DASH_COMPONENT_SETTING PARENT_SETTING_ID


DASH_DASHBOARD



Column Section Relationship Section Top of Page


Table-level Detail

Description: DASHBOARD
Definition: Dashboard Table
Table Type: REFERENCE





Column Detail - DASH_DASHBOARD


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.
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 N 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 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.
CONTENT_DATA_TXT VARCHAR(1000) N The Content of the Dashboard itself.
DASHBOARD_NAME VARCHAR(255) N Name of the Dashboard.
DASHBOARD_TEMPLATE_NAME VARCHAR(255) N Name of the Dashboard Template.
DASH_DASHBOARD_ID DOUBLE N PRIMARY KEY
DASH_TYPE_ID DOUBLE N Foreign key to Dash_Type 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.
LAST_UPDT_PRSNL_ID DOUBLE N person last updating the dashboard
ORG_ID DOUBLE N Foreign key to Organization table.
ORIG_DASH_DASHBOARD_ID DOUBLE N Reference to Original Dashboard Record. Required for Versioning.
SHIPPED_IND DOUBLE N True if shipped from Cerner.
TEMPLATE_IND DOUBLE Y True if record represents a Template Dashboard.
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 - DASH_DASHBOARD


Child Column in DASH_DASHBOARD(FK) Parent Table Name Parent Column Name
Parents: ORIG_DASH_DASHBOARD_ID DASH_DASHBOARD DASH_DASHBOARD_ID
DASH_TYPE_ID DASH_TYPE DASH_TYPE_ID
ORG_ID ORGANIZATION ORGANIZATION_ID
LAST_UPDT_PRSNL_ID PRSNL PERSON_ID




Parent Column in DASH_DASHBOARD (PK) Child Table Name Child Column Name
Children: DASH_DASHBOARD_ID DASH_COMPONENT DASH_DASHBOARD_ID
DASH_DASHBOARD ORIG_DASH_DASHBOARD_ID
DASH_FILTER DASH_DASHBOARD_ID
DASH_ITEM_GROUP DASH_DASHBOARD_ID