Layers:

Layer: ElementsXS.DBO.CompletedFoodServiceInspections (0)

Name: ElementsXS.DBO.CompletedFoodServiceInspections

Display Field: CompletedByFirstName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

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: -85.87363433799999
YMin: 41.238765717000035
XMax: -85.87363433799999
YMax: 41.238765717000035
Spatial Reference: 4326  (4326)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 0, 0, 0]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label:
Description:
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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• TaskID ( type: esriFieldTypeOID, alias: TaskID )
• ServiceOrderDetailID ( type: esriFieldTypeInteger, alias: ServiceOrderDetailID )
• CreatedByID ( type: esriFieldTypeInteger, alias: CreatedByID )
• DateCreated ( type: esriFieldTypeDate, alias: DateCreated, length: 8 )
• ScheduledStartDate ( type: esriFieldTypeDate, alias: ScheduledStartDate, length: 8 )
• ScheduledEndDate ( type: esriFieldTypeDate, alias: ScheduledEndDate, length: 8 )
• ActualStartDate ( type: esriFieldTypeDate, alias: ActualStartDate, length: 8 )
• ActualEndDate ( type: esriFieldTypeDate, alias: ActualEndDate, length: 8 )
• Priority ( type: esriFieldTypeString, alias: Priority, length: 50 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 )
• TaskType ( type: esriFieldTypeString, alias: TaskType, length: 50 )
• Completed ( type: esriFieldTypeSmallInteger, alias: Completed )
• IsWorkItemType ( type: esriFieldTypeSmallInteger, alias: IsWorkItemType )
• ServiceOrderNumber ( type: esriFieldTypeString, alias: ServiceOrderNumber, length: 50 )
• ServiceOrderID ( type: esriFieldTypeInteger, alias: ServiceOrderID )
• IsLocation ( type: esriFieldTypeSmallInteger, alias: IsLocation )
• LocationID ( type: esriFieldTypeString, alias: LocationID, length: 250 )
• LocationNo ( type: esriFieldTypeString, alias: LocationNo, length: 50 )
• Location ( type: esriFieldTypeString, alias: Location, length: 250 )
• IsCustomer ( type: esriFieldTypeSmallInteger, alias: IsCustomer )
• CustomerID ( type: esriFieldTypeString, alias: CustomerID, length: 250 )
• CustomerNo ( type: esriFieldTypeString, alias: CustomerNo, length: 50 )
• Customer ( type: esriFieldTypeString, alias: Customer, length: 250 )
• IsService ( type: esriFieldTypeSmallInteger, alias: IsService )
• ServiceID ( type: esriFieldTypeString, alias: ServiceID, length: 250 )
• Service ( type: esriFieldTypeString, alias: Service, length: 50 )
• IsMeter ( type: esriFieldTypeSmallInteger, alias: IsMeter )
• MeterID ( type: esriFieldTypeString, alias: MeterID, length: 250 )
• MeterNo ( type: esriFieldTypeString, alias: MeterNo, length: 50 )
• IsGISAsset ( type: esriFieldTypeSmallInteger, alias: IsGISAsset )
• GISFileID ( type: esriFieldTypeInteger, alias: GISFileID )
• GISLayer ( type: esriFieldTypeString, alias: GISLayer, length: 50 )
• IsAsset ( type: esriFieldTypeSmallInteger, alias: IsAsset )
• SchemaDocGuid ( type: esriFieldTypeGUID, alias: SchemaDocGuid, length: 38 )
• UtilityBillingServiceCodeTypeID ( type: esriFieldTypeInteger, alias: UtilityBillingServiceCodeTypeID )
• IsUtilityBillingServiceOrder ( type: esriFieldTypeSmallInteger, alias: IsUtilityBillingServiceOrder )
• FeePosted ( type: esriFieldTypeSmallInteger, alias: FeePosted )
• PriorityColor ( type: esriFieldTypeString, alias: PriorityColor, length: 50 )
• FeeAmount ( type: esriFieldTypeDouble, alias: FeeAmount )
• BillToAccount ( type: esriFieldTypeString, alias: BillToAccount, length: 250 )
• CompletedByFirstName ( type: esriFieldTypeString, alias: CompletedByFirstName, length: 50 )
• CompletedByLast ( type: esriFieldTypeString, alias: CompletedByLast, length: 50 )
• LastModifiedByID ( type: esriFieldTypeInteger, alias: LastModifiedByID )
• LastModified ( type: esriFieldTypeDate, alias: LastModified, length: 8 )
• PriorityID ( type: esriFieldTypeInteger, alias: PriorityID )
• StatusID ( type: esriFieldTypeInteger, alias: StatusID )
• TaskTypeID ( type: esriFieldTypeInteger, alias: TaskTypeID )
• ServiceOrderDetailTypeID ( type: esriFieldTypeInteger, alias: ServiceOrderDetailTypeID )
• LOC_Address ( type: esriFieldTypeString, alias: LOC_Address, length: 500 )
• LOC_City ( type: esriFieldTypeString, alias: LOC_City, length: 500 )
• CUST_Name ( type: esriFieldTypeString, alias: CUST_Name, length: 500 )
• GIS_AssetTag ( type: esriFieldTypeString, alias: GIS_AssetTag, length: 500 )
• AssetNo ( type: esriFieldTypeInteger, alias: AssetNo )
• ASSET_AssetTag ( type: esriFieldTypeString, alias: ASSET_AssetTag, length: 500 )
• GeoShape ( type: esriFieldTypeGeometry, alias: GeoShape )
• AssetID ( type: esriFieldTypeString, alias: AssetID, length: 50 )
• AssetLocation ( type: esriFieldTypeString, alias: AssetLocation, length: 1073741822 )
• AssetStatus ( type: esriFieldTypeString, alias: AssetStatus, length: 50 )
• AssetType ( type: esriFieldTypeString, alias: AssetType, length: 50 )
• TaskAssignmentCrews ( type: esriFieldTypeString, alias: TaskAssignmentCrews, length: 1073741822 )
• TaskAssignmentUsers ( type: esriFieldTypeString, alias: TaskAssignmentUsers, length: 1073741822 )
• TaskAssignmentContacts ( type: esriFieldTypeString, alias: TaskAssignmentContacts, length: 1073741822 )
• GISAssetNo ( type: esriFieldTypeString, alias: GISAssetNo, length: 250 )
• DivisionID ( type: esriFieldTypeInteger, alias: DivisionID )
• Expr1 ( type: esriFieldTypeInteger, alias: Expr1 )
• NoteCount ( type: esriFieldTypeInteger, alias: NoteCount )
• Division ( type: esriFieldTypeString, alias: Division, length: 250 )
• Problem ( type: esriFieldTypeString, alias: Problem, length: 1073741822 )
• ResourcesCount ( type: esriFieldTypeInteger, alias: ResourcesCount )
• ServiceOrderCategory ( type: esriFieldTypeString, alias: ServiceOrderCategory, length: 50 )
• ServiceOrderDescription ( type: esriFieldTypeString, alias: ServiceOrderDescription, length: 1073741822 )
• Type ( type: esriFieldTypeString, alias: Type, length: 150 )
• Resolution ( type: esriFieldTypeString, alias: Resolution, length: 1073741822 )
• Total_Labor_Hours ( type: esriFieldTypeDouble, alias: Total_Labor_Hours )
• Total_Labor_Cost ( type: esriFieldTypeDouble, alias: Total_Labor_Cost )
• Total_Inventory_fCost ( type: esriFieldTypeDouble, alias: Total_Inventory_fCost )
• InitialResponseByFirstName ( type: esriFieldTypeString, alias: InitialResponseByFirstName, length: 50 )
• InitialResponseByLastName ( type: esriFieldTypeString, alias: InitialResponseByLastName, length: 50 )
• WorkCompletedByFirstName ( type: esriFieldTypeString, alias: WorkCompletedByFirstName, length: 50 )
• WorkCompletedByLastName ( type: esriFieldTypeString, alias: WorkCompletedByLastName, length: 50 )
• AdminCompletedByFirstName ( type: esriFieldTypeString, alias: AdminCompletedByFirstName, length: 50 )
• AdminCompletedByLastName ( type: esriFieldTypeString, alias: AdminCompletedByLastName, length: 50 )
• CreatedByFirstName ( type: esriFieldTypeString, alias: CreatedByFirstName, length: 50 )
• CreatedByLastName ( type: esriFieldTypeString, alias: CreatedByLastName, length: 50 )
• IsFacility ( type: esriFieldTypeSmallInteger, alias: IsFacility )
• FacilityID ( type: esriFieldTypeInteger, alias: FacilityID )
• Facility ( type: esriFieldTypeString, alias: Facility, length: 250 )
• Facility_Full_Location ( type: esriFieldTypeString, alias: Facility_Full_Location, length: 1073741822 )

Layer: Completed Yearly Inspection (1)

Name: Completed Yearly Inspection

Display Field: cityofwarsaw_sde.DBO.FoodEstablishments.NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: false

Supports Statistics: false

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: -85.88099405998797
YMin: 41.22698215196253
XMax: -85.79473285774816
YMax: 41.280259511963045
Spatial Reference: 4326  (4326)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: ElementsXS.DBO.%CompletedFoodServiceInspections_1.Completed
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
Default Label:
UniqueValueInfos:
• Value: 1
  Label: 1
  Description:
  Symbol:
  
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: false
Supports OrderBy: false
Supports Distinct: false
Supports Pagination: false
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: false
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• cityofwarsaw_sde.DBO.FoodEstablishments.OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• cityofwarsaw_sde.DBO.FoodEstablishments.LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 50 )
• cityofwarsaw_sde.DBO.FoodEstablishments.PROVAL_KEY ( type: esriFieldTypeString, alias: PROVAL_KEY, length: 20 )
• cityofwarsaw_sde.DBO.FoodEstablishments.NAME ( type: esriFieldTypeString, alias: NAME, length: 254 )
• cityofwarsaw_sde.DBO.FoodEstablishments.Intercepto ( type: esriFieldTypeString, alias: Intercepto, length: 254 )
• cityofwarsaw_sde.DBO.FoodEstablishments.Pumping_co ( type: esriFieldTypeString, alias: Pumping_co, length: 254 )
• cityofwarsaw_sde.DBO.FoodEstablishments.Pumping_Cl ( type: esriFieldTypeString, alias: Pumping_Cl, length: 254 )
• cityofwarsaw_sde.DBO.FoodEstablishments.Contact ( type: esriFieldTypeString, alias: Contact, length: 254 )
• cityofwarsaw_sde.DBO.FoodEstablishments.Phone ( type: esriFieldTypeString, alias: Phone, length: 254 )
• cityofwarsaw_sde.DBO.FoodEstablishments.email ( type: esriFieldTypeString, alias: email, length: 254 )
• cityofwarsaw_sde.DBO.FoodEstablishments.Last_Clean ( type: esriFieldTypeDate, alias: Last_Clean, length: 8 )
• cityofwarsaw_sde.DBO.FoodEstablishments.CONTACT_1 ( type: esriFieldTypeString, alias: CONTACT_1, length: 254 )
• cityofwarsaw_sde.DBO.FoodEstablishments.Shape ( type: esriFieldTypeGeometry, alias: Shape )
• DBO.%CompletedFoodServiceInspections_1.TaskID ( type: esriFieldTypeInteger, alias: DBO.%CompletedFoodServiceInspections_1.TaskID )
• DBO.%CompletedFoodServiceInspections_1.ServiceOrderDetailID ( type: esriFieldTypeInteger, alias: DBO.%CompletedFoodServiceInspections_1.ServiceOrderDetailID )
• DBO.%CompletedFoodServiceInspections_1.CreatedByID ( type: esriFieldTypeInteger, alias: DBO.%CompletedFoodServiceInspections_1.CreatedByID )
• DBO.%CompletedFoodServiceInspections_1.DateCreated ( type: esriFieldTypeDate, alias: DBO.%CompletedFoodServiceInspections_1.DateCreated, length: 8 )
• DBO.%CompletedFoodServiceInspections_1.ScheduledStartDate ( type: esriFieldTypeDate, alias: DBO.%CompletedFoodServiceInspections_1.ScheduledStartDate, length: 8 )
• DBO.%CompletedFoodServiceInspections_1.ScheduledEndDate ( type: esriFieldTypeDate, alias: DBO.%CompletedFoodServiceInspections_1.ScheduledEndDate, length: 8 )
• DBO.%CompletedFoodServiceInspections_1.ActualStartDate ( type: esriFieldTypeDate, alias: DBO.%CompletedFoodServiceInspections_1.ActualStartDate, length: 8 )
• DBO.%CompletedFoodServiceInspections_1.ActualEndDate ( type: esriFieldTypeDate, alias: DBO.%CompletedFoodServiceInspections_1.ActualEndDate, length: 8 )
• DBO.%CompletedFoodServiceInspections_1.Priority ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.Priority, length: 50 )
• DBO.%CompletedFoodServiceInspections_1.Status ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.Status, length: 50 )
• DBO.%CompletedFoodServiceInspections_1.TaskType ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.TaskType, length: 50 )
• DBO.%CompletedFoodServiceInspections_1.Completed ( type: esriFieldTypeSmallInteger, alias: DBO.%CompletedFoodServiceInspections_1.Completed )
• DBO.%CompletedFoodServiceInspections_1.IsWorkItemType ( type: esriFieldTypeSmallInteger, alias: DBO.%CompletedFoodServiceInspections_1.IsWorkItemType )
• DBO.%CompletedFoodServiceInspections_1.ServiceOrderNumber ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.ServiceOrderNumber, length: 50 )
• DBO.%CompletedFoodServiceInspections_1.ServiceOrderID ( type: esriFieldTypeInteger, alias: DBO.%CompletedFoodServiceInspections_1.ServiceOrderID )
• DBO.%CompletedFoodServiceInspections_1.IsLocation ( type: esriFieldTypeSmallInteger, alias: DBO.%CompletedFoodServiceInspections_1.IsLocation )
• DBO.%CompletedFoodServiceInspections_1.LocationID ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.LocationID, length: 250 )
• DBO.%CompletedFoodServiceInspections_1.LocationNo ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.LocationNo, length: 50 )
• DBO.%CompletedFoodServiceInspections_1.Location ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.Location, length: 250 )
• DBO.%CompletedFoodServiceInspections_1.IsCustomer ( type: esriFieldTypeSmallInteger, alias: DBO.%CompletedFoodServiceInspections_1.IsCustomer )
• DBO.%CompletedFoodServiceInspections_1.CustomerID ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.CustomerID, length: 250 )
• DBO.%CompletedFoodServiceInspections_1.CustomerNo ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.CustomerNo, length: 50 )
• DBO.%CompletedFoodServiceInspections_1.Customer ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.Customer, length: 250 )
• DBO.%CompletedFoodServiceInspections_1.IsService ( type: esriFieldTypeSmallInteger, alias: DBO.%CompletedFoodServiceInspections_1.IsService )
• DBO.%CompletedFoodServiceInspections_1.ServiceID ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.ServiceID, length: 250 )
• DBO.%CompletedFoodServiceInspections_1.Service ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.Service, length: 50 )
• DBO.%CompletedFoodServiceInspections_1.IsMeter ( type: esriFieldTypeSmallInteger, alias: DBO.%CompletedFoodServiceInspections_1.IsMeter )
• DBO.%CompletedFoodServiceInspections_1.MeterID ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.MeterID, length: 250 )
• DBO.%CompletedFoodServiceInspections_1.MeterNo ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.MeterNo, length: 50 )
• DBO.%CompletedFoodServiceInspections_1.IsGISAsset ( type: esriFieldTypeSmallInteger, alias: DBO.%CompletedFoodServiceInspections_1.IsGISAsset )
• DBO.%CompletedFoodServiceInspections_1.GISFileID ( type: esriFieldTypeInteger, alias: DBO.%CompletedFoodServiceInspections_1.GISFileID )
• DBO.%CompletedFoodServiceInspections_1.GISLayer ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.GISLayer, length: 50 )
• DBO.%CompletedFoodServiceInspections_1.IsAsset ( type: esriFieldTypeSmallInteger, alias: DBO.%CompletedFoodServiceInspections_1.IsAsset )
• DBO.%CompletedFoodServiceInspections_1.SchemaDocGuid ( type: esriFieldTypeGUID, alias: DBO.%CompletedFoodServiceInspections_1.SchemaDocGuid, length: 38 )
• DBO.%CompletedFoodServiceInspections_1.UtilityBillingServiceCodeTypeID ( type: esriFieldTypeInteger, alias: DBO.%CompletedFoodServiceInspections_1.UtilityBillingServiceCodeTypeID )
• DBO.%CompletedFoodServiceInspections_1.IsUtilityBillingServiceOrder ( type: esriFieldTypeSmallInteger, alias: DBO.%CompletedFoodServiceInspections_1.IsUtilityBillingServiceOrder )
• DBO.%CompletedFoodServiceInspections_1.FeePosted ( type: esriFieldTypeSmallInteger, alias: DBO.%CompletedFoodServiceInspections_1.FeePosted )
• DBO.%CompletedFoodServiceInspections_1.PriorityColor ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.PriorityColor, length: 50 )
• DBO.%CompletedFoodServiceInspections_1.FeeAmount ( type: esriFieldTypeDouble, alias: DBO.%CompletedFoodServiceInspections_1.FeeAmount )
• DBO.%CompletedFoodServiceInspections_1.BillToAccount ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.BillToAccount, length: 250 )
• DBO.%CompletedFoodServiceInspections_1.CompletedByFirstName ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.CompletedByFirstName, length: 50 )
• DBO.%CompletedFoodServiceInspections_1.CompletedByLast ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.CompletedByLast, length: 50 )
• DBO.%CompletedFoodServiceInspections_1.LastModifiedByID ( type: esriFieldTypeInteger, alias: DBO.%CompletedFoodServiceInspections_1.LastModifiedByID )
• DBO.%CompletedFoodServiceInspections_1.LastModified ( type: esriFieldTypeDate, alias: DBO.%CompletedFoodServiceInspections_1.LastModified, length: 8 )
• DBO.%CompletedFoodServiceInspections_1.PriorityID ( type: esriFieldTypeInteger, alias: DBO.%CompletedFoodServiceInspections_1.PriorityID )
• DBO.%CompletedFoodServiceInspections_1.StatusID ( type: esriFieldTypeInteger, alias: DBO.%CompletedFoodServiceInspections_1.StatusID )
• DBO.%CompletedFoodServiceInspections_1.TaskTypeID ( type: esriFieldTypeInteger, alias: DBO.%CompletedFoodServiceInspections_1.TaskTypeID )
• DBO.%CompletedFoodServiceInspections_1.ServiceOrderDetailTypeID ( type: esriFieldTypeInteger, alias: DBO.%CompletedFoodServiceInspections_1.ServiceOrderDetailTypeID )
• DBO.%CompletedFoodServiceInspections_1.LOC_Address ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.LOC_Address, length: 500 )
• DBO.%CompletedFoodServiceInspections_1.LOC_City ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.LOC_City, length: 500 )
• DBO.%CompletedFoodServiceInspections_1.CUST_Name ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.CUST_Name, length: 500 )
• DBO.%CompletedFoodServiceInspections_1.GIS_AssetTag ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.GIS_AssetTag, length: 500 )
• DBO.%CompletedFoodServiceInspections_1.AssetNo ( type: esriFieldTypeInteger, alias: DBO.%CompletedFoodServiceInspections_1.AssetNo )
• DBO.%CompletedFoodServiceInspections_1.ASSET_AssetTag ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.ASSET_AssetTag, length: 500 )
• DBO.%CompletedFoodServiceInspections_1.AssetID ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.AssetID, length: 50 )
• DBO.%CompletedFoodServiceInspections_1.AssetLocation ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.AssetLocation, length: 1073741822 )
• DBO.%CompletedFoodServiceInspections_1.AssetStatus ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.AssetStatus, length: 50 )
• DBO.%CompletedFoodServiceInspections_1.AssetType ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.AssetType, length: 50 )
• DBO.%CompletedFoodServiceInspections_1.TaskAssignmentCrews ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.TaskAssignmentCrews, length: 1073741822 )
• DBO.%CompletedFoodServiceInspections_1.TaskAssignmentUsers ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.TaskAssignmentUsers, length: 1073741822 )
• DBO.%CompletedFoodServiceInspections_1.TaskAssignmentContacts ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.TaskAssignmentContacts, length: 1073741822 )
• DBO.%CompletedFoodServiceInspections_1.GISAssetNo ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.GISAssetNo, length: 250 )
• DBO.%CompletedFoodServiceInspections_1.DivisionID ( type: esriFieldTypeInteger, alias: DBO.%CompletedFoodServiceInspections_1.DivisionID )
• DBO.%CompletedFoodServiceInspections_1.Expr1 ( type: esriFieldTypeInteger, alias: DBO.%CompletedFoodServiceInspections_1.Expr1 )
• DBO.%CompletedFoodServiceInspections_1.NoteCount ( type: esriFieldTypeInteger, alias: DBO.%CompletedFoodServiceInspections_1.NoteCount )
• DBO.%CompletedFoodServiceInspections_1.Division ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.Division, length: 250 )
• DBO.%CompletedFoodServiceInspections_1.Problem ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.Problem, length: 1073741822 )
• DBO.%CompletedFoodServiceInspections_1.ResourcesCount ( type: esriFieldTypeInteger, alias: DBO.%CompletedFoodServiceInspections_1.ResourcesCount )
• DBO.%CompletedFoodServiceInspections_1.ServiceOrderCategory ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.ServiceOrderCategory, length: 50 )
• DBO.%CompletedFoodServiceInspections_1.ServiceOrderDescription ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.ServiceOrderDescription, length: 1073741822 )
• DBO.%CompletedFoodServiceInspections_1.Type ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.Type, length: 150 )
• DBO.%CompletedFoodServiceInspections_1.Resolution ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.Resolution, length: 1073741822 )
• DBO.%CompletedFoodServiceInspections_1.Total_Labor_Hours ( type: esriFieldTypeDouble, alias: DBO.%CompletedFoodServiceInspections_1.Total_Labor_Hours )
• DBO.%CompletedFoodServiceInspections_1.Total_Labor_Cost ( type: esriFieldTypeDouble, alias: DBO.%CompletedFoodServiceInspections_1.Total_Labor_Cost )
• DBO.%CompletedFoodServiceInspections_1.Total_Inventory_fCost ( type: esriFieldTypeDouble, alias: DBO.%CompletedFoodServiceInspections_1.Total_Inventory_fCost )
• DBO.%CompletedFoodServiceInspections_1.InitialResponseByFirstName ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.InitialResponseByFirstName, length: 50 )
• DBO.%CompletedFoodServiceInspections_1.InitialResponseByLastName ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.InitialResponseByLastName, length: 50 )
• DBO.%CompletedFoodServiceInspections_1.WorkCompletedByFirstName ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.WorkCompletedByFirstName, length: 50 )
• DBO.%CompletedFoodServiceInspections_1.WorkCompletedByLastName ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.WorkCompletedByLastName, length: 50 )
• DBO.%CompletedFoodServiceInspections_1.AdminCompletedByFirstName ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.AdminCompletedByFirstName, length: 50 )
• DBO.%CompletedFoodServiceInspections_1.AdminCompletedByLastName ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.AdminCompletedByLastName, length: 50 )
• DBO.%CompletedFoodServiceInspections_1.CreatedByFirstName ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.CreatedByFirstName, length: 50 )
• DBO.%CompletedFoodServiceInspections_1.CreatedByLastName ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.CreatedByLastName, length: 50 )
• DBO.%CompletedFoodServiceInspections_1.IsFacility ( type: esriFieldTypeSmallInteger, alias: DBO.%CompletedFoodServiceInspections_1.IsFacility )
• DBO.%CompletedFoodServiceInspections_1.FacilityID ( type: esriFieldTypeInteger, alias: DBO.%CompletedFoodServiceInspections_1.FacilityID )
• DBO.%CompletedFoodServiceInspections_1.Facility ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.Facility, length: 250 )
• DBO.%CompletedFoodServiceInspections_1.Facility_Full_Location ( type: esriFieldTypeString, alias: DBO.%CompletedFoodServiceInspections_1.Facility_Full_Location, length: 1073741822 )