Name: SOMASTER.SO_Maintenance_History

Display Field: NAME_OF_WORK

Type: Table

Geometry Type: N/A

Description: null

Definition Expression: N/A

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: SUBTYPE

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SUBTYPE ( type: esriFieldTypeSmallInteger, alias: SUBTYPE )
• SC_R_NO ( type: esriFieldTypeString, alias: Street connection reference no., length: 10 )
• LINE ( type: esriFieldTypeString, alias: Line identifination, length: 100 )
• WORK_DATE ( type: esriFieldTypeDate, alias: Survey or job application date(dd-mm-yyyy), length: 8 )
• NAME_OF_WORK ( type: esriFieldTypeString, alias: Name of work, length: 255 )
• PO_NUMBER ( type: esriFieldTypeString, alias: PO Number, length: 100 )
• EXECUTING_AGENCY ( type: esriFieldTypeString, alias: Executing agency, length: 100 )
• CATEGORY_OF_UPDATION ( type: esriFieldTypeString, alias: Category of updation, length: 50 , Coded Values: [0: SURV_ST] , [1: SURV_GT] , [2: SURV_SCL] , ...7 more... )
• REMARKS ( type: esriFieldTypeString, alias: Remarks, length: 255 )
• ED_OPERATOR ( type: esriFieldTypeString, alias: Last updated by, length: 50 )
• ED_DATETIME ( type: esriFieldTypeDate, alias: Last updated on(dd-mm-yyyy), length: 8 )
• DOWN_NODE_NO ( type: esriFieldTypeString, alias: DOWN_NODE_NO, length: 50 )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )
• CATEGORY_OF_WORK ( type: esriFieldTypeString, alias: Category of Work, length: 50 )
• NODE_NO ( type: esriFieldTypeString, alias: Node No, length: 50 )
• DLP_END_DT ( type: esriFieldTypeDate, alias: Defect Liability End Date, length: 8 )
• NIS_NO ( type: esriFieldTypeInteger, alias: NIS NO )
• LINE_NEW ( type: esriFieldTypeString, alias: LINE_NEW, length: 30 )
• NODE_NO_NEW ( type: esriFieldTypeString, alias: Node No (New Format), length: 15 )
• DOWN_NODE_NO_NEW ( type: esriFieldTypeString, alias: Down Node No (New Format), length: 15 )

Types:

ID: 0
Name: NA
Domains:
• CATEGORY_OF_UPDATION:
  Inherited

---

ID: 1
Name: Manhole
Domains:
• CATEGORY_OF_UPDATION:
  Inherited
• CATEGORY_OF_WORK:
  Coded Values: [RBM: Raising of Buried Manhole] , [FMC: Fixing of Manhole Cover] , [RCM: Reconstruction of Manhole] , ...6 more...

---

ID: 2
Name: Sewerline
Domains:
• CATEGORY_OF_UPDATION:
  Inherited
• CATEGORY_OF_WORK:
  Coded Values: [RSL: Replacement / Repairs of Sewerline] , [PSL: Providing and Laying of Sewerline] , [ESL: Enlargement of Sewerline] , ...9 more...

---

ID: 3
Name: Vent Shaft
Domains:
• CATEGORY_OF_UPDATION:
  Inherited
• CATEGORY_OF_WORK:
  Coded Values: [OTH: Others] , [CVS: Construction of New Vent Shaft] , [SVS: Shifting of Vent Shaft] , ...1 more...

---

Supported Operations:   Query   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata