Table Detail Report

NOTE_TYPE_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: List personal and role based list of note types
Definition: note type list
Table Type: REFERENCE





Column Detail - NOTE_TYPE_LIST


Column Name Type Null? Definition
ENCNTR_TYPE_CLASS_CD DOUBLE N Identifies the encounter type class code to which this list is associated. If 0, then the list belongs to either an individual identified by prsnlid or role identified by the role_type_cd.
NOTE_TYPE_ID DOUBLE N Foreign Key to note_type table
NOTE_TYPE_LIST_ID DOUBLE N unique primary key to note_type_list table
PRSNL_ID DOUBLE N Foreign key to prsnl table. Identifies the person whose list this item belongs to. if 0 then this item belongs to a role based list
ROLE_TYPE_CD DOUBLE N identifies the role to which this list is associated if 0 then the list belongs to an individual identified by prsnl_id
SEQ_NUM DOUBLE Y orders elements of a given list
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_TYPE_LIST


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


NOTE_TYPE_SCR_PATTERN_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Note Type and SCR Pattern Relationship table
Definition: It defines the relationships between tables NOTE_TYPE and SCR_PATTERN.
Table Type: REFERENCE





Column Detail - NOTE_TYPE_SCR_PATTERN_RELTN


Column Name Type Null? Definition
NOTE_TYPE_ID DOUBLE N This serves as a foreign key to the NOTE_TYPE table.
NOTE_TYPE_SCR_PATTERN_RELTN_ID DOUBLE N Unique Identifier for this table
SCR_PATTERN_CKI_IDENTIFIER VARCHAR(50) Y External identifier for a pattern, used with SCR_PATTERN_CKI_SOURCE to form an external identifier.
SCR_PATTERN_CKI_SOURCE CHAR(12) Y External source for thiss pattern, used with SCR_PATTERN_CKI_ID to form an external identifier.
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_TYPE_SCR_PATTERN_RELTN


Child Column in NOTE_TYPE_SCR_PATTERN_RELTN(FK) Parent Table Name Parent Column Name
Parents: NOTE_TYPE_ID NOTE_TYPE NOTE_TYPE_ID


NOTE_TYPE_TEMPLATE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table relates a note type with a clinical note template.
Definition: note_type_template_reltn
Table Type: REFERENCE





Column Detail - NOTE_TYPE_TEMPLATE_RELTN


Column Name Type Null? Definition
DEFAULT_IND DOUBLE Y if value of 1 the template is the default template for the associated script.
NOTE_TYPE_ID DOUBLE N Foreign key to note_type table
NOTE_TYPE_TEMPLATE_RELTN_ID DOUBLE N unique primary key to table.
TEMPLATE_ID DOUBLE N Foreign key to 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 - NOTE_TYPE_TEMPLATE_RELTN


Child Column in NOTE_TYPE_TEMPLATE_RELTN(FK) Parent Table Name Parent Column Name
Parents: TEMPLATE_ID CLINICAL_NOTE_TEMPLATE TEMPLATE_ID
NOTE_TYPE_ID NOTE_TYPE NOTE_TYPE_ID




Parent Column in NOTE_TYPE_TEMPLATE_RELTN (PK) Child Table Name Child Column Name
Children: NOTE_TYPE_TEMPLATE_RELTN_ID PRSNL_LOC_TEMPLATE_RELTN NOTE_TYPE_TEMPLATE_RELTN_ID


PDOC_ASSESSPLAN_CONTENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Physician Documentation Assesment Plan Content
Definition: Used to link the assessment-and-plan ; workflow component content to clinical events.
Table Type: ACTIVITY





Column Detail - PDOC_ASSESSPLAN_CONTENT


Column Name Type Null? Definition
EVENT_ID DOUBLE N Reference to the CLINICAL_EVENT.EVENT_ID. ; Identifier of the document (MDOC) that contains the given diagnosis or comment.
NOMENCLATURE_ID DOUBLE N Reference to NOMENCLATURE.NOMENCLATURE_ID. If the value is NULL, the Assessment&Plan comment is referred.
PDOC_ASSESSPLAN_CONTENT_ID DOUBLE N Unique generated number that identifies a single row on the PDOC_ASSESSPLAN_CONTENT table.
SERVICE_DT_TM DATETIME Y Service Date Time of the Document that contains given diagnosis or comment
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 - PDOC_ASSESSPLAN_CONTENT


Child Column in PDOC_ASSESSPLAN_CONTENT(FK) Parent Table Name Parent Column Name
Parents: NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID


PDOC_NOTE_TYPE_PREF_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Physician Documentation Note Type Preference Relationship
Definition: This table captures groupings of note type for use in Bedrock configuration.
Table Type: REFERENCE





Column Detail - PDOC_NOTE_TYPE_PREF_R


Column Name Type Null? Definition
CONTEXT_NAME VARCHAR(255) N The context under which the preference name is established, for example "DEFAULT", "POSITION", or "FACILITY".
NOTE_TYPE_ID DOUBLE N A note type related a preference.
PARENT_ENTITY_ID DOUBLE Y The context table id under which the preference name is established. Will be null for the default context.
PARENT_ENTITY_NAME VARCHAR(30) Y The context table name under which the preference name is established. Will be null for the default context.
PDOC_NOTE_TYPE_PREF_R_ID DOUBLE N Unique, generated number that identifies a single row on the PDOC_NOTE_TYPE_PREF_R table.
PREF_NAME VARCHAR(255) N The name of the preference related to the note type.
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 - PDOC_NOTE_TYPE_PREF_R


Child Column in PDOC_NOTE_TYPE_PREF_R(FK) Parent Table Name Parent Column Name
Parents: NOTE_TYPE_ID NOTE_TYPE NOTE_TYPE_ID