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