ACQUIREMENT_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: ACQUIREMENT INFO
Definition: Item / Location relationship that defines how you acquire an item.
Table Type: REFERENCE





Column Detail - ACQUIREMENT_INFO


Column Name Type Null? Definition
AVERAGE_LEAD_TIME DOUBLE Y The average time it takes a vendor to deliver goods.
AVERAGE_LEAD_TIME_UOM_CD DOUBLE N Average Lead Time Unit of Measure
CONSIGNMENT_IND DOUBLE Y Consignment indicator
ECONOMIC_ORDER_QTY DOUBLE Y The quantity that is economically feasible to reorder from the vendor.
FILL_LOCATION_CD DOUBLE N The location that the item is replenished from.
ITEM_ID DOUBLE N Primary Key
LOCATION_CD DOUBLE N Primary Key
PRIMARY_VENDOR_CD DOUBLE N The vendor that this item is usually ordered from.
PRIMARY_VENDOR_ITEM_ID DOUBLE N The primary vendor's item that is reordered.
PRODUCT_ORIGIN_CD DOUBLE N x
REORDER_PACKAGE_TYPE_ID DOUBLE N The package type that is usually reordered from the vendor.
SYSCALC_EOQ_IND DOUBLE Y x
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_SITE_ID DOUBLE N Foreign key to the vendor site



Relationship Detail - ACQUIREMENT_INFO


Child Column in ACQUIREMENT_INFO(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_DEFINITION ITEM_ID
REORDER_PACKAGE_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID
PRIMARY_VENDOR_ITEM_ID VENDOR_ITEM ITEM_ID
VENDOR_SITE_ID VENDOR_SITE VENDOR_SITE_ID


CLASS_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: CLASS GROUP
Definition: Classification grouping table.
Table Type: REFERENCE





Column Detail - CLASS_GROUP


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.
CHILD_CLASS_NODE_ID DOUBLE N A foreign key to the class_node table reflecting the child of a parent - child relationship.
CLASS_GROUP_ID DOUBLE N Primary Key
CLASS_INSTANCE_CD DOUBLE N The codevalue for this particular instance of a classification.
CREATE_APPLCTX DOUBLE Y The application context number from the record info block.
CREATE_DT_TM DATETIME Y The date and time the row was inserted.
CREATE_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the insert of the row in the table.
CREATE_TASK DOUBLE Y The registered (assigned) task number for the process that inserted the row.
PARENT_CLASS_NODE_ID DOUBLE N The parent class node.
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 - CLASS_GROUP


Child Column in CLASS_GROUP(FK) Parent Table Name Parent Column Name
Parents: CHILD_CLASS_NODE_ID CLASS_NODE CLASS_NODE_ID
PARENT_CLASS_NODE_ID CLASS_NODE CLASS_NODE_ID


CLASS_NODE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Classification Node.
Definition: An individual class node in the classfication (eg. Sutures).
Table Type: REFERENCE





Column Detail - CLASS_NODE


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 this node is built under.
CLASS_NODE_ID DOUBLE N Primary key
CLASS_TYPE_CD DOUBLE N The type of classification the being defined (e.g. Item Class, Ordering Class, Reporting Class).
CREATE_APPLCTX DOUBLE Y The application context number from the record info block.
CREATE_DT_TM DATETIME Y The date and time the row was inserted.
CREATE_ID DOUBLE Y The person_id of the person from the personnel table (prsnl) that caused the insert of the row in the table.
CREATE_TASK DOUBLE Y The registered (assigned) task number for the process that inserted the row.
DESCRIPTION VARCHAR(60) Y Description of the class node.
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.
SHORT_DESCRIPTION VARCHAR(40) Y Short description of the class node.
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 - CLASS_NODE


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




Parent Column in CLASS_NODE (PK) Child Table Name Child Column Name
Children: CLASS_NODE_ID CLASS_GROUP CHILD_CLASS_NODE_ID
CLASS_GROUP PARENT_CLASS_NODE_ID
ITEM_CLASS_NODE_R CLASS_NODE_ID
MM_APPROVAL CLASS_NODE_ID
MM_APPROVAL_QUEUE CLASS_NODE_ID
MM_CYCLE_CNT_FILTER CLASS_NODE_ID
MM_OMF_ITEM_MASTER CLASS_NODE_ID
MM_PRICE_FORMULA_CLASS_R CLASS_NODE_ID
MM_REQ_FILL_ROUTE CLASS_NODE_ID
MM_SUPPLY_CABINET ITEM_CLASS_ID
MM_XFI_CNTRCT_HDR CLASS_NODE_ID
MM_XFI_CNTRCT_HDR_TIER CLASS_NODE_ID
MM_XFI_CNTRCT_PRICE_ADJ ADJ_CLASS_NODE_ID
MM_XFI_ITEM CLASS_NODE_ID
OBJECT_IDENTIFIER_INDEX OBJECT_PARENT_NODE_ID
PRSNL_CLASS_NODE_R CLASS_NODE_ID
SEGMENT_REFERENCE EQUIP_CLASS_NODE_ID
SN_SUP_CAB_PREF_CLASS ITEM_CLASS_ID


EQUIPMENT_MASTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: EQUIPMENT MASTER
Definition: Equipment master - subclass of Item Master
Table Type: REFERENCE





Column Detail - EQUIPMENT_MASTER


Column Name Type Null? Definition
ITEM_ID DOUBLE N Primary key
SAFETY_CHK_IND DOUBLE Y Does this item require a safety check prior to use? Yes/No
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.
USAGE_UOM_CD DOUBLE N Usage unit of measure



Relationship Detail - EQUIPMENT_MASTER


Child Column in EQUIPMENT_MASTER(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_MASTER ITEM_ID


IDENTIFIER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Identifier
Definition: This table contains identifiers (Item Number, Description,...).
Table Type: REFERENCE





Column Detail - IDENTIFIER


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.
CONTRIBUTOR_CD DOUBLE N Contributor Source Code value
CREATE_APPLCTX DOUBLE Y The application context number from the record info block.
CREATE_DT_TM DATETIME Y The date and time the row was inserted.
CREATE_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.
CREATE_TASK DOUBLE Y The registered (assigned) task number for the process that inserted the row.
IDENTIFIER_ID DOUBLE N Primary key.
IDENTIFIER_TYPE_CD DOUBLE N Code value for the type of identifier.
IDENTIFIER_UPDT_CNT DOUBLE N Indicates the number of changes that have been made to Identifier that have not been updated in bill_item_modifier.
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.
PACKAGE_TYPE_ID DOUBLE N Foreign key to the package type table. Indicates the unit-of-measure for a specific UPN or NDC.
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the table to which the address row is related (i.e., person_id, organization_id, etc.)
PARENT_ENTITY_NAME VARCHAR(32) N Name of the parent entity table
REPLACED_UPN_ID DOUBLE N Foreign key to the identifier table. Indicates the UPN identifier that was replaced by the current UPN.
REPLACEMENT_UPN_ID DOUBLE N Foreign key to the identifier table. Indicates the UPN identifier that was replaces the current UPN.
SALABLE_BY_MFR_IND DOUBLE Y Indicates whether or not this UPN specific item & package is salable by the manufacturer.
SALABLE_BY_VENDOR_IND DOUBLE Y Indicates whether or not this UPN specific item & package is salable by the vendor.
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 The string displayed to the user.
VALUE_KEY VARCHAR(255) N Same as Value except in all uppercase.
VALUE_KEY_A_NLS VARCHAR(1020) Y VALUE_KEY_A_NLS column
VALUE_KEY_NLS VARCHAR(512) Y Used in queries for locales other than English.



Relationship Detail - IDENTIFIER


Child Column in IDENTIFIER(FK) Parent Table Name Parent Column Name
Parents: REPLACED_UPN_ID IDENTIFIER IDENTIFIER_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
PACKAGE_TYPE_ID PACKAGE_TYPE PACKAGE_TYPE_ID




Parent Column in IDENTIFIER (PK) Child Table Name Child Column Name
Children: IDENTIFIER_ID IDENTIFIER REPLACED_UPN_ID
MM_TRANS_LINE ITEM_DESC_ID
MM_TRANS_LINE ITEM_NBR_ID
MM_TRANS_LINE MFR_CATALOG_NBR_ID
MM_XFI_INSTANCE INSTANCE_IDENT_ID
MM_XFI_INSTANCE SERIAL_NBR_ID
MM_XFI_ITEM CHARGE_NUMBER_ID
MM_XFI_ITEM ITEM_ALIAS_ID
MM_XFI_ITEM ITEM_CLINICAL_DESC_ID
MM_XFI_ITEM ITEM_DESC_ID
MM_XFI_ITEM ITEM_NBR_ID
MM_XFI_ITEM ITEM_SHORT_DESC_ID
MM_XFI_ITEM MFR_ITEM_BRAND_NAME_ID
MM_XFI_ITEM MFR_ITEM_DESC_ID
MM_XFI_ITEM MFR_ITEM_NBR_ID
MM_XFI_ITEM MFR_ITEM_TRADE_NAME_ID
MM_XFI_ITEM REPLACEMENT_UPN_ID
MM_XFI_ITEM UPN_ID
MM_XFI_ITEM VENDOR_ITEM_DESC_ID
MM_XFI_ITEM VENDOR_ITEM_NBR_ID
OBJECT_IDENTIFIER_INDEX IDENTIFIER_ID