View In:   ArcGIS Online Map Viewer

Name: CCMS Provider Details

Display Field: ProviderName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: dbo.view_ProviderDetails_ArcGIS_1

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -180.0
YMin: -90.0
XMax: 180.0
YMax: 90.0
Spatial Reference: 4326  (4326)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [54, 93, 140, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• ProviderId ( type: esriFieldTypeOID, alias: ProviderId, editable: false, nullable: false, defaultValue: null, modelName: ProviderId )
• ProviderKey ( type: esriFieldTypeString, alias: ProviderKey, editable: true, nullable: true, length: 15, defaultValue: null, modelName: ProviderKey )
• ProviderName ( type: esriFieldTypeString, alias: ProviderName, editable: true, nullable: true, length: 154, defaultValue: null, modelName: ProviderName )
• BusinessName ( type: esriFieldTypeString, alias: BusinessName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BusinessName )
• LastName ( type: esriFieldTypeString, alias: LastName, editable: true, nullable: true, length: 75, defaultValue: null, modelName: LastName )
• FirstName ( type: esriFieldTypeString, alias: FirstName, editable: true, nullable: true, length: 75, defaultValue: null, modelName: FirstName )
• MiddleName ( type: esriFieldTypeString, alias: MiddleName, editable: true, nullable: true, length: 1, defaultValue: null, modelName: MiddleName )
• ProviderAddress ( type: esriFieldTypeString, alias: ProviderAddress, editable: true, nullable: true, length: 245, defaultValue: null, modelName: ProviderAddress )
• ProviderAddressLine1 ( type: esriFieldTypeString, alias: ProviderAddressLine1, editable: true, nullable: true, length: 75, defaultValue: null, modelName: ProviderAddressLine1 )
• ProviderAddressLine2 ( type: esriFieldTypeString, alias: ProviderAddressLine2, editable: true, nullable: true, length: 91, defaultValue: null, modelName: ProviderAddressLine2 )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Address )
• City ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 75, defaultValue: null, modelName: City )
• State ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 2, defaultValue: null, modelName: State )
• ZipCode ( type: esriFieldTypeString, alias: ZipCode, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ZipCode )
• PhoneNumber ( type: esriFieldTypeString, alias: PhoneNumber, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PhoneNumber )
• AlternatePhoneNumber ( type: esriFieldTypeString, alias: AlternatePhoneNumber, editable: true, nullable: true, length: 20, defaultValue: null, modelName: AlternatePhoneNumber )
• CellPhoneNumber ( type: esriFieldTypeString, alias: CellPhoneNumber, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CellPhoneNumber )
• FaxNumber ( type: esriFieldTypeString, alias: FaxNumber, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FaxNumber )
• Email ( type: esriFieldTypeString, alias: Email, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Email )
• Website ( type: esriFieldTypeString, alias: Website, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Website )
• RemoveFromWebsite ( type: esriFieldTypeSmallInteger, alias: RemoveFromWebsite, editable: true, nullable: false, defaultValue: null, modelName: RemoveFromWebsite )
• RemoveFromWebsiteDate ( type: esriFieldTypeDate, alias: RemoveFromWebsiteDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RemoveFromWebsiteDate )
• ORS ( type: esriFieldTypeSmallInteger, alias: ORS, editable: true, nullable: false, defaultValue: null, modelName: ORS )
• VACMSActive ( type: esriFieldTypeSmallInteger, alias: VACMSActive, editable: true, nullable: false, defaultValue: null, modelName: VACMSActive )
• ProviderTypeID ( type: esriFieldTypeInteger, alias: ProviderTypeID, editable: true, nullable: false, defaultValue: null, modelName: ProviderTypeID )
• ProviderTypeName ( type: esriFieldTypeString, alias: ProviderTypeName, editable: true, nullable: true, length: 75, defaultValue: null, modelName: ProviderTypeName )
• ProviderRegulatoryAgencyID ( type: esriFieldTypeInteger, alias: ProviderRegulatoryAgencyID, editable: true, nullable: true, defaultValue: null, modelName: ProviderRegulatoryAgencyID )
• ProviderRegulatoryAgencyName ( type: esriFieldTypeString, alias: ProviderRegulatoryAgencyName, editable: true, nullable: true, length: 75, defaultValue: null, modelName: ProviderRegulatoryAgencyName )
• RegulatoryAgencyIssueDate ( type: esriFieldTypeDate, alias: RegulatoryAgencyIssueDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RegulatoryAgencyIssueDate )
• RegulatoryAgencyExpDate ( type: esriFieldTypeDate, alias: RegulatoryAgencyExpDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RegulatoryAgencyExpDate )
• ProviderStatusID ( type: esriFieldTypeInteger, alias: ProviderStatusID, editable: true, nullable: false, defaultValue: null, modelName: ProviderStatusID )
• ProviderStatusName ( type: esriFieldTypeString, alias: ProviderStatusName, editable: true, nullable: true, length: 75, defaultValue: null, modelName: ProviderStatusName )
• ProviderStatusDate ( type: esriFieldTypeDate, alias: ProviderStatusDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ProviderStatusDate )
• CCARTeamID ( type: esriFieldTypeInteger, alias: CCARTeamID, editable: true, nullable: true, defaultValue: null, modelName: CCARTeamID )
• CCARTeam ( type: esriFieldTypeString, alias: CCARTeam, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CCARTeam )
• CEPSTeamID ( type: esriFieldTypeInteger, alias: CEPSTeamID, editable: true, nullable: true, defaultValue: null, modelName: CEPSTeamID )
• CEPSTeam ( type: esriFieldTypeString, alias: CEPSTeam, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CEPSTeam )
• MOAIssueDate ( type: esriFieldTypeDate, alias: MOAIssueDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MOAIssueDate )
• MOAExpDate ( type: esriFieldTypeDate, alias: MOAExpDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MOAExpDate )
• MOATypeID ( type: esriFieldTypeInteger, alias: MOATypeID, editable: true, nullable: true, defaultValue: null, modelName: MOATypeID )
• MOALicensedSubTypeID ( type: esriFieldTypeInteger, alias: MOALicensedSubTypeID, editable: true, nullable: true, defaultValue: null, modelName: MOALicensedSubTypeID )
• MOAUnLicensedSubTypeID ( type: esriFieldTypeInteger, alias: MOAUnLicensedSubTypeID, editable: true, nullable: true, defaultValue: null, modelName: MOAUnLicensedSubTypeID )
• MOATypeName ( type: esriFieldTypeString, alias: MOATypeName, editable: true, nullable: true, length: 75, defaultValue: null, modelName: MOATypeName )
• MOALicensedSubTypeName ( type: esriFieldTypeString, alias: MOALicensedSubTypeName, editable: true, nullable: true, length: 75, defaultValue: null, modelName: MOALicensedSubTypeName )
• MOAUnLicensedSubTypeName ( type: esriFieldTypeString, alias: MOAUnLicensedSubTypeName, editable: true, nullable: true, length: 75, defaultValue: null, modelName: MOAUnLicensedSubTypeName )
• PermitIssueDate ( type: esriFieldTypeDate, alias: PermitIssueDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PermitIssueDate )
• PermitExpiryDate ( type: esriFieldTypeDate, alias: PermitExpiryDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PermitExpiryDate )
• PermitStatusID ( type: esriFieldTypeInteger, alias: PermitStatusID, editable: true, nullable: true, defaultValue: null, modelName: PermitStatusID )
• PermitStatusName ( type: esriFieldTypeString, alias: PermitStatusName, editable: true, nullable: true, length: 75, defaultValue: null, modelName: PermitStatusName )
• StateProviderIdentifier ( type: esriFieldTypeString, alias: StateProviderIdentifier, editable: true, nullable: true, length: 15, defaultValue: null, modelName: StateProviderIdentifier )
• IsAcceptsSubsidy ( type: esriFieldTypeString, alias: IsAcceptsSubsidy, editable: true, nullable: false, length: 3, defaultValue: null, modelName: IsAcceptsSubsidy )
• Languages ( type: esriFieldTypeString, alias: Languages, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: Languages )
• AgesOfChildrenServed ( type: esriFieldTypeString, alias: AgesOfChildrenServed, editable: true, nullable: true, length: 39, defaultValue: null, modelName: AgesOfChildrenServed )
• TransportationProvided ( type: esriFieldTypeString, alias: TransportationProvided, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: TransportationProvided )
• ElementarySchools ( type: esriFieldTypeString, alias: ElementarySchools, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: ElementarySchools )
• DaysofOperation ( type: esriFieldTypeString, alias: DaysofOperation, editable: true, nullable: true, length: 8000, defaultValue: null, modelName: DaysofOperation )
• HoursOfOperation ( type: esriFieldTypeString, alias: HoursOfOperation, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: HoursOfOperation )
• SpecialNeeds ( type: esriFieldTypeString, alias: SpecialNeeds, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: SpecialNeeds )
• ProviderCredentials ( type: esriFieldTypeString, alias: ProviderCredentials, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: ProviderCredentials )
• ProviderAccreditation ( type: esriFieldTypeString, alias: ProviderAccreditation, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: ProviderAccreditation )
• IsUSDAFoodProgram ( type: esriFieldTypeString, alias: IsUSDAFoodProgram, editable: true, nullable: false, length: 3, defaultValue: null, modelName: IsUSDAFoodProgram )
• PhysicalEnvironmentCharacteristics ( type: esriFieldTypeString, alias: PhysicalEnvironmentCharacteristics, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: PhysicalEnvironmentCharacteristics )
• ProgramParticipations ( type: esriFieldTypeString, alias: ProgramParticipations, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: ProgramParticipations )
• ChildCareServices ( type: esriFieldTypeString, alias: ChildCareServices, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: ChildCareServices )
• FireStations ( type: esriFieldTypeString, alias: FireStations, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: FireStations )

Templates:

• Name: CCMS Provider Details
  Description:
  Prototype:
  ChildCareServices: null
  FireStations: null
  ProviderKey: null
  ProviderName: null
  BusinessName: null
  LastName: null
  FirstName: null
  MiddleName: null
  ProviderAddress: null
  ProviderAddressLine1: null
  ProviderAddressLine2: null
  Address: null
  City: null
  State: null
  ZipCode: null
  PhoneNumber: null
  AlternatePhoneNumber: null
  CellPhoneNumber: null
  FaxNumber: null
  Email: null
  Website: null
  RemoveFromWebsite: 0
  RemoveFromWebsiteDate: null
  ORS: 0
  VACMSActive: 0
  ProviderTypeID: 0
  ProviderTypeName: null
  ProviderRegulatoryAgencyID: null
  ProviderRegulatoryAgencyName: null
  RegulatoryAgencyIssueDate: null
  RegulatoryAgencyExpDate: null
  ProviderStatusID: 0
  ProviderStatusName: null
  ProviderStatusDate: null
  CCARTeamID: null
  CCARTeam: null
  CEPSTeamID: null
  CEPSTeam: null
  MOAIssueDate: null
  MOAExpDate: null
  MOATypeID: null
  MOALicensedSubTypeID: null
  MOAUnLicensedSubTypeID: null
  MOATypeName: null
  MOALicensedSubTypeName: null
  MOAUnLicensedSubTypeName: null
  PermitIssueDate: null
  PermitExpiryDate: null
  PermitStatusID: null
  PermitStatusName: null
  StateProviderIdentifier: null
  IsAcceptsSubsidy:
  Languages: null
  AgesOfChildrenServed: null
  TransportationProvided: null
  ElementarySchools: null
  DaysofOperation: null
  HoursOfOperation: null
  SpecialNeeds: null
  ProviderCredentials: null
  ProviderAccreditation: null
  IsUSDAFoodProgram:
  PhysicalEnvironmentCharacteristics: null
  ProgramParticipations: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata