Table Detail Report
OUTCOME_ACTIVITY_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Outcome Activity Relation |
Definition: | Used to store the relationship between parent and child outcomes for outcome activity in OUTCOME_ACTIVITY table. |
Table Type: | ACTIVITY |
Column Detail - OUTCOME_ACTIVITY_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
CHILD_OUTCOME_ACTIVITY_ID | DOUBLE | N | Defines that the outcome activity is the child of the parent outcome activity. |
OUTCOME_ACTIVITY_RELTN_ID | DOUBLE | N | PRIMARY KEY |
PARENT_OUTCOME_ACTIVITY_ID | DOUBLE | N | This is the foreign key for this table and also the unique identifier for rows on the OUTCOME_ACTIVITY 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. |
Relationship Detail - OUTCOME_ACTIVITY_RELTN
Child Column in OUTCOME_ACTIVITY_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CHILD_OUTCOME_ACTIVITY_ID | OUTCOME_ACTIVITY | OUTCOME_ACTIVITY_ID |
PARENT_OUTCOME_ACTIVITY_ID | OUTCOME_ACTIVITY | OUTCOME_ACTIVITY_ID |
OUTCOME_CATALOG
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Outcome catalog table |
Definition: | Used to hold outcome definitions |
Table Type: | REFERENCE |
Column Detail - OUTCOME_CATALOG
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_DT_TM | DATETIME | N | Active date and timeColumn |
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_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
CONCEPT_CKI | VARCHAR(255) | Y | Unique CKI identifier |
DESCRIPTION | VARCHAR(100) | N | Description for a particular outcome |
DESCRIPTION_A_NLS | VARCHAR(400) | Y | DESCRIPTION_A_NLS column |
DESCRIPTION_KEY | VARCHAR(100) | N | Formatted outcome descriptionColumn |
DESCRIPTION_NLS | VARCHAR(100) | Y | Formatted outcome descriptionColumn |
EVENT_CD | DOUBLE | N | Event code from v500_event_code which is used to identify relevant results |
EXPECTATION | VARCHAR(200) | N | Expected value for the outcome formatted from the outcome criteria built by the users |
EXPECTATION_A_NLS | VARCHAR(400) | Y | EXPECTATION_A_NLS column |
EXPECTATION_KEY | VARCHAR(200) | N | Formatted expected value for the outcome formatted from the outcome criteria built by the users |
EXPECTATION_NLS | VARCHAR(200) | Y | Formatted expected value for the outcome formatted from the outcome criteria built by the users |
HIDE_EXPECTATION_IND | DOUBLE | N | Used to suppress the display of outcome expectation string in the front end application. |
NOMEN_STRING_FLAG | DOUBLE | N | Identifies which nomenclature table field will be used to display the alpha response. 0 - Short String 1 - Mnemonic 2 - Source String |
OPERAND_MEAN | CHAR(12) | Y | Meaning that defines the operand when multiple alpha responses are used to define an outcome (AND or OR) |
OUTCOME_CATALOG_ID | DOUBLE | N | Unique identifier for a particular outcome |
OUTCOME_CLASS_CD | DOUBLE | N | Outcome class codeColumn |
OUTCOME_TYPE_CD | DOUBLE | N | Outcome type code - outcome type identifier |
REFERENCE_TASK_ID | DOUBLE | N | Unique identifier for a task that is used to chart values for the outcome. FK from ORDER_TASK table. |
REF_TEXT_RELTN_ID | DOUBLE | N | Unique identifier used to link outcome definition to the appropriate version of reference text defined for the outcome. |
RESULT_TYPE_CD | DOUBLE | N | Format type of the result value which is used to evaluate the outcome |
SINGLE_SELECT_IND | DOUBLE | N | Used in conjunction with multi-criteria outcomes to indicate that only a single value can be selected when charting results against this outcome in Document In Plan view. |
TASK_ASSAY_CD | DOUBLE | N | DTA from discrete_task_assay table which is used to identify an event_cd and criteria values for the outcome definition |
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 - OUTCOME_CATALOG
Child Column in OUTCOME_CATALOG(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TASK_ASSAY_CD | DISCRETE_TASK_ASSAY | TASK_ASSAY_CD |
REFERENCE_TASK_ID | ORDER_TASK | REFERENCE_TASK_ID | |
EVENT_CD | V500_EVENT_CODE | EVENT_CD |
Parent Column in OUTCOME_CATALOG (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | OUTCOME_CATALOG_ID | OUTCOME_ACTIVITY | OUTCOME_CATALOG_ID |
OUTCOME_CAT_CRITERIA | OUTCOME_CATALOG_ID | ||
OUTCOME_CAT_LOC_RELTN | OUTCOME_CATALOG_ID |
OUTCOME_CAT_CRITERIA
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Outcome catalog criteria |
Definition: | Used to hold evaluation criteria for outcomes |
Table Type: | REFERENCE |
Column Detail - OUTCOME_CAT_CRITERIA
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_DT_TM | DATETIME | N | Date and time the component was activated |
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_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
NOMENCLATURE_ID | DOUBLE | N | Unique identifier from nomenclature table, which is used for evaluation of alpha response base outcomes |
OPERATOR_CD | DOUBLE | N | Mathematical operator code from code set 17909, which determines the comparison to be performed during outcome evaluation |
OUTCOME_CATALOG_ID | DOUBLE | N | Unique identifier from outcome_catalog table, which is used to store individual outcome definitions |
OUTCOME_CAT_CRITERIA_ID | DOUBLE | N | Unique identifier for an outcome criteria |
RESULT_UNIT_CD | DOUBLE | N | Unit codes to be used in conjunction with result value during outcome evaluation |
RESULT_VALUE | DOUBLE | Y | A value that is compared to an actual result during outcome evaluation. |
SEQUENCE | DOUBLE | Y | Indicates the order of the outcome criteria for display to the user |
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 - OUTCOME_CAT_CRITERIA
Child Column in OUTCOME_CAT_CRITERIA(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID |
OUTCOME_CATALOG_ID | OUTCOME_CATALOG | OUTCOME_CATALOG_ID |
OUTCOME_CAT_LOC_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | OUTCOME CATALOG LOCATION RELATION (FLEX) |
Definition: | The Outcome catalog Flex/RELTN table stores the facility or location information for which the outcome is available. |
Table Type: | REFERENCE |
Column Detail - OUTCOME_CAT_LOC_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
LOCATION_CD | DOUBLE | N | Location code of the entity this flex entry is related to. |
OUTCOME_CATALOG_ID | DOUBLE | N | Unique id of the outcome catalog entry referenced by an entry on this table. |
OUTCOME_CAT_LOC_RELTN_ID | DOUBLE | N | PRIMARY 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 - OUTCOME_CAT_LOC_RELTN
Child Column in OUTCOME_CAT_LOC_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOCATION_CD | LOCATION | LOCATION_CD |
OUTCOME_CATALOG_ID | OUTCOME_CATALOG | OUTCOME_CATALOG_ID |
OUTCOME_CRITERIA
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Outcome criteria table |
Definition: | Used to hold outcome criteria definitions for active outcomes |
Table Type: | ACTIVITY |
Column Detail - OUTCOME_CRITERIA
Column Name | Type | Null? | Definition |
---|---|---|---|
NOMENCLATURE_ID | DOUBLE | N | Unique identifier from nomenclature table, which is used for evaluation of alpha response base outcomes |
OPERATOR_CD | DOUBLE | N | Mathematical operator code from code set 17909, which determines the comparison to be performed during outcome evaluation |
OUTCOME_ACTIVITY_ID | DOUBLE | N | Unique identifier from outcome_activity table, which is used to store active outcome definitions |
OUTCOME_CRITERIA_ID | DOUBLE | N | Unique identifier for an outcome criteria |
RESULT_UNIT_CD | DOUBLE | N | Unit codes to be used in conjunction with result value during outcome evaluation |
RESULT_VALUE | DOUBLE | N | A value that is compared to an actual result during outcome evaluation. |
SEQUENCE | DOUBLE | N | This field is used to order the outcome criteria for display |
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 - OUTCOME_CRITERIA
Child Column in OUTCOME_CRITERIA(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID |
OUTCOME_ACTIVITY_ID | OUTCOME_ACTIVITY | OUTCOME_ACTIVITY_ID |