Table Detail Report
MM_OMF_MFG_ITEM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | MM OMF MFG ITEM |
Definition: | Manufacturer item summary table |
Table Type: | REFERENCE |
Column Detail - MM_OMF_MFG_ITEM
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_CD | DOUBLE | N | active status |
ACTIVE_DT_NBR | DOUBLE | Y | Date, in Julian format, this item became active. |
ACTIVE_DT_TM | DATETIME | Y | Date and time the row is activated (active indicator is set to 1). |
ACTIVE_ID | DOUBLE | N | The ID from the person table that activated the item |
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_MIN_NBR | DOUBLE | Y | Stores the minute value of when the item became active. |
AWP | DOUBLE | Y | Contains the Average Wholesale Price for the item. |
AWP_BULK | DOUBLE | Y | The bulk average wholesale price for this item. |
AWP_FACTOR | DOUBLE | Y | Contains the items average wholesale price factor. |
BRAND_NAME | VARCHAR(100) | Y | Brand Name of the item. |
COST1 | DOUBLE | Y | Cost1 - not currently being used. |
COST2 | DOUBLE | Y | Cost2 - not currently being used. |
CREATE_DT_NBR | DOUBLE | Y | A Julian date, number representing the date this item row was created. |
CREATE_DT_TM | DATETIME | Y | The date/time this entry was created. |
CREATE_ID | DOUBLE | N | ID of user who created this row |
CREATE_MIN_NBR | DOUBLE | Y | Contains the minute number of when the item row was created. |
DESCRIPTION | VARCHAR(200) | Y | textual description of the item |
ITEM_COUNT | DOUBLE | Y | Stores an item count. |
ITEM_NBR | VARCHAR(40) | Y | An identifying number of the item. |
LAST_DIST_DT_NBR | DOUBLE | Y | Stores the items' last distribution date in a Julian format. |
LAST_DIST_DT_TM | DATETIME | Y | Stores the date and time of the items' last distribution. |
LAST_DIST_MIN_NBR | DOUBLE | Y | Stores the minute value for the items' last distribution. |
LAST_ORDER_CONTRACT_DESC | VARCHAR(100) | Y | % lst% |
LAST_ORDER_DT_NBR | DOUBLE | Y | Stores the last order date for the item in Julian format. |
LAST_ORDER_DT_TM | DATETIME | Y | Stores the date and time of the items' last order. |
LAST_ORDER_MIN_NBR | DOUBLE | Y | Stores the minute value for the items last order time. |
LAST_ORDER_PKG_DESC | VARCHAR(40) | Y | Stores the Package Description for the items' last order. |
LAST_ORDER_PRICE | DOUBLE | Y | Stores the price of the items' last order. |
LAST_ORDER_PRICE_TYPE_CD | DOUBLE | N | Stores the type of order price for the items' last order. |
LAST_RECEIPT_DT_NBR | DOUBLE | Y | Last Receipt Date, in Julian format, for this item. |
LAST_RECEIPT_DT_TM | DATETIME | Y | Date and Time for the Last Receipt for this item. |
LAST_RECEIPT_MIN_NBR | DOUBLE | Y | Minute Number Value for the Last Receipt for this item. |
LAST_RECEIPT_PKG_DESC | VARCHAR(40) | Y | Package Description for the Last Receipt for this item. |
LAST_REQ_DT_NBR | DOUBLE | Y | date, in Julian format, of the last requisition, for this item. |
LAST_REQ_DT_TM | DATETIME | Y | Date and time of the last requisition for this item. |
LAST_REQ_MIN_NBR | DOUBLE | Y | Minute value for the last requisition for this item. |
LAST_UPDT_DT_NBR | DOUBLE | Y | Date, in Julian format of the Last Update for this item. |
LAST_UPDT_DT_TM | DATETIME | Y | Date and time of the Last Update for this item. |
LAST_UPDT_ID | DOUBLE | N | Identification of the person who performed the Last Update on this item. |
LAST_UPDT_MIN_NBR | DOUBLE | Y | Value of the minutes for the Last Update for this item. |
LAST_VOUCHER_DT_NBR | DOUBLE | Y | Date, in Julian format, of the Last Voucher for this item. |
LAST_VOUCHER_DT_TM | DATETIME | Y | Date and Time of the Last Voucher for this item. |
LAST_VOUCHER_MIN_NBR | DOUBLE | Y | Value of the minutes for the Last Voucher for this item. |
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. |
MFG_CD | DOUBLE | N | Manufacturer code for the item |
MFG_ITEM_ID | DOUBLE | N | Uniquely identifies and Manufacturing Item |
NDC | VARCHAR(40) | Y | Uniqule National Drug Code for this item. |
QUICKADD_IND | DOUBLE | Y | Indicates whether an item is Quickadd. |
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 - MM_OMF_MFG_ITEM
Child Column in MM_OMF_MFG_ITEM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |
MM_OMF_UPD_QUEUE
Column Section | Top of Page |
Table-level Detail
Description: | MM OMF UPD QUEUE |
Definition: | Table used to determine what to update for the OMF tables |
Table Type: | ACTIVITY |
Column Detail - MM_OMF_UPD_QUEUE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_FLAG | DOUBLE | Y | Field used to determine if the entry is a new or updated one. Currently, this field is not being used. |
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 |
PARENT_ENTITY_ID | DOUBLE | N | Foreign key to a table designated by parent_entity_name |
PARENT_ENTITY_NAME | VARCHAR(40) | N | Defines the parent table for parent_entity_id |
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. |
MM_OMF_VENDOR_ITEM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Vendor Item table |
Definition: | Vendor Item Summary table built using omf tools. |
Table Type: | REFERENCE |
Column Detail - MM_OMF_VENDOR_ITEM
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_CD | DOUBLE | N | Active Code |
ACTIVE_DT_NBR | DOUBLE | Y | Date, in Julian format, this item became active. |
ACTIVE_DT_TM | DATETIME | Y | The date and time that this row became active, usually the date and time that it was inserted. |
ACTIVE_ID | DOUBLE | N | The ID from the person table that activated the item |
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_MIN_NBR | DOUBLE | Y | Stores the minute value of when the item became active. |
CREATE_DT_NBR | DOUBLE | Y | A Julian date, number representing the date this item row was created. |
CREATE_DT_TM | DATETIME | Y | The date/time this entry was created. |
CREATE_ID | DOUBLE | N | ID of user who created this row |
CREATE_MIN_NBR | DOUBLE | Y | Contains the minute number of when the item row was created. |
DESCRIPTION | VARCHAR(200) | Y | textual description |
ITEM_COUNT | DOUBLE | Y | Stores an item count. |
ITEM_NBR | VARCHAR(40) | Y | Item Number Identifier. |
LAST_DIST_DT_NBR | DOUBLE | Y | Stores the items' last distribution date in a Julian format. |
LAST_DIST_DT_TM | DATETIME | Y | Stores the date and time of the items' last distribution. |
LAST_DIST_MIN_NBR | DOUBLE | Y | Stores the minute value for the items' last distribution. |
LAST_ORDER_CONTRACT_DESC | VARCHAR(100) | Y | % lst% |
LAST_ORDER_DT_NBR | DOUBLE | Y | Stores the last order date for the item in Julian format. |
LAST_ORDER_DT_TM | DATETIME | Y | Stores the date and time of the items' last order. |
LAST_ORDER_MIN_NBR | DOUBLE | Y | Stores the minute value for the items last order time. |
LAST_ORDER_PKG_DESC | VARCHAR(40) | Y | Stores the Package Description for the items' last order. |
LAST_ORDER_PRICE | DOUBLE | Y | Stores the price of the items' last order. |
LAST_ORDER_PRICE_TYPE_CD | DOUBLE | N | Stores the type of order price for the items' last order. |
LAST_RECEIPT_DT_NBR | DOUBLE | Y | %Reciept% |
LAST_RECEIPT_DT_TM | DATETIME | Y | Date and Time for the Last Receipt for this item. |
LAST_RECEIPT_MIN_NBR | DOUBLE | Y | Minute Number Value for the Last Receipt for this item. |
LAST_RECEIPT_PKG_DESC | VARCHAR(40) | Y | Package Description for the Last Receipt for this item. |
LAST_REQ_DT_NBR | DOUBLE | Y | date, in Julian format, of the last requisition, for this item. |
LAST_REQ_DT_TM | DATETIME | Y | Date and time of the last requisition for this item. |
LAST_REQ_MIN_NBR | DOUBLE | Y | Minute value for the last requisition for this item. |
LAST_UPDT_DT_NBR | DOUBLE | Y | Date, in Julian format of the Last Update for this item. |
LAST_UPDT_DT_TM | DATETIME | Y | Date and time of the Last Update for this item. |
LAST_UPDT_ID | DOUBLE | N | Identification of the person who performed the Last Update on this item. |
LAST_UPDT_MIN_NBR | DOUBLE | Y | Value of the minutes for the Last Update for this item. |
LAST_VOUCHER_DT_NBR | DOUBLE | Y | Date, in Julian format, of the Last Voucher for this item. |
LAST_VOUCHER_DT_TM | DATETIME | Y | Date and Time of the Last Voucher for this item. |
LAST_VOUCHER_MIN_NBR | DOUBLE | Y | Value of the minutes for the Last Voucher for this item. |
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. |
QUICKADD_IND | DOUBLE | Y | Indicates whether an item is Quickadd. |
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 | N | Vendor associated with this account |
VENDOR_ITEM_ID | DOUBLE | N | Uniquely identifies a vendor item. |
Relationship Detail - MM_OMF_VENDOR_ITEM
Child Column in MM_OMF_VENDOR_ITEM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |
MM_PRICE_FORMULA
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Pricing Formula |
Definition: | Formula used to determine the patient price for the supply bill items. |
Table Type: | REFERENCE |
Column Detail - MM_PRICE_FORMULA
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. |
MM_PRICE_FORMULA_ID | DOUBLE | N | Unique generated number that identifies a single row on the MM_PRICE_FORMULA table. |
ORGANIZATION_ID | DOUBLE | N | The organization associated with this pricing formula |
PRICE_FORMULA_DESC | VARCHAR(40) | N | Text field describing the formula |
PRICE_FORMULA_DESC_KEY | VARCHAR(40) | N | This field contains the price_formula_desc value with all special characters removed and all alpha characters converted to upper case. |
PRICE_FORMULA_DESC_KEY_A_NLS | VARCHAR(160) | N | Stores the corresponding non-English character set values for the price_formula_desc_key column. Used to sort correctly internationally. |
PRICE_SCHED_ID | DOUBLE | N | Price Schedule associated to this pricing formula. |
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 - MM_PRICE_FORMULA
Child Column in MM_PRICE_FORMULA(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID |
PRICE_SCHED_ID | PRICE_SCHED | PRICE_SCHED_ID |
Parent Column in MM_PRICE_FORMULA (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | MM_PRICE_FORMULA_ID | MM_CS_PATIENT_PRICE | MM_PRICE_FORMULA_ID |
MM_PRICE_FORMULA_CLASS_R | MM_PRICE_FORMULA_ID | ||
MM_PRICE_FORMULA_LOC_RELTN | MM_PRICE_FORMULA_ID | ||
MM_PRICE_FORMULA_RANGE | MM_PRICE_FORMULA_ID |
MM_PRICE_FORMULA_CLASS_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Pricing Formula Class Relation |
Definition: | The class of item this formula applies to. |
Table Type: | REFERENCE |
Column Detail - MM_PRICE_FORMULA_CLASS_R
Column Name | Type | Null? | Definition |
---|---|---|---|
CLASS_NODE_ID | DOUBLE | N | The classification for this formula |
MM_PRICE_FORMULA_CLASS_R_ID | DOUBLE | N | Unique generated number that identifies a single row on the MM_PRICE_FORMULA_CLASS_R table. |
MM_PRICE_FORMULA_ID | DOUBLE | N | The price formula that the classification on this row is associated with. |
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 - MM_PRICE_FORMULA_CLASS_R
Child Column in MM_PRICE_FORMULA_CLASS_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CLASS_NODE_ID | CLASS_NODE | CLASS_NODE_ID |
MM_PRICE_FORMULA_ID | MM_PRICE_FORMULA | MM_PRICE_FORMULA_ID |