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 |