Name: MMtblAsset_XYTableToPoint

Display Field: NameLastOrCompany

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 7596902.50581276
YMin: 643942.03619424
XMax: 7785498.42656497
YMax: 731725.13063495
Spatial Reference: 2913 (2913)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[165,61,139,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: AssetID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Asset (type: esriFieldTypeString, alias: Asset, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• PropertyID (type: esriFieldTypeInteger, alias: PropertyID, SQL Type: sqlTypeOther, nullable: false, editable: true)
• BuildingID (type: esriFieldTypeInteger, alias: BuildingID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FloorID (type: esriFieldTypeInteger, alias: FloorID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ParentID (type: esriFieldTypeInteger, alias: ParentID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Active (type: esriFieldTypeInteger, alias: Active, SQL Type: sqlTypeOther, nullable: false, editable: true)
• Description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Type (type: esriFieldTypeString, alias: Type, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• Manufacturer (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Supplier (type: esriFieldTypeString, alias: Supplier, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Account (type: esriFieldTypeString, alias: Account, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• ModelNumber (type: esriFieldTypeString, alias: ModelNumber, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DateInstall (type: esriFieldTypeDate, alias: DateInstall, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DateDisposal (type: esriFieldTypeDate, alias: DateDisposal, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SerialNumber (type: esriFieldTypeString, alias: SerialNumber, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DatePurchased (type: esriFieldTypeDate, alias: DatePurchased, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DateReplace (type: esriFieldTypeDate, alias: DateReplace, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CostInstall (type: esriFieldTypeDouble, alias: CostInstall, SQL Type: sqlTypeOther, nullable: false, editable: true)
• CostReplacement (type: esriFieldTypeDouble, alias: CostReplacement, SQL Type: sqlTypeOther, nullable: false, editable: true)
• DateMoveIn (type: esriFieldTypeDate, alias: DateMoveIn, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DateMoveOut (type: esriFieldTypeDate, alias: DateMoveOut, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DateLeaseExpire (type: esriFieldTypeDate, alias: DateLeaseExpire, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• NameLastOrCompany (type: esriFieldTypeString, alias: NameLastOrCompany, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• NameFirst (type: esriFieldTypeString, alias: NameFirst, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Phone (type: esriFieldTypeString, alias: Phone, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Fax (type: esriFieldTypeString, alias: Fax, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• SquareFeet (type: esriFieldTypeSingle, alias: SquareFeet, SQL Type: sqlTypeOther, nullable: false, editable: true)
• TenantPrevious (type: esriFieldTypeString, alias: TenantPrevious, SQL Type: sqlTypeOther, length: 130, nullable: true, editable: true)
• DateLastMaintained (type: esriFieldTypeDate, alias: DateLastMaintained, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ReserveForReplacement (type: esriFieldTypeInteger, alias: ReserveForReplacement, SQL Type: sqlTypeOther, nullable: false, editable: true)
• CommentToWO (type: esriFieldTypeInteger, alias: CommentToWO, SQL Type: sqlTypeOther, nullable: false, editable: true)
• UDF1 (type: esriFieldTypeString, alias: UDF1, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UDF2 (type: esriFieldTypeString, alias: UDF2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UDF3 (type: esriFieldTypeString, alias: UDF3, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UDF4 (type: esriFieldTypeString, alias: UDF4, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UDF5 (type: esriFieldTypeString, alias: UDF5, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ControlNumber (type: esriFieldTypeString, alias: ControlNumber, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Longitude (type: esriFieldTypeString, alias: Longitude, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Latitude (type: esriFieldTypeString, alias: Latitude, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Altitude (type: esriFieldTypeString, alias: Altitude, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Family (type: esriFieldTypeString, alias: Family, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DispositionFee (type: esriFieldTypeDouble, alias: DispositionFee, SQL Type: sqlTypeOther, nullable: false, editable: true)
• LeaseEndDate (type: esriFieldTypeDate, alias: LeaseEndDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LeasePayment (type: esriFieldTypeDouble, alias: LeasePayment, SQL Type: sqlTypeOther, nullable: false, editable: true)
• LeaseStartDate (type: esriFieldTypeDate, alias: LeaseStartDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Lessor (type: esriFieldTypeString, alias: Lessor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PONumber (type: esriFieldTypeString, alias: PONumber, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SalvageValue (type: esriFieldTypeDouble, alias: SalvageValue, SQL Type: sqlTypeOther, nullable: false, editable: true)
• Spare (type: esriFieldTypeInteger, alias: Spare, SQL Type: sqlTypeOther, nullable: false, editable: true)
• Tires (type: esriFieldTypeInteger, alias: Tires, SQL Type: sqlTypeOther, nullable: false, editable: true)
• TrackOnly (type: esriFieldTypeInteger, alias: TrackOnly, SQL Type: sqlTypeOther, nullable: false, editable: true)
• UsefulLife (type: esriFieldTypeInteger, alias: UsefulLife, SQL Type: sqlTypeOther, nullable: false, editable: true)
• Updated (type: esriFieldTypeInteger, alias: Updated, SQL Type: sqlTypeOther, nullable: false, editable: true)
• PhotoName (type: esriFieldTypeString, alias: PhotoName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Vacant (type: esriFieldTypeInteger, alias: Vacant, SQL Type: sqlTypeOther, nullable: false, editable: true)
• Wing (type: esriFieldTypeString, alias: Wing, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Zone (type: esriFieldTypeString, alias: Zone, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Room (type: esriFieldTypeString, alias: Room, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GroupID (type: esriFieldTypeInteger, alias: GroupID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GroupSubID (type: esriFieldTypeInteger, alias: GroupSubID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DepartmentID (type: esriFieldTypeInteger, alias: DepartmentID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ClassAssetID (type: esriFieldTypeInteger, alias: ClassAssetID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RiskAssessmentRequired (type: esriFieldTypeInteger, alias: RiskAssessmentRequired, SQL Type: sqlTypeOther, nullable: false, editable: true)
• RiskLevel (type: esriFieldTypeSingle, alias: RiskLevel, SQL Type: sqlTypeOther, nullable: false, editable: true)
• RatingGroup (type: esriFieldTypeString, alias: RatingGroup, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AssessedBy (type: esriFieldTypeString, alias: AssessedBy, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AssessmentDate (type: esriFieldTypeDate, alias: AssessmentDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• EquipmentFunction (type: esriFieldTypeSingle, alias: EquipmentFunction, SQL Type: sqlTypeOther, nullable: false, editable: true)
• ClinicalApplication (type: esriFieldTypeSingle, alias: ClinicalApplication, SQL Type: sqlTypeOther, nullable: false, editable: true)
• MaintenanceRequirement (type: esriFieldTypeSingle, alias: MaintenanceRequirement, SQL Type: sqlTypeOther, nullable: false, editable: true)
• IncidentHistory (type: esriFieldTypeSingle, alias: IncidentHistory, SQL Type: sqlTypeOther, nullable: false, editable: true)
• EnvironmentalUseArea (type: esriFieldTypeSingle, alias: EnvironmentalUseArea, SQL Type: sqlTypeOther, nullable: false, editable: true)
• AssessmentScore (type: esriFieldTypeSingle, alias: AssessmentScore, SQL Type: sqlTypeOther, nullable: false, editable: true)
• PFIRelated (type: esriFieldTypeInteger, alias: PFIRelated, SQL Type: sqlTypeOther, nullable: false, editable: true)
• HIPAARegulated (type: esriFieldTypeInteger, alias: HIPAARegulated, SQL Type: sqlTypeOther, nullable: false, editable: true)
• TaskRequired (type: esriFieldTypeInteger, alias: TaskRequired, SQL Type: sqlTypeOther, nullable: false, editable: true)
• SOCRelated (type: esriFieldTypeInteger, alias: SOCRelated, SQL Type: sqlTypeOther, nullable: false, editable: true)
• SOCCompliant (type: esriFieldTypeInteger, alias: SOCCompliant, SQL Type: sqlTypeOther, nullable: false, editable: true)
• Shop (type: esriFieldTypeString, alias: Shop, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SOCDueDate (type: esriFieldTypeDate, alias: SOCDueDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SOCExtended (type: esriFieldTypeInteger, alias: SOCExtended, SQL Type: sqlTypeOther, nullable: false, editable: true)
• SOCExtendedDate (type: esriFieldTypeDate, alias: SOCExtendedDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PFIDueDate (type: esriFieldTypeDate, alias: PFIDueDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PFICompleted (type: esriFieldTypeInteger, alias: PFICompleted, SQL Type: sqlTypeOther, nullable: false, editable: true)
• xmWEB (type: esriFieldTypeInteger, alias: xmWEB, SQL Type: sqlTypeOther, nullable: false, editable: true)
• SpaceClassTypeID (type: esriFieldTypeInteger, alias: SpaceClassTypeID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AreaClassID (type: esriFieldTypeInteger, alias: AreaClassID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Capacity (type: esriFieldTypeInteger, alias: Capacity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TimeStamp (type: esriFieldTypeBlob, alias: TimeStamp, SQL Type: sqlTypeOther, nullable: true, editable: true)
• X (type: esriFieldTypeDouble, alias: X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Y (type: esriFieldTypeDouble, alias: Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Asset_ID (type: esriFieldTypeInteger, alias: Asset_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: MMtblAsset_XYTableToPoint
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Asset:
• PropertyID: 0
• Active: 0
• Type:
• Account:
• CostInstall: 0
• CostReplacement: 0
• SquareFeet: 0
• ReserveForReplacement: 0
• CommentToWO: 0
• DispositionFee: 0
• LeasePayment: 0
• SalvageValue: 0
• Spare: 0
• Tires: 0
• TrackOnly: 0
• UsefulLife: 0
• Updated: 0
• Vacant: 0
• RiskAssessmentRequired: 0
• RiskLevel: 0
• EquipmentFunction: 0
• ClinicalApplication: 0
• MaintenanceRequirement: 0
• IncidentHistory: 0
• EnvironmentalUseArea: 0
• AssessmentScore: 0
• PFIRelated: 0
• HIPAARegulated: 0
• TaskRequired: 0
• SOCRelated: 0
• SOCCompliant: 0
• SOCExtended: 0
• PFICompleted: 0
• xmWEB: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/12/2026 2:50:45 PM

Schema Last Edit Date: 8/12/2026 2:50:45 PM

Data Last Edit Date: 8/12/2026 2:50:45 PM

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