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 |