LRS Edit Log Table User Name Field

Idea created by Kyle.gonterwitz_KSDOT on Apr 1, 2019
    New
    Score10
    • Cameron@crab.wa.gov

    When creating a LRS data model in the Roads and Highways extention, the Lrs_Edit_Log table is a minimum schema object of the Roads and Highways LRS Data Model.  The Lrs_Edit_Log table has field "UserName", type "String" with field length 272.  

     

    The idea is to change the string length to 255.  Why?  Just because 255 is the shapefile/dbase limitation I suppose.    If anybody has a name longer than 255 characters first I apologize, second, you should use a shorter user name when editing roads and highways database.  It will also help with field validation based on a 255 length text field as a validation rule.