Tables:

Table: CMS_Projects (13)

Name: CMS_Projects

Display Field: project_num

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• project_num ( type: esriFieldTypeString, alias: project_num, length: 7 )
• approved_budget ( type: esriFieldTypeDouble, alias: approved_budget )
• title ( type: esriFieldTypeString, alias: title, length: 75 )
• StatusFull ( type: esriFieldTypeString, alias: StatusFull, length: 12 )
• description ( type: esriFieldTypeString, alias: description, length: 511 )
• start_date ( type: esriFieldTypeDate, alias: start_date, length: 8 )
• end_date ( type: esriFieldTypeDate, alias: end_date, length: 8 )
• URL ( type: esriFieldTypeString, alias: URL, length: 42 )
• project_id ( type: esriFieldTypeBigInteger, alias: project_id )
• fy ( type: esriFieldTypeString, alias: fy, length: 2 )
• project ( type: esriFieldTypeString, alias: project, length: 4 )
• account_no ( type: esriFieldTypeString, alias: account_no, length: 7 )
• type ( type: esriFieldTypeString, alias: type, length: 1 )
• cdp_type ( type: esriFieldTypeString, alias: cdp_type, length: 2 )
• cycle ( type: esriFieldTypeString, alias: cycle, length: 4 )
• fm_coord ( type: esriFieldTypeString, alias: fm_coord, length: 20 )
• user_coord ( type: esriFieldTypeString, alias: user_coord, length: 20 )
• nasf ( type: esriFieldTypeInteger, alias: nasf )
• comments ( type: esriFieldTypeString, alias: comments, length: 2147483647 )
• gsf ( type: esriFieldTypeInteger, alias: gsf )
• lastsave ( type: esriFieldTypeDate, alias: lastsave, length: 8 )
• fiscal_closeout ( type: esriFieldTypeDate, alias: fiscal_closeout, length: 8 )
• abor_pi ( type: esriFieldTypeDate, alias: abor_pi, length: 8 )
• abor_ci ( type: esriFieldTypeDate, alias: abor_ci, length: 8 )
• abor_pa ( type: esriFieldTypeDate, alias: abor_pa, length: 8 )
• budget_saved_date ( type: esriFieldTypeDate, alias: budget_saved_date, length: 8 )
• y2ksort ( type: esriFieldTypeInteger, alias: y2ksort )
• budget_last_saved_date ( type: esriFieldTypeDate, alias: budget_last_saved_date, length: 8 )
• abor_oth ( type: esriFieldTypeDate, alias: abor_oth, length: 8 )
• opacct ( type: esriFieldTypeInteger, alias: opacct )
• delivery ( type: esriFieldTypeString, alias: delivery, length: 6 )
• revacct ( type: esriFieldTypeInteger, alias: revacct )
• revenue_budget ( type: esriFieldTypeDouble, alias: revenue_budget )
• billable ( type: esriFieldTypeString, alias: billable, length: 1 )
• billable_hours_limit ( type: esriFieldTypeSingle, alias: billable_hours_limit )
• abor_phase ( type: esriFieldTypeString, alias: abor_phase, length: 6 )
• bldg_no ( type: esriFieldTypeString, alias: bldg_no, length: 10 )
• projected_budget ( type: esriFieldTypeDouble, alias: projected_budget )
• construction_budget ( type: esriFieldTypeDouble, alias: construction_budget )
• warranty_messaged_date ( type: esriFieldTypeDate, alias: warranty_messaged_date, length: 8 )
• concept_budget_saved_date ( type: esriFieldTypeDate, alias: concept_budget_saved_date, length: 8 )
• sc_budget_saved_date ( type: esriFieldTypeDate, alias: sc_budget_saved_date, length: 8 )
• revised_budget_saved_date ( type: esriFieldTypeDate, alias: revised_budget_saved_date, length: 8 )
• jccr_flag ( type: esriFieldTypeString, alias: jccr_flag, length: 1 )
• fy_4digit ( type: esriFieldTypeInteger, alias: fy_4digit )
• design_intent ( type: esriFieldTypeString, alias: design_intent, length: 2147483647 )
• web_suppress ( type: esriFieldTypeSmallInteger, alias: web_suppress )
• web_counter ( type: esriFieldTypeInteger, alias: web_counter )
• design_professional ( type: esriFieldTypeString, alias: design_professional, length: 128 )
• contractor ( type: esriFieldTypeString, alias: contractor, length: 128 )
• i_number ( type: esriFieldTypeString, alias: i_number, length: 6 )
• sc_date ( type: esriFieldTypeDateOnly, alias: sc_date )
• community_update ( type: esriFieldTypeString, alias: community_update, length: 2147483647 )
• notice_to_proceed_date ( type: esriFieldTypeDateOnly, alias: notice_to_proceed_date )
• sub_account ( type: esriFieldTypeString, alias: sub_account, length: 5 )
• billing_suppress ( type: esriFieldTypeSmallInteger, alias: billing_suppress )
• phoenix_campus ( type: esriFieldTypeSmallInteger, alias: phoenix_campus )
• cd_switch ( type: esriFieldTypeDateOnly, alias: cd_switch )
• sharepoint_project ( type: esriFieldTypeString, alias: sharepoint_project, length: 10 )
• DPM ( type: esriFieldTypeString, alias: DPM, length: 20 )
• PM ( type: esriFieldTypeString, alias: PM, length: 20 )
• story_map_title ( type: esriFieldTypeString, alias: story_map_title, length: 255 )
• story_map ( type: esriFieldTypeSmallInteger, alias: story_map )
• story_map_order ( type: esriFieldTypeInteger, alias: story_map_order )
• webcamStream ( type: esriFieldTypeString, alias: webcamStream, length: 500 )