Millennium Data Model Reports - 2026.1.01

• Home
• |
• Reports by Table
• |
• Table Report Help

Table Detail Report

ORDER_PROPOSAL_ADHOC_TIME

Column Section

Relationship Section

Top of Page

Table-level Detail

Description:	Order Proposal Adhoc Time
Definition:	This table stores adhoc frequency times that are being proposed for a new or existing order.
Table Type:	ACTIVITY

Column Detail - ORDER_PROPOSAL_ADHOC_TIME

Column Name	Type	Null?	Definition
ADHOC_TIME_SEQUENCE	DOUBLE	N	Signifies the order of the ad hoc frequency time supplied for a proposal. This is assigned by the system.
ORDER_PROPOSAL_ADHOC_TIME_ID	DOUBLE	N	The primary key of this table. It is internally assigned by the system.
ORDER_PROPOSAL_ID	DOUBLE	N	The order proposal ID associated to this ad hoc frequency time instance.
TIME_OF_DAY	DOUBLE	N	Ad hoc time of day which is represented as the number of minutes within a day. The valid range of values for this field is 0 to 1439 (inclusive).
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 - ORDER_PROPOSAL_ADHOC_TIME

	Child Column in ORDER_PROPOSAL_ADHOC_TIME(FK)	Parent Table Name	Parent Column Name
Parents:	ORDER_PROPOSAL_ID	ORDER_PROPOSAL	ORDER_PROPOSAL_ID

ORDER_PROPOSAL_COMMENT

Column Section

Relationship Section

Top of Page

Table-level Detail

Description:	Order Proposal Comment
Definition:	Stores comments associated with an order proposal
Table Type:	ACTIVITY

Column Detail - ORDER_PROPOSAL_COMMENT

Column Name	Type	Null?	Definition
COMMENT_TYPE_CD	DOUBLE	N	Codified value indicating the type of comment associated with a proposal.
LONG_TEXT_ID	DOUBLE	N	The long text id from the Long Text table.
ORDER_PROPOSAL_COMMENT_ID	DOUBLE	N	Primary key of this table. It is internally assigned by the system.
ORDER_PROPOSAL_ID	DOUBLE	N	The order proposal ID associated with this comment
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 - ORDER_PROPOSAL_COMMENT

	Child Column in ORDER_PROPOSAL_COMMENT(FK)	Parent Table Name	Parent Column Name
Parents:	ORDER_PROPOSAL_ID	ORDER_PROPOSAL	ORDER_PROPOSAL_ID

ORDER_PROPOSAL_DETAIL

Column Section

Relationship Section

Top of Page

Table-level Detail

Description:	Order Proposal Detail
Definition:	This table stores all order details captured about an order proposal.
Table Type:	ACTIVITY

Column Detail - ORDER_PROPOSAL_DETAIL

Column Name	Type	Null?	Definition
DETAIL_ALTER_FLAG	DOUBLE	N	For a proposal to create an order, this field is set to 2, which indicates this is a new detail. For a proposal to alter an order, the flag identifies how this detail relates to the order's detail that this proposal is for. 0 - Unchanged, 1 - Modify, 2 - Add, 3 - Delete.
DETAIL_DEFAULT_VALUE	VARCHAR(255)	Y	The default value of the detail. This value represents a codified meaning which indicates the value that should be applied to the detail at the point of acceptance (ex. "T;N" represents current date/time when under consideration of being accepted) . If this field is valued, oe_field_display_value, oe_field_dt_tm_value, and oe_field_value will not be valued.
DETAIL_SEQUENCE	DOUBLE	N	Signifies the order of the detail within the proposal. This is assigned by the system.
OE_FIELD_DISPLAY_VALUE	VARCHAR(255)	Y	The display value of the order proposal detail.
OE_FIELD_DISPLAY_VALUE_EXTEND	VARCHAR(4000)	Y	The extended display value of the order proposal detail.
OE_FIELD_DT_TM_VALUE	DATETIME	Y	Date and time value captured by this detail. This is only filled out for date/time details
OE_FIELD_ID	DOUBLE	N	This number uniquely identifies the order entry field. It is defined on the order_entry_fields table
OE_FIELD_MEANING	VARCHAR(25)	Y	This is the meaning associated to the OE_Field_ID attribute. It is the text that describes the type of information that the detail captures.
OE_FIELD_MEANING_ID	DOUBLE	N	This is the Cerner defined meaning ID associated to the OE_Field_ID. It identifies the type of information that the detail captures.
OE_FIELD_TZ	DOUBLE	Y	The time zone associated to this date/time detail. This is only filled out for date/time details. For the order detail tables, it can either represent the user's or the patients (facility location) timezone, depending on the type of concept that detail is meant to store.
OE_FIELD_VALUE	DOUBLE	Y	Numeric value captured by this detail. This could be a codified value or a simple numeric value.
ORDER_PROPOSAL_DETAIL_ID	DOUBLE	N	The primary key of this table. It is internally generated by the system.
ORDER_PROPOSAL_ID	DOUBLE	N	The order proposal ID associated with this detail.
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 - ORDER_PROPOSAL_DETAIL

	Child Column in ORDER_PROPOSAL_DETAIL(FK)	Parent Table Name	Parent Column Name
Parents:	OE_FIELD_MEANING_ID	OE_FIELD_MEANING	OE_FIELD_MEANING_ID
	OE_FIELD_ID	ORDER_ENTRY_FIELDS	OE_FIELD_ID
	ORDER_PROPOSAL_ID	ORDER_PROPOSAL	ORDER_PROPOSAL_ID

	Parent Column in ORDER_PROPOSAL_DETAIL (PK)	Child Table Name	Child Column Name
Children:	ORDER_PROPOSAL_DETAIL_ID	ORDER_PROPOSAL_DETAIL_HST	ORDER_PROPOSAL_DETAIL_ID

ORDER_PROPOSAL_DETAIL_HST

Column Section

Relationship Section

Top of Page

Table-level Detail

Description:	Order Proposal Detail History
Definition:	The table will store order proposal details that are altered by the system from what the user entered.
Table Type:	ACTIVITY

Column Detail - ORDER_PROPOSAL_DETAIL_HST

Column Name	Type	Null?	Definition
DETAIL_ALTER_TRIGGER_CD	DOUBLE	N	Codified value that indicates the trigger that altered details. e.g. Therapeutic Substitution.
OE_FIELD_DISPLAY_VALUE	VARCHAR(255)	Y	The display value of the order proposal detail.
OE_FIELD_DT_TM_VALUE	DATETIME	Y	Date and time value captured by this detail. This is only filled out for date/time details
OE_FIELD_TZ	DOUBLE	Y	The time zone associated to this date/time detail. This is only filled out for date/time details
OE_FIELD_VALUE	DOUBLE	Y	Numeric value captured by this detail. this could be a codified value or a simple numeric value.
ORDER_PROPOSAL_DETAIL_HST_ID	DOUBLE	N	Unique generated number that identifies a single row on the ORDER_PROPOSAL_DETAIL_HST table.
ORDER_PROPOSAL_DETAIL_ID	DOUBLE	N	The ID of the order proposal detail associated with this alteration.
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 - ORDER_PROPOSAL_DETAIL_HST

	Child Column in ORDER_PROPOSAL_DETAIL_HST(FK)	Parent Table Name	Parent Column Name
Parents:	ORDER_PROPOSAL_DETAIL_ID	ORDER_PROPOSAL_DETAIL	ORDER_PROPOSAL_DETAIL_ID

ORDER_PROPOSAL_DIAG_RELTN

Column Section

Relationship Section

Top of Page

Table-level Detail

Description:	Order Proposal Diagnosis Relation
Definition:	This table stores attributes that are a part of the relationship between the Order _Proposal and Diagnosis tables.
Table Type:	ACTIVITY

Column Detail - ORDER_PROPOSAL_DIAG_RELTN

Column Name	Type	Null?	Definition
DIAGNOSIS_ALTER_FLAG	DOUBLE	N	Identifies what type of diagnosis change it is. For a proposal to create an order this field is set to 1, which indicates it is a new diagnosis. 0 - Unchanged, 1 - Add, 2 - Modify, 3 - Delete
DIAGNOSIS_ID	DOUBLE	N	This is the diagnosis ID from the Diagnosis table of the diagnosis associated with the order proposal.
ORDER_PROPOSAL_DIAG_RELTN_ID	DOUBLE	N	This is the primary key of this table. It is assigned internally by the system.
ORDER_PROPOSAL_ID	DOUBLE	N	This is the ID of the order proposal associated to this diagnosis.
RANK_SEQUENCE	DOUBLE	N	This field captures how the diagnosis is ranked in relationship to the order proposal.
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 - ORDER_PROPOSAL_DIAG_RELTN

	Child Column in ORDER_PROPOSAL_DIAG_RELTN(FK)	Parent Table Name	Parent Column Name
Parents:	DIAGNOSIS_ID	DIAGNOSIS	DIAGNOSIS_ID
	ORDER_PROPOSAL_ID	ORDER_PROPOSAL	ORDER_PROPOSAL_ID

Copyright © 2026 Oracle and/or its affiliates. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission.

Materials in this document pertain to Oracle Health, Oracle, Oracle Cerner, and Cerner Enviza which are all wholly-owned subsidiaries of Oracle Corporation.
Nothing in this document should be taken as indicating that any decisions regarding the integration of any EMEA Cerner and/or Enviza entities have been made where an integration has not already occurred.
Last Updated: January 26, 2026