Name: STP SPREADSHEET

Display Field: ASSET_NO

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 100000

Supported Query Formats: JSON

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ASSET_NO ( type: esriFieldTypeString, alias: STP ASSET NO, length: 15 )
• FUNC_LOC ( type: esriFieldTypeString, alias: FUNCTIONAL LOCATION, length: 15 )
• DESC_FUNC_LOC ( type: esriFieldTypeString, alias: DESCRIPTION OF FUNCTIONAL LOCATION, length: 50 )
• MAINT_PLANT ( type: esriFieldTypeString, alias: UNIT OFFICE, length: 10 )
• SOURCE_CODE ( type: esriFieldTypeString, alias: SOURCE CODE, length: 5 )
• PROC_TYPE ( type: esriFieldTypeString, alias: PROCESS TYPE, length: 10 )
• TAKEOVER_DT ( type: esriFieldTypeDate, alias: TAKEOVER DATE, length: 8 )
• EFF_STD ( type: esriFieldTypeString, alias: EFFLUENT STANDARD, length: 5 )
• LA_AMIS ( type: esriFieldTypeString, alias: LOCAL AUTHORITY, length: 50 )
• DOE_CAT ( type: esriFieldTypeString, alias: DOE CATEGORY, length: 10 )
• STP_TYPE ( type: esriFieldTypeString, alias: STP TYPE, length: 15 )
• CPE ( type: esriFieldTypeInteger, alias: CURRENT PE )
• DPE ( type: esriFieldTypeInteger, alias: DESIGNED PE )
• MUL_PLANT_TYPE ( type: esriFieldTypeString, alias: MULTIPLE PLANT TYPE, length: 25 )
• OPI_VISIT ( type: esriFieldTypeDouble, alias: OPI VISIT )
• APPROVED_VISIT ( type: esriFieldTypeDouble, alias: APPROVED VISIT )
• INCOMING_AMP ( type: esriFieldTypeDouble, alias: TNB INCOMING AMP )
• STP_SECURITY ( type: esriFieldTypeString, alias: STP SECURITY, length: 15 )
• MANNED_PLANT_CAT ( type: esriFieldTypeString, alias: MANNED PLANT CATEGORY, length: 15 )
• EWS ( type: esriFieldTypeString, alias: EWS, length: 5 )
• SCADA ( type: esriFieldTypeString, alias: SCADA, length: 5 )
• SLUDGE_TF ( type: esriFieldTypeString, alias: SLUDGE TREATMENT FACILITY, length: 10 )
• SLUDGE_INTERWORKS ( type: esriFieldTypeString, alias: INTERWORKS SLUDGE (SLUDGE FACILITY), length: 5 )
• TOT_MAJOR_EQUIP ( type: esriFieldTypeSmallInteger, alias: TOTAL MAJOR EQUIP )
• TOT_NONMAJOR_EQUIP ( type: esriFieldTypeSmallInteger, alias: TOTAL NON-MAJOR EQUIP )
• TOT_OEO_EE ( type: esriFieldTypeSmallInteger, alias: TOTAL OEO EE )
• TOT_OEO_IS ( type: esriFieldTypeSmallInteger, alias: TOTAL OEO IS )
• PMA_PMT ( type: esriFieldTypeString, alias: PMA/PMT, length: 5 )
• TARIFF_CAT ( type: esriFieldTypeString, alias: TNB TARIFF CATEGORY, length: 50 )

Relationships:

• PUBLIC_STP_OM_STP_SPREADSHEET (0) -- Related To: Public STP (O&M) - Integration (34)
• IGISPROD.SDE.%PUBLIC_STP_AMIS_VIEW_1_1 (3) -- Related To: STP - Polygon (36)

Supported Operations:   Query   Query Attachments   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata