VERIFIED SOLUTION i
X

Using the Confirm Referential Integrity Map Layer specifications

UPDATED: October 1, 2018


Map Layer Specification

The specification for Referential Integrity map layer is in the Confirm help file under Confirm Task Processor > Agents > Referential Integrity Agent > Map Layer Specification.  They are:

Street Works Referential Integrity Map Layer

The Referential Integrity Agent will update the following columns depending on the Confirm entity being processed.

Referential Integrity will not automatically create the map layer unless stated in the section below.

The layer must contain these primary columns:
  • Work_Number (Char(12))

The layer may also contain the following optional columns. These attributes of the map layer record will be updated if present.
  • Organisation (Char(100))
  • Description (Char(254))
  • Start_Date (Date/Time)
  • End_Date (Date/Time)
  • Organisation_Code (Char(8))
  • Works_Reference (Char(20))

 

Defect Referential Integrity Map Layer

The layer must contain this primary column:
  • Defect_Number, defect_no (Decimal(8))

The layer may also contain the following optional columns. These attributes of the map layer record will be updated if present.
  • Defect_Type, def_type (Char(4))
  • Description, descript (Char(254))
  • Location (Char(254))
  • Defect_Date, def_date (Date/Time)
  • Defect_Status, def_status (Char(1))

 A blank MapInfo map layer for Defects is in the attachment Blank Defect RI Map Layer.zip


Feature Referential Integrity Map Layer

The layer must contain one of these primary columns:
  • Central_Asset_Id (Char(20))
  • Asset_Id * (Char(15))

The layer may also contain the following optional columns. These attributes of the map layer record will be updated if present. Confirm columns can relate to different map column names depending on the flavour of Confirm being used and the layer's mapping technology. Below are the map column names that Referential Integrity can update:
  • Site_Code (Char(10))
  • Site_Name, Street_Name, Road_Name, Building_Name (Char(40))
  • Plot_Number, Plot_No, Asset_Number, Sequence_Number, Feature_Number, Section_Number (Decimal(10,2))
  • Feature_Id, Asset_Id *, Tag_Number, Road_Number, Label (Char(15))
  • Feature_Type (Char(4)) (populated with the Feature Type Code)
  • Feature_Type_Name, Type, Species, Carriageway_Type (Char(30))
  • Feature_Group_Code, Feature_Gp (Char(4))
  • Feature_Location, Location, Tree_Location, Feature_Location, Section_Location (Char(254))
  • Primary_Measure, Prim_Meas (Decimal(10,2))
  • Unit_Of_Measure, unit (Char(15))
  • Layer (Char(50))
  • Start_Date (Date/Time)
  • End_Date (Date/Time)
  • Centroid_Easting (Decimal(10,2))
  • Centroid_Northing (Decimal(10,2))
  • Extent_Easting_1 (Decimal(10,2))
  • Extent_Northing_1 (Decimal(10,2))
  • Extent_Easting_2 (Decimal(10,2))
  • Extent_Northing_2 (Decimal(10,2))

* Asset_Id is only populated with the Feature Id column from Confirm if Central_Asset_Id is being used as the primary column. Otherwise Asset_Id will contain the Central_Asset_Id.


Enquiry Referential Integrity Map Layer

The layer must contain this primary column:
  • Enquiry_Number, enq_no (Decimal(8,0))

For full functionality the layer must also contain the following columns:
  • Service (Char(4))
  • Subject (Char(4))
  • Description, descript (Char(254))
  • Location (Char(254))
  • Logged_Date, log_date (Date/Time)
  • Enquiry_Status, enq_status (Char(4))
  • Site_Code (Char(10))


Job Referential Integrity Map Layer

The layer must contain this primary column:
  • Job_Number (Decimal(8,0))

The layer may also contain the following optional columns. These attributes of the map layer record will be updated if present.
  • Location (Character(250))
  • Notes (Character(250))
  • Job_Status (Char(4))
  • Site_Code (Char(10))
  • Plot_Number, plot_no (Decimal(10,2))


GPS Logging Referential Integrity Map Layer

Referential Integrity will automatically create this layer.

The layer will be populated with the Action Officer's current GPS location information when updates are received via the Confirm Connector.

 

The layer must contain this primary column:
  • Officer_Code (Char(4))

The layer will also contain the following columns:
  • Officer_Name (Char(30))
  • Work_Group (Char(4))
  • Officer_Telephone (Char(20))
  • Location_Key (Decimal(9,0))
  • Location_Date_Time (Char(30))

Environment Details

Products affected: Confirm

 

Downloads

  • No Downloads