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 |