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 |