Table Detail Report
SUMMARY_SECTION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Summary Section |
Definition: | The Summary Section table defines the subject area of the section within the Summary Sheet. |
Table Type: | REFERENCE |
Column Detail - SUMMARY_SECTION
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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 | Y | 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. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | 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. |
COMMENT_TEXT | VARCHAR(255) | Y | Not Used. |
DISPLAY | VARCHAR(40) | Y | The user-defined name for the section. |
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. |
MAX_QUAL | DOUBLE | Y | Not Used. |
PRSNL_ID | DOUBLE | N | The unique personnel identifier of the person that the section is assigned to. |
SCRIPT | VARCHAR(50) | Y | Not Used. |
SECTION_ID | DOUBLE | N | Unique identifier for the summary section table. |
SECTION_TYPE_CD | DOUBLE | N | Defines what the section format is, e.g. header or body. |
SORTABLE_IND | DOUBLE | Y | Indicates whether the section can be sorted. |
SUBJECT_AREA_CD | DOUBLE | N | Defines the domain of the data within the section. |
TMPL_SECTION_ID | DOUBLE | N | The original section_id that was used to create this section. |
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 - SUMMARY_SECTION
Child Column in SUMMARY_SECTION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SUBJECT_AREA_CD | CODE_VALUE | CODE_VALUE |
SUMMARY_SECTION_R
Column Section | Top of Page |
Table-level Detail
Description: | Summary Section Relation |
Definition: | The Summary Section Relationship table defines the order of the sections to appear on the Summary Sheet. |
Table Type: | REFERENCE |
Column Detail - SUMMARY_SECTION_R
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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 | Y | 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. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | 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. |
DEFAULT_EXPAND_IND | DOUBLE | Y | Determines whether the section is defaulted as opened when the summary sheet displays. |
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. |
SECTION_ID | DOUBLE | N | The unique identifier that defines a section. |
SEQUENCE | DOUBLE | N | Defines the order that the sections are displayed on the summary sheet. |
SUMMARY_SHEET_ID | DOUBLE | N | The unique identifier that defines the summary sheet. |
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. |
SUMMARY_SHEET
Column Section | Top of Page |
Table-level Detail
Description: | Summary Sheet |
Definition: | The Summary Sheet table is used to define a template, or format, to view patient information, eg. demographics, problems, allergies, orders, etc. |
Table Type: | REFERENCE |
Column Detail - SUMMARY_SHEET
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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 | Y | 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. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | 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. |
DESCRIPTION | VARCHAR(60) | Y | Description of the summary sheet format. |
DISPLAY | VARCHAR(40) | Y | Short display of the summary sheet. |
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. |
PRSNL_ID | DOUBLE | N | The unique identifier from the personnel table. |
SUMMARY_SHEET_ID | DOUBLE | N | Unique identifier for the summary sheet table. |
TMPL_SUMMARY_ID | DOUBLE | N | The original summary sheet that the personal copy was created from. |
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. |
TERM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Term |
Definition: | Each row in the Term table represents a special form of a string, eg. eponym, acronym, tradename, laboratory number, etc. For English language entries, each string is linked to all of its lexical variants or minor variations by means of a common term ide |
Table Type: | REFERENCE |
Column Detail - TERM
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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 | Y | 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. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | 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. |
CONCEPT_IDENTIFIER | VARCHAR(242) | Y | A unique identifier supplied from Cerner or other external database and is persistent once it is assigned to a concept. All Cerner assigned concept identifiers are created from the CONCEPT_SEQ. The sequence number is formatted to an 8-byte number padded |
CONCEPT_SOURCE_CD | DOUBLE | N | Represents the external source that owns the concept_identifier. |
DATA_STATUS_CD | DOUBLE | N | Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED. |
DATA_STATUS_DT_TM | DATETIME | Y | The date and time that the data_status_cd was set. |
DATA_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the data_status_cd to be set or change. |
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. |
TERM_ID | DOUBLE | N | This is the value of the unique primary identifier of the term table. It is an internal system assigned number. |
TERM_IDENTIFIER | CHAR(18) | Y | A unique identifier supplied from Cerner or other external database and is persistent once it is assigned to a term. |
TERM_SOURCE_CD | DOUBLE | N | Represents the external source that owns the term_identifier. |
TERM_STATUS_CD | DOUBLE | N | Indication of whether the term is the preferred name of the concept or a synonym. Each language has its own preferred term. |
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 - TERM
Parent Column in TERM (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | TERM_ID | NOMENCLATURE | TERM_ID |
THERAPTC_CAT_ITEM_LOAD
Column Section | Top of Page |
Table-level Detail
Description: | THERAPEUTIC CAT ITEM LOAD |
Definition: | Load table for taking 3rd party content and uploading to THERAPEUTIC_CAT_ITEM table. Community tables we truncate and reload in house, and ship to clients, to load 3rd party content without downtime. |
Table Type: | REFERENCE |
Column Detail - THERAPTC_CAT_ITEM_LOAD
Column Name | Type | Null? | Definition |
---|---|---|---|
CHILD_EXTERNAL_IDENT | VARCHAR(255) | N | 2nd Column of Primary Key (2 of 2) |
PARENT_EXTERNAL_IDENT | VARCHAR(255) | N | 1st Column of Primary Key (1 of 2) |
SOURCE_VOCAB_MEAN | VARCHAR(12) | N | CDF Meaning of Source Vocabulary. To be able to use these tables for other terminologies besides SNOMED in the future |
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. |