Table Detail Report
CNT_DTA_RRF_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CNT DTA RRF R |
Definition: | DTA RRF RELTN |
Table Type: | REFERENCE |
Column Detail - CNT_DTA_RRF_R
Column Name | Type | Null? | Definition |
---|---|---|---|
CNT_DTA_ID | DOUBLE | N | Sequence generated ID (Value: 0.0) |
CNT_DTA_RRF_R_ID | DOUBLE | N | Sequence generated ID - PRIMARY KEY |
CNT_RRF_ID | DOUBLE | N | Sequence generated ID (Value: 0.0) |
RRF_UID | VARCHAR(100) | N | Unique identifier for Reference Range Factor |
TASK_ASSAY_UID | VARCHAR(100) | N | Unique identifier for DTA |
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 - CNT_DTA_RRF_R
Child Column in CNT_DTA_RRF_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CNT_DTA_ID | CNT_DTA | CNT_DTA_ID |
CNT_RRF_ID | CNT_RRF | CNT_RRF_ID |
CNT_EQUATION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CNT EQUATION |
Definition: | CONTENT EQUATION INFORMATION |
Table Type: | REFERENCE |
Column Detail - CNT_EQUATION
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 defined for the calculation. |
AGE_FROM_UNITS_CD | DOUBLE | N | Code Set: 66 a unique code value that identifies the units of age for the beginning of the age range. |
AGE_FROM_UNITS_CDUID | VARCHAR(100) | N | Unique identifier for Age From Units Code Value |
AGE_TO_MINUTES | DOUBLE | N | defines the ending age range defined for the calculation. |
AGE_TO_UNITS_CD | DOUBLE | N | Code Set: 66 a unique code value that identifies the units of age for the ending of the age range. |
AGE_TO_UNITS_CDUID | VARCHAR(100) | N | Unique identifier for Age To Units Code Value |
CNT_DTA_KEY_ID | DOUBLE | N | Sequence generated ID (Value: 0.0) FK from CNT_DTA_KEY2 |
CNT_EQUATION_ID | DOUBLE | N | Sequence generated ID - PRIMARY KEY |
DEFAULT_IND | DOUBLE | N | indicates whether the equation is the default equation for the procedure. |
EQUATION_DESCRIPTON | 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. |
EQUATION_UID | VARCHAR(100) | N | UNIQUE IDENTIFIER FOR THE EQUATION |
GESTATIONAL_AGE_IND | DOUBLE | N | 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. |
SCRIPT_NAME | VARCHAR(50) | Y | defines a site-specific script to be used for interpretations. (currently not implemented) |
SERVICE_RESOURCE_CD | DOUBLE | N | Code Set: 221 a unique code value that identifies the service resource associated with the equation. a value of zero means all service resources. |
SERVICE_RESOURCE_CDUID | VARCHAR(100) | N | Unique identifier for Service Resource Code Value |
SEX_CD | DOUBLE | N | Code Set: 57 a unique code value that identifies the sex of the person for which the equation is to be used. |
SEX_CDUID | VARCHAR(100) | N | Unique identifier for Sex Code Value |
SPECIES_CD | DOUBLE | N | Species code from Code Set: 226 |
SPECIES_CDUID | VARCHAR(100) | N | Unique identifier for Species Code Value |
TASK_ASSAY_CD | DOUBLE | N | a unique code value that identifies a specific discrete task assay. |
TASK_ASSAY_UID | VARCHAR(100) | N | Unique identifier for DTA |
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 - CNT_EQUATION
Child Column in CNT_EQUATION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CNT_DTA_KEY_ID | CNT_DTA_KEY2 | CNT_DTA_KEY_ID |
Parent Column in CNT_EQUATION (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CNT_EQUATION_ID | CNT_EQUATION_COMPONENT | CNT_EQUATION_ID |
CNT_EQUATION_COMPONENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CNT EQUATION COMPONENT |
Definition: | CONTENT EQUATION COMPONENTS |
Table Type: | REFERENCE |
Column Detail - CNT_EQUATION_COMPONENT
Column Name | Type | Null? | Definition |
---|---|---|---|
AGE_IND | DOUBLE | N | was to be used for interpretation. (currently not implemented) |
CNT_EQUATION_COMPONENT_ID | DOUBLE | N | Sequence generated ID |
CNT_EQUATION_ID | DOUBLE | N | FK to CNT_EQUATION |
COMPONENT_FLAG | DOUBLE | N | FLAG_VALUE:DESCRIPTION:DEFINITION 1.00:Procedure:Denotes the row as defining a procedure. 2.00:Variable:(not currently implemented) 3.00:Constant:Denotes the row as defining a constant. |
COMPONENT_NAME | VARCHAR(50) | Y | describes the component by either the procedure mnemonic or the free textname for a constant or variable. |
COMPONENT_SEQUENCE | DOUBLE | N | defines the sequence number when multiple components are defined for an equation. |
CONSTANT_VALUE | DOUBLE | Y | defines the value of a constant defined in the equation. |
CROSS_DRAWN_DT_TM_IND | DOUBLE | N | 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_UID | VARCHAR(100) | N | Unique identifier for EQUATION |
INCLUDED_ASSAY_CD | DOUBLE | N | a unique code value that identifies a specific discrete task assay. |
INCLUDED_ASSAY_UID | VARCHAR(100) | N | Unique identifier for DTA |
LOOK_TIME_DIRECTION_FLAG | DOUBLE | N | FLAG_VALUE:DESCRIPTION:DEFINITION 0.00:TIME WINDOW BACK MINUTES:TIME_WINDOW_BACK_MINUTES 1st and TIME_WINDOW_MINUTES 2nd 1.00:TIME WINDOW MINUTES:TIME_WINDOW_MINUTES 1st and TIME_WINDOW_BACK_MINUTES 2nd |
OCTAL_VALUE | DOUBLE | Y | was to be used for interpretation. (currently not implemented) |
RACE_IND | DOUBLE | N | was to be used for interpretation. (currently not implemented) |
RESULT_REQ_FLAG | DOUBLE | N | FLAG_VALUE:DESCRIPTION:DEFINITION 0.00:Not Required:Result not required and default value may be used. 1.00:Required:Result required for equation to evaluate. |
RESULT_STATUS_CD | DOUBLE | N | Code Set: 1901 a unique code value that identifies the lowest level at which the procedure result status can be to include this component in the equation. |
RESULT_STATUS_CDUID | VARCHAR(100) | N | Unique identifier for Result Status Code Value |
SEX_IND | DOUBLE | N | was to be used for interpretation. (currently not implemented) |
TASK_ASSAY_UID | VARCHAR(100) | N | Universal identifier for the task assay |
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 | Code Set: 54 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. |
UNITS_CDUID | VARCHAR(100) | N | Unique identifier for Units Code Value |
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 - CNT_EQUATION_COMPONENT
Child Column in CNT_EQUATION_COMPONENT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CNT_EQUATION_ID | CNT_EQUATION | CNT_EQUATION_ID |
CNT_GRID
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CNT GRID |
Definition: | INTERSECTION DATA |
Table Type: | REFERENCE |
Column Detail - CNT_GRID
Column Name | Type | Null? | Definition |
---|---|---|---|
CNT_DTA_KEY_ID | DOUBLE | N | Sequence generated ID (Value: 0.0) |
CNT_GRID_ID | DOUBLE | N | Sequence generated ID - PRIMARY KEY |
CNT_INPUT_KEY_ID | DOUBLE | N | FK FROM CNT_INPUT_KEY table |
COL_TASK_ASSAY_UID | VARCHAR(100) | N | Unique identifier for Column DTA |
INPUT_DESCRIPTION | VARCHAR(200) | Y | GRID INPUT DESCRIPTION |
INPUT_REF_SEQ | DOUBLE | Y | Sequence number of input control to control order that it is placed on the section. |
INT_EVENT_CD | DOUBLE | N | Event code |
INT_EVENT_CDUID | VARCHAR(100) | N | UNIQUE VALUE FROM CNT_CODE_VALUE_KEY |
ROW_TASK_ASSAY_UID | VARCHAR(100) | N | Unique identifier for row DTA |
SECTION_UID | VARCHAR(100) | N | Unique identifier for Section - from CNT_INPUT_KEY 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. |
Relationship Detail - CNT_GRID
Child Column in CNT_GRID(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CNT_DTA_KEY_ID | CNT_DTA_KEY2 | CNT_DTA_KEY_ID |
CNT_INPUT_KEY_ID | CNT_INPUT_KEY | CNT_INPUT_KEY_ID |
CNT_INPUT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CNT INPUT |
Definition: | INPUT |
Table Type: | REFERENCE |
Column Detail - CNT_INPUT
Column Name | Type | Null? | Definition |
---|---|---|---|
CNT_INPUT_ID | DOUBLE | N | PRIMARY KEY - Sequence generated ID |
CNT_INPUT_KEY_ID | DOUBLE | N | Sequence generated ID FROM CNT_INPUT_KEY table - (Value: 0.0) |
CNT_SECTION_KEY2_ID | DOUBLE | N | Sequence generated ID from CNT_SECTION_KEY2 table - (Value: 0.0) |
CODE_VALUE_DISP | VARCHAR(40) | Y | Used to look up merge_id not written to a table |
COND_SECT_UID | VARCHAR(100) | N | Unique identifier for Conditional Section DTA |
DCP_INPUT_REF_ID | DOUBLE | N | unique id of input control from table DCP_INPUT_REF |
DTA_ACT_DISP | VARCHAR(40) | Y | Used to look up merge_id not written to a table |
EVENT_CD | DOUBLE | N | Event code for DTAs |
EVENT_CDUID | VARCHAR(100) | N | Unique identifier FK to CNT_CODE_VALUE_KEY |
INPUT_DESCRIPTION | VARCHAR(200) | N | textual description of input control |
INPUT_REF_SEQ | DOUBLE | N | sequence number of input control to control order that it is placed on the section |
INPUT_SEQUENCE | DOUBLE | Y | Sequence of name value pair |
MERGE_ID | DOUBLE | N | The MERGE_ID value from table NAME_VALUE_PREFS. This is a PE-NAME/PE-ID relationship so no specific root entity name or sequence name can be specified. MERGE_NAME specifies the table name. |
MERGE_NAME | VARCHAR(100) | N | name of the table referenced by merge_id |
MERGE_UID | VARCHAR(100) | N | The universal unique identifier for the referenced row. |
NAME_VALUE_PREFS_ID | DOUBLE | N | The primary id of the table this row references |
PVC_NAME | VARCHAR(32) | N | The name portion of the name/value pair that is stored on a row in this table. |
PVC_VALUE | VARCHAR(255) | Y | The value portion of the name/value pair that is stored on a row in this table. |
SECTION_UID | VARCHAR(100) | N | Unique identifier for Section |
TASK_ASSAY_UID | VARCHAR(100) | N | Unique identifier for DTA |
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 - CNT_INPUT
Child Column in CNT_INPUT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CNT_INPUT_KEY_ID | CNT_INPUT_KEY | CNT_INPUT_KEY_ID |
CNT_SECTION_KEY2_ID | CNT_SECTION_KEY2 | CNT_SECTION_KEY2_ID |