ADVANCED_DELTA
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Advanced Delta Checking |
Definition: | Stores parameters used for advanced delta checking for General Lab applications |
Table Type: | REFERENCE |
Column Detail - ADVANCED_DELTA
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 | N | 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. |
ADVANCED_DELTA_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific advanced delta check row. |
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. |
DELTA_CHECK_TYPE_CD | DOUBLE | N | A unique code value that identifies the specific type of delta checking (such as absolute, percent, and so on). |
DELTA_HIGH | DOUBLE | Y | Stores the value for the high end of the range for delta checking. |
DELTA_IND | DOUBLE | N | Stores the indicator that is used to determine whether a delta checking range has been entered. Valid values are 0 - no range, 1 - low value only, 2 - high value only, 3 - both low and high values. |
DELTA_LOW | DOUBLE | Y | Used to store the value for the low range to be used for delta checking. |
DELTA_MINUTES | DOUBLE | Y | Defines the number of minutes used to evaluate the delta check rule. |
DELTA_VALUE | DOUBLE | Y | Defines the value used to evaluate delta checking. |
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. |
REFERENCE_RANGE_FACTOR_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies the specific reference range associated with the advanced delta checking parameters. Creates a relationship to the reference range factor table. |
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 - ADVANCED_DELTA
Child Column in ADVANCED_DELTA(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | REFERENCE_RANGE_FACTOR_ID | REFERENCE_RANGE_FACTOR | REFERENCE_RANGE_FACTOR_ID |
Parent Column in ADVANCED_DELTA (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ADVANCED_DELTA_ID | PERFORM_RESULT | ADVANCED_DELTA_ID |
ALPHA_RESPONSES
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Alpha Responses |
Definition: | Used to store codified alpha responses for discrete task assays that are result type of alpha. |
Table Type: | REFERENCE |
Column Detail - ALPHA_RESPONSES
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. |
ALPHA_RESPONSES_CATEGORY_ID | DOUBLE | N | Foreign key to the category for this ALPHA_RESPONSES row. |
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. |
CONCEPT_CKI | VARCHAR(255) | N | The nomenclature concept to which this alpha response is associated. |
DEFAULT_IND | DOUBLE | Y | Used to indicate which alpha response should be used as the default in result entry applications. |
DESCRIPTION | VARCHAR(100) | Y | Used to store the long description of the response. |
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. |
MULTI_ALPHA_SORT_ORDER | DOUBLE | Y | Defines the sort order of alpha responses that are used to result a task or assay with multiple valid alpha results. |
NOMENCLATURE_ID | DOUBLE | N | Stores the identifier (from the nomenclature table) that stores the text for the alpha response. |
REFERENCE_IND | DOUBLE | Y | Indicates if the alpha response selected will be printed on hard-copy charts as the typical "reference" value. |
REFERENCE_RANGE_FACTOR_ID | DOUBLE | N | Used to store the identifier for the row from the reference range factor table that is associated with the alpha response. |
RESULT_PROCESS_CD | DOUBLE | N | Used to store processing codes that would flag alpha responses as normal, abnormal, critical, and so on. |
RESULT_VALUE | DOUBLE | Y | The value associated with the alpha response for a specific assay that would be used for appending additional information to the result. |
SEQUENCE | DOUBLE | N | The sequence in which alpha responses are stored and displayed. |
TRUTH_STATE_CD | DOUBLE | N | This states whether to make the condition true of false based on the nomenclature concept. |
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. |
USE_UNITS_IND | DOUBLE | Y | Used to indicate whether or not units of measure will be appended to the alpha response. |
Relationship Detail - ALPHA_RESPONSES
Child Column in ALPHA_RESPONSES(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ALPHA_RESPONSES_CATEGORY_ID | ALPHA_RESPONSES_CATEGORY | ALPHA_RESPONSES_CATEGORY_ID |
REFERENCE_RANGE_FACTOR_ID | REFERENCE_RANGE_FACTOR | REFERENCE_RANGE_FACTOR_ID |
Parent Column in ALPHA_RESPONSES (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | NOMENCLATURE_ID | ALPHA_RESPONSE_RULE | NOMENCLATURE_ID |
REFERENCE_RANGE_FACTOR_ID | ALPHA_RESPONSE_RULE | REFERENCE_RANGE_FACTOR_ID | |
NOMENCLATURE_ID | CYTO_ALPHA_SECURITY | NOMENCLATURE_ID | |
REFERENCE_RANGE_FACTOR_ID | CYTO_ALPHA_SECURITY | REFERENCE_RANGE_FACTOR_ID | |
NOMENCLATURE_ID | CYTO_DIAG_DISCREPANCY | NOMENCLATURE_X_ID | |
CYTO_DIAG_DISCREPANCY | NOMENCLATURE_Y_ID | ||
REFERENCE_RANGE_FACTOR_ID | CYTO_DIAG_DISCREPANCY | REFERENCE_RANGE_FACTOR_ID | |
CYTO_DIAG_DISCREPANCY | REFERENCE_RANGE_FACTOR_ID | ||
NOMENCLATURE_ID | CYTO_SCREENING_EVENT | NOMENCLATURE_ID | |
REFERENCE_RANGE_FACTOR_ID | CYTO_SCREENING_EVENT | REFERENCE_RANGE_FACTOR_ID |
ALPHA_RESPONSES_CATEGORY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Alpha Responses Category |
Definition: | Allows categorization of Alpha Responses. |
Table Type: | REFERENCE |
Column Detail - ALPHA_RESPONSES_CATEGORY
Column Name | Type | Null? | Definition |
---|---|---|---|
ALPHA_RESPONSES_CATEGORY_ID | DOUBLE | N | Unique, generated key for ALPHA_RESPONSES_CATEGORY. |
CATEGORY_NAME | VARCHAR(100) | N | The identifier and display value for the category. |
DISPLAY_SEQ | DOUBLE | N | Identifies the order the categories will be displayed. |
EXPAND_FLAG | DOUBLE | N | Indicates whether the category is expanded or contracted to show the associated Alpha Responses.0 |
REFERENCE_RANGE_FACTOR_ID | DOUBLE | N | Relates this record to a specific row in the reference_range_factor table. |
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 - ALPHA_RESPONSES_CATEGORY
Child Column in ALPHA_RESPONSES_CATEGORY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | REFERENCE_RANGE_FACTOR_ID | REFERENCE_RANGE_FACTOR | REFERENCE_RANGE_FACTOR_ID |
Parent Column in ALPHA_RESPONSES_CATEGORY (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ALPHA_RESPONSES_CATEGORY_ID | ALPHA_RESPONSES | ALPHA_RESPONSES_CATEGORY_ID |
ALPHA_RESPONSE_RULE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Alpha Response Rule |
Definition: | Contains rules related to a given alpha response. |
Table Type: | REFERENCE |
Column Detail - ALPHA_RESPONSE_RULE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | 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. |
ALPHA_RESPONSE_RULE_ID | DOUBLE | N | Uniquely identifies an alpha response rule. |
NOMENCLATURE_ID | DOUBLE | N | Used in combination with the Reference_Range_Factor_ID to determine the unique alpha response related to this alpha response rule. |
REFERENCE_RANGE_FACTOR_ID | DOUBLE | N | Used in combination with the Nomenclature_ID to determine the unique alpha response related to this alpha response rule. |
REF_RANGE_FACTOR_RULE_ID | DOUBLE | N | Uniquely identifies the reference range factor rule related to the alpha response rule. |
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 - ALPHA_RESPONSE_RULE
Child Column in ALPHA_RESPONSE_RULE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | NOMENCLATURE_ID | ALPHA_RESPONSES | NOMENCLATURE_ID |
REFERENCE_RANGE_FACTOR_ID | ALPHA_RESPONSES | REFERENCE_RANGE_FACTOR_ID | |
REF_RANGE_FACTOR_RULE_ID | REF_RANGE_FACTOR_RULE | REF_RANGE_FACTOR_RULE_ID |
ASSAY_PROCESSING_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Discrete Task Assay Processing Resolution |
Definition: | Stores relationships for assays and the service resouces that perform them. Used to store service resource specific information about task/assays used for result entry parameters |
Table Type: | REFERENCE |
Column Detail - ASSAY_PROCESSING_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. |
CODE_SET | DOUBLE | Y | Used to store the code set referenced if a result type of "online code set" is chosen for a particular assay/resource combination. |
DEFAULT_RESULT_TEMPLATE_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific result template to be displayed by default if a discrete task assay at the indicated service resource is resulted. Creates a relationship to the word processing template table. |
DEFAULT_RESULT_TYPE_CD | DOUBLE | N | A unique code value that identifies the specific default result type for the discrete task assay/service resource combination. |
DISPLAY_SEQUENCE | DOUBLE | Y | Defines the sequence number that determines the order in which the discrete task assays display in result entry applications. |
DNLD_ASSAY_ALIAS | VARCHAR(100) | Y | Defines the alias used to download the discrete task assay to a service resource that is a medical device (i.e. instrument). |
DOWNLD_IND | DOUBLE | Y | Indicates whether downloads will be performed for this service resource. |
LOADED_SERVICE_RESOURCE_CD | DOUBLE | N | Service Resource where tests have been loaded. |
POST_ZERO_RESULT_IND | DOUBLE | Y | Indicates whether the system will accept zeroes as a valid result from this service resource. |
PROCESS_SEQUENCE | DOUBLE | Y | Indicates the sequence that will be used by a service resource for posting results from a medical device interface. |
QC_RESULT_TYPE_CD | DOUBLE | N | A unique code value that identifies a specific result type for QC samples posting from this service resource if it is a medical device (i.e. instrument). |
QC_SEQUENCE | DOUBLE | Y | Used to control the sequence of discrete task assays as they relate to quality control samples posting from a medical device service resource (i.e. instrument). |
SERVICE_RESOURCE_CD | DOUBLE | N | A unique code value that identifies a specific service resource that is 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. |
UPLD_ASSAY_ALIAS | VARCHAR(25) | Y | Defines the alias used for posting the discrete task assay back from a medical device service resource (i.e. instrument). |
Relationship Detail - ASSAY_PROCESSING_R
Child Column in ASSAY_PROCESSING_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TASK_ASSAY_CD | DISCRETE_TASK_ASSAY | TASK_ASSAY_CD |
LOADED_SERVICE_RESOURCE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD | |
SERVICE_RESOURCE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD | |
DEFAULT_RESULT_TEMPLATE_ID | WP_TEMPLATE | TEMPLATE_ID |
Parent Column in ASSAY_PROCESSING_R (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | LOADED_SERVICE_RESOURCE_CD | ASSAY_RESOURCE_TRANSLATION | LOADED_SERVICE_RESOURCE_CD |
SERVICE_RESOURCE_CD | ASSAY_RESOURCE_TRANSLATION | SERVICE_RESOURCE_CD | |
TASK_ASSAY_CD | ASSAY_RESOURCE_TRANSLATION | TASK_ASSAY_CD |