Name: AuditPackTest
Display Field: inspCompanyName
Type: Table
Geometry Type: N/A
Description: null
Service Item Id: df1e411da35243ef85d223365c03d74a
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 2000
Supported Query Formats: JSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
HasZ: false
HasM: false
Has Attachments: true
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: null
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
guid
(
type: esriFieldTypeGUID, alias: guid, length: 38
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, length: 38
)
-
created_user
(
type: esriFieldTypeString, alias: Created By, length: 255
)
-
created_date
(
type: esriFieldTypeDate, alias: Created On, length: 8
)
-
last_edited_user
(
type: esriFieldTypeString, alias: Last Edited By, length: 255
)
-
last_edited_date
(
type: esriFieldTypeDate, alias: Last Edit Date, length: 8
)
-
inspectionDate
(
type: esriFieldTypeDate, alias: Date of Inspection, length: 8
)
-
inspector
(
type: esriFieldTypeString, alias: Inspector, length: 50
)
-
testType
(
type: esriFieldTypeInteger, alias: Test Type
, Coded Values:
[0: Routine Inspection]
, [1: Courtesy Inspection]
, [2: Complaint]
)
-
productBrandIdentity
(
type: esriFieldTypeString, alias: Product/Brand Identity, length: 50
)
-
lotCodes
(
type: esriFieldTypeString, alias: Lot Codes, length: 50
)
-
Manufacturer
(
type: esriFieldTypeString, alias: Manufacturer, length: 50
)
-
containerDescription
(
type: esriFieldTypeString, alias: Container Description, length: 250
)
-
measurementUnits
(
type: esriFieldTypeString, alias: Measurement Units, length: 50
)
-
inspectionLotSize
(
type: esriFieldTypeSmallInteger, alias: Inspection Lot Size
)
-
sampleSize
(
type: esriFieldTypeSmallInteger, alias: Sample Size (n)
)
-
initialTareSampleSize
(
type: esriFieldTypeSmallInteger, alias: Init. Tare Sample Size
)
-
numberofMAVAllowed
(
type: esriFieldTypeSmallInteger, alias: Number of MAVs Allowed
)
-
rangeOfPackageERrors
(
type: esriFieldTypeSmallInteger, alias: Range of Package Errors (Rc)
)
-
rangeOfTareWeights
(
type: esriFieldTypeSmallInteger, alias: Range of Tare Weights (Rt)
)
-
rcDivrt
(
type: esriFieldTypeDouble, alias: Rc / Rt
)
-
avgTareWt
(
type: esriFieldTypeDouble, alias: Avg. Tare Wt.
)
-
nomialGrossWt
(
type: esriFieldTypeDouble, alias: Nominal Gross Wt
)
-
totalError
(
type: esriFieldTypeDouble, alias: Total Error
)
-
numberOfUnreasonableMinusErrors
(
type: esriFieldTypeSmallInteger, alias: Number of Unreasonable Minus (-) Errors
)
-
box16GTbox8
(
type: esriFieldTypeSmallInteger, alias: Number of Unreasonable Minus Errors > # MAVs Allowed?
, Coded Values:
[0: No]
, [1: Yes]
)
-
AvgErrorinDimlessUnits
(
type: esriFieldTypeDouble, alias: Avg. Error in Dimensionless Units
)
-
avgErrorInLabeledUnits
(
type: esriFieldTypeDouble, alias: Avg. Error in Labeled Units
)
-
sampleStandardDeviation
(
type: esriFieldTypeDouble, alias: Sample Standard Deviation
)
-
sampleCorrectionFactor
(
type: esriFieldTypeDouble, alias: Sample Correction Factor
)
-
sampleErrorLimit
(
type: esriFieldTypeDouble, alias: Sample Error Limit
)
-
box18GTbox23
(
type: esriFieldTypeSmallInteger, alias: Disregarding Signs, is Avg. Error in Dimless Units > Sample Error Limit?
, Coded Values:
[0: No]
, [1: Yes]
)
-
dispositionOfInspectionLot
(
type: esriFieldTypeString, alias: Disposition of Inspection Lot, length: 50
, Coded Values:
[APP: Approve]
, [REJ: Reject]
, [CDM: Condemned]
)
-
Comments
(
type: esriFieldTypeString, alias: Comments, length: 4000
)
-
countMinusErrors
(
type: esriFieldTypeSmallInteger, alias: Count of Minus Errors
)
-
countPlusErrors
(
type: esriFieldTypeSmallInteger, alias: Count of Plus Errors
)
-
operator
(
type: esriFieldTypeString, alias: Operator, length: 50
)
-
operatorPhone
(
type: esriFieldTypeDouble, alias: Operator Phone
)
-
operatorEmail
(
type: esriFieldTypeString, alias: Operator's Email, length: 50
)
-
inspCompanyName
(
type: esriFieldTypeString, alias: Inspection Company Name, length: 200
)
-
inspCompanyAdd
(
type: esriFieldTypeString, alias: Inspection Company Address, length: 200
)
-
box18EqualZeroOrPlus
(
type: esriFieldTypeDouble, alias: Box 18 Equal Zero Or Plus
, Coded Values:
[0: No]
, [1: Yes]
)
-
tareStandardizationType
(
type: esriFieldTypeString, alias: Tare Standardization Type, length: 50
, Coded Values:
[Tare Correction: Tare Correction]
, [Moisture Allowance: Moisture Allowance]
, [Not Applicable: Not Applicable]
)
-
tareWeightType
(
type: esriFieldTypeString, alias: Tare Weight Type, length: 50
, Coded Values:
[Dry: Dry Tare]
, [Wet: Wet Tare]
, [Unused: Unused Dry Tare]
)
-
measurementDivisions
(
type: esriFieldTypeDouble, alias: Measurement Divisions
)
-
samplesToTake
(
type: esriFieldTypeInteger, alias: Samples to Take
)
-
isARetest
(
type: esriFieldTypeSmallInteger, alias: Test is a re-test?
, Coded Values:
[0: No]
, [1: Yes]
)
-
establishmentType
(
type: esriFieldTypeString, alias: Establishment Type, length: 50
, Coded Values:
[Supermarket: Supermarket]
, [Gas/Fuel Station: Gas/Fuel Station]
, [Convenience Store: Convenience Store]
, ...17 more...
)
-
Resolved
(
type: esriFieldTypeSmallInteger, alias: Resolved
, Coded Values:
[0: No]
, [1: Yes]
)
-
ResolutionDate
(
type: esriFieldTypeDate, alias: Resolution Date, length: 8
)
-
ResolutionComments
(
type: esriFieldTypeString, alias: Resolution Comments, length: 1000
)
Relationships:
Supported Operations:
Query
Query Attachments
Query Analytic
Query Related Records
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata