Name: pes_tracker_contracts_prod
Display Field: contractcode
Type: Table
Geometry Type: N/A
Description: N/A
Service Item Id: d53bfe3274da4d04a16f72d381817f57
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 1000
MaxSelectionCount: 0
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:
Feature Draw Order:
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: false
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
-
objectid
(
nullable: false, editable: false, defaultValue: null, length: 4, alias: OBJECTID, type: esriFieldTypeOID
)
-
globalid
(
nullable: false, quotesRequired: true, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID
)
-
contractcode
(
nullable: true, quotesRequired: true, editable: true, defaultValue: null, length: 100, alias: ContractCode, type: esriFieldTypeString
)
-
applicationcode
(
nullable: true, quotesRequired: true, editable: true, defaultValue: null, length: 100, alias: ApplicationCode, type: esriFieldTypeString
)
-
contractstatus
(
nullable: true, quotesRequired: true, editable: true, defaultValue: null, length: 50, alias: ContractStatus, type: esriFieldTypeString
)
-
activitytype
(
nullable: true, quotesRequired: true, editable: true, defaultValue: null, length: 255, alias: ActivityType, type: esriFieldTypeString
)
-
activitystartdate
(
nullable: true, quotesRequired: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: ActivityStartDate, type: esriFieldTypeDate
)
-
currency
(
nullable: true, quotesRequired: true, editable: true, defaultValue: null, length: 100, alias: Currency, type: esriFieldTypeString
)
-
contractedpaymentterms
(
nullable: true, quotesRequired: true, editable: true, defaultValue: null, length: 4000, alias: ContractedPaymentTerms, type: esriFieldTypeString
)
-
contractedpaymentmilestones
(
nullable: true, quotesRequired: true, editable: true, defaultValue: null, length: 4000, alias: ContractedPaymentMilestones, type: esriFieldTypeString
)
-
contractedmonitoringmilestones
(
nullable: true, quotesRequired: true, editable: true, defaultValue: null, length: 4000, alias: ContractedMonitoringMilestones, type: esriFieldTypeString
)
-
contractstartdate
(
nullable: true, quotesRequired: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: ContractStartDate, type: esriFieldTypeDate
)
-
contractenddate
(
nullable: true, quotesRequired: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: ContractEndDate, type: esriFieldTypeDate
)
-
contractduration
(
nullable: true, quotesRequired: true, editable: true, defaultValue: null, length: 100, alias: ContractDuration, type: esriFieldTypeString
)
-
contractedpesarea
(
nullable: true, quotesRequired: true, editable: true, defaultValue: null, alias: ContractedPESArea, type: esriFieldTypeDouble
)
-
createddatetime
(
nullable: true, quotesRequired: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: CreatedDateTime, type: esriFieldTypeDate
)
-
updateddatetime
(
nullable: true, quotesRequired: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: UpdatedDateTime, type: esriFieldTypeDate
)
-
plannedvisits
(
nullable: true, quotesRequired: true, editable: true, defaultValue: null, alias: PlannedVisits, type: esriFieldTypeInteger
)
-
plannedpayments
(
nullable: true, quotesRequired: true, editable: true, defaultValue: null, alias: PlannedPayments, type: esriFieldTypeInteger
)
-
paymenttermstotal
(
nullable: true, quotesRequired: true, editable: true, defaultValue: null, alias: PaymentTermsTotal, type: esriFieldTypeDouble
)
-
paymenttermscurrency
(
nullable: true, quotesRequired: true, editable: true, defaultValue: null, length: 50, alias: PaymentTermsCurrency, type: esriFieldTypeString
)
-
visitsdone
(
nullable: true, quotesRequired: true, editable: true, defaultValue: null, alias: VisitsDone, type: esriFieldTypeInteger
)
-
paymentscompleted
(
nullable: true, quotesRequired: true, editable: true, defaultValue: null, alias: PaymentsCompleted, type: esriFieldTypeInteger
)
-
nextvisitdue
(
nullable: true, quotesRequired: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: NextVisitDue, type: esriFieldTypeDate
)
-
nextpaymentdue
(
nullable: true, quotesRequired: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: NextPaymentDue, type: esriFieldTypeDate
)
-
milestonedateerrors
(
nullable: true, quotesRequired: true, editable: true, defaultValue: null, alias: MilestoneDateErrors, type: esriFieldTypeInteger
)
-
recordhash
(
nullable: true, quotesRequired: true, editable: true, defaultValue: null, length: 64, alias: RecordHash, type: esriFieldTypeString
)
-
lastchangedat
(
nullable: true, quotesRequired: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: LastChangedAt, type: esriFieldTypeDate
)
Capabilities: Query
Sync Can Return Changes: true
Is Data Versioned: false
Supports Rollback On Failure: true
Supports ApplyEdits With Global Ids: true
Supports ApplyEdits By Upload Id: true
Supports Query With Historic Moment: false
Supports Coordinates Quantization: true
Child Resources:
Supported Operations:
Query
Query Attachments
Query Analytic
Query Top Features
Query Bins
Append
Validate SQL
Generate Renderer
Return Updates
Metadata
Update Metadata