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 |