Name: DATA_ADMIN.CDOT_Fixtures

Display Field: COMED_FILENAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FIXTURE_ID ( type: esriFieldTypeInteger, alias: fixture_id )
• EFFECTIVE_DATE ( type: esriFieldTypeDate, alias: effective_date, length: 8 )
• CIRCUIT_ID ( type: esriFieldTypeInteger, alias: circuit_id )
• BALLAST_LOSS ( type: esriFieldTypeSmallInteger, alias: ballast_loss )
• INSTALL_DATE ( type: esriFieldTypeDate, alias: install_date, length: 8 )
• END_DATE ( type: esriFieldTypeDate, alias: end_date, length: 8 )
• REMOVE_DATE ( type: esriFieldTypeDate, alias: remove_date, length: 8 )
• COMED_STATUSCD ( type: esriFieldTypeString, alias: comed_statuscd, length: 50 , Coded Values: [Ready for Review: Ready for Review] , [Reviewed: Reviewed] , [Submitted: Submitted] , ...4 more... )
• COMED_STATUSDATE ( type: esriFieldTypeDate, alias: comed_statusdate, length: 8 )
• COMED_REJECTREASON ( type: esriFieldTypeString, alias: comed_rejectreason, length: 400 )
• COMED_FILENAME ( type: esriFieldTypeString, alias: comed_filename, length: 30 )
• COMED_UPDATETYPE ( type: esriFieldTypeString, alias: comed_updatetype, length: 3 , Coded Values: [INS: INS] , [MNT: MNT] , [REM: REM] , ...1 more... )
• CDOT_PROJECT_ID ( type: esriFieldTypeInteger, alias: cdot_project_id )
• PHOTOCELL_FLAG ( type: esriFieldTypeSmallInteger, alias: photocell_flag )
• RELATED_URL ( type: esriFieldTypeString, alias: related_url, length: 250 )
• REVIEWER_USERID ( type: esriFieldTypeString, alias: reviewer_userid, length: 10 )
• REVIEWER_COMMENTS ( type: esriFieldTypeString, alias: reviewer_comments, length: 50 )
• COMMENTS ( type: esriFieldTypeString, alias: comments, length: 50 )
• FIXTURE_CODE ( type: esriFieldTypeInteger, alias: fixture_code , Coded Values: [0: aviation_13] , [1: coach_50] , [2: coach_60] , ...81 more... )
• CBI_ID ( type: esriFieldTypeInteger, alias: cbi_id )
• PROCESSED ( type: esriFieldTypeSmallInteger, alias: processed )
• 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 )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata