Name: Client List

Display Field: FirstName

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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: true
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: false
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:

Fields:

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

Templates:

• Name: Client List
  Description:
  Prototype:
  EmerFirst:
  EmerPhoneHome:
  SpouseVet: null
  ResCity:
  Mobility: null
  ResState:
  Gender: null
  ResZipcode: 0
  NeedLift: null
  ActiveStatus: null
  PhoneMobile:
  ClientName: null
  Race:
  EmerLast:
  PhoneHome:
  Veteran: null
  SexualOrientation: null
  Age: 0
  MaritialStatus: null
  YCoord: null
  Blind: null
  Comment: null
  ResSuite: null
  EmerPhoneMobile:
  FirstName:
  ResAddress:
  GenderIdentity: null
  DateBirth: null
  Ethnicity: null
  XCoord: null
  LivesAlone: null
  ClientID: null
  LastName:
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata