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 |