Table Detail Report

CNT_RELATED_ASSAY



Column Section Top of Page


Table-level Detail

Description: CNT RELATED ASSAYS
Definition: Content only - holds procedure related information for task assay - acts as intermediate table to Millennium tables
Table Type: REFERENCE





Column Detail - CNT_RELATED_ASSAY


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.
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.
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.
CNT_RELATED_ASSAY_ID DOUBLE N PRIMARY KEY
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.
RELATED_PROC_TYPE_CDUID VARCHAR(100) Y unique identifier. FK to cnt_code_value_key
RELATED_TYPE_CD DOUBLE N a unique code value that identifies the specific type of relationship between discrete task assays.
TASK_ASSAY_UID VARCHAR(100) Y a unique code value uid that identifies a specific discrete task assay.
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.


CNT_RRF



Column Section Relationship Section Top of Page


Table-level Detail

Description: CNT RRF
Definition: RRF
Table Type: REFERENCE





Column Detail - CNT_RRF


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.
CNT_RRF_ID DOUBLE N Sequence generated ID
CNT_RRF_KEY_ID DOUBLE N Sequence generated ID (Value: 0.0)
CODE_SET DOUBLE N defines the code set used to validate reference ranges for assays with the result type of "online code set".
CRITICAL_HIGH DOUBLE Y Defines the critical high reference range.
CRITICAL_IND DOUBLE N indicates whether critical result reference ranges are defined.
CRITICAL_LOW DOUBLE Y Defines the critical low reference range.
DEFAULT_RESULT DOUBLE Y defines the default result value associated with specified reference range.
DEF_RESULT_IND DOUBLE N indicates whether the default result value has been defined for the reference range.
DELTA_CHECK_TYPE_CD DOUBLE N Code Set: 236
DELTA_CHECK_TYPE_CDUID VARCHAR(100) N Unique identifier FK to CNT_CODE_VALUE_KEY
DELTA_CHK_FLAG DOUBLE N 0.00 No delta checking 1.00 Perform standard delta checking 2.00 Perform advanced delta checking
DELTA_MINUTES DOUBLE Y defines the specific number of minutes used to calculate the delta checking algorithm.
DELTA_VALUE DOUBLE Y defines the value used to perform delta checking.
DILUTE_IND DOUBLE N indicates whether a dilution will be required for results that exceed the limits of the linear high range column.
ENCNTR_TYPE_CD DOUBLE N A unique code value display that identifies the encounter type
ENCNTR_TYPE_CDUID VARCHAR(100) N Unique identifier FK to CNT_CODE_VALUE_KEY
FEASIBLE_HIGH DOUBLE Y Defines the feasible high value for the defined reference range. Typically, this is the limit above which no result is possible.
FEASIBLE_IND DOUBLE N indicates whether feasible limits exist for the reference range
FEASIBLE_LOW DOUBLE Y Defines the feasible low value for the reference range. Typically, this is the limit below which no result is possible.
GESTATIONAL_IND DOUBLE N Indicates whether the reference range defined is for the gestational age.
LINEAR_HIGH DOUBLE Y Defines the linear high limit for the reference range. Result values above this limit are considered out of the linear high limits of the service resource specified.
LINEAR_IND DOUBLE N indicates whether linear limits exist for the reference range.
LINEAR_LOW DOUBLE Y Defines the linear low limit for the reference range. Result values below this limit are considered out of the linear low limits of the service resource specified.
MINS_BACK DOUBLE Y Used to calculate the minutes back from the previous result to default the value for the current result for CareNet applications.
NORMAL_HIGH DOUBLE Y Defines the normal high reference range value for a specific discrete task assay.
NORMAL_IND DOUBLE N indicates whether normal ranges are built for the reference range specified.
NORMAL_LOW DOUBLE Y Defines the normal low reference range value for a specific discrete task assay.
REVIEW_HIGH DOUBLE Y defines the review high reference range limit for a discrete task assay.
REVIEW_IND DOUBLE N indicates whether review range values are defined for the reference range.
REVIEW_LOW DOUBLE Y defines the value for the review low reference range.
RRF_UID VARCHAR(100) N Unique identifier for Reference Range Factor.
SENSITIVE_HIGH DOUBLE Y Defines the value for the sensitive high reference range.
SENSITIVE_IND DOUBLE N indicates whether sensitive range values are defined for the reference range.
SENSITIVE_LOW DOUBLE Y Defines the sensitive low value for the reference range.
UNITS_CD DOUBLE N A unique code value display that identifies the specific units of measure to be appended to results for the defined reference range
UNITS_CDUID VARCHAR(100) N Unique identifier FK to CNT_CODE_VALUE_KEY
UNITS_CKI VARCHAR(50) N UNITS CKI
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_RRF


Child Column in CNT_RRF(FK) Parent Table Name Parent Column Name
Parents: CNT_RRF_KEY_ID CNT_RRF_KEY CNT_RRF_KEY_ID




Parent Column in CNT_RRF (PK) Child Table Name Child Column Name
Children: CNT_RRF_ID CNT_DTA_RRF_R CNT_RRF_ID


CNT_RRF_AR_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: CNT RRF AR R
Definition: RRF AR RELTN
Table Type: REFERENCE





Column Detail - CNT_RRF_AR_R


Column Name Type Null? Definition
ALPHA_RESPONSES_CATEGORY_ID DOUBLE N foreign key to the category for this alpha_responses row. - ALPHA_RESPONSES_CATEGORY
AR_SEQUENCE DOUBLE N The sequence in which alpha responses are stored and displayed.
AR_UID VARCHAR(100) N Unique identifier for Alpha Response
CNT_ALPHA_RESPONSE_KEY_ID DOUBLE N Sequence generated ID (Value: 0.0)
CNT_RRF_AR_R_ID DOUBLE N PRIMARY KEY
CNT_RRF_KEY_ID DOUBLE N Sequence generated ID (Value: 0.0)
DEFAULT_IND DOUBLE N Used to indicate which alpha response should be used as the default in result entry applications.
DESCRIPTION VARCHAR(100) N Used to store the long description of the response.
MULTI_ALPHA_SORT_ORDER DOUBLE N Defines the sort order of alpha responses that are used to result a task or assay with multiple valid alpha results.
REFERENCE_IND DOUBLE N Indicates if the alpha response selected will be printed on hard-copy charts as the typical "reference" value.
RESULT_PROCESS_CD DOUBLE N Used to store processing codes that would flag alpha responses as normal, abnormal, critical, and so on.
RESULT_PROCESS_CDUID VARCHAR(100) N Unique identifier FK to CNT_CODE_VALUE_KEY
RESULT_VALUE DOUBLE Y The value associated with the alpha response for a specific assay that would be used for appending additional information to the result.
RRF_UID VARCHAR(100) N Unique identifier for Reference Range Factor
TRUTH_STATE_CD DOUBLE N this states whether to make the condition true or false based on the nomenclature concept.
TRUTH_STATE_CDUID VARCHAR(100) Y unique identifier fk to cnt_code_value_key
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.
USE_UNITS_IND DOUBLE N Used to indicate whether or not units of measure will be appended to the alpha response.



Relationship Detail - CNT_RRF_AR_R


Child Column in CNT_RRF_AR_R(FK) Parent Table Name Parent Column Name
Parents: CNT_ALPHA_RESPONSE_KEY_ID CNT_ALPHA_RESPONSE_KEY CNT_ALPHA_RESPONSE_KEY_ID
CNT_RRF_KEY_ID CNT_RRF_KEY CNT_RRF_KEY_ID


CNT_RRF_KEY



Column Section Relationship Section Top of Page


Table-level Detail

Description: CNT RRF KEY
Definition: RRF KEY
Table Type: REFERENCE





Column Detail - CNT_RRF_KEY


Column Name Type Null? Definition
AGE_FROM_MINUTES DOUBLE Y Defines the beginning age in minutes for a defined reference range.
AGE_FROM_UNITS_CD DOUBLE N A unique code value display that identifies the specific age units (such as days, months, years, and so on) for the beginning age reference range. Code Set 340
AGE_FROM_UNITS_CDUID VARCHAR(100) N Unique identifier FK to CNT_CODE_VALUE_KEY
AGE_TO_MINUTES DOUBLE Y Defines the ending age in minutes for a defined reference range.
AGE_TO_UNITS_CD DOUBLE N A unique code value display that identifies the specific age units (such as days, months, years, and so on) for the ending age reference range.
AGE_TO_UNITS_CDUID VARCHAR(100) N Unique identifier FK to CNT_CODE_VALUE_KEY
CNT_RRF_KEY_ID DOUBLE N Sequence generated ID
DCP_REF_RANGE_FACTOR_ID DOUBLE N a unique, internal, system-assigned number that identifies a specific reference range factor row.
ORGANISM_CD DOUBLE N Code set: 1021
ORGANISM_CDUID VARCHAR(100) N Unique identifier FK to CNT_CODE_VALUE_KEY
PATIENT_CONDITION_CD DOUBLE N Code set: 235
PATIENT_CONDITION_CDUID VARCHAR(100) N Unique identifier FK to CNT_CODE_VALUE_KEY
PRECEDENCE_SEQUENCE DOUBLE N used to determine which reference range row to use when all matching criteria are the same.
RRF_INTERNAL_UID VARCHAR(100) N Unique identifier for domain generated Reference Range factor
RRF_UID VARCHAR(100) N Unique identifier for Reference Range Factor
SERVICE_RESOURCE_CD DOUBLE N A unique code value display that identifies the service resource (such as instrument, bench, or sub section) that will affect the reference range defined.
SERVICE_RESOURCE_CDUID VARCHAR(100) N Unique identifier FK to CNT_CODE_VALUE_KEY
SEX_CD DOUBLE N A unique code value display that identifies the sex adjustment for the reference range.
SEX_CDUID VARCHAR(100) N Unique identifier FK to CNT_CODE_VALUE_KEY
SPECIES_CD DOUBLE N A unique code value display that identifies the species for the defined reference range.
SPECIES_CDUID VARCHAR(100) N Unique identifier FK to CNT_CODE_VALUE_KEY
SPECIMEN_TYPE_CD DOUBLE N A unique code value display that identifies the specimen type for the defined reference range.
SPECIMEN_TYPE_CDUID VARCHAR(100) N Unique identifier FK to CNT_CODE_VALUE_KEY
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_RRF_KEY




Parent Column in CNT_RRF_KEY (PK) Child Table Name Child Column Name
Children: CNT_RRF_KEY_ID CNT_RRF CNT_RRF_KEY_ID
CNT_RRF_AR_R CNT_RRF_KEY_ID


CNT_SECTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: CNT SECTION
Definition: SECTION
Table Type: REFERENCE





Column Detail - CNT_SECTION


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.
CNT_SECTION_ID DOUBLE N Sequence generated ID (Value: 0.0) PRIMARY KEY
CNT_SECTION_KEY2_ID DOUBLE N Sequence generated ID - FROM CNT_SECTION_KEY2
SECTION_CKI VARCHAR(50) Y A unique external identifier for CKI
SECTION_FLAG DOUBLE N Used for determine which sections are conditional on the import not written directly to a table
SECTION_HEIGHT DOUBLE Y Height of section.
SECTION_UID VARCHAR(100) N Unique identifier for Section
SECTION_WIDTH DOUBLE Y Width of section.
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_SECTION


Child Column in CNT_SECTION(FK) Parent Table Name Parent Column Name
Parents: CNT_SECTION_KEY2_ID CNT_SECTION_KEY2 CNT_SECTION_KEY2_ID