[[admin:tables_fields:regimen]]

Regimen

Back to the table list

Contains the list of regimens for which data will be captured and that will be displayed in regimen records

Field name Description Type Ind
id Primary key. Unique ID for the regimen Longint *
description The regimen's description (the text that will appear anywhere the regimen needs to be displayed) Alpha
order The order in which the record should be displayed in lists: 1=first, 2=second etc. Int
type The type of the regimen: 1=adult, 2=paediatric Int *

regimen_record

Contains the details of individual regimen records

Field name Description Type Ind
id Primary key. Unique id for each regimen record Longint *
name_id Foreign key to [name]id. The id of the customer to which this regimen record belongs Longint
store_id Foreign key to [store]id. The id of the store to which this record belongs Longint
created_by Foreign key to [user]id. The id of the user who created this record Longint
date_created The date this record was created Date
date_entered The date this record was entered for. Used when reporting to determine which reporting period this record belongs to Date
comment Any comment that goes with the regimen record Text

regimen_line

Contains the details of all lines belonging to different regimen records

Field name Description Type Ind
id Primary key. Unique id for each regimen line Long *
regimen_record_id Foreign key to [regimen_record]id. The id of the regimen that this regimen line belongs to Long
regimen_id Foreign key to [regimen]id. The regimen this line represents Long
num_patients_on_treatment The number of patients on the regimen in [regimen_line]regimen_id Long
num_patients_to_be_initiated The number of patients to be initiated onto the regimen in [regimen_line]regimen_id Long
num_num_patients_stopped The number of patients who stopped/defaulted or died on the regimen in [regimen_line]regimen_id Long
comment Any remarks that go with the line Alpha
  • Last modified: 2016/11/30 08:47
  • by Mark Glover