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