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 |