Table Detail Report

ONC_INFUSION_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: ONCOLOGY INFUSION ACTIVITY
Definition: Stores the oncology infusion activity
Table Type: ACTIVITY





Column Detail - ONC_INFUSION_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.
ADMIN_ROUTE_TYPE_TXT VARCHAR(100) N A short display string to indicate the type of the route selected for the event
ENCNTR_ID DOUBLE N encounter for which this event is charted
EVENT_STATUS_TXT VARCHAR(20) N A short display string to indicate the status of the event documented.
ONC_INFUSION_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.
SERVICE_DT_TM DATETIME Y Date and time of the event charted.
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_INFUSION_ACTIVITY


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


ONC_MTUITIVE_WORKSHEET



Column Section Relationship Section Top of Page


Table-level Detail

Description: ONCOLOGY MTUITIVE WORKSHEET
Definition: Contains the oncology mTuitive worksheet data
Table Type: ACTIVITY





Column Detail - ONC_MTUITIVE_WORKSHEET


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.
ANSWER_CONCEPT_CKI VARCHAR(256) Y Answer Concept CKI of the MTuitive question;
ANSWER_DATATYPE VARCHAR(256) Y QUESTION DATATYPE. FOR EG. STRING, DECIMAL
ANSWER_SHORT_STRING VARCHAR(256) Y Short string of the answer, to match with the millenium Nomenclatures
ANSWER_TEXT VARCHAR(1280) N Full string Answer TEXT
ANSWER_TYPE_TXT VARCHAR(256) Y ANSWER TYPE. For Eg. LIST, FREETEXT 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.
DTA_CONCEPT_CKI VARCHAR(256) Y The concept_cki from Discrete_Task_assay table.
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.
NOMENCLATURE_ID DOUBLE Y The nomenclature_id from nomenclature table
ONC_MTUITIVE_WORKSHEET_ID DOUBLE N PRIMARY KEY
QUESTION_CONCEPT_CKI VARCHAR(256) Y Question Concept CKI of the mTuitive question
QUESTION_DATATYPE VARCHAR(256) N QUESTION DATATYPE. FOR EG. STRING, DECIMAL
QUESTION_MULTI_IND DOUBLE Y IF LIST, QUESTION MULTISELECT INDICATOR. NULL = FREETEXT, MULTI =TRUE and SINGLE = FALSE;
QUESTION_TEXT VARCHAR(256) N mTuitive Question text;
QUESTION_TYPE_TXT VARCHAR(256) N REPORT QUESTION TYPE. For Eg. LIST, FREETEXT Etc.
REPORT_NAME_KEY VARCHAR(256) N mTuitive Report name in CAPs, without special characters;
REPORT_NAME_STRING VARCHAR(256) N mTuitive Report name along with special characters;
REPORT_VERSION_TXT VARCHAR(256) N mTuitive Report Version
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_MTUITIVE_WORKSHEET


Child Column in ONC_MTUITIVE_WORKSHEET(FK) Parent Table Name Parent Column Name
Parents: NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID


ONC_NOMEN_DOCSETREF_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Nomenclature Doc Set Ref Relationship
Definition: Stores the relationship between a Nomenclature and a Doc_Set_Ref for Oncology
Table Type: REFERENCE





Column Detail - ONC_NOMEN_DOCSETREF_R


Column Name Type Null? Definition
DOC_SET_REF_ID DOUBLE N Identifier for the Doc_Set_Ref item being related
NOMENCLATURE_ID DOUBLE N Identifier for the nomenclature item being related
ONC_NOMEN_DOCSETREF_R_ID DOUBLE N Primary Key. an internal system assigned number.
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_NOMEN_DOCSETREF_R


Child Column in ONC_NOMEN_DOCSETREF_R(FK) Parent Table Name Parent Column Name
Parents: DOC_SET_REF_ID DOC_SET_REF DOC_SET_REF_ID
NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID


ONC_NOMEN_TERM_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: ONCOLOGY NOMENCLATURE TERM RELATION
Definition: Stores the oncology nomenclature and anatomy pathology term association information
Table Type: REFERENCE





Column Detail - ONC_NOMEN_TERM_RELTN


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.
CKI_IDENTIFIER VARCHAR(50) Y concept identifier
CKI_SOURCE VARCHAR(12) Y Concept source code
NOMENCLATURE_ID DOUBLE N Primary key from NOMECLATURE table. In this case used to identify the nomenlature associated with scr_term.
ONC_NOMEN_TERM_RELTN_ID DOUBLE N PRIMARY KEY
ONC_TASK_SENT_RELTN_ID DOUBLE N Primary key from ONC_TASK_SENT_RELTN table,in this case used get nomenclature and term association information from ONC_TASK_SENT_RELTN.
SCR_SENTENCE_ID DOUBLE N Foreign key from SCR_SENTENCE table, in this case used to identify the worksheet sentence by SCR_SENTENCE_ID
SCR_TERM_DISPLAY VARCHAR(40) Y A short display string for the term display
SCR_TERM_HIER_ID DOUBLE N Primary key from SCR_TER_HIER table, in this case used to identify the scr_term_id by scr_term_hier_id
SCR_TERM_ID DOUBLE N Primary Key frorm SCR_TERM table, in this case used to identify the term by scr_term_id.
SHORT_STRING VARCHAR(40) Y A short description of the source string from NOMENCLATURE table.
SOURCE_STRING VARCHAR(256) Y The SOURCE_STRING from NOMECLATURE, in this case used to identify source string of the the nomenclature defined.
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_NOMEN_TERM_RELTN


Child Column in ONC_NOMEN_TERM_RELTN(FK) Parent Table Name Parent Column Name
Parents: NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
ONC_TASK_SENT_RELTN_ID ONC_TASK_SENT_RELTN ONC_TASK_SENT_RELTN_ID
SCR_SENTENCE_ID SCR_SENTENCE SCR_SENTENCE_ID
SCR_TERM_ID SCR_TERM SCR_TERM_ID
SCR_TERM_HIER_ID SCR_TERM_HIER SCR_TERM_HIER_ID


ONC_RX_SET



Column Section Relationship Section Top of Page


Table-level Detail

Description: Oncology Prescription Set
Definition: Stores Oncology Prescription Sets
Table Type: REFERENCE





Column Detail - ONC_RX_SET


Column Name Type Null? Definition
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_RX_SET_ID DOUBLE N Primary Key for Prescription Set Record
ONC_RX_SET_NAME VARCHAR(100) N Unique Name of Prescription Set
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_RX_SET




Parent Column in ONC_RX_SET (PK) Child Table Name Child Column Name
Children: ONC_RX_SET_ID ONC_FS_VIEW_RX_SET_RELTN ONC_RX_SET_ID