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