Name: OneYearWarrantiesRT

Display Field: ProjectName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 8e8eff8d62f54fe0a360187e229d7033

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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• RelatedGlobalID ( type: esriFieldTypeGUID, alias: RelatedGlobalID, length: 38 )
• DateOfOneYearInspection ( type: esriFieldTypeDate, alias: Date Of One Year Warranty Review, length: 8 )
• NotesConcerns ( type: esriFieldTypeString, alias: Notes & Concerns, length: 1000 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• ProjectName ( type: esriFieldTypeString, alias: Project Name, length: 254 )
• 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 )
• Deficiency1 ( type: esriFieldTypeString, alias: Deficiency 1, length: 500 )
• Deficiency2 ( type: esriFieldTypeString, alias: Deficiency 2, length: 500 )
• Deficiency3 ( type: esriFieldTypeString, alias: Deficiency 3, length: 500 )
• Deficiency4 ( type: esriFieldTypeString, alias: Deficiency 4, length: 500 )
• Deficiency5 ( type: esriFieldTypeString, alias: Deficiency 5, length: 500 )
• Deficiency6 ( type: esriFieldTypeString, alias: Deficiency 6, length: 500 )
• Deficiency7 ( type: esriFieldTypeString, alias: Deficiency 7, length: 500 )
• Deficiency8 ( type: esriFieldTypeString, alias: Deficiency 8, length: 500 )
• Deficiency9 ( type: esriFieldTypeString, alias: Deficiency 9, length: 500 )
• Deficiency10 ( type: esriFieldTypeString, alias: Deficiency 10, length: 500 )
• Deficiency11 ( type: esriFieldTypeString, alias: Deficiency 11, length: 500 )
• Deficiency12 ( type: esriFieldTypeString, alias: Deficiency 12, length: 500 )
• Deficiency13 ( type: esriFieldTypeString, alias: Deficiency 13, length: 500 )
• Deficiency14 ( type: esriFieldTypeString, alias: Deficiency 14, length: 500 )
• Deficiency15 ( type: esriFieldTypeString, alias: Deficiency 15, length: 500 )
• Deficiency16 ( type: esriFieldTypeString, alias: Deficiency 16, length: 500 )
• Deficiency17 ( type: esriFieldTypeString, alias: Deficiency 17, length: 500 )
• Deficiency18 ( type: esriFieldTypeString, alias: Deficiency 18, length: 500 )
• Deficiency19 ( type: esriFieldTypeString, alias: Deficiency 19, length: 500 )
• Deficiency20 ( type: esriFieldTypeString, alias: Deficiency 20, length: 500 )
• Deficiency21 ( type: esriFieldTypeString, alias: Deficiency 21, length: 500 )
• Deficiency22 ( type: esriFieldTypeString, alias: Deficiency 22, length: 500 )
• Deficiency23 ( type: esriFieldTypeString, alias: Deficiency 23, length: 500 )
• Deficiency24 ( type: esriFieldTypeString, alias: Deficiency 24, length: 500 )
• Deficiency25 ( type: esriFieldTypeString, alias: Deficiency 25, length: 500 )
• Inspector ( type: esriFieldTypeString, alias: Inspector , length: 255 )
• Contractor ( type: esriFieldTypeString, alias: Contractor , length: 255 )
• ContractorPhone ( type: esriFieldTypeString, alias: Contractor Phone , length: 255 )
• ContractorEmail ( type: esriFieldTypeString, alias: Contractor Email, length: 255 )
• ImperviousArea ( type: esriFieldTypeDouble, alias: Impervious Area )
• ContractorEmail2 ( type: esriFieldTypeString, alias: Contractor Email 2, length: 255 )
• ContractorEmail3 ( type: esriFieldTypeString, alias: Contractor Email 3, length: 255 )
• ContractorEmail4 ( type: esriFieldTypeString, alias: Contractor Email 4, length: 255 )
• ContractorEmail5 ( type: esriFieldTypeString, alias: Contractor Email 5, length: 255 )
• FinalInspectionDateApproved ( type: esriFieldTypeDate, alias: Date Project Entered into One Year Warranty, length: 8 )
• LogType ( type: esriFieldTypeString, alias: LogType, length: 255 , Coded Values: [Development Poly: Development Poly] , [Development Line: Development Line] , [City Poly: City Poly] , ...3 more... )
• WarrantyApprovedDate ( type: esriFieldTypeDate, alias: One Year Warranty Date of Approval, length: 8 )
• WarrantyApproval ( type: esriFieldTypeString, alias: One Year Warranty Approved?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff1 ( type: esriFieldTypeString, alias: Sign Off 1?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff2 ( type: esriFieldTypeString, alias: Sign Off 2?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff3 ( type: esriFieldTypeString, alias: Sign Off 3?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff4 ( type: esriFieldTypeString, alias: Sign Off 4?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff5 ( type: esriFieldTypeString, alias: Sign Off 5?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff6 ( type: esriFieldTypeString, alias: Sign Off 6?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff7 ( type: esriFieldTypeString, alias: Sign Off 7?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff8 ( type: esriFieldTypeString, alias: Sign Off 8?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff9 ( type: esriFieldTypeString, alias: Sign Off 9?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff10 ( type: esriFieldTypeString, alias: Sign Off 10?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff11 ( type: esriFieldTypeString, alias: Sign Off 11?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff12 ( type: esriFieldTypeString, alias: Sign Off 12?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff13 ( type: esriFieldTypeString, alias: Sign Off 13?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff14 ( type: esriFieldTypeString, alias: Sign Off 14?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff15 ( type: esriFieldTypeString, alias: Sign Off 15?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff16 ( type: esriFieldTypeString, alias: Sign Off 16?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff17 ( type: esriFieldTypeString, alias: Sign Off 17?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff18 ( type: esriFieldTypeString, alias: Sign Off 18?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff19 ( type: esriFieldTypeString, alias: Sign Off 19?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff20 ( type: esriFieldTypeString, alias: Sign Off 20?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff21 ( type: esriFieldTypeString, alias: Sign Off 21?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff22 ( type: esriFieldTypeString, alias: Sign Off 22?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff23 ( type: esriFieldTypeString, alias: Sign Off 23?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff24 ( type: esriFieldTypeString, alias: Sign Off 24?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff25 ( type: esriFieldTypeString, alias: Sign Off 25?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SecretaryEmail ( type: esriFieldTypeString, alias: Secretary Email, length: 100 , Coded Values: [jfinch@spanishfork.org: jfinch@spanishfork.org] , [marciec@spanishfork.org: marciec@spanishfork.org] )

Relationships:

• DBO.DevelopmentProjectLines (4) -- Related To: Development Project Lines (0)
• DBO.CityProjectLines (11) -- Related To: City Project Lines (1)
• DBO.ExcavationPermits (0) -- Related To: Excavation Permits (10)
• DBO.CityProjectPolygons (19) -- Related To: City Project Polygons (3)
• DBO.DevelopmentProjectPolygons (15) -- Related To: Development Project Polygons (2)

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

  Iteminfo   Thumbnail   Metadata