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. |