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