Table Detail Report

EQUATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Equation
Definition: Defines the equation to be performed to evaluate for a procedure result.
Table Type: REFERENCE





Column Detail - EQUATION


Column Name Type Null? Definition
ACTIVE_DT_TM DATETIME Y Defines the date and time the equation was last activated.
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.
AGE_FROM_MINUTES DOUBLE Y Defines the beginning age range defined for the calculation.
AGE_FROM_UNITS_CD DOUBLE N A unique code value that identifies the units of age for the beginning of the age range.
AGE_TO_MINUTES DOUBLE Y Defines the ending age range defined for the calculation.
AGE_TO_UNITS_CD DOUBLE N A unique code value that identifies the units of age for the ending of the age range.
DEFAULT_IND DOUBLE Y Indicates whether the equation is the default equation for the procedure.
EQUATION_DESCRIPTION VARCHAR(2000) Y Character description for the equation that is parsed when the equation is performed by the resulting application.
EQUATION_ID DOUBLE N A unique, internal, system-assigned number that identifies a specific equation.
EQUATION_POSTFIX VARCHAR(2000) Y Stores the equation in a postfix format. Used mainly for instrument processing.
GESTATIONAL_AGE_IND DOUBLE Y Indicates whether the equation applies to gestational age. A value of 0 indicates the equation is not for gestational age. A value of 1 indicates the equation is for gestational ages.
INACTIVE_DT_TM DATETIME Y Defines the date and time the equation was set to be inactive.
SCRIPT VARCHAR(50) Y Defines a site-specific script to be used for interpretations. (Currently not implemented)
SERVICE_RESOURCE_CD DOUBLE N A unique code value that identifies the service resource associated with the equation. A value of zero means all service resources.
SEX_CD DOUBLE N A unique code value that identifies the sex of the person for which the equation is to be used.
SPECIES_CD DOUBLE N A unique code value that identifies the species of the patient for which the equation is to be used.
TASK_ASSAY_CD DOUBLE N A unique code value that identifies the discrete task assay for which the equation is defined.
UNKNOWN_AGE_IND DOUBLE N Indicates whether the equation is for patients with an unknown age or birth date. A value of 0 indicates the equation is not used for patients with unknown ages or birth dates. A value of 1 indicates the equation is for patients with unknown ages or birth dates.
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 - EQUATION


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




Parent Column in EQUATION (PK) Child Table Name Child Column Name
Children: EQUATION_ID CE_STRING_RESULT EQUATION_ID
EQUATION_COMPONENT EQUATION_ID
PERFORM_RESULT EQUATION_ID


EQUATION_COMPONENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Equation Component
Definition: Defines the component procedures to an equation and all of its attributes.
Table Type: REFERENCE





Column Detail - EQUATION_COMPONENT


Column Name Type Null? Definition
AGE_IND DOUBLE Y Was to be used for interpretation. (Currently not implemented)
COMPONENT_FLAG DOUBLE Y Defines the equation component type.
CONSTANT_VALUE DOUBLE Y Defines the value of a constant defined in the equation.
CROSS_DRAWN_DT_TM_IND DOUBLE Y Indicates whether the equation component may cross drawn date and time when looking up the result to be used in the equation. A value of 0 indicates the equation component will not cross drawn date and time. A value of 1 indicates the equation component may cross drawn date and time.
DEFAULT_VALUE DOUBLE Y Defines the value to use when a component result is not found and the result required flag is set to allow a default to be used.
EQUATION_ID DOUBLE N A unique, internal, system-assigned number that identifies a specific equation component. Creates a relationship to the equation table.
INCLUDED_ASSAY_CD DOUBLE N Defines the discrete task assay procedure to be used as a component of the equation.
LOOK_TIME_DIRECTION_FLAG DOUBLE N Identifies to use TIME_WINDOW_MINS and TIME WINDOW_BACK_MINUTES in an order. 0: TIME_WINDOW_BACK_MINUTES 1st and TIME_WINDOW_MINUTES 2nd 1: TIME_WINDOW_MINUTES 1st and TIME_WINDOW_BACK_MINUTES 2nd
NAME VARCHAR(50) Y Describes the component by either the procedure mnemonic or the free textname for a constant or variable.
OCTAL_VALUE DOUBLE Y Was to be used for interpretation. (Currently not implemented)
RACE_IND DOUBLE Y Was to be used for interpretation. (Currently not implemented)
RESULT_REQ_FLAG DOUBLE Y Defines whether the component is required to have a result before the equation will be processed.
RESULT_STATUS_CD DOUBLE N A unique code value that identifies the lowest level at which the procedure result status can be to include this component in the equation.
SEQUENCE DOUBLE N Defines the sequence number when multiple components are defined for an equation.
SEX_IND DOUBLE Y Was to be used for interpretation. (Currently not implemented)
TIME_WINDOW_BACK_MINUTES DOUBLE Y Defines the amount of time in minutes to look back from the collected time of the current specimen to the collected time of the previous specimen for using a result in an equation.
TIME_WINDOW_MINUTES DOUBLE Y Defines the amount of time to look across the drawn date and time to find a component that is set to cross drawn date and time.
UNITS_CD DOUBLE N A unique code value that identifies the unit in which this component is measured. This field is not used by PathNet, but is filled out by Power Forms.
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.
VARIABLE_PROMPT VARCHAR(50) Y Stores the prompt to display for a variable to be entered at run time. (Currently not implemented)



Relationship Detail - EQUATION_COMPONENT


Child Column in EQUATION_COMPONENT(FK) Parent Table Name Parent Column Name
Parents: EQUATION_ID EQUATION EQUATION_ID


EXT_CODING_GTTD



Column Section Top of Page


Table-level Detail

Description: External Coding Global Temp Table
Definition: Global Temp Table to assist with qualifying external codes on searches.
Table Type: ACTIVITY





Column Detail - EXT_CODING_GTTD


Column Name Type Null? Definition
CODE_TXT VARCHAR(255) Y Contains a codified string value
CODING_SYSTEM_URI VARCHAR(255) Y The URI of the coding system.
INCLUDE_IND DOUBLE Y Indicates whether the code should be included or excluded
VERSION_TXT VARCHAR(255) Y The version of the coding system, if applicable.


GEN_LAB_EXT_DATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Gen Lab External Data
Definition: To temporarily hold untrested data that has come from an external source (e.g. FHIR)
Table Type: ACTIVITY





Column Detail - GEN_LAB_EXT_DATA


Column Name Type Null? Definition
ACTION_DT_TM DATETIME Y The date and time of the action.
ACTION_PRSNL_ID DOUBLE N The personnel who performed the action.
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 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.
CLIENT_IDENT VARCHAR(80) Y The identifier of the client who last updated the document.
CLIN_SIG_DT_TM DATETIME Y The clinically significant date and time of this lab result.
CORRELATION_IDENT VARCHAR(80) N Uppercase, hyphenated GUID that identifies the transaction that updated this row.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data.
DATA_TYPE_FLAG DOUBLE Y Identifies the type of external data.
ENCNTR_ID DOUBLE N The encounter related to the external data.
EVENT_CD DOUBLE Y Identifies the event code for the result, indicating which test the result describes.
EVENT_ID DOUBLE N The id of the clinical event associated to this lab result.
GEN_LAB_EXT_BLOB LONGBLOB Y The data that has come from an external interface.
GEN_LAB_EXT_DATA_ID DOUBLE N Unique generated number that identifies a single row on the GEN_LAB_EXT_DATA table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
PARENT_EXT_DATA_ID DOUBLE N This unique identifier is used to indicate the parent external data that groups this external data row is related to.
PERSON_ID DOUBLE N The person related to the external data.
REQUESTED_ACTION_CD DOUBLE N Action requested for the data.
SUBMITTED_DT_TM DATETIME Y The date and time this external data was added to the staging tables.
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.



Relationship Detail - GEN_LAB_EXT_DATA


Child Column in GEN_LAB_EXT_DATA(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PARENT_EXT_DATA_ID GEN_LAB_EXT_DATA GEN_LAB_EXT_DATA_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
PERSON_ID PERSON PERSON_ID
ACTION_PRSNL_ID PRSNL PERSON_ID




Parent Column in GEN_LAB_EXT_DATA (PK) Child Table Name Child Column Name
Children: GEN_LAB_EXT_DATA_ID GEN_LAB_EXT_DATA PARENT_EXT_DATA_ID
LAB_EXT_IDENTIFIER GEN_LAB_EXT_DATA_ID


INCLUDED_COMPONENTS



Column Section Top of Page


Table-level Detail

Description: Included Components
Definition: Defines the components that were used to perform a result for a calculation.
Table Type: ACTIVITY





Column Detail - INCLUDED_COMPONENTS


Column Name Type Null? Definition
ACTIVITY_FLAG DOUBLE Y Used to determine if the result was taken from activity or from clinical events. (Currently not implemented)
PERFORM_RESULT_ID DOUBLE N A unique, internal, system-assigned number that identifies a specific perform result value of the equation. Creates a relationship to the perform result table.
RESULT_ID DOUBLE N A unique. internal. system-assigned number that identifies a specific result value used as a component of the equation. Creates a relationship to the result 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.
USED_PERFORM_RESULT_ID DOUBLE N A unique, internal, system-assigned number that identifies a specific perform result value used as a component of the equation. Creates a relationship to the perform result table.