AMANDA Folder Milestone
Category	Development
Feature Dataset Name	Stand-Alone
Item Name	AMANDA_FOLDER_MILESTONE
Database Type
Originator
Bureau	Bureau of Development Services
Publication Date
Abstract	Derived from the AMANDA database, key milestones associated with a folder process. Data includes attempt results like approved, check sheet and not required
Purpose	Derived from the AMANDA database, key milestones associated with a folder process. Data includes attempt results like approved, check sheet and not required
Supplemental Information
Last Dataset Update
Last Source Update
Maintenance/Update Frequency	Daily
Extent	City of Portland
Data Type
Shape Type
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)	AMANDA,Metrics,Milestone,Process
Theme Keyword Thesaurus
Place Keyword(s)
Place Keyword Thesaurus
Access Constraints	Available for Public Use
Use Constraints
Source Dataset Type	Enterprise Geodatabase
Output Geodatabase	EGH_Web
Distribution
Contact(s) Add
Anne Stine 503 823-7300 Anne.Stine@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

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	folder_rsn	Folder RSN	Integer	4	Add	X
2	process_rsn	Process RSN	Integer	4	Add	X
3	review_iteration	Review Iteration	String	100	Add	X
3	attempt_rsn	Attempt RSN	Integer	4	Add	X
3	folder_milestone_name	Folder Milestone Name	String	100	Add	X
3	start_attempt_rsn	Start Attempt RSN	Integer	4	Add	X
4	end_attempt_rsn	End Attempt RSN	Integer	4	Add	X
5	folder_type	Folder Type	String	4	Add	X
6	review_team	Review Team	String	50	Add	X
6	milestone_type	Milestone Type	String	50	Add	X
7	review_round	Review Round	Integer	4	Add	X
8	milestone_name	Milestone Name	String	100	Add	X
9	milestone_status	Milestone Status	String	100	Add	X
10	milestone_sort	Milestone Sort	Integer	4	Add	X
11	milestone_start_name	Start Name	String	100	Add	X
11	folder_milestone_sort	Folder Milestone Sort	Integer	4	Add	X
12	milestone_start_date	Start Date	Date	8	Add	X
13	milestone_end_name	End Name	String	100	Add	X
14	milestone_end_date	End Date	Date	8	Add	X
15	milestone_elapsed_days	Elapsed Days	Integer	4	Add	X
16	elapsed_days_from_under_review	Elapsed Days from Under Review	Integer	4	Add	X
16	elapsed_days_from_und_rev	Elapsed Days from Under Review	Integer	4	Add	X
17	milestone_goal_time	Goal Time	Integer	4	Add	X
18	milestone_overdue_days	Overdue Days	Integer	4	Add	X
19	milestone_overdue_status	Overdue Status	String	50	Add	X
20	milestone_result	Milestone Result	String	50	Add	X
21	gis_process_status	GIS Process Status	String	100	Add	X
22	life_cycle_image_url	Life Cycle Image	String	255	Add	X
22	responsibility	Responsibility	String	255	Add	X
23	bureau	Bureau	String	20	Add	X
24	contact_name	Contact Name	String	255	Add	X
25	contact_email	Contact Email	String	255	Add	X
26	folder_work_type	Folder Work Type	String	255	Add	X
27	folder_in_date	Folder In Date	Date	8	Add	X
28	folder_section	Folder Section	String	255	Add	X
29	folder_status	Folder Status	String	255	Add	X
30	folder_sub_type	Folder Sub Type	String	255	Add	X
31	folder_under_review_date	Folder Under Review Date	Date	8	Add	X
32	folder_final_valuation	Folder Final Valuation	Integer	4	Add	X
33	folder_final_value_class	Folder Final Valuation Class	String	255	Add	X
34	folder_year	Folder Create Year	String	4	Add	X
35	folder_fiscal_year	Folder Fiscal Year	String	20	Add	X
36	relative_date_class	Relative Date Class	String	50	Add	X
					Add	X