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)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata