Table Detail Report

REFERENCE_RANGE_FACTOR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Reference Range Factor
Definition: Stores reference range information for a specific discrete task assay. Used to store all reference range paramaters to flex numeric or alpha result types.
Table Type: REFERENCE





Column Detail - REFERENCE_RANGE_FACTOR


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.
AGE_FROM_MINUTES DOUBLE Y Defines the beginning age in minutes for a defined reference range.
AGE_FROM_UNITS_CD DOUBLE N A unique code value that identifies the specific age units (such as days, months, years, and so on) for the beginning age reference range.
AGE_TO_MINUTES DOUBLE Y Defines the ending age in minutes for a defined reference range.
AGE_TO_UNITS_CD DOUBLE N A unique code value that identifies the specific age units (such as days, months, years, and so on) for the ending age reference range.
ALPHA_RESPONSE_IND DOUBLE Y Indicates whether alpha responses apply for the reference range defined. (No longer used)
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.
CODE_SET DOUBLE Y Defines the code set used to validate reference ranges for assays with the result type of "online code set".
CRITICAL_HIGH DOUBLE Y Defines the critical high reference range.
CRITICAL_IND DOUBLE Y Indicates whether critical result reference ranges are defined.
CRITICAL_LOW DOUBLE Y Indicates the critical low value for a reference range.
DEFAULT_RESULT DOUBLE Y Defines the default result value associated with specified reference range.
DEF_RESULT_IND DOUBLE Y Indicates whether the default result value has been defined for the reference range.
DELTA_CHECK_TYPE_CD DOUBLE N A unique code value that identifies the type of delta checking algorithm to use.
DELTA_CHK_FLAG DOUBLE Y Defines the type of delta checking to perform.
DELTA_MINUTES DOUBLE Y Defines the specific number of minutes used to calculate the delta checking algorithm.
DELTA_VALUE DOUBLE Y Defines the value used to perform delta checking.
DILUTE_IND DOUBLE Y Indicates whether a dilution will be required for results that exceed the limits of the linear high range column.
ENCNTR_TYPE_CD DOUBLE N A unique code value that identifies the encounter type (i.e. patient type) used to flex the reference range.
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.
FEASIBLE_HIGH DOUBLE Y Defines the feasible high value for the defined reference range. Typically, this is the limit above which no result is possible.
FEASIBLE_IND DOUBLE Y Indicates whether feasible limits exist for the reference range.
FEASIBLE_LOW DOUBLE Y Defines the feasible low value for the reference range. Typically, this is the limit below which no result is possible.
GESTATIONAL_IND DOUBLE Y Indicates whether the reference range defined is for the gestational age.
LINEAR_HIGH DOUBLE Y Defines the linear high limit for the reference range. Result values above this limit are considered out of the linear high limits of the service resource specified.
LINEAR_IND DOUBLE Y Indicates whether linear limits exist for the reference range.
LINEAR_LOW DOUBLE Y Defines the linear low limit for the reference range. Result values below this limit are considered out of the linear low limits of the service resource specified.
MINS_BACK DOUBLE Y Used to calculate the minutes back from the previous result to default the value for the current result for CareNet applications.
NORMAL_HIGH DOUBLE Y Defines the normal high reference range value for a specific discrete task assay.
NORMAL_IND DOUBLE Y Indicates whether normal ranges are built for the reference range specified.
NORMAL_LOW DOUBLE Y Defines the normal low value for the reference range.
ORGANISM_CD DOUBLE N (Currently not implemented)
PATIENT_CONDITION_CD DOUBLE N A unique code value that identifies the patient condition that is stored for the reference range. (Currently not implemented)
PRECEDENCE_SEQUENCE DOUBLE Y Used to determine which reference range row to use when all matching criteria are the same.
REFERENCE_RANGE_FACTOR_ID DOUBLE N A unique, internal, system-assigned number that identifies a specific reference range factor row.
REF_RANGE_RULE_IND DOUBLE N Indicates that there are reference flexing rules. These are stored on the ref_range_factor_rule table.
REVIEW_HIGH DOUBLE Y Defines the review high reference range limit for a discrete task assay.
REVIEW_IND DOUBLE Y Indicates whether review range values are defined for the reference range.
REVIEW_LOW DOUBLE Y Defines the value for the review low reference range.
SENSITIVE_HIGH DOUBLE Y Defines the value for the sensitive high reference range.
SENSITIVE_IND DOUBLE Y Indicates whether sensitive range values are defined for the reference range.
SENSITIVE_LOW DOUBLE Y Defines the sensitive low value for the reference range.
SERVICE_RESOURCE_CD DOUBLE N A unique code value that identifies the service resource (such as instrument, bench, or sub section) that will affect the reference range defined. A value of zero represents any service resource.
SEX_CD DOUBLE N A unique code value that identifies the sex adjustment for the reference range. A value of zero represents any sex.
SPECIES_CD DOUBLE N A unique code value that identifies the species for the defined reference range. A value of zero represents any species.
SPECIMEN_TYPE_CD DOUBLE N A unique code value that identifies the specimen type for the defined reference range. A value of zero represents any specimen type.
TASK_ASSAY_CD DOUBLE N A unique code value that identifies the discrete task assay to which the reference range applies.
UNITS_CD DOUBLE N A unique code value that identifies the specific units of measure to be appended to results for the defined reference range.
UNKNOWN_AGE_IND DOUBLE Y Indicates whether the reference range stored is for unknown ages.
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 - REFERENCE_RANGE_FACTOR


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




Parent Column in REFERENCE_RANGE_FACTOR (PK) Child Table Name Child Column Name
Children: REFERENCE_RANGE_FACTOR_ID ADVANCED_DELTA REFERENCE_RANGE_FACTOR_ID
ALPHA_RESPONSES REFERENCE_RANGE_FACTOR_ID
ALPHA_RESPONSES_CATEGORY REFERENCE_RANGE_FACTOR_ID
CHARGE_EVENT_ACT REFERENCE_RANGE_FACTOR_ID
PERFORM_RESULT REFERENCE_RANGE_FACTOR_ID
PROP_RESULT REFERENCE_RANGE_FACTOR_ID
REF_RANGE_FACTOR_RULE REFERENCE_RANGE_FACTOR_ID
REF_RANGE_NOTIFY_TRIG REFERENCE_RANGE_FACTOR_ID


REF_RANGE_FACTOR_RULE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Reference Range Factor Rule
Definition: Contains rules related to the reference range factor table.
Table Type: REFERENCE





Column Detail - REF_RANGE_FACTOR_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.
CRITICAL_HIGH DOUBLE N Defines the critical high limit for the reference range. Result values above this limit are considered out of the normal limits of the service resource specified.
CRITICAL_LIMIT_IND DOUBLE N Indicates whether critical limits exist for the reference range rule.
CRITICAL_LOW DOUBLE N Defines the Critical Low limit for the reference range. Result values below this limit are considered out of the critical low limits of the service resource specified.
DEFAULT_RESULT_IND DOUBLE N Indicates whether the default result value has been defined for the reference range.
DEFAULT_RESULT_VALUE DOUBLE N Defines the default result value associated with specified reference range.
FEASIBLE_HIGH DOUBLE N Defines the feasible high limit for the reference range. Result values above this limit are considered out of the feasible limits of the service resource specified.
FEASIBLE_LIMIT_IND DOUBLE N Indicates whether feasible limits exist for the reference range rule.
FEASIBLE_LOW DOUBLE N defines the feasible low limit for the reference range. Result values below this limit are considered out of the feasible low limits of the service resource specified.
FROM_GESTATION_DAYS DOUBLE N Contains the from side of the range of the gestational age of the patient at the birth measured in days.
FROM_HEIGHT DOUBLE N The from side of the range of height through which the reference is flexed.
FROM_HEIGHT_UNIT_CD DOUBLE N Contains the unit of measure for the height.
FROM_WEIGHT DOUBLE N The from side of the range of weight through which the reference is flexed.
FROM_WEIGHT_UNIT_CD DOUBLE N Contains the unit of measure for the weight.
LOCATION_CD DOUBLE N Contains the location of the patient when the results are documented.
MINUTES_BACK DOUBLE Y Used to calculate the minutes back from the previous result to default the value for the current result for CareNet applications.
NORMAL_HIGH DOUBLE N Defines the normal high limit for the reference range. Result values above this limit are considered out of the normal high limits of the service resource specified.
NORMAL_LIMIT_IND DOUBLE N Indicates whether the normal limits exist for the reference range rule.
NORMAL_LOW DOUBLE N Defines the normal low limit for the reference range. Result values below this limit are considered out of the normal low limits of the service resource specified.
REFERENCE_RANGE_FACTOR_ID DOUBLE N Uniquely identifies the reference range factor related to this rule.
REF_RANGE_FACTOR_RULE_ID DOUBLE N Uniquely identifies a rule for a given reference range factor.
RESULT_MEASUREMENT_UNIT_CD DOUBLE N A unique code value that identifies the specific units of measure to be appended to results for the defined reference range.
TO_GESTATION_DAYS DOUBLE N Contains the to side of the range of the gestational age of the patient at birth measured in days.
TO_HEIGHT DOUBLE N Contains the to side of the range of the height through which the reference is flexed.
TO_HEIGHT_UNIT_CD DOUBLE N Contains the unit of measure for the height.
TO_WEIGHT DOUBLE N Contains the to side of the range of weight through which the reference is flexed.
TO_WEIGHT_UNIT_CD DOUBLE N Contains the unit of measure for the weight.
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 - REF_RANGE_FACTOR_RULE


Child Column in REF_RANGE_FACTOR_RULE(FK) Parent Table Name Parent Column Name
Parents: REFERENCE_RANGE_FACTOR_ID REFERENCE_RANGE_FACTOR REFERENCE_RANGE_FACTOR_ID




Parent Column in REF_RANGE_FACTOR_RULE (PK) Child Table Name Child Column Name
Children: REF_RANGE_FACTOR_RULE_ID ALPHA_RESPONSE_RULE REF_RANGE_FACTOR_RULE_ID


RELATED_ASSAY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Related assay
Definition: Used to store information at the assay level about other assay that may be related to each other for functional/informational reasons (i.e. delta checking, reporting)
Table Type: REFERENCE





Column Detail - RELATED_ASSAY


Column Name Type Null? Definition
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.
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.
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.
RELATED_ENTITY_ID DOUBLE N A unique, internal, system-assigned number that identifies a specific relationship between related discrete task assays.
REL_TYPE_CD DOUBLE N A unique code value that identifies the specific type of relationship between discrete task assays.
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 - RELATED_ASSAY


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


SERVICE_DIRECTORY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Service directory
Definition: Sub-type table of order catalog that contains more details for catalog item
Table Type: REFERENCE





Column Detail - SERVICE_DIRECTORY


Column Name Type Null? Definition
ACTIVE_DT_TM DATETIME Y (Currently not implemented)
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.
BB_DEFAULT_PHASES_CD DOUBLE N A unique code value that identifies the processing code used by Blood Bank result entry to set the default phases for Blood Bank order catalog items.
BB_PROCESSING_CD DOUBLE N A unique code value that identifies the processing code used by Blood Bank result entry to drive prompts and workflow in the Blood Bank result entry applications.
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.
BIOLOGICAL_CATEGORY_CD DOUBLE N Denotes the origin of the sequence of the part of the DNA or RNA being tested and the species of the organism being tested (animal, bacteria, or virus) for this orderable.
CATALOG_CD DOUBLE N A unique code value that identifies a specific order catalog item.
CHARGE_AT_GROUP_DETAIL DOUBLE Y (Currently not implemented)
DESCRIPTION VARCHAR(100) Y Used to store the long description of the order catalog item.
DUP_CHECK_LVL_FLAG 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_IND DOUBLE Y (Currently not implemented)
INACTIVE_DT_TM DATETIME Y (Currently not implemented)
PROMPT_IND DOUBLE Y Indicates whether the discrete task assay has been associated with an order catalog item that is marked as a prompt.
RAD_FLOURO_USED_IND DOUBLE Y *** OBSOLETE - no longer used *** Indicates whether flouroscopy is used for the procedure.
RAD_ORGAN_ID DOUBLE N *** OBSOLETE - no longer used *** A unique, internal, system-assigned number that identifies a specific Radiology exposure value associated with the procedure. Creates a relationship to the radiology exposure values table.
RAD_PROTOCOL_REQ_IND DOUBLE N Indicates if this orderable requires protocolling.
SHORT_DESCRIPTION VARCHAR(100) Y Used to store the short description of the order catalog item.
SPECIMEN_REQUIRED DOUBLE Y Indicates whether a specimen is required for this order catalog item.
SYNONYM_ID DOUBLE N A unique, internal, system-assigned number that identifies the primary synonym for the order catalog item. Creates a relationship to the order catalog synonym table.
SYSTEM_DEFINED_IND 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.



Relationship Detail - SERVICE_DIRECTORY


Child Column in SERVICE_DIRECTORY(FK) Parent Table Name Parent Column Name
Parents: CATALOG_CD ORDER_CATALOG CATALOG_CD
RAD_ORGAN_ID RAD_EXPOSURE_VALUES EXPOSURE_VALUE_ID




Parent Column in SERVICE_DIRECTORY (PK) Child Table Name Child Column Name
Children: CATALOG_CD DEPT_DUP_CHECK CATALOG_CD
EXAM_FOLDER CATALOG_CD
EXAM_REASON CATALOG_CD
FILM_USAGE CATALOG_CD
PROFILE_TASK_R CATALOG_CD
RAD_PROTOCOL_CATALOG_R CATALOG_CD
REPLACE_GROUPING CATALOG_CD
REPLACE_GROUPING REPLACE_CATALOG_CD


TEXT_DATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Text Data (Currently not implemented)
Definition: Used to store text information for task/assays
Table Type: REFERENCE





Column Detail - TEXT_DATA


Column Name Type Null? Definition
RESULT_TEMPLATE_CD DOUBLE N Not used currently
TASK_ASSAY_CD DOUBLE N Used to store the code for the task/assay that has associated text
TEMPLATE_USED DOUBLE Y Not used currently
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 - TEXT_DATA


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