Table Detail Report

MANUFACTURER_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Manufacturer Item
Definition: Manufacturer's items
Table Type: REFERENCE





Column Detail - MANUFACTURER_ITEM


Column Name Type Null? Definition
AWP DOUBLE Y Average Wholesale Price
AWP_BULK DOUBLE Y AWP Bulk
AWP_FACTOR DOUBLE Y Average Wholesale Price Factor
COST1 DOUBLE Y Cost 1
COST2 DOUBLE Y Cost 1
ITEM_ID DOUBLE N Primary key inherited from item_definition
ITEM_MASTER_ID DOUBLE N Item Master Identifier
MANUFACTURER_CD DOUBLE N Manufacturer code value.
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.
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 - MANUFACTURER_ITEM




Parent Column in MANUFACTURER_ITEM (PK) Child Table Name Child Column Name
Children: ITEM_ID DISPENSE_REPLACE_AUDIT REPLACE_MANF_ITEM_ID
LINE_ITEM ORIGINAL_MANUF_ITEM_ID
MED_PRODUCT MANF_ITEM_ID
PHA_PROD_DISP_OBS_ST MANF_ITEM_ID
RECEIPT_LINE_ITEM ACTUAL_MANF_ITEM_ID
RX_ADMIN_PROD_DISPENSE_HX MANF_ITEM_ID


MM_COMMENT



Column Section Top of Page


Table-level Detail

Description: MM COMMENT
Definition: Mat Mgmt Comments
Table Type: ACTIVITY





Column Detail - MM_COMMENT


Column Name Type Null? Definition
COMMENT_TYPE_CD DOUBLE N The type of comment.
CREATE_APPLCTX DOUBLE Y Application which created this row
CREATE_DT_TM DATETIME Y The date/time this entry was created.
CREATE_ID DOUBLE N ID of user who created this row
CREATE_TASK DOUBLE Y Task which created this row
LONG_TEXT_ID DOUBLE N Foreign Key to long_text table.
PARENT_ENTITY_ID DOUBLE N Parent Entity ID
PARENT_ENTITY_NAME VARCHAR(32) 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_CS_PATIENT_PRICE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Inveontory Charge Serices Patient Price
Definition: Stores the price when Load Item Master 6 Ops job inserts or updates the patient price based off Variance defined in mmPricingTool.exe. Used for control of the ops job.
Table Type: ACTIVITY





Column Detail - MM_CS_PATIENT_PRICE


Column Name Type Null? Definition
COST_AMT DOUBLE N Cost amount from the last run of the ops job. Original value from ITEM_LOCATION_COST.cost
COST_TYPE_CD DOUBLE N The cost type code allows differentiation between average cost, current cost, last cost, etc.
ITEM_ID DOUBLE N The item that this cost and price applies to.
MM_CS_PATIENT_PRICE_ID DOUBLE N Unique, generated number that identifies a single row on the MM_CS_PATIENT_PRICE table.
MM_PRICE_FORMULA_ID DOUBLE N Identifies the price formula that was used for this item.
MM_PRICE_FORMULA_RANGE_ID DOUBLE N Identifies the price formula range that was used for this item.
OPS_JOB_RUN_DT_TM DATETIME N The date and time the ops job last ran and updated this row.
ORGANIZATION_ID DOUBLE N The organization that this item price was calculated for.
PRICE_AMT DOUBLE N The patient price derived based on supply cost with markup. The official data value is stored in PRICE_SCHED_ITEMS.price
PRICE_SCHED_ID DOUBLE N The price schedule that this item is a part of.
RANGE_END_DT_TM DATETIME N The end date of the pricing formula range.
RANGE_START_DT_TM DATETIME N The start date of the pricing formula range.
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_CS_PATIENT_PRICE


Child Column in MM_CS_PATIENT_PRICE(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_DEFINITION ITEM_ID
MM_PRICE_FORMULA_ID MM_PRICE_FORMULA MM_PRICE_FORMULA_ID
MM_PRICE_FORMULA_RANGE_ID MM_PRICE_FORMULA_RANGE MM_PRICE_FORMULA_RANGE_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PRICE_SCHED_ID PRICE_SCHED PRICE_SCHED_ID


MM_CYCLE_CNT_FILTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Cycle Count Filter
Definition: Stores some of the parameters needed to create a cycle count.
Table Type: REFERENCE





Column Detail - MM_CYCLE_CNT_FILTER


Column Name Type Null? Definition
ABC_CLASS_CD DOUBLE N Denotes the ABC classification of the items on this cycle count.
CLASS_NODE_ID DOUBLE N Denotes the Class node of the items on this cycle count.
FILTER_TYPE_FLAG DOUBLE N The type of parameter this row pertains to.
MM_CYCLE_CNT_FILTER_ID DOUBLE N Unique, generated number that identifies a single row on the MM_CYCLE_CNT_FILTER table.
MM_TEMPLATE_ID DOUBLE N %applyes%
SORT_METHOD_TXT VARCHAR(50) N Denotes how the items are going to be sorted.
SORT_SEQ DOUBLE N The sequence to apply when sorting by sort_txt.
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_CYCLE_CNT_FILTER


Child Column in MM_CYCLE_CNT_FILTER(FK) Parent Table Name Parent Column Name
Parents: CLASS_NODE_ID CLASS_NODE CLASS_NODE_ID
MM_TEMPLATE_ID MM_TEMPLATE MM_TEMPLATE_ID


MM_DB_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM DB LOG
Definition: ProCure DB update logging table.
Table Type: ACTIVITY





Column Detail - MM_DB_LOG


Column Name Type Null? Definition
APP_NAME VARCHAR(60) Y The application which caused the insert.
ATTR_COUNT DOUBLE Y The number of attributes filled out for a specific row.
ATTR_ID1 DOUBLE Y %examle%
ATTR_ID2 DOUBLE Y %examle%
ATTR_ID3 DOUBLE Y %examle%
ATTR_ID4 DOUBLE Y %examle%
ATTR_ID5 DOUBLE Y %examle%
ATTR_NAME1 VARCHAR(40) Y %examle%
ATTR_NAME2 VARCHAR(40) Y %examle%
ATTR_NAME3 VARCHAR(40) Y %examle%
ATTR_NAME4 VARCHAR(40) Y %examle%
ATTR_NAME5 VARCHAR(40) Y %examle%
ATTR_VALUE1 VARCHAR(100) Y %examle%
ATTR_VALUE2 VARCHAR(100) Y %examle%
ATTR_VALUE3 VARCHAR(100) Y %examle%
ATTR_VALUE4 VARCHAR(100) Y %examle%
ATTR_VALUE5 VARCHAR(100) Y %examle%
FIELD_COUNT DOUBLE Y The number of fields filled out for this row.
FIELD_NAME1 VARCHAR(30) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_NAME10 VARCHAR(30) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_NAME2 VARCHAR(30) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_NAME3 VARCHAR(30) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_NAME4 VARCHAR(30) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_NAME5 VARCHAR(30) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_NAME6 VARCHAR(30) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_NAME7 VARCHAR(30) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_NAME8 VARCHAR(30) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_NAME9 VARCHAR(30) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_VALUE_NEW1 VARCHAR(100) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_VALUE_NEW10 VARCHAR(100) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_VALUE_NEW2 VARCHAR(100) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_VALUE_NEW3 VARCHAR(100) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_VALUE_NEW4 VARCHAR(100) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_VALUE_NEW5 VARCHAR(100) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_VALUE_NEW6 VARCHAR(100) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_VALUE_NEW7 VARCHAR(100) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_VALUE_NEW8 VARCHAR(100) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_VALUE_NEW9 VARCHAR(100) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_VALUE_OLD1 VARCHAR(100) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_VALUE_OLD10 VARCHAR(100) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_VALUE_OLD2 VARCHAR(100) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_VALUE_OLD3 VARCHAR(100) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_VALUE_OLD4 VARCHAR(100) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_VALUE_OLD5 VARCHAR(100) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_VALUE_OLD6 VARCHAR(100) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_VALUE_OLD7 VARCHAR(100) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_VALUE_OLD8 VARCHAR(100) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
FIELD_VALUE_OLD9 VARCHAR(100) Y All 'FIELD_*' fields come in threes: Name, Old Value, New Value. The Name will be the actual table field name. The Old Value will contain what was previously on the table and the New Value obviously contains the new one.
LOGICAL_DOMAIN_ID DOUBLE Y 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.
LOG_ID DOUBLE N Primary Key
LOG_TYPE_CD DOUBLE N The type of log.
ORGANIZATION_ID DOUBLE Y The Organization that is associated to the logged item.
PERSON_NAME VARCHAR(100) Y The person who caused the insert.
REQ_NAME VARCHAR(40) Y (currently not used)
TASK_NAME VARCHAR(60) Y The task which caused the insert.
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_DB_LOG


Child Column in MM_DB_LOG(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID