Steven's COBie Rules

	A	B	C	D	E	F	G	H	I	J	K	L	N
1	Feel free to ask questions, explanations, or just tell me where I am wrong using the Comments function (ctrl+alt+m)
2	My journey to understanding COBie part 1: where to start - BIM+ (bimplus.co.uk)
3	My journey to understanding COBie part 2: what data needs to be prioritised - BIM+ (bimplus.co.uk)
4	My journey to understanding COBie part 3: further information on the type sheet - BIM+ (bimplus.co.uk)
5	My journey to understanding COBie part 4: filling in the blanks - BIM+ (bimplus.co.uk)
6	My journey to understanding COBie part 5: enlightenment - BIM+ (bimplus.co.uk)
7
8	Refer to NBIMS 4.2 for the original field descriptions. My content requirements are a mix of what NBIMS specifies and anything extra we have specified to make something specific
9
10	Also refer NBIMS Annex A for exact table format requirements. I've not quite used the correct terminology here and again mixed the requirements by NBIMS and the additional requirements we have specified
11
12	Sheet	Column	Column Number	Type	Functionality Requirement - Must be 100% correct or the database does not work	Format Requirement	Content Requirements/Guidance	Stage Required Facility Information	Stage Required Capital Plant	Stage Required Equipment	Stage Required Fixtures	Stage Required Openings	Column Types

13	Contact	Email	1	Primary	Must be Unique on Sheet.	Must be an email address	Contact email of company. Shall be unique for whole project.	3	n/a	n/a	n/a	n/a	Primary
14	Contact	CreatedBy	2	Foreign	Must be on Contact.Email	N/A Foreign Key	Contact email of company creating or updating data. Referenced from Contact.Email.	3	n/a	n/a	n/a	n/a	Foreign
15	Contact	CreatedOn	3	Free		yyyy-mm-dd	ISO 8601 format - Timestamp optional.	3	n/a	n/a	n/a	n/a	Pick
16	Contact	Category	4	Pick		Formated Ro_nn_nn_nn: Then a text string	Category of business, Code followed by Title from Roles Uniclass table (Ro).	3	n/a	n/a	n/a	n/a	Free
17	Contact	Company	5	Free		Text String	Trading Name of Company.	3	n/a	n/a	n/a	n/a
18	Contact	Phone	6	Free		Is a phone number	Contact telephone number of company including international dialling code. Important for warranty information, obsolete for designers.	3	n/a	n/a	n/a	n/a
19	Contact	ExtSystem	7	Free			[application generated]	3	n/a	n/a	n/a	n/a
20	Contact	ExtObject	8	Free			[application generated]	3	n/a	n/a	n/a	n/a
21	Contact	ExtIdentifier	9	Free			[application generated]	3	n/a	n/a	n/a	n/a
22	Contact	Department	10	Free		Text String	Content Not Required	X	n/a	n/a	n/a	n/a
23	Contact	OrganizationCode	11	Free		Text String	Company code specified by client. Not required for manufacturer/warranty guarantor.	3	n/a	n/a	n/a	n/a
24	Contact	GivenName	12	Free		Text String	Content Not Required	X	n/a	n/a	n/a	n/a
25	Contact	FamilyName	13	Free		Text String	Content Not Required	X	n/a	n/a	n/a	n/a
26	Contact	Street	14	Free		Text String	Address of company including all information excluding Town, Postal Code & Country.	3	n/a	n/a	n/a	n/a
27	Contact	PostalBox	15	Free		Text String	Content Not Required	X	n/a	n/a	n/a	n/a
28	Contact	Town	16	Free		Text String	Town of company.	3	n/a	n/a	n/a	n/a
29	Contact	StateRegion	17	Free		Text String	Content Not Required	X	n/a	n/a	n/a	n/a
30	Contact	PostalCode	18	Free		Text String	Postcode of company.	3	n/a	n/a	n/a	n/a
31	Contact	Country	19	Free		3 Letters	Officially assigned ISO 3166-1 alpha-3 code for country of company.	3	n/a	n/a	n/a	n/a
32	Facility	Name	1	Primary	Must be Unique on Sheet.	Text String	Facility number specified by client. Number appears on design documentation	3	n/a	n/a	n/a	n/a
33	Facility	CreatedBy	2	Foreign	Must be on Contact.Email	N/A Foreign Key	Contact email of company creating or updating data. Referenced from Contact.Email.	3	n/a	n/a	n/a	n/a
34	Facility	CreatedOn	3	Free		yyyy-mm-dd	ISO 8601 format - Timestamp optional.	3	n/a	n/a	n/a	n/a
35	Facility	Category	4	Pick		Formated EN_nn_nn_nn: Then a text string	Category of building specified by client, Code followed by Title from Entities Uniclass table (En).	3	n/a	n/a	n/a	n/a
36	Facility	ProjectName	5	Free		Text String	Project number specified by client. Number appears on design documentation.	3	n/a	n/a	n/a	n/a
37	Facility	SiteName	6	Free		Text String	Site number specified by client. Number appears on design documentation.	3	n/a	n/a	n/a	n/a
38	Facility	LinearUnits	7	Pick		Text String	Use Millimeters.	3	n/a	n/a	n/a	n/a
39	Facility	AreaUnits	8	Pick		Text String	Use Square Meter.	3	n/a	n/a	n/a	n/a
40	Facility	VolumeUnits	9	Pick		Text String	Use Cubic Meter.	3	n/a	n/a	n/a	n/a
41	Facility	CurrencyUnit	10	Pick		Text String	Use Euros.	3	n/a	n/a	n/a	n/a
42	Facility	AreaMeasurement	11	Free		Text String	Use International Property Measurement Standards: Industrial Buildings	3	n/a	n/a	n/a	n/a
43	Facility	ExternalSystem	12	Free			[application generated]	3	n/a	n/a	n/a	n/a
44	Facility	ExternalProjectObject	13	Free			[application generated]	3	n/a	n/a	n/a	n/a
45	Facility	ExternalProjectIdentifier	14	Free			[application generated]	3	n/a	n/a	n/a	n/a
46	Facility	ExternalSiteObject	15	Free			[application generated]	3	n/a	n/a	n/a	n/a
47	Facility	ExternalSiteIdentifier	16	Free			[application generated]	3	n/a	n/a	n/a	n/a
48	Facility	ExternalFacilityObject	17	Free			[application generated]	3	n/a	n/a	n/a	n/a
49	Facility	ExternalFacilityIdentifier	18	Free			[application generated]	3	n/a	n/a	n/a	n/a
50	Facility	Description	19	Free		Text String	Facility name specified by client. Name appears on design documentation	3	n/a	n/a	n/a	n/a
51	Facility	ProjectDescription	20	Free		Text String	Project name specified by client. Name appears on design documentation	3	n/a	n/a	n/a	n/a
52	Facility	SiteDescription	21	Free		Text String	Site name specified by client. Name appears on design documentation	3	n/a	n/a	n/a	n/a
53	Facility	Phase	22	Free		Text String	Plan of Work from BS8536-1.	3	n/a	n/a	n/a	n/a
54	Facility	WeightUnits	23	Free		Text String	Use kilograms.	3	n/a	n/a	n/a	n/a
55	Floor	Name	1	Primary	Must be Unique on Sheet.	Text String	Name defined in BEP.	3	n/a	n/a	n/a	n/a
56	Floor	CreatedBy	2	Foreign	Must be on Contact.Email	N/A Foreign Key	Contact email of company creating or updating data. Referenced from Contact.Email.	3	n/a	n/a	n/a	n/a
57	Floor	CreatedOn	3	Free		yyyy-mm-dd	ISO 8601 format - Timestamp optional.	3	n/a	n/a	n/a	n/a
58	Floor	Category	4	Pick		Level type picked from Foundation, Floor, Roof, Site.	Level type picked from Foundation, Floor, Roof, Site.	3	n/a	n/a	n/a	n/a
59	Floor	ExtSystem	5	Free			[application generated]	3	n/a	n/a	n/a	n/a
60	Floor	ExtObject	6	Free			[application generated]	3	n/a	n/a	n/a	n/a
61	Floor	ExtIdentifier	7	Free			[application generated]	3	n/a	n/a	n/a	n/a
62	Floor	Description	8	Free		Text String	Description defined in BEP corresponding to Name.	3	n/a	n/a	n/a	n/a
63	Floor	Elevation	9	Free		Number	Structural Level elevation to datum specified by client.	3	n/a	n/a	n/a	n/a
64	Floor	Height	10	Free		Number	Distance between top of floor structure to bottom of structure above.	3	n/a	n/a	n/a	n/a
65	Floor	GIA	11	Free		Number	Total gross internal area of level calculated by project standard.	3	n/a	n/a	n/a	n/a
66	Space	Name	1	Primary	Must be Unique on Sheet.	Text String	Client standard defined Room Number. Shall match number on design documentation	3	n/a	n/a	n/a	n/a
67	Space	CreatedBy	2	Foreign	Must be on Contact.Email	N/A Foreign Key	Contact email of company creating or updating data. Referenced from Contact.Email.	3	n/a	n/a	n/a	n/a
68	Space	CreatedOn	3	Free		yyyy-mm-dd	ISO 8601 format - Timestamp optional.	3	n/a	n/a	n/a	n/a
69	Space	Category	4	Pick		Formated SL_nn_nn_nn: Then a text string	Category of space/room, Code followed by Title from Spaces/ locations Uniclass table (SL)	3	n/a	n/a	n/a	n/a
70	Space	FloorName	5	Foreign	Must be on Floor.Name	N/A Foreign Key	Reference Floor tab	3	n/a	n/a	n/a	n/a
71	Space	Description	6	Free			Client standard defined Room Name. Shall match name on design documentation	3	n/a	n/a	n/a	n/a
72	Space	ExtSystem	7	Free			[application generated]	3	n/a	n/a	n/a	n/a
73	Space	ExtObject	8	Free			[application generated]	3	n/a	n/a	n/a	n/a
74	Space	ExtIdentifier	9	Free			[application generated]	3	n/a	n/a	n/a	n/a
75	Space	RoomTag	10	Free		Text String	To match signage. Note some room signage won't include room name	3	n/a	n/a	n/a	n/a
76	Space	UsableHeight	11	Free		Number	Distance from top of finished floor(FFL) to underside of ceiling(UCL).	3	n/a	n/a	n/a	n/a
77	Space	GrossArea	12	Free		Number	Content Not Required	X	n/a	n/a	n/a	n/a
78	Space	NetArea	13	Free		Number	Useable space area calculated by Facility.AreaMeasurement	3	n/a	n/a	n/a	n/a
79	Space	FinishFloorHeight	16	Free		Number	Height of the flooring (from base slab without flooring to the flooring height).	3	n/a	n/a	n/a	n/a
80	Zone	Name	1	Primary	Must be Unique on Sheet.	Text String	Client standard defined Volume. Shall match volume on design documentation.	3	n/a	n/a	n/a	n/a
81	Zone	CreatedBy	2	Foreign	Must be on Contact.Email	N/A Foreign Key	Contact email of company creating or updating data. Referenced from Contact.Email.	3	n/a	n/a	n/a	n/a
82	Zone	CreatedOn	3	Free		yyyy-mm-dd	ISO 8601 format - Timestamp optional.	3	n/a	n/a	n/a	n/a
83	Zone	Category	4	Pick		Text String	Client standard defined Volume Code.	3	n/a	n/a	n/a	n/a
84	Zone	SpaceNames	5	Foreign	Must be on Space.Name, Comma delimited	N/A Foreign Key	Delimited list of all spaces within Zone.	3	n/a	n/a	n/a	n/a
85	Zone	ExtSystem	6	Free			[application generated]	3	n/a	n/a	n/a	n/a
86	Zone	ExtObject	7	Free			[application generated]	3	n/a	n/a	n/a	n/a
87	Zone	ExtIdentifier	8	Free			[application generated]	3	n/a	n/a	n/a	n/a
88	Zone	Description	9	Free		Text String	Client standard defined Volume Description.	3	n/a	n/a	n/a	n/a
89	Zone	GEA	10	Free		Number	Total gross external area calculated by project standard.	3	n/a	n/a	n/a	n/a
90	Type	Name	1	Primary	Must be Unique on Sheet.	Text String	As BS 8541 Object naming. [Source]_[Type]_[SubType/Product]_[Further(optional)] Initial Caps to be used. No spaces allowed in name. Ratings/sizes range shall be separated by a hyphen. Underscore only to be used to separate fields. Source is the organisation responsible for modelling the element. Type is the category type, e.g. ElectricalEquipment, LightingFixture. SubType/Product is the type of product e.g. Generator, Pendant. Further is to be used capture manufacturer, ratings, sizes, model, etc if required.	n/a	3	4	4	3
91	Type	CreatedBy	2	Foreign	Must be on Contact.Email	N/A Foreign Key	Contact email of company creating or updating data. Referenced from Contact.Email.	n/a	3	4	4	3
92	Type	CreatedOn	3	Free		yyyy-mm-dd	ISO 8601 format - Timestamp optional.	n/a	3	4	4	3
93	Type	Category	4	Pick		Formated Pr_nn_nn_nn_nn: Then a text string	Category of type, Code followed by Title from Products Uniclass table (Pr).	n/a	3	4	4	3
94	Type	Description	5	Free		Text String	Client standard defined Description. Shall match description on design documentation.	n/a	3	4	4	3
95	Type	AssetType	6	Pick		Picked from "Fixed" or "Moveable"	Picked from Fixed, Moveable. Note Moveable means it can be relocated (e.g. a MEWP), not if it has moving parts (e.g. a door).	n/a	3	4	4	3
96	Type	Manufacturer	7	Foreign	Must be on Contact.Email	N/A Foreign Key	Reference Contact.Email of manufacturer.	n/a	3	4	5	4
97	Type	ModelNumber	8	Free		Text String	Manufacturer’s model number.	n/a	3	4	5	4
98	Type	WarrantyGuarantorParts	9	Foreign	Must be on Contact.Email	N/A Foreign Key	Reference Contact.Email of parties responsible for parts during warranty period for replacement parts.	n/a	5	5	5	5
99	Type	WarrantyDurationParts	10	Free		Number	Length of warranty for parts.	n/a	5	5	5	5
100	Type	WarrantyGuarantorLabor	11	Foreign	Must be on Contact.Email	N/A Foreign Key	Reference Contact.Email of parties responsible for labour costs during warranty period for replacement parts.	n/a	5	5	5	5