Name: UPS

Display Field: Name

Type: Table

Geometry Type: N/A

Description:

Definition Expression: N/A

Copyright Text:

Default Visibility: false

MaxRecordCount: 100000

Supported Query Formats: JSON, AMF, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
• InstallDate ( type: esriFieldTypeDate , alias: Install Date , editable: true , nullable: true , length: 8 )
• RehabDate ( type: esriFieldTypeDate , alias: Rehab Date , editable: true , nullable: true , length: 8 )
• SerialNo ( type: esriFieldTypeString , alias: Serial Number , editable: true , nullable: true , length: 30 )
• ModelNo ( type: esriFieldTypeString , alias: Model Number , editable: true , nullable: true , length: 30 )
• Manufacturer ( type: esriFieldTypeString , alias: Manufacturer , editable: true , nullable: true , length: 55 )
• Voltage ( type: esriFieldTypeDouble , alias: Voltage , editable: true , nullable: true , Coded Values: [230: 230] , [480: 480] , [230.48: 230.480] , ...2 more... )
• Amperage ( type: esriFieldTypeDouble , alias: Amperage , editable: true , nullable: true )
• ComponentID ( type: esriFieldTypeString , alias: Component ID , editable: true , nullable: true , length: 55 )
• ParentID ( type: esriFieldTypeString , alias: Parent ID , editable: true , nullable: true , length: 55 )
• Description ( type: esriFieldTypeString , alias: Description , editable: true , nullable: true , length: 255 )
• Process ( type: esriFieldTypeString , alias: Process , editable: true , nullable: true , length: 55 , Coded Values: [Mechanical: Mechanical] , [ICE: ICE] , [Civil: Civil] )
• Subprocess ( type: esriFieldTypeString , alias: Subprocess , editable: true , nullable: true , length: 75 , Coded Values: [Valves: Valves] , [Electrical: Electrical] , [Control: Control] , ...3 more... )
• Service ( type: esriFieldTypeString , alias: Service , editable: true , nullable: true , length: 30 , Coded Values: [In Service: In Service] , [Out of Service: Out of Service] , [Retired: Retired] )
• Name ( type: esriFieldTypeString , alias: Name , editable: true , nullable: true , length: 75 )
• Location ( type: esriFieldTypeString , alias: Location , editable: true , nullable: true , length: 75 )
• FacilityType ( type: esriFieldTypeString , alias: Facility Type , editable: true , nullable: true , length: 55 , Coded Values: [Lift Station: Lift Station] , [Treatment Plant: Treatment Plant] )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , editable: false , nullable: false , length: 38 )
• created_user ( type: esriFieldTypeString , alias: created_user , editable: false , nullable: true , length: 255 )
• created_date ( type: esriFieldTypeDate , alias: created_date , editable: false , nullable: true , length: 8 )
• last_edited_user ( type: esriFieldTypeString , alias: last_edited_user , editable: false , nullable: true , length: 255 )
• last_edited_date ( type: esriFieldTypeDate , alias: last_edited_date , editable: false , nullable: true , length: 8 )
• Notes ( type: esriFieldTypeString , alias: Notes , editable: true , nullable: true , length: 255 )
• Address ( type: esriFieldTypeString , alias: Address , editable: true , nullable: true , length: 130 )
• EstimatedUse_Yrs ( type: esriFieldTypeSmallInteger , alias: Estimated Useful Life (yrs) , editable: true , nullable: true )
• BRE ( type: esriFieldTypeDouble , alias: Business Risk Exposure , editable: true , nullable: true )
• COF ( type: esriFieldTypeDouble , alias: COF , editable: true , nullable: true )
• LOF ( type: esriFieldTypeDouble , alias: LOF , editable: true , nullable: true )

Templates:

• Name: UPS
  Description:
  Prototype:
  COF: null
  LOF: null
  InstallDate: null
  RehabDate: null
  SerialNo: null
  ModelNo: null
  Manufacturer: null
  Voltage: null
  Amperage: null
  ComponentID: null
  ParentID: null
  Description: null
  Process: null
  Subprocess: null
  Service: null
  Name: null
  Location: null
  FacilityType: null
  BRE: null
  EstimatedUse_Yrs: null
  Address: null
  Notes: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• LS_Subprocess (37) -- Related To: LS_Subprocess (2)

Capabilities: Create,Query,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata