Table Detail Report

ITEM_STERILIZATION_METHOD



Column Section Top of Page


Table-level Detail

Description:
Definition:
Table Type: ACTIVITY





Column Detail - ITEM_STERILIZATION_METHOD


Column Name Type Null? Definition
ITEM_ID DOUBLE N The unique id for the item master.
STERILIZATION_METHOD_CD DOUBLE N


LOCATION_INV_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Location Inventory Information
Definition: Location information specific to a location.
Table Type: REFERENCE





Column Detail - LOCATION_INV_INFO


Column Name Type Null? Definition
ALTERNATE_FILL_LOC_DISP_IND DOUBLE N Indicates if the alternate fill locations should be displayed.
ALTERNATE_VENDOR_DISP_IND DOUBLE N Indicates if the alternate vendor information should be displayed.
AUTO_DISTRIBUTE_IND DOUBLE Y This indicator will be used to determine if the location is defined as auto distribute.
AUTO_SELECT_LOT_IND DOUBLE N Indicates if the user needs to select the lot for transfer manually or if the system will select the lot automatically. 0- manual, 1- auto
BACKORDER_IND DOUBLE Y Backorder_ind = 1 then backorders are supported at the location. Backorder_ind = 0 then the location is defined as fill/kill and quantities that are not filled will be cancelled.
BACKORDER_PRINTER VARCHAR(40) Y This attribute will be used to store the printer the backorder report will be sent too.
CHK_AVAILABLE_IND DOUBLE Y Determines whether or not Pharmnet performs inventory availability checks prior to a dispense.
COST_CENTER_CD DOUBLE N Cost center code value
COST_FLAG DOUBLE N This flag indicates whether the average cost is calculated when the quantity on hand falls below zero.
COST_TYPE_CD DOUBLE N Obsolete
CREATE_PHYS_COUNT_TRANS_IND DOUBLE N This preference indicates whether should be created.
DELIVERY_TICKET_PRINTER VARCHAR(40) Y The printer on which to print the Delivery Ticket report.
FILTER_CC_SA_IND DOUBLE N Indicates if the facility and all of the locations under that facility will filter cost center and sub account based on chart of accounts.
FUNDING_SOURCE_CD DOUBLE N Stores the relationship between the location and the vaccine provider (funding source) for a vaccine stored at the location.
ITEM_FILTER_BY_LOCATION_IND DOUBLE N Indicates if the item should be filtered off, if it is not present in the location.
ITEM_LOCATION_TEMPLATE_TXT LONGTEXT Y Stores the default values of item location properties in JSON format. These values would be defaulted while adding any item to the respective location.
ITEM_ORG_COST_IND DOUBLE N This preference indicates whether the Organization supports Org level unit cost or not.
ITEM_ORG_RELTN_IND DOUBLE N Indicates if this facility's organization allows items to be related to organizations.
LOCATION_CD DOUBLE N Primary Key
LOCK_REQ_UOM_FLAG DOUBLE N Locks the requesting unit of measure control in mmRequisition application.
LOC_DISPLAY_FLAG DOUBLE N This flag determines the prefix to location display. 1 = Company/Location, 2 = Company/Cost Center/Location (this is the default), 3=Cost Center/Location, 4=Location
MOBILE_PICKING_IND DOUBLE Y Indicator used to determine if the location support mobile picking or auto distribute. Mobile picking = 1, auto distribute = 0
NO_AUTO_FILL_FLAG DOUBLE N This flag indicates whether requisitions will not be filled even if there is enough quantity on hand.
OFFSET_ACCOUNT_IND DOUBLE N Retrieve offsetting cost center and subaccount information from the clinical location for clinical adjustment transactions.
ORGANIZATION_ID DOUBLE N The organization associated with this location (used for the company code).
ORG_DISPLAY_IND DOUBLE N Indicates if the organization or building should be displayed in location boxes.
PAR_CALC_PRINTER VARCHAR(40) Y Printer where the PAR calculation report will be printed
PATIENT_NAME_REQUIRED_IND DOUBLE N Indicates whether the patient name is a mandatory field at this location.
PICK_LIST_PRINTER VARCHAR(40) Y The printer on which to print a Distribution Pick-List.
PRINT_PT_BACKORDER_FLAG DOUBLE N This flag indicates whether patient backorder section will be printed.
PRINT_REQ_HDR_COMMENTS_IND DOUBLE Y If true, the distribution report will include all requisition header comments.
PRINT_REQ_LINE_COMMENTS_IND DOUBLE Y f true, the distribution report will include all requisition line comments.
REAL_TIME_REQ_OUTBOUND_IND DOUBLE N Indicates if requisitions are sent outbound in real-time. 0 - not sent in real-time, 1 - requisitions are sent in real-time.
REQ_PICK_LIST_PRINTER VARCHAR(40) Y Printer used to print requisition pick list reports.
SHELF_LABEL_PRINTER VARCHAR(40) Y Printer used to print shelf labels
SHIP_TO_LOCATION_CD DOUBLE N The ship-to location for this location.
SHOW_FILL_LOC_QOH_FLAG DOUBLE N Shows fill location quantity on hand information in mmRequisition application.
STOCK_OUT_PRINTER VARCHAR(40) Y The printer on which to print a Stock-Out report.
SUB_ACCOUNT_CD DOUBLE Y The Sub Account Defined For Locations Inventory Information
SYS_CALC_PAR_DAYS DOUBLE Y Indicates how many days usage to take into account for calculating par levels
SYS_CALC_PAR_FLAG DOUBLE N Indicates whether or not the system is to recalculate par levels.
TRANSFER_EXPIRED_LOT_IND DOUBLE N Indicates if expired lots are to be transferred from one location to another. 0 = not, 1 - yes
TWO_DECIMAL_PRECISION_IND DOUBLE N A user selection field of which Decimal Precision (Either 2 or 4 digits after the decimal) that they want to use at their Organization. This preference would thereafter be referred/consumed in the Procurement workflows of Clinical Inventory Management solution to drive the calculation for several currency field values. By default, 4 Decimal precision preference would be the option selected.
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 - LOCATION_INV_INFO


Child Column in LOCATION_INV_INFO(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


LOCATOR_ROLLUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lists items that exist at locators.
Definition: Locator Rollup
Table Type: REFERENCE





Column Detail - LOCATOR_ROLLUP


Column Name Type Null? Definition
ITEM_ID DOUBLE N Foreign key to item_definition
LOCATION_CD DOUBLE N Location codevalue
LOCATOR_CD DOUBLE N Locator Codevalue
PACKAGE_TYPE_ID DOUBLE N Foreign key to package_type table
RELATIONSHIP_TYPE_CD DOUBLE N Defines the type of item/location relationship
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 - LOCATOR_ROLLUP


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


LOT_NUMBER_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: LOT NUMBER INFO
Definition: Holds an item's lot number(s)
Table Type: REFERENCE





Column Detail - LOT_NUMBER_INFO


Column Name Type Null? Definition
ABS_EXP_DT_TM DATETIME Y Expiration Date as determined at place of origin.
ABS_EXP_TZ DOUBLE Y Time zone associated with the ABS_EXP_DT_TM column.
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.
EXP_DT_TM DATETIME Y The date/time an item will expire.
ITEM_ID DOUBLE N The unique id for the item master.
LOT_NUMBER CHAR(40) Y Character description of the lot number as defined by the manufacturer of the lot.
LOT_NUMBER_ID DOUBLE N Primary key.
LOT_NUMBER_TXT VARCHAR(40) N The lot number converted to all uppercase.
MANF_DT_TM DATETIME Y Date and time an item in the lot was manufactured.
MANUFACTURER_CD DOUBLE N Manufacturer for the item.
MED_PRODUCT_ID DOUBLE N Primary Key from the MED_PRODUCT table. Represents the medication product associated to the lot.
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 - LOT_NUMBER_INFO


Child Column in LOT_NUMBER_INFO(FK) Parent Table Name Parent Column Name
Parents: MED_PRODUCT_ID MED_PRODUCT MED_PRODUCT_ID




Parent Column in LOT_NUMBER_INFO (PK) Child Table Name Child Column Name
Children: LOT_NUMBER_ID ALIQUOTTED_PRIMER_KIT LOT_NUMBER_ID
BLOT_BATCH LOT_NUMBER_ID
HLA_AB_SCREEN_BATCH LOT_NUMBER_ID
HLA_AB_SCREEN_TRAY_MAP LOT_NUMBER_ID
HLA_TYP_TRAY_MAP LOT_NUMBER_ID
HLA_XM_TRAY_MAP LOT_NUMBER_ID
HLA_XM_TRAY_WELL LOT_NUMBER_ID
LOT_NUMBER_LOCATION_INFO LOT_NUMBER_ID
MM_INSTANCE LOT_NUMBER_ID
MM_LOT_RELTN LOT_NUMBER_ID
MM_LOT_RELTN PARENT_LOT_NUMBER_ID
MM_RECEIPT_DOC_LOT LOT_NUMBER_ID
MM_SUPPLY_CABINET LOT_NUMBER_ID
MM_TRANS_IDENTIFIER_RELTN LOT_NUMBER_ID
MM_XFI_ASN_LOT LOT_NUMBER_ID
MM_XFI_QOH LOT_NUMBER_ID
MM_XFI_REQ_FILL_LOT LOT_NUMBER_ID
MOLECULAR_BLOT LOT_NUMBER_ID
SN_PICKLIST_ITEM_DETAIL LOT_NUMBER_ID


LOT_NUMBER_LOCATION_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Location specific lot information
Definition: Location Lot Information
Table Type: REFERENCE





Column Detail - LOT_NUMBER_LOCATION_INFO


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.
LOCATION_CD DOUBLE N Foreign key to location table
LOT_NUMBER_ID DOUBLE N Primary Key
PACKAGE_TYPE_ID DOUBLE N Foreign Key
QTY DOUBLE N The quantity of the lot at this location
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 - LOT_NUMBER_LOCATION_INFO


Child Column in LOT_NUMBER_LOCATION_INFO(FK) Parent Table Name Parent Column Name
Parents: LOT_NUMBER_ID LOT_NUMBER_INFO LOT_NUMBER_ID
PACKAGE_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID