Name: Inspect Ticket

Display Field: NameCaller

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 5000

Supported Query Formats: JSON

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

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

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)

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

  Iteminfo   Thumbnail   Metadata