Name: Corporate Registration

Display Field: BUSINESS_NAME

Type: Table

Geometry Type: N/A

Description: The Department of Licensing and Consumer Protection (DLCP) Business and Professional Licensing Administration Corporations Division serves as the Office of Corporate Registrar for the District of Columbia. This data set contains data related to the following information of a business entity: file number, entity status, locale, model type, business name, suffix, business address, email, effective date, foreign date of organization, next report year, latest report year filed, and latest report date filed. More information can be found at https://dlcp.dc.gov/page/corporations

Copyright Text: Department of Licensing and Consumer Protection

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:

• FILE_NUMBER ( type: esriFieldTypeString, alias: File Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FILE_NUMBER )
• ENTITY_STATUS ( type: esriFieldTypeString, alias: Entity Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ENTITY_STATUS )
• LOCALE ( type: esriFieldTypeString, alias: Locale, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LOCALE )
• MODELTYPE ( type: esriFieldTypeString, alias: Model Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MODELTYPE )
• BUSINESS_NAME ( type: esriFieldTypeString, alias: Business Name, editable: true, nullable: true, length: 300, defaultValue: null, modelName: BUSINESS_NAME )
• BUSNIESS_ADDRESS_LINE1 ( type: esriFieldTypeString, alias: Business Address LIne 1, editable: true, nullable: true, length: 200, defaultValue: null, modelName: BUSNIESS_ADDRESS_LINE1 )
• BUSNIESS_ADDRESS_LINE2 ( type: esriFieldTypeString, alias: Business Address LIne 2, editable: true, nullable: true, length: 100, defaultValue: null, modelName: BUSNIESS_ADDRESS_LINE2 )
• BUSNIESS_ADDRESS_LINE3 ( type: esriFieldTypeString, alias: Business Address LIne 3, editable: true, nullable: true, length: 100, defaultValue: null, modelName: BUSNIESS_ADDRESS_LINE3 )
• BUSNIESS_ADDRESS_LINE4 ( type: esriFieldTypeString, alias: Business Address LIne 4, editable: true, nullable: true, length: 100, defaultValue: null, modelName: BUSNIESS_ADDRESS_LINE4 )
• BUSINESS_CITY ( type: esriFieldTypeString, alias: Business City, editable: true, nullable: true, length: 100, defaultValue: null, modelName: BUSINESS_CITY )
• BUSINESS_STATE ( type: esriFieldTypeString, alias: Business State, editable: true, nullable: true, length: 10, defaultValue: null, modelName: BUSINESS_STATE )
• ZIPCODE ( type: esriFieldTypeString, alias: Zip Code, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ZIPCODE )
• BUSINESS_COUNTRY ( type: esriFieldTypeString, alias: Business Country, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BUSINESS_COUNTRY )
• SUFFIX ( type: esriFieldTypeString, alias: Suffix, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SUFFIX )
• RA_NAME ( type: esriFieldTypeString, alias: RA Name, editable: true, nullable: true, length: 200, defaultValue: null, modelName: RA_NAME )
• RA_ADDRESS1 ( type: esriFieldTypeString, alias: RA Address 1, editable: true, nullable: true, length: 200, defaultValue: null, modelName: RA_ADDRESS1 )
• RA_ADDRESS2 ( type: esriFieldTypeString, alias: RA Address 2, editable: true, nullable: true, length: 200, defaultValue: null, modelName: RA_ADDRESS2 )
• RA_ADDRESS3 ( type: esriFieldTypeString, alias: RA Address 3, editable: true, nullable: true, length: 100, defaultValue: null, modelName: RA_ADDRESS3 )
• RA_ADDRESS4 ( type: esriFieldTypeString, alias: RA Address 4, editable: true, nullable: true, length: 100, defaultValue: null, modelName: RA_ADDRESS4 )
• RA_CITY ( type: esriFieldTypeString, alias: RA CIty, editable: true, nullable: true, length: 100, defaultValue: null, modelName: RA_CITY )
• RA_STATE ( type: esriFieldTypeString, alias: RA State, editable: true, nullable: true, length: 10, defaultValue: null, modelName: RA_STATE )
• RA_ZIPCODE ( type: esriFieldTypeString, alias: RA Zip Code, editable: true, nullable: true, length: 20, defaultValue: null, modelName: RA_ZIPCODE )
• EFFECTIVE_DATE ( type: esriFieldTypeDate, alias: Effective Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EFFECTIVE_DATE )
• FOREIGN_DATEOF_ORGANIZATION ( type: esriFieldTypeDate, alias: Foreign Date Of Organization, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FOREIGN_DATEOF_ORGANIZATION )
• NEXT_REPORTYEAR_DUE ( type: esriFieldTypeString, alias: Next Report Year Due, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NEXT_REPORTYEAR_DUE )
• DCS_LAST_MOD_DTTM ( type: esriFieldTypeDate, alias: Last Modified Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DCS_LAST_MOD_DTTM )
• DATE_LAST_REPORT_FILED ( type: esriFieldTypeDate, alias: Date Last Report Filed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_LAST_REPORT_FILED )
• NEXT_REPORTYEAR ( type: esriFieldTypeString, alias: Next Report Year, editable: true, nullable: true, length: 1, defaultValue: null, modelName: NEXT_REPORTYEAR )
• LATESTFILED_REPORTDATE ( type: esriFieldTypeString, alias: Latest Filed Report Date, editable: true, nullable: true, length: 1, defaultValue: null, modelName: LATESTFILED_REPORTDATE )
• LATESTREPORT_YEARFILED ( type: esriFieldTypeString, alias: Latest Report Year Filed, editable: true, nullable: true, length: 1, defaultValue: null, modelName: LATESTREPORT_YEARFILED )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )

Templates:

• Name: Corporate Registration
  Description:
  Prototype:
  LATESTREPORT_YEARFILED: null
  FILE_NUMBER: null
  ENTITY_STATUS: null
  LOCALE: null
  MODELTYPE: null
  BUSINESS_NAME: null
  BUSNIESS_ADDRESS_LINE1: null
  BUSNIESS_ADDRESS_LINE2: null
  BUSNIESS_ADDRESS_LINE3: null
  BUSNIESS_ADDRESS_LINE4: null
  BUSINESS_CITY: null
  BUSINESS_STATE: null
  ZIPCODE: null
  BUSINESS_COUNTRY: null
  SUFFIX: null
  RA_NAME: null
  RA_ADDRESS1: null
  RA_ADDRESS2: null
  RA_ADDRESS3: null
  RA_ADDRESS4: null
  RA_CITY: null
  RA_STATE: null
  RA_ZIPCODE: null
  EFFECTIVE_DATE: null
  FOREIGN_DATEOF_ORGANIZATION: null
  NEXT_REPORTYEAR_DUE: null
  DCS_LAST_MOD_DTTM: null
  DATE_LAST_REPORT_FILED: null
  NEXT_REPORTYEAR: null
  LATESTFILED_REPORTDATE: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

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