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