Name: Client List

Display Field: FirstName

Type: Table

Geometry Type: N/A

Description: N/A

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

Feature Draw Order:

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: N/A

Fields:

• OBJECTID ( nullable: false, alias: ObjectID, type: esriFieldTypeOID )
• FirstName ( nullable: true, length: 255, alias: First Name, type: esriFieldTypeString )
• LastName ( nullable: true, length: 255, alias: Last Name, type: esriFieldTypeString )
• Age ( nullable: true, alias: Age, type: esriFieldTypeDouble )
• DateBirth ( nullable: true, length: 8, alias: Date of Birth, type: esriFieldTypeDate )
• PhoneHome ( nullable: true, length: 255, alias: Phone Home, type: esriFieldTypeString )
• PhoneMobile ( nullable: true, length: 255, alias: Phone Mobile, type: esriFieldTypeString )
• Race ( nullable: true, length: 255, alias: Race, type: esriFieldTypeString )
• ResAddress ( nullable: true, length: 255, alias: Residential Address, type: esriFieldTypeString )
• ResSuite ( nullable: true, length: 20, alias: Suite/Apt, type: esriFieldTypeString )
• ResCity ( nullable: true, length: 255, alias: Residential City, type: esriFieldTypeString )
• ResState ( nullable: true, length: 255, alias: Residential State, type: esriFieldTypeString )
• ResZipcode ( nullable: true, alias: Residential Zipcode, type: esriFieldTypeDouble )
• EmerFirst ( nullable: true, length: 255, alias: Emergency Contact First, type: esriFieldTypeString )
• EmerLast ( nullable: true, length: 255, alias: Emergency Contact Last, type: esriFieldTypeString )
• EmerPhoneHome ( nullable: true, length: 255, alias: Emergency Contact Phone Home, type: esriFieldTypeString )
• EmerPhoneMobile ( nullable: true, length: 255, alias: Emergency Contact Phone Mobile, type: esriFieldTypeString )
• ActiveStatus ( nullable: true, length: 255, alias: Active Status, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• LivesAlone ( nullable: true, length: 255, alias: Lives Alone, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• MaritialStatus ( nullable: true, length: 75, alias: Maritial Status, type: esriFieldTypeString , Coded Values: [Married: Married] , [Divorced: Divorced] , [Widowed: Widowed] , ...3 more... )
• Gender ( nullable: true, length: 30, alias: Gender, type: esriFieldTypeString , Coded Values: [Male: Male] , [Female: Female] )
• Veteran ( nullable: true, length: 20, alias: Veteran, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• SpouseVet ( nullable: true, length: 20, alias: Spouse/Widow of Veteran, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• Ethnicity ( nullable: true, length: 255, alias: Ethnicity, type: esriFieldTypeString , Coded Values: [Hispanic: Hispanic] , [Non-Hispanic: Non-Hispanic] )
• Mobility ( nullable: true, length: 255, alias: Mobility, type: esriFieldTypeString , Coded Values: [Walker: Walker] , [Wheelchair Electric: Wheelchair Electric] , [Wheelchair Manual: Wheelchair Manual] )
• NeedLift ( nullable: true, length: 20, alias: Needs Lift, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• SexualOrientation ( nullable: true, length: 255, alias: Sexual Orientation, type: esriFieldTypeString , Coded Values: [Straight: Straight] , [Lesbian: Lesbian] , [Gay: Gay] , ...4 more... )
• GenderIdentity ( nullable: true, length: 255, alias: Gender Identity, type: esriFieldTypeString , Coded Values: [Man: Man] , [Woman: Woman] , [Gender Non-Conforming: Gender Non-Conforming] , ...2 more... )
• Blind ( nullable: true, length: 20, alias: Blind, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• Comment ( nullable: true, length: 255, alias: Comment, type: esriFieldTypeString )
• XCoord ( nullable: true, alias: X Coordinate, type: esriFieldTypeDouble )
• YCoord ( nullable: true, alias: Y Coordinate, type: esriFieldTypeDouble )
• ClientID ( nullable: true, length: 255, alias: Client ID, type: esriFieldTypeString )
• created_user ( nullable: true, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, length: 8, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, length: 8, alias: last_edited_date, type: esriFieldTypeDate )
• ClientName ( nullable: true, length: 255, alias: ClientName, type: esriFieldTypeString )
• GlobalID ( nullable: false, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )

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

  Iteminfo   Thumbnail   Metadata