Table Detail Report

PROVIDER_TAXONOMY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Taxonomy reference code information
Definition: Contains provider taxonomy reference code information
Table Type: REFERENCE





Column Detail - PROVIDER_TAXONOMY


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.
CLASSIFICATION_CD DOUBLE N This represents the 2 character taxonomy classification code.
END_EFFECTIVE_DT_TM DATETIME Y 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.
PROVIDER_TYPE_CD DOUBLE N This represents the 2 character taxonomy provider code.
SPECIALIZATION_CD DOUBLE N This represents the 5 character area of specialization taxonomy code.
TAXONOMY VARCHAR(10) N A 10 character alphanumeric field comprised of a provider code, classification code, area of specialization code, and tertiary value.
TAXONOMY_ID DOUBLE N This is the value of the unique primary identifier of the taxonomy table. It is an internal system assigned number.
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 - PROVIDER_TAXONOMY




Parent Column in PROVIDER_TAXONOMY (PK) Child Table Name Child Column Name
Children: TAXONOMY_ID AUTHORIZATION TAXONOMY_ID
EEM_PROV_TAX_RELTN TAXONOMY_ID


SECTION_ATTRIBUTE



Column Section Top of Page


Table-level Detail

Description: Section Attribute
Definition: The Section Attribute defines the subject area detail attributes that are defined by the section.
Table Type: REFERENCE





Column Detail - SECTION_ATTRIBUTE


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.
COLUMN_NUM DOUBLE N Defines the column that the attribute is displayed.
DETAIL_SEQUENCE DOUBLE N Defines the order of the attributes within the column.
DETAIL_TYPE_CD DOUBLE N Defines the attribute as a literal or a codified attribute.
DETAIL_VALUE VARCHAR(255) Y The value of the literal.
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.
HEIGHT DOUBLE Y Not Used.
OUTPUT_MASK VARCHAR(50) Y Not Used.
ROW_NUM DOUBLE N Not Used.
SECTION_ID DOUBLE N Unique identifier for the section table.
SEP_STRING CHAR(18) Y Not Used.
SEP_STR_LENGTH DOUBLE Y Not Used.
SORT_DIRECTION_CD DOUBLE N Not Used.
SUBJ_AREA_DTL_CD DOUBLE N Defines the codified attribute.
TRIM_CHAR CHAR(1) Y Not Used.
TRIM_TYPE_CD DOUBLE N Not Used.
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.
WIDTH DOUBLE Y Defines the width of a column.


SECTION_SECTION_R



Column Section Top of Page


Table-level Detail

Description: Section Section Relation
Definition: The Section Section Relationship table relates header sections and subsections together to define the overall format of the section within the Summary Sheet.
Table Type: REFERENCE





Column Detail - SECTION_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.
CHILD_ID DOUBLE N The unique identifier of the child 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.
PARENT_ID DOUBLE N The unique identifier of the parent section.
SEQUENCE DOUBLE N Defines the order of the subsections.
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.


SEMANTIC_NETWORK



Column Section Relationship Section Top of Page


Table-level Detail

Description: Semantic Network
Definition: Defines the relationships between semantic types. The semantic types are the nodes in the network and the semantic relationships are the links.
Table Type: REFERENCE





Column Detail - SEMANTIC_NETWORK


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.
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.
END_EFFECTIVE_DT_TM DATETIME Y 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.
PROPERTY_LIST_IND DOUBLE Y Indicates whether a semantic type relationship represents a list of concepts of the related semantic type.
REQUIRED_IND DOUBLE Y Indicates whether a concept is required to have a relationship with another concept of the semantic type defined in semantic_type2_id.
SEMANTIC_NETWORK_ID DOUBLE N Primary key for the table. Uniquely identifies a row within the table.
SEMANTIC_RELTN_ID DOUBLE N The semantic relationship, or link, of the nodes in the network.
SEMANTIC_TYPE1_ID DOUBLE N A node in the semantic network.
SEMANTIC_TYPE2_ID DOUBLE N The related node in the semantic network.
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 - SEMANTIC_NETWORK


Child Column in SEMANTIC_NETWORK(FK) Parent Table Name Parent Column Name
Parents: SEMANTIC_RELTN_ID SEMANTIC_TYPE SEMANTIC_TYPE_ID
SEMANTIC_TYPE1_ID SEMANTIC_TYPE SEMANTIC_TYPE_ID
SEMANTIC_TYPE2_ID SEMANTIC_TYPE SEMANTIC_TYPE_ID


SEMANTIC_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Semantic Type
Definition: Provides for a consistent categorization of concepts represented in the Cerner Knowledge Index and provides a set of useful relationships between these concepts.
Table Type: REFERENCE





Column Detail - SEMANTIC_TYPE


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.
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.
CODE_SET DOUBLE Y Identifies which code_set contains valid values for a given sematic property.
END_EFFECTIVE_DT_TM DATETIME Y 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.
HELP_LIST VARCHAR(2000) Y Stores User Defined Help as XML stringColumn
LOCK_TYPE_FLAG DOUBLE Y Used to determine how a column behaves in an .XML spreadsheet view.
PROPERTY_FLAG DOUBLE Y Identifies a semantic type as a property.
PROPERTY_TYPE_FLAG DOUBLE Y Identifies the "data type" of the semantic property.
REQUIRED_IND DOUBLE Y Required indicator.
SEMANTIC_IDENTIFIER VARCHAR(255) N A unique identifier supplied from Cerner or other external database and is persistent once it is assigned to a semantic type. All Cerner assigned semantic identifiers are created from the CONCEPT_SEQ
SEMANTIC_PROPERTY_ID DOUBLE N Identifies the semantic_type_id used to fetch the valid concepts for a semantic property.
SEMANTIC_RELTN_IND DOUBLE Y Identifies a semantic type as a relationship.
SEMANTIC_SOURCE_CD DOUBLE N Represents the external source that owns the semantic type identifier.
SEMANTIC_TYPE_DISPLAY VARCHAR(100) Y The display for the semantic type.
SEMANTIC_TYPE_ID DOUBLE N Primary key for the table. Uniquely identifies a row within the table.
SEMANTIC_TYPE_MEAN VARCHAR(30) Y Allows multiple semantic types to be grouped, or to have the same meaning, e.g. PARENT_OF and CHILD_OF could both have the meaning of IS_A.
TAG VARCHAR(100) Y The XML tag used on export.
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 - SEMANTIC_TYPE


Child Column in SEMANTIC_TYPE(FK) Parent Table Name Parent Column Name
Parents: SEMANTIC_PROPERTY_ID SEMANTIC_TYPE SEMANTIC_TYPE_ID




Parent Column in SEMANTIC_TYPE (PK) Child Table Name Child Column Name
Children: SEMANTIC_TYPE_ID CONCEPT_CONCEPT_R INVERSE_RELATION_ID
CONCEPT_CONCEPT_R RELATION_ID
CONCEPT_PROPERTY SEMANTIC_TYPE_ID
CONCEPT_SEMTYPE_R SEMANTIC_TYPE_ID
SEMANTIC_NETWORK SEMANTIC_RELTN_ID
SEMANTIC_NETWORK SEMANTIC_TYPE1_ID
SEMANTIC_NETWORK SEMANTIC_TYPE2_ID
SEMANTIC_TYPE SEMANTIC_PROPERTY_ID