Layers:

Layer: Assy Device (0)

Name: Assy Device

Display Field: Size

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: 1.3201209627125815E7
YMin: 685909.0947200358
XMax: 1.3245397031445503E7
YMax: 753411.9767730385
Spatial Reference: 2898  (2898)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: PassFail
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: Pass
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [76, 230, 0, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 2
  Label: Fail
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [230, 0, 0, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 3
  Label: Testing Due
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 0, 0, 255]
  Size: 8.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [255, 255, 0, 255] Width: 1
Transparency: 0
Labeling Info:
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: PassFail

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Address )
• AssyType ( type: esriFieldTypeSmallInteger, alias: Type, editable: true, nullable: true, defaultValue: null, modelName: AssyType , Coded Values: [1: RPZ] , [2: RPDA] , [3: PVB] , ...3 more... )
• SerialNo ( type: esriFieldTypeString, alias: Serial No, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SerialNo )
• Size ( type: esriFieldTypeString, alias: Size, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Size , Coded Values: [0.5: 0.5 in] , [0.75: 0.75 in] , [1.00: 1.00 in] , ...11 more... )
• Make ( type: esriFieldTypeString, alias: Make, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Make , Coded Values: [Air Gap: Air Gap] , [Ames: Ames] , [Apollo: Apollo] , ...20 more... )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Model )
• AssyPurpose ( type: esriFieldTypeSmallInteger, alias: Purpose, editable: true, nullable: true, defaultValue: null, modelName: AssyPurpose , Coded Values: [1: Mainline] , [2: Isolation] )
• BldgLocation ( type: esriFieldTypeString, alias: BldgLocation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BldgLocation , Coded Values: [Basement: Basement] , [Boiler: Boiler] , [Boiler Room: Boiler Room] , ...8 more... )
• PassFail ( type: esriFieldTypeSmallInteger, alias: Pass / Fail, editable: true, nullable: true, defaultValue: null, modelName: PassFail , Coded Values: [1: Pass] , [2: Fail] , [3: Testing Due] )
• Tester ( type: esriFieldTypeString, alias: Tester, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Tester )
• CertificationNo ( type: esriFieldTypeString, alias: CertificationNo, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CertificationNo )
• TestDate ( type: esriFieldTypeDate, alias: Test Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TestDate )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 400, defaultValue: null, modelName: Comments )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: REL_GLOBALID )
• 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 )
Types:
ID: 1
Name: Pass
Domains:
• AssyType:
  Inherited
• Size:
  Inherited
• Make:
  Inherited
• AssyPurpose:
  Inherited
• BldgLocation:
  Inherited
• PassFail:
  Inherited
Templates:
• Name: Pass
  Description:
  Prototype:
  BldgLocation: null
  REL_GLOBALID: null
  Address: null
  AssyType: null
  SerialNo: null
  Size: null
  Make: null
  Model: null
  AssyPurpose: null
  PassFail: 1
  Tester: null
  CertificationNo: null
  TestDate: null
  Comments: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Fail
Domains:
• AssyType:
  Inherited
• Size:
  Inherited
• Make:
  Inherited
• AssyPurpose:
  Inherited
• BldgLocation:
  Inherited
• PassFail:
  Inherited
Templates:
• Name: Fail
  Description:
  Prototype:
  BldgLocation: null
  REL_GLOBALID: null
  Address: null
  AssyType: null
  SerialNo: null
  Size: null
  Make: null
  Model: null
  AssyPurpose: null
  PassFail: 2
  Tester: null
  CertificationNo: null
  TestDate: null
  Comments: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: Testing Due
Domains:
• AssyType:
  Inherited
• Size:
  Inherited
• Make:
  Inherited
• AssyPurpose:
  Inherited
• BldgLocation:
  Inherited
• PassFail:
  Inherited
Templates:
• Name: Testing Due
  Description:
  Prototype:
  BldgLocation: null
  REL_GLOBALID: null
  Address: null
  AssyType: null
  SerialNo: null
  Size: null
  Make: null
  Model: null
  AssyPurpose: null
  PassFail: 3
  Tester: null
  CertificationNo: null
  TestDate: null
  Comments: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• DBO.CCCPAccounts (0) -- Related To: CCCP Accounts (8)

Layer: CCCP Accounts (8)

Name: CCCP Accounts

Display Field: CCCPAddress

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: 1.3193937910482645E7
YMin: 658642.6090846956
XMax: 1.3271493765725598E7
YMax: 754673.9163047969
Spatial Reference: 2898  (2898)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: Status
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: Due
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [104, 104, 104, 127]
  Outline:
  Style: esriSLSSolid
  Color: [104, 104, 104, 255]
  Width: 1
• Value: 2
  Label: Pass
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [85, 255, 0, 127]
  Outline:
  Style: esriSLSSolid
  Color: [104, 104, 104, 255]
  Width: 1
• Value: 3
  Label: Pass - Missing Requirement
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 0, 197, 127]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 1
• Value: 4
  Label: Yellow Tag
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 255, 0, 127]
  Outline:
  Style: esriSLSSolid
  Color: [104, 104, 104, 255]
  Width: 1
• Value: 5
  Label: Appointment Scheduled
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 170, 0, 127]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 1
• Value: 6
  Label: Fail
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 0, 0, 127]
  Outline:
  Style: esriSLSSolid
  Color: [104, 104, 104, 255]
  Width: 1
• Value: 7
  Label: Fail -FTC
  Description: N/A
  Symbol:
  Style: esriSFSBackwardDiagonal
  Color: [255, 0, 0, 127]
  Outline:
  Style: esriSLSSolid
  Color: [104, 104, 104, 255]
  Width: 1
• Value: 8
  Label: Fail - Off at Road
  Description: N/A
  Symbol:
  Style: esriSFSBackwardDiagonal
  Color: [255, 0, 0, 127]
  Outline:
  Style: esriSLSSolid
  Color: [104, 104, 104, 255]
  Width: 1
• Value: 9
  Label: Pass- Off at Road
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [85, 255, 0, 153]
  Outline:
  Style: esriSLSSolid
  Color: [104, 104, 104, 255]
  Width: 1
• Value: 99
  Label: Not Due
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [207, 189, 252, 0]
  Outline:
  Style: esriSLSSolid
  Color: [104, 104, 104, 255]
  Width: 1
Transparency: 0
Labeling Info:
Label Placement: esriServerPolygonPlacementAlwaysHorizontal
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Tahoma
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 1500.0
Max. Scale: 0.0

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: true
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: true

HasM: true

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Status

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Status ( type: esriFieldTypeSmallInteger, alias: Status, editable: true, nullable: true, defaultValue: null, modelName: Status , Coded Values: [1: Due] , [2: Pass] , [3: Pass - Missing Requirement] , ...7 more... )
• StatusDate ( type: esriFieldTypeDate, alias: Status Updated On, editable: true, nullable: true, length: 8, defaultValue: null, modelName: StatusDate )
• Comments ( type: esriFieldTypeString, alias: Comments/Notes, editable: true, nullable: true, length: 300, defaultValue: null, modelName: Comments )
• OwnerBiz ( type: esriFieldTypeString, alias: Owner/Biz, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OwnerBiz )
• CCCPAddress ( type: esriFieldTypeString, alias: CCCP Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CCCPAddress )
• IR ( type: esriFieldTypeSmallInteger, alias: Irrigation Line, editable: true, nullable: true, defaultValue: null, modelName: IR , Coded Values: [0: No] , [1: Yes] )
• Freq ( type: esriFieldTypeSmallInteger, alias: Freq (yrs), editable: true, nullable: true, defaultValue: null, modelName: Freq , Coded Values: [1: 1] , [3: 3] , [10: 10] )
• HazardType ( type: esriFieldTypeSmallInteger, alias: Hazard Type, editable: true, nullable: true, defaultValue: null, modelName: HazardType , Coded Values: [1: Low] , [2: High] )
• Class ( type: esriFieldTypeSmallInteger, alias: Class, editable: true, nullable: true, defaultValue: null, modelName: Class , Coded Values: [1: Residential] , [2: Commercial] , [3: Non-CCCP Lot] , ...1 more... )
• RouteBook ( type: esriFieldTypeString, alias: Route Book, editable: false, nullable: true, length: 255, defaultValue: null, modelName: RouteBook , Coded Values: [0101: 0101] , [0102: 0102] , [0103: 0103] , ...25 more... )
• LetterDate ( type: esriFieldTypeDate, alias: LetterDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LetterDate )
• MailingComments ( type: esriFieldTypeString, alias: Mailing Comments, editable: true, nullable: true, length: 300, defaultValue: null, modelName: MailingComments )
• MailingRecipient ( type: esriFieldTypeString, alias: Letter Recipient, editable: true, nullable: true, length: 300, defaultValue: null, modelName: MailingRecipient )
• MailingAddress ( type: esriFieldTypeString, alias: Letter Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MailingAddress )
• MailingCityStateZip ( type: esriFieldTypeString, alias: Letter State Zip, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MailingCityStateZip )
• AccessAddress ( type: esriFieldTypeString, alias: Access Address, editable: false, nullable: true, length: 255, defaultValue: null, modelName: AccessAddress )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )
• PCOMBINED ( type: esriFieldTypeString, alias: PCOMBINED, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PCOMBINED )
• PSNUMBER ( type: esriFieldTypeDouble, alias: PSNUMBER, editable: true, nullable: true, defaultValue: null, modelName: PSNUMBER )
• PDRESSDIR ( type: esriFieldTypeString, alias: PDRESSDIR, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PDRESSDIR )
• PSSSTREET ( type: esriFieldTypeString, alias: PSSSTREET, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PSSSTREET )
• PDRESSZIP ( type: esriFieldTypeString, alias: PDRESSZIP, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PDRESSZIP )
• Tax_ID ( type: esriFieldTypeString, alias: Tax_ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Tax_ID )
• PRTYCLASS ( type: esriFieldTypeString, alias: PRTYCLASS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PRTYCLASS )
• SIMPROVED ( type: esriFieldTypeDouble, alias: SIMPROVED, editable: true, nullable: true, defaultValue: null, modelName: SIMPROVED )
• TCLEUNITS ( type: esriFieldTypeDouble, alias: TCLEUNITS, editable: true, nullable: true, defaultValue: null, modelName: TCLEUNITS )
• PTYSTATUS ( type: esriFieldTypeString, alias: PTYSTATUS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PTYSTATUS )
• ParcelUpdated ( type: esriFieldTypeDate, alias: ParcelUpdated, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ParcelUpdated )
Types:
ID: 1
Name: Due
Domains:
• Status:
  Inherited
• IR:
  Inherited
• Freq:
  Inherited
• HazardType:
  Inherited
• Class:
  Inherited
• RouteBook:
  Inherited
Templates:
• Name: Due
  Description:
  Prototype:
  PTYSTATUS: null
  Status: 1
  StatusDate: null
  Comments: null
  OwnerBiz: null
  CCCPAddress: null
  IR: null
  Freq: null
  HazardType: null
  Class: null
  TCLEUNITS: null
  LetterDate: null
  MailingComments: null
  MailingRecipient: null
  MailingAddress: null
  MailingCityStateZip: null
  SIMPROVED: null
  ParcelUpdated: null
  PRTYCLASS: null
  Tax_ID: null
  PDRESSZIP: null
  PSSSTREET: null
  PCOMBINED: null
  PSNUMBER: null
  PDRESSDIR: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 2
Name: Pass
Domains:
• Status:
  Inherited
• IR:
  Inherited
• Freq:
  Inherited
• HazardType:
  Inherited
• Class:
  Inherited
• RouteBook:
  Inherited
Templates:
• Name: Pass
  Description:
  Prototype:
  PTYSTATUS: null
  Status: 2
  StatusDate: null
  Comments: null
  OwnerBiz: null
  CCCPAddress: null
  IR: null
  Freq: null
  HazardType: null
  Class: null
  TCLEUNITS: null
  LetterDate: null
  MailingComments: null
  MailingRecipient: null
  MailingAddress: null
  MailingCityStateZip: null
  SIMPROVED: null
  ParcelUpdated: null
  PRTYCLASS: null
  Tax_ID: null
  PDRESSZIP: null
  PSSSTREET: null
  PCOMBINED: null
  PSNUMBER: null
  PDRESSDIR: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 3
Name: Pass - Missing Requirement
Domains:
• Status:
  Inherited
• IR:
  Inherited
• Freq:
  Inherited
• HazardType:
  Inherited
• Class:
  Inherited
• RouteBook:
  Inherited
Templates:
• Name: Pass - Missing Requirement
  Description:
  Prototype:
  PTYSTATUS: null
  Status: 3
  StatusDate: null
  Comments: null
  OwnerBiz: null
  CCCPAddress: null
  IR: null
  Freq: null
  HazardType: null
  Class: null
  TCLEUNITS: null
  LetterDate: null
  MailingComments: null
  MailingRecipient: null
  MailingAddress: null
  MailingCityStateZip: null
  SIMPROVED: null
  ParcelUpdated: null
  PRTYCLASS: null
  Tax_ID: null
  PDRESSZIP: null
  PSSSTREET: null
  PCOMBINED: null
  PSNUMBER: null
  PDRESSDIR: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 4
Name: Yellow Tag
Domains:
• Status:
  Inherited
• IR:
  Inherited
• Freq:
  Inherited
• HazardType:
  Inherited
• Class:
  Inherited
• RouteBook:
  Inherited
Templates:
• Name: Yellow Tag
  Description:
  Prototype:
  PTYSTATUS: null
  Status: 4
  StatusDate: null
  Comments: null
  OwnerBiz: null
  CCCPAddress: null
  IR: null
  Freq: null
  HazardType: null
  Class: null
  TCLEUNITS: null
  LetterDate: null
  MailingComments: null
  MailingRecipient: null
  MailingAddress: null
  MailingCityStateZip: null
  SIMPROVED: null
  ParcelUpdated: null
  PRTYCLASS: null
  Tax_ID: null
  PDRESSZIP: null
  PSSSTREET: null
  PCOMBINED: null
  PSNUMBER: null
  PDRESSDIR: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 5
Name: Appointment Scheduled
Domains:
• Status:
  Inherited
• IR:
  Inherited
• Freq:
  Inherited
• HazardType:
  Inherited
• Class:
  Inherited
• RouteBook:
  Inherited
Templates:
• Name: Appointment Scheduled
  Description:
  Prototype:
  PTYSTATUS: null
  Status: 5
  StatusDate: null
  Comments: null
  OwnerBiz: null
  CCCPAddress: null
  IR: null
  Freq: null
  HazardType: null
  Class: null
  TCLEUNITS: null
  LetterDate: null
  MailingComments: null
  MailingRecipient: null
  MailingAddress: null
  MailingCityStateZip: null
  SIMPROVED: null
  ParcelUpdated: null
  PRTYCLASS: null
  Tax_ID: null
  PDRESSZIP: null
  PSSSTREET: null
  PCOMBINED: null
  PSNUMBER: null
  PDRESSDIR: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 6
Name: Fail
Domains:
• Status:
  Inherited
• IR:
  Inherited
• Freq:
  Inherited
• HazardType:
  Inherited
• Class:
  Inherited
• RouteBook:
  Inherited
Templates:
• Name: Fail
  Description:
  Prototype:
  PTYSTATUS: null
  Status: 6
  StatusDate: null
  Comments: null
  OwnerBiz: null
  CCCPAddress: null
  IR: null
  Freq: null
  HazardType: null
  Class: null
  TCLEUNITS: null
  LetterDate: null
  MailingComments: null
  MailingRecipient: null
  MailingAddress: null
  MailingCityStateZip: null
  SIMPROVED: null
  ParcelUpdated: null
  PRTYCLASS: null
  Tax_ID: null
  PDRESSZIP: null
  PSSSTREET: null
  PCOMBINED: null
  PSNUMBER: null
  PDRESSDIR: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 7
Name: Fail -FTC
Domains:
• Status:
  Inherited
• IR:
  Inherited
• Freq:
  Inherited
• HazardType:
  Inherited
• Class:
  Inherited
• RouteBook:
  Inherited
Templates:
• Name: Fail -FTC
  Description:
  Prototype:
  PTYSTATUS: null
  Status: 7
  StatusDate: null
  Comments: null
  OwnerBiz: null
  CCCPAddress: null
  IR: null
  Freq: null
  HazardType: null
  Class: null
  TCLEUNITS: null
  LetterDate: null
  MailingComments: null
  MailingRecipient: null
  MailingAddress: null
  MailingCityStateZip: null
  SIMPROVED: null
  ParcelUpdated: null
  PRTYCLASS: null
  Tax_ID: null
  PDRESSZIP: null
  PSSSTREET: null
  PCOMBINED: null
  PSNUMBER: null
  PDRESSDIR: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 8
Name: Fail - Off at Road
Domains:
• Status:
  Inherited
• IR:
  Inherited
• Freq:
  Inherited
• HazardType:
  Inherited
• Class:
  Inherited
• RouteBook:
  Inherited
Templates:
• Name: Fail - Off at Road
  Description:
  Prototype:
  PTYSTATUS: null
  Status: 8
  StatusDate: null
  Comments: null
  OwnerBiz: null
  CCCPAddress: null
  IR: null
  Freq: null
  HazardType: null
  Class: null
  TCLEUNITS: null
  LetterDate: null
  MailingComments: null
  MailingRecipient: null
  MailingAddress: null
  MailingCityStateZip: null
  SIMPROVED: null
  ParcelUpdated: null
  PRTYCLASS: null
  Tax_ID: null
  PDRESSZIP: null
  PSSSTREET: null
  PCOMBINED: null
  PSNUMBER: null
  PDRESSDIR: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 9
Name: Pass- Off at Road
Domains:
• Status:
  Inherited
• IR:
  Inherited
• Freq:
  Inherited
• HazardType:
  Inherited
• Class:
  Inherited
• RouteBook:
  Inherited
Templates:
• Name: Pass- Off at Road
  Description:
  Prototype:
  PTYSTATUS: null
  Status: 9
  StatusDate: null
  Comments: null
  OwnerBiz: null
  CCCPAddress: null
  IR: null
  Freq: null
  HazardType: null
  Class: null
  TCLEUNITS: null
  LetterDate: null
  MailingComments: null
  MailingRecipient: null
  MailingAddress: null
  MailingCityStateZip: null
  SIMPROVED: null
  ParcelUpdated: null
  PRTYCLASS: null
  Tax_ID: null
  PDRESSZIP: null
  PSSSTREET: null
  PCOMBINED: null
  PSNUMBER: null
  PDRESSDIR: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 99
Name: Not Due
Domains:
• Status:
  Inherited
• IR:
  Inherited
• Freq:
  Inherited
• HazardType:
  Inherited
• Class:
  Inherited
• RouteBook:
  Inherited
Templates:
• Name: Not Due
  Description:
  Prototype:
  PTYSTATUS: null
  Status: 99
  StatusDate: null
  Comments: null
  OwnerBiz: null
  CCCPAddress: null
  IR: null
  Freq: null
  HazardType: null
  Class: null
  TCLEUNITS: null
  LetterDate: null
  MailingComments: null
  MailingRecipient: null
  MailingAddress: null
  MailingCityStateZip: null
  SIMPROVED: null
  ParcelUpdated: null
  PRTYCLASS: null
  Tax_ID: null
  PDRESSZIP: null
  PSSSTREET: null
  PCOMBINED: null
  PSNUMBER: null
  PDRESSDIR: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

Relationships:

• DBO.CCCPInspection (1) -- Related To: Inspection Form (10)
• DBO.XCFound (2) -- Related To: XC Found Form (11)
• DBO.AssyDevice (0) -- Related To: Assy Device (0)

Tables:

Table: Inspection Form (10)

Name: Inspection Form

Display Field: InspectorName

Type: Table

Geometry Type: N/A

Description:

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


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 )
• OwnerContact ( type: esriFieldTypeString, alias: Owner / Contact, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OwnerContact )
• PhoneNo ( type: esriFieldTypeString, alias: Phone No, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PhoneNo )
• AddressLocation ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AddressLocation )
• InspDate ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspDate )
• InspectorName ( type: esriFieldTypeString, alias: Inspector's Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: InspectorName )
• InspType ( type: esriFieldTypeSmallInteger, alias: Inspection Type, editable: true, nullable: true, defaultValue: null, modelName: InspType , Coded Values: [1: Initial Inspection] , [2: Renewal Inspection] , [3: Re-Inspection] )
• CCCPClass ( type: esriFieldTypeSmallInteger, alias: Class, editable: true, nullable: true, defaultValue: null, modelName: CCCPClass , Coded Values: [1: Residential] , [2: Commercial] , [3: Non-CCCP Lot] , ...1 more... )
• HazardType ( type: esriFieldTypeSmallInteger, alias: Hazard Type, editable: true, nullable: true, defaultValue: null, modelName: HazardType , Coded Values: [1: Low] , [2: High] )
• HeatSource ( type: esriFieldTypeSmallInteger, alias: Heat Source, editable: true, nullable: true, defaultValue: null, modelName: HeatSource , Coded Values: [1: Forced Air] , [2: Boiler (protected)] , [3: Boiler (unprotected)] , ...1 more... )
• Question1 ( type: esriFieldTypeSmallInteger, alias: Question 1: Is there any type of secondary water supply within the property?, editable: true, nullable: true, defaultValue: null, modelName: Question1 , Coded Values: [0: No] , [1: Yes] )
• Q1SurfaceWater ( type: esriFieldTypeSmallInteger, alias: Surface Water, editable: true, nullable: true, defaultValue: null, modelName: Q1SurfaceWater , Coded Values: [0: No] , [1: Yes] )
• Q1WellSupply ( type: esriFieldTypeSmallInteger, alias: Well supply, editable: true, nullable: true, defaultValue: null, modelName: Q1WellSupply , Coded Values: [0: No] , [1: Yes] )
• Q1StorageTank ( type: esriFieldTypeSmallInteger, alias: Storage tank, editable: true, nullable: true, defaultValue: null, modelName: Q1StorageTank , Coded Values: [0: No] , [1: Yes] )
• Q1Recirculated ( type: esriFieldTypeSmallInteger, alias: Recirculated, editable: true, nullable: true, defaultValue: null, modelName: Q1Recirculated , Coded Values: [0: No] , [1: Yes] )
• Q1Other ( type: esriFieldTypeSmallInteger, alias: Other, see comments, editable: true, nullable: true, defaultValue: null, modelName: Q1Other , Coded Values: [0: No] , [1: Yes] )
• Question2 ( type: esriFieldTypeSmallInteger, alias: Question 2: Are there any cross connections by submerged inlet?, editable: true, nullable: true, defaultValue: null, modelName: Question2 , Coded Values: [0: No] , [1: Yes] )
• Q2Boiler ( type: esriFieldTypeSmallInteger, alias: Boilers, editable: true, nullable: true, defaultValue: null, modelName: Q2Boiler , Coded Values: [0: No] , [1: Yes] )
• Q2Lab ( type: esriFieldTypeSmallInteger, alias: Laboratories, editable: true, nullable: true, defaultValue: null, modelName: Q2Lab , Coded Values: [0: No] , [1: Yes] )
• Q2Sprinkler ( type: esriFieldTypeSmallInteger, alias: Lawn sprinkling system, editable: true, nullable: true, defaultValue: null, modelName: Q2Sprinkler , Coded Values: [0: No] , [1: Yes] )
• Q2Autopsy ( type: esriFieldTypeSmallInteger, alias: Autopsy / mortuary table, editable: true, nullable: true, defaultValue: null, modelName: Q2Autopsy , Coded Values: [0: No] , [1: Yes] )
• Q2Other ( type: esriFieldTypeSmallInteger, alias: Other, see comments, editable: true, nullable: true, defaultValue: null, modelName: Q2Other , Coded Values: [0: No] , [1: Yes] )
• Question3 ( type: esriFieldTypeSmallInteger, alias: Question 3: Are there any cross connections with piping which may contain sanitary water or a waste or a chemical contaminate?, editable: true, nullable: true, defaultValue: null, modelName: Question3 , Coded Values: [0: No] , [1: Yes] )
• Q3FireProtection ( type: esriFieldTypeSmallInteger, alias: Piping for fire protection, editable: true, nullable: true, defaultValue: null, modelName: Q3FireProtection , Coded Values: [0: No] , [1: Yes] )
• Q3Softner ( type: esriFieldTypeSmallInteger, alias: Equipment drained to sewer-water softner, editable: true, nullable: true, defaultValue: null, modelName: Q3Softner , Coded Values: [0: No] , [1: Yes] )
• Q3Refrigeration ( type: esriFieldTypeSmallInteger, alias: Refrigeration system, editable: true, nullable: true, defaultValue: null, modelName: Q3Refrigeration , Coded Values: [0: No] , [1: Yes] )
• Q3Other ( type: esriFieldTypeSmallInteger, alias: Other, see comments, editable: true, nullable: true, defaultValue: null, modelName: Q3Other , Coded Values: [0: No] , [1: Yes] )
• Question4 ( type: esriFieldTypeSmallInteger, alias: Question 4: Are there any cross connections with piping immersed in a tank or vessel?, editable: true, nullable: true, defaultValue: null, modelName: Question4 , Coded Values: [0: No] , [1: Yes] )
• Q4ComLaundry ( type: esriFieldTypeSmallInteger, alias: Commerical laundry, editable: true, nullable: true, defaultValue: null, modelName: Q4ComLaundry , Coded Values: [0: No] , [1: Yes] )
• Q4SteamLines ( type: esriFieldTypeSmallInteger, alias: Steam lines to keep storage tank from freezing, editable: true, nullable: true, defaultValue: null, modelName: Q4SteamLines , Coded Values: [0: No] , [1: Yes] )
• Q4Coils ( type: esriFieldTypeSmallInteger, alias: Coils within plating or rinse tanks, editable: true, nullable: true, defaultValue: null, modelName: Q4Coils , Coded Values: [0: No] , [1: Yes] )
• Q4Other ( type: esriFieldTypeSmallInteger, alias: Other, see comments, editable: true, nullable: true, defaultValue: null, modelName: Q4Other , Coded Values: [0: No] , [1: Yes] )
• Question5 ( type: esriFieldTypeSmallInteger, alias: Question 5: Are any hoses connected to possible contaminates?, editable: true, nullable: true, defaultValue: null, modelName: Question5 , Coded Values: [1: No] , [2: Yes - Protected by an approved vacuum breaker] , [3: Yes - NOT protected] )
• Question6 ( type: esriFieldTypeSmallInteger, alias: Question 6: Is the potable water supply within the propert satisfactory?, editable: true, nullable: true, defaultValue: null, modelName: Question6 , Coded Values: [0: No] , [1: Yes] )
• AirGap ( type: esriFieldTypeSmallInteger, alias: Air Gaps, editable: true, nullable: true, defaultValue: null, modelName: AirGap , Coded Values: [0: No] , [1: Yes] )
• VacuumBr ( type: esriFieldTypeSmallInteger, alias: Vacuum Breakers, editable: true, nullable: true, defaultValue: null, modelName: VacuumBr , Coded Values: [0: No] , [1: Yes] )
• PressureVaccuumBr ( type: esriFieldTypeSmallInteger, alias: Pressure Vaccuum Breaker, editable: true, nullable: true, defaultValue: null, modelName: PressureVaccuumBr , Coded Values: [0: No] , [1: Yes] )
• DoubleCkValveAssy ( type: esriFieldTypeSmallInteger, alias: Double Check Valve Assy, editable: true, nullable: true, defaultValue: null, modelName: DoubleCkValveAssy , Coded Values: [0: No] , [1: Yes] )
• VentedDouble_Ck ( type: esriFieldTypeSmallInteger, alias: Vented Double Check, editable: true, nullable: true, defaultValue: null, modelName: VentedDouble_Ck , Coded Values: [0: No] , [1: Yes] )
• RPZ ( type: esriFieldTypeSmallInteger, alias: RPZ, editable: true, nullable: true, defaultValue: null, modelName: RPZ , Coded Values: [0: No] , [1: Yes] )
• RPDA ( type: esriFieldTypeSmallInteger, alias: RPDA, editable: true, nullable: true, defaultValue: null, modelName: RPDA , Coded Values: [0: No] , [1: Yes] )
• Question8 ( type: esriFieldTypeSmallInteger, alias: Question 8: Any required protection?, editable: true, nullable: true, defaultValue: null, modelName: Question8 , Coded Values: [0: No] , [1: Yes] )
• ReqProtection ( type: esriFieldTypeString, alias: Required Protection:, editable: true, nullable: true, length: 400, defaultValue: null, modelName: ReqProtection )
• InspFreq ( type: esriFieldTypeSmallInteger, alias: Inspection Frequency?, editable: true, nullable: true, defaultValue: null, modelName: InspFreq , Coded Values: [1: 1] , [3: 3] , [10: 10] )
• MainLinContain ( type: esriFieldTypeSmallInteger, alias: Main Line Containment?, editable: true, nullable: true, defaultValue: null, modelName: MainLinContain , Coded Values: [0: No] , [1: Yes] )
• InspOutcome ( type: esriFieldTypeSmallInteger, alias: Inspection Outcome, editable: true, nullable: true, defaultValue: null, modelName: InspOutcome , Coded Values: [1: Approved] , [2: Failed] )
• HBVBTotal ( type: esriFieldTypeSmallInteger, alias: # HBVB Given, editable: true, nullable: true, defaultValue: null, modelName: HBVBTotal , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...8 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 400, defaultValue: null, modelName: Comments )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Related_GlobalID ( type: esriFieldTypeGUID, alias: Related_GlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Related_GlobalID )
• 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 )
Templates:
• Name: CCCPInspection
  Description:
  Prototype:
  Related_GlobalID: null
  OwnerContact: null
  PhoneNo: null
  AddressLocation: null
  InspDate: null
  InspectorName: null
  InspType: null
  CCCPClass: null
  HazardType: null
  HeatSource: null
  Question1: null
  Q1SurfaceWater: null
  Q1WellSupply: null
  Q1StorageTank: null
  Q1Recirculated: null
  Q1Other: null
  Question2: null
  Q2Boiler: null
  Q2Lab: null
  Q2Sprinkler: null
  Q2Autopsy: null
  Q2Other: null
  Question3: null
  Q3FireProtection: null
  Q3Softner: null
  Q3Refrigeration: null
  Q3Other: null
  Question4: null
  Q4ComLaundry: null
  Q4SteamLines: null
  Q4Coils: null
  Q4Other: null
  Question5: null
  Question6: null
  AirGap: null
  VacuumBr: null
  PressureVaccuumBr: null
  DoubleCkValveAssy: null
  VentedDouble_Ck: null
  RPZ: null
  RPDA: null
  Question8: null
  ReqProtection: null
  InspFreq: null
  MainLinContain: null
  InspOutcome: null
  HBVBTotal: null
  Comments: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• DBO.CCCPAccounts (1) -- Related To: CCCP Accounts (8)

Table: XC Found Form (11)

Name: XC Found Form

Display Field: AddressLocation

Type: Table

Geometry Type: N/A

Description:

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


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 )
• AddressLocation ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AddressLocation )
• XCFoundDate ( type: esriFieldTypeDate, alias: XC Found Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: XCFoundDate )
• XCDescription ( type: esriFieldTypeString, alias: XC Description, editable: true, nullable: true, length: 400, defaultValue: null, modelName: XCDescription )
• XCStatus ( type: esriFieldTypeSmallInteger, alias: XC Status, editable: true, nullable: true, defaultValue: null, modelName: XCStatus , Coded Values: [1: Existing] , [2: Resolved] )
• XCResolvedDate ( type: esriFieldTypeDate, alias: XC Resolved Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: XCResolvedDate )
• XCComments ( type: esriFieldTypeString, alias: XC Comments, editable: true, nullable: true, length: 400, defaultValue: null, modelName: XCComments )
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: REL_GLOBALID )
• 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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
Templates:
• Name: XCFound
  Description:
  Prototype:
  REL_GLOBALID: null
  AddressLocation: null
  XCFoundDate: null
  XCDescription: null
  XCStatus: null
  XCResolvedDate: null
  XCComments: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• DBO.CCCPAccounts (2) -- Related To: CCCP Accounts (8)