Table Detail Report
PDM_DATA_POINT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Patient Data Monitoring Data Point |
Definition: | Table used to store each group of PDM results |
Table Type: | ACTIVITY |
Column Detail - PDM_DATA_POINT
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. |
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. |
PDM_DP_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific patient data monitoring data point. |
PDM_PARAM_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies the specific patient data monitoring parameters associated with the data point. Creates a relationship to the patient data monitoring parameters table. |
PDM_RANGE_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies the specific patient data monitoring range associated with the data point. Creates a relationship to the patient data monitoring ranges table. |
SEQUENCE | DOUBLE | N | Defines the sequence of the next result in line. |
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 - PDM_DATA_POINT
Parent Column in PDM_DATA_POINT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PDM_DP_ID | QC_RESULT | PDM_DP_ID |
PDM_PARAMS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Patient Data Monitoring Parameters |
Definition: | Stores the reference data for Quatlity Control Patient Data Monitoring. |
Table Type: | REFERENCE |
Column Detail - PDM_PARAMS
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. |
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. |
MIN_NBR_RESULTS | DOUBLE | N | Defines the minimum number of patient results required before converting the results into a quality control result. |
NBR_RESULTS | DOUBLE | N | Defines the number of patient results to use for the creation of a quality control result. Once this number is reached, the QC result will be created and the count will start over. |
PDM_PARAM_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies specific patient data monitoring parameters. |
RESULT_EVAL_FLAG | DOUBLE | N | Defines the number of results or the time period required to generate a quality control result. |
RULE_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies the specific rule set used to evaluate the quality control result. |
SERVICE_RESOURCE_CD | DOUBLE | N | A unique code value that identifies the specific service resource where the result was performed. |
TASK_ASSAY_CD | DOUBLE | N | A unique code value that identifies the specific discrete task assay associated with the quality control result entered in the system. |
TIME_PERIOD_MINUTES | DOUBLE | N | Defines the number of minutes to accumulate patient results before converting them into a quality control result. |
TIME_PERIOD_UNITS_CD | DOUBLE | N | A unique code value that identifies the time units of measure (such as day, week, and so on) to accumulate patient results before converting them into a quality control result. |
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 - PDM_PARAMS
Parent Column in PDM_PARAMS (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PDM_PARAM_ID | PDM_RANGES | PDM_PARAM_ID |
QC_RESULT | PDM_PARAM_ID | ||
QC_STAT_PERIOD | PDM_PARAM_ID |
PDM_RANGES
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Patient Data Monitoring Ranges |
Definition: | Stores the range specific information for Patient Data Monitoring. |
Table Type: | REFERENCE |
Column Detail - PDM_RANGES
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. |
AGE_FROM_MINUTES | DOUBLE | N | Defines the beginning age range used to determine if a patient's result should be included or excluded in the calculation of the quality control result. |
AGE_FROM_UNITS_CD | DOUBLE | N | A unique code value that identifies the units of age for the beginning age range. |
AGE_TO_MINUTES | DOUBLE | N | Defines the ending age range used to determine if a patient's result should be included or excluded in the calculation of the quality control result. |
AGE_TO_UNITS_CD | DOUBLE | N | A unique code value that identifies the units of age for the ending age range. |
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. |
MEAN | DOUBLE | N | Defines the expected quality control mean for the defined range parameters. |
PDM_PARAM_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies the specific patient data monitoring parameters associated with the patient data monitoring ranges. |
PDM_RANGE_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies specific patient data monitoring range parameters. Ranges are defined by the combination of species, gender, and age range. |
RESULT_HIGH | DOUBLE | N | Defines the high end of the trimming range. Results greater than the result high value will not be used to create the quality control result. |
RESULT_LOW | DOUBLE | N | Defines the low end of the trimming range. Results less than the result low value will not be used to create the quality control result. |
SEQUENCE | DOUBLE | N | Stores the sequence of the ranges for a set of patient data monitoring parameters. |
SEX_CD | DOUBLE | N | A unique code value that identifies the gender used to determine if a patient's result should be included or excluded in the calculation of the quality control result. |
SPECIES_CD | DOUBLE | N | A unique code value that identifies the species used to determine if a patient's result should be included or excluded in the calculation of the quality control result. |
STD_DEV | DOUBLE | N | Defines the expected standard deviation for the given patient data monitoring range. |
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 - PDM_RANGES
Child Column in PDM_RANGES(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PDM_PARAM_ID | PDM_PARAMS | PDM_PARAM_ID |
Parent Column in PDM_RANGES (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PDM_RANGE_ID | QC_RESULT | PDM_RANGE_ID |
QC_STAT_PERIOD | PDM_RANGE_ID |
PDM_RESULT
Column Section | Top of Page |
Table-level Detail
Description: | Patient Data Monitoring Result |
Definition: | Table used to hold each patient data monitoring result created. |
Table Type: | ACTIVITY |
Column Detail - PDM_RESULT
Column Name | Type | Null? | Definition |
---|---|---|---|
PDM_DP_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies the patient data monitoring data point created for this group of results. Creates a relationship to the patient data monitoring data point table. |
PERFORM_DT_TM | DATETIME | N | Stores the date and time the result was performed by the instrument or manually in Accession Result Entry. |
PERFORM_RESULT_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies the specific result value used. Creates a relationship to the perform result table. |
SEQUENCE | DOUBLE | N | Defines the sequence of results within the data point. |
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. |
ZSCORE | DOUBLE | N | Defines the value that was created for the Z Score when this row was written by pfmt_gl_to_pdm. |
PERFORM_RESULT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Perform Result |
Definition: | Stores result values and corresponding information relating to the result. If a result is performed multiple times a new entry into the table is added. |
Table Type: | ACTIVITY |
Column Detail - PERFORM_RESULT
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_SEQUENCE | DOUBLE | Y | Defines the sequence to use when selecting a row from the result comment table. (Currently not implemented) |
ADVANCED_DELTA_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies the specific advanced delta check reference rule that was used to evaluate a result that failed delta checking. Creates a relationship to the advanced delta table. |
APP_MODE_IND | DOUBLE | Y | This indicator is used to show what application/application mode this result came from. The possible values are: 1 = AccessionResultEntry Accession Mode 2 = AccessionResultEntry Worklist Mode 3 = AccessionResultEntry Instrument Queue Mode 4 = AccessionResultEntry Correction Mode 5 = AccessionResultEntry Differential Mode 6 = BatchResultEntry Mode 7 = Multiple Accession Result Verification Mode If the value is + 100, it means that synchronous posting to clinical events was used. |
ASCII_TEXT | VARCHAR(60) | Y | If the procedure is defined as free-text, the result value is stored. If the procedure is defined as text or interpretation, the first 60 characters of the text without RTF attributes is stored. |
AV_ERROR_CD | DOUBLE | N | A unique code value that identifies a specific autoverification error code if the autoverification server is not able to autoverify a result. |
CONTAINER_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific container holding the specimen on which the procedure was performed to produce the result. Creates a relationship to the container table. |
CRITICAL_CD | DOUBLE | N | A unique code value that identifies whether a result has passed or failed critical result reference range. |
DELTA_CD | DOUBLE | N | A unique code value that identifies whether the result value has passed or failed a delta check. |
DELTA_PERF_RESULT_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific perform result ID of the previous result used in delta checking. |
DILUTION_FACTOR | DOUBLE | Y | Defines the dilution factor to be considered when reviewing a result when the specimen has been diluted for testing. |
EQUATION_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific equation used to create the result value. This field is valid for discrete task assays that are defined as the calculation result type. Creates a relationship to the equation table. |
FEASIBLE_CD | DOUBLE | N | A unique code value that identifies whether a result has passed or failed feasible result reference range. |
IDENTIFIER | VARCHAR(20) | Y | If the result was posted using an identifier from a worklist, the identifier used will be recorded here. (Currently not implemented) |
INTERFACE_FLAG | DOUBLE | Y | Defines how the result was entered into the table. |
INTERFACE_STATUS_FLAG | DOUBLE | N | Will Indicate the result status coming from an instrument.0 - Default, No messages from interface.1 - Modified on Instrument by Operator2 - In result group with an assay that was modified on an instrument |
INTERP_DATA_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies when specific interpretive data is associated with the discrete task assay. Creates a relationship to the interpretive data table. |
INTERP_OVERRIDE_IND | DOUBLE | Y | Indicates whether an interpretation has been overridden and an alpha response entered. A value of 1 indicates when an interpretation has been overridden. A value of 0 indicates when the interpretation has not been overridden. |
LESS_GREAT_FLAG | DOUBLE | Y | Defines whether or not the result value should be viewed qualitatively with a < or > sign. |
LINEAR_CD | DOUBLE | N | A unique code value that identifies whether a result has passed or failed a linear result reference range. |
LONG_TEXT_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies the specific text associated with a textual or interpretation result. Creates a relationship to the long text table. |
MULTIPLEX_RESOURCE_CD | DOUBLE | N | A unique code value that identifies a specific multiplexor that the instrument was running when the interface sent the result across. |
NOMENCLATURE_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific nomenclature selection for an alpha response. Creates a relationship to the nomenclature table. |
NORMAL_ALPHA | VARCHAR(2000) | Y | Defines the normal alpha response for a procedure with the result type of alpha. |
NORMAL_CD | DOUBLE | N | A unique code value that identifies the normal reference range associated with the result value, such as normal, low, or high. |
NORMAL_HIGH | DOUBLE | Y | Defines the normal high reference range value associated with a result. The result must be greater than the normal high to be flagged as high. |
NORMAL_LOW | DOUBLE | Y | Defines the normal low reference range value associated with a result. The result must be less than the normal low to be flagged as low. |
NOTIFY_CD | DOUBLE | N | Indicates the notify flag is applied to this result value. |
NUMERIC_RAW_VALUE | DOUBLE | Y | Stores the numeric result value as transmitted from the instrument or entered by the result entry application before any rounding has been appiled. |
PARENT_PERFORM_RESULT_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies the previous performed result value when a discrete task assay result is changed. Creates a relationship to an associated row on the perform result table. |
PERFORM_DT_TM | DATETIME | Y | Defines the date and time the result was performed. |
PERFORM_PERSONNEL_ID | DOUBLE | N | Defines the person who performed the result for a procedure. |
PERFORM_RESULT_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific perform result value. |
PERFORM_TZ | DOUBLE | Y | Time zone associated with the corresponding DT_TM column. |
POST_ALPHA_IND | DOUBLE | Y | Indicates whether a result was posted as an alpha from an instrument, but changed to the numeric linear value. A value of 1 indicates the result was posted as an alpha from an instrument. A value of 0 indicates the result was posted as received from the instrument. (Currently not implemented) |
QC_OVERRIDE_CD | DOUBLE | Y | A code value that identifies if the user has chosen to override the quality control validation when posting this result to the system. |
RAW_RESULT_STR | VARCHAR(255) | Y | Contains the result exactly as it was sent from the instrument. For alphas, it is what was used to match the mnemonic on nomenclature. For numerics, it is what was posted as the numeric value. For free textit is what was sent and could not be matched to an alpha response. |
REFERENCE_RANGE_FACTOR_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific reference range applied to the result. Creates a relationship to the reference range factor table. |
REPEAT_NBR | DOUBLE | N | Defines the sequence number of a repeated result value. A value of zero represents the original performed result, one is the first repeat, etc. |
RESOURCE_ERROR_CODES | VARCHAR(255) | Y | Stores the error codes that have been sent by an automated instrument while processing a result. |
RESULT_CODE_SET_CD | DOUBLE | N | A unique code value that identifies a specific code value result type for a discrete task assay that is to be resulted as a code value. The code set can be any code set and is not tied specifically to one code set. |
RESULT_ID | DOUBLE | N | A unique, internal, system-assigned number that identifies a specific discrete task assay result. Creates a relationship to the result table. |
RESULT_STATUS_CD | DOUBLE | N | A unique code value that identifies a specific status of the result, such as performed, verified, corrected, and so on. |
RESULT_TYPE_CD | DOUBLE | N | A unique code value that identifies the result type of the result value. |
RESULT_VALUE_ALPHA | VARCHAR(200) | Y | Stores the alpha response text of an alpha procedure. |
RESULT_VALUE_DT_TM | DATETIME | Y | Stores the date and time for a procedure defined as date. |
RESULT_VALUE_NUMERIC | DOUBLE | Y | Stores the numeric result value as rounded for formatting and display. |
REVIEW_CD | DOUBLE | N | A unique code value that identifies whether or not a result has passed or failed the review result reference range. Denotes that a result has been flagged for review. |
SERVICE_RESOURCE_CD | DOUBLE | N | A unique code value that identifies a specific service resource (such as instrument, bench, or sub section) where the procedure was performed. |
UNITS_CD | DOUBLE | N | A unique code value that identifies the units of measure for interpreting the result value. |
UNPERF_FLAG | DOUBLE | Y | Defines how the result is unperformed. (Currently not implemented) |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
WORKLIST_ID | DOUBLE | N | Identifies the automatic worklist associated with the result. |
Relationship Detail - PERFORM_RESULT
Child Column in PERFORM_RESULT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ADVANCED_DELTA_ID | ADVANCED_DELTA | ADVANCED_DELTA_ID |
EQUATION_ID | EQUATION | EQUATION_ID | |
INTERP_DATA_ID | INTERP_DATA | INTERP_DATA_ID | |
NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID | |
REFERENCE_RANGE_FACTOR_ID | REFERENCE_RANGE_FACTOR | REFERENCE_RANGE_FACTOR_ID | |
RESULT_ID | RESULT | RESULT_ID | |
WORKLIST_ID | WORKLIST | WORKLIST_ID |
Parent Column in PERFORM_RESULT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PERFORM_RESULT_ID | BB_EXCEPTION | PERFORM_RESULT_ID |