Table Detail Report
CODE_SET_FIELD_DOMAIN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | The code_set_field_domain entity contains a list of valid co |
Definition: | Codes sets may have the ability to filter the code values that are displayed based on certain user defined parameters. The code set field domain entity contains a list of valid code sets that can be used to establish code set filtering. |
Table Type: | REFERENCE |
Column Detail - CODE_SET_FIELD_DOMAIN
Column Name | Type | Null? | Definition |
---|---|---|---|
CODE_SET | DOUBLE | N | Not currently used |
REFERENCE | DOUBLE | N | Not currently 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. |
Relationship Detail - CODE_SET_FIELD_DOMAIN
Child Column in CODE_SET_FIELD_DOMAIN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CODE_SET | CODE_VALUE_SET | CODE_SET |
Parent Column in CODE_SET_FIELD_DOMAIN (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CODE_SET | CODE_SET_DOMAIN | CODE_SET |
REFERENCE | CODE_SET_DOMAIN | REFERENCE |
CODE_VALUE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Code Value |
Definition: | Stores the display, definition, etc for each code_value. |
Table Type: | REFERENCE |
Column Detail - CODE_VALUE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_DT_TM | DATETIME | Y | The date time the code value became active |
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_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
ACTIVE_TYPE_CD | DOUBLE | N | Code value which provides more infomation about the active status of the row |
BEGIN_EFFECTIVE_DT_TM | DATETIME | Y | The beginning effective date for the code value |
CDF_MEANING | VARCHAR(12) | Y | The actual string value for the cdf meaning. |
CKI | VARCHAR(255) | Y | Cerner Knowledge Index for the Code Value |
CODE_SET | DOUBLE | N | The code set for the code value |
CODE_VALUE | DOUBLE | N | code value. |
COLLATION_SEQ | DOUBLE | Y | Used to order the code values for a code set in a pulldown list |
CONCEPT_CKI | VARCHAR(255) | Y | Concept CKI is the functional Concept Identifier; it is the codified means within Millennium to identify key medical concepts to support information processing, clinical decision support, executable knowledge and knowledge presentation. Composed of a source and an identifier. For example, if the concept source is "SNOMED" and the concept identifier is "123", then the CKI is "SNOMED!123". |
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. |
DEFINITION | VARCHAR(100) | Y | The definition for the code value |
DESCRIPTION | VARCHAR(60) | Y | The description for the code value |
DISPLAY | VARCHAR(40) | Y | The display string for the code_value |
DISPLAY_KEY | VARCHAR(40) | Y | Similar to DISPLAY but contains only upper case and alphanumeric characters without any special characters or embedded spaces; Typically used in index to improve query performance |
DISPLAY_KEY_A_NLS | VARCHAR(160) | Y | DISPLAY_KEY_A_NLS column |
DISPLAY_KEY_NLS | VARCHAR(255) | Y | NLS Version of the Display KeyColumn |
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. |
INACTIVE_DT_TM | DATETIME | Y | The date time the code value became inactive |
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 - CODE_VALUE
Parent Column in CODE_VALUE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CODE_VALUE | ACCEPT_QUAR_PROD_R | PRODUCT_CD |
ACCEPT_QUAR_REASON | QUAR_REASON_CD | ||
APP_TRANSLATION | APP_LANGUAGE_CD | ||
AP_ACCN_TEMPLATE_DETAIL | TEMPLATE_CD | ||
AP_DIAG_QUERY_PARAM | QUERY_CD | ||
AP_FT_TYPE | FOLLOWUP_TRACKING_TYPE_CD | ||
AP_SYNOPTIC_SPEC_PREFIX_R | SPECIMEN_CD | ||
AP_SYS_CORR | LOOKBACK_CASE_TYPE_CD | ||
AUTHORIZATION_CODE_VALUE_R | CODE_VALUE | ||
BBHIST_SPECIAL_TESTING | SPECIAL_TESTING_CD | ||
BB_SHIPMENT | COURIER_CD | ||
BB_SHIP_CONTAINER | CONTAINER_CONDITION_CD | ||
BB_SHIP_CONTAINER | CONTAINER_TYPE_CD | ||
BB_SHIP_CONTAINER | UNIT_OF_MEAS_CD | ||
BB_SHIP_EVENT | RETURN_CONDITION_CD | ||
BB_SHIP_EVENT | RETURN_VIS_INSP_CD | ||
CASE_SPECIMEN_TYPE_R | CASE_TYPE_CD | ||
CHART_REQUEST | DIST_RUN_TYPE_CD | ||
CMT_CODE_VALUE_LOAD | CODE_VALUE | ||
CMT_CROSS_MAP | MAP_TYPE_CD | ||
CMT_CROSS_MAP | SOURCE_VOCABULARY_CD | ||
CODE_DOMAIN_FILTER_DISPLAY | CODE_VALUE | ||
CODE_VALUE_ALIAS | CODE_VALUE | ||
CODE_VALUE_EXTENSION | CODE_VALUE | ||
CODE_VALUE_GROUP | CHILD_CODE_VALUE | ||
CODE_VALUE_GROUP | PARENT_CODE_VALUE | ||
CODE_VALUE_LOG_DOMAIN_R | CODE_VALUE | ||
CODE_VALUE_OUTBOUND | CODE_VALUE | ||
COLL_TEMPLATE_PREF | COLL_TEMPLATE_CD | ||
COLL_TEMPLATE_PREF_R | COLL_TEMPLATE_CD | ||
CONTAINER_CONDITION_R | CONDITION_CD | ||
CONTAINER_CONDITION_R | CONTAINER_TYPE_CD | ||
CONTAINER_ORG_R | CONTAINER_TYPE_CD | ||
CONTNR_TYPE_PROD_R | PRODUCT_CD | ||
CONTNR_TYPE_PROD_R | UNIT_OF_MEAS_CD | ||
CONTRIBUTOR_SYSTEM | CONTRIBUTOR_SYSTEM_CD | ||
CR_STATIC_REGION_SR_RELTN | SERVICE_RESOURCE_CD | ||
CR_TEMPLATE_POSITION_RELTN | POSITION_CD | ||
CV_ACRONYM | ACRONYM_CATEGORY_CD | ||
DISCRETE_TASK_ASSAY | TASK_ASSAY_CD | ||
DISPENSE_CATEGORY | DISPENSE_CATEGORY_CD | ||
DISPENSE_CATEGORY | LABEL_FORMAT_CD | ||
DISPENSE_CATEGORY_FORM_R | FORM_CD | ||
DRC_FACILITY_R | FACILITY_CD | ||
DRC_FACILITY_R_VER | FACILITY_CD | ||
DTS_TRANS_STATS | RESULT_STATUS_CD | ||
EEM_ABN_ACTION | ABN_ACTION_CD | ||
EEM_ABN_ACTION | ABN_STATE_CD | ||
EEM_ABN_CHECK | ABN_STATE_CD | ||
EEM_ABN_CHECK | GENDER_CD | ||
EEM_ABN_CHECK | HIGH_STATUS_CD | ||
EEM_ABN_CHECK | MED_STATUS_CD | ||
EEM_ABN_CHECK | PROC_VOCAB_CD | ||
EEM_ABN_DATA | ATTR_TYPE_CD | ||
EEM_ABN_DATA | COMP_TYPE_CD | ||
EEM_ABN_DATA | DATA_TYPE_CD | ||
EEM_ABN_DATA | UNITS_CD | ||
EEM_ABN_DATA | VOCABULARY_CD | ||
EEM_ABN_DIAG | DIAG_VOCAB_CD | ||
EEM_ABN_INDEX | HIGH_STATUS_CD | ||
EEM_ABN_INDEX | MED_STATUS_CD | ||
EEM_ABN_LOW | LOW_STATUS_CD | ||
EEM_ABN_MOD | MOD_VOCAB_CD | ||
EEM_ABN_RULE | DIAG_VOCABULARY_CD | ||
EEM_ABN_RULE | PROC_VOCABULARY_CD | ||
EEM_ACTION | EEM_ACTION_CD | ||
EEM_BENEFIT | BENEFIT_TYPE_CD | ||
EEM_BENEFIT | DATA_TYPE_CD | ||
EEM_BENEFIT | UNITS_CD | ||
EEM_COMMENT | SUB_TEXT_CD | ||
EEM_COMMENT | TEXT_TYPE_CD | ||
EEM_DEMOG_DETAIL | GENDER_CD | ||
EEM_FILE | CONTRIBUTOR_SYSTEM_CD | ||
EEM_FILE_ACTION | FILE_ACTION_CD | ||
EEM_FILE_ACTION | FILE_STATE_CD | ||
EEM_FILE_RELTN | PARENT1_CD | ||
EEM_FILE_RELTN | PARENT2_CD | ||
EEM_FILE_RELTN | PARENT3_CD | ||
EEM_MOH_DETAIL | GENDER_CD | ||
EEM_MOH_DETAIL | RESPONSE_CD | ||
EEM_NEWBORN_DETAIL | GENDER_CD | ||
EEM_REVIEW_RELTN | SPECIALTY_CD | ||
FILL_BATCH | FILL_BATCH_CD | ||
FILTER_TYPE | FILTER_TYPE_CD | ||
FREQUENCY_SCHEDULE | ACTIVITY_TYPE_CD | ||
HEALTH_PLAN_ALIAS | PLAN_ALIAS_SUB_TYPE_CD | ||
HEALTH_PLAN_ALIAS | PLAN_ALIAS_TYPE_CD | ||
HE_RULE_GROUP | ACTIVE_STATUS_CD | ||
HE_RULE_GROUP | RULE_GROUP_CD | ||
HP_ALIAS_POOL_RELTN | LOCATION_CD | ||
IMAGE_CLASS_TYPE | IMAGE_CLASS_TYPE_CD | ||
KIA_EVENT_CODE_SNP | EVENT_CD | ||
LAB_INSTRUMENT | SERVICE_RESOURCE_CD | ||
LOCATION | LOCATION_CD | ||
LOCATION | LOCATION_TYPE_CD | ||
LOCATION | VIEW_TYPE_CD | ||
LOCATION_GROUP | ROOT_LOC_CD | ||
MEDICATION_DEFINITION | ORDER_ALERT1_CD | ||
MEDICATION_DEFINITION | ORDER_ALERT2_CD | ||
MED_DEF_LOC_R | LOCATION_CD | ||
MESSAGE_TYPE_TEMPLATE_RELTN | MESSAGE_TYPE_CD | ||
MODIFY_OPTION_DEVICE | DEVICE_TYPE_CD | ||
NOMENCLATURE | PRINCIPLE_TYPE_CD | ||
NOMENCLATURE | VOCAB_AXIS_CD | ||
ONC_CHEMO_VERIFY | POSITION_ROLE_CD | ||
OPS_SCHED_DEP | ACTIVE_STATUS_CD | ||
ORDER_ALERTS | ALERT_CD | ||
ORDER_CATALOG | CATALOG_CD | ||
ORDER_DIAG_CONFIG | CATALOG_TYPE_CD | ||
ORDER_DISPENSE | FUTURE_LOC_FACILITY_CD | ||
ORDER_DISPENSE | FUTURE_LOC_NURSE_UNIT_CD | ||
ORGANIZATION_RESOURCE | ORG_RESOURCE_TYPE_CD | ||
ORG_SHIPMENT | INVENTORY_AREA_CD | ||
ORG_SHIPMENT | OWNER_AREA_CD | ||
ORG_TRANS_URL_RELTN | TRANSACTION_URL_CD | ||
PASSIVE_ALERT | CATEGORY_CD | ||
PASSIVE_ALERT_POSITION | POSITION_CD | ||
PCS_DEMOGRAPHIC_FIELD | CURRENT_FIELD_CD | ||
PCS_DEMOGRAPHIC_FIELD | FIELD_CD | ||
PFT_REG_MOD | ENCNTR_TYPE_CD | ||
PHARMACY_NOTES | COMMENT_TYPE_CD | ||
PHA_BATCH_PARAMETERS | PARAMETER_CD | ||
PHA_FLEX | FINANCIAL_CLASS_CD | ||
PRAC_SITE_SPECIALTY_RELTN | SPECIALTY_CD | ||
PRIVILEGE_DEF | PRIVILEGE_CD | ||
PROT_CRPC_BILLING | PROT_RES_ACCNT_CD | ||
RAD_OMF_TC_INDICATOR | INDICATOR_CD | ||
REPORT_HISTORY_GROUPING_R | GROUPING_CD | ||
REPORT_QUEUE_R | REPORT_QUEUE_CD | ||
RESOURCE_GROUP | ROOT_SERVICE_RESOURCE_CD | ||
RLN_CONTRIBUTOR | CONTRIBUTOR_SOURCE_CD | ||
ROBOTICS_ITEMS | SERVICE_RESOURCE_CD | ||
ROUTE_FORM_R | FORM_CD | ||
ROUTE_FORM_R | ROUTE_CD | ||
RX_HEALTH_PLAN | CLAIM_VALIDATION_CD | ||
RX_HEALTH_PLAN | PRICE_CODE_CD | ||
RX_HEALTH_PLAN_CLAIM | CODE_VALUE_CD | ||
RX_PRINTER_LOCATION_R | LOCATION_CD | ||
RX_PROTOCOL | PROTOCOL_CD | ||
SA_PREFERENCE | PREFERENCE_TYPE_CD | ||
SA_REF_REQUIRED_PRSNL_ACTIVITY | PRSNL_ACTIVITY_TYPE_CD | ||
SCH_ABN_CROSS | APPT_TYPE_CD | ||
SCH_ABN_CROSS | PARENT_APPT_TYPE_CD | ||
SCH_ACTION | SCH_ACTION_CD | ||
SCH_ACTION | SCH_REASON_CD | ||
SCH_ACTION_DATE | TIME_RESTR_CD | ||
SCH_ACTION_LINK | SCH_ACTION_CD | ||
SCH_ACTION_NOTIFY | REPORT_TYPE_CD | ||
SCH_ACTION_NOTIFY | SCH_STATE_CD | ||
SCH_ACTION_NOTIFY | SOURCE_TYPE_CD | ||
SCH_ACTION_ROLE | LOCATION_TYPE_CD | ||
SCH_ACTION_ROLE | RESOURCE_CD | ||
SCH_APPLY | APPLY_TYPE_CD | ||
SCH_APPLY | SCH_STATE_CD | ||
SCH_APPLY | SUB_TEXT_CD | ||
SCH_APPLY | TEXT_TYPE_CD | ||
SCH_APPLY_LIST | RESOURCE_CD | ||
SCH_APPLY_LIST | SLOT_STATE_CD | ||
SCH_APPT | ACTIVITY_CD | ||
SCH_APPT | SCH_STATE_CD | ||
SCH_APPT | SLOT_STATE_CD | ||
SCH_APPT_BOOK | APPT_SYNONYM_CD | ||
SCH_APPT_BOOK | APPT_TYPE_CD | ||
SCH_APPT_COMP | COMP_APPT_SYNONYM_CD | ||
SCH_APPT_COMP | COMP_APPT_TYPE_CD | ||
SCH_APPT_COMP | OFFSET_BEG_UNITS_CD | ||
SCH_APPT_COMP | OFFSET_END_UNITS_CD | ||
SCH_APPT_COMP | OFFSET_FROM_CD | ||
SCH_APPT_COMP | OFFSET_TYPE_CD | ||
SCH_APPT_DEF | DEF_STATE_CD | ||
SCH_APPT_DUP | APPT_TYPE_CD | ||
SCH_APPT_DUP | BEG_UNITS_CD | ||
SCH_APPT_DUP | DUP_ACTION_CD | ||
SCH_APPT_DUP | DUP_TYPE_CD | ||
SCH_APPT_DUP | END_UNITS_CD | ||
SCH_APPT_DUP | LOCATION_CD | ||
SCH_APPT_FREE | APPT_TYPE_CD | ||
SCH_APPT_FREE | CHILD_CD | ||
SCH_APPT_FREE | FREE_TYPE_CD | ||
SCH_APPT_INTER | INTER_TYPE_CD | ||
SCH_APPT_LOC | APPT_TYPE_CD | ||
SCH_APPT_NOMEN | APPT_NOMEN_CD | ||
SCH_APPT_NOMEN | APPT_TYPE_CD | ||
SCH_APPT_NOTIFY | APPT_TYPE_CD | ||
SCH_APPT_NOTIFY | BEG_UNITS_CD | ||
SCH_APPT_NOTIFY | END_UNITS_CD | ||
SCH_APPT_NOTIFY | SCH_ACTION_CD | ||
SCH_APPT_OBJECT | APPT_TYPE_CD | ||
SCH_APPT_OBJECT | ASSOC_TYPE_CD | ||
SCH_APPT_OPTION | APPT_TYPE_CD | ||
SCH_APPT_OPTION | SCH_OPTION_CD | ||
SCH_APPT_ORD | APPT_TYPE_CD | ||
SCH_APPT_ROUTING | APPT_TYPE_CD | ||
SCH_APPT_ROUTING | BEG_UNITS_CD | ||
SCH_APPT_ROUTING | END_UNITS_CD | ||
SCH_APPT_ROUTING | SCH_ACTION_CD | ||
SCH_APPT_STATE | APPT_TYPE_CD | ||
SCH_APPT_STATE | SCH_STATE_CD | ||
SCH_APPT_SYN | APPT_SYNONYM_CD | ||
SCH_APPT_SYN | APPT_TYPE_CD | ||
SCH_APPT_TYPE | APPT_TYPE_CD | ||
SCH_APPT_TYPE | PERSON_ACCEPT_CD | ||
SCH_APPT_TYPE | RECUR_CD | ||
SCH_ASSOC | ASSOC_TYPE_CD | ||
SCH_ASSOC | DATA_SOURCE_CD | ||
SCH_BOOKING | APPT_TYPE_CD | ||
SCH_BOOKING | RESOURCE_CD | ||
SCH_BOOKING_ORD | ORDER_STATUS_CD | ||
SCH_BOOK_LIST | RESOURCE_CD | ||
SCH_CODE_GROUP | CODE_VALUE | ||
SCH_COMMENT | SUB_TEXT_CD | ||
SCH_COMMENT | TEXT_TYPE_CD | ||
SCH_DATE_COMMENT | SCH_STATE_CD | ||
SCH_DATE_COMMENT | SUB_TEXT_CD | ||
SCH_DATE_COMMENT | TEXT_TYPE_CD | ||
SCH_DEF_APPLY | DEF_STATE_CD | ||
SCH_DEF_APPLY | RESOURCE_CD | ||
SCH_DEF_RES | RESOURCE_CD | ||
SCH_DEF_SCHED | DEFAULT_TYPE_CD | ||
SCH_DEF_SLOT | VIS_BEG_UNITS_CD | ||
SCH_DEF_SLOT | VIS_END_UNITS_CD | ||
SCH_DEL_LIST | DELETE_ACTION_CD | ||
SCH_DEL_LIST | PARENT_CD | ||
SCH_DISPLAY_TOKEN | DATA_TYPE_CD | ||
SCH_DISPLAY_TOKEN | DATE_FORMAT_CD | ||
SCH_DISPLAY_TOKEN | DATE_ORDER_CD | ||
SCH_DISPLAY_TOKEN | TIME_FORMAT_CD | ||
SCH_DISPLAY_TOKEN | WARN_TOKEN_CD | ||
SCH_DISPLAY_TOKEN | WARN_TYPE_CD | ||
SCH_ENTRY | APPT_TYPE_CD | ||
SCH_EVENT | APPT_TYPE_CD | ||
SCH_EVENT | CONTRIBUTOR_SYSTEM_CD | ||
SCH_EVENT | SCH_STATE_CD | ||
SCH_EVENT_ACTION | ESO_ACTION_CD | ||
SCH_EVENT_ACTION | REQ_ACTION_CD | ||
SCH_EVENT_ACTION | RESOURCE_CD | ||
SCH_EVENT_ACTION | VER_STATUS_CD | ||
SCH_EVENT_ALIAS | ALIAS_POOL_CD | ||
SCH_EVENT_ALIAS | CHECK_DIGIT_METHOD_CD | ||
SCH_EVENT_ALIAS | CONTRIBUTOR_SYSTEM_CD | ||
SCH_EVENT_ALIAS | EVENT_ALIAS_SUB_TYPE_CD | ||
SCH_EVENT_ALIAS | EVENT_ALIAS_TYPE_CD | ||
SCH_EVENT_ATTACH | ATTACH_TYPE_CD | ||
SCH_EVENT_ATTACH | ORDER_STATUS_CD | ||
SCH_EVENT_ATTACH | SCH_STATE_CD | ||
SCH_EVENT_COMM | SUB_TEXT_CD | ||
SCH_EVENT_COMM | TEXT_TYPE_CD | ||
SCH_EVENT_RECUR | DURATION_UNITS_CD | ||
SCH_EVENT_RECUR | RECUR_STATE_CD | ||
SCH_EVENT_ROLE | RESOURCE_CD | ||
SCH_FLEX_LIST | DATA_SOURCE_CD | ||
SCH_FLEX_LIST | DATA_TYPE_CD | ||
SCH_FLEX_LIST | FLEX_EVAL_CD | ||
SCH_FLEX_LIST | FLEX_ORIENT_CD | ||
SCH_FLEX_LIST | FLEX_TOKEN_CD | ||
SCH_FLEX_LIST | OFFSET_UNITS_CD | ||
SCH_FLEX_LIST | TOKEN_TYPE_CD | ||
SCH_FLEX_STRING | FLEX_TYPE_CD | ||
SCH_FLEX_TOKEN | DATA_SOURCE_CD | ||
SCH_FLEX_TOKEN | DATA_TYPE_CD | ||
SCH_FLEX_TOKEN | FLEX_EVAL_CD | ||
SCH_FLEX_TOKEN | TOKEN_TYPE_CD | ||
SCH_FREQ | END_TYPE_CD | ||
SCH_FREQ | FREQ_PATTERN_CD | ||
SCH_FREQ | FREQ_STATE_CD | ||
SCH_FREQ | FREQ_TYPE_CD | ||
SCH_FREQ | UNITS_CD | ||
SCH_GENERIC_LOC | LOCATION_TYPE_CD | ||
SCH_INSTR_LIST | PRIORITY_CD | ||
SCH_LIST_LOC | LOCATION_TYPE_CD | ||
SCH_LIST_RES | RESOURCE_CD | ||
SCH_LIST_RES | RES_SCH_CD | ||
SCH_LIST_ROLE | ALGORITHM_CD | ||
SCH_LIST_ROLE | PROMPT_ACCEPT_CD | ||
SCH_LIST_ROLE | ROLE_TYPE_CD | ||
SCH_LIST_ROLE | SCH_ROLE_CD | ||
SCH_LIST_SLOT | CLEANUP_UNITS_CD | ||
SCH_LIST_SLOT | DURATION_UNITS_CD | ||
SCH_LIST_SLOT | OFFSET_BEG_UNITS_CD | ||
SCH_LIST_SLOT | OFFSET_END_UNITS_CD | ||
SCH_LIST_SLOT | OFFSET_TYPE_CD | ||
SCH_LIST_SLOT | SETUP_UNITS_CD | ||
SCH_LOCATION | LOCATION_TYPE_CD | ||
SCH_LOCK | SCH_ACTION_CD | ||
SCH_LOG_LIST | LOG_TEXT_CD | ||
SCH_NOTIFY | NOTIFY_TYPE_CD | ||
SCH_NOTIFY | REPORT_TYPE_CD | ||
SCH_NOTIFY | SCH_ACTION_CD | ||
SCH_NOTIFY | UNITS_CD | ||
SCH_OBJECT | OBJECT_SUB_CD | ||
SCH_OBJECT | OBJECT_TYPE_CD | ||
SCH_OBJECT_ASSOC | ASSOC_TYPE_CD | ||
SCH_OBJECT_ASSOC | ASSOC_WITH_CD | ||
SCH_OBJECT_ASSOC | OBJECT_SUB_CD | ||
SCH_OBJECT_DATA | ASSOC_TYPE_CD | ||
SCH_OBJECT_DATA | DATA_SOURCE_CD | ||
SCH_OBJECT_DATA | OBJECT_SUB_CD | ||
SCH_OBJECT_SUB | OBJECT_SUB_CD | ||
SCH_OBJECT_SUB | OBJECT_TYPE_CD | ||
SCH_OBJECT_USAGE | OBJECT_SUB_CD | ||
SCH_OBJECT_USAGE | OBJECT_USAGE_CD | ||
SCH_OPTION | WARN_CLASS_CD | ||
SCH_OPTION | WARN_LEVEL_CD | ||
SCH_OPTION | WARN_OPTION_CD | ||
SCH_OPTION | WARN_REASON_CD | ||
SCH_ORDER_APPT | APPT_TYPE_CD | ||
SCH_ORDER_APPT | CATALOG_CD | ||
SCH_ORDER_APPT | CHILD_APPT_TYPE_CD | ||
SCH_ORDER_APPT | DEL_APPT_CD | ||
SCH_ORDER_APPT | PROC_SPEC_CD | ||
SCH_ORDER_DURATION | ARRIVAL_UNITS_CD | ||
SCH_ORDER_DURATION | CATALOG_CD | ||
SCH_ORDER_DURATION | CLEANUP_UNITS_CD | ||
SCH_ORDER_DURATION | DURATION_UNITS_CD | ||
SCH_ORDER_DURATION | LOCATION_CD | ||
SCH_ORDER_DURATION | OFFSET_BEG_UNITS_CD | ||
SCH_ORDER_DURATION | OFFSET_END_UNITS_CD | ||
SCH_ORDER_DURATION | OFFSET_TYPE_CD | ||
SCH_ORDER_DURATION | RECOVERY_UNITS_CD | ||
SCH_ORDER_DURATION | SETUP_UNITS_CD | ||
SCH_ORDER_INTER | CATALOG_CD | ||
SCH_ORDER_INTER | INTER_TYPE_CD | ||
SCH_ORDER_LOC | CATALOG_CD | ||
SCH_ORDER_ROLE | CATALOG_CD | ||
SCH_PREF | DATA_TYPE_CD | ||
SCH_PREF | PREF_TYPE_CD | ||
SCH_PREF | PREF_UNITS_CD | ||
SCH_QUERY | QUERY_TYPE_CD | ||
SCH_REF_COMMENT | SUB_TEXT_CD | ||
SCH_REF_COMMENT | TEXT_TYPE_CD | ||
SCH_REF_FREQ | FREQ_PATTERN_CD | ||
SCH_REF_FREQ | UNITS_CD | ||
SCH_REPORT | REPORT_TYPE_CD | ||
SCH_RESOURCE | RESOURCE_CD | ||
SCH_RESOURCE_LIST | APPT_TYPE_CD | ||
SCH_RES_LIST | RESOURCE_CD | ||
SCH_RES_ROLE | RESOURCE_CD | ||
SCH_RES_ROLE | SCH_ROLE_CD | ||
SCH_RES_TYPE | RES_GROUP_CD | ||
SCH_ROLE | SCH_ROLE_CD | ||
SCH_ROUTE | ROUTE_TYPE_CD | ||
SCH_SCHEDULE | SCH_STATE_CD | ||
SCH_SECURITY | DATA1_SOURCE_CD | ||
SCH_SECURITY | DATA2_SOURCE_CD | ||
SCH_SECURITY | DATA3_SOURCE_CD | ||
SCH_SECURITY | SEC_TYPE_CD | ||
SCH_SEC_COMMENT | SEC_ACTION_CD | ||
SCH_SEC_COMMENT | SEC_TYPE_CD | ||
SCH_SEC_COMMENT | SUB_TEXT_CD | ||
SCH_SEC_COMMENT | TEXT_TYPE_CD | ||
SCH_SEC_DATA | DATA_SOURCE_CD | ||
SCH_SEC_DATA | SEC_TYPE_CD | ||
SCH_SEC_DATA | VIEW_SOURCE_CD | ||
SCH_SEC_DATA | VIEW_TYPE_CD | ||
SCH_SEQ_GROUP | SEQ_TYPE_CD | ||
SCH_SEQ_LIST | DURATION_UNITS_CD | ||
SCH_SEQ_LIST | SEQ_SOURCE_CD | ||
SCH_SIMPLE_ASSOC | ASSOC_TYPE_CD | ||
SCH_SLOT_ALIAS | ALIAS_POOL_CD | ||
SCH_SLOT_ALIAS | CHECK_DIGIT_METHOD_CD | ||
SCH_SLOT_ALIAS | SLOT_ALIAS_SUB_TYPE_CD | ||
SCH_SLOT_ALIAS | SLOT_ALIAS_TYPE_CD | ||
SCH_SUB_TEXT | SUB_TEXT_CD | ||
SCH_SUB_TEXT | TEMPLATE_ACCEPT_CD | ||
SCH_SUB_TEXT | TEXT_ACCEPT_CD | ||
SCH_SUB_TEXT | TEXT_TYPE_CD | ||
SCH_TEMPLATE | SUB_TEXT_CD | ||
SCH_TEMPLATE | TEXT_TYPE_CD | ||
SCH_TEXT_LINK | LAPSE_UNITS_CD | ||
SCH_TEXT_LINK | SUB_TEXT_CD | ||
SCH_TEXT_LINK | TEMPLATE_ACCEPT_CD | ||
SCH_TEXT_LINK | TEXT_ACCEPT_CD | ||
SCH_TEXT_LINK | TEXT_TYPE_CD | ||
SCH_WARNING | WARN_BATCH_CD | ||
SCH_WARNING | WARN_CLASS_CD | ||
SCH_WARNING | WARN_LEVEL_CD | ||
SCH_WARNING | WARN_OPTION_CD | ||
SCH_WARNING | WARN_REASON_CD | ||
SCH_WARNING | WARN_STATE_CD | ||
SCH_WARNING | WARN_TYPE_CD | ||
SCH_WARNING_LEVEL | WARN_LEVEL_CD | ||
SCH_WARNING_LIST | WARN_TOKEN_CD | ||
SCH_WARNING_LIST | WARN_TYPE_CD | ||
SCH_WARNING_OPTION | REASON_ACCEPT_CD | ||
SCH_WARNING_OPTION | WARN_CLASS_CD | ||
SCH_WARNING_OPTION | WARN_LEVEL_CD | ||
SCH_WARNING_OPTION | WARN_OPTION_CD | ||
SCH_WARNING_OPTION | WARN_PROCESS_CD | ||
SCH_WARNING_OPTION | WARN_TYPE_CD | ||
SCH_WARNING_REASON | WARN_OPTION_CD | ||
SCH_WARNING_REASON | WARN_REASON_CD | ||
SCH_WARNING_REASON | WARN_TYPE_CD | ||
SCH_WARNING_TOKEN | DATA_TYPE_CD | ||
SCH_WARNING_TOKEN | WARN_TOKEN_CD | ||
SCH_WARNING_TYPE | WARN_BATCH_CD | ||
SCH_WARNING_TYPE | WARN_TYPE_CD | ||
SCH_WARN_LEVEL | WARN_LEVEL_CD | ||
SCH_WARN_TYPE | REASON_ACCEPT_CD | ||
SCH_WARN_TYPE | TEMPLATE_ACCEPT_CD | ||
SCH_WARN_TYPE | TEXT_ACCEPT_CD | ||
SCH_WARN_TYPE | WARN_LEVEL_CD | ||
SCH_WARN_TYPE | WARN_TYPE_CD | ||
SCH_WIZARD_COMMENT | SUB_TEXT_CD | ||
SCH_WIZARD_COMMENT | TEXT_TYPE_CD | ||
SCH_WIZARD_COMMENT | WIZ_OPTION_CD | ||
SCH_WIZARD_COMMENT | WIZ_TYPE_CD | ||
SCH_WIZARD_OPTION | WIZ_DISPLAY_CD | ||
SCH_WIZARD_OPTION | WIZ_OPTION_CD | ||
SCH_WIZARD_OPTION | WIZ_TYPE_CD | ||
SCH_WIZARD_PARAM | DATA_TYPE_CD | ||
SCH_WIZARD_PARAM | EVAL_TYPE_CD | ||
SCH_WIZARD_PARAM | WIZ_OPTION_CD | ||
SCH_WIZARD_PARAM | WIZ_TYPE_CD | ||
SCH_WIZARD_TYPE | WIZ_TYPE_CD | ||
SEGMENT_REFERENCE | SEG_CD | ||
SERVICE_RESOURCE | VIEW_TYPE_CD | ||
SET_ITEM_R | DEFAULT_ACTION_CD | ||
SHX_CATEGORY_REF | CATEGORY_CD | ||
SHX_ELEMENT | INPUT_TYPE_CD | ||
SN_PREF_CARD | SURG_AREA_CD | ||
SN_TRACK_EVENT_RELTN | EVENT_CD | ||
SPECIMEN_GROUPING_R | CATEGORY_CD | ||
SPECIMEN_GROUPING_R | SOURCE_CD | ||
STORAGE_ITEM | STORAGE_ITEM_CD | ||
SUMMARY_SECTION | SUBJECT_AREA_CD | ||
TIME_SCALE | INTERVAL_UNITS_CD | ||
TRACKING_CHECKIN | FAMILY_PRESENT_CD | ||
TRACKING_CHECKIN | TRACKING_EVENT_TYPE_CD | ||
TRACKING_CHECKIN | TRACKING_GROUP_CD | ||
TRACKING_EVENT | EVENT_STATUS_CD | ||
TRACKING_EVENT | TRACKING_GROUP_CD | ||
TRACKING_EVT_CMT | EVT_COMMENT_TYPE_CD | ||
TRACKING_HOLD | BED_STATUS_CD | ||
TRACKING_HOLD | LOCATION_CD | ||
TRACKING_ITEM | ACTIVE_STATUS_CD | ||
TRACKING_LOCATOR | LOCATION_CD | ||
TRACKING_LOCATOR | LOC_BED_CD | ||
TRACKING_LOCATOR | LOC_NURSE_UNIT_CD | ||
TRACKING_LOCATOR | LOC_ROOM_CD | ||
TRACKING_LOCATOR | TRACKING_REASON_CD | ||
TRACKING_PRSNL | DEF_ENCNTR_PRSNL_R_CD | ||
TRACKING_PRSNL | TRACKING_GROUP_CD | ||
TRACKING_PRSNL_REF | TRACKING_REF_TYPE_CD | ||
TRACKING_TAG | MANUF_TYPE_CD | ||
TRACKING_TAG | TAG_TYPE_CD | ||
TRACK_EVENT | DEF_BEGIN_LOC_CD | ||
TRACK_EVENT | DEF_REQUEST_LOC_CD | ||
TRACK_EVENT | EVENT_USE_MEAN_CD | ||
TRACK_EVENT | FLEX_LOCATION_CD | ||
TRACK_EVENT | TRACKING_GROUP_CD | ||
TRACK_LOCATION_PARAM | LOCATION_CD | ||
TRACK_REFERENCE | TRACKING_GROUP_CD | ||
TRACK_REFERENCE | TRACKING_REF_TYPE_CD | ||
UKR_SACT | INTENT_OF_TREATMENT_CD |
CODE_VALUE_ALIAS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Used to provide translations from source to source for code |
Definition: | The code alias entity is used to provide translations from source to source for code values. A source is a known defined system that is sending data. |
Table Type: | REFERENCE |
Column Detail - CODE_VALUE_ALIAS
Column Name | Type | Null? | Definition |
---|---|---|---|
ALIAS | VARCHAR(255) | N | The actual inbound alias |
ALIAS_TYPE_MEANING | VARCHAR(12) | Y | The meaning of the alias. Used when alias is not unique enough within a code_set. |
CODE_SET | DOUBLE | N | The code set for the code value. This is a denormalized column and reads should be from Code_value.code_set of the code_value. |
CODE_VALUE | DOUBLE | N | code value |
CONTRIBUTOR_SOURCE_CD | DOUBLE | N | The code value for the contributing system |
PRIMARY_IND | DOUBLE | Y | Not currently 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. |
Relationship Detail - CODE_VALUE_ALIAS
Child Column in CODE_VALUE_ALIAS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CODE_VALUE | CODE_VALUE | CODE_VALUE |
CODE_SET | CODE_VALUE_SET | CODE_SET |
CODE_VALUE_EVENT_R
Column Section | Top of Page |
Table-level Detail
Description: | CODE VALUE EVENT R |
Definition: | Used to alias code_values to event codes. |
Table Type: | REFERENCE |
Column Detail - CODE_VALUE_EVENT_R
Column Name | Type | Null? | Definition |
---|---|---|---|
EVENT_CD | DOUBLE | N | event_cd to be used to post clinical_event recordColumn |
FLEX1_CD | DOUBLE | N | Used to flex the parent_cd field. Should be 0 if no flexing required. This would allow the same catalog_cd to point to multiple event_cd's based on some other criteria (i.e. specimen_type_cd). |
FLEX2_CD | DOUBLE | N | Used to flex the parent_cd field. Should be 0 if no flexing required. This would allow the same catalog_cd to point to multiple event_cd's based on some other criteria (i.e. specimen_type_cd). |
FLEX3_CD | DOUBLE | N | Used to flex the parent_cd field. Should be 0 if no flexing required. This would allow the same catalog_cd to point to multiple event_cd's based on some other criteria (i.e. specimen_type_cd). |
FLEX4_CD | DOUBLE | N | Used to flex the parent_cd field. Should be 0 if no flexing required. This would allow the same catalog_cd to point to multiple event_cd's based on some other criteria (i.e. specimen_type_cd). |
FLEX5_CD | DOUBLE | N | Used to flex the parent_cd field. Should be 0 if no flexing required. This would allow the same catalog_cd to point to multiple event_cd's based on some other criteria (i.e. specimen_type_cd). |
PARENT_CD | DOUBLE | N | This is the code_value of the thing we are mapping to an event_cd. It can be a dta_cd, orc_cd, or a code_value. |
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. |
CODE_VALUE_EXTENSION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | The code value extension entity stores the values of the add |
Definition: | The code value extension entity stores the values of the additional values defined by the code set extension entity. Extended fields will be stored as alpha and should be converted by the client application. |
Table Type: | REFERENCE |
Column Detail - CODE_VALUE_EXTENSION
Column Name | Type | Null? | Definition |
---|---|---|---|
CODE_SET | DOUBLE | N | The code set for the extension. This is a denormalized column and reads should be from Code_value.code_set of the code_value. |
CODE_VALUE | DOUBLE | N | code value |
FIELD_NAME | VARCHAR(32) | N | The field name of the extension. |
FIELD_TYPE | DOUBLE | Y | The data type of the code value extension. This is a denormalized column and reads should be from Code_set_extension.field_type of the code_set/field_name. |
FIELD_VALUE | VARCHAR(100) | Y | The actual stored value |
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 - CODE_VALUE_EXTENSION
Child Column in CODE_VALUE_EXTENSION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CODE_SET | CODE_SET_EXTENSION | CODE_SET |
FIELD_NAME | CODE_SET_EXTENSION | FIELD_NAME | |
CODE_VALUE | CODE_VALUE | CODE_VALUE |