Layers:

Layer: Certificate_of_Compliance_Asset_List (0)

Name: Certificate_of_Compliance_Asset_List

Display Field: firm_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 5.6843418860808015E-14
YMin: 5.6843418860808015E-14
XMax: 5.6843418860808015E-14
YMax: 5.6843418860808015E-14
Spatial Reference: 4326  (4326)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [145, 95, 30, 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: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: ObjectID )
• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• business_number ( type: esriFieldTypeString, alias: Business Account Number:, length: 255 )
• firm_name ( type: esriFieldTypeString, alias: Legal Name of Firm/Agency:, length: 255 )
• status_num ( type: esriFieldTypeInteger, alias: status number )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• email ( type: esriFieldTypeString, alias: email, length: 255 )

Relationships:

• DBO.ComplianceAssets (0) -- Related To: ComplianceAssets (3)

Layer: Compliance_Form (1)

Name: Compliance_Form

Display Field: firm_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 5.6843418860808015E-14
YMin: 5.6843418860808015E-14
XMax: 5.6843418860808015E-14
YMax: 5.6843418860808015E-14
Spatial Reference: 4326  (4326)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [137, 57, 96, 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: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: ObjectID )
• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• firm_name ( type: esriFieldTypeString, alias: Legal Name of Firm/Agency:, length: 255 )
• firm_struct ( type: esriFieldTypeString, alias: Business Structure:, length: 255 )
• firm_phone ( type: esriFieldTypeString, alias: Phone:, length: 255 )
• firm_url ( type: esriFieldTypeString, alias: Website:, length: 255 )
• phys_address ( type: esriFieldTypeString, alias: Address:, length: 255 )
• phys_suite ( type: esriFieldTypeString, alias: Suite:, length: 255 )
• phys_city ( type: esriFieldTypeString, alias: City:, length: 255 )
• phys_state ( type: esriFieldTypeString, alias: State:, length: 255 )
• phys_zip ( type: esriFieldTypeString, alias: Zip:, length: 255 )
• same_add ( type: esriFieldTypeString, alias: Is the Physical Address the same as your mailing?, length: 255 )
• mail_address ( type: esriFieldTypeString, alias: Address:, length: 255 )
• mail_suite ( type: esriFieldTypeString, alias: Suite:, length: 255 )
• mail_city ( type: esriFieldTypeString, alias: City:, length: 255 )
• mail_state ( type: esriFieldTypeString, alias: State:, length: 255 )
• mail_zip ( type: esriFieldTypeString, alias: Zip:, length: 255 )
• title1 ( type: esriFieldTypeString, alias: Title:, length: 255 )
• firstname1 ( type: esriFieldTypeString, alias: First Name:, length: 255 )
• lastname1 ( type: esriFieldTypeString, alias: Last Name:, length: 255 )
• contact_phone1 ( type: esriFieldTypeString, alias: Phone:, length: 255 )
• contact_email1 ( type: esriFieldTypeString, alias: Email:, length: 255 )
• title2 ( type: esriFieldTypeString, alias: Alternative Contact Title:, length: 255 )
• firstname2 ( type: esriFieldTypeString, alias: Alternative Contact First Name:, length: 255 )
• lastname2 ( type: esriFieldTypeString, alias: Alternative Contact Last Name:, length: 255 )
• contact_phone2 ( type: esriFieldTypeString, alias: Alternative Contact Phone:, length: 255 )
• contact_email2 ( type: esriFieldTypeString, alias: Alternative Contact Email:, length: 255 )
• primary_activities ( type: esriFieldTypeString, alias: Please provide a description of your firm's/agency's primary activities and services or products:, length: 255 )
• jackson_residency ( type: esriFieldTypeString, alias: Is this firm/agency located in Jackson County:, length: 255 )
• jackson_taxroll ( type: esriFieldTypeString, alias: Firm/agency is on Jackson County Tax Roll:, length: 255 )
• recent_contract ( type: esriFieldTypeString, alias: Has your Firm/Agency held a contract with Jackson County within the last 3 years?, length: 255 )
• minority_city ( type: esriFieldTypeString, alias: City of Kansas City, Missouri:, length: 255 )
• minority_state ( type: esriFieldTypeString, alias: State of Missouri:, length: 255 )
• minority_other ( type: esriFieldTypeString, alias: Other:, length: 255 )
• women_city ( type: esriFieldTypeString, alias: City of Kansas City, Missouri:, length: 255 )
• women_state ( type: esriFieldTypeString, alias: State of Missouri:, length: 255 )
• woment_other ( type: esriFieldTypeString, alias: Other:, length: 255 )
• veteran_cert ( type: esriFieldTypeString, alias: Veteran Business Enterprise certification:, length: 255 )
• veteran_authorities ( type: esriFieldTypeString, alias: If yes, please list the issuing authority, length: 255 )
• app_type ( type: esriFieldTypeString, alias: What type of application is this?, length: 255 )
• pending_deadline ( type: esriFieldTypeDate, alias: Is there a pending deadline to have this issued by?, length: 8, precision: 1 )
• true_statement1 ( type: esriFieldTypeString, alias: By entering your name you attest this is a true statement:, length: 255 )
• true_statement2 ( type: esriFieldTypeString, alias: By entering your name you attest this is a true statement:, length: 255 )
• Total_employees ( type: esriFieldTypeString, alias: Total Number of Employees, length: 255 )
• self_identify ( type: esriFieldTypeString, alias: Do you ask your employees to voluntarily self-identify in the areas of race, ethnicity, gender identity and sexual orientation?, length: 255 )
• minority_percent ( type: esriFieldTypeDouble, alias: Minority )
• women_percent ( type: esriFieldTypeDouble, alias: women )
• lgbtq_percent ( type: esriFieldTypeDouble, alias: LGBTQ )
• veteran_percent ( type: esriFieldTypeDouble, alias: Veteran )
• app_prep_title ( type: esriFieldTypeString, alias: Application Preparer's Title:, length: 255 )
• app_prep_name ( type: esriFieldTypeString, alias: Application Preparer's Name:, length: 255 )
• collections1 ( type: esriFieldTypeString, alias: Were taxes paid:, length: 255 )
• assessment1_notes ( type: esriFieldTypeString, alias: Assessment Notes:, length: 255 )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, length: 8, precision: 1 )
• Creator ( type: esriFieldTypeString, alias: Creator, length: 128 )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, length: 8, precision: 1 )
• Editor ( type: esriFieldTypeString, alias: Editor, length: 128 )
• send_assessment ( type: esriFieldTypeString, alias: Does this need to be sent to the Assessment Department?, length: 256 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• business_number ( type: esriFieldTypeString, alias: business_number, length: 255 )
• multiple_number ( type: esriFieldTypeString, alias: multiple_number, length: 255 )
• status_num ( type: esriFieldTypeString, alias: status_num, length: 255 )
• taxes_owed ( type: esriFieldTypeDouble, alias: taxes_owed )
• account_creation ( type: esriFieldTypeString, alias: account_creation, length: 255 )
• assets_updated ( type: esriFieldTypeString, alias: assets_updated, length: 255 )
• multi_accounts ( type: esriFieldTypeString, alias: Multiple Accounts, length: 255 )
• auditors_notes ( type: esriFieldTypeString, alias: auditors_notes, length: 255 )
• auditor_reviewed ( type: esriFieldTypeString, alias: auditor_reviewed, length: 255 )
• account_needed ( type: esriFieldTypeString, alias: account_needed, length: 255 )

Tables:

Table: ComplianceAssets (3)

Name: ComplianceAssets

Display Field: OBJECTID

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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: false
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: true
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: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• parglobal ( type: esriFieldTypeGUID, alias: parglobal, length: 38 )
• item_name ( type: esriFieldTypeString, alias: item_name, length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• purchase_year ( type: esriFieldTypeDate, alias: purchase_year, length: 8 )
• purchase_price ( type: esriFieldTypeDouble, alias: purchase_price )
• item_loc ( type: esriFieldTypeString, alias: item_loc, length: 255 )
• business_number1 ( type: esriFieldTypeString, alias: business_number1, length: 255 )

Relationships:

• DBO.Certificate_of_Compliance_Asset_List (0) -- Related To: Certificate_of_Compliance_Asset_List (0)