Name: Opener

Display Field: AssetName

Type: Table

Geometry Type: N/A

Description:

Definition Expression: N/A

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

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 )
• AssetID ( type: esriFieldTypeString , alias: Asset ID (Tag) , editable: true , nullable: false , length: 50 )
• AssetName ( type: esriFieldTypeString , alias: Asset Name , editable: true , nullable: true , length: 100 )
• FacilitySiteName ( type: esriFieldTypeString , alias: Facility Site Name , editable: true , nullable: true , length: 100 , Coded Values: [Main Facility: SLCWRRF - Main Facility] , [Influent Pump Station: SLCWRRF - Influent Pump Station] )
• ParentID ( type: esriFieldTypeString , alias: Parent ID , editable: true , nullable: true , length: 50 )
• OrigEquipNumber ( type: esriFieldTypeString , alias: Original Equipment Number , editable: true , nullable: true , length: 30 )
• Type ( type: esriFieldTypeString , alias: Type , editable: true , nullable: true , length: 30 , Coded Values: [Electric: Electric] , [Pneumatic: Pneumatic] , [Hydraulic: Hydraulic] , ...1 more... )
• Criticality ( type: esriFieldTypeInteger , alias: Criticality , editable: true , nullable: true , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• CriticalityComments ( type: esriFieldTypeString , alias: Criticality Comments , editable: true , nullable: true , length: 255 )
• Condition ( type: esriFieldTypeInteger , alias: Condition , editable: true , nullable: true , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• ConditionComments ( type: esriFieldTypeString , alias: Condition Comments , editable: true , nullable: true , length: 256 )
• StartUpDate ( type: esriFieldTypeDate , alias: Start Up Date , editable: true , nullable: true , length: 8 )
• Location ( type: esriFieldTypeString , alias: Location , editable: true , nullable: true , length: 200 )
• SerialNumber ( type: esriFieldTypeString , alias: Serial Number , editable: true , nullable: true , length: 50 )
• ModelNumber ( type: esriFieldTypeString , alias: Model Number , editable: true , nullable: true , length: 50 )
• Description ( type: esriFieldTypeString , alias: Description , editable: true , nullable: true , length: 255 )
• Manufacturer ( type: esriFieldTypeString , alias: Manufacturer , editable: true , nullable: true , length: 50 )
• Vendor ( type: esriFieldTypeString , alias: Vendor , editable: true , nullable: true , length: 50 )
• WarrantyDate ( type: esriFieldTypeDate , alias: Warranty Date , editable: true , nullable: true , length: 8 )
• OriginalCost ( type: esriFieldTypeDouble , alias: Original Cost , editable: true , nullable: true )
• ReplacementCost ( type: esriFieldTypeDouble , alias: Replacement Cost , editable: true , nullable: true )
• EstimatedLife ( type: esriFieldTypeSmallInteger , alias: Estimated Life , editable: true , nullable: true )
• Process ( type: esriFieldTypeString , alias: Process , editable: true , nullable: true , length: 50 , Coded Values: [Influent Screening: Influent Screening] , [Primary Settling: Primary Settling] , [Secondary Settling: Secondary Settling] , ...16 more... )
• O_MLink ( type: esriFieldTypeString , alias: O&M Link , editable: true , nullable: true , length: 255 )
• CIPName ( type: esriFieldTypeString , alias: CIP Name , editable: true , nullable: true , length: 100 )
• CIPNumber ( type: esriFieldTypeString , alias: CIP Number , editable: true , nullable: true , length: 20 )
• PurchaseDate ( type: esriFieldTypeDate , alias: Purchase Date , editable: true , nullable: true , length: 8 )
• Classification ( type: esriFieldTypeString , alias: Classification , editable: true , nullable: true , length: 50 , Coded Values: [Unclassified: Unclassified] , [Class 1 - Division 1: Class 1 - Division 1] , [Class 1 - Division 2: Class 1 - Division 2] )
• LifecycleStatus ( type: esriFieldTypeString , alias: Lifecycle Status , editable: true , nullable: true , length: 20 , Coded Values: [Active: Active] , [Retired: Retired] , [Removed: Removed] , ...1 more... )
• Service ( type: esriFieldTypeString , alias: Service , editable: true , nullable: true , length: 20 , Coded Values: [In Service: In Service] , [Out of Service: Out of Service] , [Retired: Retired] )
• AddlActuatorInfo ( type: esriFieldTypeString , alias: Additional Actuator Information , editable: true , nullable: true , length: 255 )
• AddlOperatorInfo ( type: esriFieldTypeString , alias: Additional Operator Information , editable: true , nullable: true , length: 255 )
• DCNewFields ( type: esriFieldTypeString , alias: DC_New Fields or Values , editable: true , nullable: true , length: 255 )
• DCAddlComments ( type: esriFieldTypeString , alias: DC_Additional Comments , editable: true , nullable: true , length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , editable: false , nullable: false , length: 38 )
• PARENTGlobalID ( type: esriFieldTypeGUID , alias: PARENTGlobalID , editable: true , nullable: true , length: 38 )

Templates:

• Name: Opener
  Description:
  Prototype:
  DCAddlComments: null
  PARENTGlobalID: null
  AssetID:
  AssetName: null
  FacilitySiteName: null
  ParentID: null
  OrigEquipNumber: null
  Type: null
  Criticality: null
  CriticalityComments: null
  Condition: null
  ConditionComments: null
  StartUpDate: null
  Location: null
  SerialNumber: null
  ModelNumber: null
  Description: null
  Manufacturer: null
  Vendor: null
  WarrantyDate: null
  OriginalCost: null
  ReplacementCost: null
  EstimatedLife: null
  Process: null
  O_MLink: null
  CIPName: null
  CIPNumber: null
  PurchaseDate: null
  Classification: null
  LifecycleStatus: null
  Service: null
  AddlActuatorInfo: null
  AddlOperatorInfo: null
  DCNewFields: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Gearbox (309) -- Related To: Gearbox (50)
• Motor (383) -- Related To: Motor (72)
• OverheadDoor (401) -- Related To: OverheadDoor (76)

Capabilities: Query,Create,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

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