Name: OneYearWarrantiesRT

Display Field: ProjectName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 8cb0d6bce3594157aca6a1aa683a54e5

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

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

Templates:

• Name: OneYearWarrantiesRT
  Description:
  Prototype:
  SignOff25: null
  RelatedGlobalID: null
  DateOfOneYearInspection: null
  NotesConcerns: null
  SecretaryEmail: null
  ProjectName: null
  SignOff24: null
  SignOff23: null
  SignOff22: null
  SignOff21: null
  Deficiency1: null
  Deficiency2: null
  Deficiency3: null
  Deficiency4: null
  Deficiency5: null
  Deficiency6: null
  Deficiency7: null
  Deficiency8: null
  Deficiency9: null
  Deficiency10: null
  Deficiency11: null
  Deficiency12: null
  Deficiency13: null
  Deficiency14: null
  Deficiency15: null
  Deficiency16: null
  Deficiency17: null
  Deficiency18: null
  Deficiency19: null
  Deficiency20: null
  Deficiency21: null
  Deficiency22: null
  Deficiency23: null
  Deficiency24: null
  Deficiency25: null
  Inspector: null
  Contractor: null
  ContractorPhone: null
  ContractorEmail: null
  ImperviousArea: null
  ContractorEmail2: null
  ContractorEmail3: null
  ContractorEmail4: null
  ContractorEmail5: null
  FinalInspectionDateApproved: null
  LogType: null
  WarrantyApprovedDate: null
  WarrantyApproval: null
  SignOff1: null
  SignOff2: null
  SignOff3: null
  SignOff4: null
  SignOff5: null
  SignOff6: null
  SignOff7: null
  SignOff8: null
  SignOff9: null
  SignOff10: null
  SignOff11: null
  SignOff12: null
  SignOff13: null
  SignOff14: null
  SignOff15: null
  SignOff16: null
  SignOff17: null
  SignOff18: null
  SignOff19: null
  SignOff20: null
  
  Drawing Tool: esriFeatureEditToolNone

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)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports OidReservation: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata