AMANDA Folder Detail
Category	Development
Feature Dataset Name	AMANDA_Folder_Publish
Item Name	AMANDA_Folder_Publish
Database Type	SDE
Originator	AMANDA/BDS GIS
Bureau	Bureau of Development Services
Publication Date	10/01/2020
Abstract	AMANDA folder details and processing metrics
Purpose	AMANDA folder details and processing metrics
Supplemental Information	This dataset contains only permits that could be mapped.  Some of the older permits we do not have a reliable associated parcel centroid to associate the permit with.
Last Dataset Update
Last Source Update
Maintenance/Update Frequency	Daily
Extent	City of Portland
Data Type
Shape Type	Point
Feature Count
Horizontal Position Accuracy
Horizontal Position Accuracy Link
Progress
North Bounding Coordinate
South Bounding Coordinate
East Bounding Coordinate
West Bounding Coordinate
Theme Keyword(s)	Permit,AMANDA,Folder
Theme Keyword Thesaurus	Permit,Construction
Place Keyword(s)	Portland
Place Keyword Thesaurus
Access Constraints	Available for Public Use
Use Constraints
Source Dataset Type	Enterprise Geodatabase
Output Geodatabase	EGH_Web
Distribution	Grid: State plane coordinate system 1983(91). Units: International feet Datum: North American Datum of 1983/1991 (HPGN) Liability: The information in this file was derived from digital databases on the City of Portland GIS. Care was taken in the creation of this file. The City cannot accept any responsibility for errors, omissions, or positional accuracy. There are no warranties, expressed or implied. Format: Shapefile or File Geodatabase Feature Class - Data will be provided via City of Portland FTP Site. Online Resource: http://portlandmaps.com/opendata Online Instructions: City of Portland Public/Open Data is distributed via the PortlandMaps Open Data Site - http://portlandmaps.com/opendata. Data not available on the PortlandMaps Open Data site can be requested by contacting the City of Portland CGIS Group - maps@portlandoregon.gov Transfer Size: varies SPCS Zone Identifier: 5076
Contact(s) Add
Jake Brown 503 823-5295 Jake.Brown@portlandoregon.gov 1900 SW 4th Ave, Suite 5000 Portland, OR 97201 City of Portland - BDS 503-823-7300 503-823-6868 BDS@portlandoregon.gov
File(s) Add Add File File Description Cancel Add File
Lineage Add

Web Services

Service	Description	Feature Access	Layer
BDS_Permit_Dashboard	BDS Permit Dashboard contains AMANDA folder and process data that is updated nightly	Dynamic	Construction Project Status

Attribute Tables & Domains

X
Table Description
Table Jurisdiction
Column Sort	Column Name	Column Alias	Column Type	Column Size	Domain Value(s)	Column Description Add
1	Shape	Shape	Geometry	8	Add	X map point in web mercator aux sphere
2	folder_rsn	Folder RSN	Integer	4	Add	X folder record sequence number from AMANDA.   Also known as IVR number
3	property_rsn	Property RSN	Integer	4	Add	X property record sequence number from AMANDA
4	eplans_project_id	ePlans Project ID	Integer	4	Add	X
5	intake_folder_rsn	Intake Folder RSN	Integer	4	Add	X
6	intake_folder_status	Intake Folder Status	String	255	Add	X
7	intake_request_submitted	Intake Request Submitted Date	Date	8	Add	X
8	intake_review_approved	Intake Review Approved Date	Date	8	Add	X
9	intake_category_of_const	Intake Category of Construction	String	255	Add	X
10	intake_request_type	Intake Request Type	String	255	Add	X
11	intake_type_of_work	Intake Type of Work	String	255	Add	X
12	intake_link_to_permit	Intake Link to Permit	Date	8	Add	X
13	intake_work_valuation	Intake Work Valuation	Integer	4	Add	X
14	dev_hub_status	Dev HUB Status	String	255	Add	X
15	folder_name	Folder Name	String	255	Add	X folder name; combines folder type, sequence, section revision and year
16	folder_type	Folder Type	String	40	Add	X 2-4 character abbreviation permit type (ex. CO = commercial, etc)
17	folder_number	Folder Number	String	25	Add	X
18	folder_section	Folder Section	String	3	Add	X
19	folder_revision	Folder Revision	String	3	Add	X
19	intake_complete_date	Intake Complete Date	Date	8	Add	X
20	status	Status	String	40	Add	X
21	description	Description	String	4000	Add	X
22	work_type	Work Type	String	100	Add	X
23	sub_type	Sub Type	String	100	Add	X
23	finaled_date	Finaled Date	Date	8	Add	X no updates made after permit reaches finaled date
24	reference_file	Reference File	String	255	Add	X
25	in_date	In Date	Date	8	Add	X
26	under_review_date	Under Review Complete Date	Date	8	Add	X Date permit first entered Under Review status.<br>To enter Under Review status, a permit must complete Application phase and be accepted by review staff as complete.<br>In most cases, the applicant must pay review fees to advance the permit from Application to Under Review.<br>This date is used for vesting in current codes and fees, and to calculate goal first review dates.
27	pre_issuance_date	Pre Issuance Date	Date	8	Add	X
27	pre_issuance_start_date	Pre Issuance Start Date	Date	8	Add	X
28	pre_issuance_complete_date	Pre Issuance Complete Date	Date	8	Add	X
29	approved_to_issue_date	Approved to Issued Date	Date	8	Add	X
30	issued_date	Issued Date	Date	8	Add	X
31	under_inspection_date	Under Inspection Date	Date	8	Add	X
32	final_date	Final Date	Date	8	Add	X
33	expiry_date	Expiry Date	Date	8	Add	X
34	property_address	Property Address	String	60	Add	X
35	property_r_number	Property R Number	String	9	Add	X also called property_id.&nbsp; This is set by the county
36	property_alt_r_number	Property Alternate R Number	String	15	Add	X
37	property_state_id	Property State ID	String	40	Add	X Primary Property State ID
38	property_city	Property City	String	40	Add	X
39	property_county	Property County	String	40	Add	X
40	property_neighborhood	Property Neighborhood	String	255	Add	X
41	property_neighborhood_police	Property Neighborhood (Police)	String	255	Add	X No neighborhood overlap
42	property_neighborhood_coalition	Property Neighborhood Coalition	String	255	Add	X
43	property_business_association	Property Business Association	String	255	Add	X
43	mando_first_rev_overdue_status	Mandatory First Review Overdue	String	255	Add	X
44	building_submitted_valuation	Building Submitted Valuation	Integer	4	Add	X Project valuation&nbsp;<i>for the scope of work of the subject permit only</i>,&nbsp;provided by the applicant.<br>Reviewed by building plans examiner for accuracy.<br>Not necessarily used for fee calculation or other purposes unless submitted valuation is accepted by building plans examiner to be equal to the Building Final Valuation.<br>See Building Final Valuation.
44	mandatory_first_review_complete	Mandatory First Review Complete	String	40	Add	X
45	process_first_review_avg_days	Process First Review Average Days	Integer	4	Add	X
45	building_final_valuation	Building Final Valuation	Integer	4	Add	X Project valuation&nbsp;<i>for the scope of work of the subject permit only</i>, calculated, reviewed and approved by building plans examiner.<br>This value is set at the time when the building plans examiner review for the subject permit is complete, and is not subsequently updated, revised or adjusted.<br>Calculated value&nbsp;for New Construction and Additions typically follows ICC tables for new square footage by occupancy, adjusted for West Coast construction costs.<br>For&nbsp;Alterations, calculated valuations often range&nbsp;between 25% and 60% of New Construction square footage.<br>ICC valuation tables used by BDS are updated annually.<br>The Building Final Valuation approved by the building plans examiner is used for fee calculation.
46	building_final_value_class	Building Final Valuation Class	String	255	Add	X
47	building_new_unit_count	Building New Unit Count	Integer	4	Add	X
48	intake_complete_year	Intake Complete Year	String	4	Add	X
48	building_removed_unit_count	Building Removed Unit Count	Integer	4	Add	X
49	building_net_unit_count	Building Net Unit Count	Integer	4	Add	X
49	intake_complete_year_month	Intake Complete Year Month	String	30	Add	X format for sorting:&nbsp; year-month number-month text
50	intake_within_one_year	Intake Within One Year	String	5	Add	X intake complete date +365 days - today
50	building_story_count	Building Story Count	Integer	4	Add	X
51	timeline_exception_reason	Timeline Exception Reason	String	50	Add	X
52	review_type	Review Type	String	40	Add	X Over the Counter or Standard Review&nbsp;
53	intake_folder_days	Intake Folder Days	Integer	4	Add	X
54	first_review_complete_date	First Review Complete Date	Date	8	Add	X
55	first_rev_overdue_status	First Review Overdue	String	255	Add	X
56	first_review_complete	First Review Complete	String	40	Add	X
57	first_review_avg_days	First Review Average Days	Integer	4	Add	X
58	create_year	Create Year	String	4	Add	X folder create year
59	create_year_month	Create Year Month	String	30	Add	X format for sorting:&nbsp; year-month number-month text
60	create_fiscal_year	Create Fiscal Year	String	20	Add	X
61	relative_date_class	Relative Date Class	String	50	Add	X
62	under_review_year	Under Review Year	String	4	Add	X
63	under_review_year_month	Under Review Year Month	String	30	Add	X
64	under_review_within_one_year	Under Review Within One Year	String	5	Add	X
65	app_to_und_rev_days	App to Under Review Days	Integer	4	Add	X
66	und_rev_to_pre_iss_days	Under Review to Pre Issuance Days	Integer	4	Add	X
67	pre_issuance_days	Pre Issuance Days	Integer	4	Add	X
68	pre_issue_to_ati_days	Pre Issue to Appr to Issue Days	Integer	4	Add	X
69	app_to_ati_days	Application to Appr to Issue Days	Integer	4	Add	X
70	app_to_issue_days	Application to Issue Days	Integer	4	Add	X
71	approved_to_issue_days	Approved to Issue Days	Integer	4	Add	X elapsed days from intake complete to approved to issue
72	approved_to_issue_days_class	Approved to Issue Days Class	String	20	Add	X elapsed days from intake complete to approved to issue broken into 4 classes<br><ul><li>Under Review</li><li>0-20 days</li><li>21-45 days</li><li>46+ days</li></ul>
73	tot_city_busy_to_ati_days	Total Days City Processed Permit	Integer	4	Add	X waiting days calculated by corrections received date - corrections processed
74	tot_cust_busy_to_ati_days	Total Days Customer Processed Permit	Integer	4	Add	X waiting days calculated by window open date (first review complete) - corrections received
75	days_since_intake	Bus. Days Since Intake	Integer	4	Add	X
76	days_since_setup	Bus. Days Since Setup	Integer	4	Add	X
77	days_since_und_rev	Bus. Days Since Under Review	Integer	4	Add	X
78	days_since_first_rev_done	Bus. Days Since First Review	Integer	4	Add	X
79	days_since_pre_issue_start	Bus. Days Since Pre-Issuance Start	Integer	4	Add	X
80	days_since_pre_issue_done	Bus. Days Since Pre-Issuance Complete	Integer	4	Add	X
81	days_since_ati	Bus. Days Since Approved To Issue	Integer	4	Add	X
82	days_since_issue	Bus. Days Since Issue	Integer	4	Add	X
83	checksheet_count	Checksheet Count	Integer	4	Add	X
84	corrections_received_count	Corrections Received Count	Integer	4	Add	X number of corrections received processes that are associated with folder
85	reviewer_overdue_status	Reviewer Overdue Status	String	255	Add	X if any of the reviewer groups have taken longer than 5 days to review corrections received
86	review_window_status	Review Window Status	String	255	Add	X
86	gis_portland_maps_url	PortlandMaps URL	String	100	Add	X link to folder details in PortlandMaps
87	review_window_publish_text	Review Window Publish Text	String	255	Add	X
88	under_inspection_days	Under Inspection Days	Integer	4	Add	X
89	inspection_site_visit_count	Inspection Site Visit Count	Integer	4	Add	X
90	inspection_window_publish_text	Inspection Window Publish Text	String	255	Add	X
91	building_occupancy_group_1	Building Occupancy Group 1	String	255	Add	X manually input in folder info&nbsp;
92	building_construction_type_1	Building Construction Type 1	String	255	Add	X manually input&nbsp;in&nbsp;folder info&nbsp;
93	building_total_sq_ft_1	Building Total Sq Ft 1	Integer	4	Add	X manually input&nbsp;in&nbsp;folder info&nbsp;
94	building_occupancy_group_2	Building Occupancy Group 2	String	255	Add	X manually input&nbsp;in&nbsp;folder info&nbsp;
95	building_construction_type_2	Building Construction Type 2	String	255	Add	X manually input&nbsp;in&nbsp;folder info&nbsp;
96	building_total_sq_ft_2	Building Total Sq Ft 2	Integer	4	Add	X manually input&nbsp;in&nbsp;folder info&nbsp;
97	building_occupancy_group_3	Building Occupancy Group 3	String	255	Add	X manually input&nbsp;in&nbsp;folder info&nbsp;
98	building_construction_type_3	Building Construction Type 3	String	255	Add	X manually input&nbsp;in&nbsp;folder info&nbsp;
98	chksht_assign_address_rev	Assign Address Tot. Checksheet #	Integer	4	Add	X
99	status_assign_address_rev	Assign Address Status	String	255	Add	X
99	building_total_sq_ft_3	Building Total Sq Ft 3	Integer	4	Add	X manually input&nbsp;in&nbsp;folder info&nbsp;
100	building_occupancy_group_4	Building Occupancy Group 4	String	255	Add	X manually input&nbsp;in&nbsp;folder info&nbsp;
100	chksht_com_plumb_rev	Commercial Plumbing Review Tot. Checksheet #	Integer	4	Add	X
101	status_com_plumb_rev	Commercial Plumbing Review Status	String	255	Add	X
101	building_construction_type_4	Building Construction Type 4	String	255	Add	X manually input&nbsp;in&nbsp;folder info&nbsp;
102	building_total_sq_ft_4	Building Total Sq Ft 4	Integer	4	Add	X manually input&nbsp;in&nbsp;folder info&nbsp;
102	chksht_demo_release_rev	Demo Release Review Tot. Checksheet #	Integer	4	Add	X
103	status_demo_release_rev	Demo Release Review Status	String	255	Add	X
103	aff_housing_unit_count	Affordable Housing Unit Count	Integer	4	Add	X 10/1/2020 this data is not currently available - we are hoping to add it
104	aff_housing_exempt_type_1	Affordable Housing Exempt Type 1	String	255	Add	X manually input&nbsp;in&nbsp;folder info&nbsp;
104	chksht_energy_code_rev	Energy Code Review Tot. Checksheet #	Integer	4	Add	X
105	status_energy_code_rev	Energy Code Review Status	String	255	Add	X
105	aff_housing_exempt_sqft_1	Affordable Housing Exempt Sq Ft 1	String	255	Add	X manually input&nbsp;in&nbsp;folder info&nbsp;
106	aff_housing_exempt_type_2	Affordable Housing Exempt Type 2	String	255	Add	X manually input&nbsp;in&nbsp;folder info&nbsp;
106	chksht_erosion_ctrl_plan_rev	Erosion Control Plan Review Tot. Checksheet #	Integer	4	Add	X
107	status_erosion_ctrl_plan_rev	Erosion Control Plan Review Status	String	255	Add	X
107	aff_housing_exempt_sqft_2	Affordable Housing Exempt Sq Ft 2	String	255	Add	X manually input&nbsp;in&nbsp;folder info&nbsp;
108	aff_housing_exempt_type_3	Affordable Housing Exempt Type 3	String	255	Add	X manually input&nbsp;in&nbsp;folder info&nbsp;
108	chksht_fire_plan_rev	Fire Plan Review Tot. Checksheet #	Integer	4	Add	X
109	status_fire_plan_rev	Fire Plan Review Status	String	255	Add	X
109	aff_housing_exempt_sqft_3	Affordable Housing Exempt Sq Ft 3	String	255	Add	X manually input&nbsp;in&nbsp;folder info&nbsp;
110	aff_housing_exempt_type_4	Affordable Housing Exempt Type 4	String	255	Add	X manually input&nbsp;in&nbsp;folder info&nbsp;
110	chksht_inclus_house_rev	Inclusionary Housing Review Tot. Checksheet #	Integer	4	Add	X
111	status_inclus_house_rev	Inclusionary Housing Review Status	String	255	Add	X
111	aff_housing_exempt_sqft_4	Affordable Housing Exempt Sq Ft 4	String	255	Add	X manually input&nbsp;in&nbsp;folder info&nbsp;
112	gis_map_label	GIS Map Label	String	50	Add	X text used for map labeling
112	chksht_life_safety_rev	Life Safety Review Tot. Checksheet #	Integer	4	Add	X
112	assign_address_rev_chksht	Assign Address Tot. Checksheet #	Integer	4	Add	X
113	assign_address_rev_status	Assign Address Status	String	255	Add	X
113	status_life_safety_rev	Life Safety Review Status	String	255	Add	X
113	gis_symbol_class	GIS Symbol Class	String	50	Add	X drives map symbology in the BDS dashboard
114	gis_process_date	GIS Process Date	Date	8	Add	X last update date by GIS
114	chksht_plan_and_zone_rev	Planning and Zoning Review Tot. Checksheet #	Integer	4	Add	X
114	assign_address_rev_days	Assign Address Elapsed Days	Integer	4	Add	X
115	gis_process_status	GIS Process Status	String	100	Add	X
115	assign_address_rev_user	Assign Address Reviewer	Integer	4	Add	X
115	status_plan_and_zone_rev	Planning and Zoning Review Status	String	255	Add	X
116	chksht_process_manager	Process Manager Tot. Checksheet #	Integer	4	Add	X
116	portland_maps_url	PortlandMaps URL	String	100	Add	X
116	com_plumb_rev_chksht	Commercial Plumbing Review Tot. Checksheet #	Integer	4	Add	X
117	com_plumb_rev_status	Commercial Plumbing Review Status	String	255	Add	X
117	eplans_url	ePlans URL	String	255	Add	X
117	status_process_manager	Process Manager Status	String	255	Add	X
118	chksht_site_dev_rev	Site Development Review Tot. Checksheet #	Integer	4	Add	X
118	efiles_url	eFiles URL	String	255	Add	X
118	com_plumb_rev_days	Commercial Plumbing Review Elapsed Days	Integer	4	Add	X
119	report_date	Report Date	Date	8	Add	X
119	com_plumb_rev_user	Commercial Plumbing Reviewer	Integer	4	Add	X
119	status_site_dev_rev	Site Development Review Status	String	255	Add	X
120	chksht_structural_rev	Structural Review Tot. Checksheet #	Integer	4	Add	X
120	report_url	Report URL	String	255	Add	X
120	demo_release_rev_chksht	Demo Release Review Tot. Checksheet #	Integer	4	Add	X
121	demo_release_rev_status	Demo Release ReviewStatus	String	255	Add	X
121	life_cycle_image_url	Life Cycle Image	String	255	Add	X
121	status_structural_rev	Structural Review Status	String	255	Add	X
122	chksht_bes_env_rev	BES Environmental Review Tot. Checksheet #	Integer	4	Add	X
122	demo_release_rev_days	Demo Release Review Elapsed Days	Integer	4	Add	X
122	gantt_chart_url	Gantt Chart URL	String	255	Add	X
123	demo_release_rev_user	Demo Release Reviewer	Integer	4	Add	X
123	status_bes_env_rev	BES Environmental Review Status	String	255	Add	X
124	chksht_bes_src_ctrl_rev	BES Source Control Review Tot. Checksheet #	Integer	4	Add	X
124	energy_code_rev_chksht	Energy Code Review Tot. Checksheet #	Integer	4	Add	X
125	energy_code_rev_status	Energy Code Review Status	String	255	Add	X
125	status_bes_src_ctrl_rev	BES Source Control Review Status	String	255	Add	X
126	chksht_pbob_str_assign_rev	Trans - Street Systems Review Tot. Checksheet #	Integer	4	Add	X
126	energy_code_rev_days	Energy Code Review Elapsed Days	Integer	4	Add	X
127	energy_code_rev_user	Energy Code Reviewer	Integer	4	Add	X
127	status_pbob_str_assign_rev	Trans - Street Systems Review Status	String	255	Add	X
128	chksht_pbot_trans_sdc_rev	Transportation SDC Review Tot. Checksheet #	Integer	4	Add	X
128	erosion_ctrl_plan_rev_chksht	Erosion Control Plan Review Tot. Checksheet #	Integer	4	Add	X
129	erosion_ctrl_plan_rev_status	Erosion Control Plan Review Status	String	255	Add	X
129	status_pbot_trans_sdc_rev	Transportation SDC Review Status	String	255	Add	X
130	chksht_pbot_trans_ss_rev	Street Systems - Assign Reviews Tot. Checksheet #	Integer	4	Add	X
130	erosion_ctrl_plan_rev_days	Erosion Control Plan Review Elapsed Days	Integer	4	Add	X
131	erosion_ctrl_plan_rev_user	Erosion Control Plan Reviewer	Integer	4	Add	X
131	status_pbot_trans_ss_rev	Street Systems - Assign Reviews Status	String	255	Add	X
132	chksht_parks_sdc_rev	Parks SDC Review Tot. Checksheet #	Integer	4	Add	X
132	fire_plan_rev_chksht	Fire Plan Review Tot. Checksheet #	Integer	4	Add	X
133	fire_plan_rev_status	Fire Plan Review Status	String	255	Add	X
133	status_parks_sdc_rev	Parks SDC Review Status	String	255	Add	X
134	chksht_parks_urb_forest_rev	Urban Forestry Review Tot. Checksheet #	Integer	4	Add	X
134	fire_plan_rev_days	Fire Plan Review Elapsed Days	Integer	4	Add	X
135	fire_plan_rev_user	Fire Plan Reviewer	Integer	4	Add	X
135	status_parks_urb_forest_rev	Urban Forestry Review Status	String	255	Add	X
136	chksht_water_available_rev	Water Available Tot. Checksheet #	Integer	4	Add	X
136	inclus_house_rev_chksht	Inclusionary Housing Review Tot. Checksheet #	Integer	4	Add	X
137	inclus_house_rev_status	Inclusionary Housing ReviewStatus	String	255	Add	X
137	status_water_qual_backflow	Water Available Status	String	255	Add	X
138	chksht_water_qual_backflow	Water Quality Backflow Tot. Checksheet #	Integer	4	Add	X
138	inclus_house_rev_days	Inclusionary Housing Review Elapsed Days	Integer	4	Add	X
139	inclus_house_rev_user	Inclusionary Housing Reviewer	Integer	4	Add	X
139	status_water_available_rev	Status	String	255	Add	X
140	life_safety_rev_chksht	Life Safety Review Tot. Checksheet #	Integer	4	Add	X
141	life_safety_rev_status	Life Safety Review Status	String	255	Add	X
142	life_safety_rev_days	Life Safety Review Elapsed Days	Integer	4	Add	X
143	life_safety_rev_user	Life Safety Reviewer	Integer	4	Add	X
144	plan_and_zone_rev_chksht	Planning and Zoning Review Tot. Checksheet #	Integer	4	Add	X
145	plan_and_zone_rev_status	Planning and Zoning ReviewStatus	String	255	Add	X
146	plan_and_zone_rev_days	Planning and Zoning Review Elapsed Days	Integer	4	Add	X
147	plan_and_zone_rev_user	Planning and Zoning Reviewer	Integer	4	Add	X
148	process_manager_chksht	Process Manager Tot. Checksheet #	Integer	4	Add	X
149	process_manager_status	Process Manager Status	String	255	Add	X
150	process_manager_days	Process Manager Elapsed Days	Integer	4	Add	X
151	process_manager_user	Process Manager Reviewer	Integer	4	Add	X
152	site_dev_rev_chksht	Site Development Review Tot. Checksheet #	Integer	4	Add	X
153	site_dev_rev_status	Site Development Review Status	String	255	Add	X
154	site_dev_rev_days	Site Development Review Elapsed Days	Integer	4	Add	X
155	site_dev_rev_user	Site Development Reviewer	Integer	4	Add	X
156	structural_rev_chksht	Structural Review Tot. Checksheet #	Integer	4	Add	X
157	structural_rev_status	Structural Review Status	String	255	Add	X
158	structural_rev_days	Structural Review Elapsed Days	Integer	4	Add	X
159	structural_rev_user	Structural Reviewer	Integer	4	Add	X
160	bes_env_rev_chksht	BES Environmental Review Tot. Checksheet #	Integer	4	Add	X
161	bes_env_rev_status	BES Environmental Review Status	String	255	Add	X
162	bes_env_rev_days	BES Environmental Review Elapsed Days	Integer	4	Add	X
163	bes_env_rev_user	BES Environmental Reviewer	Integer	4	Add	X
164	bes_src_ctrl_rev_chksht	BES Source Control Review Tot. Checksheet #	Integer	4	Add	X
165	bes_src_ctrl_rev_status	BES Source Control Review Status	String	255	Add	X
166	bes_src_ctrl_rev_days	BES Source Control Review Elapsed Days	Integer	4	Add	X
167	bes_src_ctrl_rev_user	BES Source Control Review Reviewer	Integer	4	Add	X
168	pbot_str_assign_rev_chksht	Trans - Street Systems Review Tot. Checksheet #	Integer	4	Add	X
169	pbot_str_assign_rev_status	Trans - Street Systems Review Status	String	255	Add	X
170	pbot_str_assign_rev_days	Trans - Street Systems Review Elapsed Days	Integer	4	Add	X
171	pbot_str_assign_rev_user	Trans - Street Systems Reviewer	Integer	4	Add	X
172	pbot_trans_sdc_rev_chksht	Transportation SDC Review Tot. Checksheet #	Integer	4	Add	X
173	pbot_trans_sdc_rev_status	Transportation SDC Review Status	String	255	Add	X
174	pbot_trans_sdc_rev_days	Transportation SDC Review Elapsed Days	Integer	4	Add	X
175	pbot_trans_sdc_rev_user	Transportation SDC Reviewer	Integer	4	Add	X
176	pbot_trans_ss_rev_chksht	Street Systems - Assign Reviews Tot. Checksheet #	Integer	4	Add	X
177	pbot_trans_ss_rev_status	Street Systems - Assign Reviews Status	String	255	Add	X
178	pbot_trans_ss_rev_days	Street Systems - Assign Reviews Elapsed Days	Integer	4	Add	X
179	pbot_trans_ss_user	Street Systems Reviewer	Integer	4	Add	X
180	parks_sdc_rev_chksht	Parks SDC Review Tot. Checksheet #	Integer	4	Add	X
181	parks_sdc_rev_status	Parks SDC Review Status	String	255	Add	X
182	parks_sdc_rev_days	Parks SDC Review Elapsed Days	Integer	4	Add	X
183	parks_sdc_rev_user	Parks SDC Reviewer	Integer	4	Add	X
184	parks_urb_forest_rev_chksht	Urban Forestry Review Tot. Checksheet #	Integer	4	Add	X
185	parks_urb_forest_rev_status	Urban Forestry Review Status	String	255	Add	X
186	parks_urb_forest_rev_days	Urban Forestry Review Elapsed Days	Integer	4	Add	X
187	parks_urb_forest_user	Urban Forestry Reviewer	Integer	4	Add	X
188	water_available_rev_chksht	Water Available Tot. Checksheet #	Integer	4	Add	X
189	water_available_rev_status	Water Available Status	String	255	Add	X
190	water_available_rev_days	Water Available Elapsed Days	Integer	4	Add	X
191	water_available_rev_user	Water Available Reviewer	Integer	4	Add	X
192	water_qual_backflow_chksht	Water Quality Backflow Tot. Checksheet #	Integer	4	Add	X
193	water_qual_backflow_status	Water Quality Backflow Status	String	255	Add	X
194	water_qual_backflow_days	Water Quality Backflow Elapsed Days	Integer	4	Add	X
195	water_qual_backflow_user	Water Quality Backflow Reviewer	Integer	4	Add	X
206	gantt_chart_image_url	Gantt Chart Image	String	255	Add	X