Name: Contacts

Display Field: profilename

Type: Table

Geometry Type: N/A

Description:

Service Item Id: d6abb16dfcf843be8c414392f527601c

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: false
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: false
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 ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• idproject ( modelName: idproject, nullable: true, editable: true, defaultValue: null, alias: idProject, type: esriFieldTypeInteger )
• projectassociationstatus ( modelName: projectassociationstatus, nullable: true, editable: true, defaultValue: null, length: 2048, alias: projectAssociationStatus, type: esriFieldTypeString )
• isprimary ( modelName: isprimary, nullable: true, editable: true, defaultValue: null, alias: isPrimary, type: esriFieldTypeSmallInteger )
• inform ( modelName: inform, nullable: true, editable: true, defaultValue: null, alias: inForm, type: esriFieldTypeSmallInteger )
• isactive ( modelName: isactive, nullable: true, editable: true, defaultValue: null, alias: isActive, type: esriFieldTypeSmallInteger )
• idprofilelineage ( modelName: idprofilelineage, nullable: true, editable: true, defaultValue: null, alias: idProfileLineage, type: esriFieldTypeInteger )
• idprofessionallicense ( modelName: idprofessionallicense, nullable: true, editable: true, defaultValue: null, alias: idProfessionalLicense, type: esriFieldTypeInteger )
• idcreator ( modelName: idcreator, nullable: true, editable: true, defaultValue: null, alias: idCreator, type: esriFieldTypeInteger )
• profilename ( modelName: profilename, nullable: true, editable: true, defaultValue: null, length: 128, alias: profileName, type: esriFieldTypeString )
• streetaddress ( modelName: streetaddress, nullable: true, editable: true, defaultValue: null, length: 255, alias: streetAddress, type: esriFieldTypeString )
• unit ( modelName: unit, nullable: true, editable: true, defaultValue: null, length: 64, alias: unit, type: esriFieldTypeString )
• city ( modelName: city, nullable: true, editable: true, defaultValue: null, length: 64, alias: city, type: esriFieldTypeString )
• state ( modelName: state, nullable: true, editable: true, defaultValue: null, length: 8, alias: state, type: esriFieldTypeString )
• zip ( modelName: zip, nullable: true, editable: true, defaultValue: null, length: 64, alias: zip, type: esriFieldTypeString )
• email ( modelName: email, nullable: true, editable: true, defaultValue: null, length: 128, alias: email, type: esriFieldTypeString )
• phone ( modelName: phone, nullable: true, editable: true, defaultValue: null, length: 16, alias: phone, type: esriFieldTypeString )
• fax ( modelName: fax, nullable: true, editable: true, defaultValue: null, length: 16, alias: fax, type: esriFieldTypeString )
• datestart ( modelName: datestart, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: dateStart, type: esriFieldTypeDate )
• dateend ( modelName: dateend, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: dateEnd, type: esriFieldTypeDate )
• company ( modelName: company, nullable: true, editable: true, defaultValue: null, length: 128, alias: company, type: esriFieldTypeString )
• isremoved ( modelName: isremoved, nullable: true, editable: true, defaultValue: null, alias: isRemoved, type: esriFieldTypeSmallInteger )
• isvalidated ( modelName: isvalidated, nullable: true, editable: true, defaultValue: null, alias: isValidated, type: esriFieldTypeSmallInteger )
• isself ( modelName: isself, nullable: true, editable: true, defaultValue: null, alias: isSelf, type: esriFieldTypeSmallInteger )
• iduser ( modelName: iduser, nullable: true, editable: true, defaultValue: null, alias: idUser, type: esriFieldTypeInteger )
• alternateemail ( modelName: alternateemail, nullable: true, editable: true, defaultValue: null, length: 128, alias: alternateEmail, type: esriFieldTypeString )
• firstname ( modelName: firstname, nullable: true, editable: true, defaultValue: null, length: 64, alias: firstName, type: esriFieldTypeString )
• lastname ( modelName: lastname, nullable: true, editable: true, defaultValue: null, length: 64, alias: lastName, type: esriFieldTypeString )
• title1 ( modelName: title1, nullable: true, editable: true, defaultValue: null, length: 128, alias: title, type: esriFieldTypeString )
• title2 ( modelName: title2, nullable: true, editable: true, defaultValue: null, length: 128, alias: title, type: esriFieldTypeString )
• requireprofessionallicense ( modelName: requireprofessionallicense, nullable: true, editable: true, defaultValue: null, alias: requireProfessionalLicense, type: esriFieldTypeSmallInteger )
• licensenumber ( modelName: licensenumber, nullable: true, editable: true, defaultValue: null, length: 128, alias: licenseNumber, type: esriFieldTypeString )
• licensestate ( modelName: licensestate, nullable: true, editable: true, defaultValue: null, length: 8, alias: licenseState, type: esriFieldTypeString )
• companyname ( modelName: companyname, nullable: true, editable: true, defaultValue: null, length: 128, alias: companyName, type: esriFieldTypeString )
• licensestatus ( modelName: licensestatus, nullable: true, editable: true, defaultValue: null, length: 128, alias: licenseStatus, type: esriFieldTypeString )
• islicenseactive ( modelName: islicenseactive, nullable: true, editable: true, defaultValue: null, alias: isLicenseActive, type: esriFieldTypeSmallInteger )
• expirationdate ( modelName: expirationdate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: expirationDate, type: esriFieldTypeDate )
• modifieddate ( modelName: modifieddate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: modifiedDate, type: esriFieldTypeDate )
• licensepin ( modelName: licensepin, nullable: true, editable: true, defaultValue: null, alias: licensePin, type: esriFieldTypeInteger )
• ts_from ( modelName: ts_from, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: TS_FROM, type: esriFieldTypeDate )
• requirevalidation ( modelName: requirevalidation, nullable: true, editable: true, defaultValue: null, alias: requireValidation, type: esriFieldTypeSmallInteger )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: GlobalID )

Templates:

• Name: Contacts
  Description:
  Prototype:
  isvalidated: null
  isself: null
  licensenumber: null
  iduser: null
  firstname: null
  inform: null
  idprofessionallicense: null
  alternateemail: null
  licensepin: null
  city: null
  isactive: null
  licensestate: null
  idproject: null
  projectassociationstatus: null
  modifieddate: null
  ts_from: null
  profilename: null
  streetaddress: null
  company: null
  state: null
  fax: null
  email: null
  islicenseactive: null
  zip: null
  idcreator: null
  title1: null
  dateend: null
  title2: null
  expirationdate: null
  isprimary: null
  idprofilelineage: null
  lastname: null
  datestart: null
  unit: null
  licensestatus: null
  phone: null
  companyname: null
  isremoved: null
  requirevalidation: null
  requireprofessionallicense: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• BusinessLicenseFeeWaivers (16) -- Related To: BusinessLicenseFeeWaivers (26)
• CodeEnforcementCases (20) -- Related To: CodeEnforcementCases (18)
• BuildingPermits (4) -- Related To: BuildingPermits (4)
• Complaints (22) -- Related To: Complaints (24)
• BusinessLicenseEnforcements (15) -- Related To: BusinessLicenseEnforcements (25)
• RightOfWayImprovementPermits (25) -- Related To: RightOfWayImprovementPermits (8)
• BusinessLicense (11) -- Related To: BusinessLicense (7)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Related Records   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata