Tables:

Table: sde.SHELTER_STAFFDAILYSHIFTSUMMARY_VIEW2 (2)

Name: sde.SHELTER_STAFFDAILYSHIFTSUMMARY_VIEW2

Display Field: FullName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 5ad1edc472374a4fb978ed15b5b0cf17

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FullName ( type: esriFieldTypeString, alias: FullName, length: 255 )
• StaffID ( type: esriFieldTypeString, alias: StaffID, length: 255 )
• GUID ( type: esriFieldTypeGUID, alias: GUID, length: 38 )
• FacilityName ( type: esriFieldTypeString, alias: FacilityName, length: 255 )
• POSITION ( type: esriFieldTypeString, alias: POSITION, length: 255 )
• DayOfTheWeek ( type: esriFieldTypeString, alias: DayOfTheWeek, length: 30 )
• ClockTimeIn ( type: esriFieldTypeDate, alias: ClockTimeIn, length: 8, precision: 1 )
• ClockStatusIn ( type: esriFieldTypeString, alias: ClockStatusIn, length: 8 )
• ClockTimeOut ( type: esriFieldTypeDate, alias: ClockTimeOut, length: 8, precision: 1 )
• ClockStatusOut ( type: esriFieldTypeString, alias: ClockStatusOut, length: 9 )
• HoursWorked ( type: esriFieldTypeDouble, alias: HoursWorked )
• CurrentShiftStatus ( type: esriFieldTypeString, alias: CurrentShiftStatus, length: 14 )