Table Detail Report

CONDITIONAL_DTA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Conditional DTA
Definition: The DTA that needs enabled or disable
Table Type: REFERENCE





Column Detail - CONDITIONAL_DTA


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_TO_NBR DOUBLE N Ending age on a range
AGE_TO_UNIT_CD DOUBLE N Unit of measure for age to
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.
CONDITIONAL_ASSAY_CD DOUBLE N The dta that needs to enable/diabled
CONDITIONAL_DTA_ID DOUBLE N Primary key
COND_EXPRESSION_ID DOUBLE N Foreign key on conditional expression
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.
GENDER_CD DOUBLE N Sex of the patient
LOCATION_CD DOUBLE N Location of the patient
POSITION_CD DOUBLE N Position_cd of documented user
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 UNKNOWN AGE INDICATOR. Age of the patient is unknown.
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 - CONDITIONAL_DTA


Child Column in CONDITIONAL_DTA(FK) Parent Table Name Parent Column Name
Parents: PREV_CONDITIONAL_DTA_ID CONDITIONAL_DTA CONDITIONAL_DTA_ID
COND_EXPRESSION_ID COND_EXPRESSION COND_EXPRESSION_ID
CONDITIONAL_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD




Parent Column in CONDITIONAL_DTA (PK) Child Table Name Child Column Name
Children: CONDITIONAL_DTA_ID CNT_CONDITIONAL_DTA_KEY DCP_COND_DTA_REF_ID
CONDITIONAL_DTA PREV_CONDITIONAL_DTA_ID


COND_EXPRESSION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores conditional expression
Definition: Stores conditional expression that will enable or disable controls
Table Type: REFERENCE





Column Detail - COND_EXPRESSION


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.
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.
COND_EXPRESSION_ID DOUBLE N Primary way to distinguish
COND_EXPRESSION_NAME VARCHAR(100) N Short description what the expression and conditionality is meant for.
COND_EXPRESSION_TXT VARCHAR(512) N String representation of the condition.
COND_POSTFIX_TXT VARCHAR(512) N Postfix notation of the expression, helps us to parse and calculate the logic
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.
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.



Relationship Detail - COND_EXPRESSION


Child Column in COND_EXPRESSION(FK) Parent Table Name Parent Column Name
Parents: PREV_COND_EXPRESSION_ID COND_EXPRESSION COND_EXPRESSION_ID




Parent Column in COND_EXPRESSION (PK) Child Table Name Child Column Name
Children: COND_EXPRESSION_ID CNT_COND_EXPRESSION_KEY DCP_COND_EXPRESSION_REF_ID
CONDITIONAL_DTA COND_EXPRESSION_ID
COND_EXPRESSION PREV_COND_EXPRESSION_ID
COND_EXPRESSION_COMP COND_EXPRESSION_ID


COND_EXPRESSION_COMP



Column Section Relationship Section Top of Page


Table-level Detail

Description: COND_EXPRESSION_COMP
Definition: The tables stores the Trigger DTA and conditions to evaluate the condition for them.
Table Type: REFERENCE





Column Detail - COND_EXPRESSION_COMP


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.
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.
COND_COMP_NAME VARCHAR(30) N Unique description for the component for the expression
COND_EXPRESSION_COMP_ID DOUBLE N Primary identifier for the table
COND_EXPRESSION_ID DOUBLE N Foreign key from the cond_expression table
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.
OPERATOR_CD DOUBLE N Stores comparison operator between the triggerDTA and logical operator.
PARENT_ENTITY_ID DOUBLE N Foreign key to a table identified by PARENT_ENTITY_NAME
PARENT_ENTITY_NAME VARCHAR(60) N Parent table of nomenclature and codeset.
PREV_COND_EXPRESSION_COMP_ID DOUBLE N Unique identifier of the original version.
REQUIRED_IND DOUBLE N Required Ind for the conditionality
RESULT_VALUE DOUBLE N Result value that evaluates the component
TRIGGER_ASSAY_CD DOUBLE N The dta which enable or disable other dta's.
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 - COND_EXPRESSION_COMP


Child Column in COND_EXPRESSION_COMP(FK) Parent Table Name Parent Column Name
Parents: COND_EXPRESSION_ID COND_EXPRESSION COND_EXPRESSION_ID
PREV_COND_EXPRESSION_COMP_ID COND_EXPRESSION_COMP COND_EXPRESSION_COMP_ID
TRIGGER_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD




Parent Column in COND_EXPRESSION_COMP (PK) Child Table Name Child Column Name
Children: COND_EXPRESSION_COMP_ID CNT_COND_EXPRSN_COMP_KEY DCP_COND_EXP_COMP_ID_REF_ID
COND_EXPRESSION_COMP PREV_COND_EXPRESSION_COMP_ID


COND_REQUIRED_PROPS



Column Section Relationship Section Top of Page


Table-level Detail

Description: CONDITIONAL REQUIRED PROPERTIES
Definition: Conditional property identifier
Table Type: REFERENCE





Column Detail - COND_REQUIRED_PROPS


Column Name Type Null? Definition
COND_PROPERTY_ID DOUBLE N The target property_id that makes the property_id column required
PROPERTY_ID DOUBLE N property identifierColumn
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.
VALUE_IND DOUBLE N VALUE_INDICATOR



Relationship Detail - COND_REQUIRED_PROPS


Child Column in COND_REQUIRED_PROPS(FK) Parent Table Name Parent Column Name
Parents: COND_PROPERTY_ID CONTENT_PROPERTY PROPERTY_ID
PROPERTY_ID CONTENT_PROPERTY PROPERTY_ID


CONTENT_DOMAIN_INFO



Column Section Top of Page


Table-level Detail

Description: CONTENT DOMAIN INFO
Definition: Stores content domain information for the Content Manager solution.
Table Type: REFERENCE





Column Detail - CONTENT_DOMAIN_INFO


Column Name Type Null? Definition
CONTENT_DOMAIN_INFO_ID DOUBLE N PRIMARY KEY
FIELD_NAME VARCHAR(100) N Name of the Content DOMAIN attribute being stored in the FIELD_VALUE column.
FIELD_VALUE DOUBLE Y Numeric value for the attribute named in the FIELD_NAME column.
FIELD_VALUE_STR VARCHAR(100) Y String value for the attribute named in the FIELD_NAME column.
PROPERTY_ID DOUBLE N Unique generated number that identifies a single row on the CONTENT_PROPERTY 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.