Data_Dictionary_Sites.xlsx

	A	B	C	D
1	RecordType	FieldName	Type	Description

2	LOCATION	State	VARCHAR	Property location - State
3	LOCATION	County	VARCHAR	Property location - County
4	LOCATION	City	VARCHAR	Property location - City
5	LOCATION	Site_Address	VARCHAR	Address of property
6	DEVELOPMENT INFORMATION	Sector	VARCHAR	Residential \| Commercial
7	DEVELOPMENT INFORMATION	Construction_Type	VARCHAR	New \| Renovation OR Remodel
8	DEVELOPMENT INFORMATION	Project_Count	VARCHAR	Number of projects at the property
9	DEVELOPMENT INFORMATION	Project_Type	VARCHAR	Type of projects are the property
10	DEVELOPMENT INFORMATION	Project_Status	VARCHAR	Planning \| in-Progress \| Complete
11	DEVELOPMENT INFORMATION	Status_Date	DATE	Date status was updated
12	DEVELOPMENT INFORMATION	Project_Cost_est	VARCHAR	Estimated cost of all projects
13	CONTACTS	Contact_1_Name	VARCHAR	Primary contact name
14	CONTACTS	Contact_1_Company	VARCHAR	Primary contact's company name
15	CONTACTS	Contact_1_Address	VARCHAR	Primary contact's address
16	CONTACTS	Contact_1_Phone	VARCHAR	Primary contact's phone
17	CONTACTS	Contact_1_Email	VARCHAR	Primary contact's email
18	CONTACTS	Contact_2_Name	VARCHAR	Secondary contact name
19	CONTACTS	Contact_2_Company	VARCHAR	Secondary contact's company name
20	CONTACTS	Contact_2_Address	VARCHAR	Secondary contact's address
21	CONTACTS	Contact_2_Phone	VARCHAR	Secondary contact's phone
22	CONTACTS	Contact_2_Email	VARCHAR	Secondary contact's email
23	CONTACTS	Contact_3_Name	VARCHAR	Alternative contact name
24	CONTACTS	Contact_3_Email	VARCHAR	Alternative contact's email
25	CONTACTS	Contact_3_Info	VARCHAR	Alternative contact's details
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100