Table Detail Report
ORG_BARCODE_FORMAT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | This table identifies a barcode format to be used to interpret a barcode. |
Definition: | Organization Barcode Format. |
Table Type: | REFERENCE |
Column Detail - ORG_BARCODE_FORMAT
Column Name | Type | Null? | Definition |
---|---|---|---|
ALIAS_TYPE_CD | DOUBLE | N | Identifies the type of alias contained by the barcode. If the barcode is not an alias type the value will be 0. there are multiple codesets used to identify the various aliases used within HNAM. |
BARCODE_TYPE_CD | DOUBLE | N | The type of barcode being identified.Column |
CHECK_DIGIT_IND | DOUBLE | N | Indicates the presence of a check digit within the barcode label.Column |
ORGANIZATION_ID | DOUBLE | N | Identifier of organization of the barcode format.Column |
ORG_BARCODE_FORMAT_ID | DOUBLE | N | Unique primary key |
PARENT_ENTITY_ID | DOUBLE | N | Identifier of referenced itemColumn |
PARENT_ENTITY_NAME | VARCHAR(32) | N | Name of parent entityColumn |
PREFIX | VARCHAR(255) | N | Prefix that is included in barcode label to identify format.Column |
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. |
Z_DATA | VARCHAR(255) | N | Z segment included in barcode to help identify format.Column |
Relationship Detail - ORG_BARCODE_FORMAT
Child Column in ORG_BARCODE_FORMAT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID |
ORG_BARCODE_ORG
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Identifies which barcode labels from other organizations an organization may rea |
Definition: | Identifies which barcode labels from other organizations an organization may read. |
Table Type: | REFERENCE |
Column Detail - ORG_BARCODE_ORG
Column Name | Type | Null? | Definition |
---|---|---|---|
BARCODE_TYPE_CD | DOUBLE | N | The type of barcode being identified.Column |
LABEL_ORGANIZATION_ID | DOUBLE | N | Identifier of organization printing the barcode labelColumn |
ORG_BARCODE_SEQ_ID | DOUBLE | N | Primary Key for org_barcode_format that defines a CareNetColumn |
SCAN_ORGANIZATION_ID | DOUBLE | N | The identifier of the scanning organization.Column |
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 - ORG_BARCODE_ORG
Child Column in ORG_BARCODE_ORG(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LABEL_ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID |
SCAN_ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID |
OUTCOME_ACTION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Outcome action |
Definition: | Used to store an audit trail for outcome definition changes. A partial snapshot of OUTCOME_ACTIVITY data used to track changes. |
Table Type: | ACTIVITY |
Column Detail - OUTCOME_ACTION
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_DT_TM | DATETIME | Y | Date and Time the action occurred |
ACTION_SEQ | DOUBLE | N | Action Sequence. Used with OUTCOME_ACTIVITY column to define uniqueness for the row. |
ACTION_TZ | DOUBLE | Y | Time Zone associated with the corresponding date column |
END_DT_TM | DATETIME | Y | Used to define a date range for results that are queried when evaluating the outcome |
END_ESTIMATED_IND | DOUBLE | N | To indicate whether the outcome end date time is estimated or precise. |
END_TZ | DOUBLE | Y | Time zone associated with the corresponding dt_tm column. |
OUTCOME_ACTIVITY_ID | DOUBLE | N | Unique identifier from outcome_activity table, which is used to store active outcome definitions |
OUTCOME_STATUS_CD | DOUBLE | N | Outcome status identifier |
OUTCOME_STATUS_DT_TM | DATETIME | N | Date & time value indicating when an outcome reached its current status |
OUTCOME_STATUS_TZ | DOUBLE | Y | Time zone associated with the corresponding dt_tm column. |
START_DT_TM | DATETIME | Y | Used to define a date range for results that are queried when evaluating the outcome |
START_ESTIMATED_IND | DOUBLE | N | To indicate whether the outcome start is estimated or precise. |
START_TZ | DOUBLE | Y | Time zone associated with the corresponding dt_tm column. |
TARGET_TYPE_CD | DOUBLE | N | Target type codeColumn |
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_ACTION
Child Column in OUTCOME_ACTION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | OUTCOME_ACTIVITY_ID | OUTCOME_ACTIVITY | OUTCOME_ACTIVITY_ID |
OUTCOME_ACTIVITY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Outcome activity table |
Definition: | Used to hold definition for outcomes as they are ordered |
Table Type: | ACTIVITY |
Column Detail - OUTCOME_ACTIVITY
Column Name | Type | Null? | Definition |
---|---|---|---|
COMMENT_ID | DOUBLE | N | Outcome comment id. This is foreign key to LONG_TEXT table. |
DESCRIPTION | VARCHAR(100) | N | Description for a particular outcome |
ENCNTR_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
END_DT_TM | DATETIME | Y | Used to define a date range for results that are queried when evaluating the outcome |
END_ESTIMATED_IND | DOUBLE | N | To indicate whether the outcome end date time is estimated or precise. |
END_TZ | DOUBLE | Y | Time zone associated with the corresponding dt_tm column. |
EVENT_CD | DOUBLE | N | Event code from v500_event_code which is used to identify relevant results |
EXPAND_QTY | DOUBLE | Y | Range value to be used to set the limit of evaluating the outcomes past their target |
EXPAND_UNIT_CD | DOUBLE | N | Unit code to be used together with the range value to set the limit of evaluating the outcomes past their target |
EXPECTATION | VARCHAR(200) | N | Expected value for the outcome formatted from the outcome criteria built by the users |
GROUP_COLLABORATION_IND | DOUBLE | N | Indicates if the outcome is a team outcome or individual outcome. |
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_ACTIVITY_ID | DOUBLE | N | Unique identifier for a particular outcome instance |
OUTCOME_CATALOG_ID | DOUBLE | N | Unique identifier for a particular outcome from OUTCOME_CATALOG table |
OUTCOME_CLASS_CD | DOUBLE | N | Outcome class codeColumn |
OUTCOME_STATUS_CD | DOUBLE | N | Outcome status identifier |
OUTCOME_STATUS_DT_TM | DATETIME | N | Date & time value indicating when an outcome reached its current status |
OUTCOME_STATUS_TZ | DOUBLE | Y | Time zone associated with the corresponding dt_tm column. |
OUTCOME_TYPE_CD | DOUBLE | N | Outcome Type Code - Outcome type identifier |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
PRIORITY_NBR | DOUBLE | N | Defines the priority of the outcome activity. 0 if no priority is assigned. |
REFERENCE_TASK_ID | DOUBLE | N | Unique identifier for a task that is used to chart values for the outcome. |
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. |
SOURCE_FLAG | DOUBLE | N | Where the outcome was written from; 0: PowerPlans, 1: BodySystems MPage, 2: Goals MPage Component |
START_DT_TM | DATETIME | Y | Used to define a date range for results that are queried when evaluating the outcome |
START_ESTIMATED_IND | DOUBLE | N | To indicate whether the outcome start is estimated or precise. |
START_TZ | DOUBLE | Y | Time zone associated with the corresponding dt_tm column. |
TARGET_DURATION_QTY | DOUBLE | Y | Target duration quantity as defined by plan reference catalog |
TARGET_DURATION_UNIT_CD | DOUBLE | N | Target duration unit code as defined by plan reference catalog |
TARGET_TYPE_CD | DOUBLE | N | Target type codeColumn |
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_ACTIVITY
Child Column in OUTCOME_ACTIVITY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TASK_ASSAY_CD | DISCRETE_TASK_ASSAY | TASK_ASSAY_CD |
ENCNTR_ID | ENCOUNTER | ENCNTR_ID | |
COMMENT_ID | LONG_TEXT | LONG_TEXT_ID | |
REFERENCE_TASK_ID | ORDER_TASK | REFERENCE_TASK_ID | |
OUTCOME_CATALOG_ID | OUTCOME_CATALOG | OUTCOME_CATALOG_ID | |
PERSON_ID | PERSON | PERSON_ID | |
EVENT_CD | V500_EVENT_CODE | EVENT_CD |
Parent Column in OUTCOME_ACTIVITY (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | OUTCOME_ACTIVITY_ID | OUTCOME_ACTION | OUTCOME_ACTIVITY_ID |
OUTCOME_ACTIVITY_DETAIL | OUTCOME_ACTIVITY_ID | ||
OUTCOME_ACTIVITY_RELTN | CHILD_OUTCOME_ACTIVITY_ID | ||
OUTCOME_ACTIVITY_RELTN | PARENT_OUTCOME_ACTIVITY_ID | ||
OUTCOME_CRITERIA | OUTCOME_ACTIVITY_ID |
OUTCOME_ACTIVITY_DETAIL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Outcome Activity Detail |
Definition: | Used to store the detials of outcomes |
Table Type: | ACTIVITY |
Column Detail - OUTCOME_ACTIVITY_DETAIL
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. |
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. |
OUTCOME_ACTIVITY_DETAIL_ID | DOUBLE | N | PRIMARY KEY |
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. |
OUTCOME_DETAIL_DISPLAY | VARCHAR(255) | Y | the display value of the outcome detail |
OUTCOME_DETAIL_DT_TM | DATETIME | Y | outcome detail field date time value |
OUTCOME_DETAIL_TYPE_CD | DOUBLE | N | Indicates the type code of detail. For example outcome_sub_type,outcome_category_cd, outcome_frequency |
OUTCOME_DETAIL_VALUE | DOUBLE | Y | Value of the outcome detail if a numeric or coded value. |
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_DETAIL
Child Column in OUTCOME_ACTIVITY_DETAIL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | OUTCOME_ACTIVITY_ID | OUTCOME_ACTIVITY | OUTCOME_ACTIVITY_ID |