CCTV Manager Null Fields

Question

I'm trying to use our CCTV data with the CCTV Manager.  It works however the televised mains layer produces NULL values for all the existing fields, including most importantly Flow.  I've tried using both "U" and "Upstream".  I know I could easily join the data to the original tale based on inspection but seems like this should work.  Any suggestions or anyone else experience this?  We are using a custom schema.  ArcGIS Pro 2.2.1.

KrystalPhaneuf2 · Accepted Answer

Answered my own question.  Looks like the tool takes text or numeric field types for Inspection ID, however in the process it converts it to numeric and I'm guessing when it tried to join the tables it refused.  I changed the Inspection ID to numeric from text and the process worked and all fields appeared correctly.  Going to add a suggestion that ESRI create documentation for best field formats when using their solutions.