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