Table Detail Report

MM_PRICE_FORMULA_LOC_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pricing Formula Location Relationship
Definition: Links the price schedules with locations. This will only be populated if the organization is not tracking costs at the organization level.
Table Type: REFERENCE





Column Detail - MM_PRICE_FORMULA_LOC_RELTN


Column Name Type Null? Definition
LOCATION_CD DOUBLE N The location that this pricing formula is associated with.
LOC_SEQ DOUBLE N The order the locations are to be applied for a particular formula.
MM_PRICE_FORMULA_ID DOUBLE N The formula for which this location applies.
MM_PRICE_FORMULA_LOC_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the MM_PRICE_FORMULA_LOC_RELTN table.
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_LOC_RELTN


Child Column in MM_PRICE_FORMULA_LOC_RELTN(FK) Parent Table Name Parent Column Name
Parents: LOCATION_CD LOCATION LOCATION_CD
MM_PRICE_FORMULA_ID MM_PRICE_FORMULA MM_PRICE_FORMULA_ID


MM_PRICE_FORMULA_RANGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pricing Formula Range
Definition: Date ranges for the pricing formula.
Table Type: REFERENCE





Column Detail - MM_PRICE_FORMULA_RANGE


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.
APPLY_FEE_IND DOUBLE N Indicator to check whether the fee has to be applied before the markup
BEGIN_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is considered valid as active current data.
COST_TYPE_CD DOUBLE N The type of costing for this formula. If there is org level tracking, the choices are Org Average or Org Last Cost. If there is location level tracking, the choices are Average and Last Cost.
DAY_OF_WEEK_FLAG DOUBLE N The day of the week that this formula will be updated.
END_DT_TM DATETIME N Date and time on which the pricing formula range ends
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
LAST_UPDT_PRSNL_ID DOUBLE N The personnel that last updated this row.
MM_PRICE_FORMULA_ID DOUBLE N The pricing formula that this range applies to.
MM_PRICE_FORMULA_RANGE_ID DOUBLE N Unique generated number that identifies a single row on the MM_PRICE_FORMULA_RANGE table.
MONTHLY_OCCURRENCE_TYPE_FLAG DOUBLE N Monthly pattern type selected
MONTHLY_WEEK_NBR DOUBLE N The relative week during a month that recurrence selection is set for.
NEGATIVE_VARIANCE_AMT DOUBLE N Will hold the negative variance percentage or amount.
NEGATIVE_VARIANCE_TYPE_IND DOUBLE N Indicates if the negative variance amount represents a percentage or a monetary amount.
OCCURRENCE_DAYS DOUBLE N The number of days that recurrence selection is set for
OCCURRENCE_MONTHS DOUBLE N The number of months that recurrence selection is set for
OCCURRENCE_TYPE_FLAG DOUBLE N Indicates if the occurrence type is daily, weekly, or monthly.
OCCURRENCE_WEEKS DOUBLE N The number of weeks that recurrence selection is set for
POSITIVE_VARIANCE_AMT DOUBLE N Will hold the positive variance percentage or amount.
POSITIVE_VARIANCE_TYPE_IND DOUBLE N Indicates if the positive variance amount represents a percentage or a monetary amount.
PREV_MM_PRICE_FORMULA_RANGE_ID DOUBLE N The id to the price formula range row before the record was changed. If 0, this is the original unchanged row
RANGE_DESC VARCHAR(40) N Description of pricing formula range
RANGE_DESC_KEY VARCHAR(40) N The value in RANGE_DESC but in all capitals with punctuation removed. This field is used for indexing and searching/
RANGE_DESC_KEY_A_NLS VARCHAR(160) N Stores the corresponding non-English character set values for the range_desc_key column. Used to sort correctly internationally.
START_DT_TM DATETIME N Date and time on which the pricing formula range begins
UPDATE_PRICE_FLAG DOUBLE N Indicates if the price needs to be updated based on the variance percentage or amount.
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_RANGE


Child Column in MM_PRICE_FORMULA_RANGE(FK) Parent Table Name Parent Column Name
Parents: MM_PRICE_FORMULA_ID MM_PRICE_FORMULA MM_PRICE_FORMULA_ID
PREV_MM_PRICE_FORMULA_RANGE_ID MM_PRICE_FORMULA_RANGE MM_PRICE_FORMULA_RANGE_ID
LAST_UPDT_PRSNL_ID PRSNL PERSON_ID




Parent Column in MM_PRICE_FORMULA_RANGE (PK) Child Table Name Child Column Name
Children: MM_PRICE_FORMULA_RANGE_ID MM_CS_PATIENT_PRICE MM_PRICE_FORMULA_RANGE_ID
MM_PRICE_FORMULA_RANGE PREV_MM_PRICE_FORMULA_RANGE_ID
MM_RANGE_DETAIL MM_PRICE_FORMULA_RANGE_ID
MM_RANGE_PROCESS MM_PRICE_FORMULA_RANGE_ID


MM_RANGE_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pricing Formula Range Detail
Definition: This table will store the varius components that are considered to calculate the price for each date range.
Table Type: REFERENCE





Column Detail - MM_RANGE_DETAIL


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.
ADMIN_CHARGE_AMT DOUBLE N Administrative overhead which added/subtracted to base price to form the final cost
BEGIN_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is considered valid as active current data.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
FROM_COST_AMT DOUBLE N Base price of the item
LAST_UPDT_PRSNL_ID DOUBLE N Personnel that last updated this row.
MARKUP_PCT DOUBLE N Percentage of markup overhead which added/subtracted to base price to form the final cost
MIN_PRICE_AMT DOUBLE N The minimum price an item can cost.
MM_PRICE_FORMULA_RANGE_ID DOUBLE N The pricing formula range that these details pertain to.
MM_RANGE_DETAIL_ID DOUBLE N Unique generated number that identifies a single row on the MM_RANGE_DETAIL table.
PREV_MM_RANGE_DETAIL_ID DOUBLE N The id to the range detail row before the record was changed. If 0, this is the original unchanged record
ROUND_UP_AMT DOUBLE N Rounded value to the nearest number
SERVICE_CHARGE_AMT DOUBLE N Service charge overhead which added/subtracted to base price to form the final cost
TO_COST_AMT DOUBLE N Final price of an item
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_RANGE_DETAIL


Child Column in MM_RANGE_DETAIL(FK) Parent Table Name Parent Column Name
Parents: MM_PRICE_FORMULA_RANGE_ID MM_PRICE_FORMULA_RANGE MM_PRICE_FORMULA_RANGE_ID
PREV_MM_RANGE_DETAIL_ID MM_RANGE_DETAIL MM_RANGE_DETAIL_ID
LAST_UPDT_PRSNL_ID PRSNL PERSON_ID




Parent Column in MM_RANGE_DETAIL (PK) Child Table Name Child Column Name
Children: MM_RANGE_DETAIL_ID MM_RANGE_DETAIL PREV_MM_RANGE_DETAIL_ID


MM_RANGE_PROCESS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pricing Formula Range Process
Definition: Information about the price calculations of each pricing formula.
Table Type: ACTIVITY





Column Detail - MM_RANGE_PROCESS


Column Name Type Null? Definition
LAST_RUN_DT_TM DATETIME Y The date and time the previous price calculation was performed.
MM_PRICE_FORMULA_RANGE_ID DOUBLE N The pricing formula range that this price evaluation was performed on.
MM_RANGE_PROCESSING_ID DOUBLE N Unique generated number that identifies a single row on the MM_RANGE_PROCESS table.
NEXT_RUN_DT_TM DATETIME Y The date and time the next price calculation is scheduled to run.
NEXT_RUN_DT_TM_TZ DOUBLE N Stores the time zone on which the next run date time is updated.
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 - MM_RANGE_PROCESS


Child Column in MM_RANGE_PROCESS(FK) Parent Table Name Parent Column Name
Parents: MM_PRICE_FORMULA_RANGE_ID MM_PRICE_FORMULA_RANGE MM_PRICE_FORMULA_RANGE_ID


MM_SUPPLY_CABINET



Column Section Relationship Section Top of Page


Table-level Detail

Description: MM SUPPLY CABINET
Definition: Stores data received from an external supply cabinet
Table Type: ACTIVITY





Column Detail - MM_SUPPLY_CABINET


Column Name Type Null? Definition
BUS_DOMAIN_NAME VARCHAR(30) Y The bus domain that is the source of this information.
DEVICE_IDENT VARCHAR(150) Y The identifier of the device as supplied by the Bus.
ITEM_CLASS_ID DOUBLE N The supply cabinet inventory item's class.
ITEM_ID DOUBLE N The resolved Millennium item in ITEM_DEFINITION.
LATEX_CD DOUBLE N The resolved Millennium latex indicator.
LOC_CD DOUBLE N The location of the supply cabinet.
LOT_NUMBER_ID DOUBLE N Resolved Millennium lot number.
MFR_CD DOUBLE N Resolved Millennium manufacturer code
MFR_ITEM_ID DOUBLE N Resolved Millennium manufacturer item id
MM_SUPPLY_CABINET_ID DOUBLE N Unique, generated number that identifies a single row on the MM_SUPPLY_CABINET table.
PERSON_ID DOUBLE N Resolved Millennium patient that this supply is for.
PROCESSED_BY_APP_ID DOUBLE N Indicates the primary key from the application/table that consumed this data.
PROCESSED_BY_APP_NAME VARCHAR(30) Y Indicates the table that consumed this dataInitially this will be "PERIOPERATIVE_DOCUMENT"
PROCESSED_BY_DOC_IND DOUBLE N Indicates whether this row has been defaulted into Surgical documentation yet.
PROCESSED_BY_PL_IND DOUBLE N Indicates whether this row has been defaulted onto the Surgical pick list yet.
PROCESS_FLAG DOUBLE N Indicates the status of reconciling item received to Millennium item.
PRSNL_ID DOUBLE N The person that performed the action (remove, return, waste) that triggered this transaction
SC_EXP_DT_TM DATETIME Y Expiration date and time for lot received from supply cabinet
SC_ITEM_QTY DOUBLE Y Quantity of item(s) removed/returned/wasted from supply cabinet
SC_ITEM_TXT VARCHAR(255) N Description of item received from supply cabinet
SC_LATEX_CD DOUBLE N Indication from supply cabinet whether the item contains latex.
SC_LOT_NBR_TXT VARCHAR(40) Y Lot number received from supply cabinet
SC_MFR_CAT_NBR_TXT VARCHAR(255) Y Catalog number received from supply cabinet
SC_MFR_NAME VARCHAR(60) Y Item manufacturer received from supply cabinet
SC_REASON_TXT VARCHAR(255) Y Reason for the transaction. (Ex: Item was wasted, returned.)
SC_SERIAL_NBR_TXT VARCHAR(255) Y Item serial number received from supply cabinet
SC_SIZE_TXT VARCHAR(50) Y Item size and units (alphanumeric) received from supply cabinet
SC_SURG_CASE_NBR_TXT VARCHAR(25) Y The surgical case number received from a supply cabinet.
SC_TRANS_DT_TM DATETIME Y Date/time the transaction occurred on the supply cabinet.
SC_TRANS_FLAG DOUBLE N Indicates the type of transaction.1
SC_TRANS_IDENT VARCHAR(150) N The foreign system's internal identifier for the transaction.
SEG_CD DOUBLE N The surgical segment a supply cabinet inventory item defaulted on.
SURG_CASE_ID DOUBLE N The resolved surgical case resulting from the sc_surg_case_nbr_txt received from the supply cabinet.
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_SUPPLY_CABINET


Child Column in MM_SUPPLY_CABINET(FK) Parent Table Name Parent Column Name
Parents: ITEM_CLASS_ID CLASS_NODE CLASS_NODE_ID
ITEM_ID ITEM_DEFINITION ITEM_ID
MFR_ITEM_ID ITEM_DEFINITION ITEM_ID
LOC_CD LOCATION LOCATION_CD
LOT_NUMBER_ID LOT_NUMBER_INFO LOT_NUMBER_ID
PERSON_ID PERSON PERSON_ID
PRSNL_ID PRSNL PERSON_ID
SURG_CASE_ID SURGICAL_CASE SURG_CASE_ID