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 |