Negotiator

Fields:

Field	Type	Comments
Referencing
NegotiatorID	int(11)
OfficeID	int(11)
AlternativeOfficeID	int(11)
Data
Initials	varchar(255)
Name	varchar(255)
JobTitle	varchar(255)
Department	int(11)	Equivalent to property register
FineHomes	tinyint(1)
NewHomes	tinyint(1)
FSConsultant	tinyint(1)
Notes	longtext
Telephone	varchar	Negotiators direct line or extention
email	varchar(50)
Username	varchar(50)
Password	varchar(50)
AnyOfficeInRegion	tinyint(1)
AnyOfficeInGroup	tinyint(1)
GroupAdministrator	tinyint(1)
AdvancedUser	tinyint(1)
Privileges1	int(11)
Privileges2	int(11)
GenesisLevel	int(11)
System
Closed	tinyint(1)
CreationOffice	int(11)
CreationUser	int(11)
CreationDate	datetime
ModificationOffice	int(11)
ModificationUser	int(11)
ModificationDate	datetime