Name: KSM_SDE.DBO.FLEET

Display Field: ASSETID

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ASSETID (type: esriFieldTypeString, alias: ASSETID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MODEL (type: esriFieldTypeString, alias: MODEL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DESCRIPTION (type: esriFieldTypeString, alias: DESCRIPTION, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• VIN (type: esriFieldTypeString, alias: VIN, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LICENSE (type: esriFieldTypeString, alias: LICENSE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MANUFACTURER (type: esriFieldTypeString, alias: MANUFACTURER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CAPITAL (type: esriFieldTypeString, alias: CAPITAL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RATE_TYPE (type: esriFieldTypeString, alias: RATE TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LOCATION (type: esriFieldTypeString, alias: LOCATION, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DEPARTMENT (type: esriFieldTypeString, alias: DEPARTMENT, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• COST_CENTRE (type: esriFieldTypeString, alias: COST_CENTRE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• REGISTRATION_RENEWAL (type: esriFieldTypeDate, alias: REGISTRATION RENEWAL, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• EMISSION_TEST (type: esriFieldTypeDate, alias: EMISSION TEST DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• INSURANCE_RENEWAL (type: esriFieldTypeDate, alias: INSURANCE RENEWAL, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• IMAGE_ (type: esriFieldTypeString, alias: IMAGE_, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• WarrantyDate (type: esriFieldTypeDate, alias: WarrantyDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CFACID (type: esriFieldTypeString, alias: CFACID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MILEAGE (type: esriFieldTypeString, alias: MILEAGE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ConditionDate (type: esriFieldTypeDate, alias: ConditionDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• InspCondition (type: esriFieldTypeSmallInteger, alias: InspCondition, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAKE (type: esriFieldTypeString, alias: MAKE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• YEAR (type: esriFieldTypeString, alias: YEAR, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MODELTYPE (type: esriFieldTypeString, alias: MODELTYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• iPOF (type: esriFieldTypeDouble, alias: iPOF, SQL Type: sqlTypeOther, nullable: true, editable: true)
• iCOF (type: esriFieldTypeDouble, alias: iCOF, SQL Type: sqlTypeOther, nullable: true, editable: true)
• iBRE (type: esriFieldTypeDouble, alias: iBRE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• iMSPU (type: esriFieldTypeDouble, alias: iMSPU, SQL Type: sqlTypeOther, nullable: true, editable: true)
• iMSPO (type: esriFieldTypeDouble, alias: iMSPO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• iCalcDate (type: esriFieldTypeDate, alias: iCalcDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)

Templates:

Name: KSM_SDE.DBO.FLEET
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• KSMMS_SDE.DBO.FLEET_INSURANCE (0) -- Related To: KSM_SDE.DBO.FLEET_INSURANCE (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/10/2024 6:34:03 PM

Schema Last Edit Date: 7/10/2024 6:34:03 PM

Data Last Edit Date: 7/10/2024 6:34:03 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat