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