Table Detail Report

REGIMEN_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Regimen Detail
Definition: Storage for regimen details
Table Type: ACTIVITY





Column Detail - REGIMEN_DETAIL


Column Name Type Null? Definition
ACTIVITY_ENTITY_ID DOUBLE N Regimen may include plans and orders. This table will then have a row for each plan and order and point to PATHWAY (pathway group nbr) and ORDERS(order_id) tables as necessary.
ACTIVITY_ENTITY_NAME VARCHAR(30) N Regimen may include plans and orders. This table will then have a row for each plan and order and point to PATHWAY and ORDERS tables as necessary.
CYCLE_NBR DOUBLE N Cycle of treatment number
REFERENCE_ENTITY_ID DOUBLE N Regimen may include plans and orders. This table will then have a row for each plan and order and point to PATHWAY_CATALOG and ORDER_CATALOG_SYNONYM tables as necessary.
REFERENCE_ENTITY_NAME VARCHAR(30) N Regimen may include plans and orders. This table will then have a row for each plan and order and point to PATHWAY_CATALOG and ORDER_CATALOG_SYNONYM tables as necessary.
REGIMEN_CAT_DETAIL_ID DOUBLE N sequence name: reference_seq Unique identifier for the REGIMEN_CAT_DETAIL table.
REGIMEN_DETAIL_ID DOUBLE N sequence name: CareNet_seq Unique identifier for the REGIMEN _DETAIL table.
REGIMEN_DETAIL_SEQUENCE DOUBLE N Regimen detail sequence
REGIMEN_DETAIL_STATUS_CD DOUBLE N DETAIL STATUS
REGIMEN_ID DOUBLE N sequence name: CareNet_seq Unique identifier for the REGIMEN table.
START_DT_TM DATETIME Y Estimated REGIMEN start date time
START_TZ DOUBLE Y START TIME ZONE
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 - REGIMEN_DETAIL


Child Column in REGIMEN_DETAIL(FK) Parent Table Name Parent Column Name
Parents: REGIMEN_ID REGIMEN REGIMEN_ID
REGIMEN_CAT_DETAIL_ID REGIMEN_CAT_DETAIL REGIMEN_CAT_DETAIL_ID




Parent Column in REGIMEN_DETAIL (PK) Child Table Name Child Column Name
Children: REGIMEN_DETAIL_ID REGIMEN_DETAIL_ACTION REGIMEN_DETAIL_ID
REGIMEN_DETAIL_R REGIMEN_DETAIL_S_ID
REGIMEN_DETAIL_R REGIMEN_DETAIL_T_ID
REGIMEN_DOCUMENTATION REGIMEN_DETAIL_ID


REGIMEN_DETAIL_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Regimen Detail Action
Definition: Storage for actions taken on regimen detail row
Table Type: ACTIVITY





Column Detail - REGIMEN_DETAIL_ACTION


Column Name Type Null? Definition
ACTION_DT_TM DATETIME N Indicates the date and time the action was taken on the regimen detail
ACTION_PRSNL_ID DOUBLE N Indicates the person who took the action on the regimen detail
ACTION_REASON_CD DOUBLE N Indicates the codified action reason on the regimen detail
ACTION_TYPE_CD DOUBLE N Indicates the type of action taken on the regimen detail
ACTION_TZ DOUBLE N Action time zone
LONG_TEXT_ID DOUBLE N Indicates the action comment on the regimen detail. Pointer to the long text table entry.
REGIMEN_DETAIL_ACTION_ID DOUBLE N sequence name: CareNet_seq Unique identifier for the REGIMEN_DETAIL_ACTION table.
REGIMEN_DETAIL_ID DOUBLE N sequence name: CareNet_seq Unique identifier for the REGIMEN_DETAIL table.
REGIMEN_ID DOUBLE N sequence name: CareNet_seq Unique identifier for the REGIMEN 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 - REGIMEN_DETAIL_ACTION


Child Column in REGIMEN_DETAIL_ACTION(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
ACTION_PRSNL_ID PRSNL PERSON_ID
REGIMEN_ID REGIMEN REGIMEN_ID
REGIMEN_DETAIL_ID REGIMEN_DETAIL REGIMEN_DETAIL_ID


REGIMEN_DETAIL_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Regimen Detail Relation
Definition: Storage for offsets between regimen details
Table Type: ACTIVITY





Column Detail - REGIMEN_DETAIL_R


Column Name Type Null? Definition
OFFSET_UNIT_CD DOUBLE N Identifies the offset unit (days, weeks, months).
OFFSET_VALUE DOUBLE N Offset quantity used to define a time offset for the relationship
REGIMEN_DETAIL_R_ID DOUBLE N sequence name: reference_seq Unique identifier for the REGIMEN_DETAIL_R table.
REGIMEN_DETAIL_S_ID DOUBLE N This is the value of the unique primary identifier on the REGIMEN_ DETAIL table. It is an internal system assigned number.
REGIMEN_DETAIL_T_ID DOUBLE N This is the value of the unique primary identifier on the REGIMEN_ DETAIL table. It is an internal system assigned number.
REGIMEN_ID DOUBLE N FK FROM REGIMEN TABLE
TYPE_MEAN VARCHAR(12) N Identifies the type of relationship.
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 - REGIMEN_DETAIL_R


Child Column in REGIMEN_DETAIL_R(FK) Parent Table Name Parent Column Name
Parents: REGIMEN_ID REGIMEN REGIMEN_ID
REGIMEN_DETAIL_S_ID REGIMEN_DETAIL REGIMEN_DETAIL_ID
REGIMEN_DETAIL_T_ID REGIMEN_DETAIL REGIMEN_DETAIL_ID


REGIMEN_DOCUMENTATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: REGIMEN DOCUMENTATION
Definition: Holds responses at the regimen or regimen detail level.
Table Type: ACTIVITY





Column Detail - REGIMEN_DOCUMENTATION


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.
CHART_DT_TM DATETIME N Date & time the regimen response was charted
CHART_PRSNL_ID DOUBLE N unique identifier of the person who documented the response
CHART_TZ DOUBLE N Time zone associated with the corresponding dt_tm column.
LONG_TEXT_ID DOUBLE N Free text Patient's response to treatment or regimen comment
REGIMEN_DETAIL_ID DOUBLE N sequence name: CareNet_seq Unique identifier for the REGIMEN _DETAIL table.
REGIMEN_DOCUMENTATION_ID DOUBLE N sequence name: CareNet_seq Unique identifier for the REGIMEN _DOCUMENTATION table.
REGIMEN_ID DOUBLE N sequence name: CareNet_seq Unique identifier for the REGIMEN table.
RESPONSE_CD DOUBLE N Codified Patient's response to treatment
TYPE_FLAG DOUBLE N Indicates a type of documentation. 1-Patient's response to treatment 2-Regimen comment
UNCHART_DT_TM DATETIME Y Date & time the regimen response was uncharted
UNCHART_PRSNL_ID DOUBLE N unique identifier of the person who removed the documented response
UNCHART_TZ DOUBLE N Time zone associated with the corresponding dt_tm column.
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 - REGIMEN_DOCUMENTATION


Child Column in REGIMEN_DOCUMENTATION(FK) Parent Table Name Parent Column Name
Parents: REGIMEN_ID REGIMEN REGIMEN_ID
REGIMEN_DETAIL_ID REGIMEN_DETAIL REGIMEN_DETAIL_ID