NC_CHARTED_SECTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Nursing - Charting View
Definition: Maintains activity of a charting section.
Table Type: ACTIVITY





Column Detail - NC_CHARTED_SECTION


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.
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_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
CHARTED_SECTION_CLOB LONGTEXT Y A JSON formatted string containing the representation of the charted section activity.
CLINICAL_DT_TM DATETIME Y The clinically relevent date of the charted section.
CLOB_TYPE_FLAG DOUBLE N Represents the type of data stored in the JSON clob.
CLOUD_CHARTING_SECTION_IDENT VARCHAR(255) N Represents the cloud reference identifier for the charting section.
CREATE_DT_TM DATETIME Y Thd date and time this row was created.
CREATE_PRSNL_ID DOUBLE N The personnel ID of the person who created the row in the table
ENCNTR_ID DOUBLE N The patient's encounter associated to the section.
LAST_UPDT_DT_TM DATETIME Y Last date and time this row was updated.
LAST_UPDT_PRSNL_ID DOUBLE N The personnel that last updated the data on this row.
NC_CHARTED_SECTION_ID DOUBLE N Unique, generated number that identifies a single row on the NC_CHARTED_SECTION table.
NC_CHARTED_VIEW_ID DOUBLE Y The Charted View that owns this section.;
NC_CHARTING_SECTION_ID DOUBLE N Identifier of the charting section reference data.
PATIENT_ID DOUBLE N The patient associated to the section.
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 - NC_CHARTED_SECTION


Child Column in NC_CHARTED_SECTION(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
NC_CHARTED_VIEW_ID NC_CHARTED_VIEW NC_CHARTED_VIEW_ID
NC_CHARTING_SECTION_ID NC_CHARTING_SECTION NC_CHARTING_SECTION_ID
PATIENT_ID PERSON PERSON_ID
CREATE_PRSNL_ID PRSNL PERSON_ID
LAST_UPDT_PRSNL_ID PRSNL PERSON_ID




Parent Column in NC_CHARTED_SECTION (PK) Child Table Name Child Column Name
Children: NC_CHARTED_SECTION_ID NC_CHARTED_SECTION_CE_R NC_CHARTED_SECTION_ID


NC_CHARTED_SECTION_CE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Nursing Charting - Charted Section Clinical Event Relation
Definition: Relates Charted Sections to the Clinical Event values that they contain.
Table Type: ACTIVITY





Column Detail - NC_CHARTED_SECTION_CE_R


Column Name Type Null? Definition
EVENT_ID DOUBLE N The clinical event that belongs to the Charted Section.
NC_CHARTED_SECTION_CE_R_ID DOUBLE N Unique generated number that identifies a single row on the NC_CHARTED_SECTON_CE_R table.
NC_CHARTED_SECTION_ID DOUBLE N The Charted Section that the associated Event_id belongs to.
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 - NC_CHARTED_SECTION_CE_R


Child Column in NC_CHARTED_SECTION_CE_R(FK) Parent Table Name Parent Column Name
Parents: NC_CHARTED_SECTION_ID NC_CHARTED_SECTION NC_CHARTED_SECTION_ID


NC_CHARTED_VIEW



Column Section Relationship Section Top of Page


Table-level Detail

Description: Nursing Charting - Charted View
Definition: Used to maintain activity details of a charting view.
Table Type: ACTIVITY





Column Detail - NC_CHARTED_VIEW


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.
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_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
CE_DRAFT_ID DOUBLE Y The identifier of the clinical event draft for the charted view.
CHARTED_VIEW_CLOB LONGTEXT Y A JSON formatted string containing the representation of the charted view activity.
CHARTING_VIEW_DISP VARCHAR(255) Y Stores the label of the charting view, if a label is defined. Otherwise, stores the name of the charting view. This is either pulled from NC_CHARTING_VIEW (Quick Chart solution) or an external cloud database (Integrated Charting).
CLINICAL_DT_TM DATETIME Y The clinically relevent date of the charted view.
CLOUD_CHARTING_VIEW_IDENT VARCHAR(255) N Represents the cloud reference identifier for the charting view.
CREATE_DT_TM DATETIME Y Thd date and time this row was created.
CREATE_PRSNL_ID DOUBLE N The personnel ID of the person who created the row in the table
DRAFT_STATUS_TFLG VARCHAR(15) Y The status text of the draft for the charted view.; Values: NOT_STARTED, IN_PROGRESS;
DRAFT_UPDT_DT_TM DATETIME Y The date and time the draft for the charted view was updated.
ENCNTR_ID DOUBLE N The identifier of the patient's encounter associated to the charted view.
INACTIVE_NOTIFICATION_DT_TM DATETIME Y The date time an inactive notification was sent for the charted view.
LAST_UPDT_DT_TM DATETIME Y Last date and time this row was updated.
LAST_UPDT_PRSNL_ID DOUBLE N The personnel that last updated the data on this row.
NC_CHARTED_VIEW_ID DOUBLE N Unique, generated number that identifies a single row on the NC_CHARTED_VIEW table.
NC_CHARTING_VIEW_ID DOUBLE N The identifier of the charting view reference data.
NOTE_EVENT_ID DOUBLE Y The identifier of the note event for the charted view.
NOTE_STATUS_CD DOUBLE Y The status code of the note for the charted view.
NOTE_TYPE_CD DOUBLE Y The type code of the note for the charted view.
PATIENT_ID DOUBLE N The patient associated to the view.
SCRATCHPAD_DRAFT_ID DOUBLE Y The identifier of the scratchpad draft for the charted view.;
STATUS_CD DOUBLE N The status of the charted view
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.
VERSION_NBR DOUBLE Y The version of the charted view schema.



Relationship Detail - NC_CHARTED_VIEW


Child Column in NC_CHARTED_VIEW(FK) Parent Table Name Parent Column Name
Parents: CE_DRAFT_ID CE_DRAFT CE_DRAFT_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
NC_CHARTING_VIEW_ID NC_CHARTING_VIEW NC_CHARTING_VIEW_ID
SCRATCHPAD_DRAFT_ID NURSING_ENCNTR_SCRATCHPAD NURSING_ENCNTR_SCRATCHPAD_ID
PATIENT_ID PERSON PERSON_ID
CREATE_PRSNL_ID PRSNL PERSON_ID
LAST_UPDT_PRSNL_ID PRSNL PERSON_ID




Parent Column in NC_CHARTED_VIEW (PK) Child Table Name Child Column Name
Children: NC_CHARTED_VIEW_ID NC_CHARTED_SECTION NC_CHARTED_VIEW_ID


NC_CHARTING_SECTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Nursing Charting - Charting Section
Definition: A charting section is a collection of charting elements. The elements represent the documentation that is captured as part of clinicians providing patient care. A section represents the collection of elements that need documented for a particular workflow. An example would be a Vitals section which would contain elements such as Heart Rate, Blood Pressure, and Respiratory Rate. The table includes the section name along with a JSON formatted string containing the grouping of charting ele
Table Type: REFERENCE





Column Detail - NC_CHARTING_SECTION


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 Y 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.
CHARTING_SECTION_CLOB LONGTEXT Y A JSON formatted string containing the representation of the charting section. This includes the grouping of charting elements in the section along with additional meta data.
CREATE_DT_TM DATETIME Y Contains the date and time the section was created.
CREATE_PRSNL_ID DOUBLE N The person responsible for inserting this row on the table
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.
NC_CHARTING_SECTION_ID DOUBLE N Unique, generated number that identifies a single row on the NC_CHARTING_SECTION table.
ORIG_NC_CHARTING_SECTION_ID DOUBLE N This field is used to track versions of the Charting Sections. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times.
SECTION_NAME VARCHAR(255) N The name displayed for the section.
SECTION_NAME_KEY VARCHAR(255) N This field contains the section_name value with all special characters removed and all alpha characters converted to upper case.
SECTION_NAME_KEY_A_NLS VARCHAR(1020) N Stores the corresponding non-English character set values for the section_name_key column. Used to sort correctly internationally.
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 - NC_CHARTING_SECTION


Child Column in NC_CHARTING_SECTION(FK) Parent Table Name Parent Column Name
Parents: ORIG_NC_CHARTING_SECTION_ID NC_CHARTING_SECTION NC_CHARTING_SECTION_ID
CREATE_PRSNL_ID PRSNL PERSON_ID




Parent Column in NC_CHARTING_SECTION (PK) Child Table Name Child Column Name
Children: NC_CHARTING_SECTION_ID NC_CHARTED_SECTION NC_CHARTING_SECTION_ID
NC_CHARTING_SECTION ORIG_NC_CHARTING_SECTION_ID


NC_CHARTING_VIEW



Column Section Relationship Section Top of Page


Table-level Detail

Description: Nursing Charting - Charting View
Definition: A charting view is a collection of charting sections. A view would represent a set of sections that need documented for a particular workflow. An example would be an Adult Admissions view that contains sections for Vitals, Weight, and Safety. The table includes the view name along with a JSON formatted string containing the grouping of charting sections within the view.
Table Type: REFERENCE





Column Detail - NC_CHARTING_VIEW


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 Y 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.
CHARTING_VIEW_CLOB LONGTEXT Y A JSON formatted string containing the representation of the charting view. This includes the grouping of charting sections in the view along with additional meta data.
CREATE_DT_TM DATETIME Y Contains the date and time the view was created.
CREATE_PRSNL_ID DOUBLE N The person responsible for inserting this row on the table
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.
NC_CHARTING_VIEW_ID DOUBLE N Unique, generated number that identifies a single row on the NC_CHARTING_VIEW table.
ORIG_NC_CHARTING_VIEW_ID DOUBLE N This field is used to track versions of the Charting Views. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times.
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.
VIEW_NAME VARCHAR(255) N Name that is displayed for the view.
VIEW_NAME_KEY VARCHAR(255) N This field contains the view_name value with all special characters removed and all alpha characters converted to upper case.
VIEW_NAME_KEY_A_NLS VARCHAR(1020) N Stores the corresponding non-English character set values for the view_name_key column. Used to sort correctly internationally.



Relationship Detail - NC_CHARTING_VIEW


Child Column in NC_CHARTING_VIEW(FK) Parent Table Name Parent Column Name
Parents: ORIG_NC_CHARTING_VIEW_ID NC_CHARTING_VIEW NC_CHARTING_VIEW_ID
CREATE_PRSNL_ID PRSNL PERSON_ID




Parent Column in NC_CHARTING_VIEW (PK) Child Table Name Child Column Name
Children: NC_CHARTING_VIEW_ID NC_CHARTED_VIEW NC_CHARTING_VIEW_ID
NC_CHARTING_VIEW ORIG_NC_CHARTING_VIEW_ID