Name: PN_Asset_Maint_Record

Display Field: Asset_Name

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: e1dd598dad7947b0904fe5f8b0050b71

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:

N/A

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: TASK_TYPE_ID

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ASSETID ( type: esriFieldTypeInteger, alias: AssetID )
• ASSET_TYPE ( type: esriFieldTypeInteger, alias: Asset Type , Coded Values: [10001: Art Installation] , [10002: Baseball Back Stop] , [10003: Bench] , ...31 more... )
• Asset_Name ( type: esriFieldTypeString, alias: Asset Name, length: 50 )
• COMPOUND_NAME ( type: esriFieldTypeString, alias: Compound, length: 50 , Coded Values: [Armory: Armory] , [Center City Armory: Center City Armory] , [Frayser: Frayser] , ...6 more... )
• Park_ID ( type: esriFieldTypeInteger, alias: ParkID )
• PARK_NAMEFULL ( type: esriFieldTypeString, alias: Full Park Name, length: 50 , Coded Values: [Alcy-Samuels Park: Alcy-Samuels Park] , [Alcy-Warren Park: Alcy-Warren Park] , [Alonzo Weaver Park (W. Junction): Alonzo Weaver Park (W. Junction)] , ...226 more... )
• PARCELID ( type: esriFieldTypeString, alias: Parcel ID, length: 240 )
• TASK_ID ( type: esriFieldTypeInteger, alias: Task Unique ID )
• TASK_TYPE_ID ( type: esriFieldTypeInteger, alias: Task Type ID )
• TASK_TYPE ( type: esriFieldTypeString, alias: Maintenance Task, length: 75 )
• TASK_STATUS ( type: esriFieldTypeString, alias: Task Status, length: 50 , Coded Values: [Open: Open] , [Unassigned: Unassigned] , [Assigned: Assigned] , ...6 more... )
• TASK_PRIORITY ( type: esriFieldTypeString, alias: Task Priority, length: 25 , Coded Values: [High: High] , [Medium: Medium] , [Low: Low] )
• CREATION_DATE ( type: esriFieldTypeDate, alias: Creation Date, length: 8 )
• TASK_SUBJECT ( type: esriFieldTypeString, alias: Maintenance Subject, length: 250 )
• TASK_ASSIGNEE ( type: esriFieldTypeString, alias: Task Assignee, length: 255 , Coded Values: [Anthony Howard: Anthony Howard] , [Connie Shepherd: Connie Shepherd] , [Gettone Smith: Gettone Smith] , ...10 more... )
• TASK_NOTES ( type: esriFieldTypeString, alias: Maintenance Notes, length: 250 )
• Park_Assets_Rating ( type: esriFieldTypeInteger, alias: Park Assets Rating , Coded Values: [1: 1 - Cannot be repaired, must be replaced] , [2: 2 - Poor condition, needs renovation] , [3: 3 - Adequate, but needs a little work] , ...2 more... )
• SCHEDULED_START_DATE ( type: esriFieldTypeDate, alias: Scheduled Start Date, length: 8 )
• SCHEDULED_END_DATE ( type: esriFieldTypeDate, alias: Scheduled End Date, length: 8 )
• ACTUAL_START_DATE ( type: esriFieldTypeDate, alias: Actual Start Date, length: 8 )
• ACTUAL_END_DATE ( type: esriFieldTypeDate, alias: Actual End Date, length: 8 )
• ACTUAL_EFFORT ( type: esriFieldTypeDouble, alias: Actual Effort )
• FOLLOWUP_DATE ( type: esriFieldTypeDate, alias: Follow Up Date, length: 8 )
• ASSET_GUID ( type: esriFieldTypeGUID, alias: ASSET_GUID, length: 38 )
• CREATED_BY ( type: esriFieldTypeString, alias: Created By, length: 255 , Coded Values: [Anthony Howard: Anthony Howard] , [Connie Shepherd: Connie Shepherd] , [Gettone Smith: Gettone Smith] , ...10 more... )
• LAST_UPDATED_BY ( type: esriFieldTypeString, alias: Task Updated By, length: 255 , Coded Values: [Anthony Howard: Anthony Howard] , [Connie Shepherd: Connie Shepherd] , [Gettone Smith: Gettone Smith] , ...10 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )

Types:

ID: 20001
Name: Maintenance Task
Domains:
• ASSET_TYPE:
  Inherited
• COMPOUND_NAME:
  Inherited
• PARK_NAMEFULL:
  Inherited
• TASK_TYPE:
  Coded Values: [Empty Trash Receptacle: Empty Trash Receptacle] , [Inventory Report: Inventory Report] , [Leaf Mulching: Leaf Mulching] , ...7 more...
• TASK_STATUS:
  Inherited
• TASK_PRIORITY:
  Inherited
• TASK_ASSIGNEE:
  Inherited
• Park_Assets_Rating:
  Inherited
• CREATED_BY:
  Inherited
• LAST_UPDATED_BY:
  Inherited

---

ID: 20002
Name: Maintenance Task M & O
Domains:
• ASSET_TYPE:
  Inherited
• COMPOUND_NAME:
  Inherited
• PARK_NAMEFULL:
  Inherited
• TASK_TYPE:
  Coded Values: [Asset Inspection: Asset Inspection] , [Asset Repair: Asset Repair] , [Playground Inspection: Playground Inspection]
• TASK_STATUS:
  Inherited
• TASK_PRIORITY:
  Inherited
• TASK_ASSIGNEE:
  Inherited
• Park_Assets_Rating:
  Inherited
• CREATED_BY:
  Inherited
• LAST_UPDATED_BY:
  Inherited

---

Relationships:

• Records to Asset (5) -- Related To: PN_Asset_Locations (4)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata