Table Detail Report

DASH_FILTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: DASHBOARD FILTERS
Definition: The Dashboard Filter table
Table Type: REFERENCE





Column Detail - DASH_FILTER


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 Filter.
DASH_DASHBOARD_ID DOUBLE N Foreign key to Dashboard Table.
DASH_FILTER_ID DOUBLE N PRIMARY KEY
DASH_ITEM_GROUP_ID DOUBLE N Foreign key to Dash_Item_Group 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.
FILTER_NAME VARCHAR(255) N Name of the Filter.
FILTER_TEMPLATE_NAME VARCHAR(255) N Name of the Filter Template.
LAST_UPDT_PRSNL_ID DOUBLE N person last updating the dashboard filter
ORG_ID DOUBLE N Foreign key to Organization table.
ORIG_DASH_FILTER_ID DOUBLE N Reference to Original Filter Record. Required for Versioning
SHIPPED_IND DOUBLE N True if shipped from Cerner.
TEMPLATE_IND DOUBLE N True if record represents a Template Filter.
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_FILTER


Child Column in DASH_FILTER(FK) Parent Table Name Parent Column Name
Parents: DASH_DASHBOARD_ID DASH_DASHBOARD DASH_DASHBOARD_ID
ORIG_DASH_FILTER_ID DASH_FILTER DASH_FILTER_ID
DASH_ITEM_GROUP_ID DASH_ITEM_GROUP DASH_ITEM_GROUP_ID
ORG_ID ORGANIZATION ORGANIZATION_ID
LAST_UPDT_PRSNL_ID PRSNL PERSON_ID




Parent Column in DASH_FILTER (PK) Child Table Name Child Column Name
Children: DASH_FILTER_ID DASH_FILTER ORIG_DASH_FILTER_ID


DASH_ITEM_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: DASHBOARD ITEM GROUPS
Definition: Dashboard Item Groups Table
Table Type: REFERENCE





Column Detail - DASH_ITEM_GROUP


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.
CONTENT_DATA_TXT VARCHAR(1000) N The Content of the Item Group
DASH_DASHBOARD_ID DOUBLE N Foreign key to Dashboard Table.
DASH_ITEM_GROUP_ID DOUBLE N PRIMARY KEY
GROUP_NAME VARCHAR(255) N Name of the Group.
LAST_UPDT_PRSNL_ID DOUBLE N Person last updating the item group
ORG_ID DOUBLE N Foreign key to Organization table.
SHIPPED_IND DOUBLE N True if shipped from Cerner.
TEMPLATE_IND DOUBLE N 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_ITEM_GROUP


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




Parent Column in DASH_ITEM_GROUP (PK) Child Table Name Child Column Name
Children: DASH_ITEM_GROUP_ID DASH_FILTER DASH_ITEM_GROUP_ID


DASH_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: DASHBOARD TYPE
Definition: Identifies the Dashboard Type and assigns a unique Name
Table Type: REFERENCE





Column Detail - DASH_TYPE


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.
DASH_TYPE_ID DOUBLE N PRIMARY KEY
DASH_TYPE_NAME VARCHAR(100) N Name of the Dashboard Type
ORG_ID DOUBLE N Foreign key to Organization 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 - DASH_TYPE


Child Column in DASH_TYPE(FK) Parent Table Name Parent Column Name
Parents: ORG_ID ORGANIZATION ORGANIZATION_ID




Parent Column in DASH_TYPE (PK) Child Table Name Child Column Name
Children: DASH_TYPE_ID DASH_DASHBOARD DASH_TYPE_ID
DASH_TYPE_COMPONENT_RELTN DASH_TYPE_ID


DASH_TYPE_COMPONENT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: DASHBOARD TYPE anb COMPONENT RELATIONS
Definition: Dashboard Type-Component Relationships table
Table Type: REFERENCE





Column Detail - DASH_TYPE_COMPONENT_RELTN


Column Name Type Null? Definition
DASH_COMPONENT_ID DOUBLE N Foreign key to Dashboard Component Table.
DASH_TYPE_COMPONENT_RELTN_ID DOUBLE N PRIMARY KEY
DASH_TYPE_ID DOUBLE N Foreign key to Dash_Type 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 - DASH_TYPE_COMPONENT_RELTN


Child Column in DASH_TYPE_COMPONENT_RELTN(FK) Parent Table Name Parent Column Name
Parents: DASH_COMPONENT_ID DASH_COMPONENT DASH_COMPONENT_ID
DASH_TYPE_ID DASH_TYPE DASH_TYPE_ID