REGIMEN



Column Section Relationship Section Top of Page


Table-level Detail

Description: REGIMEN
Definition: Storage for regimens patient is on.
Table Type: ACTIVITY





Column Detail - REGIMEN


Column Name Type Null? Definition
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. it is an internal system assigned number.
END_DT_TM DATETIME Y The regimen end date time
END_TZ DOUBLE Y TIME ZONE FOR THE END TIME
ORDERED_AS_NAME VARCHAR(100) N Regimen synonym name used when the regimen was added
ORDER_DT_TM DATETIME Y date and time the regimen was ordered
ORDER_TZ DOUBLE Y THE TIME ZONE FOR THE ORDER DATE/TIME
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. it is an internal system assigned number.
REGIMEN_CATALOG_ID DOUBLE N sequence name: reference_seq Unique identifier for the REGIMEN_CATALOG table. Each change or revision made to a regimen creates a new regimen instance.
REGIMEN_DESCRIPTION VARCHAR(1000) N Regimen Name key of the field Regimen Name. This field has all capital letters and punctuation removed. It is used for indexing and searching for a regimen catalog.
REGIMEN_ID DOUBLE N sequence name: CareNet_seq Unique identifier for the REGIMEN table.
REGIMEN_NAME VARCHAR(100) N REGIMEN_NAME refers to the display name for the regimen.
REGIMEN_STATUS_CD DOUBLE N Regimen Status
REQUESTED_START_DT_TM DATETIME Y Estimated Regimen start date and time.
REQUESTED_START_TZ DOUBLE Y TIME ZONE FOR THE REQUESTED START DATE/TIME
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


Child Column in REGIMEN(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
REGIMEN_CATALOG_ID REGIMEN_CATALOG REGIMEN_CATALOG_ID




Parent Column in REGIMEN (PK) Child Table Name Child Column Name
Children: REGIMEN_ID PRECOMPONENT_ORDER_RELTN REGIMEN_ID
REGIMEN_ACTION REGIMEN_ID
REGIMEN_ATTRIBUTE REGIMEN_ID
REGIMEN_DETAIL REGIMEN_ID
REGIMEN_DETAIL_ACTION REGIMEN_ID
REGIMEN_DETAIL_R REGIMEN_ID
REGIMEN_DOCUMENTATION REGIMEN_ID
UKR_SACT REGIMEN_ID


REGIMEN_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Regimen Action
Definition: Storage for actions taken on regimens
Table Type: ACTIVITY





Column Detail - REGIMEN_ACTION


Column Name Type Null? Definition
ACTION_DT_TM DATETIME N Indicates the date and time the action was taken on the regimen
ACTION_PRSNL_ID DOUBLE N Indicates the person who took the action on the regimen
ACTION_TYPE_CD DOUBLE N Indicates the type of action taken on the regimen
ACTION_TZ DOUBLE N TIME ZONE FOR THE ACTION DATE TIME
DISCONTINUE_REASON_CD DOUBLE N Indicates the codified reason for the discontinue action taken on the regimen
LONG_TEXT_ID DOUBLE N Contains the free text reason for the action taken on the regimen
REGIMEN_ACTION_ID DOUBLE N sequence name: CareNet_seq Unique identifier for the REGIMEN_ACTION 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_ACTION


Child Column in REGIMEN_ACTION(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
REGIMEN_ID REGIMEN REGIMEN_ID


REGIMEN_ATTRIBUTE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Regimen Attribute
Definition: Storage for attributes captured for a regimen
Table Type: ACTIVITY





Column Detail - REGIMEN_ATTRIBUTE


Column Name Type Null? Definition
ATTRIBUTE_DISPLAY VARCHAR(100) N ATTRIBUTE_DISPLAY refers to the display name for the attribute.
ATTRIBUTE_DISPLAY_FLAG DOUBLE N Display mode for the attribute on the regimen 0 = Unknown 1 = Display Only 2 = Optional 3 = Required
ATTRIBUTE_MEAN VARCHAR(12) N ATTRIBUTE_MEAN refers to the display meaning for the attribute. RESEARCHPROT, TREATMENTINT, THERAPYLINE
CODE_SET DOUBLE N Holds the pre defined responses for attribute.
INPUT_TYPE_FLAG DOUBLE N Indicates the input type for the attribute. 1-Yes/No 2-Codeset
REGIMEN_ATTRIBUTE_ID DOUBLE N sequence name: CareNet_seq Unique identifier for the REGIMEN_ATTRIBUTE table.
REGIMEN_CAT_ATTRIBUTE_R_ID DOUBLE N FK FROM REGIMEN_CAT_ATTRIBUTE_R
REGIMEN_ID DOUBLE N sequence name: CareNet_seq Unique identifier for the REGIMEN table.
SEQUENCE DOUBLE N REGIMEN ATTRIBUTE SEQUENCE
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.
VALUE_ID DOUBLE N indicates value from table (code value field) or application specific value (0 - No selection/1 - Yes/2 - No) identified in value_name (CODE_VALUE or BOOLEAN).
VALUE_NAME VARCHAR(30) Y VALUE_NAME - Indicates whether the value in value_id column refers to an actual entity in the database (i.e. CODE_VALUE) or an application-specific value (i.e. BOOLEAN).



Relationship Detail - REGIMEN_ATTRIBUTE


Child Column in REGIMEN_ATTRIBUTE(FK) Parent Table Name Parent Column Name
Parents: REGIMEN_ID REGIMEN REGIMEN_ID
REGIMEN_CAT_ATTRIBUTE_R_ID REGIMEN_CAT_ATTRIBUTE_R REGIMEN_CAT_ATTRIBUTE_R_ID


REGIMEN_CATALOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Regimen Catalog
Definition: Main table defining each regimen stored in the database. The table will hold high-level attributes such as display name and description.
Table Type: REFERENCE





Column Detail - REGIMEN_CATALOG


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.
ADD_PLAN_IND DOUBLE N ADD PLAN INDICATOR
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.
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.
EXTEND_TREATMENT_IND DOUBLE N Indicates the ability to extend treatment of a regimen
GROUP_REGIMEN_CATALOG_ID DOUBLE N sequence name: reference_seq Uniquely defines a regimen within the REGIMEN_CATALOG table. The REGIMEN_CATALOG_GROUP_ID can be associated with multiple regimen instances. When a new regimen is added to the REGIMEN_CATALOG table the REGIMEN_CATALOG_GROUP_ID is assigned to the REGIMEN_CATALOG_ ID
REGIMEN_CATALOG_ID DOUBLE N sequence name: reference_seq Unique identifier for the REGIMEN_CATALOG table. Each change or revision made to a regimen creates a new regimen instance.
REGIMEN_DESCRIPTION VARCHAR(1000) N REGIMEN_DESCRIPTION is a longer and more descriptive version of the regimen name summarizing the treatment encapsulated by the regimen.
REGIMEN_NAME VARCHAR(100) N REGIMEN_NAME refers to the display name for the regimen.
REGIMEN_NAME_KEY VARCHAR(100) N Regimen Name key of the field Regimen Name. This field has all capital letters and punctuation removed. It is used for indexing and searching for a regimen catalog.
REGIMEN_NAME_KEY_A_NLS VARCHAR(400) Y REGIMEN NAME KEY VALUE WHEN National Language Support is required for Boolean operations.
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_CATALOG


Child Column in REGIMEN_CATALOG(FK) Parent Table Name Parent Column Name
Parents: GROUP_REGIMEN_CATALOG_ID REGIMEN_CATALOG REGIMEN_CATALOG_ID




Parent Column in REGIMEN_CATALOG (PK) Child Table Name Child Column Name
Children: REGIMEN_CATALOG_ID REGIMEN REGIMEN_CATALOG_ID
REGIMEN_CATALOG GROUP_REGIMEN_CATALOG_ID
REGIMEN_CAT_ATTRIBUTE_R REGIMEN_CATALOG_ID
REGIMEN_CAT_DETAIL REGIMEN_CATALOG_ID
REGIMEN_CAT_DETAIL_R REGIMEN_CATALOG_ID
REGIMEN_CAT_FACILITY_R REGIMEN_CATALOG_ID
REGIMEN_CAT_SYNONYM REGIMEN_CATALOG_ID


REGIMEN_CAT_ATTRIBUTE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Regimen Catalog Attributes
Definition: Storage for regimen attribute list. This table holds pre-defined set of attributes and display properties for those attributes.
Table Type: REFERENCE





Column Detail - REGIMEN_CAT_ATTRIBUTE


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.
ATTRIBUTE_DISPLAY VARCHAR(100) N ATTRIBUTE_DISPLAY refers to the display name for the attribute.
ATTRIBUTE_MEAN VARCHAR(12) Y ATTRIBUTE_MEAN refers to the display meaning for the attribute. RESEARCHPROT, TREATMENTINT, THERAPYLINE
CODE_SET DOUBLE N Holds the pre defined responses for attribute.
INPUT_TYPE_FLAG DOUBLE N Indicates the input type for the attribute. 1-Yes/No 2-Codeset
REGIMEN_CAT_ATTRIBUTE_ID DOUBLE N sequence name: reference_seq Unique identifier for the REGIMEN_CAT_ATTRIBUTE 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_CAT_ATTRIBUTE


Child Column in REGIMEN_CAT_ATTRIBUTE(FK) Parent Table Name Parent Column Name
Parents: CODE_SET CODE_VALUE_SET CODE_SET




Parent Column in REGIMEN_CAT_ATTRIBUTE (PK) Child Table Name Child Column Name
Children: REGIMEN_CAT_ATTRIBUTE_ID REGIMEN_CAT_ATTRIBUTE_R REGIMEN_CAT_ATTRIBUTE_ID