Table Detail Report

ITEM_CLASS_NODE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Item Classification
Definition: Relationship table which ties an item to a particular classification node.
Table Type: REFERENCE





Column Detail - ITEM_CLASS_NODE_R


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.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
CLASS_INSTANCE_CD DOUBLE N The classification instance which the class node is built under.
CLASS_NODE_ID DOUBLE N Foreign key to the class_node table.
ITEM_ID DOUBLE N Foreign key to item_definition 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 - ITEM_CLASS_NODE_R


Child Column in ITEM_CLASS_NODE_R(FK) Parent Table Name Parent Column Name
Parents: CLASS_NODE_ID CLASS_NODE CLASS_NODE_ID
ITEM_ID ITEM_DEFINITION ITEM_ID


ITEM_COMPONENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: ITEM COMPONENT
Definition: Contains a listing of an item's components
Table Type: REFERENCE





Column Detail - ITEM_COMPONENT


Column Name Type Null? Definition
COMPONENT_ID DOUBLE N Actual component item. Foreign key to item_definition table.
CREATE_APPLCTX DOUBLE N Application which created this row
CREATE_DT_TM DATETIME N The date/time this entry was created.
CREATE_ID DOUBLE N ID of user who created this row
CREATE_TASK DOUBLE N Task which created this row
ITEM_ID DOUBLE N Item which is a pack or set. Foreign key to item_definition table.
PACKAGE_TYPE_ID DOUBLE N Package size for this component
QTY DOUBLE N Quantity of component in this pack.
SEQUENCE DOUBLE N Sequence of components used for display purposes
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 - ITEM_COMPONENT


Child Column in ITEM_COMPONENT(FK) Parent Table Name Parent Column Name
Parents: COMPONENT_ID ITEM_DEFINITION ITEM_ID
ITEM_ID ITEM_DEFINITION ITEM_ID
PACKAGE_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID


ITEM_CONTROL_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Item Control Info
Definition: The main control record for an item / location relationship.
Table Type: REFERENCE





Column Detail - ITEM_CONTROL_INFO


Column Name Type Null? Definition
ABC_CLASS_CD DOUBLE N The ABC classification for this item at this location.
CHARGE_TYPE_CD DOUBLE N The charge type for this item.
COST_CENTER_CD DOUBLE N The cost center associated with this item.
COUNTBACK_FLAG DOUBLE N Flag used to determine if this item/location requires a physical count once the item has been removed. 0 - no count is required; 1 - Blind counting; 2 - Confirm count
COUNT_COMMIT_DT_TM DATETIME Y Insert the count committed date and time
COUNT_COMMIT_UPDT_IND DOUBLE N Indicates if this row has had the count_commit_dt_tm value updated to an actual date.
COUNT_CYCLE_CD DOUBLE N The count cycle for this item.
FIRST_DOSE_FLAG DOUBLE Y Default value is 0, value of 1 indicates the item at the location can be evaluated for first dose dispensing.
INSTANCE_IND DOUBLE Y Indicates whether or not this location tracks instances of the item.
ITEM_ID DOUBLE N Foreign key to the item definition table.
LIST_ROLE_ID DOUBLE N Foreign key to sch_list_role table. (used for scheduling)
LOCATION_CD DOUBLE N Location code value
LOT_TRACKING_LEVEL_CD DOUBLE N The level at which lots are tracked at this location.
OMF_SUCCESS_IND DOUBLE N The value of 0 or 1 indicates the success or failure of the respective OMF table update. 1 indicates update to OMF table was successful and 0 indicates failure.
OVERRIDE_CLSFCTN_CD DOUBLE N Provides the ability to override the classification of an item at each specific device.
RETURN_TO_STOCK_FLAG DOUBLE N Allow nursing to return to stock. Values can be 0 -product default 1-can return 2- cannot return
SCAN_ON_DISPENSE_FLAG DOUBLE N Determines if an item requires scanning during a dispense. When the flag is set to 0 it is basically saying look at the location type and product to determine whether or not to scan - and ignore this flag.If the user wants to override the other two preferences at the location type and product level they would set it to 1- Require scan or 2-Do not require scan
SCH_QTY DOUBLE Y The quantity of this item that is available to be scheduled.
SCH_ROLE_CD DOUBLE N Schedule Role CD - Foreign key to the sch_role table.
STOCK_PACKAGE_TYPE_ID DOUBLE N The package type in which this item is stocked.
STOCK_TYPE_IND DOUBLE Y Indicates the stock type for an item.
SUB_ACCOUNT_CD DOUBLE N The sub account defined for the item at this location.
SUPPRESS_SCAN_WORKFLOWS_BITMAP DOUBLE N By using the bits, determines if an item should be scanned in various workflows.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - ITEM_CONTROL_INFO


Child Column in ITEM_CONTROL_INFO(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_DEFINITION ITEM_ID
STOCK_PACKAGE_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID
LIST_ROLE_ID SCH_LIST_ROLE LIST_ROLE_ID


ITEM_DEFINITION



Column Section Relationship Section Top of Page


Table-level Detail

Description: ITEM DEFINITION
Definition: Parent table for all Inventory, Vendor, and Manufacturer items.
Table Type: REFERENCE





Column Detail - ITEM_DEFINITION


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.
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_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
APPROVED_IND DOUBLE Y Indicates that this item has been approved for use.
BASE_ISSUE_FACTOR DOUBLE N The factor in which an item's issue quantity can be broken down in. For example: A tablet is what aspirin is tracked by, but they can dispense it in half tablets. Therefor the base issue factor will be 1/2.
BATCH_QTY DOUBLE Y The quantity that is manufactured / assembled each time.
CHARGEABLE_IND DOUBLE N Indicates whether the item is chargeable or not.
COMPONENT_FILL_RETURN_IND DOUBLE N Indicates whether or not to use component fill/return hierarchy. Used to indicate that the components are decremented from a different location than where the pack was filled/decremented from.
COMPONENT_IND DOUBLE Y Indicates whether or not this item contains components.
COMPONENT_TRANS_IND DOUBLE N Indicates whether or not a component generates an inventory transaction. Indicates that the components are decremented independently from the parent/pack level.
COMPONENT_USAGE_IND DOUBLE Y Defines whether or not usage is captured for each component in a pack/set.
CREATE_APPLCTX DOUBLE N The application context number from the record info block.
CREATE_DT_TM DATETIME N The date and time the row was created.
CREATE_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that created the row in the table.
CREATE_TASK DOUBLE N The registered (assigned) task number for the process that created the row.
IMPLANT_TYPE_CD DOUBLE N If this item is an implant, indicates the type of implant.
ITEM_ID DOUBLE N Primary key.
ITEM_LEVEL_FLAG DOUBLE N This flag indicates the item type, specifically for med def items.
ITEM_TYPE_CD DOUBLE N Codevalue for the type of item (ITEM_MASTER, ITEM_EQP,...).
LATEX_IND DOUBLE Y Indicator which specifies whether the item is latex 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.
LOT_TRACKING_IND DOUBLE N Indicates if the item quantity is tracked at lot level.
MAX_TEMP_AMT DOUBLE N The maximum temperature at which this item should be stored.
MIN_TEMP_AMT DOUBLE N The minimum temperature at which this item should be stored.
MULTI_LOT_TRANSFER_IND DOUBLE N Indicates if the a transfer is for one lot or multiple lots. 0 - single lot, 1 - multiple lots
OMF_SUCCESS_IND DOUBLE N The value of 0 or 1 indicates the success or failure of the respective OMF table update. 1 indicates update to OMF table was successful and 0 indicates failure.
PHA_TYPE_FLAG DOUBLE N This flag indicates the pharmacy item type: inpatient, retail or shared.
PRE_EXP_DATE_PERIOD_NBR DOUBLE N When to alert the user that the product should be used before expiring.
PRE_EXP_DATE_UOM_CD DOUBLE N The unit of measure associated to PRE_EXP_DATE_PERIOD_NBR.
QUICKADD_IND DOUBLE Y Indicates that this item was added through the QuickAdd function.
REUSABLE_IND DOUBLE Y Indicates whether or not this item is reusable.
SHELF_LIFE DOUBLE Y Indicates the shelf life for this item.
SHELF_LIFE_UOM_CD DOUBLE N The units of measure for the shelf life.
SUBSTITUTION_IND DOUBLE Y Indicator which specifies whether the item is under substitution.
SUPPRESS_AUTO_FILL_IND DOUBLE N Indicates whether or not to suppress automated fill on Case Pick list. Used to prevent the components from being filled prematurely.
TEMP_UOM_CD DOUBLE N The unit of measure the temperature columns represent.
UDI_EXP_DATE_IND DOUBLE N Indicates whether the UDI is tracked by expiration date
UDI_LOT_NBR_IND DOUBLE N Indicates whether the UDI is tracked by lot number
UDI_MFR_DATE_IND DOUBLE N Indicates whether the UDI is tracked by manufacturer date
UDI_SERIAL_NBR_IND DOUBLE N Indicates whether the UDI is tracked by serial number
UNIQUE_FIELD VARCHAR(400) Y Unique field which will hold the Item Nbr, Description, and Vendor/Manufacturer concatenated together for merging purposes.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_PRICE_SCHED_PRICE_IND DOUBLE N Denotes whether the price schedule price needs to be update for this item.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - ITEM_DEFINITION


Child Column in ITEM_DEFINITION(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID




Parent Column in ITEM_DEFINITION (PK) Child Table Name Child Column Name
Children: ITEM_ID ACQUIREMENT_INFO ITEM_ID
CE_INVENTORY_RESULT ITEM_ID
FILL_PRINT_ORD_HX ITEM_ID
IMPLANT_HISTORY IMPLANT_ITEM_ID
ITEM_CLASS_NODE_R ITEM_ID
ITEM_COMPONENT COMPONENT_ID
ITEM_COMPONENT ITEM_ID
ITEM_CONTROL_INFO ITEM_ID
ITEM_INSTANCE ITEM_ID
ITEM_ITEM_XREF CHILD_ITEM_ID
ITEM_ITEM_XREF PARENT_ITEM_ID
ITEM_LOCATION_COST ITEM_ID
ITEM_ORG_RELTN ITEM_ID
LOCATOR_ROLLUP ITEM_ID
MEDICATION_DEFINITION INV_MASTER_ID
MEDICATION_DEFINITION PARENT_ITEM_ID
MEDICATION_DEFINITION PRIMARY_MANF_ITEM_ID
MED_DISPENSE ITEM_ID
MED_INGRED_SET CHILD_ITEM_ID
MED_INGRED_SET PARENT_ITEM_ID
MM_APPROVAL_LOG ITEM_ID
MM_AP_LOG_LINE_HMW ITEM_ID
MM_CS_PATIENT_PRICE ITEM_ID
MM_INSTANCE ITEM_ID
MM_ITEM_ORG_COST_HIST ITEM_ID
MM_OMF_ITEM_MASTER ITEM_MASTER_ID
MM_REQ_FILL_ROUTE ITEM_ID
MM_SUPPLY_CABINET ITEM_ID
MM_SUPPLY_CABINET MFR_ITEM_ID
MM_TEMPLATE_ITEM ITEM_ID
MM_XFI_COST ITEM_ID
MM_XFI_INSTANCE ITEM_ID
MM_XFI_ITEM ITEM_MASTER_ID
MM_XFI_ITEM MFR_ITEM_ID
MM_XFI_ITEM VENDOR_ITEM_ID
MM_XFI_ITEMLOC ITEM_ID
MM_XFI_ITEMLOC PRIMARY_VENDOR_ITEM_ID
MM_XFI_LOCATOR ITEM_ID
ORDER_CATALOG_ITEM_R ITEM_ID
ORDER_PRODUCT ITEM_ID
PACKAGE_TYPE ITEM_ID
PHA_PROD_DISP_OBS_ST ITEM_ID
PHYS_COUNT_SHEET_ITEM ITEM_ID
PREF_CARD_PICK_LIST ITEM_ID
PROD_DISPENSE_HX ITEM_ID
PROD_DISPENSE_HX MANF_ITEM_ID
QUANTITY_ON_HAND ITEM_ID
RXS_ACTIVITY_INDEX ITEM_ID
RXS_ALERT INV_ITEM_ID
RXS_EXTENDED_COUNT_PROP ITEM_ID
RXS_FOREIGN_DEVICE_ALERT INV_ITEM_ID
RXS_GROUP_ITEM_RELTN ITEM_ID
RXS_ITEM_COUNTBACK INV_ITEM_ID
RXS_LAST_LOCATOR_ACTIVITY ITEM_ID
RXS_LOCATION_TASK INV_ITEM_ID
RX_ADMIN_PROD_DISPENSE_HX ITEM_ID
RX_PERSON_OWE INV_ITEM_ID
RX_PERSON_OWE ITEM_ID
RX_WS_FAC_ITEM_RELTN ITEM_ID
RX_WS_FAC_RELTN PARENT_ITEM_ID
SCH_PEND_SURG_ITEM ITEM_ID
SCH_RESOURCE ITEM_ID
SN_PICKLIST_ITEM ITEM_ID
SN_PREF_CARD_EXCEPT_ADD ITEM_ID
SN_PREF_CARD_EXCEPT_REMOVE ITEM_ID
SN_PREF_CARD_ITEM ITEM_ID
STANDARDIZED_PHA_DOSE ITEM_ID
STORED_AT ITEM_ID
TEMPLATE_NONFORMULARY SHELL_ITEM_ID


ITEM_INSTANCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Item Instance desc
Definition: Item Instance
Table Type: REFERENCE





Column Detail - ITEM_INSTANCE


Column Name Type Null? Definition
ACQUISITION_COST DOUBLE Y Acquisition Cost
ACQUISITION_TYPE_CD DOUBLE Y Acquisition Type
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_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
COMMISSION_DT_TM DATETIME Y Commissioned Date/Time
CREATE_APPLCTX DOUBLE N Create Application Context
CREATE_DT_TM DATETIME N The date and time the Item Instance was created.
CREATE_ID DOUBLE N ID of user who created this row
CREATE_TASK DOUBLE N Task which created this row
CURRENT_LOCATION_CD DOUBLE Y Current Location
DISPOSAL_DT_TM DATETIME Y Disposal Date/Time
EXPIRE_DT_TM DATETIME Y expire date and time value
INSTANCE_ID DOUBLE N Primary Key
INSTANCE_TYPE_CD DOUBLE N The type of Item Instance (General, Equipment).
ITEM_ID DOUBLE N Foreign Key
LOAN_BORROW_IND DOUBLE Y Loan / Borrow Indicator
MANUFACTURER_CD DOUBLE Y Manufacturer
PERSON_ID DOUBLE Y This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PO_NBR VARCHAR(40) Y Purchase Order Number
PURCHASE_ORDER_ID DOUBLE Y **OBSOLETE ** - Purchase Order primary key
RENTAL_COST DOUBLE Y Rental Cost
RENTAL_USAGE_UOM_CD DOUBLE Y Rental Usage Unit of Measure
RENTED_DT_TM DATETIME Y Rented Date/Time
STATUS_CD DOUBLE Y Status code value
STERILE_IND DOUBLE Y Sterile Indicator
STORAGE_LOCATION_CD DOUBLE Y Storage Location
SVC_GROUP_CD DOUBLE Y Service Group
UNIQUE_FIELD VARCHAR(200) Y Unique field which will hold the Serial Nbr and Mnemonic concatenated together for merging purposes.
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.
VENDOR_CD DOUBLE Y Vendor associated with this account



Relationship Detail - ITEM_INSTANCE


Child Column in ITEM_INSTANCE(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_DEFINITION ITEM_ID