Table Detail Report

SUBSCRPTN_FILTER_MSG_HIST



Column Section Top of Page


Table-level Detail

Description: Subscription Filter History
Definition: Subscription Filter History Information
Table Type: ACTIVITY





Column Detail - SUBSCRPTN_FILTER_MSG_HIST


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 FK VALUE FROM MSG_FYI_ASSIGNMENT
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.
PURGE_DT_TM DATETIME Y The Date and Time the SUBSCRIPTION_FILTER row was purged.
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.
SUBSCRPTN_FILTER_MSG_HIST_ID DOUBLE N Unique, generated number that is used to identify an individual row on the SUBSCRIPTION_FILTER_HISTORY table.
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.


SUBSCRPTN_FILTER_RESULTS_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Subscription Filter Results Relation
Definition: Relationship table joining the SUBSCRIPTION_NEW_RESULTS table with the MSG_FYI_FILTER table.
Table Type: ACTIVITY





Column Detail - SUBSCRPTN_FILTER_RESULTS_RELTN


Column Name Type Null? Definition
MSG_FYI_FILTER_ID DOUBLE N Unique, generated number that is used to identify an individual row on the MSG_FYI_FILTER table.
SUBSCRIPTION_NEW_RESULTS_ID DOUBLE N Unique, generated number that is used to identify an individual row on the SUBSCRIPTION_NEW_RESULTS table.
SUBSCRPTN_FILTER_RESULTS_R_ID DOUBLE N PRIMARY KEY
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 - SUBSCRPTN_FILTER_RESULTS_RELTN


Child Column in SUBSCRPTN_FILTER_RESULTS_RELTN(FK) Parent Table Name Parent Column Name
Parents: MSG_FYI_FILTER_ID MSG_FYI_FILTER MSG_FYI_FILTER_ID
SUBSCRIPTION_NEW_RESULTS_ID SUBSCRIPTION_NEW_RESULTS SUBSCRIPTION_NEW_RESULTS_ID


SUBSCRPTN_HIST



Column Section Top of Page


Table-level Detail

Description: Subscription History
Definition: Subscription History Information
Table Type: ACTIVITY





Column Detail - SUBSCRPTN_HIST


Column Name Type Null? Definition
ENCOUNTER_ID DOUBLE N ENCOUNTER VALUE
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.
PURGE_DT_TM DATETIME Y The Date and Time the subscription row was purged.
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.
SUBSCRPTN_HIST_ID DOUBLE N Unique, generated number that is used to identify an individual row on the SUBSCRIPTION_HISTORY 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.