Metadata: AMANDA Folder Detail

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
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
Add

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