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 |