Name: Business License Table

Display Field: bname

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

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

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
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 ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• original ( type: esriFieldTypeDate, alias: Original Issue Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: original )
• renew ( type: esriFieldTypeDate, alias: Renewal Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: renew )
• expire ( type: esriFieldTypeDate, alias: Expiration Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: expire )
• discontdt ( type: esriFieldTypeDate, alias: Discontinued Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: discontdt )
• VISIONPID ( type: esriFieldTypeDouble, alias: VisionID, editable: true, nullable: true, defaultValue: null, modelName: VISIONPID )
• full_address ( type: esriFieldTypeString, alias: Full Address of Business, editable: true, nullable: true, length: 50, defaultValue: null, modelName: full_address )
• btype ( type: esriFieldTypeString, alias: Business Type, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: btype )
• status_1 ( type: esriFieldTypeInteger, alias: Status, editable: true, nullable: true, defaultValue: null, modelName: status_1 )
• status_str ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 15, defaultValue: Active, modelName: status_str , Coded Values: [Active: Active] , [Inactive: Inactive] )
• notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: notes )
• bname ( type: esriFieldTypeString, alias: Business Name, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: bname )
• bhousenum ( type: esriFieldTypeString, alias: Business Address #, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: bhousenum )
• bstreetname ( type: esriFieldTypeString, alias: Business Street Name, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: bstreetname , Coded Values: [Abbott Avenue: Abbott Avenue] , [Abigail Lane: Abigail Lane] , [Adrian Avenue: Adrian Avenue] , ...534 more... )
• bapt ( type: esriFieldTypeString, alias: Business Apt #, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: bapt )
• bcity ( type: esriFieldTypeString, alias: Business City, editable: true, nullable: true, length: 1073741822, defaultValue: West Springfield, modelName: bcity )
• bstate ( type: esriFieldTypeString, alias: Business State, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: bstate )
• bzip ( type: esriFieldTypeString, alias: Business Zip, editable: true, nullable: true, length: 5, defaultValue: 01089, modelName: bzip )
• bphone ( type: esriFieldTypeString, alias: Business Phone #, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: bphone )
• parentname ( type: esriFieldTypeString, alias: Parent Company Name, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: parentname )
• paddr1 ( type: esriFieldTypeString, alias: Parent Company Address and Street, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: paddr1 )
• paddr2 ( type: esriFieldTypeString, alias: Parent Company Suite #, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: paddr2 )
• pcsz ( type: esriFieldTypeString, alias: Parent Company City, State, Zip, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: pcsz )
• lname1 ( type: esriFieldTypeString, alias: Owner 1 Last Name, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: lname1 )
• fname1 ( type: esriFieldTypeString, alias: Owner 1 First Name, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: fname1 )
• n1housenum ( type: esriFieldTypeString, alias: Owner 1 Address #, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: n1housenum )
• n1streetname ( type: esriFieldTypeString, alias: Owner 1 Street Name, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: n1streetname )
• n1apt ( type: esriFieldTypeString, alias: Owner 1 Apt. #, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: n1apt )
• n1city ( type: esriFieldTypeString, alias: Owner 1 City, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: n1city )
• n1state ( type: esriFieldTypeString, alias: Owner 1 State, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: n1state )
• n1zip ( type: esriFieldTypeString, alias: Owner 1 Zip, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: n1zip )
• n1phone ( type: esriFieldTypeString, alias: Owner 1 Phone, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: n1phone )
• lname2 ( type: esriFieldTypeString, alias: Owner 2 Last Name, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: lname2 )
• fname2 ( type: esriFieldTypeString, alias: Owner 2 First Name, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: fname2 )
• n2housenum ( type: esriFieldTypeString, alias: Owner 2 Address #, editable: true, nullable: true, length: 20, defaultValue: null, modelName: n2housenum )
• n2streetname ( type: esriFieldTypeString, alias: Owner 2 Street Name, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: n2streetname )
• n2apt ( type: esriFieldTypeString, alias: Owner 2 Apt #, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: n2apt )
• n2city ( type: esriFieldTypeString, alias: Owner 2 City, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: n2city )
• n2state ( type: esriFieldTypeString, alias: Owner 2 State, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: n2state )
• n2zip ( type: esriFieldTypeString, alias: Owner 2 Zip, editable: true, nullable: true, length: 5, defaultValue: null, modelName: n2zip )
• n2phone ( type: esriFieldTypeString, alias: Owner 2 Phone, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: n2phone )
• lname3 ( type: esriFieldTypeString, alias: Owner 3 Last Name, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: lname3 )
• fname3 ( type: esriFieldTypeString, alias: Owner 3 First Name, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: fname3 )
• n3housenum ( type: esriFieldTypeInteger, alias: Owner 3 Address #, editable: true, nullable: true, defaultValue: null, modelName: n3housenum )
• n3streetname ( type: esriFieldTypeString, alias: Owner 3 Street Name, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: n3streetname )
• n3apt ( type: esriFieldTypeString, alias: Owner 3 Apt #, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: n3apt )
• n3city ( type: esriFieldTypeString, alias: Owner 3 City, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: n3city )
• n3state ( type: esriFieldTypeString, alias: Owner 3 State, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: n3state )
• n3zip ( type: esriFieldTypeString, alias: Owner 3 Zip, editable: true, nullable: true, length: 5, defaultValue: null, modelName: n3zip )
• n3phone ( type: esriFieldTypeString, alias: Owner 3 Phone, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: n3phone )
• lname4 ( type: esriFieldTypeString, alias: Owner 4 Last Name, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: lname4 )
• fname4 ( type: esriFieldTypeString, alias: Owner 4 First Name, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: fname4 )
• n4housenum ( type: esriFieldTypeString, alias: Owner 4 Address #, editable: true, nullable: true, length: 20, defaultValue: null, modelName: n4housenum )
• n4streetname ( type: esriFieldTypeString, alias: Owner 4 Street Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: n4streetname )
• n4apt ( type: esriFieldTypeString, alias: Owner 4 Apt #, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: n4apt )
• n4city ( type: esriFieldTypeString, alias: Owner 4 City, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: n4city )
• n4st ( type: esriFieldTypeString, alias: Owner 4 State, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: n4st )
• n4zip ( type: esriFieldTypeString, alias: Owner 4 Zip, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: n4zip )
• n4phone ( type: esriFieldTypeString, alias: Owner 4 Phone, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: n4phone )
• id ( type: esriFieldTypeString, alias: softright_id, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: id )
• mailing_label_address ( type: esriFieldTypeString, alias: Send Mailing Label to, editable: true, nullable: true, length: 255, defaultValue: Business Address, modelName: mailing_label_address , Coded Values: [Business Address: Business Address] , [Parent Company Address: Parent Company Address] )
• PIN ( type: esriFieldTypeString, alias: PIN, editable: true, nullable: true, length: 11, defaultValue: null, modelName: PIN )
• MSADD ( type: esriFieldTypeString, alias: MSADD, editable: true, nullable: true, length: 15, defaultValue: null, modelName: MSADD )
• STREET ( type: esriFieldTypeString, alias: STREET, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREET )
• certnum ( type: esriFieldTypeInteger, alias: certnum, editable: true, nullable: true, defaultValue: null, modelName: certnum )
• check_address ( type: esriFieldTypeString, alias: check_address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: check_address , Coded Values: [Yes: Yes] , [No: No] )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: Business License Table
  Description:
  Prototype:
  certnum: null
  check_address: null
  original: null
  renew: null
  expire: null
  discontdt: null
  VISIONPID: null
  full_address: null
  btype: null
  status_1: null
  status_str: Active
  notes: null
  bname: null
  bhousenum: null
  bstreetname: null
  bapt: null
  bcity: West Springfield
  bstate: null
  bzip: 01089
  bphone: null
  parentname: null
  paddr1: null
  paddr2: null
  pcsz: null
  lname1: null
  fname1: null
  n1housenum: null
  n1streetname: null
  n1apt: null
  n1city: null
  n1state: null
  n1zip: null
  n1phone: null
  lname2: null
  fname2: null
  n2housenum: null
  n2streetname: null
  n2apt: null
  n2city: null
  n2state: null
  n2zip: null
  n2phone: null
  lname3: null
  fname3: null
  n3housenum: null
  n3streetname: null
  n3apt: null
  n3city: null
  n3state: null
  n3zip: null
  n3phone: null
  lname4: null
  fname4: null
  n4housenum: null
  n4streetname: null
  n4apt: null
  n4city: null
  n4st: null
  n4zip: null
  n4phone: null
  id: null
  mailing_label_address: Business Address
  PIN: null
  MSADD: null
  STREET: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• WSGISData.DBO.fpgCLKbusinessLicenseParcels (0) -- Related To: Business License Parcels (0)

Capabilities: Query,Create,Update,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:   Field Groups   Contingent Values

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