Name: CWHONOLULU.azteca.INSPECTION

Display Field: INSPTEMPLATENAME

Type: Table

Geometry Type: N/A

Description: null

Definition Expression: N/A

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• INSPECTIONID ( type: esriFieldTypeDouble , alias: INSPECTIONID )
• WORKORDERID ( type: esriFieldTypeString , alias: WORKORDERID , length: 60 )
• INSPTEMPLATEID ( type: esriFieldTypeDouble , alias: INSPTEMPLATEID )
• INSPTEMPLATENAME ( type: esriFieldTypeString , alias: INSPTEMPLATENAME , length: 30 )
• ENTITYUID ( type: esriFieldTypeString , alias: ENTITYUID , length: 50 )
• ENTITYTYPE ( type: esriFieldTypeString , alias: ENTITYTYPE , length: 50 )
• INSPDATE ( type: esriFieldTypeDate , alias: INSPDATE , length: 8 )
• INSPECTEDBY ( type: esriFieldTypeString , alias: INSPECTEDBY , length: 100 )
• LOCATION ( type: esriFieldTypeString , alias: LOCATION , length: 256 )
• OBSERVATIONSUM ( type: esriFieldTypeString , alias: OBSERVATIONSUM , length: 900 )
• REPAIRSMADE ( type: esriFieldTypeString , alias: REPAIRSMADE , length: 900 )
• FOREMANRECOMND ( type: esriFieldTypeString , alias: FOREMANRECOMND , length: 900 )
• REQUESTID ( type: esriFieldTypeInteger , alias: REQUESTID )
• PRJSTARTDATE ( type: esriFieldTypeDate , alias: PRJSTARTDATE , length: 8 )
• PRJFINISHDATE ( type: esriFieldTypeDate , alias: PRJFINISHDATE , length: 8 )
• ACTFINISHDATE ( type: esriFieldTypeDate , alias: ACTFINISHDATE , length: 8 )
• DATECLOSED ( type: esriFieldTypeDate , alias: DATECLOSED , length: 8 )
• CLOSEDBY ( type: esriFieldTypeString , alias: CLOSEDBY , length: 100 )
• CLOSESR ( type: esriFieldTypeSmallInteger , alias: CLOSESR )
• CANCEL ( type: esriFieldTypeSmallInteger , alias: CANCEL )
• DATECANCELLED ( type: esriFieldTypeDate , alias: DATECANCELLED , length: 8 )
• CANCELLEDBY ( type: esriFieldTypeString , alias: CANCELLEDBY , length: 100 )
• CANCELREASON ( type: esriFieldTypeString , alias: CANCELREASON , length: 100 )
• STATUS ( type: esriFieldTypeString , alias: STATUS , length: 50 )
• INSPX ( type: esriFieldTypeDouble , alias: INSPX )
• INSPY ( type: esriFieldTypeDouble , alias: INSPY )
• INITIATEDBY ( type: esriFieldTypeString , alias: INITIATEDBY , length: 100 )
• INITIATEDATE ( type: esriFieldTypeDate , alias: INITIATEDATE , length: 8 )
• ENTITYSID ( type: esriFieldTypeInteger , alias: ENTITYSID )
• FEATUREUID ( type: esriFieldTypeString , alias: FEATUREUID , length: 50 )
• FEATUREID ( type: esriFieldTypeInteger , alias: FEATUREID )
• FEATURETYPE ( type: esriFieldTypeString , alias: FEATURETYPE , length: 50 )
• DOMAINID ( type: esriFieldTypeInteger , alias: DOMAINID )
• SHOP ( type: esriFieldTypeString , alias: SHOP , length: 100 )
• MAPPAGE ( type: esriFieldTypeString , alias: MAPPAGE , length: 100 )
• TILENO ( type: esriFieldTypeString , alias: TILENO , length: 50 )
• DISTRICT ( type: esriFieldTypeString , alias: DISTRICT , length: 50 )
• RESOLUTION ( type: esriFieldTypeString , alias: RESOLUTION , length: 100 )
• PRIORITY ( type: esriFieldTypeString , alias: PRIORITY , length: 50 )
• STREETNAME ( type: esriFieldTypeString , alias: STREETNAME , length: 50 )
• CONDRATING ( type: esriFieldTypeDouble , alias: CONDRATING )
• TEXT1 ( type: esriFieldTypeString , alias: TEXT1 , length: 100 )
• TEXT2 ( type: esriFieldTypeString , alias: TEXT2 , length: 100 )
• TEXT3 ( type: esriFieldTypeString , alias: TEXT3 , length: 100 )
• TEXT4 ( type: esriFieldTypeString , alias: TEXT4 , length: 100 )
• TEXT5 ( type: esriFieldTypeString , alias: TEXT5 , length: 100 )
• TEXT6 ( type: esriFieldTypeString , alias: TEXT6 , length: 100 )
• TEXT7 ( type: esriFieldTypeString , alias: TEXT7 , length: 100 )
• TEXT8 ( type: esriFieldTypeString , alias: TEXT8 , length: 100 )
• TEXT9 ( type: esriFieldTypeString , alias: TEXT9 , length: 100 )
• TEXT10 ( type: esriFieldTypeString , alias: TEXT10 , length: 100 )
• NUM1 ( type: esriFieldTypeDouble , alias: NUM1 )
• NUM2 ( type: esriFieldTypeDouble , alias: NUM2 )
• NUM3 ( type: esriFieldTypeDouble , alias: NUM3 )
• NUM4 ( type: esriFieldTypeDouble , alias: NUM4 )
• NUM5 ( type: esriFieldTypeDouble , alias: NUM5 )
• DATE1 ( type: esriFieldTypeDate , alias: DATE1 , length: 8 )
• DATE2 ( type: esriFieldTypeDate , alias: DATE2 , length: 8 )
• DATE3 ( type: esriFieldTypeDate , alias: DATE3 , length: 8 )
• DATE4 ( type: esriFieldTypeDate , alias: DATE4 , length: 8 )
• DATE5 ( type: esriFieldTypeDate , alias: DATE5 , length: 8 )
• CONDSCORE ( type: esriFieldTypeDouble , alias: CONDSCORE )
• UPDATEMAP ( type: esriFieldTypeString , alias: UPDATEMAP , length: 1 )
• SUBMITTOEMPLOYEESID ( type: esriFieldTypeDouble , alias: SUBMITTOEMPLOYEESID )
• SUBMITTONAME ( type: esriFieldTypeString , alias: SUBMITTONAME , length: 100 )
• DATESUBMITTO ( type: esriFieldTypeDate , alias: DATESUBMITTO , length: 8 )
• EFFORT ( type: esriFieldTypeDouble , alias: EFFORT )
• PARENTINSPID ( type: esriFieldTypeInteger , alias: PARENTINSPID )
• CYCLETYPE ( type: esriFieldTypeString , alias: CYCLETYPE , length: 20 )
• CYCLEFROM ( type: esriFieldTypeString , alias: CYCLEFROM , length: 30 )
• CYCLEINTERVALNUM ( type: esriFieldTypeInteger , alias: CYCLEINTERVALNUM )
• CYCLEINTERVALUNIT ( type: esriFieldTypeString , alias: CYCLEINTERVALUNIT , length: 1 )
• CREATEDBYCYCLE ( type: esriFieldTypeSmallInteger , alias: CREATEDBYCYCLE )
• FROMDATE ( type: esriFieldTypeDate , alias: FROMDATE , length: 8 )
• INITIATEDBYAPP ( type: esriFieldTypeString , alias: INITIATEDBYAPP , length: 50 )
• INSPECTEDBYSID ( type: esriFieldTypeInteger , alias: INSPECTEDBYSID )
• CANCELLEDBYSID ( type: esriFieldTypeInteger , alias: CANCELLEDBYSID )
• INITIATEDBYSID ( type: esriFieldTypeInteger , alias: INITIATEDBYSID )
• CLOSEDBYSID ( type: esriFieldTypeInteger , alias: CLOSEDBYSID )
• FACILITY_ID ( type: esriFieldTypeString , alias: FACILITY_ID , length: 256 )
• LEVEL_ID ( type: esriFieldTypeString , alias: LEVEL_ID , length: 256 )
• PROJECTSID ( type: esriFieldTypeDouble , alias: PROJECTSID )
• PROJECTPHASEID ( type: esriFieldTypeInteger , alias: PROJECTPHASEID )
• METADATA ( type: esriFieldTypeString , alias: METADATA , length: 2147483647 )
• INSPZ ( type: esriFieldTypeDouble , alias: INSPZ )

Supported Operations:   Query   Generate Renderer   Return Updates