Layers:

Layer: InspectionSites (0)

Name: InspectionSites

Display Field: Company_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 3000000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: -1.0614573151280513E7
YMin: 5.664923641290895E-9
XMax: 7871945.992248241
YMax: 5147341.141325982
Spatial Reference: 102100  (3857)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [115, 223, 255, 255]
Size: 5.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• 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 )
• created_user ( type: esriFieldTypeString, alias: Created By, 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 By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Operator_Name ( type: esriFieldTypeString, alias: Operator Name, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Operator_Name )
• Operator_Phone ( type: esriFieldTypeDouble, alias: Operator Phone, editable: true, nullable: true, defaultValue: null, modelName: Operator_Phone )
• Operator_Email ( type: esriFieldTypeString, alias: Operator Email, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: Operator_Email )
• Company_Name ( type: esriFieldTypeString, alias: Company Name, editable: true, nullable: false, length: 200, defaultValue: null, modelName: Company_Name )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: false, length: 200, defaultValue: null, modelName: Address )
• City ( type: esriFieldTypeString, alias: City, editable: true, nullable: false, length: 200, defaultValue: null, modelName: City , Coded Values: [Bellevue: Bellevue] , [Huron: Huron] , [Sandusky: Sandusky] , ...11 more... )
• State ( type: esriFieldTypeString, alias: State, editable: true, nullable: false, length: 200, defaultValue: OH, modelName: State , Coded Values: [AL: Alabama] , [AK: Alaska] , [AZ: Arizona] , ...48 more... )
• Zip ( type: esriFieldTypeInteger, alias: Zip, editable: true, nullable: false, defaultValue: null, modelName: Zip , Coded Values: [43438: 43438] , [43464: 43464] , [44089: 44089] , ...9 more... )
• County ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 200, defaultValue: Erie, modelName: County )
• Type_of_Device ( type: esriFieldTypeString, alias: Type of Device, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Type_of_Device , Coded Values: [Computing Scale: Computing Scale] , [Counter/Bench Scale/Non-computing ≤ 500 lbs.: Counter/Bench Scale/Non-computing ≤ 500 lbs.] , [Platform/Floor Scale ≤ 5000 lbs.: Platform/Floor Scale ≤ 5000 lbs.] , ...28 more... )
• Phone ( type: esriFieldTypeString, alias: Phone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Phone )
• SiteType ( type: esriFieldTypeString, alias: Site Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SiteType , Coded Values: [Supermarket: Supermarket] , [Gas/Fuel Station: Gas/Fuel Station] , [Convenience Store: Convenience Store] , ...17 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Comments )
Templates:
• Name: InspectionSites
  Description:
  Prototype:
  Company_Name:
  Zip: 0
  Address:
  State: OH
  City:
  County: Erie
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• HopperScaleTest (0) -- Related To: HopperScaleTest (6)
• ReinspectionOrRepairs (1) -- Related To: ReinspectionOrRepairs (16)
• massFlowMeterTest (2) -- Related To: massFlowMeterTest (10)
• ScaleTests (3) -- Related To: ScaleTests (19)
• priceVerificationTest (4) -- Related To: priceVerificationTest (13)
• ObservedTests (5) -- Related To: ObservedTests (11)
• PumpTests (6) -- Related To: PumpTests (15)
• skimmerCheck (7) -- Related To: skimmerCheck (20)
• ComplaintsReceived (8) -- Related To: ComplaintsReceived (3)
• AuditPackTest (9) -- Related To: AuditPackTest (2)
• loadingRackTest (10) -- Related To: loadingRackTest (8)
• vehicleScaleTest (11) -- Related To: vehicleScaleTest (27)

Tables:

Table: AuditPackSubtest (1)

Name: AuditPackSubtest

Display Field: productDescription

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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


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 )
• Guid ( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: Created By, 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 By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• productDescription ( type: esriFieldTypeString, alias: Product Desc., Lot Code, Unit Price, editable: true, nullable: false, length: 50, defaultValue: null, modelName: productDescription , Coded Values: [Meat: Meat] , [Produce: Produce] , [Feed/Seed: Feed/Seed] , ...1 more... )
• tare ( type: esriFieldTypeDouble, alias: Tare, editable: true, nullable: false, defaultValue: null, modelName: tare )
• labeledWtorPrice ( type: esriFieldTypeDouble, alias: Labeled Weight or Price, editable: true, nullable: false, defaultValue: null, modelName: labeledWt )
• packageError ( type: esriFieldTypeDouble, alias: Package Error, editable: true, nullable: false, defaultValue: null, modelName: packageError )
• mavDimless ( type: esriFieldTypeDouble, alias: MAV (dimensionless), editable: true, nullable: false, defaultValue: null, modelName: mavDimless )
• positiveCheck ( type: esriFieldTypeSmallInteger, alias: Positive Check, editable: true, nullable: true, defaultValue: null, modelName: positiveCheck )
• negativeCheck ( type: esriFieldTypeSmallInteger, alias: Negative Check, editable: true, nullable: true, defaultValue: null, modelName: negativeCheck )
• recordedWeightOrPrice ( type: esriFieldTypeDouble, alias: Recorded Weight Or Price, editable: true, nullable: true, defaultValue: null, modelName: recordedWeightOrPrice )
Templates:
• Name: AuditPackSubtest
  Description:
  Prototype:
  negativeCheck: null
  positiveCheck: null
  Guid: null
  recordedWeightOrPrice: null
  mavDimless: 0
  packageError: 0
  labeledWtorPrice: 0
  tare: 0
  productDescription:
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• AuditPackTest (12) -- Related To: AuditPackTest (2)

Table: AuditPackTest (2)

Name: AuditPackTest

Display Field: inspCompanyName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• guid ( type: esriFieldTypeGUID, alias: guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: guid )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: Created By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: Created On, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• inspectionDate ( type: esriFieldTypeDate, alias: Date of Inspection, editable: true, nullable: false, length: 8, defaultValue: null, modelName: inspectionDate )
• inspector ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 50, defaultValue: null, modelName: inspector )
• testType ( type: esriFieldTypeInteger, alias: Test Type, editable: true, nullable: false, defaultValue: 0, modelName: testType , Coded Values: [0: Routine Inspection] , [1: Courtesy Inspection] , [2: Complaint] )
• productBrandIdentity ( type: esriFieldTypeString, alias: Product/Brand Identity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: productBrandIdentity )
• lotCodes ( type: esriFieldTypeString, alias: Lot Codes, editable: true, nullable: true, length: 50, defaultValue: null, modelName: lotCodes )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• containerDescription ( type: esriFieldTypeString, alias: Container Description, editable: true, nullable: true, length: 250, defaultValue: null, modelName: containerDescription )
• measurementUnits ( type: esriFieldTypeString, alias: Measurement Units, editable: true, nullable: true, length: 50, defaultValue: null, modelName: unitOfMeasure )
• inspectionLotSize ( type: esriFieldTypeSmallInteger, alias: Inspection Lot Size, editable: true, nullable: true, defaultValue: null, modelName: inspectionLotSize )
• sampleSize ( type: esriFieldTypeSmallInteger, alias: Sample Size (n), editable: true, nullable: true, defaultValue: null, modelName: sampleSize )
• initialTareSampleSize ( type: esriFieldTypeSmallInteger, alias: Init. Tare Sample Size, editable: true, nullable: true, defaultValue: null, modelName: initialRateSampleSize )
• numberofMAVAllowed ( type: esriFieldTypeSmallInteger, alias: Number of MAVs Allowed, editable: true, nullable: true, defaultValue: null, modelName: numberofMAVAllowed )
• rangeOfPackageERrors ( type: esriFieldTypeSmallInteger, alias: Range of Package Errors (Rc), editable: true, nullable: true, defaultValue: null, modelName: rangeOfPackageERrors )
• rangeOfTareWeights ( type: esriFieldTypeSmallInteger, alias: Range of Tare Weights (Rt), editable: true, nullable: true, defaultValue: null, modelName: rangeOfTareWeights )
• rcDivrt ( type: esriFieldTypeDouble, alias: Rc / Rt, editable: true, nullable: true, defaultValue: null, modelName: rcDivrt )
• avgTareWt ( type: esriFieldTypeDouble, alias: Avg. Tare Wt., editable: true, nullable: true, defaultValue: null, modelName: avgTareWt )
• nomialGrossWt ( type: esriFieldTypeDouble, alias: Nominal Gross Wt, editable: true, nullable: true, defaultValue: null, modelName: nomialGrossWt )
• totalError ( type: esriFieldTypeDouble, alias: Total Error, editable: true, nullable: true, defaultValue: null, modelName: totalError )
• numberOfUnreasonableMinusErrors ( type: esriFieldTypeSmallInteger, alias: Number of Unreasonable Minus (-) Errors, editable: true, nullable: true, defaultValue: null, modelName: numberOfUnreasonableMinusErrors )
• box16GTbox8 ( type: esriFieldTypeSmallInteger, alias: Number of Unreasonable Minus Errors > # MAVs Allowed?, editable: true, nullable: true, defaultValue: null, modelName: box16GTbox8 , Coded Values: [0: No] , [1: Yes] )
• AvgErrorinDimlessUnits ( type: esriFieldTypeDouble, alias: Avg. Error in Dimensionless Units, editable: true, nullable: true, defaultValue: null, modelName: AvgErrorinDimlessUnits )
• avgErrorInLabeledUnits ( type: esriFieldTypeDouble, alias: Avg. Error in Labeled Units, editable: true, nullable: true, defaultValue: null, modelName: avgErrorInLabeledUnits )
• sampleStandardDeviation ( type: esriFieldTypeDouble, alias: Sample Standard Deviation, editable: true, nullable: true, defaultValue: null, modelName: sampleStandardDeviation )
• sampleCorrectionFactor ( type: esriFieldTypeDouble, alias: Sample Correction Factor, editable: true, nullable: true, defaultValue: null, modelName: sampleCorrectionFactor )
• sampleErrorLimit ( type: esriFieldTypeDouble, alias: Sample Error Limit, editable: true, nullable: true, defaultValue: null, modelName: sampleErrorLimit )
• box18GTbox23 ( type: esriFieldTypeSmallInteger, alias: Disregarding Signs, is Avg. Error in Dimless Units > Sample Error Limit?, editable: true, nullable: true, defaultValue: null, modelName: box18GTbox23 , Coded Values: [0: No] , [1: Yes] )
• dispositionOfInspectionLot ( type: esriFieldTypeString, alias: Disposition of Inspection Lot, editable: true, nullable: true, length: 50, defaultValue: null, modelName: dispositionOfInspectionLot , Coded Values: [APP: Approve] , [REJ: Reject] , [CDM: Condemned] )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: Comments )
• countMinusErrors ( type: esriFieldTypeSmallInteger, alias: Count of Minus Errors, editable: true, nullable: true, defaultValue: null, modelName: countMinusErrors )
• countPlusErrors ( type: esriFieldTypeSmallInteger, alias: Count of Plus Errors, editable: true, nullable: true, defaultValue: null, modelName: countPlusErrors )
• operator ( type: esriFieldTypeString, alias: Operator, editable: true, nullable: true, length: 50, defaultValue: null, modelName: operator )
• operatorPhone ( type: esriFieldTypeDouble, alias: Operator Phone, editable: true, nullable: true, defaultValue: null, modelName: operatorPhone )
• operatorEmail ( type: esriFieldTypeString, alias: Operator's Email, editable: true, nullable: false, length: 50, defaultValue: null, modelName: operatorEmail )
• inspCompanyName ( type: esriFieldTypeString, alias: Inspection Company Name, editable: true, nullable: true, length: 200, defaultValue: null, modelName: inspCompanyName )
• inspCompanyAdd ( type: esriFieldTypeString, alias: Inspection Company Address, editable: true, nullable: true, length: 200, defaultValue: null, modelName: inspCompanyAdd )
• box18EqualZeroOrPlus ( type: esriFieldTypeDouble, alias: Box 18 Equal Zero Or Plus, editable: true, nullable: true, defaultValue: null, modelName: box18EqualZeroOrPlus , Coded Values: [0: No] , [1: Yes] )
• tareStandardizationType ( type: esriFieldTypeString, alias: Tare Standardization Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: tareCorrection , Coded Values: [Tare Correction: Tare Correction] , [Moisture Allowance: Moisture Allowance] , [Not Applicable: Not Applicable] )
• tareWeightType ( type: esriFieldTypeString, alias: Tare Weight Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: tareWeightType , Coded Values: [Dry: Dry Tare] , [Wet: Wet Tare] , [Unused: Unused Dry Tare] )
• measurementDivisions ( type: esriFieldTypeDouble, alias: Measurement Divisions, editable: true, nullable: true, defaultValue: null, modelName: measurementDivisions )
• samplesToTake ( type: esriFieldTypeInteger, alias: Samples to Take, editable: true, nullable: true, defaultValue: null, modelName: samplesToTake )
• isARetest ( type: esriFieldTypeSmallInteger, alias: Test is a re-test?, editable: true, nullable: true, defaultValue: null, modelName: isARetest , Coded Values: [0: No] , [1: Yes] )
• establishmentType ( type: esriFieldTypeString, alias: Establishment Type, editable: true, nullable: false, length: 50, defaultValue: null, modelName: establishmentType , Coded Values: [Supermarket: Supermarket] , [Gas/Fuel Station: Gas/Fuel Station] , [Convenience Store: Convenience Store] , ...17 more... )
• Resolved ( type: esriFieldTypeSmallInteger, alias: Resolved, editable: true, nullable: true, defaultValue: null, modelName: Resolved , Coded Values: [0: No] , [1: Yes] )
• ResolutionDate ( type: esriFieldTypeDate, alias: Resolution Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ResolutionDate )
• ResolutionComments ( type: esriFieldTypeString, alias: Resolution Comments, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: ResolutionComments )
Templates:
• Name: AuditPackTest
  Description:
  Prototype:
  ResolutionDate: null
  Resolved: null
  guid: null
  ResolutionComments: null
  establishmentType:
  isARetest: null
  samplesToTake: null
  measurementDivisions: null
  inspectionDate: -2209161600000
  inspector: null
  testType: 0
  productBrandIdentity: null
  lotCodes: null
  Manufacturer: null
  containerDescription: null
  measurementUnits: null
  inspectionLotSize: null
  sampleSize: null
  initialTareSampleSize: null
  numberofMAVAllowed: null
  rangeOfPackageERrors: null
  rangeOfTareWeights: null
  rcDivrt: null
  avgTareWt: null
  nomialGrossWt: null
  totalError: null
  numberOfUnreasonableMinusErrors: null
  box16GTbox8: null
  AvgErrorinDimlessUnits: null
  avgErrorInLabeledUnits: null
  sampleStandardDeviation: null
  sampleCorrectionFactor: null
  sampleErrorLimit: null
  box18GTbox23: null
  dispositionOfInspectionLot: null
  Comments: null
  countMinusErrors: null
  countPlusErrors: null
  operator: null
  operatorPhone: null
  operatorEmail:
  inspCompanyName: null
  inspCompanyAdd: null
  box18EqualZeroOrPlus: null
  tareStandardizationType: null
  tareWeightType: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• AuditPackSubtest (12) -- Related To: AuditPackSubtest (1)
• InspectionSites (9) -- Related To: InspectionSites (0)

Table: ComplaintsReceived (3)

Name: ComplaintsReceived

Display Field: inspCompanyName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• guid ( type: esriFieldTypeGUID, alias: guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: guid )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: Created By, 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 By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• inspector ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 50, defaultValue: null, modelName: inspector )
• inspCompanyName ( type: esriFieldTypeString, alias: Inspection Company Name, editable: true, nullable: true, length: 200, defaultValue: null, modelName: inspCompanyName )
• inspCompanyAdd ( type: esriFieldTypeString, alias: Inspection Company, editable: true, nullable: true, length: 200, defaultValue: null, modelName: inspCompanyAdd )
• dateReceived ( type: esriFieldTypeDate, alias: Date Received, editable: true, nullable: true, length: 8, defaultValue: null, modelName: dateReceived )
• resolved ( type: esriFieldTypeSmallInteger, alias: Resolved, editable: true, nullable: true, defaultValue: null, modelName: resolved , Coded Values: [0: No] , [1: Yes] )
• comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: comments )
• dateResolved ( type: esriFieldTypeDate, alias: Date Resolved, editable: true, nullable: true, length: 8, defaultValue: null, modelName: dateResolved )
• Contacted ( type: esriFieldTypeString, alias: Contacted, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Contacted )
• Title ( type: esriFieldTypeString, alias: Title, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Title )
• Device ( type: esriFieldTypeString, alias: Device, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Device )
• CompType ( type: esriFieldTypeString, alias: Complaint Type, editable: true, nullable: false, length: 50, defaultValue: null, modelName: CompType , Coded Values: [Motor-Fuel: Motor-Fuel] , [Home Heating Fuel: Home Heating Fuel] , [Price Errors: Price Errors] , ...6 more... )
• complainReceivedByName ( type: esriFieldTypeString, alias: Complaint Contact, editable: true, nullable: true, length: 50, defaultValue: null, modelName: complainReceivedByName )
• complainReceivedByAdd ( type: esriFieldTypeString, alias: Complaint Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: complainReceivedByAdd )
• complainReceivedByPhone ( type: esriFieldTypeString, alias: Complaint Phone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: complainReceivedByPhone )
• operatorPhone ( type: esriFieldTypeDouble, alias: Operator Phone, editable: true, nullable: true, defaultValue: null, modelName: operatorPhone )
• reason ( type: esriFieldTypeString, alias: Reason, editable: true, nullable: true, length: 200, defaultValue: null, modelName: reason )
• findings ( type: esriFieldTypeString, alias: Findings, editable: true, nullable: true, length: 200, defaultValue: null, modelName: findings )
• action ( type: esriFieldTypeString, alias: Action, editable: true, nullable: true, length: 200, defaultValue: null, modelName: action )
Templates:
• Name: ComplaintsReceived
  Description:
  Prototype:
  findings: null
  reason: null
  guid: null
  action: null
  operatorPhone: null
  complainReceivedByPhone: null
  complainReceivedByAdd: null
  complainReceivedByName: null
  inspector: null
  inspCompanyName: null
  inspCompanyAdd: null
  dateReceived: null
  resolved: null
  comments: null
  dateResolved: null
  Contacted: null
  Title: null
  Device: null
  CompType:
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• InspectionSites (8) -- Related To: InspectionSites (0)

Table: hopperAggregateTests (4)

Name: hopperAggregateTests

Display Field: created_user

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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


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 )
• Guid ( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: Created By, 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 By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• WeightA ( type: esriFieldTypeDouble, alias: Weight, editable: true, nullable: false, defaultValue: null, modelName: Weight )
• Requested ( type: esriFieldTypeDouble, alias: Requested, editable: true, nullable: false, defaultValue: null, modelName: Requested )
• Delivered ( type: esriFieldTypeDouble, alias: Delivered, editable: true, nullable: false, defaultValue: null, modelName: Delivered )
• DifferenceA ( type: esriFieldTypeDouble, alias: Difference, editable: true, nullable: false, defaultValue: null, modelName: Difference )
• scaleDivisionsA ( type: esriFieldTypeString, alias: Scale Divisions A, editable: true, nullable: true, length: 50, defaultValue: null, modelName: scaleDivisionsA )
Templates:
• Name: hopperAggregateTests
  Description:
  Prototype:
  DifferenceA: 0
  Delivered: 0
  Guid: null
  scaleDivisionsA: null
  Requested: 0
  WeightA: 0
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• HopperScaleTest (13) -- Related To: HopperScaleTest (6)

Table: hopperCementTests (5)

Name: hopperCementTests

Display Field: created_user

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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


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 )
• Guid ( type: esriFieldTypeGUID, alias: Guidg, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: Created By, 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 By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• WeightC ( type: esriFieldTypeDouble, alias: Weight, editable: true, nullable: false, defaultValue: null, modelName: Weight )
• Total ( type: esriFieldTypeDouble, alias: Total, editable: true, nullable: false, defaultValue: null, modelName: Total )
• DifferenceC ( type: esriFieldTypeDouble, alias: Difference, editable: true, nullable: false, defaultValue: null, modelName: Difference )
• scaleDivisionsC ( type: esriFieldTypeString, alias: Scale Divisions A, editable: true, nullable: true, length: 50, defaultValue: null, modelName: scaleDivisionsC )
Templates:
• Name: hopperCementTests
  Description:
  Prototype:
  DifferenceC: 0
  Total: 0
  Guid: null
  scaleDivisionsC: null
  WeightC: 0
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• HopperScaleTest (14) -- Related To: HopperScaleTest (6)

Table: HopperScaleTest (6)

Name: HopperScaleTest

Display Field: inspCompanyName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: Created By, 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 By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• inspectionDate ( type: esriFieldTypeDate, alias: Date of Inspection, editable: true, nullable: false, length: 8, defaultValue: null, modelName: inspectionDate )
• inspector ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 50, defaultValue: null, modelName: inspector )
• testType ( type: esriFieldTypeInteger, alias: Test Type, editable: true, nullable: false, defaultValue: 0, modelName: testType , Coded Values: [0: Routine Inspection] , [1: Courtesy Inspection] , [2: Complaint] )
• MFG ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MFG )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• SerialNumber ( type: esriFieldTypeString, alias: Serial Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SerialNumber )
• Capacity ( type: esriFieldTypeDouble, alias: Capacity, editable: true, nullable: true, defaultValue: null, modelName: Capacity )
• GradSize ( type: esriFieldTypeDouble, alias: Grad Size, editable: true, nullable: true, defaultValue: null, modelName: GradSize )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: Comments )
• operator ( type: esriFieldTypeString, alias: Operator, editable: true, nullable: true, length: 50, defaultValue: null, modelName: operator )
• operatorPhone ( type: esriFieldTypeDouble, alias: Operator Phone, editable: true, nullable: true, defaultValue: null, modelName: operatorPhone )
• operatorEmail ( type: esriFieldTypeString, alias: Operator's Email, editable: true, nullable: false, length: 50, defaultValue: null, modelName: operatorEmail )
• inspCompanyAdd ( type: esriFieldTypeString, alias: Inspection Company Address, editable: true, nullable: true, length: 200, defaultValue: null, modelName: inspCompanyAdd )
• inspCompanyName ( type: esriFieldTypeString, alias: Inspection Company Name, editable: true, nullable: true, length: 200, defaultValue: null, modelName: inspCompanyName )
• passFail ( type: esriFieldTypeString, alias: Pass/Fail, editable: true, nullable: true, length: 50, defaultValue: null, modelName: passFail , Coded Values: [Pass: Pass] , [Fail: Fail] )
• isARetest ( type: esriFieldTypeSmallInteger, alias: Test is a re-test?, editable: true, nullable: true, defaultValue: null, modelName: isARetest , Coded Values: [0: No] , [1: Yes] )
• establishmentType ( type: esriFieldTypeString, alias: Establishment Type, editable: true, nullable: false, length: 50, defaultValue: null, modelName: establishmentType , Coded Values: [Supermarket: Supermarket] , [Gas/Fuel Station: Gas/Fuel Station] , [Convenience Store: Convenience Store] , ...17 more... )
• Resolved ( type: esriFieldTypeSmallInteger, alias: Resolved, editable: true, nullable: true, defaultValue: null, modelName: Resolved , Coded Values: [0: No] , [1: Yes] )
• ResolutionDate ( type: esriFieldTypeDate, alias: Resolution Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ResolutionDate )
• ResolutionComments ( type: esriFieldTypeString, alias: Resolution Comments, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: ResolutionComments )
• ScaleType ( type: esriFieldTypeString, alias: Scale Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ScaleType , Coded Values: [Computing Scale: Computing Scale] , [Counter/Bench Scale Non-computing =<500: Counter/Bench Scale Non-computing =<500] , [Platform/Floor Scale <= 5000lbs: Platform/Floor Scale <= 5000lbs] , ...14 more... )
Templates:
• Name: HopperScaleTest
  Description:
  Prototype:
  ResolutionComments: null
  ResolutionDate: null
  Guid: null
  ScaleType: null
  Resolved: null
  establishmentType:
  isARetest: null
  passFail: null
  inspectionDate: -2209161600000
  inspector: null
  testType: 0
  MFG: null
  Model: null
  SerialNumber: null
  Capacity: null
  GradSize: null
  Comments: null
  operator: null
  operatorPhone: null
  operatorEmail:
  inspCompanyAdd: null
  inspCompanyName: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• hopperCementTests (14) -- Related To: hopperCementTests (5)
• hopperAggregateTests (13) -- Related To: hopperAggregateTests (4)
• InspectionSites (0) -- Related To: InspectionSites (0)

Table: loadingRackSubTests (7)

Name: loadingRackSubTests

Display Field: liquidBrandName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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


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 )
• Guid ( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: Created By, 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 By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• liquidBrandName ( type: esriFieldTypeString, alias: Liquid (Brand Name), editable: true, nullable: false, length: 50, defaultValue: null, modelName: liquidBrandName )
• meterReading ( type: esriFieldTypeDouble, alias: Meter Reading, editable: true, nullable: true, defaultValue: null, modelName: meterReading )
• tempCompUnComp ( type: esriFieldTypeDouble, alias: Temp. Comp/Un Comp, editable: true, nullable: true, defaultValue: null, modelName: tempCompUnComp )
• netMeterReading ( type: esriFieldTypeDouble, alias: Net Meter Reading, editable: true, nullable: true, defaultValue: null, modelName: netMeterReading )
• proverGross ( type: esriFieldTypeDouble, alias: Prover Gross, editable: true, nullable: true, defaultValue: null, modelName: proverGross )
• proverTemp ( type: esriFieldTypeDouble, alias: Prover Temp, editable: true, nullable: true, defaultValue: null, modelName: proverTemp )
• Diff ( type: esriFieldTypeDouble, alias: Diff., editable: true, nullable: true, defaultValue: null, modelName: Diff )
• correctedProver ( type: esriFieldTypeDouble, alias: Corrected Prover, editable: true, nullable: true, defaultValue: null, modelName: correctedProver )
• proverNet ( type: esriFieldTypeDouble, alias: Prover Net, editable: true, nullable: true, defaultValue: null, modelName: proverNet )
• errorGallon ( type: esriFieldTypeDouble, alias: Error Gallon, editable: true, nullable: true, defaultValue: null, modelName: errorGallon )
• errorinCuInPlusMinus ( type: esriFieldTypeDouble, alias: Error in Cu. In. (Indicate Plus/Minus), editable: true, nullable: true, defaultValue: null, modelName: errorinCuInPlusMinus )
Templates:
• Name: loadingRackSubTests
  Description:
  Prototype:
  errorGallon: null
  proverNet: null
  Guid: null
  errorinCuInPlusMinus: null
  correctedProver: null
  Diff: null
  proverTemp: null
  proverGross: null
  liquidBrandName:
  meterReading: null
  tempCompUnComp: null
  netMeterReading: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• loadingRackTest (15) -- Related To: loadingRackTest (8)

Table: loadingRackTest (8)

Name: loadingRackTest

Display Field: inspCompanyName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: Created By, 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 By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• inspectionDate ( type: esriFieldTypeDate, alias: Date of Inspection, editable: true, nullable: false, length: 8, defaultValue: null, modelName: inspectionDate )
• inspector ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 50, defaultValue: null, modelName: inspector )
• testType ( type: esriFieldTypeInteger, alias: Test Type, editable: true, nullable: false, defaultValue: 0, modelName: testType , Coded Values: [0: Routine Inspection] , [1: Courtesy Inspection] , [2: Complaint] )
• makeOfMeter ( type: esriFieldTypeString, alias: Make of Meter, editable: true, nullable: true, length: 50, defaultValue: null, modelName: makeOfMeter )
• meterSerialNumber ( type: esriFieldTypeString, alias: Meter Serial Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: meterSerialNumber )
• meterSealAsFound ( type: esriFieldTypeString, alias: Meter Seal As Found, editable: true, nullable: true, length: 50, defaultValue: null, modelName: meterSealAsFound , Coded Values: [State: State] , [Other: Other] )
• meterConditionOfSeal ( type: esriFieldTypeString, alias: Condition of Seal, editable: true, nullable: true, length: 50, defaultValue: null, modelName: meterConditionOfSeal , Coded Values: [Intact: Intact] , [Broken: Broke] , [Missing: Missing] )
• makeOfRegister ( type: esriFieldTypeString, alias: Make of Register, editable: true, nullable: true, length: 50, defaultValue: null, modelName: makeOfRegister )
• registerSerialNumber ( type: esriFieldTypeString, alias: Register Serial Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: registerSerialNumber )
• registerSealAsFound ( type: esriFieldTypeString, alias: Register Seal As Found, editable: true, nullable: true, length: 50, defaultValue: null, modelName: registerSealAsFound , Coded Values: [State: State] , [Other: Other] )
• registerConditionOfSeal ( type: esriFieldTypeString, alias: Register Condition of Seal, editable: true, nullable: true, length: 50, defaultValue: null, modelName: registerConditionOfSeal , Coded Values: [Intact: Intact] , [Broken: Broke] , [Missing: Missing] )
• totalizerReadingAsFound ( type: esriFieldTypeString, alias: Totalizer Reading as Found, editable: true, nullable: true, length: 50, defaultValue: null, modelName: totalizerReadingAsFound )
• totalizerReadingAsLeft ( type: esriFieldTypeString, alias: Totalizer Reading as Left, editable: true, nullable: true, length: 50, defaultValue: null, modelName: totalizerReadingAsLeft )
• antiDrainValueFunctioning ( type: esriFieldTypeSmallInteger, alias: Antidrain Value Functioning, editable: true, nullable: true, defaultValue: null, modelName: antiDrainValueFunctioning , Coded Values: [0: No] , [1: Yes] )
• recheck ( type: esriFieldTypeSmallInteger, alias: Recheck, editable: true, nullable: true, defaultValue: null, modelName: recheck , Coded Values: [0: No] , [1: Yes] )
• actionTaken ( type: esriFieldTypeString, alias: Action Taken, editable: true, nullable: true, length: 50, defaultValue: null, modelName: actionTaken , Coded Values: [APP: Approve] , [REJ: Reject] , [CDM: Condemned] )
• stateWeightsAndMeasuresInspecto ( type: esriFieldTypeString, alias: State Weights & Measures Inspector, editable: true, nullable: true, length: 50, defaultValue: null, modelName: stateWeightsAndMeasuresInspector )
• operator ( type: esriFieldTypeString, alias: Operator, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Operator )
• operatorEmail ( type: esriFieldTypeString, alias: Operator's Email, editable: true, nullable: false, length: 50, defaultValue: null, modelName: operatorEmail )
• inspCompanyAdd ( type: esriFieldTypeString, alias: Inspection Company Address, editable: true, nullable: true, length: 200, defaultValue: null, modelName: inspCompanyAdd )
• inspCompanyName ( type: esriFieldTypeString, alias: Inspection Company Name, editable: true, nullable: true, length: 200, defaultValue: null, modelName: inspCompanyName )
• testNum ( type: esriFieldTypeString, alias: Test Num., editable: true, nullable: true, length: 50, defaultValue: null, modelName: testNum )
• permitNum ( type: esriFieldTypeString, alias: Permit No., editable: true, nullable: true, length: 50, defaultValue: null, modelName: permitNum )
• truckNum ( type: esriFieldTypeString, alias: Truck No., editable: true, nullable: true, length: 50, defaultValue: null, modelName: truckNum )
• productTradeName ( type: esriFieldTypeString, alias: Product Trade Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: productTradeName )
• stateIdNum ( type: esriFieldTypeString, alias: State ID No., editable: true, nullable: true, length: 50, defaultValue: null, modelName: stateIdNum )
• ccNum ( type: esriFieldTypeString, alias: CC #, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ccNum )
• Remarks ( type: esriFieldTypeString, alias: Remarks, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: Remakrs )
• isARetest ( type: esriFieldTypeSmallInteger, alias: Test is a re-test?, editable: true, nullable: true, defaultValue: null, modelName: isARetest , Coded Values: [0: No] , [1: Yes] )
• establishmentType ( type: esriFieldTypeString, alias: Establishment Type, editable: true, nullable: false, length: 50, defaultValue: null, modelName: establishmentType , Coded Values: [Supermarket: Supermarket] , [Gas/Fuel Station: Gas/Fuel Station] , [Convenience Store: Convenience Store] , ...17 more... )
• Resolved ( type: esriFieldTypeSmallInteger, alias: Resolved, editable: true, nullable: true, defaultValue: null, modelName: Resolved , Coded Values: [0: No] , [1: Yes] )
• ResolutionDate ( type: esriFieldTypeDate, alias: Resolution Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ResolutionDate )
• ResolutionComments ( type: esriFieldTypeString, alias: Resolution Comments, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: ResolutionComments )
• operatorPhone ( type: esriFieldTypeDouble, alias: Operator Phone, editable: true, nullable: true, defaultValue: null, modelName: operatorPhone )
• ScaleType ( type: esriFieldTypeString, alias: Scale Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ScaleType , Coded Values: [Computing Scale: Computing Scale] , [Counter/Bench Scale Non-computing =<500: Counter/Bench Scale Non-computing =<500] , [Platform/Floor Scale <= 5000lbs: Platform/Floor Scale <= 5000lbs] , ...14 more... )
Templates:
• Name: loadingRackTest
  Description:
  Prototype:
  operatorPhone: null
  ResolutionComments: null
  Guid: null
  ScaleType: null
  ResolutionDate: null
  Resolved: null
  establishmentType:
  isARetest: null
  inspectionDate: -2209161600000
  inspector: null
  testType: 0
  makeOfMeter: null
  meterSerialNumber: null
  meterSealAsFound: null
  meterConditionOfSeal: null
  makeOfRegister: null
  registerSerialNumber: null
  registerSealAsFound: null
  registerConditionOfSeal: null
  totalizerReadingAsFound: null
  totalizerReadingAsLeft: null
  antiDrainValueFunctioning: null
  recheck: null
  actionTaken: null
  stateWeightsAndMeasuresInspecto: null
  operator: null
  operatorEmail:
  inspCompanyAdd: null
  inspCompanyName: null
  testNum: null
  permitNum: null
  truckNum: null
  productTradeName: null
  stateIdNum: null
  ccNum: null
  Remarks: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• loadingRackSubTests (15) -- Related To: loadingRackSubTests (7)
• InspectionSites (10) -- Related To: InspectionSites (0)

Table: massFlowMeterSubTest (9)

Name: massFlowMeterSubTest

Display Field: Time

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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


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 )
• Guid ( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: Created By, 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 By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• TestNo ( type: esriFieldTypeSmallInteger, alias: Test Number, editable: true, nullable: true, defaultValue: null, modelName: TestNo )
• Time ( type: esriFieldTypeString, alias: Time, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Time )
• flowRate ( type: esriFieldTypeDouble, alias: Flow Rate, editable: true, nullable: true, defaultValue: null, modelName: flowRate )
• Gross ( type: esriFieldTypeDouble, alias: Gross, editable: true, nullable: true, defaultValue: null, modelName: Gross )
• Tare ( type: esriFieldTypeDouble, alias: Tare, editable: true, nullable: true, defaultValue: null, modelName: Tare )
• scaleError ( type: esriFieldTypeDouble, alias: Scale Error, editable: true, nullable: true, defaultValue: null, modelName: scaleError )
• Net ( type: esriFieldTypeDouble, alias: Net, editable: true, nullable: true, defaultValue: null, modelName: Net )
• meterReading ( type: esriFieldTypeDouble, alias: Meter Reading, editable: true, nullable: true, defaultValue: null, modelName: meterReading )
• Difference ( type: esriFieldTypeDouble, alias: Difference, editable: true, nullable: true, defaultValue: null, modelName: Difference )
• pcntError ( type: esriFieldTypeDouble, alias: % Error, editable: true, nullable: true, defaultValue: null, modelName: pcntError )
• passFail ( type: esriFieldTypeString, alias: Pass/Fail, editable: true, nullable: false, length: 50, defaultValue: null, modelName: passFail , Coded Values: [Pass: Pass] , [Fail: Fail] )
• productNumber ( type: esriFieldTypeString, alias: Product Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: productNumber )
• bayNum ( type: esriFieldTypeString, alias: Bay Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: bayNum )
Templates:
• Name: massFlowMeterSubTest
  Description:
  Prototype:
  productNumber: null
  passFail:
  Guid: null
  bayNum: null
  pcntError: null
  Difference: null
  meterReading: null
  Net: null
  TestNo: null
  Time: null
  flowRate: null
  Gross: null
  Tare: null
  scaleError: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• massFlowMeterTest (16) -- Related To: massFlowMeterTest (10)

Table: massFlowMeterTest (10)

Name: massFlowMeterTest

Display Field: inspCompanyName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: Created By, 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 By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• inspectionDate ( type: esriFieldTypeDate, alias: Date of Inspection, editable: true, nullable: false, length: 8, defaultValue: null, modelName: inspectionDate )
• inspector ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Inspector )
• inspCompanyName ( type: esriFieldTypeString, alias: Inspection Company Name, editable: true, nullable: true, length: 200, defaultValue: null, modelName: inspCompanyName )
• inspCompanyAdd ( type: esriFieldTypeString, alias: Inspection Company Address, editable: true, nullable: true, length: 200, defaultValue: null, modelName: inspCompanyAdd )
• operator ( type: esriFieldTypeString, alias: Operator, editable: true, nullable: true, length: 50, defaultValue: null, modelName: operator )
• operatorPhone ( type: esriFieldTypeDouble, alias: Operator Phone, editable: true, nullable: true, defaultValue: null, modelName: operatorPhone )
• operatorEmail ( type: esriFieldTypeString, alias: Operator Email, editable: true, nullable: false, length: 50, defaultValue: null, modelName: operatorEmail )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: Comments )
• TypeOfProduct ( type: esriFieldTypeString, alias: Type of Product, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TypeOfProduct )
• SerialNumber ( type: esriFieldTypeString, alias: Serial Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SerialNumber )
• AccuracyClass ( type: esriFieldTypeString, alias: Accuracy Class, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AccuracyClass )
• isARetest ( type: esriFieldTypeSmallInteger, alias: Test is a re-test?, editable: true, nullable: true, defaultValue: null, modelName: isARetest , Coded Values: [0: No] , [1: Yes] )
• establishmentType ( type: esriFieldTypeString, alias: Establishment Type, editable: true, nullable: false, length: 50, defaultValue: null, modelName: establishmentType , Coded Values: [Supermarket: Supermarket] , [Gas/Fuel Station: Gas/Fuel Station] , [Convenience Store: Convenience Store] , ...17 more... )
• testType ( type: esriFieldTypeInteger, alias: Test Type, editable: true, nullable: false, defaultValue: null, modelName: testType , Coded Values: [0: Routine Inspection] , [1: Courtesy Inspection] , [2: Complaint] )
• passFail ( type: esriFieldTypeString, alias: Pass/Fail, editable: true, nullable: true, length: 50, defaultValue: null, modelName: passFail , Coded Values: [Pass: Pass] , [Fail: Fail] )
Templates:
• Name: massFlowMeterTest
  Description:
  Prototype:
  testType: 0
  establishmentType:
  Guid: null
  passFail: null
  isARetest: null
  AccuracyClass: null
  SerialNumber: null
  TypeOfProduct: null
  inspectionDate: -2209161600000
  inspector: null
  inspCompanyName: null
  inspCompanyAdd: null
  operator: null
  operatorPhone: null
  operatorEmail:
  Comments: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• massFlowMeterSubTest (16) -- Related To: massFlowMeterSubTest (9)
• InspectionSites (2) -- Related To: InspectionSites (0)

Table: ObservedTests (11)

Name: ObservedTests

Display Field: inspectionType

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• guid ( type: esriFieldTypeGUID, alias: guid, editable: true, nullable: false, length: 38, defaultValue: null, modelName: guid )
• created_user ( type: esriFieldTypeString, alias: Created By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• inspector ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: false, length: 50, defaultValue: null, modelName: inspector )
• ServiceCompany ( type: esriFieldTypeString, alias: Service Company, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ServiceCompany )
• ServiceTech ( type: esriFieldTypeString, alias: Service Technician, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ServiceTech )
• StateID ( type: esriFieldTypeString, alias: State ID#, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StateID )
• inspectionDate ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: false, length: 8, defaultValue: null, modelName: inspectionDate )
• inspCompanyName ( type: esriFieldTypeString, alias: Inspection Company Name, editable: true, nullable: true, length: 200, defaultValue: null, modelName: inspCompanyName )
• inspCompanyAdd ( type: esriFieldTypeString, alias: Inspection Company Address, editable: true, nullable: true, length: 200, defaultValue: null, modelName: inspCompanyAdd )
• operator ( type: esriFieldTypeString, alias: Operator, editable: true, nullable: true, length: 50, defaultValue: null, modelName: operator )
• operatorPhone ( type: esriFieldTypeDouble, alias: Operator Phone, editable: true, nullable: true, defaultValue: null, modelName: operatorPhone )
• operatorEmail ( type: esriFieldTypeString, alias: Operator Email, editable: true, nullable: true, length: 50, defaultValue: null, modelName: operatorEmail )
• testType ( type: esriFieldTypeInteger, alias: Test Type, editable: true, nullable: false, defaultValue: null, modelName: testType , Coded Values: [0: Routine Inspection] , [1: Courtesy Inspection] , [2: Complaint] )
• isARetest ( type: esriFieldTypeSmallInteger, alias: Test is a re-test?, editable: true, nullable: false, defaultValue: null, modelName: isARetest , Coded Values: [0: No] , [1: Yes] )
• Checked ( type: esriFieldTypeSmallInteger, alias: Checked?, editable: true, nullable: false, defaultValue: null, modelName: Checked , Coded Values: [0: No] , [1: Yes] )
• Sealed ( type: esriFieldTypeSmallInteger, alias: Sealed?, editable: true, nullable: false, defaultValue: null, modelName: Sealed , Coded Values: [0: No] , [1: Yes] )
• outOfTolerance ( type: esriFieldTypeSmallInteger, alias: Out of Tolerance?, editable: true, nullable: false, defaultValue: null, modelName: outOfTolerance , Coded Values: [0: No] , [1: Yes] )
• retest ( type: esriFieldTypeSmallInteger, alias: Requires Re-test?, editable: true, nullable: false, defaultValue: null, modelName: retest , Coded Values: [0: No] , [1: Yes] )
• 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 By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• establishmentType ( type: esriFieldTypeString, alias: Establishment Type, editable: true, nullable: false, length: 50, defaultValue: null, modelName: establishmentType , Coded Values: [Supermarket: Supermarket] , [Gas/Fuel Station: Gas/Fuel Station] , [Convenience Store: Convenience Store] , ...17 more... )
• inspectionType ( type: esriFieldTypeString, alias: Inspection Type, editable: true, nullable: false, length: 50, defaultValue: null, modelName: inspectionType , Coded Values: [Automatic Weighing Systems: Automatic Weighing Systems] , [Compressed Natural Gas (CNG): Compressed Natural Gas (CNG)] , [Other Platform > 5000lbs.: Other Platform > 5000lbs.] , ...8 more... )
• remarks ( type: esriFieldTypeString, alias: Remarks, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: remarks )
• Resolved ( type: esriFieldTypeSmallInteger, alias: Resolved, editable: true, nullable: true, defaultValue: null, modelName: Resolved , Coded Values: [0: No] , [1: Yes] )
• ResolutionDate ( type: esriFieldTypeDate, alias: Resolution Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ResolutionDate )
• ResolutionComments ( type: esriFieldTypeString, alias: Resolution Comments, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: ResolutionComments )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
Templates:
• Name: ObservedTests
  Description:
  Prototype:
  ResolutionComments: null
  ResolutionDate: null
  guid: {00000000-0000-0000-0000-000000000000}
  Resolved: null
  inspector:
  ServiceCompany: null
  ServiceTech: null
  StateID: null
  inspectionDate: -2209161600000
  inspCompanyName: null
  inspCompanyAdd: null
  operator: null
  operatorPhone: null
  operatorEmail: null
  testType: 0
  isARetest: 0
  Checked: 0
  Sealed: 0
  outOfTolerance: 0
  retest: 0
  remarks: null
  inspectionType:
  establishmentType:
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• InspectionSites (5) -- Related To: InspectionSites (0)

Table: priceVerificationSubtests (12)

Name: priceVerificationSubtests

Display Field: Location

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Location )
• Item ( type: esriFieldTypeString, alias: Item, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Item )
• Listed ( type: esriFieldTypeDouble, alias: Listed, editable: true, nullable: true, defaultValue: null, modelName: Listed )
• Charged ( type: esriFieldTypeDouble, alias: Charged, editable: true, nullable: true, defaultValue: null, modelName: Charged )
• Difference ( type: esriFieldTypeDouble, alias: Plus, editable: true, nullable: true, defaultValue: null, modelName: Plus )
Templates:
• Name: priceVerificationSubtests
  Description:
  Prototype:
  Charged: null
  Listed: null
  Guid: null
  Difference: null
  Item: null
  Location: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• priceVerificationTest (17) -- Related To: priceVerificationTest (13)

Table: priceVerificationTest (13)

Name: priceVerificationTest

Display Field: inspCompanyName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: Created By, 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 By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• inspectionDate ( type: esriFieldTypeDate, alias: Date of Inspection, editable: true, nullable: false, length: 8, defaultValue: null, modelName: inspectionDate )
• inspector ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Inspector )
• inspCompanyName ( type: esriFieldTypeString, alias: Inspection Company Name, editable: true, nullable: true, length: 200, defaultValue: null, modelName: inspCompanyName )
• inspCompanyAdd ( type: esriFieldTypeString, alias: Inspection Company Address, editable: true, nullable: true, length: 200, defaultValue: null, modelName: inspCompanyAdd )
• operator ( type: esriFieldTypeString, alias: Operator, editable: true, nullable: true, length: 50, defaultValue: null, modelName: operator )
• operatorPhone ( type: esriFieldTypeDouble, alias: Operator Phone, editable: true, nullable: true, defaultValue: null, modelName: operatorPhone )
• operatorEmail ( type: esriFieldTypeString, alias: Operator's Email, editable: true, nullable: false, length: 50, defaultValue: null, modelName: operatorEmail )
• establishmentType ( type: esriFieldTypeString, alias: Establishment Type, editable: true, nullable: false, length: 50, defaultValue: null, modelName: establishmentType , Coded Values: [Supermarket: Supermarket] , [Gas/Fuel Station: Gas/Fuel Station] , [Convenience Store: Convenience Store] , ...17 more... )
• testType ( type: esriFieldTypeInteger, alias: Test Type, editable: true, nullable: false, defaultValue: 0, modelName: testType , Coded Values: [0: Routine Inspection] , [1: Courtesy Inspection] , [2: Complaint] )
• isARetest ( type: esriFieldTypeSmallInteger, alias: Test is a re-test?, editable: true, nullable: true, defaultValue: null, modelName: isARetest , Coded Values: [0: No] , [1: Yes] )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: Comments )
• Score ( type: esriFieldTypeDouble, alias: Score, editable: true, nullable: true, defaultValue: null, modelName: Score )
• Resolved ( type: esriFieldTypeSmallInteger, alias: Resolved, editable: true, nullable: true, defaultValue: null, modelName: Resolved , Coded Values: [0: No] , [1: Yes] )
• ResolutionDate ( type: esriFieldTypeDate, alias: Resolution Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ResolutionDate )
• ResolutionComments ( type: esriFieldTypeString, alias: Resolution Comments, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: ResolutionComments )
Templates:
• Name: priceVerificationTest
  Description:
  Prototype:
  ResolutionDate: null
  Resolved: null
  Guid: null
  ResolutionComments: null
  Score: null
  Comments: null
  isARetest: null
  testType: 0
  inspectionDate: -2209161600000
  inspector: null
  inspCompanyName: null
  inspCompanyAdd: null
  operator: null
  operatorPhone: null
  operatorEmail:
  establishmentType:
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• priceVerificationSubtests (17) -- Related To: priceVerificationSubtests (12)
• InspectionSites (4) -- Related To: InspectionSites (0)

Table: PumpSubtests (14)

Name: PumpSubtests

Display Field: PumpNumber

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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


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 )
• Guid ( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GasStationID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: Created By, 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 By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• PumpNumber ( type: esriFieldTypeString, alias: Pump #, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PumpNumber )
• ProductKey ( type: esriFieldTypeSmallInteger, alias: Product Key, editable: true, nullable: true, defaultValue: null, modelName: ProductKey , Coded Values: [1: Gasoline] , [2: Diesel Fuel] , [3: Kerosene] )
• N ( type: esriFieldTypeString, alias: N, editable: true, nullable: true, length: 50, defaultValue: null, modelName: N )
• S ( type: esriFieldTypeString, alias: S, editable: true, nullable: true, length: 50, defaultValue: null, modelName: S )
• ProverReadingPlusCubicIn ( type: esriFieldTypeDouble, alias: Prover Reading Cubic In. (+), editable: true, nullable: true, defaultValue: null, modelName: PowerReading )
• ProverReadingMinusCubicIn ( type: esriFieldTypeDouble, alias: ProverReading Cubic In. (-), editable: true, nullable: true, defaultValue: null, modelName: PowerReadingMinusCubicIn )
• ActionTaken ( type: esriFieldTypeString, alias: Action Taken, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ActionTaken , Coded Values: [APP: Approve] , [REJ: Reject] , [CDM: Condemned] )
• SealBroken ( type: esriFieldTypeSmallInteger, alias: Seal Broken, editable: true, nullable: true, defaultValue: null, modelName: SealBroken , Coded Values: [0: No] , [1: Yes] )
• Remarks ( type: esriFieldTypeString, alias: Remarks, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: Remarks )
• TotalGallons ( type: esriFieldTypeString, alias: Total Gallons, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TotalGallons )
• Amount ( type: esriFieldTypeString, alias: Amount, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Amount )
• PumpMeetsAllTolerances ( type: esriFieldTypeSmallInteger, alias: Pump Meets All Tolerances, editable: true, nullable: true, defaultValue: null, modelName: PumpMeetsAllTolerances , Coded Values: [0: No] , [1: Yes] )
• pumpFuelType ( type: esriFieldTypeString, alias: Pump Fuel Type, editable: true, nullable: false, length: 50, defaultValue: null, modelName: pumpFuelType , Coded Values: [Regular: Regular] , [Blend: Blend] , [Diesel: Diesel] , ...1 more... )
• Octane ( type: esriFieldTypeString, alias: Octane, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Octane , Coded Values: [87: 87] , [89: 89] , [93: 93] , ...10 more... )
• PricePerGallon ( type: esriFieldTypeString, alias: Price Per Gallon, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PricePerGallon )
• subtestIsARetest ( type: esriFieldTypeSmallInteger, alias: Subtest is a Retest, editable: true, nullable: true, defaultValue: null, modelName: subtestIsARetest )
Templates:
• Name: PumpSubtests
  Description:
  Prototype:
  PricePerGallon: null
  Octane: null
  Guid: null
  subtestIsARetest: null
  pumpFuelType:
  PumpMeetsAllTolerances: null
  Amount: null
  TotalGallons: null
  PumpNumber: null
  ProductKey: null
  N: null
  S: null
  ProverReadingPlusCubicIn: null
  ProverReadingMinusCubicIn: null
  ActionTaken: null
  SealBroken: null
  Remarks: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• PumpTests (18) -- Related To: PumpTests (15)

Table: PumpTests (15)

Name: PumpTests

Display Field: inspCompanyName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• Guid ( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GasStationID )
• testType ( type: esriFieldTypeInteger, alias: Test Type, editable: true, nullable: false, defaultValue: 0, modelName: testType , Coded Values: [0: Routine Inspection] , [1: Courtesy Inspection] , [2: Complaint] )
• created_user ( type: esriFieldTypeString, alias: Created By, 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 Inspected By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Inspected Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• inspectionDate ( type: esriFieldTypeDate, alias: Date of Inspection, editable: true, nullable: false, length: 8, defaultValue: null, modelName: inspectionDate )
• inspector ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Inspector )
• operator ( type: esriFieldTypeString, alias: Operator, editable: true, nullable: true, length: 500, defaultValue: null, modelName: operator )
• operatorPhone ( type: esriFieldTypeDouble, alias: Operator Phone, editable: true, nullable: true, defaultValue: null, modelName: operatorPhone )
• operatorEmail ( type: esriFieldTypeString, alias: Operator Email, editable: true, nullable: true, length: 500, defaultValue: null, modelName: operatorEmail )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• inspCompanyAdd ( type: esriFieldTypeString, alias: Inspection Company Address, editable: true, nullable: true, length: 200, defaultValue: null, modelName: inspCompanyAdd )
• inspCompanyName ( type: esriFieldTypeString, alias: Inspection Company Name, editable: true, nullable: true, length: 200, defaultValue: null, modelName: inspCompanyName )
• fuelReturnedToPropertyStorage ( type: esriFieldTypeSmallInteger, alias: Fuel Returned To Property Storage, editable: true, nullable: true, defaultValue: null, modelName: fuelReturnedToPropertyStorage , Coded Values: [0: No] , [1: Yes] )
• pumpCountOutOfTolerance ( type: esriFieldTypeInteger, alias: Pump Count Out Of Tolerance, editable: true, nullable: true, defaultValue: null, modelName: pumpCountOutOfTolerance )
• comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: comments )
• ReinpectionRequired ( type: esriFieldTypeSmallInteger, alias: Reinpection Required?, editable: true, nullable: true, defaultValue: null, modelName: ReinpectionRequired , Coded Values: [0: No] , [1: Yes] )
• isARetest ( type: esriFieldTypeSmallInteger, alias: Test is a re-test?, editable: true, nullable: true, defaultValue: null, modelName: isARetest , Coded Values: [0: No] , [1: Yes] )
• fuelType ( type: esriFieldTypeString, alias: Fuel Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: fuelType , Coded Values: [Regular: Regular] , [Blend: Blend] , [Diesel: Diesel] , ...1 more... )
• establishmentType ( type: esriFieldTypeString, alias: Establishment Type, editable: true, nullable: false, length: 50, defaultValue: null, modelName: establishmentType , Coded Values: [Supermarket: Supermarket] , [Gas/Fuel Station: Gas/Fuel Station] , [Convenience Store: Convenience Store] , ...17 more... )
• Resolved ( type: esriFieldTypeSmallInteger, alias: Resolved, editable: true, nullable: true, defaultValue: null, modelName: Resolved , Coded Values: [0: No] , [1: Yes] )
• ResolutionDate ( type: esriFieldTypeDate, alias: Resolution Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ResolutionDate )
• ResolutionComments ( type: esriFieldTypeString, alias: Resolution Comments, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: ResolutionComments )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• isARetest_ ( type: esriFieldTypeSmallInteger, alias: Is a Retest, editable: true, nullable: true, defaultValue: null, modelName: isARetest_ )
Templates:
• Name: PumpTests
  Description:
  Prototype:
  ResolutionComments: null
  Guid: null
  testType: 0
  ResolutionDate: null
  Resolved: null
  establishmentType:
  fuelType: null
  inspectionDate: -2209161600000
  inspector: null
  operator: null
  operatorPhone: null
  operatorEmail: null
  isARetest_: null
  inspCompanyAdd: null
  inspCompanyName: null
  fuelReturnedToPropertyStorage: null
  pumpCountOutOfTolerance: null
  comments: null
  ReinpectionRequired: null
  isARetest: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• PumpSubtests (18) -- Related To: PumpSubtests (14)
• InspectionSites (6) -- Related To: InspectionSites (0)

Table: ReinspectionOrRepairs (16)

Name: ReinspectionOrRepairs

Display Field: RepairCompanyName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: Created By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: Created On, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edited On, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• inspCompanyName ( type: esriFieldTypeString, alias: Inspection Company Name, editable: true, nullable: true, length: 200, defaultValue: null, modelName: inspCompanyName )
• inspCompanyAdd ( type: esriFieldTypeString, alias: Inspection Company Address, editable: true, nullable: true, length: 200, defaultValue: null, modelName: inspCompanyAdd )
• Phone ( type: esriFieldTypeDouble, alias: Phone, editable: true, nullable: true, defaultValue: null, modelName: Phone )
• RepairedBy ( type: esriFieldTypeString, alias: Repaired By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RepairedBy )
• RepairCompanyName ( type: esriFieldTypeString, alias: Repair Company Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Company )
• RepairCompanyAddress ( type: esriFieldTypeString, alias: Repair Company Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Address )
• RepairCompanyPhone ( type: esriFieldTypeString, alias: Repair Company Phone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Phone )
• reinspectionDate ( type: esriFieldTypeDate, alias: Date of Reinspection, editable: true, nullable: true, length: 8, defaultValue: null, modelName: reinspectionDate )
Templates:
• Name: ReinspectionOrRepairs
  Description:
  Prototype:
  RepairCompanyPhone: null
  RepairCompanyAddress: null
  Guid: null
  reinspectionDate: null
  RepairCompanyName: null
  RepairedBy: null
  Phone: null
  inspCompanyAdd: null
  inspCompanyName: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• InspectionSites (1) -- Related To: InspectionSites (0)

Table: ScalePerformanceTests (17)

Name: ScalePerformanceTests

Display Field: created_user

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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


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 )
• Guid ( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: Created By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: Created On, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Phone ( type: esriFieldTypeDouble, alias: Phone, editable: true, nullable: true, defaultValue: null, modelName: Phone )
• TestD ( type: esriFieldTypeDouble, alias: Test D, editable: true, nullable: true, defaultValue: null, modelName: TestD )
• TestLoad ( type: esriFieldTypeDouble, alias: Test Load, editable: true, nullable: true, defaultValue: null, modelName: TestLoad )
• ErrorInD ( type: esriFieldTypeDouble, alias: Error In D, editable: true, nullable: true, defaultValue: null, modelName: ErrorInD )
• Error ( type: esriFieldTypeDouble, alias: Error, editable: true, nullable: true, defaultValue: null, modelName: Error )
Templates:
• Name: ScalePerformanceTests
  Description:
  Prototype:
  ErrorInD: null
  TestLoad: null
  Guid: null
  Error: null
  TestD: null
  Phone: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• ScaleTests (19) -- Related To: ScaleTests (19)

Table: ScaleShiftCapacityTests (18)

Name: ScaleShiftCapacityTests

Display Field: created_user

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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


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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid )
• created_user ( type: esriFieldTypeString, alias: Created By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: Created On, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edited On, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Shift1Load ( type: esriFieldTypeDouble, alias: Shift 1 Load, editable: true, nullable: true, defaultValue: null, modelName: Shift1Load )
• Shift1Error ( type: esriFieldTypeDouble, alias: Shift 1 Error, editable: true, nullable: true, defaultValue: null, modelName: Shift1Error )
• Shift2Load ( type: esriFieldTypeDouble, alias: Shift 2 Load, editable: true, nullable: true, defaultValue: null, modelName: Shift2Load )
• Shift2Error ( type: esriFieldTypeDouble, alias: Shift 2 Error, editable: true, nullable: true, defaultValue: null, modelName: Shift2Error )
• Shift3Load ( type: esriFieldTypeDouble, alias: Shift 3 Load, editable: true, nullable: true, defaultValue: null, modelName: Shift3Load )
• Shift3Error ( type: esriFieldTypeDouble, alias: Shift 3 Error, editable: true, nullable: true, defaultValue: null, modelName: Shift3Error )
• Shift4Load ( type: esriFieldTypeDouble, alias: Shift 4 Load, editable: true, nullable: true, defaultValue: null, modelName: Shift4Load )
• Shift4Error ( type: esriFieldTypeDouble, alias: Shift 4 Error, editable: true, nullable: true, defaultValue: null, modelName: Shift4Error )
• Shift1Reading ( type: esriFieldTypeDouble, alias: Shift 1 Reading, editable: true, nullable: true, defaultValue: null, modelName: Shift1Reading )
• Shift1ErrorInD ( type: esriFieldTypeDouble, alias: Shift 1 Error In D, editable: true, nullable: true, defaultValue: null, modelName: Shift1ErrorInD )
• Shift2Reading ( type: esriFieldTypeDouble, alias: Shift 2 Reading, editable: true, nullable: true, defaultValue: null, modelName: Shift2Reading )
• Shift2ErrorInD ( type: esriFieldTypeDouble, alias: Shift 2 Error In D, editable: true, nullable: true, defaultValue: null, modelName: Shift2ErrorInD )
• Shift3Reading ( type: esriFieldTypeDouble, alias: Shift 3 Reading, editable: true, nullable: true, defaultValue: null, modelName: Shift3Reading )
• Shift3ErrorInD ( type: esriFieldTypeDouble, alias: Shift 3 Error In D, editable: true, nullable: true, defaultValue: null, modelName: Shift3ErrorInD )
• Shift4Reading ( type: esriFieldTypeDouble, alias: Shift 4 Reading, editable: true, nullable: true, defaultValue: null, modelName: Shift4Reading )
• Shift4ErrorInD ( type: esriFieldTypeDouble, alias: Shift 4 Error In D, editable: true, nullable: true, defaultValue: null, modelName: Shift4ErrorInD )
Templates:
• Name: ScaleShiftCapacityTests
  Description:
  Prototype:
  Shift4Reading: null
  Shift3ErrorInD: null
  Shift4ErrorInD: null
  Guid: null
  Shift3Reading: null
  Shift2ErrorInD: null
  Shift2Reading: null
  Shift1ErrorInD: null
  Shift1Load: null
  Shift1Error: null
  Shift2Load: null
  Shift2Error: null
  Shift3Load: null
  Shift3Error: null
  Shift4Load: null
  Shift4Error: null
  Shift1Reading: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• ScaleTests (20) -- Related To: ScaleTests (19)

Table: ScaleTests (19)

Name: ScaleTests

Display Field: inspCompanyName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GroceryStoreID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: Record Created By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: Record Created On, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• inspectionDate ( type: esriFieldTypeDate, alias: Date of Inspection, editable: true, nullable: false, length: 8, defaultValue: null, modelName: inspectionDate )
• inspector ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Inspector )
• operator ( type: esriFieldTypeString, alias: Operator, editable: true, nullable: true, length: 50, defaultValue: null, modelName: operator )
• operatorPhone ( type: esriFieldTypeDouble, alias: Operator Phone, editable: true, nullable: true, defaultValue: null, modelName: operatorPhone )
• operatorEmail ( type: esriFieldTypeString, alias: Operator's Email, editable: true, nullable: true, length: 50, defaultValue: null, modelName: operatorEmail )
• TestType ( type: esriFieldTypeInteger, alias: Test Type, editable: true, nullable: false, defaultValue: 0, modelName: TestType , Coded Values: [0: Routine Inspection] , [1: Courtesy Inspection] , [2: Complaint] )
• ScaleType ( type: esriFieldTypeString, alias: Scale Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ScaleType , Coded Values: [Computing Scale: Computing Scale] , [Counter/Bench Scale Non-computing =<500: Counter/Bench Scale Non-computing =<500] , [Platform/Floor Scale <= 5000lbs: Platform/Floor Scale <= 5000lbs] , ...14 more... )
• Scale ( type: esriFieldTypeString, alias: Scale, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Scale )
• ScaleLocation ( type: esriFieldTypeString, alias: Scale Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ScaleLocation )
• MakeOfScale ( type: esriFieldTypeString, alias: Make of Scale, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MakeOfScale )
• ModelType ( type: esriFieldTypeString, alias: Model Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ModelType )
• SerielNo ( type: esriFieldTypeString, alias: Scale Seriel Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SerielNo )
• Capacity ( type: esriFieldTypeString, alias: Capacity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Capacity )
• Division ( type: esriFieldTypeString, alias: Division, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Division )
• NumOfD ( type: esriFieldTypeInteger, alias: Number of (d), editable: true, nullable: true, defaultValue: null, modelName: NumOfDiv )
• SealCondition ( type: esriFieldTypeString, alias: Seal Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SealCondition , Coded Values: [Intact: Intact] , [Broken: Broke] , [Missing: Missing] )
• ZeroLoadBalance ( type: esriFieldTypeSmallInteger, alias: Zero Load Balance, editable: true, nullable: true, defaultValue: null, modelName: ZeroLoadBalance )
• AZSM ( type: esriFieldTypeSmallInteger, alias: AZSM, editable: true, nullable: true, defaultValue: null, modelName: AZSM , Coded Values: [0: Does Not Meet Requirements] , [1: Meets Requirements] , [2: Not Applicable] )
• LevelCondition ( type: esriFieldTypeSmallInteger, alias: Level Condition, editable: true, nullable: true, defaultValue: null, modelName: LevelCondition , Coded Values: [0: Does Not Meet Requirements] , [1: Meets Requirements] , [2: Not Applicable] )
• SupportForScale ( type: esriFieldTypeSmallInteger, alias: Support For Scale, editable: true, nullable: true, defaultValue: null, modelName: SupportForScale , Coded Values: [0: Does Not Meet Requirements] , [1: Meets Requirements] , [2: Not Applicable] )
• SuitableForEnvironment ( type: esriFieldTypeSmallInteger, alias: Suitable For Environment, editable: true, nullable: true, defaultValue: null, modelName: SuitableForEnvironment , Coded Values: [0: Does Not Meet Requirements] , [1: Meets Requirements] , [2: Not Applicable] )
• CustomerIndications ( type: esriFieldTypeSmallInteger, alias: Customer Indications, editable: true, nullable: true, defaultValue: null, modelName: CustomerIndications , Coded Values: [0: Does Not Meet Requirements] , [1: Meets Requirements] , [2: Not Applicable] )
• PrinterRequirements ( type: esriFieldTypeSmallInteger, alias: Printer Requirements, editable: true, nullable: true, defaultValue: null, modelName: PrinterRequirements , Coded Values: [0: Does Not Meet Requirements] , [1: Meets Requirements] , [2: Not Applicable] )
• TareCapabilities ( type: esriFieldTypeSmallInteger, alias: Tare Capabilities, editable: true, nullable: true, defaultValue: null, modelName: TareCapabilities , Coded Values: [0: Does Not Meet Requirements] , [1: Meets Requirements] , [2: Not Applicable] )
• SRatZero ( type: esriFieldTypeSmallInteger, alias: SR at Zero, editable: true, nullable: true, defaultValue: null, modelName: SRatZero , Coded Values: [0: Does Not Meet Requirements] , [1: Meets Requirements] , [2: Not Applicable] )
• SRatMax ( type: esriFieldTypeSmallInteger, alias: SR at Max, editable: true, nullable: true, defaultValue: null, modelName: SRatMax , Coded Values: [0: Does Not Meet Requirements] , [1: Meets Requirements] , [2: Not Applicable] )
• IncLoadTest ( type: esriFieldTypeSmallInteger, alias: Inc. Load Test, editable: true, nullable: true, defaultValue: null, modelName: IncLoadTest , Coded Values: [0: Does Not Meet Requirements] , [1: Meets Requirements] , [2: Not Applicable] )
• ShiftTest ( type: esriFieldTypeSmallInteger, alias: Shift Test, editable: true, nullable: true, defaultValue: null, modelName: ShiftTest , Coded Values: [0: Does Not Meet Requirements] , [1: Meets Requirements] , [2: Not Applicable] )
• DecLoadTest ( type: esriFieldTypeSmallInteger, alias: Dec. Load Test, editable: true, nullable: true, defaultValue: null, modelName: DecLoadTest , Coded Values: [0: Does Not Meet Requirements] , [1: Meets Requirements] , [2: Not Applicable] )
• ReturnToZero ( type: esriFieldTypeSmallInteger, alias: Return To Zero, editable: true, nullable: true, defaultValue: null, modelName: ReturnToZero , Coded Values: [0: Does Not Meet Requirements] , [1: Meets Requirements] , [2: Not Applicable] )
• MoneyValueComps ( type: esriFieldTypeSmallInteger, alias: Money Value Comps, editable: true, nullable: true, defaultValue: null, modelName: MoneyValueComps , Coded Values: [0: Does Not Meet Requirements] , [1: Meets Requirements] , [2: Not Applicable] )
• ScaleMeetsAllTolerances ( type: esriFieldTypeSmallInteger, alias: Scale Meets All Tolerances, editable: true, nullable: true, defaultValue: null, modelName: ScaleMeetsAllTolerances , Coded Values: [0: No] , [1: Yes] )
• ScaleIs ( type: esriFieldTypeSmallInteger, alias: Scale Is, editable: true, nullable: true, defaultValue: null, modelName: ScaleIs , Coded Values: [0: Sealed] , [1: Rejected for Repair] , [2: Condemned from Use Until Repaired] )
• Remarks ( type: esriFieldTypeString, alias: Remarks, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: Remarks )
• Error ( type: esriFieldTypeSmallInteger, alias: Error, editable: true, nullable: true, defaultValue: null, modelName: Error , Coded Values: [0: No] , [1: Yes] )
• ReinspectionRequired ( type: esriFieldTypeSmallInteger, alias: Reinspection Required, editable: true, nullable: true, defaultValue: null, modelName: ReinspectionRequired , Coded Values: [0: No] , [1: Yes] )
• inspCompanyAdd ( type: esriFieldTypeString, alias: Inspection Company Address, editable: true, nullable: true, length: 200, defaultValue: null, modelName: inspCompanyAdd )
• inspCompanyName ( type: esriFieldTypeString, alias: Inspection Company Name, editable: true, nullable: true, length: 200, defaultValue: null, modelName: inspCompanyName )
• isARetest ( type: esriFieldTypeSmallInteger, alias: Test is a re-test?, editable: true, nullable: true, defaultValue: null, modelName: isARetest , Coded Values: [0: No] , [1: Yes] )
• establishmentType ( type: esriFieldTypeString, alias: Establishment Type, editable: true, nullable: false, length: 50, defaultValue: null, modelName: establishmentType , Coded Values: [Supermarket: Supermarket] , [Gas/Fuel Station: Gas/Fuel Station] , [Convenience Store: Convenience Store] , ...17 more... )
• Resolved ( type: esriFieldTypeSmallInteger, alias: Resolved, editable: true, nullable: true, defaultValue: null, modelName: Resolved , Coded Values: [0: No] , [1: Yes] )
• ResolutionDate ( type: esriFieldTypeDate, alias: Resolution Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ResolutionDate )
• ResolutionComments ( type: esriFieldTypeString, alias: Resolution Comments, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: ResolutionComments )
Templates:
• Name: ScaleTests
  Description:
  Prototype:
  ResolutionDate: null
  Resolved: null
  Guid: null
  ResolutionComments: null
  establishmentType:
  isARetest: null
  inspCompanyName: null
  inspCompanyAdd: null
  inspectionDate: -2209161600000
  inspector: null
  operator: null
  operatorPhone: null
  operatorEmail: null
  TestType: 0
  ScaleType: null
  Scale: null
  ScaleLocation: null
  MakeOfScale: null
  ModelType: null
  SerielNo: null
  Capacity: null
  Division: null
  NumOfD: null
  SealCondition: null
  ZeroLoadBalance: null
  AZSM: null
  LevelCondition: null
  SupportForScale: null
  SuitableForEnvironment: null
  CustomerIndications: null
  PrinterRequirements: null
  TareCapabilities: null
  SRatZero: null
  SRatMax: null
  IncLoadTest: null
  ShiftTest: null
  DecLoadTest: null
  ReturnToZero: null
  MoneyValueComps: null
  ScaleMeetsAllTolerances: null
  ScaleIs: null
  Remarks: null
  Error: null
  ReinspectionRequired: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• ScaleShiftCapacityTests (20) -- Related To: ScaleShiftCapacityTests (18)
• ScalePerformanceTests (19) -- Related To: ScalePerformanceTests (17)
• InspectionSites (3) -- Related To: InspectionSites (0)

Table: skimmerCheck (20)

Name: skimmerCheck

Display Field: inspCompanyName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• Guid ( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid )
• TestType ( type: esriFieldTypeInteger, alias: Test Type, editable: true, nullable: false, defaultValue: 0, modelName: TestType , Coded Values: [0: Routine Inspection] , [1: Courtesy Inspection] , [2: Complaint] )
• created_user ( type: esriFieldTypeString, alias: Created By, 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 By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• inspectionDate ( type: esriFieldTypeDate, alias: Date of Inspection, editable: true, nullable: false, length: 8, defaultValue: null, modelName: inspectionDate )
• inspector ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Inspector )
• SkimmerFound ( type: esriFieldTypeSmallInteger, alias: Skimmer Found, editable: true, nullable: true, defaultValue: null, modelName: SkimmerFound , Coded Values: [0: No] , [1: Yes] )
• numOfFuelDispensers ( type: esriFieldTypeSmallInteger, alias: # of Fuel Dispensers, editable: true, nullable: true, defaultValue: null, modelName: numOfFuelDispensers )
• pumpNumber ( type: esriFieldTypeString, alias: Pump Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: pumpNumber )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: Notes )
• operator ( type: esriFieldTypeString, alias: Operator, editable: true, nullable: true, length: 50, defaultValue: null, modelName: operator )
• operatorPhone ( type: esriFieldTypeDouble, alias: Operator Phone, editable: true, nullable: true, defaultValue: null, modelName: operatorPhone )
• operatorEmail ( type: esriFieldTypeString, alias: Operator's Email, editable: true, nullable: false, length: 50, defaultValue: null, modelName: operatorEmail )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• inspCompanyAdd ( type: esriFieldTypeString, alias: Inspection Company Address, editable: true, nullable: true, length: 200, defaultValue: null, modelName: inspCompanyAdd )
• inspCompanyName ( type: esriFieldTypeString, alias: Inspection Company Name, editable: true, nullable: true, length: 200, defaultValue: null, modelName: inspCompanyName )
• isARetest ( type: esriFieldTypeSmallInteger, alias: Test is a re-test? , editable: true, nullable: true, defaultValue: null, modelName: isARetest , Coded Values: [0: No] , [1: Yes] )
• establishmentType ( type: esriFieldTypeString, alias: Establishment Type, editable: true, nullable: false, length: 50, defaultValue: null, modelName: establishmentType , Coded Values: [Supermarket: Supermarket] , [Gas/Fuel Station: Gas/Fuel Station] , [Convenience Store: Convenience Store] , ...17 more... )
• Resolved ( type: esriFieldTypeSmallInteger, alias: Resolved, editable: true, nullable: true, defaultValue: null, modelName: Resolved , Coded Values: [0: No] , [1: Yes] )
• ResolutionDate ( type: esriFieldTypeDate, alias: Resolution Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ResolutionDate )
• ResolutionComments ( type: esriFieldTypeString, alias: Resolution Comments, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: ResolutionComments )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
Templates:
• Name: skimmerCheck
  Description:
  Prototype:
  ResolutionComments: null
  Guid: null
  TestType: 0
  Resolved: null
  establishmentType:
  isARetest: null
  inspCompanyName: null
  inspectionDate: -2209161600000
  inspector: null
  SkimmerFound: null
  numOfFuelDispensers: null
  pumpNumber: null
  Notes: null
  operator: null
  operatorPhone: null
  operatorEmail:
  ResolutionDate: null
  inspCompanyAdd: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• InspectionSites (7) -- Related To: InspectionSites (0)

Table: vehicleScaleAsFoundLoadCal (21)

Name: vehicleScaleAsFoundLoadCal

Display Field: created_user

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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


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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid )
• calibrationLoadAsFound ( type: esriFieldTypeDouble, alias: Calibration Load As Found, editable: true, nullable: true, defaultValue: null, modelName: calibrationLoadAsFound )
• calibrationWeightAsFound ( type: esriFieldTypeDouble, alias: Calibration Weight As Found, editable: true, nullable: true, defaultValue: null, modelName: calibrationWeightAsFound )
• calibrationTotalAsFound ( type: esriFieldTypeDouble, alias: Total Weight As Found, editable: true, nullable: true, defaultValue: null, modelName: calibrationTotalAsFound )
• readingAsFound ( type: esriFieldTypeDouble, alias: Reading As Found, editable: true, nullable: true, defaultValue: null, modelName: readingAsFound )
• errorAsFound ( type: esriFieldTypeDouble, alias: Error As Found, editable: true, nullable: true, defaultValue: null, modelName: errorAsFound )
• created_user ( type: esriFieldTypeString, alias: Created By, 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 By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
Templates:
• Name: vehicleScaleAsFoundLoadCal
  Description:
  Prototype:
  readingAsFound: null
  errorAsFound: null
  calibrationTotalAsFound: null
  Guid: null
  calibrationLoadAsFound: null
  calibrationWeightAsFound: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• vehicleScaleTest (21) -- Related To: vehicleScaleTest (27)

Table: vehicleScaleAsFoundTestReadings (22)

Name: vehicleScaleAsFoundTestReadings

Display Field: created_user

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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


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 )
• Guid ( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: Created By, 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 By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• asFoundweightApplied ( type: esriFieldTypeDouble, alias: Weight Applied, editable: true, nullable: true, defaultValue: null, modelName: asFoundweightApplied )
• asFoundReading ( type: esriFieldTypeDouble, alias: Reading, editable: true, nullable: true, defaultValue: null, modelName: asFoundReading )
• asFoundError ( type: esriFieldTypeDouble, alias: Error, editable: true, nullable: true, defaultValue: null, modelName: asFoundError )
• asFoundTotal ( type: esriFieldTypeDouble, alias: Total, editable: true, nullable: true, defaultValue: null, modelName: asFoundTotal )
Templates:
• Name: vehicleScaleAsFoundTestReadings
  Description:
  Prototype:
  asFoundError: null
  asFoundReading: null
  Guid: null
  asFoundTotal: null
  asFoundweightApplied: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• vehicleScaleTest (22) -- Related To: vehicleScaleTest (27)

Table: vehicleScaleAsLeftLoadCal (23)

Name: vehicleScaleAsLeftLoadCal

Display Field: errorAsLeft

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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


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 )
• Guid ( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: Created By, 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 By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• calibrationLoadAsLeft ( type: esriFieldTypeDouble, alias: Calibration Load As Left, editable: true, nullable: true, defaultValue: null, modelName: calibrationLoadAsLeft )
• calibrationWeightAsLeft ( type: esriFieldTypeDouble, alias: Calibration Weight As Found, editable: true, nullable: true, defaultValue: null, modelName: calibrationWeightAsLeft )
• calibrationTotalAsLeft ( type: esriFieldTypeDouble, alias: Calibration Total As Found, editable: true, nullable: true, defaultValue: null, modelName: calibrationTotalAsLeft )
• readingAsLeft ( type: esriFieldTypeDouble, alias: Reading, editable: true, nullable: true, defaultValue: null, modelName: readingAsLeft )
• errorAsLeft ( type: esriFieldTypeString, alias: Error As Left, editable: true, nullable: true, length: 50, defaultValue: null, modelName: errorAsLeft )
Templates:
• Name: vehicleScaleAsLeftLoadCal
  Description:
  Prototype:
  readingAsLeft: null
  calibrationTotalAsLeft: null
  Guid: null
  errorAsLeft: null
  calibrationWeightAsLeft: null
  calibrationLoadAsLeft: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• vehicleScaleTest (23) -- Related To: vehicleScaleTest (27)

Table: vehicleScaleAsLeftTestReadings (24)

Name: vehicleScaleAsLeftTestReadings

Display Field: created_user

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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


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 )
• Guid ( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: Created By, 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 By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• asLeftweightApplied ( type: esriFieldTypeDouble, alias: Weight Applied, editable: true, nullable: true, defaultValue: null, modelName: asFoundweightApplied )
• asLeftReading ( type: esriFieldTypeDouble, alias: Reading, editable: true, nullable: true, defaultValue: null, modelName: asFoundReading )
• asLeftError ( type: esriFieldTypeDouble, alias: Error, editable: true, nullable: true, defaultValue: null, modelName: asFoundError )
• asLeftTotal ( type: esriFieldTypeDouble, alias: Total, editable: true, nullable: true, defaultValue: null, modelName: asFoundTotal )
Templates:
• Name: vehicleScaleAsLeftTestReadings
  Description:
  Prototype:
  asLeftError: null
  asLeftReading: null
  Guid: null
  asLeftTotal: null
  asLeftweightApplied: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• vehicleScaleTest (24) -- Related To: vehicleScaleTest (27)

Table: vehicleScaleDecreasingLoadTests (25)

Name: vehicleScaleDecreasingLoadTests

Display Field: created_user

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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


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 )
• guid ( type: esriFieldTypeGUID, alias: guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: guid )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: Created By, 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 By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• decreasingWtApplied ( type: esriFieldTypeDouble, alias: Decreasing Wt Applied, editable: true, nullable: true, defaultValue: null, modelName: decreasingWtApplied )
• decreasingReading ( type: esriFieldTypeDouble, alias: Decreasing Reading, editable: true, nullable: true, defaultValue: null, modelName: decreasingReading )
• decreasingError ( type: esriFieldTypeDouble, alias: Decreasing Error, editable: true, nullable: true, defaultValue: null, modelName: decreasingError )
• decreasingTotal ( type: esriFieldTypeDouble, alias: Decreasing Total, editable: true, nullable: true, defaultValue: null, modelName: decreasingTotal )
Templates:
• Name: vehicleScaleDecreasingLoadTests
  Description:
  Prototype:
  decreasingError: null
  decreasingReading: null
  guid: null
  decreasingTotal: null
  decreasingWtApplied: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• vehicleScaleTest (25) -- Related To: vehicleScaleTest (27)

Table: vehicleScaleIncreasingLoadTests (26)

Name: vehicleScaleIncreasingLoadTests

Display Field: created_user

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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


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 )
• guid ( type: esriFieldTypeGUID, alias: guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: guid )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: Created By, 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 By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• increasingWtApplied ( type: esriFieldTypeDouble, alias: Increasing Weight Applied, editable: true, nullable: true, defaultValue: null, modelName: increasingWtApplied )
• increasingReading ( type: esriFieldTypeDouble, alias: Increasing Reading, editable: true, nullable: true, defaultValue: null, modelName: increasingReading )
• increasingError ( type: esriFieldTypeDouble, alias: Increasing Error, editable: true, nullable: true, defaultValue: null, modelName: increasingError )
• increasingTotal ( type: esriFieldTypeDouble, alias: Increasing Total, editable: true, nullable: true, defaultValue: null, modelName: increasingTotal )
Templates:
• Name: vehicleScaleIncreasingLoadTests
  Description:
  Prototype:
  increasingError: null
  increasingReading: null
  guid: null
  increasingTotal: null
  increasingWtApplied: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• vehicleScaleTest (26) -- Related To: vehicleScaleTest (27)

Table: vehicleScaleTest (27)

Name: vehicleScaleTest

Display Field: inspCompanyName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Guid ( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• testType ( type: esriFieldTypeInteger, alias: Test Type, editable: true, nullable: false, defaultValue: 0, modelName: testType , Coded Values: [0: Routine Inspection] , [1: Courtesy Inspection] , [2: Complaint] )
• created_user ( type: esriFieldTypeString, alias: Created By, 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 By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• inspectionDate ( type: esriFieldTypeDate, alias: Date of Inspection, editable: true, nullable: false, length: 8, defaultValue: null, modelName: inspectionDate )
• inspector ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Inspector )
• indicatorMake ( type: esriFieldTypeString, alias: Indicator Make, editable: true, nullable: true, length: 50, defaultValue: null, modelName: indicatorMake )
• indicatorSerial ( type: esriFieldTypeString, alias: Indicator Serial #, editable: true, nullable: true, length: 50, defaultValue: null, modelName: indicatorSerial )
• indicatorModelNum ( type: esriFieldTypeString, alias: Indicator Model #, editable: true, nullable: true, length: 50, defaultValue: null, modelName: indicatorModelNum )
• scaleCapacity ( type: esriFieldTypeString, alias: Scale Capacity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: scaleCapacity )
• platformMake ( type: esriFieldTypeString, alias: Platform Make, editable: true, nullable: true, length: 50, defaultValue: null, modelName: platformMake )
• platformSerial ( type: esriFieldTypeString, alias: Platform Serial #, editable: true, nullable: true, length: 50, defaultValue: null, modelName: platformSerial )
• platformModelNum ( type: esriFieldTypeString, alias: Platform Model #, editable: true, nullable: true, length: 50, defaultValue: null, modelName: platformModelNum )
• CLC ( type: esriFieldTypeString, alias: CLC, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CLC )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: Comments )
• operator ( type: esriFieldTypeString, alias: Operator, editable: true, nullable: true, length: 50, defaultValue: null, modelName: operator )
• operatorPhone ( type: esriFieldTypeDouble, alias: Operator Phone, editable: true, nullable: true, defaultValue: null, modelName: operatorPhone )
• operatorEmail ( type: esriFieldTypeString, alias: Operator's Email, editable: true, nullable: false, length: 50, defaultValue: null, modelName: operatorEmail )
• inspCompanyAdd ( type: esriFieldTypeString, alias: Inspection Company Address, editable: true, nullable: true, length: 200, defaultValue: null, modelName: inspCompanyAdd )
• inspCompanyName ( type: esriFieldTypeString, alias: Inspection Company Name, editable: true, nullable: true, length: 200, defaultValue: null, modelName: inspCompanyName )
• isARetest ( type: esriFieldTypeSmallInteger, alias: Test is a re-test?, editable: true, nullable: true, defaultValue: null, modelName: isARetest , Coded Values: [0: No] , [1: Yes] )
• passFail ( type: esriFieldTypeString, alias: Pass/Fail, editable: true, nullable: true, length: 50, defaultValue: null, modelName: passFail , Coded Values: [Pass: Pass] , [Fail: Fail] )
• establishmentType ( type: esriFieldTypeString, alias: Establishment Type, editable: true, nullable: false, length: 50, defaultValue: null, modelName: establishmentType , Coded Values: [Supermarket: Supermarket] , [Gas/Fuel Station: Gas/Fuel Station] , [Convenience Store: Convenience Store] , ...17 more... )
• Resolved ( type: esriFieldTypeSmallInteger, alias: Resolved, editable: true, nullable: true, defaultValue: null, modelName: Resolved , Coded Values: [0: No] , [1: Yes] )
• ResolutionDate ( type: esriFieldTypeDate, alias: Resolution Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ResolutionDate )
• ResolutionComments ( type: esriFieldTypeString, alias: Resolution Comments, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: ResolutionComments )
Templates:
• Name: vehicleScaleTest
  Description:
  Prototype:
  ResolutionDate: null
  Resolved: null
  Guid: null
  ResolutionComments: null
  testType: 0
  establishmentType:
  passFail: null
  isARetest: null
  inspCompanyName: null
  inspectionDate: -2209161600000
  inspector: null
  indicatorMake: null
  indicatorSerial: null
  indicatorModelNum: null
  scaleCapacity: null
  platformMake: null
  platformSerial: null
  platformModelNum: null
  CLC: null
  Comments: null
  operator: null
  operatorPhone: null
  operatorEmail:
  inspCompanyAdd: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• vehicleScaleTestSectionShiftCal (27) -- Related To: vehicleScaleTestSectionShiftCalibration (28)
• vehicleScaleAsFoundLoadCal (21) -- Related To: vehicleScaleAsFoundLoadCal (21)
• vehicleScaleAsLeftTestReadings (24) -- Related To: vehicleScaleAsLeftTestReadings (24)
• vehicleScaleIncreasingLoadTests (26) -- Related To: vehicleScaleIncreasingLoadTests (26)
• vehicleScaleAsLeftLoadCal (23) -- Related To: vehicleScaleAsLeftLoadCal (23)
• vehicleScaleAsFoundTestReadings (22) -- Related To: vehicleScaleAsFoundTestReadings (22)
• vehicleScaleDecreasingLoadTests (25) -- Related To: vehicleScaleDecreasingLoadTests (25)
• InspectionSites (11) -- Related To: InspectionSites (0)

Table: vehicleScaleTestSectionShiftCalibration (28)

Name: vehicleScaleTestSectionShiftCalibration

Display Field: sectionNum

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 74ddcd7fe0d24d69a16454b8f2af2080

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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


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 )
• Guid ( type: esriFieldTypeGUID, alias: Guid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Guid )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: Created By, 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 By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• sectionNum ( type: esriFieldTypeString, alias: Section Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: sectionNum )
• asFoundReading1 ( type: esriFieldTypeDouble, alias: As Found Reading 1, editable: true, nullable: true, defaultValue: null, modelName: asFoundReading1 )
• asFoundReading2 ( type: esriFieldTypeDouble, alias: As Found Reading 2, editable: true, nullable: true, defaultValue: null, modelName: asFoundReading2 )
• asFoundReading3 ( type: esriFieldTypeDouble, alias: As Found Reading 3, editable: true, nullable: true, defaultValue: null, modelName: asFoundReading3 )
• asFoundReading4 ( type: esriFieldTypeDouble, alias: As Found Reading 4, editable: true, nullable: true, defaultValue: null, modelName: asFoundReading4 )
• varianceError ( type: esriFieldTypeDouble, alias: Variance/Error, editable: true, nullable: true, defaultValue: null, modelName: varianceError )
• tolerance ( type: esriFieldTypeDouble, alias: Tolerance, editable: true, nullable: true, defaultValue: null, modelName: tolerance )
Templates:
• Name: vehicleScaleTestSectionShiftCalibration
  Description:
  Prototype:
  varianceError: null
  asFoundReading4: null
  Guid: null
  tolerance: null
  asFoundReading3: null
  asFoundReading2: null
  asFoundReading1: null
  sectionNum: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• vehicleScaleTest (27) -- Related To: vehicleScaleTest (27)