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 |
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 |