Table Detail Report
OBJECT_IDENTIFIER_INDEX
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | OBJECT IDENTIFIER INDEX |
Definition: | Denormalized table for Item Help |
Table Type: | REFERENCE |
Column Detail - OBJECT_IDENTIFIER_INDEX
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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. |
APPROVED_IND | DOUBLE | Y | Indicates whether or not the item has been approved for use in the system. |
GENERIC_OBJECT | DOUBLE | Y | Holds either location_cd or class_node_id. |
IDENTIFIER_ID | DOUBLE | N | Foreign key to identifier table. |
IDENTIFIER_TYPE_CD | DOUBLE | N | Identifier type code value. |
ITEM_LEVEL_FLAG | DOUBLE | N | Tells whether and item is med def or not. |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
LONG_PATH_TO_ITEM | VARCHAR(200) | Y | The classification path to the item using the description field. |
OBJECT_ID | DOUBLE | N | The value of the primary key of the table to which the row is related (i.e. item_id, instance_id) |
OBJECT_IDENTIFIER_INDEX_ID | DOUBLE | N | Primary key |
OBJECT_PARENT_NODE_ID | DOUBLE | N | Foreign key to classification table. |
OBJECT_TYPE_CD | DOUBLE | N | The type of object this row refers to (i.e. ITEM_MASTER, MED_DEF, ITEM_INSTANCE, etc.) |
PARENT_ENTITY_ID | DOUBLE | N | The value of the primary key of the table to which the row is related (i.e. item_id, instance_id) |
PARENT_ENTITY_NAME | VARCHAR(32) | Y | The upper case name of the table to which this row is related (i.e. ITEM_DEFINITION, ITEM_INSTANCE) |
PHA_TYPE_FLAG | DOUBLE | N | This flag indicates the pharmacy item type: retail or shared. |
PRICE_REVIEW_IND | DOUBLE | Y | Indicates that this vendor item has one or more prices that are in need of review. |
PRIMARY_IND | DOUBLE | N | Indicates if this identifier is the primary one to display for this type of identifier. |
PRIMARY_NBR_IND | DOUBLE | N | Indicates the primary item number to display (i.e. Stock or System Assigned) |
QUICKADD_IND | DOUBLE | Y | Indicates that the item was added through the QuickAdd application or through an interface. |
RELATIONSHIP_TYPE_CD | DOUBLE | N | Type of item / location relationship. |
REL_PARENT_ENTITY_ID | DOUBLE | N | The upper case name of the table to which this row is related (i.e., LOCATION,CLASS_NODE) |
REL_PARENT_ENTITY_NAME | VARCHAR(32) | Y | The upper case name of the table to which this row is related (i.e. CLASS_NODE, LOCATION) |
SEQUENCE | DOUBLE | Y | The priority of the vendor item. |
SHORT_PATH_TO_ITEM | VARCHAR(200) | Y | The classification path to the item using the short description field. |
SPCL_CHAR_VALUE | VARCHAR(255) | N | Stores the data except * + / and space characters in uppercase mode. |
SPCL_CHAR_VALUE_A_NLS | VARCHAR(1020) | N | Stores the corresponding non-English character set values for the SPCL_CHAR_VALUE column. Used to sort correctly internationally. |
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 | VARCHAR(255) | N | Actual value of identifier. |
VALUE_KEY | VARCHAR(255) | N | Uppercase value. |
VALUE_KEY_A_NLS | VARCHAR(1020) | Y | VALUE_KEY_A_NLS column |
VALUE_KEY_NLS | VARCHAR(512) | Y | Used for queries for locales other than English. |
VENDOR_MANF_CD | DOUBLE | N | Vendor or Manufacturer. |
Relationship Detail - OBJECT_IDENTIFIER_INDEX
Child Column in OBJECT_IDENTIFIER_INDEX(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | OBJECT_PARENT_NODE_ID | CLASS_NODE | CLASS_NODE_ID |
IDENTIFIER_ID | IDENTIFIER | IDENTIFIER_ID | |
LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |
PACKAGE_TYPE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Package Type |
Definition: | Contains package types that an item comes in. |
Table Type: | REFERENCE |
Column Detail - PACKAGE_TYPE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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 | Y | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | Y | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | Y | The person who caused the active_status_cd to be set or change. |
BASE_PACKAGE_TYPE_IND | DOUBLE | Y | Indicates this is the base package for an item. |
DESCRIPTION | VARCHAR(100) | Y | Description of this package type. |
ITEM_ID | DOUBLE | N | Foreign key to item_definition table. |
PACKAGE_TYPE_ID | DOUBLE | N | This is the value of the unique primary identifier of the package type table. It is an internal system assigned number. |
QTY | DOUBLE | Y | The quantity of base package types contained in this package. |
UOM_CD | DOUBLE | N | The Unit of Measure for this package type. |
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 - PACKAGE_TYPE
Child Column in PACKAGE_TYPE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ITEM_ID | ITEM_DEFINITION | ITEM_ID |
Parent Column in PACKAGE_TYPE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PACKAGE_TYPE_ID | ACQUIREMENT_INFO | REORDER_PACKAGE_TYPE_ID |
IDENTIFIER | PACKAGE_TYPE_ID | ||
ITEM_COMPONENT | PACKAGE_TYPE_ID | ||
ITEM_CONTROL_INFO | STOCK_PACKAGE_TYPE_ID | ||
ITEM_PRICE | PACKAGE_TYPE_ID | ||
ITEM_PRICE_HIST | PACKAGE_TYPE_ID | ||
LINE_ITEM_QUANTITY | BASE_PKG_TYPE_ID | ||
LINE_ITEM_QUANTITY | PACKAGE_TYPE_ID | ||
LOCATOR_ROLLUP | PACKAGE_TYPE_ID | ||
LOT_NUMBER_LOCATION_INFO | PACKAGE_TYPE_ID | ||
MED_DISPENSE | PACKAGE_TYPE_ID | ||
MED_INGRED_SET | CHILD_PKG_TYPE_ID | ||
MED_PRODUCT | INNER_PKG_TYPE_ID | ||
MED_PRODUCT | OUTER_PKG_TYPE_ID | ||
MM_APPROVAL_LOG | PACKAGE_TYPE_ID | ||
MM_ITEM_ORG_COST_HIST | PACKAGE_TYPE_ID | ||
MM_LOT_RELTN | PACKAGE_TYPE_ID | ||
MM_OMF_ITEM_MASTER | BASE_PKG_ID | ||
MM_TRANS_LINE | BASE_PKG_TYPE_ID | ||
MM_TRANS_LINE | FROM_PKG_TYPE_ID | ||
MM_TRANS_LINE | TO_PKG_TYPE_ID | ||
MM_XFI_COST | PKG_TYPE_ID | ||
MM_XFI_ITEM | BASE_PKG_TYPE_ID | ||
MM_XFI_ITEM | PKG_TYPE_ID | ||
MM_XFI_ITEMLOC | REORDER_PKG_TYPE_ID | ||
MM_XFI_ITEMLOC | STOCK_PKG_TYPE_ID | ||
MM_XFI_LOCATOR | PKG_TYPE_ID | ||
PHYS_COUNT_SHEET_ITEM | PACKAGE_TYPE_ID | ||
PROD_DISPENSE_HX | PACKAGE_TYPE_ID | ||
QUANTITY_ON_HAND | PACKAGE_TYPE_ID | ||
RXS_ITEM_COUNTBACK | PACKAGE_TYPE_ID | ||
RXS_LOCATION_TASK | PACKAGE_TYPE_ID | ||
RXS_LOC_ENCNTR_INVENTORY | PACKAGE_TYPE_ID | ||
RX_PERSON_OWE | PACKAGE_TYPE_ID | ||
STORED_AT | PACKAGE_TYPE_ID |
PARTS_LIST
Column Section | Top of Page |
Table-level Detail
Description: | |
Definition: | |
Table Type: | ACTIVITY |
Column Detail - PARTS_LIST
Column Name | Type | Null? | Definition |
---|---|---|---|
COMMENTS | DOUBLE | Y | |
COMPONENT_ITEM_ID | DOUBLE | N | |
ITEM_ID | DOUBLE | N | |
QTY | DOUBLE | Y | |
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. |
PRSNL_CLASS_NODE_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Personal Class Node Reference |
Definition: | Table used to create relationships between personal and electronic item catalog(s). |
Table Type: | REFERENCE |
Column Detail - PRSNL_CLASS_NODE_R
Column Name | Type | Null? | Definition |
---|---|---|---|
CLASS_NODE_ID | DOUBLE | N | Key to the CLASS_NODE table indicating the item catalog |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
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 - PRSNL_CLASS_NODE_R
Child Column in PRSNL_CLASS_NODE_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CLASS_NODE_ID | CLASS_NODE | CLASS_NODE_ID |
PERSON_ID | PRSNL | PERSON_ID |
PRSNL_LOCATION_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Personnel Location Relationship |
Definition: | Ties a person to a specific location view. |
Table Type: | REFERENCE |
Column Detail - PRSNL_LOCATION_R
Column Name | Type | Null? | Definition |
---|---|---|---|
LOCATION_CD | DOUBLE | N | The location which the person has been related to. |
LOCATION_TYPE_CD | DOUBLE | N | The type of location. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
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 - PRSNL_LOCATION_R
Child Column in PRSNL_LOCATION_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOCATION_CD | LOCATION | LOCATION_CD |
PERSON_ID | PRSNL | PERSON_ID |