Drug_register

Back to list of main tables

Field number	Field Name	Description	Type	Length	Index
7	application_date	The date of application	Date
8	application_number	A unique number assigned to track the application	Long Integer
9	approval_date	The date the application was approved (blank if never approved)	Date
17	category1_ID	ID of the category record related to this record	Alpha
18	category2_ID	ID of the category2 record related to this record	Alpha
19	category3	Free-form text field for another category of the user's choice	Text
20	category4	Free-form text field for another category of the user's choice	Text
16	comment	User-entered free text	Text
13	created_by	The ID of the user who created the record	Alpha
1	ID	The unique ID of the record	Alpha	Y
15	is_currently_registered	True if currently registered (automatically turned off by mSupply on registration expiry)	Boolean
2	Item_ID	The ID of the item associated with this record	Long Integer	Y
4	Manufacturer_ID	The ID of the Manufacturer associated with this record	Long Integer	Y
11	modified_date	The date the record was last modified	Date
12	modified_time	The time the record was last modified	Time
6	pack_size	The pack sizes for this item	Text
10	registration_expiry_date	The date the registration expires	Date
14	registration_number	The unique number (or code) given to the registration	Text	Y
3	Supplier_ID	The ID of the Supplier associated with this record	Long Integer	Y
5	trade_name	The name the item is being registered under	Alpha	Y

drug_register_category1

Field number	Field Name	Description	Type	Length	Index
2	Description	The category name	Alpha
1	ID	The unique ID of the category	Alpha	Y

drug_register_category2

Field number	Field Name	Description	Type	Length	Index
2	Description	The category name	Alpha
1	ID	The unique ID of the category	Alpha	Y