Name: Inspect Ticket

Display Field: NameCaller

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 5000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Join_PARCELID ( type: esriFieldTypeString, alias: Join_PARCELID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Join_PARCELID )
• NameCaller ( type: esriFieldTypeString, alias: Callers Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NameCaller )
• PhoneCaller ( type: esriFieldTypeString, alias: Callers Contact Number, editable: true, nullable: true, length: 12, defaultValue: null, modelName: PhoneCaller )
• NameTenant ( type: esriFieldTypeString, alias: Tenants Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NameTenant )
• PhoneTenant ( type: esriFieldTypeString, alias: Tenants Number, editable: true, nullable: true, length: 12, defaultValue: null, modelName: PhoneTenant )
• NameOwner ( type: esriFieldTypeString, alias: Owners Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NameOwner )
• PhoneOwner ( type: esriFieldTypeString, alias: Owners Number, editable: true, nullable: true, length: 12, defaultValue: null, modelName: PhoneOwner )
• AddressOwner ( type: esriFieldTypeString, alias: Address of Owner, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AddressOwner )
• InspectionOutcome ( type: esriFieldTypeString, alias: InspectionOutcome, editable: true, nullable: true, length: 50, defaultValue: null, modelName: InspectionOutcome , Coded Values: [Occupant Not Home: Occupant Not Home] , [Inspection Could Not Be Performed: Inspection Could Not Be Performed] , [Inspection Passed: Inspection Passed] , ...12 more... )
• DispatchComments ( type: esriFieldTypeString, alias: DispatchComments, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: DispatchComments )
• InspectorComments ( type: esriFieldTypeString, alias: InspectorComments, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: InspectorComments )
• InspectorName ( type: esriFieldTypeString, alias: InspectorName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: InspectorName , Coded Values: [7: 7] , [8: 8] , [9: 9] , ...4 more... )
• SchedBy ( type: esriFieldTypeString, alias: SchedBy, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SchedBy , Coded Values: [Program Coordinator: Program Coordinator] , [Dispatch: Dispatch] , [Dispatch Relief: Dispatch Relief] )
• SchedStatus ( type: esriFieldTypeString, alias: SchedStatus, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SchedStatus , Coded Values: [Scheduled: Scheduled] , [Re-Scheduled: Re-Scheduled] , [On Hold: On Hold] , ...2 more... )
• InspectDate ( type: esriFieldTypeDate, alias: InspectDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectDate )
• InspectTime ( type: esriFieldTypeString, alias: InspectTime, editable: true, nullable: true, length: 10, defaultValue: null, modelName: InspectTime )
• HouseNum ( type: esriFieldTypeString, alias: House Number, editable: true, nullable: true, length: 12, defaultValue: null, modelName: HouseNum )
• EmailCaller ( type: esriFieldTypeString, alias: Callers Email, editable: true, nullable: true, length: 125, defaultValue: null, modelName: EmailCaller )
• NamePropManager ( type: esriFieldTypeString, alias: Property Managers Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NamePropManager )
• NameOnPremContact ( type: esriFieldTypeString, alias: Name of On Premise Contact, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NameOnPremContact )
• InspectionReason ( type: esriFieldTypeString, alias: Inspection Reason, editable: true, nullable: true, length: 25, defaultValue: null, modelName: InspectionReason , Coded Values: [Complaint: Complaint] , [Letter Sent: Letter Sent] , [Random Sampling: Random Sampling] , ...3 more... )
• AccelaNum ( type: esriFieldTypeString, alias: Accela Number, editable: true, nullable: true, length: 25, defaultValue: null, modelName: AccelaNum )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• AptUnit ( type: esriFieldTypeString, alias: Apt or Unit, editable: true, nullable: true, length: 25, defaultValue: null, modelName: AptUnit )
• Case_Number ( type: esriFieldTypeString, alias: Case Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Case_Number )
• script_last_run ( type: esriFieldTypeDate, alias: Script Last Run, editable: true, nullable: true, length: 8, defaultValue: null, modelName: script_last_run )
• isDuplicated ( type: esriFieldTypeString, alias: Does the apartment complex need a random sampling of batch tickets made?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: isDuplicated , Coded Values: [Yes: Yes] , [No: No] )
• last_edited ( type: esriFieldTypeDate, alias: Last Edited, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited )
• date_created ( type: esriFieldTypeDate, alias: Date Created, editable: false, nullable: true, length: 8, defaultValue: null, modelName: date_created )
• HistoricalData ( type: esriFieldTypeString, alias: Is this historical data?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HistoricalData , Coded Values: [Yes: Yes] , [No: No] )

Templates:

• Name: Inspect Ticket
  Description:
  Prototype:
  script_last_run: null
  isDuplicated: null
  Join_PARCELID: null
  NameCaller: null
  PhoneCaller: null
  NameTenant: null
  PhoneTenant: null
  NameOwner: null
  PhoneOwner: null
  AddressOwner: null
  InspectionOutcome: null
  DispatchComments: null
  InspectorComments: null
  InspectorName: null
  SchedBy: null
  SchedStatus: null
  InspectDate: null
  InspectTime: null
  HouseNum: null
  EmailCaller: null
  NamePropManager: null
  NameOnPremContact: null
  InspectionReason: null
  AccelaNum: null
  HistoricalData: null
  AptUnit: null
  Case_Number: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Exterior (2) -- Related To: Exterior Area Inspection (2)
• Interior (3) -- Related To: Interior Area Inspection (3)
• Common Areas (1) -- Related To: Common Area Inspection (1)
• \\cosb-fs1\gissys\Admin\GISConfigStore\10_6\DatabaseConnections\CentralServices_Code@cosb-sql_gis.sde\CODE.rsvp_parcels (0) -- Related To: Parcels (0)

Capabilities: Query,Create,Update,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: date_created
• Creator Field:
• Edit Date Field: last_edited
• Editor Field:

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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