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 |