Name: LightsActivity

Display Field: LastName

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, PBF

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ID ( type: esriFieldTypeDouble, alias: ID )
• Comment ( type: esriFieldTypeString, alias: Comment, length: 4000 )
• RequestDept ( type: esriFieldTypeInteger, alias: Request Dept )
• RequestType ( type: esriFieldTypeString, alias: Request Type, length: 200 , Coded Values: [KnockdownUNK: Knockdown-Unknown Reason] , [KnockdownHR: Knockdown-Hit and Run] , [FailureEQU: Failure-Equipment] , ...2 more... )
• RequestID ( type: esriFieldTypeString, alias: Request ID, length: 10 )
• LastName ( type: esriFieldTypeString, alias: Last Name, length: 100 )
• FirstName ( type: esriFieldTypeString, alias: First Name, length: 100 )
• Email ( type: esriFieldTypeString, alias: Email, length: 100 )
• CallerAddress ( type: esriFieldTypeString, alias: Caller Address, length: 150 )
• IncidentAddress ( type: esriFieldTypeString, alias: Incident Address, length: 150 )
• Description ( type: esriFieldTypeString, alias: Description, length: 500 )
• AppointmentTime ( type: esriFieldTypeString, alias: Appointment Time, length: 8 )
• SubmitTo ( type: esriFieldTypeString, alias: Submit To, length: 100 )
• ResponseDate ( type: esriFieldTypeDate, alias: Response Date, length: 8 )
• ResponseTime ( type: esriFieldTypeString, alias: Response Time, length: 8 )
• ResponseNotes ( type: esriFieldTypeString, alias: Response Notes, length: 2000 )
• 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 )
• DayPhone ( type: esriFieldTypeString, alias: Day Phone, length: 12 )
• NightPhone ( type: esriFieldTypeString, alias: Night Phone, length: 12 )
• CellPhone ( type: esriFieldTypeString, alias: Cell Phone, length: 12 )
• RequestDeptList ( type: esriFieldTypeString, alias: Request Dept List, length: 50 )
• InitiatedDate ( type: esriFieldTypeString, alias: Initiated Date, length: 50 )
• AppointmentDate ( type: esriFieldTypeString, alias: Appointment Date, length: 50 )
• Callout ( type: esriFieldTypeString, alias: Callout, length: 3 )
• WorkOrder ( type: esriFieldTypeString, alias: Work Order No, length: 10 )
• FacilityID ( type: esriFieldTypeString, alias: Facility ID, length: 50 )
• Controller ( type: esriFieldTypeString, alias: Controller, length: 50 )
• PoliceReportNo ( type: esriFieldTypeString, alias: Police Report No, length: 50 )
• RepairedDate ( type: esriFieldTypeDate, alias: Repaired Date, length: 8 )
• IncidentDate ( type: esriFieldTypeDate, alias: Incident Date, length: 8 )
• RestitutionRequestProcess ( type: esriFieldTypeString, alias: Listed on Restitution Request Process?, length: 50 , Coded Values: [N: No] , [Y: Yes] , [NA: N/A] )
• RepairStatus ( type: esriFieldTypeString, alias: RepairStatus, length: 20 , Coded Values: [Canceled: Canceled] , [Closed: Completed/Closed] , [Open: Open/Work Needed] , ...2 more... )
• ReimbursementStatus ( type: esriFieldTypeString, alias: ReimbursementStatus, length: 50 , Coded Values: [Canceled: Canceled] , [Closed: Completed/Closed] , [Open: Open/Work Needed] , ...2 more... )
• FileLocations ( type: esriFieldTypeString, alias: FileLocations, length: 350 )

Relationships:

• Lights (0) -- Related To: Eagan Light Inventory (11)

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

  Iteminfo   Thumbnail   Metadata