Name: CIS_PREMISE_SURVEY_TABLE_CUSTOMER

Display Field: InspectorName

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• PREMISEID (type: esriFieldTypeInteger, alias: Premise ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• material_ (type: esriFieldTypeString, alias: RPU Side Updated Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AC: Asbestos Cement], [BRASS: Brass], [CCP: Concrete Steel Cylinder], ... 23 more ...)
• diameter_dbl (type: esriFieldTypeDouble, alias: RPU Side Updated Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.5: 0.5"], [0.75: 0.75"], [1: 1"], ... 12 more ...)
• RPUUpdatedInstallDate (type: esriFieldTypeDate, alias: RPU Side Updated Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RPUUpdatedPremiseID (type: esriFieldTypeInteger, alias: RPU Side Updated Premise ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RPUVerificationSource (type: esriFieldTypeString, alias: RPU Side Verification Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [As-Builts: As-Builts], [Blue Slip/Tap Card: Blue Slip/Tap Card], [Construction Permit: Construction Permit], ... 6 more ...)
• RPUAsBuiltImprvmtReference (type: esriFieldTypeString, alias: RPU As-Built / Imporvement Plan Reference, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• notes_ (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LeadGooseneck_ (type: esriFieldTypeString, alias: Lead Gooseneck, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• Shape_Length (type: esriFieldTypeDouble, alias: Shape_Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TestLocation (type: esriFieldTypeString, alias: Test Location, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Meter: Meter], [Building: Building], [Other: Other])
• OtherLocation (type: esriFieldTypeString, alias: Other Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TestType (type: esriFieldTypeString, alias: Test Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [3M Test Kit: 3M Test Kit], [Excavation: Excavation], [Other: Other], ... 3 more ...)
• OtherTest (type: esriFieldTypeString, alias: Other Test, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InspectedMaterialType (type: esriFieldTypeString, alias: Inspected Material Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [AC: Asbestos Cement], [BRASS: Brass], [CCP: Concrete Steel Cylinder], ... 23 more ...)
• InspectedLineSize (type: esriFieldTypeDouble, alias: Inspected Line Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.5: 0.5"], [0.75: 0.75"], [1: 1"], ... 12 more ...)
• InspectorName (type: esriFieldTypeString, alias: Inspector Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Al Orozco: Al Orozco], [Brad Kelvington: Brad Kelvington], [Danny Bertotti: Danny Bertotti], ... 7 more ...)
• InspectionDate (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Inspectionnotes (type: esriFieldTypeString, alias: Inspection Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CUSTUpdatedMaterial (type: esriFieldTypeString, alias: Customer Side Updated Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AC: Asbestos Cement], [BRASS: Brass], [CCP: Concrete Steel Cylinder], ... 23 more ...)
• CUSTUpdatedDiameter (type: esriFieldTypeDouble, alias: Customer Side Updated Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.5: 0.5"], [0.75: 0.75"], [1: 1"], ... 12 more ...)
• CUSTUpdatedBuildDate (type: esriFieldTypeDate, alias: Customer Side Updated Build Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CUSTVerificationSource (type: esriFieldTypeString, alias: Customer Side Verification Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [As-Builts: As-Built Drawings], [Blue Slip/Tap Card: Blue Slip/Tap Card], [Construction Permit: Construction Permit], ... 7 more ...)
• CUSTAsBuiltImprvmtReference (type: esriFieldTypeString, alias: Customer As-Built / Imporvement Plan Reference, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ConstructionPermitReference (type: esriFieldTypeString, alias: Construction Permit Reference, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• PREMISE_ID_CIS (type: esriFieldTypeString, alias: PREMISE_ID_CIS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• custupdatedbuildyear (type: esriFieldTypeString, alias: Customer Side Updated Build Year, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Pre 1942: Pre 1942], [1942 - 1957: 1942 - 1957], [1958 - 1985: 1958 - 1985], ... 2 more ...)

Templates:

Name: CIS_PREMISE_SURVEY_TABLE_CUSTOMER
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/8/2023 7:16:50 AM

Schema Last Edit Date: 9/8/2023 7:16:50 AM

Data Last Edit Date: 6/26/2023 3:03:12 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat