Table Detail Report

ONC_DOCSET_ELEM_DECORATOR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Doc Set Element Decorator
Definition: Defines display attributes of a doc set element
Table Type: REFERENCE





Column Detail - ONC_DOCSET_ELEM_DECORATOR


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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
DOC_SET_ELEMENT_ID DOUBLE N The id of the doc set element that is decorated.
ELEMENT_STYLE_FLAG DOUBLE N An enumeration specifying what element style to apply when displaying the element: 0: Default 1: Use Radio Buttons for Alpha Responses.
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.
END_GROUP_TYPE_FLAG DOUBLE N BitMask of enumerations for the type of group that is being ended: 0 (10) = 0 + 0 + 0 -> none 1 (10) = 0 + 0 + 1 -> tab 2 (10) = 0 + 10 + 0 -> frame 3 (10) = 0 + 10 + 1 -> tab and frame 4 (10) = 100 + 0 + 0 -> horizontal list 5 (10) = 100 + 0 + 1 -> horizontal list and tab. 6 (10) = 100 + 10 + 0 -> horizontal list and frame 7 (10) = 100 + 10 + 1 -> horizontal list and frame and tab.
GROUP_CAPTION VARCHAR(256) N The caption to use for the element group that is being started. When multiple group types are started simultaneously, '%~' will be interpreted as a delimiter so separate captions can be specified for each. The fields in the delimited string will be applied in increasing order by group type enumeration value.
GROUP_END_IND DOUBLE N Specifies to stop the last started element groups matching the group_type_flag
GROUP_START_IND DOUBLE N Specifies to start one element group for each group type represented in the group_type_flag. When multiple groups are provided they will be started in increasing order by group type enumeration value
ONC_DOCSET_ELEM_DECORATOR_ID DOUBLE N Primary key
PREV_DOCSET_ELEM_DECORATOR_ID DOUBLE N Previous Doc Set Section Element Decorator Id Used for Type 2 versioning
START_GROUP_TYPE_FLAG DOUBLE N BitMask of enumerations for the type of group that is being started: 0 (10) = 0 + 0 + 0 -> none 1 (10) = 0 + 0 + 1 -> tab 2 (10) = 0 + 10 + 0 -> frame 3 (10) = 0 + 10 + 1 -> tab and frame 4 (10) = 100 + 0 + 0 -> horizontal list 5 (10) = 100 + 0 + 1 -> horizontal list and tab. 6 (10) = 100 + 10 + 0 -> horizontal list and frame 7 (10) = 100 + 10 + 1 -> horizontal list and frame and tab.
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 - ONC_DOCSET_ELEM_DECORATOR


Child Column in ONC_DOCSET_ELEM_DECORATOR(FK) Parent Table Name Parent Column Name
Parents: DOC_SET_ELEMENT_ID DOC_SET_ELEMENT_REF DOC_SET_ELEMENT_ID
PREV_DOCSET_ELEM_DECORATOR_ID ONC_DOCSET_ELEM_DECORATOR ONC_DOCSET_ELEM_DECORATOR_ID




Parent Column in ONC_DOCSET_ELEM_DECORATOR (PK) Child Table Name Child Column Name
Children: ONC_DOCSET_ELEM_DECORATOR_ID ONC_DOCSET_ELEM_DECORATOR PREV_DOCSET_ELEM_DECORATOR_ID


ONC_FORM_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Oncology Forms Activity
Definition: Stores activity data for oncology forms
Table Type: ACTIVITY





Column Detail - ONC_FORM_ACTIVITY


Column Name Type Null? Definition
DOC_SET_REF_ID DOUBLE N Identifier for the doc set that contains the reference data for the form
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
EVENT_ID DOUBLE N An EVENT_ID value from the CLINICAL_EVENT table
FORM_ACTIVITY_ID DOUBLE N Identifier for a Onc_Form_Activity group. Identifies a logical Onc_Form_Activity row. There may be more than one row with the same Form_Activity_Id, but only one of those rows will be current as indicated by the Valid_Until_Dt_Tm field. THIS VALUE IS OBTAINED FROM A SEQUENCE AND WILL NOT EQUAL ANY PRIMARY KEY VALUE IN THE TABLE.
FORM_STATUS_CD DOUBLE N Status of the results on the form
ONC_DOCSETREF_CAT_ID DOUBLE N Foreign Key value from the ONC_DOCSETREF_CAT table
ONC_FORM_ACTIVITY_ID DOUBLE N This is the value of the unique primary identifier of the Onc_Form_Activity table. It is an internal system assigned number.
ONSET_DT_TM DATETIME Y The date and time selected for the onset of the problem. This field will be NULL if the onset date is documented along with the problem.
ONSET_PRECISION_CD DOUBLE Y Indicates to what precision the onset_dt_tm has been set.
ONSET_PRECISION_FLAG DOUBLE Y indicates to what level of accuracy the onset_dt_tm has been set.
PERFORMED_PRSNL_ID DOUBLE N Personnel id of provider who charted this form instance
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PRE_RECURRENCE_FORM_ACT_ID DOUBLE N The form_activity_id of the form that this entry is a recurrence of.
PROBLEM_ID DOUBLE N Identifier for the problem being related
RECURRENCE_DT_TM DATETIME Y Date of recurrence for cancer documented by the form
RECURRENCE_PRECISION_CD DOUBLE Y Indicates to what precision the recurrence_dt_tm has been set.
RECURRENCE_PRECISION_FLAG DOUBLE Y Indicates to what level of accuracy the recurrence_dt_tm has been set.
TEXTUAL_RENDITION_EVENT_ID DOUBLE N The event_id of the clinical note generated from the form data. (from CLINICAL_EVENT table)
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.
VALID_FROM_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
VALID_UNTIL_DT_TM DATETIME Y 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.
VERSION_DT_TM DATETIME Y Date and time of the doc set reference that was documented. Used to pinpoint the correct version of the doc set that was used to document the results.



Relationship Detail - ONC_FORM_ACTIVITY


Child Column in ONC_FORM_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: DOC_SET_REF_ID DOC_SET_REF DOC_SET_REF_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
ONC_DOCSETREF_CAT_ID ONC_DOCSETREF_CAT ONC_DOCSETREF_CAT_ID
PERSON_ID PERSON PERSON_ID
PROBLEM_ID PROBLEM PROBLEM_INSTANCE_ID


ONC_FS_VIEW



Column Section Relationship Section Top of Page


Table-level Detail

Description: Oncology Flowsheet View
Definition: This table contains views for the Oncology Flowsheet.
Table Type: REFERENCE





Column Detail - ONC_FS_VIEW


Column Name Type Null? Definition
COLLATION_SEQ DOUBLE N Collation sequence used for ordering Oncology Flowsheet Views
IN_USE_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.
ONC_FS_VIEW_EVENT_SET_NAME VARCHAR(100) Y Name of Event Set to be used in the Oncology Flowsheet View
ONC_FS_VIEW_ID DOUBLE N Primary key for Oncology Flowsheet Views
ONC_FS_VIEW_NAME VARCHAR(100) N Name of Oncology Flowsheet View
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 - ONC_FS_VIEW




Parent Column in ONC_FS_VIEW (PK) Child Table Name Child Column Name
Children: ONC_FS_VIEW_ID ONC_FS_VIEW_RX_SET_RELTN ONC_FS_VIEW_ID


ONC_FS_VIEW_RX_SET_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Oncology Flowsheet View Prescription Relation
Definition: Table relates Oncology Prescription Sets to Oncology Flowsheet Views
Table Type: REFERENCE





Column Detail - ONC_FS_VIEW_RX_SET_RELTN


Column Name Type Null? Definition
COLLATION_SEQ DOUBLE N Collation sequence used for ordering Prescription Sets
ONC_FS_VIEW_ID DOUBLE N Foreign Key to Oncology Flowsheet View Table
ONC_FS_VIEW_RX_SET_RELTN_ID DOUBLE N Primary Key for Oncology Flowsheet View Relation record.
ONC_RX_SET_ID DOUBLE N Foreign Key to Oncology Flowsheet Prescription Set 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 - ONC_FS_VIEW_RX_SET_RELTN


Child Column in ONC_FS_VIEW_RX_SET_RELTN(FK) Parent Table Name Parent Column Name
Parents: ONC_FS_VIEW_ID ONC_FS_VIEW ONC_FS_VIEW_ID
ONC_RX_SET_ID ONC_RX_SET ONC_RX_SET_ID


ONC_II_AUTO_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: ONCOLOGY INFUSION INJECTION AUTOMATION ACTIVITY
Definition: Stores the oncology infusion injection automation activity
Table Type: ACTIVITY





Column Detail - ONC_II_AUTO_ACTIVITY


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ADMIN_ROUTE_TYPE_TXT VARCHAR(100) Y A short display string to indicate the type of the rpoute selected for the event.
ENCNTR_ID DOUBLE N encounter for which this event is charted
EVENT_STATUS_TXT VARCHAR(100) Y A short display string to indicate the status of the event documeneted.
LOC_NURSE_UNIT_CD DOUBLE N This field is the current patient location with a location type of nurse unit.
LONG_TEXT_ID DOUBLE N Unique identifier of Long Text table.
ONC_II_AUTO_ACTIVITY_ID DOUBLE N PRIMARY KEY
ORDER_ID DOUBLE N order id for which event is charted.
PARENT_EVENT_ID DOUBLE N highest level event id from the CLINICAL_EVENT table for the documented order.
PERSON_ID DOUBLE N Person whom this event is charted.
REASON_SHORT_DESC LONGTEXT Y Medication disqualify reason.
START_DT_TM DATETIME Y Date and time of the event charted.
STOP_DT_TM DATETIME Y Event enddDate and time of the medication administration.
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 - ONC_II_AUTO_ACTIVITY


Child Column in ONC_II_AUTO_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
ORDER_ID ORDERS ORDER_ID
PERSON_ID PERSON PERSON_ID