Table Detail Report
CNT_CONDITIONAL_DTA_KEY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CNT_CONDITIONAL_DTA_KEY |
Definition: | Contains details about working view conditional exression DTA, which are used by Bedrock tool. Imported usig content manager tool. |
Table Type: | REFERENCE |
Column Detail - CNT_CONDITIONAL_DTA_KEY
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_NBR | DOUBLE | N | Starting age on a range |
AGE_FROM_UNIT_CD | DOUBLE | N | Unit of measure for age from |
AGE_FROM_UNIT_CD_UID | VARCHAR(100) | Y | UID of Age from CD which is used for versioning |
AGE_TO_NBR | DOUBLE | N | Ending age on a range |
AGE_TO_UNIT_CD | DOUBLE | N | Unit of measure for age to |
AGE_TO_UNIT_CD_UID | VARCHAR(100) | Y | UID of Age to CD which is used for versioning |
CNT_CONDITIONAL_DTA_KEY_ID | DOUBLE | N | PRIMARY KEY |
CNT_CONDITIONAL_DTA_KEY_UID | VARCHAR(100) | Y | Primary way to distinguish |
CONDITIONAL_ASSAY_CD | DOUBLE | N | The DTA that needs to enable/disable |
CONDITIONAL_ASSAY_CD_UID | VARCHAR(100) | Y | UID of DTA |
CONDITIONAL_DTA_ID | DOUBLE | N | Unique value of the DTA |
COND_EXPRESSION_ID | DOUBLE | N | Foreign key on the conditional expression |
DCP_COND_DTA_REF_ID | DOUBLE | N | refers to original CONDITIONAL_DTA table which is used by bedrock tool. |
GENDER_CD | DOUBLE | N | Sex of the patient |
GENDER_CD_UID | VARCHAR(100) | Y | UID of gender code used for versioning |
LOCATION_CD | DOUBLE | N | Location of the patient |
LOCATION_CD_UID | VARCHAR(100) | Y | UID of location code |
POSITION_CD | DOUBLE | N | Position code of the documenting user |
POSITION_CD_UID | VARCHAR(100) | Y | UID of location code |
PREV_CONDITIONAL_DTA_ID | DOUBLE | N | Unique identifier or Original conditional DTA id |
REQUIRED_IND | DOUBLE | N | DTA needs documented |
UNKNOWN_AGE_IND | DOUBLE | N | age unknown if true |
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. |
VERSION_DT_TM | DATETIME | Y | Date and time when this record was updated, used in versioning of the conditional expression in conjunction with UID column |
Relationship Detail - CNT_CONDITIONAL_DTA_KEY
Child Column in CNT_CONDITIONAL_DTA_KEY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DCP_COND_DTA_REF_ID | CONDITIONAL_DTA | CONDITIONAL_DTA_ID |
CNT_COND_EXPRESSION_KEY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CNT Conditional Expression |
Definition: | Contains details about working view conditional expression, which are used by Bedrock tool. Imported using content manager tool. |
Table Type: | REFERENCE |
Column Detail - CNT_COND_EXPRESSION_KEY
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_COND_EXPRESSION_KEY_ID | DOUBLE | N | PRIMARY KEY |
CNT_COND_EXPRESSION_KEY_UID | VARCHAR(100) | Y | UID (uique identification) number which is used in versioning of conditional expression in conjunctionwith version_dt_tm column. |
COND_EXPRESSION_ID | DOUBLE | N | Value of the expression ID which is used to uniquely identify the conditional expression, |
COND_EXPRESSION_NAME | VARCHAR(100) | Y | short description what the expression and conditionality is meant for. |
COND_EXPRESSION_TXT | VARCHAR(512) | Y | String representation of the condition |
COND_POSTFIX_TXT | VARCHAR(512) | Y | postfix notation of the expression, help us to parse and calculate the logic |
DCP_COND_EXPRESSION_REF_ID | DOUBLE | N | refers to original COND_EXPRESSION table which is used by bedrock tool |
MULTIPLE_IND | DOUBLE | N | Indicates multiple DTA can trigger the expression |
PREV_COND_EXPRESSION_ID | DOUBLE | N | unique identifier for condition expression and will not change between versions |
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. |
VERSION_DT_TM | DATETIME | Y | Date and time when this record was updated, used in versioning of the conditional expression in conjunction with UID column |
Relationship Detail - CNT_COND_EXPRESSION_KEY
Child Column in CNT_COND_EXPRESSION_KEY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DCP_COND_EXPRESSION_REF_ID | COND_EXPRESSION | COND_EXPRESSION_ID |
CNT_COND_EXPRSN_COMP_KEY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CNT_COND_EXPRSN_COMP_KEY |
Definition: | Contains details about working view conditional expression components which are used by Bedroc tool. Imported using content manager tool. |
Table Type: | REFERENCE |
Column Detail - CNT_COND_EXPRSN_COMP_KEY
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. |
AR_UID | VARCHAR(100) | N | UID of Alpha response. |
CNT_COND_EXPRSN_COMP_KEY_ID | DOUBLE | N | PRIMARY KEY |
CNT_COND_EXPRSN_COMP_KEY_UID | VARCHAR(100) | Y | UID(Unique Identification) number which is used in versioning of conditional expression component in conjunction with version_dt_tm column. |
COND_COMP_NAME | VARCHAR(30) | Y | Unique description for the component for the expression |
COND_EXPRSN_COMP_ID | DOUBLE | N | Unique value for the expression component |
COND_EXPRSN_ID | DOUBLE | N | references CNT_COND_EXPRESSION_KEY.COND_EXPRESSION_ID |
DCP_COND_EXP_COMP_ID_REF_ID | DOUBLE | N | refers to original COND_EXPRESSION_COMP table which is used by bedrock tool |
OPERATOR_CD | DOUBLE | N | stores comparison operator between the trigger DTA and logical operator |
OPERATOR_CD_UID | VARCHAR(100) | Y | UID of the operator code which is used for versioning |
PREV_COND_EXPRSN_COMP_ID | DOUBLE | N | Unique identifier of the original version. |
REQUIRED_IND | DOUBLE | N | Required indicator for the conditionality |
RESULT_VALUE | DOUBLE | N | result value that evaluates the component |
TRIGGER_ASSAY_CD | DOUBLE | N | The DTA which enable or disable the other DTA's. |
TRIGGER_ASSAY_CD_UID | VARCHAR(100) | Y | UID of the DTA which is used for versioning |
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. |
VERSION_DT_TM | DATETIME | Y | Date and time when this record was updated. Used in versioning of the conditional expression component in conjunction with UID column |
Relationship Detail - CNT_COND_EXPRSN_COMP_KEY
Child Column in CNT_COND_EXPRSN_COMP_KEY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DCP_COND_EXP_COMP_ID_REF_ID | COND_EXPRESSION_COMP | COND_EXPRESSION_COMP_ID |
CNT_DATA_MAP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CNT DATA MAP |
Definition: | DATA MAP |
Table Type: | REFERENCE |
Column Detail - CNT_DATA_MAP
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_DATA_MAP_ID | DOUBLE | N | PRIMARY KEY |
CNT_DTA_KEY_ID | DOUBLE | N | FOREIGN KEY VALUE FROM CNT_DTA_KEY2 |
DATA_MAP_TYPE_FLAG | DOUBLE | N | 0.00 Standard data map 1.00 QC data map |
MAX_DIGITS | DOUBLE | Y | Defines the maximum number of digits allowed in the result. |
MIN_DECIMAL_PLACES | DOUBLE | Y | Defines the minimum number of decimal places required in the result. |
MIN_DIGITS | DOUBLE | Y | Defines the minimum number of digits required in the result. |
RESULT_ENTRY_FORMAT | VARCHAR(40) | Y | (Currently not implemented) |
SERVICE_RESOURCE_CD | DOUBLE | N | A unique code value that identifies the service resource (such as instrument, bench, or sub section) for which the data map is specified. A value of zero indicates that the data map is defined for any service resource associated with the discrete task assay. |
SERVICE_RESOURCE_CDUID | VARCHAR(100) | N | Unique identifier FK to CNT_CODE_VALUE_KEY |
SERVICE_RESOURCE_DISP | VARCHAR(40) | Y | DISPLAY |
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_DATA_MAP
Child Column in CNT_DATA_MAP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CNT_DTA_KEY_ID | CNT_DTA_KEY2 | CNT_DTA_KEY_ID |
CNT_DATA_VERSION
Column Section | Top of Page |
Table-level Detail
Description: | CNT_DATA_VERSION |
Definition: | Table to hold versions for CNT data |
Table Type: | REFERENCE |
Column Detail - CNT_DATA_VERSION
Column Name | Type | Null? | Definition |
---|---|---|---|
CNT_DATA_VERSION_ID | DOUBLE | N | This field is a PK sequence value for the table. |
FILE_NAME | VARCHAR(50) | N | The file name for the data included in the version |
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. |
VERSION_DT_TM | DATETIME | Y | The date of the version for the given data |