MESSAGE_TYPE_TEMPLATE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Message-Type Template Relatioin
Definition: Stores the association between a message type and its associated templates
Table Type: REFERENCE





Column Detail - MESSAGE_TYPE_TEMPLATE_RELTN


Column Name Type Null? Definition
DEFAULT_IND DOUBLE N This is to indicate which template is the default for a given message type
MED_IND DOUBLE N This indicator is going to decide whether the message is going to route to the renewal request folder or not. 0 - don't route1 - route
MESSAGE_TYPE_CD DOUBLE N The Message Type Cd for the message type that has an associated template
MESSAGE_TYPE_TEMPLATE_RELTN_ID DOUBLE N Primary key to index an association between a message type and a template
TEMPLATE_ID DOUBLE N The Template Id for the Template that has an association to the message type. FK from Clinical Note Template.
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 - MESSAGE_TYPE_TEMPLATE_RELTN


Child Column in MESSAGE_TYPE_TEMPLATE_RELTN(FK) Parent Table Name Parent Column Name
Parents: TEMPLATE_ID CLINICAL_NOTE_TEMPLATE TEMPLATE_ID
MESSAGE_TYPE_CD CODE_VALUE CODE_VALUE


MSG_DOC_FAVORITES



Column Section Relationship Section Top of Page


Table-level Detail

Description: MSG DOC FAVORITES
Definition: To store document type ids at user or position level
Table Type: ACTIVITY





Column Detail - MSG_DOC_FAVORITES


Column Name Type Null? Definition
MSGTYPE_CD DOUBLE N Message Type code for (Message/Reminder/Consult/Letter)
MSG_DOC_FAVORITES_ID DOUBLE N Unique generated number that identifies a single row on the MSG_DOC_FAVORITES table.
NOTE_ID DOUBLE N Favorite document type ID for this Personnel or Position
POSITION_CD DOUBLE N Position Code of the Personnel
PRSNL_ID DOUBLE N Personnel ID
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 - MSG_DOC_FAVORITES


Child Column in MSG_DOC_FAVORITES(FK) Parent Table Name Parent Column Name
Parents: NOTE_ID NOTE_TYPE NOTE_TYPE_ID
PRSNL_ID PRSNL PERSON_ID


MSG_FYI_ASSIGNMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: MSG_FYI_ASSIGNMENT
Definition: Stores which users or positions are assigned to a set of FYI filters. FYI filters determine which new results will be routed to a physician's inbox.
Table Type: REFERENCE





Column Detail - MSG_FYI_ASSIGNMENT


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.
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.
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.
MSG_FYI_ASSIGNMENT_ID DOUBLE N Primary key
MSG_FYI_FILTER_ID DOUBLE N The filter assigned to the personnel or position
POSITION_CD DOUBLE N The position assigned to the filter. PRSNL_ID will be zero if this field is non-zero.
PRSNL_ID DOUBLE N The personnel assigned to the filter. POSITION_CD will be zero if this field is non-zero.
SUBS_APPLIED_IND DOUBLE N One (1) indicates that applicable subscriptions were successfully updated when the assignment was created. A zero indicates the user should be notified that some of the subscriptions were not created and should be corrected.
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 - MSG_FYI_ASSIGNMENT


Child Column in MSG_FYI_ASSIGNMENT(FK) Parent Table Name Parent Column Name
Parents: MSG_FYI_FILTER_ID MSG_FYI_FILTER MSG_FYI_FILTER_ID




Parent Column in MSG_FYI_ASSIGNMENT (PK) Child Table Name Child Column Name
Children: MSG_FYI_ASSIGNMENT_ID SUBSCRIPTION_FILTER_MSG MSG_FYI_ASSIGNMENT_ID


MSG_FYI_FILTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: MSG_FYI_FILTER
Definition: Holds basic information on a results FYI filter. These filters determine which new results will automatically display in the physician's inbox.
Table Type: REFERENCE





Column Detail - MSG_FYI_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.
ENCNTR_INCL_IND DOUBLE N One indicates associated encounters should be included, not excluded
EVENT_INCL_IND DOUBLE N One indicates associated encounters should be included, not excluded
FILTER_CREATE_DT_TM DATETIME N Date the filter was created
FILTER_DESC VARCHAR(40) Y Optional description of the filter
FILTER_END_DT_TM DATETIME N Date the filter was no longer assigned to any user or position
FILTER_NAME VARCHAR(40) N Name of the filter
FILTER_OWNER_ID DOUBLE N The prsnl_id of the user that owns the filter. This value will be zero if the filter is public.
FILTER_TYPE_FLAG DOUBLE N Indicates the type of fyi filter, 0 - relation, 1 - ad hoc
LATE_POSTING_FLAG DOUBLE N Affects results posted after the associated relationships end. Zero indicates late postings will not be included. One indicates late postings will be included. Two indicates only late postings will be shown.
MSG_FYI_FILTER_ID DOUBLE N Primary Key
PUBLIC_IND DOUBLE N One indicates the filter is public / shared
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 - MSG_FYI_FILTER




Parent Column in MSG_FYI_FILTER (PK) Child Table Name Child Column Name
Children: MSG_FYI_FILTER_ID MSG_FYI_ASSIGNMENT MSG_FYI_FILTER_ID
MSG_FYI_FILTER_DTL MSG_FYI_FILTER_ID
SUBSCRPTN_FILTER_RESULTS_RELTN MSG_FYI_FILTER_ID


MSG_FYI_FILTER_DTL



Column Section Relationship Section Top of Page


Table-level Detail

Description: MSG_FYI_FILTER_DTL
Definition: Holds detailed information on a results FYI filter. These filters determine which new results will automatically display in the physician's inbox.
Table Type: REFERENCE





Column Detail - MSG_FYI_FILTER_DTL


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.
FILTER_TYPE_CD DOUBLE N Value from code set 3414 that represents the type of filter. Can be lifetime relation, encounter relation, encounter, or event.
FILTER_VALUE_CD DOUBLE N Holds the encounter or relation code value from code sets 331, 333, or 71 to be filtered. Will be zero when the filter type code is event.
FILTER_VALUE_TXT VARCHAR(100) Y Holds the event set name being filtered. Only populated when the filter type code is event.
MSG_FYI_FILTER_DTL_ID DOUBLE N Primary key
MSG_FYI_FILTER_ID DOUBLE N The filter associated with this detail
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 - MSG_FYI_FILTER_DTL


Child Column in MSG_FYI_FILTER_DTL(FK) Parent Table Name Parent Column Name
Parents: MSG_FYI_FILTER_ID MSG_FYI_FILTER MSG_FYI_FILTER_ID