Table Detail Report

MESSAGING_FAVORITES



Column Section Relationship Section Top of Page


Table-level Detail

Description: Messaging_Favorites
Definition: Stores favorite recipient lists for providers and patients. Favorites recipients can be associated with a variety of entity types (Pool, Personnel, Distribution List, Email, etc).
Table Type: ACTIVITY





Column Detail - MESSAGING_FAVORITES


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.
FAVORITE_ID DOUBLE N The ID of the table SEQUENCE NAME: CARENET_SEQ
FAVORITE_TYPE_CD DOUBLE N The type code value that indicates the type of favorite.
MODE_FLAG DOUBLE N the mode of which the favorites was established(either favorites was used for Inbox delivery, fax delivery, secure email delivery or mail delivery)
PARENT_ENTITY_ID DOUBLE N The ID of the parent entity related to the parent entity name.
PARENT_ENTITY_NAME VARCHAR(30) N The parent entity name that indicates the type of entity.
PERSON_ID DOUBLE N The person the favorite on this line is associated with.
PRSNL_GROUP_ID DOUBLE N The ID of the personnel group who the favorite is associated.
PRSNL_ID DOUBLE N The ID of the personnel who the favorite is associated.
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 - MESSAGING_FAVORITES


Child Column in MESSAGING_FAVORITES(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID
PRSNL_ID PRSNL PERSON_ID
PRSNL_GROUP_ID PRSNL_GROUP PRSNL_GROUP_ID


MESSAGING_NOTIFY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Messaging Notify
Definition: Stores receipt requests for notifications. Notifications can be associated with multiple receipt request types (OVERDUE, READ, COMPLET, etc).
Table Type: ACTIVITY





Column Detail - MESSAGING_NOTIFY


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.
ASSIGN_EMAIL_INFO_ID DOUBLE N The id of the EMAIL_INFO row containing information about the email recipient for whom a receipt request has been issued.
ASSIGN_PERSON_ID DOUBLE N The Id of the assigned person
ASSIGN_PRSNL_GROUP_ID DOUBLE N The Id of the assign personnel group
ASSIGN_PRSNL_ID DOUBLE N Assigned Personnel ID. FK from PRSNL table
DELAY_UNIT_FLAG DOUBLE N The unit of delay.
DELAY_VALUE DOUBLE N The amount of time to wait before generating a notify receipt if the notification has not yet attained the specified status.
MESSAGING_NOTIFY_ID DOUBLE N The ID of the table SEQUENCE NAME:CARENET_SEQ
NOTIFY_EMAIL_INFO_ID DOUBLE N The id of the EMAIL_INFO row containing information about the email sender to whom a receipt request should be sent.
NOTIFY_PRIORITY_CD DOUBLE N The code value that indicates the priority of the notify to be sent
NOTIFY_PRSNL_GROUP_ID DOUBLE N Personnel Group Id that will be notified.
NOTIFY_PRSNL_ID DOUBLE N Personnel Id of the person that will be notified
NOTIFY_TYPE_CD DOUBLE N The code value that indicates the reason that the notify will be sent
TASK_ID DOUBLE N The task Id/ Foreign_key from the task_activity 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 - MESSAGING_NOTIFY


Child Column in MESSAGING_NOTIFY(FK) Parent Table Name Parent Column Name
Parents: ASSIGN_EMAIL_INFO_ID EMAIL_INFO EMAIL_INFO_ID
NOTIFY_EMAIL_INFO_ID EMAIL_INFO EMAIL_INFO_ID
ASSIGN_PERSON_ID PERSON PERSON_ID
ASSIGN_PRSNL_ID PRSNL PERSON_ID
NOTIFY_PRSNL_ID PRSNL PERSON_ID
ASSIGN_PRSNL_GROUP_ID PRSNL_GROUP PRSNL_GROUP_ID
NOTIFY_PRSNL_GROUP_ID PRSNL_GROUP PRSNL_GROUP_ID
TASK_ID TASK_ACTIVITY TASK_ID


SUBSCRIPTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Subscription
Definition: Subscription information
Table Type: ACTIVITY





Column Detail - SUBSCRIPTION


Column Name Type Null? Definition
ENCOUNTER_ID DOUBLE N The ENCNTR_ID from the Encounter related to this subscriptoin
EXPIRATION_DT_TM DATETIME N The Date and Time the subscription is set to expire.
PERSON_ID DOUBLE N The ID of the Patient whom the Provider has a subscription with.
PROVIDER_ID DOUBLE N The ID of the Provider associated to the subscription.
SUBSCRIPTION_ID DOUBLE N Unique, generated number that is used to identify an individual row on the SUBSCRIPTION table.
SUBSCRIPTION_TYPE_FLAG DOUBLE N Identifies the type of subscription. Current values are 1 = (Message Center and 2 = IView."
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 - SUBSCRIPTION


Child Column in SUBSCRIPTION(FK) Parent Table Name Parent Column Name
Parents: ENCOUNTER_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID




Parent Column in SUBSCRIPTION (PK) Child Table Name Child Column Name
Children: SUBSCRIPTION_ID SUBSCRIPTION_FILTER_MSG SUBSCRIPTION_ID
SUBSCRIPTION_NEW_RESULTS SUBSCRIPTION_ID


SUBSCRIPTION_FILTER_MSG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Subscription Filter / MSG relationship
Definition: Subscription Filter / MSG information
Table Type: ACTIVITY





Column Detail - SUBSCRIPTION_FILTER_MSG


Column Name Type Null? Definition
ENCNTR_PRSNL_R_CD DOUBLE N The Encounter/Personnel relationship code indicating this type of relationship is being taken into consideration for the associated subscription.
EXPIRATION_DT_TM DATETIME N The Date and Time the associated Encounter/Personnel relationship or Person/Personnel relationship is set to expire.
HOLD_FLAG DOUBLE N The hold flag indicates if the subscription filter is on hold or activated. Hold Flag values are: 0 - No holds / activated, 1 - Holding for encounter discharge, 2 - User unsubscribed
MSG_FYI_ASSIGNMENT_ID DOUBLE N Unique, generated number that is used to identify an individual row on the MSG_FYI_ASSIGNMENT table.
PERSON_PRSNL_R_CD DOUBLE N The Person/Personnel relationship code indicating this type of relationship is being taken into consideration for the associated subscription.
SUBSCRIBE_DT_TM DATETIME Y The Date and Time the filter was subscribed to by the provider. Currently, only populated by ad hoc filters.
SUBSCRIPTION_FILTER_MSG_ID DOUBLE N Unique, generated number that is used to identify an individual row on the SUBSCRIPTION_FILTER_MSG table.
SUBSCRIPTION_ID DOUBLE N Unique, generated number that is used to identify an individual row on the SUBSCRIPTION 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 - SUBSCRIPTION_FILTER_MSG


Child Column in SUBSCRIPTION_FILTER_MSG(FK) Parent Table Name Parent Column Name
Parents: MSG_FYI_ASSIGNMENT_ID MSG_FYI_ASSIGNMENT MSG_FYI_ASSIGNMENT_ID
SUBSCRIPTION_ID SUBSCRIPTION SUBSCRIPTION_ID


SUBSCRIPTION_NEW_RESULTS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Clinical Event Subscription new results
Definition: New results associated to a subscription
Table Type: ACTIVITY





Column Detail - SUBSCRIPTION_NEW_RESULTS


Column Name Type Null? Definition
CLINSIG_UPDT_DT_TM DATETIME N The Date and Time the new result was created and/or had a clinically significant update occur. This corresponds to the CLINICAL_EVENT table's clinsig_updt_dt_tm field.
CREATED_DT_TM DATETIME N The Date and Time the new result was created.
EVENT_CLASS_CD DOUBLE N Coded value which specifies how the event is stored in and retrieved from the event table sub-tables
EVENT_ID DOUBLE N The ID of the clinical event associated to the new result.
EXPIRATION_DT_TM DATETIME N The Date and Time the new result is set to expire. This field will determine when the new result is to be purged.
SUBSCRIPTION_ID DOUBLE N Unique, generated number that is used to identify an individual row on the SUBSCRIPTION table.
SUBSCRIPTION_NEW_RESULTS_ID DOUBLE N Unique, generated number that is used to identify an individual row on the CE_NEW_RESULTS 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.
VIEW_STATUS_CD DOUBLE N This is the state in which the physician will like to view the result in future interactions.



Relationship Detail - SUBSCRIPTION_NEW_RESULTS


Child Column in SUBSCRIPTION_NEW_RESULTS(FK) Parent Table Name Parent Column Name
Parents: SUBSCRIPTION_ID SUBSCRIPTION SUBSCRIPTION_ID




Parent Column in SUBSCRIPTION_NEW_RESULTS (PK) Child Table Name Child Column Name
Children: SUBSCRIPTION_NEW_RESULTS_ID SUBSCRPTN_FILTER_RESULTS_RELTN SUBSCRIPTION_NEW_RESULTS_ID