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.