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. |