Feature Class Schema

Lucity GIS has tools that affect the schema of a Feature class. These tools can add several fields to a GIS feature class which are automatically updated by Lucity and update aliases to match Lucity. These fields are designed to help maintain and track the integration between Lucity and GIS. Since these are special Lucity fields there are tools to add these fields to geodatabase feature classes.

Tool	Result	Purpose
Add Lucity Auto ID field	Adds the LucityLink field to the feature class(es)	Stores the system defined record number in the feature class
Add Lucity In DB field	Adds the InLucity field to the feature class(es)	Flags whether the GIS Feature exists in the Lucity database
Add Modified/Synced fields	Adds the Last Modified By, Last Modified Time, Last Synced By fields	These fields record when and who last modified a feature and when it was last synced to Lucity
Set field alias equal to Lucity Field caption	Updates a feature classes fields aliases to match the field captions found in Lucity. This only affects feature class fields that are linked to Lucity.	This is designed to simplify/standardize the field captions between ArcMap and Lucity.
Set feature class alias equal to Lucity module name	Updates the feature class alias to match the Lucity module name.	This is designed to simplify/standardize the feature class captions between ArcMap and Lucity.

Note: None of these fields are required.

Note: All of these fields are automatically maintained by the Lucity GIS tools

These tools can be applied on individual feature classes or all feature classes in a connected geodatabase. There are also tools to change field and feature class aliases to match Lucity. All of these tools are primarily for organizations that are using a geodatabase that isn't based on the Lucity schema.

Note: If using an sde all of these tools will prompt for geodatabase credentials that have the necessary permissions to make schema changes.

Note: The person running these tools must be able to acquire an exclusive lock on each feature class.

How to

Run the Feature Class Schema Tools

Select the geodatabase connection, OR the feature class to be updated
Right click on the selected geodatabase OR feature class and select Feature Class Schema > One of the tools.
A confirmation screen similar to the following one will appear. This is a warning about what is about to occur and that nobody else should be accessing the geodatabase at this time.
Select and the tool will run.
- Add Lucity Auto ID field - Adds the LucityLink field and links it in the geodatabase configuration Feature Class Information Tab
- Add Lucity In DB field - Adds the InLucity field and links it in the geodatabase configuration Feature Class Information Tab
- Add Modified/Synced fields - Adds the Last Modified By, Last Modified Time, Last Synced By fields and links it in the geodatabase configuration Feature Class Information Tab.
- Set Field Alias equal to Lucity Field Caption - Changes the alias for geodatabase fields linked to Lucity so they match the field names seen in Lucity
- Set Feature Class Alias equal to Lucity Module name - Changes the alias for feature classes linked to Lucity to match the Lucity Module name that they are linked to.
The results will be displayed in a validation window.