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