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 |