Layers:

Tables:

OTCEs23_by_BIDs (0)


Name: OTCEs23_by_BIDs

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True


Global ID Field:

Type ID Field:

Fields:
• YEAR (type: esriFieldTypeInteger, alias: YEAR, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• QTR (type: esriFieldTypeInteger, alias: QTR, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• COUNTY_CODE (type: esriFieldTypeInteger, alias: COUNTY.CODE, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• OWNERSHIP_CODE (type: esriFieldTypeInteger, alias: OWNERSHIP.CODE, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• MEEI_CODE (type: esriFieldTypeInteger, alias: MEEI.CODE, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• NAICS_CODE (type: esriFieldTypeInteger, alias: NAICS.CODE, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• EMPLOYER_ACCOUNT_NUMBER (type: esriFieldTypeInteger, alias: EMPLOYER.ACCOUNT.NUMBER, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• REPORTING_UNIT (type: esriFieldTypeInteger, alias: REPORTING.UNIT, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• LEGAL_NAME (type: esriFieldTypeString, alias: LEGAL.NAME, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• TRADE_NAME (type: esriFieldTypeString, alias: TRADE.NAME, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• MAILING_STREET (type: esriFieldTypeString, alias: MAILING.STREET, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• MAILING_CITY (type: esriFieldTypeString, alias: MAILING.CITY, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• MAILING_STATE (type: esriFieldTypeString, alias: MAILING.STATE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• MAILING_ZIP_CODE (type: esriFieldTypeInteger, alias: MAILING.ZIP.CODE, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• PHYSICAL_STREET (type: esriFieldTypeString, alias: PHYSICAL.STREET, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PHYSICAL_CITY (type: esriFieldTypeString, alias: PHYSICAL.CITY, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PHYSICAL_STATE (type: esriFieldTypeString, alias: PHYSICAL.STATE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PHYSICAL_ZIP_CODE (type: esriFieldTypeInteger, alias: PHYSICAL.ZIP.CODE, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• INITIAL_LIABILITY_DATE (type: esriFieldTypeDateOnly, alias: INITIAL.LIABILITY.DATE, SQL Type: sqlTypeDate, nullable: true, editable: true)
• END_LIABILITY_DATE (type: esriFieldTypeString, alias: END.LIABILITY.DATE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• EMPLOYMENT_MONTH_1 (type: esriFieldTypeInteger, alias: EMPLOYMENT.MONTH.1, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• EMPLOYMENT_MONTH_2 (type: esriFieldTypeInteger, alias: EMPLOYMENT.MONTH.2, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• EMPLOYMENT_MONTH_3 (type: esriFieldTypeInteger, alias: EMPLOYMENT.MONTH.3, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• TOTAL_QUARTER_WAGES (type: esriFieldTypeInteger, alias: TOTAL.QUARTER.WAGES, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• REACTIVATION_DATE (type: esriFieldTypeString, alias: REACTIVATION.DATE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• RDATE (type: esriFieldTypeString, alias: RDATE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Concat_Id (type: esriFieldTypeString, alias: Concat_Id, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• FID (type: esriFieldTypeInteger, alias: FID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• BID (type: esriFieldTypeString, alias: BID, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/22/2025 9:16:30 AM

Schema Last Edit Date: 12/22/2025 9:16:30 AM

Data Last Edit Date: 12/22/2025 9:16:30 AM