CLINICAL_NOTE_TEMPLATE



Column Section Relationship Section Top of Page


Table-level Detail

Description: List of all templates that may be inserted into a Clinical Document
Definition: Clinical Document Templates
Table Type: REFERENCE





Column Detail - CLINICAL_NOTE_TEMPLATE


Column Name Type Null? Definition
CKI VARCHAR(255) Y CKI ofd the template. It combines CKI source and CKI identifier.
LONG_BLOB_ID DOUBLE N to long blob table where template is stored
OWNER_TYPE_FLAG DOUBLE N indicates if the template is a personal template or available for public use
PRSNL_ID DOUBLE N Identifies the owner of the template if marked as personal template
SMART_TEMPLATE_CD DOUBLE Y The code of the smart template report to run
SMART_TEMPLATE_IND DOUBLE Y Indicates whether to use a smart template
TEMPLATE_ACTIVE_IND DOUBLE Y Identifies if the template is currently active
TEMPLATE_ID DOUBLE N Unique primary key to table.
TEMPLATE_NAME VARCHAR(200) N name of 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 - CLINICAL_NOTE_TEMPLATE


Child Column in CLINICAL_NOTE_TEMPLATE(FK) Parent Table Name Parent Column Name
Parents: LONG_BLOB_ID LONG_BLOB LONG_BLOB_ID




Parent Column in CLINICAL_NOTE_TEMPLATE (PK) Child Table Name Child Column Name
Children: TEMPLATE_ID DD_REF_TMPLT_CN_TMPLT_R CLINICAL_NOTE_TEMPLATE_ID
MESSAGE_TYPE_TEMPLATE_RELTN TEMPLATE_ID
NOTE_TYPE_TEMPLATE_RELTN TEMPLATE_ID
TEMPLATE_KEYWORD_RELTN TEMPLATE_ID


EXPIRE_RULE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Expire Rule
Definition: Expire Rule
Table Type: ACTIVITY





Column Detail - EXPIRE_RULE


Column Name Type Null? Definition
ACTIVE_DT_TM DATETIME N Active Date/Time for expire rule
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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
AUTHENTIC_FLAG_IND DOUBLE Y Authentic flag indicator
EXPIRE_RULE_ID DOUBLE N Unique id to identify each rule.
OBSOLETE_IND DOUBLE Y Define deleted row.
PRSNL_ID DOUBLE N Personnel id
RULE_DT_TM DATETIME N Expire Rule Date/Time
RULE_NAME VARCHAR(250) N Expire Rule Name
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 - EXPIRE_RULE


Child Column in EXPIRE_RULE(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID


NOTE_PHRASE



Column Section Relationship Section Top of Page


Table-level Detail

Description: NOTE PHRASE
Definition: The purpose of this table is to information about user & system defined abbreviations that can be used to automatically insert text (generated from user/system defined queries). This table will store the abbreviation and a brief description of what will be inserted. The NOTE_PHRASE_COMP table will store information about what queries need to be run.
Table Type: REFERENCE





Column Detail - NOTE_PHRASE


Column Name Type Null? Definition
ABBREVIATION VARCHAR(40) N Shortcut text
ABB_DESCRIPTION VARCHAR(255) Y Brief description of what will be inserted in place of the abbreviation
NOTE_PHRASE_ID DOUBLE N Unique Phrase ID
PRSNL_ID DOUBLE N ID of user that owns this abbreviation. The system owns abbreviations where this ID is 0.
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 - NOTE_PHRASE


Child Column in NOTE_PHRASE(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID




Parent Column in NOTE_PHRASE (PK) Child Table Name Child Column Name
Children: NOTE_PHRASE_ID NOTE_PHRASE_COMP NOTE_PHRASE_ID
NOTE_PHRASE_FAVORITE NOTE_PHRASE_ID
NOTE_PHRASE_LABEL NOTE_PHRASE_ID


NOTE_PHRASE_COMP



Column Section Relationship Section Top of Page


Table-level Detail

Description: NOTE PHRASE COMPONENT
Definition: This table will store information about a single value that needs to be retrieved when inserting text in place of a NOTE_PHRASE abbreviation.
Table Type: REFERENCE





Column Detail - NOTE_PHRASE_COMP


Column Name Type Null? Definition
FKEY_ID DOUBLE N Name of the ID where the value is stored.
FKEY_NAME VARCHAR(80) N Name of the table where the value is stored. Possible values are CODE_VALUE, LONG_BLOB_REFERENCE, CLINICAL_NOTE_TEMPLATE.
FORMAT_CD DOUBLE N Identifies the destination format of this note_phrase_comp. (HTML or RTF). A note phrase component is part of an auto-text entry. It is possible to store 2 versions of a particular note-phrase-comp at a particular sequence: an HTML version and an RTF version.
NOTE_PHRASE_COMP_ID DOUBLE N Unique Phrase Comp ID
NOTE_PHRASE_ID DOUBLE N Relates a Note Phrase Component to a Note Phrase
SEQUENCE DOUBLE N Sequence of how the inserted text is generated.
SYSTEM_GENERATED_IND DOUBLE N Indicates if the note phrase component was generated by the system or by a user.
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 - NOTE_PHRASE_COMP


Child Column in NOTE_PHRASE_COMP(FK) Parent Table Name Parent Column Name
Parents: NOTE_PHRASE_ID NOTE_PHRASE NOTE_PHRASE_ID


NOTE_PHRASE_DROP_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Note Phrase Drop List
Definition: This is the grouper table for auto text drop lists. A drop list is a pre-described list of items that a user can choose from. These are most often found embeded in an auto text phrase.
Table Type: REFERENCE





Column Detail - NOTE_PHRASE_DROP_LIST


Column Name Type Null? Definition
DROP_LIST_UUID VARCHAR(40) N Unique non-domain specific identifier that identifies a single row on the NOTE_PHRASE_DROP_LIST table.
MULTI_SELECT_IND DOUBLE Y Indicator whether more then one drop list item can be selected.
NOTE_PHRASE_DROP_LIST_ID DOUBLE N Unique generated number that identifies a single row on the NOTE_PHRASE_DROP_LIST 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.



Relationship Detail - NOTE_PHRASE_DROP_LIST




Parent Column in NOTE_PHRASE_DROP_LIST (PK) Child Table Name Child Column Name
Children: NOTE_PHRASE_DROP_LIST_ID NOTE_PHRASE_DROP_LIST_ITEM NOTE_PHRASE_DROP_LIST_ID