Table Detail Report

CATALOG_TAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores information about turnaround times for order catalog items
Definition: Order catalog turnaround time (Currently not implemented)
Table Type: REFERENCE





Column Detail - CATALOG_TAT


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.
CATALOG_CD DOUBLE N Used to store the code for the order catalog item for which turnaround time is specified
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.
PRIORITY_CD DOUBLE N Used to store the code for the priority for which turnaround time is specified
SERVICE_RESOURCE_CD DOUBLE N Used to store the code for the service resource for which turnaround time is specified
TAT_CD DOUBLE N Used to store the code for turnaround time
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 - CATALOG_TAT


Child Column in CATALOG_TAT(FK) Parent Table Name Parent Column Name
Parents: CATALOG_CD ORDER_CATALOG CATALOG_CD


DATA_MAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Data Map
Definition: Stores information for formating numeric values for discrete task assays that have a numeric result value.
Table Type: REFERENCE





Column Detail - DATA_MAP


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.
DATA_MAP_TYPE_FLAG DOUBLE Y Defines the type of data map.
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_DIGITS DOUBLE Y Defines the maximum number of digits allowed in the result.
MIN_DECIMAL_PLACES DOUBLE Y Defines the minimum number of decimal places required in the result.
MIN_DIGITS DOUBLE Y Defines the minimum number of digits required in the result.
RESULT_ENTRY_FORMAT DOUBLE Y (Currently not implemented)
SERVICE_RESOURCE_CD DOUBLE N A unique code value that identifies the service resource (such as instrument, bench, or sub section) for which the data map is specified. A value of zero indicates that the data map is defined for any service resource associated with the discrete task assay.
TASK_ASSAY_CD DOUBLE N A unique code value that identifies the discrete task assay with which the data map is associated.
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 - DATA_MAP


Child Column in DATA_MAP(FK) Parent Table Name Parent Column Name
Parents: TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD


DISCRETE_TASK_ASSAY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discrete Task Assay
Definition: Stores all discrete elements that you may want the system to store/track. Used to store tasks or assays.
Table Type: REFERENCE





Column Detail - DISCRETE_TASK_ASSAY


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.
ACTIVITY_TYPE_CD DOUBLE N A unique code value that identifies a specific activity type associated with the discrete task assay.
BB_RESULT_PROCESSING_CD DOUBLE N A unique code value used to determine result processing during blood bank result entry.
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.
CERNER_DEFINED_IND DOUBLE Y (Currently not implemented)
CODE_SET DOUBLE Y Defines which code set is to be prompted for when the discrete task assay is defined as a result type of 'online' code set.
CONCEPT_CKI VARCHAR(255) N 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".
DEFAULT_RESULT_TYPE_CD DOUBLE N A unique code value that identifies the default result type for the discrete task assay.
DEFAULT_TYPE_FLAG DOUBLE N Indicates if the DTA has defaults or where to get the defaults from.
DELTA_LVL_FLAG DOUBLE Y Stores the flag value that determines at what level delta checking will be performed. This flag is filled out by the database tool depending on what type of delta checking is specified.
DESCRIPTION VARCHAR(100) Y Stores the long description for the discrete task assay.
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.
EVENT_CD DOUBLE N (Currently not implemented)
HISTORY_ACTIVITY_TYPE_CD DOUBLE N A unique code value that identifies the long term storage of results for the discrete task assay once the records have been purged. (Currently not implemented)
HLA_LOCI_CD DOUBLE N (Currently not implemented)
ICD_CODE_IND DOUBLE Y Indicates whether ICD9 billing codes are associated with the discrete task assay.
INTERP_DATA_IND DOUBLE Y Indicates whether interpretive data is associated with the discrete task assay.
IO_FLAG DOUBLE N The purpose of this flag is to tell the documentation element is an intake or outtake component. The default value on this is going to 0 for passivity reasons but the other possible values are 1 for input and 2 for output
LABEL_TEMPLATE_ID DOUBLE N An identifier used to identify the label template that was used to create the dynamic label.
MNEMONIC VARCHAR(50) Y Defines the abbreviated form of the discrete task assay long description. Used in most applications to display the discrete assay task.
MNEMONIC_KEY_CAP VARCHAR(50) Y Defines the discrete task assay mnemonic in uppercase. Used for performing indexed searches on the table.
MNEMONIC_KEY_CAP_A_NLS VARCHAR(200) Y MNEMONIC_KEY_CAP_A_NLS column
MNEMONIC_KEY_CAP_NLS VARCHAR(102) N An international Key Field used to defines the discrete task assay mnemonic. Used for performing indexed searches on the table.
MODIFIER_IND DOUBLE Y A normalized value which tells that a modifier that can be documented (extended description of the result) exists for the result.
PRINT_REF_RANGES_ON_REPT DOUBLE Y (Currently not implemented)
PRINT_RESULTS DOUBLE Y (Currently not implemented)
RAD_SECTION_TYPE_CD DOUBLE N Classifies the type of report section to which the procedure belongs.
REF_RANGE_SCRIPT VARCHAR(50) Y Defines an alternate site-specific script used to determine reference ranges for the discrete task assay. (Currently not implemented)
REL_ASSAY_IND DOUBLE Y Indicates whether or not the discrete task assay has associated related discrete task assays defined.
RENDERING_PROVIDER_IND DOUBLE Y (Currently not implemented)
SCI_NOTATION_IND DOUBLE N This field indicates whether the task assay allows numeric values in scientific notation. If set, any value that exceeds the maximum digits and decimal places data map settings will be formatted in scientific notation. (e.g. MaxDigits = 5, DecimalPlaces = 2, Value = 1000.00 then FormattedValue = 1.00e3). Otherwise, the value will be formatted using the data map settings.
SIGNATURE_LINE_IND DOUBLE N Indicates whether the discrete task assay should have an associated signature line.
SINGLE_SELECT_IND DOUBLE N Indicator for first alpha single select. For multi select DTA, this indicator is used to make the first entry single select.
STRT_ASSAY_ID DOUBLE N Used to map to the strt_assay table for MDI database building.
TASK_ASSAY_CD DOUBLE N A unique code value that identifies a specific discrete task assay.
TASK_REPT_IND DOUBLE Y (Currently not implemented)
TEMPLATE_SCRIPT_CD DOUBLE N The code_value used to identify the template script used to dynamically determine the default values. It is ignored unless the default_type_flag value is 3.
TRANSMIT_INDICATOR DOUBLE Y (Currently not implemented)
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.
VERSION_NUMBER DOUBLE N This tells the how many times a user has update the Discrete_task_assay table. This table is not version-able and doesn't need to be versioned but we can store the versions in an archive so that we can compare what existed when it was documented.



Relationship Detail - DISCRETE_TASK_ASSAY


Child Column in DISCRETE_TASK_ASSAY(FK) Parent Table Name Parent Column Name
Parents: TASK_ASSAY_CD CODE_VALUE CODE_VALUE
LABEL_TEMPLATE_ID DYNAMIC_LABEL_TEMPLATE LABEL_TEMPLATE_ID
STRT_ASSAY_ID STRT_ASSAY STRT_ASSAY_ID




Parent Column in DISCRETE_TASK_ASSAY (PK) Child Table Name Child Column Name
Children: TASK_ASSAY_CD AP_DC_STUDY_RPT_PROC TASK_ASSAY_CD
AP_DIAG_AUTO_CODE TASK_ASSAY_CD
AP_FAVORITE TASK_ASSAY_CD
AP_FT_REPORT_PROC TASK_ASSAY_CD
AP_PREFIX_DIAG_SMRY TASK_ASSAY_CD
AP_PROCESSING_GRP_R TASK_ASSAY_CD
AP_PROMPT_TEST TASK_ASSAY_CD
AP_SYNOPTIC_RPT_SECTION_R TASK_ASSAY_CD
AP_TASK_ASSAY_ADDL TASK_ASSAY_CD
ASSAY_PROCESSING_R TASK_ASSAY_CD
ASSAY_RESOURCE_LIST TASK_ASSAY_CD
ASSAY_RESOURCE_LOT TASK_ASSAY_CD
AUTO_VERIFY TASK_ASSAY_CD
CASSETTE TASK_ASSAY_CD
CHART_GRP_EVNT_SUPPRESS TASK_ASSAY_CD
CNT_DS_LABEL_ASSAY_KEY TASK_ASSAY_REF_CD
CONCEPT_IDENTIFIER_DTA TASK_ASSAY_CD
CONDITIONAL_DTA CONDITIONAL_ASSAY_CD
COND_EXPRESSION_COMP TRIGGER_ASSAY_CD
CONTAINER_EVENT_ASSAY TASK_ASSAY_CD
CV_STEP_REF TASK_ASSAY_CD
CYTO_ADEQUACY_ALPHA_R TASK_ASSAY_CD
CYTO_ENDOCERV_ALPHA_R TASK_ASSAY_CD
CYTO_REPORT_CONTROL ACTION_TASK_ASSAY_CD
CYTO_REPORT_CONTROL ADEQUACY_TASK_ASSAY_CD
CYTO_REPORT_CONTROL ADEQ_REASON_TASK_ASSAY_CD
CYTO_REPORT_CONTROL CLIN_INFO_TASK_ASSAY_CD
CYTO_REPORT_CONTROL DIAGNOSIS_TASK_ASSAY_CD
CYTO_REPORT_CONTROL ENDOCERV_TASK_ASSAY_CD
CYTO_STANDARD_RPT_R TASK_ASSAY_CD
DATA_MAP TASK_ASSAY_CD
DIFFERENTIAL_REF_ASSAY TASK_ASSAY_CD
DOC_SET_ELEMENT_REF TASK_ASSAY_CD
DTA_OFFSET_MIN TASK_ASSAY_CD
EQUATION TASK_ASSAY_CD
HLA_AB_SCREEN_HISTORY_MAP B_CELL_PRA_DTA_CD
HLA_AB_SCREEN_HISTORY_MAP DILUTION_DTA_CD
HLA_AB_SCREEN_HISTORY_MAP METHODOLOGY_DTA_CD
HLA_AB_SCREEN_HISTORY_MAP REACTION_DTA_CD
HLA_AB_SCREEN_HISTORY_MAP T_CELL_PRA_DTA_CD
HLA_AB_SPEC_MAP AB_DTA_CD
HLA_DISPLAY_PRECEDENCE TASK_ASSAY_CD
HLA_DTA_EVENT_MAPPING DTA_CD
HLA_XM_HISTORY_MAP B_CELL_RESULT_DTA_CD
HLA_XM_HISTORY_MAP INTERPRETATION_DTA_CD
HLA_XM_HISTORY_MAP MONO_CELL_RESULT_DTA_CD
HLA_XM_HISTORY_MAP TB_CELL_RESULT_DTA_CD
HLA_XM_HISTORY_MAP T_CELL_RESULT_DTA_CD
HLA_XM_HISTORY_MAP XM_TYPE_DTA_CD
INTERP_COMPONENT INCLUDED_ASSAY_CD
INTERP_DATA TASK_ASSAY_CD
INTERP_RANGE INCLUDED_ASSAY_CD
INTERP_TASK_ASSAY TASK_ASSAY_CD
IO_TOTAL_DEFINITION TASK_ASSAY_CD
MIC_ORDER_LAB TASK_ASSAY_CD
ONLINE_ITEM_DEFINITION TASK_ASSAY_CD
OUTCOME_ACTIVITY TASK_ASSAY_CD
OUTCOME_CATALOG TASK_ASSAY_CD
PHASE_GROUP TASK_ASSAY_CD
PREFIX_REPORT_R DFLT_DIAGNOSTIC_TASK_ASSAY_CD
PREFIX_RPT_FONT_INFO TASK_ASSAY_CD
PROCESSING_TASK TASK_ASSAY_CD
PROFILE_TASK_R TASK_ASSAY_CD
QC_ALPHA_RESPONSES TASK_ASSAY_CD
QC_TROUBLE_STEP TASK_ASSAY_CD
RAD_BILL_CATEGORIES TASK_ASSAY_CD
RAD_EXAM TASK_ASSAY_CD
RAD_REPORT_DETAIL TASK_ASSAY_CD
RAD_TEMPLATE_ASSOC TASK_ASSAY_CD
REFERENCE_RANGE_FACTOR TASK_ASSAY_CD
RELATED_ASSAY TASK_ASSAY_CD
REPORT_DETAIL_TASK TASK_ASSAY_CD
REPORT_HISTORY_GROUPING_R TASK_ASSAY_CD
REPORT_TASK LAST_TASK_ASSAY_CD
RESOURCE_ASSAY_CONTROL TASK_ASSAY_CD
RESULT_HASH INCLUDED_ASSAY_CD
SHX_ELEMENT TASK_ASSAY_CD
SIGN_LINE_DTA_R TASK_ASSAY_CD
SLIDE STAIN_TASK_ASSAY_CD
SLIDE TASK_ASSAY_CD
SN_RPT_FILTER TASK_ASSAY_CD
TASK_DISCRETE_R TASK_ASSAY_CD
TEXT_DATA TASK_ASSAY_CD
TRANS_COMMIT_ASSAY TASK_ASSAY_CD
WF_STFG_REQ TASK_ASSAY_CD


INTERP_DATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Interpretive data
Definition: Stores interpretive data info for a task/assay from the discrete task/assay table
Table Type: REFERENCE





Column Detail - INTERP_DATA


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 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.
INTERP_DATA_ID DOUBLE N A unique, internal, system-assigned number that identifies interpretive data associated with a discrete task assay.
LONG_TEXT_ID DOUBLE N A unique, internal, system-assigned number that identifies the specific interpretive data text. Creates a relationship to the long text table.
SERVICE_RESOURCE_CD DOUBLE N A unique code value that identifies the service resource (such as instrument, bench, or sub section) with which interpretive data is associated for a given discrete task assay. A value of zero indicates any service resource associated with the discrete task assay.
TASK_ASSAY_CD DOUBLE N A unique code value that identifies a specific discrete task assay.
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 - INTERP_DATA


Child Column in INTERP_DATA(FK) Parent Table Name Parent Column Name
Parents: TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD




Parent Column in INTERP_DATA (PK) Child Table Name Child Column Name
Children: INTERP_DATA_ID PERFORM_RESULT INTERP_DATA_ID


PROFILE_TASK_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Profile Task Relationship
Definition: Used to store relationships between order catalog items and the task/assays that comprise them
Table Type: REFERENCE





Column Detail - PROFILE_TASK_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.
CATALOG_CD DOUBLE N A unique code value that identifies a specific order catalog item that is comprised of discrete task assays.
DUP_CHK_ACTION_CD DOUBLE N (Currently not implemented)
DUP_CHK_MIN DOUBLE Y (Currently not implemented)
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.
GROUP_CD DOUBLE N (Currently not implemented)
ITEM_TYPE_FLAG DOUBLE Y Defines the discrete task assay item type as it relates to the order catalog procedure.
PENDING_IND DOUBLE Y Indicates whether results for this discrete task assay must be performed before the order catalog item it is associated with will be considered complete.
POST_PROMPT_IND DOUBLE Y Indicates whether results for this prompt will be posted as performed or verified.
PROMPT_LONG_TEXT_ID DOUBLE N A unique, internal, system-assigned number that identifies the text associated with a prompt procedure. Creates a relationship to the long text table.
PROMPT_RESOURCE_CD DOUBLE N A unique code value that identifies the service resource used to look up reference ranges if the discrete task assay is marked as a prompt.
REFERENCE_TASK_ID DOUBLE N Used to store the identifier of the task that is referenced on the order_task table for CareNet tasklists.
REPEAT_IND DOUBLE Y Indicates whether repeats will be tracked by the system.
RESTRICT_DISPLAY_IND DOUBLE Y This indicator restricts the display of discrete task assays in result entry to only those that have results associated with them.
SEQUENCE DOUBLE Y Defines the sequence in which discrete task assays will be displayed in result entry applications.
TASK_ASSAY_CD DOUBLE N A unique code value that identifies the discrete task assay that is associated with the order catalog item.
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.
VERSION_NBR DOUBLE Y (Currently not implemented)



Relationship Detail - PROFILE_TASK_R


Child Column in PROFILE_TASK_R(FK) Parent Table Name Parent Column Name
Parents: TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
CATALOG_CD SERVICE_DIRECTORY CATALOG_CD




Parent Column in PROFILE_TASK_R (PK) Child Table Name Child Column Name
Children: CATALOG_CD ORDER_TASK_PROFILE_XREF CATALOG_CD
TASK_ASSAY_CD ORDER_TASK_PROFILE_XREF TASK_ASSAY_CD
CATALOG_CD PROFILE_RESOURCE_LIST CATALOG_CD
TASK_ASSAY_CD PROFILE_RESOURCE_LIST TASK_ASSAY_CD
CATALOG_CD REPORT_INPROC_STATUS CATALOG_CD
TASK_ASSAY_CD REPORT_INPROC_STATUS TASK_ASSAY_CD