Name: Current Check-ins

Display Field: name

Type: Table

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: false

Sources

Description: AttributeJoin

Copyright Text: Esri

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• name (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• team (type: esriFieldTypeString, alias: Team, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• officelocation (type: esriFieldTypeString, alias: Office Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• username (type: esriFieldTypeString, alias: Username, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• surveytype (type: esriFieldTypeString, alias: Survey Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Personnel: Personnel], [Team: Team])
• office (type: esriFieldTypeInteger, alias: Normal Work Location, SQL Type: sqlTypeOther, nullable: true, editable: true)
• home (type: esriFieldTypeInteger, alias: Working From Home, SQL Type: sqlTypeOther, nullable: true, editable: true)
• offisite (type: esriFieldTypeInteger, alias: Working Offsite, SQL Type: sqlTypeOther, nullable: true, editable: true)
• absent (type: esriFieldTypeInteger, alias: Absent, SQL Type: sqlTypeOther, nullable: true, editable: true)
• worktype (type: esriFieldTypeString, alias: Work Status, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Normal Work Location: Normal Work Location], [Working From Home: Working From Home], [Working Offsite: Working Offsite], ... 1 more ...)
• withothers (type: esriFieldTypeInteger, alias: Working With Others, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• workingwith (type: esriFieldTypeString, alias: Individual(s) Working With, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• hassymp (type: esriFieldTypeInteger, alias: Has Symptoms, SQL Type: sqlTypeOther, nullable: true, editable: true)
• symptoms (type: esriFieldTypeString, alias: Symptoms, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• hhhassymp (type: esriFieldTypeInteger, alias: Household Has Symptoms, SQL Type: sqlTypeOther, nullable: true, editable: true)
• eithersymp (type: esriFieldTypeInteger, alias: Has Personnel or Household Symptoms, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• hasadditionalinfo (type: esriFieldTypeInteger, alias: Requested Information or Assistance, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• additionalinfo (type: esriFieldTypeString, alias: Information or Assistance, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• GlobalID_1585248322854 (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate_1585248322854 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator_1585248322854 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate_1585248322854 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor_1585248322854 (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/28/2020 1:30:57 AM

Schema Last Edit Date: 3/28/2020 1:30:57 AM

Data Last Edit Date: 3/28/2020 1:30:57 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat