ONC_ADHOC_PHASE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Ad Hoc Oncology Treatment Phase
Definition: Activity data identifying chemotherapy treatment times for an oncology patient.
Table Type: ACTIVITY





Column Detail - ONC_ADHOC_PHASE


Column Name Type Null? Definition
END_DT_TM DATETIME Y End date for the phase
ONC_ADHOC_PHASE_ID DOUBLE N Primary key
ONC_ADHOC_PLAN_ID DOUBLE N Id of the ad hoc plan to which the phase belongs
PHASE_NAME VARCHAR(100) N Caption for phase name
START_DT_TM DATETIME Y Start date for the phase
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_ADHOC_PHASE


Child Column in ONC_ADHOC_PHASE(FK) Parent Table Name Parent Column Name
Parents: ONC_ADHOC_PLAN_ID ONC_ADHOC_PLAN ONC_ADHOC_PLAN_ID


ONC_ADHOC_PLAN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Ad Hoc Oncology Treatment Plan
Definition: Activity data identifying chemotherapy treatment times for an oncology patient.
Table Type: ACTIVITY





Column Detail - ONC_ADHOC_PLAN


Column Name Type Null? Definition
END_DT_TM DATETIME Y End date for the plan
ONC_ADHOC_PLAN_ID DOUBLE N Primary key
PERSON_ID DOUBLE N Person to whom the plan is associated
PLAN_NAME VARCHAR(100) N Caption for the plan
START_DT_TM DATETIME Y Start date for the plan
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_ADHOC_PLAN


Child Column in ONC_ADHOC_PLAN(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID




Parent Column in ONC_ADHOC_PLAN (PK) Child Table Name Child Column Name
Children: ONC_ADHOC_PLAN_ID ONC_ADHOC_PHASE ONC_ADHOC_PLAN_ID


ONC_CHEMO_VERIFY



Column Section Relationship Section Top of Page


Table-level Detail

Description: CHEMOTHERAPY DOSING VERIFICATION STATUS
Definition: Stores the chemotherapy dosing initiated plan verification status and action information.
Table Type: ACTIVITY





Column Detail - ONC_CHEMO_VERIFY


Column Name Type Null? Definition
ACTION_DT_TM DATETIME Y To store the verified action date and time .
ACTION_PRSNL_ID DOUBLE N Person_id of the person from personnel table(prsnl) that caused the last action in the table.
ACTION_TYPE_CD DOUBLE N Primary key of CODE_VALUE table for code_set 1305. To store the status code for the specific action.
ACTION_TYPE_DESC VARCHAR(256) Y To store the verification action status information.
ACTIVE_IND DOUBLE Y 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.
COMMENT_TXT VARCHAR(256) Y To store the user comments, while withdrawing the verify action;
LONG_TEXT_ID DOUBLE N Primary key from LONG_TEXT table,in this case used to get order information in xml format from LONG_TEXT .
ONC_CHEMO_VERIFY_ID DOUBLE N Primary key of the ONC_CHEMO_VERIFY table
PLAN_ID DOUBLE N Foreign key for Pathway Table, in this case used for plan information from PW_GROUP_NBR .
POSITION_FREE_TEXT VARCHAR(256) Y To store the free text name of position type.
POSITION_ROLE_CD DOUBLE N Primary key of CODE_VALUE table for code_set 88. It is used to store the position code for the person.
POSITION_ROLE_TYPE_ID DOUBLE N ** OBSOLETE ** this field is not used. it has been replaced, functionally, by column POSITION_ROLE_CD.
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.
VERIFICATION_GROUP DOUBLE Y To store the verification group number for initial verifications and subsequent re-vertifications;



Relationship Detail - ONC_CHEMO_VERIFY


Child Column in ONC_CHEMO_VERIFY(FK) Parent Table Name Parent Column Name
Parents: POSITION_ROLE_CD CODE_VALUE CODE_VALUE
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
ACTION_PRSNL_ID PRSNL PERSON_ID


ONC_DOCSETREF_CAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Oncology DocsetRef Category
Definition: Stores categories for Doc Set Ref values
Table Type: REFERENCE





Column Detail - ONC_DOCSETREF_CAT


Column Name Type Null? Definition
CATEGORY_DISPLAY VARCHAR(40) N Category Display Name
CATEGORY_DISPLAY_KEY VARCHAR(40) N Defines the Key to the category display name
IN_USE_IND DOUBLE N used to filter out onc_docsetref_cat records that are no longer being unused.
ONC_DOCSETREF_CAT_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.
VALID_FROM_DT_TM DATETIME N The date and time for which this category becomes effective. This is not the time that the row was created.
VALID_UNTIL_DT_TM DATETIME N The date and time after which the category is no longer valid. This is not the time that the row will become inactive.



Relationship Detail - ONC_DOCSETREF_CAT




Parent Column in ONC_DOCSETREF_CAT (PK) Child Table Name Child Column Name
Children: ONC_DOCSETREF_CAT_ID ONC_DOCSETREF_CAT_R ONC_DOCSETREF_CAT_ID
ONC_FORM_ACTIVITY ONC_DOCSETREF_CAT_ID


ONC_DOCSETREF_CAT_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Oncology DocSetRef Category Relationship
Definition: Stores the relationship between the doc_set_ref table and the ONC_DOCSETREF_CAT table.
Table Type: REFERENCE





Column Detail - ONC_DOCSETREF_CAT_R


Column Name Type Null? Definition
DOC_SET_REF_ID DOUBLE N Foreign Key to the DOC_SET_REF table
ONC_DOCSETREF_CAT_ID DOUBLE N Foreign Key the ONC_DOCSETREF_CAT table
ONC_DOCSETREF_CAT_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_DOCSETREF_CAT_R


Child Column in ONC_DOCSETREF_CAT_R(FK) Parent Table Name Parent Column Name
Parents: DOC_SET_REF_ID DOC_SET_REF DOC_SET_REF_ID
ONC_DOCSETREF_CAT_ID ONC_DOCSETREF_CAT ONC_DOCSETREF_CAT_ID