Table Schema: mf

This topic describes the columns in the mf_incidents table.

Column Name: The name of the column.
Data Type: The data type of the column.
Primary Key: The value is 1 if the column is part of the primary key; 0 if not.
Is Nullable: The value is 1 if the column can have a NULL value; 0 if not.
Column ID: The ID number of the column.
Comment: Text describing the column data (if available).
Reference Count: The number of other columns that have a foreign key pointing to this column. Only tables that exist in the reporting database are considered.
Reference To: The parent table and column (if there is an upward constraint). Only tables that exist in the reporting database are considered.

Column Name	Data Type	Primary Key	Is Nullable	Column ID	Comment	Reference Count	Reference To
incident_guid	uniqueidentifier	1	0	1		1
company_guid	uniqueidentifier	0	0	2		0
catalog_guid	uniqueidentifier	0	1	3	Catalog-F-mf_catalogs	0	mf_catalogs.catalog_guid
customer_guid	uniqueidentifier	0	1	4		0	mf_customers.customer_guid
user_guid	uniqueidentifier	0	1	5		0
incident_code_guid	uniqueidentifier	0	1	6		0
incident_result_guid	uniqueidentifier	0	1	7		0
provider_instance_guid	uniqueidentifier	0	1	8		0
incident_id	varchar (50)	0	1	9		0
incident_date	datetime	0	0	10	Order date	0
incident_followup_date	datetime	0	1	11		0
incident_due_date	datetime	0	1	12		0
incident_label	varchar (50)	0	0	13		0
incident_label_short	varchar (50)	0	1	14		0
incident_description	varchar (max)	0	1	15		0
incident_resolution	varchar (max)	0	1	16		0
incident_contact	varchar (80)	0	1	17	Attention	0
incident_phone	varchar (25)	0	1	18	Phone	0
incident_email	varchar (80)	0	1	19	Email	0
incident_age	smallint	0	1	20		0
incident_provider_error	tinyint	0	0	21		0
incident_provider_status	varchar (255)	0	1	22		0
incident_flag	tinyint	0	0	23	Used by UI as a way to assign records to different colored flags.-F-mf_flags	0
incident_alert	tinyint	0	0	24	Status flag- Indicates whether the order is alerted	0
incident_visible	tinyint	0	0	25	Status flag- Indicates whether the order is visible	0
incident_new	tinyint	0	0	26	Status flag- Indicates whether the order is new	0
incident_approved	tinyint	0	0	27	Work Flow flag- Indicates whether the order is approved	0
incident_suspended	tinyint	0	0	28	Status flag- Indicates whether the order is suspended	0
incident_locked	tinyint	0	0	29	Status flag- Indicates whether the order is locked	0
incident_closed	tinyint	0	0	30	Work Flow flag- Indicates whether the order is closed	0
incident_filed	tinyint	0	0	31	Work Flow flag- Indicates whether the order is filed	0
lu_dt	datetime	0	0	32		0
cr_dt	datetime	0	0	33		0
lu_guid	uniqueidentifier	0	1	34		0
cr_guid	uniqueidentifier	0	1	35		0

Return to index of tables

Table Schema: mf_incidents