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 |