Name: JunctionTable

Display Field: PIP_ID_GENERIC

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• PIP_ID_GENERIC (type: esriFieldTypeString, alias: PIP_ID_GENERIC, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DOC_ROW (type: esriFieldTypeString, alias: DOC_ROW, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MATCH_TIER (type: esriFieldTypeString, alias: MATCH_TIER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CONFIDENCE (type: esriFieldTypeString, alias: CONFIDENCE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MATCHED_ON (type: esriFieldTypeString, alias: MATCHED_ON, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MATCH_TYPE (type: esriFieldTypeString, alias: MATCH_TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SCORE (type: esriFieldTypeString, alias: SCORE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• YEAR_CHECK (type: esriFieldTypeString, alias: YEAR_CHECK, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• YEAR_GAP (type: esriFieldTypeString, alias: YEAR_GAP, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ID_CONFLICT (type: esriFieldTypeString, alias: ID_CONFLICT, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• REVIEW_STATUS (type: esriFieldTypeString, alias: REVIEW_STATUS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)

Templates:

Name: JunctionTable
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• Water Main (0) -- Related To: WaterMain (0)
• As-Built Document (1) -- Related To: DocumentTable (2)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/16/2026 4:16:29 PM

Schema Last Edit Date: 9/16/2026 3:36:54 PM

Data Last Edit Date: 9/16/2026 4:16:29 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat