<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<metadata xml:lang="en">
<Esri>
<CreaDate>20241106</CreaDate>
<CreaTime>17344700</CreaTime>
<ArcGISFormat>1.0</ArcGISFormat>
<SyncOnce>TRUE</SyncOnce>
<DataProperties>
<lineage>
<Process Date="20241106" Time="173447" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\toolboxes\Data Management Tools.tbx\CreateFeatureclass">CreateFeatureclass C:\SDE\next_gen_dev.sde AnnexationSubmissions_DEV Point # No Yes "PROJCS["WGS_1984_Web_Mercator_Auxiliary_Sphere",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Mercator_Auxiliary_Sphere"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",0.0],PARAMETER["Auxiliary_Sphere_Type",0.0],UNIT["Meter",1.0]];-20037700 -30241100 10000;-100000 10000;-100000 10000;0.001;0.001;0.001;IsHighPrecision" # # # # #</Process>
<Process Date="20241106" Time="173451" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\toolboxes\Data Management Tools.tbx\AddGlobalIDs">AddGlobalIDs C:\SDE\next_gen_dev.sde\AnnexationSubmissions_DEV</Process>
<Process Date="20241106" Time="173459" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_dev.sde\AnnexationSubmissions_DEV "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;dca_id&lt;/field_name&gt;&lt;field_type&gt;Long&lt;/field_type&gt;&lt;field_alias&gt;DCA ID&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;4&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;user_name&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_alias&gt;User Name&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;user_title&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_alias&gt;User Title&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;user_email&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_alias&gt;User Email&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;arb_check&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_alias&gt;Arbitration Status&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;municipality&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_alias&gt;Municipality&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;countyfips&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_alias&gt;FIPS&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;county&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_alias&gt;County&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;rc_name&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_alias&gt;rc_name&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;planning_rc_name&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_alias&gt;Planning Regional Commission&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;auth_type&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_alias&gt;Authorization Type&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;auth_num&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_alias&gt;Authorization Number&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;auth_date&lt;/field_name&gt;&lt;field_type&gt;DATE&lt;/field_type&gt;&lt;field_alias&gt;Authorization Date&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;8&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;eff_date&lt;/field_name&gt;&lt;field_type&gt;DATE&lt;/field_type&gt;&lt;field_alias&gt;Effective Date&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;8&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;dca_date&lt;/field_name&gt;&lt;field_type&gt;DATE&lt;/field_type&gt;&lt;field_alias&gt;Date Annexation Processed by DCA&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;8&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;annex_type&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_alias&gt;Annexation or De-Annexation&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;parcel_sum&lt;/field_name&gt;&lt;field_type&gt;Long&lt;/field_type&gt;&lt;field_alias&gt;Parcel Count&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;4&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;acreage&lt;/field_name&gt;&lt;field_type&gt;DOUBLE&lt;/field_type&gt;&lt;field_alias&gt;Total Acreage&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;8&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;bas_check&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_alias&gt;BAS Survey Acknowledgement&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;10&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;legi_check&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_alias&gt;Legislative Office Acknowledgement&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;10&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;road_check&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_alias&gt;Roadway/Mileage Acknowledgement&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;10&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;road_info&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_alias&gt;Roadway/Mileage Comments&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;10000&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;ord_sign&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_alias&gt;Signed Ordinance/Act/Resolution&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;comments&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_alias&gt;Comments&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;10000&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;created_user&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_alias&gt;created_user&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;created_date&lt;/field_name&gt;&lt;field_type&gt;DATE&lt;/field_type&gt;&lt;field_alias&gt;created_date&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;8&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;last_edited_user&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_alias&gt;last_edited_user&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;last_edited_date&lt;/field_name&gt;&lt;field_type&gt;DATE&lt;/field_type&gt;&lt;field_alias&gt;last_edited_date&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;8&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;internal_status&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;external_status&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;automation_status&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20241106" Time="173503" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_dev.sde\AnnexationSubmissions_DEV &lt;operationSequence&gt;&lt;workflow&gt;&lt;AlterField&gt;&lt;field_name&gt;OBJECTID&lt;/field_name&gt;&lt;field_alias&gt;OBJECTID&lt;/field_alias&gt;&lt;/AlterField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AlterField&gt;&lt;field_name&gt;SHAPE&lt;/field_name&gt;&lt;field_alias&gt;SHAPE&lt;/field_alias&gt;&lt;/AlterField&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;</Process>
<Process Date="20241106" Time="173638" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema "CIMDATA=&lt;CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'&gt;&lt;WorkspaceConnectionString&gt;ENCRYPTED_PASSWORD=00022e684a6b6b6b4574473977486734664d50506551754642497a4b415a46666935385649582f6b67484e4f3074386c684d37555646347141626f6f374b36655664336d2a00;SERVER=proddatabase.postgres.database.usgovcloudapi.net;INSTANCE=sde:postgresql:proddatabase.postgres.database.usgovcloudapi.net;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=proddatabase.postgres.database.usgovcloudapi.net;DATABASE=next_gen_dev;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS&lt;/WorkspaceConnectionString&gt;&lt;WorkspaceFactory&gt;SDE&lt;/WorkspaceFactory&gt;&lt;Dataset&gt;next_gen_dev.sde.AnnexationSubmissions_DEV&lt;/Dataset&gt;&lt;DatasetType&gt;esriDTFeatureClass&lt;/DatasetType&gt;&lt;/CIMStandardDataConnection&gt;" "&lt;operationSequence&gt;&lt;workflow&gt;&lt;EnableAttachments /&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;EnableEditorTracking&gt;&lt;creator_field&gt;created_user&lt;/creator_field&gt;&lt;creation_date_field&gt;created_date&lt;/creation_date_field&gt;&lt;last_editor_field&gt;last_edited_user&lt;/last_editor_field&gt;&lt;last_edit_date_field&gt;last_edited_date&lt;/last_edit_date_field&gt;&lt;add_fields&gt;TRUE&lt;/add_fields&gt;&lt;record_dates_in&gt;UTC&lt;/record_dates_in&gt;&lt;/EnableEditorTracking&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20241106" Time="175521" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema "CIMDATA=&lt;CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'&gt;&lt;WorkspaceConnectionString&gt;ENCRYPTED_PASSWORD=00022e6849796c49747630773967324c4b527546676f544d4d76476a55666566627033642f5578494c576e7a726d57695333714b4a4948566f6d316f45686e432b624a4d2a00;SERVER=proddatabase.postgres.database.usgovcloudapi.net;INSTANCE=sde:postgresql:proddatabase.postgres.database.usgovcloudapi.net;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=proddatabase.postgres.database.usgovcloudapi.net;DATABASE=next_gen_dev;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS&lt;/WorkspaceConnectionString&gt;&lt;WorkspaceFactory&gt;SDE&lt;/WorkspaceFactory&gt;&lt;Dataset&gt;next_gen_dev.sde.AnnexationSubmissions_DEV&lt;/Dataset&gt;&lt;DatasetType&gt;esriDTFeatureClass&lt;/DatasetType&gt;&lt;/CIMStandardDataConnection&gt;" &lt;operationSequence&gt;&lt;workflow&gt;&lt;AssignDomainToField&gt;&lt;field_name&gt;internal_status&lt;/field_name&gt;&lt;domain_name&gt;AnnexSub_internalStatus&lt;/domain_name&gt;&lt;/AssignDomainToField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AssignDomainToField&gt;&lt;field_name&gt;external_status&lt;/field_name&gt;&lt;domain_name&gt;AnnexSub_externalStatus&lt;/domain_name&gt;&lt;/AssignDomainToField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AssignDomainToField&gt;&lt;field_name&gt;automation_status&lt;/field_name&gt;&lt;domain_name&gt;AnnexSub_automationStatus&lt;/domain_name&gt;&lt;/AssignDomainToField&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;</Process>
<Process Date="20241108" Time="200338" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema "CIMDATA=&lt;CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'&gt;&lt;WorkspaceConnectionString&gt;ENCRYPTED_PASSWORD=00022e684a6b6b6b4574473977486734664d50506551754642497a4b415a46666935385649582f6b67484e4f3074386c684d37555646347141626f6f374b36655664336d2a00;SERVER=proddatabase.postgres.database.usgovcloudapi.net;INSTANCE=sde:postgresql:proddatabase.postgres.database.usgovcloudapi.net;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=proddatabase.postgres.database.usgovcloudapi.net;DATABASE=next_gen_dev;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS&lt;/WorkspaceConnectionString&gt;&lt;WorkspaceFactory&gt;SDE&lt;/WorkspaceFactory&gt;&lt;Dataset&gt;next_gen_dev.sde.AnnexationSubmissions_DEV&lt;/Dataset&gt;&lt;DatasetType&gt;esriDTFeatureClass&lt;/DatasetType&gt;&lt;/CIMStandardDataConnection&gt;" &lt;operationSequence&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;job_id&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_precision&gt;0&lt;/field_precision&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;field_alias&gt;job_id&lt;/field_alias&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;field_is_required&gt;False&lt;/field_is_required&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;</Process>
<Process Date="20241108" Time="200456" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema "CIMDATA=&lt;CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'&gt;&lt;WorkspaceConnectionString&gt;ENCRYPTED_PASSWORD=00022e684a6b6b6b4574473977486734664d50506551754642497a4b415a46666935385649582f6b67484e4f3074386c684d37555646347141626f6f374b36655664336d2a00;SERVER=proddatabase.postgres.database.usgovcloudapi.net;INSTANCE=sde:postgresql:proddatabase.postgres.database.usgovcloudapi.net;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=proddatabase.postgres.database.usgovcloudapi.net;DATABASE=next_gen_dev;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS&lt;/WorkspaceConnectionString&gt;&lt;WorkspaceFactory&gt;SDE&lt;/WorkspaceFactory&gt;&lt;Dataset&gt;next_gen_dev.sde.AnnexationSubmissions_DEV&lt;/Dataset&gt;&lt;DatasetType&gt;esriDTFeatureClass&lt;/DatasetType&gt;&lt;/CIMStandardDataConnection&gt;" &lt;operationSequence&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;job_id&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_precision&gt;0&lt;/field_precision&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;field_alias&gt;job_id&lt;/field_alias&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;field_is_required&gt;False&lt;/field_is_required&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;</Process>
<Process Date="20241108" Time="200514" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema "CIMDATA=&lt;CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'&gt;&lt;WorkspaceConnectionString&gt;ENCRYPTED_PASSWORD=00022e684a6b6b6b4574473977486734664d50506551754642497a4b415a46666935385649582f6b67484e4f3074386c684d37555646347141626f6f374b36655664336d2a00;SERVER=proddatabase.postgres.database.usgovcloudapi.net;INSTANCE=sde:postgresql:proddatabase.postgres.database.usgovcloudapi.net;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=proddatabase.postgres.database.usgovcloudapi.net;DATABASE=next_gen_dev;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS&lt;/WorkspaceConnectionString&gt;&lt;WorkspaceFactory&gt;SDE&lt;/WorkspaceFactory&gt;&lt;Dataset&gt;next_gen_dev.sde.AnnexationSubmissions_DEV&lt;/Dataset&gt;&lt;DatasetType&gt;esriDTFeatureClass&lt;/DatasetType&gt;&lt;/CIMStandardDataConnection&gt;" &lt;operationSequence&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;job_id&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_precision&gt;0&lt;/field_precision&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;field_alias&gt;job_id&lt;/field_alias&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;field_is_required&gt;False&lt;/field_is_required&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;</Process>
<Process Date="20241108" Time="200701" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema "CIMDATA=&lt;CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'&gt;&lt;WorkspaceConnectionString&gt;ENCRYPTED_PASSWORD=00022e684a6b6b6b4574473977486734664d50506551754642497a4b415a46666935385649582f6b67484e4f3074386c684d37555646347141626f6f374b36655664336d2a00;SERVER=proddatabase.postgres.database.usgovcloudapi.net;INSTANCE=sde:postgresql:proddatabase.postgres.database.usgovcloudapi.net;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=proddatabase.postgres.database.usgovcloudapi.net;DATABASE=next_gen_dev;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS&lt;/WorkspaceConnectionString&gt;&lt;WorkspaceFactory&gt;SDE&lt;/WorkspaceFactory&gt;&lt;Dataset&gt;next_gen_dev.sde.AnnexationSubmissions_DEV&lt;/Dataset&gt;&lt;DatasetType&gt;esriDTFeatureClass&lt;/DatasetType&gt;&lt;/CIMStandardDataConnection&gt;" &lt;operationSequence&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;job_id&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_precision&gt;0&lt;/field_precision&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;field_alias&gt;job_id&lt;/field_alias&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;field_is_required&gt;False&lt;/field_is_required&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;</Process>
<Process Date="20241108" Time="200830" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema "CIMDATA=&lt;CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'&gt;&lt;WorkspaceConnectionString&gt;ENCRYPTED_PASSWORD=00022e684a6b6b6b4574473977486734664d50506551754642497a4b415a46666935385649582f6b67484e4f3074386c684d37555646347141626f6f374b36655664336d2a00;SERVER=proddatabase.postgres.database.usgovcloudapi.net;INSTANCE=sde:postgresql:proddatabase.postgres.database.usgovcloudapi.net;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=proddatabase.postgres.database.usgovcloudapi.net;DATABASE=next_gen_dev;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS&lt;/WorkspaceConnectionString&gt;&lt;WorkspaceFactory&gt;SDE&lt;/WorkspaceFactory&gt;&lt;Dataset&gt;next_gen_dev.sde.AnnexationSubmissions_DEV&lt;/Dataset&gt;&lt;DatasetType&gt;esriDTFeatureClass&lt;/DatasetType&gt;&lt;/CIMStandardDataConnection&gt;" &lt;operationSequence&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;job_id&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_precision&gt;0&lt;/field_precision&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;field_alias&gt;job_id&lt;/field_alias&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;field_is_required&gt;False&lt;/field_is_required&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;</Process>
<Process Date="20241108" Time="200954" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema "CIMDATA=&lt;CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'&gt;&lt;WorkspaceConnectionString&gt;ENCRYPTED_PASSWORD=00022e684a6b6b6b4574473977486734664d50506551754642497a4b415a46666935385649582f6b67484e4f3074386c684d37555646347141626f6f374b36655664336d2a00;SERVER=proddatabase.postgres.database.usgovcloudapi.net;INSTANCE=sde:postgresql:proddatabase.postgres.database.usgovcloudapi.net;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=proddatabase.postgres.database.usgovcloudapi.net;DATABASE=next_gen_dev;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS&lt;/WorkspaceConnectionString&gt;&lt;WorkspaceFactory&gt;SDE&lt;/WorkspaceFactory&gt;&lt;Dataset&gt;next_gen_dev.sde.AnnexationSubmissions_DEV&lt;/Dataset&gt;&lt;DatasetType&gt;esriDTFeatureClass&lt;/DatasetType&gt;&lt;/CIMStandardDataConnection&gt;" &lt;operationSequence&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;job_id&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_precision&gt;0&lt;/field_precision&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;field_alias&gt;job_id&lt;/field_alias&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;field_is_required&gt;False&lt;/field_is_required&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;</Process>
<Process Date="20241111" Time="204233" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema "CIMDATA=&lt;CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'&gt;&lt;WorkspaceConnectionString&gt;ENCRYPTED_PASSWORD=00022e684a6b6b6b4574473977486734664d50506551754642497a4b415a46666935385649582f6b67484e4f3074386c684d37555646347141626f6f374b36655664336d2a00;SERVER=proddatabase.postgres.database.usgovcloudapi.net;INSTANCE=sde:postgresql:proddatabase.postgres.database.usgovcloudapi.net;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=proddatabase.postgres.database.usgovcloudapi.net;DATABASE=next_gen_dev;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS&lt;/WorkspaceConnectionString&gt;&lt;WorkspaceFactory&gt;SDE&lt;/WorkspaceFactory&gt;&lt;Dataset&gt;next_gen_dev.sde.AnnexationSubmissions_DEV&lt;/Dataset&gt;&lt;DatasetType&gt;esriDTFeatureClass&lt;/DatasetType&gt;&lt;/CIMStandardDataConnection&gt;" &lt;operationSequence&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;job_id&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_precision&gt;0&lt;/field_precision&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;field_alias&gt;job_id&lt;/field_alias&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;field_is_required&gt;False&lt;/field_is_required&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;</Process>
<Process Date="20241111" Time="205652" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema "CIMDATA=&lt;CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'&gt;&lt;WorkspaceConnectionString&gt;ENCRYPTED_PASSWORD=00022e684a6b6b6b4574473977486734664d50506551754642497a4b415a46666935385649582f6b67484e4f3074386c684d37555646347141626f6f374b36655664336d2a00;SERVER=proddatabase.postgres.database.usgovcloudapi.net;INSTANCE=sde:postgresql:proddatabase.postgres.database.usgovcloudapi.net;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=proddatabase.postgres.database.usgovcloudapi.net;DATABASE=next_gen_dev;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS&lt;/WorkspaceConnectionString&gt;&lt;WorkspaceFactory&gt;SDE&lt;/WorkspaceFactory&gt;&lt;Dataset&gt;next_gen_dev.sde.AnnexationSubmissions_DEV&lt;/Dataset&gt;&lt;DatasetType&gt;esriDTFeatureClass&lt;/DatasetType&gt;&lt;/CIMStandardDataConnection&gt;" &lt;operationSequence&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;job_id&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_precision&gt;0&lt;/field_precision&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;field_alias&gt;job_id&lt;/field_alias&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;field_is_required&gt;False&lt;/field_is_required&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;</Process>
<Process Date="20241112" Time="164124" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema "CIMDATA=&lt;CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'&gt;&lt;WorkspaceConnectionString&gt;ENCRYPTED_PASSWORD=00022e684a6b6b6b4574473977486734664d50506551754642497a4b415a46666935385649582f6b67484e4f3074386c684d37555646347141626f6f374b36655664336d2a00;SERVER=proddatabase.postgres.database.usgovcloudapi.net;INSTANCE=sde:postgresql:proddatabase.postgres.database.usgovcloudapi.net;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=proddatabase.postgres.database.usgovcloudapi.net;DATABASE=next_gen_dev;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS&lt;/WorkspaceConnectionString&gt;&lt;WorkspaceFactory&gt;SDE&lt;/WorkspaceFactory&gt;&lt;Dataset&gt;next_gen_dev.sde.AnnexationSubmissions_DEV&lt;/Dataset&gt;&lt;DatasetType&gt;esriDTFeatureClass&lt;/DatasetType&gt;&lt;/CIMStandardDataConnection&gt;" "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AssignDefaultToField&gt;&lt;field_name&gt;internal_status&lt;/field_name&gt;&lt;default_value&gt;Awaiting manual review.&lt;/default_value&gt;&lt;/AssignDefaultToField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AssignDefaultToField&gt;&lt;field_name&gt;external_status&lt;/field_name&gt;&lt;default_value&gt;Annexation Filing In-Process&lt;/default_value&gt;&lt;/AssignDefaultToField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AssignDefaultToField&gt;&lt;field_name&gt;automation_status&lt;/field_name&gt;&lt;default_value&gt;Manual Review Pending&lt;/default_value&gt;&lt;/AssignDefaultToField&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20241126" Time="205125" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema "CIMDATA=&lt;CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'&gt;&lt;WorkspaceConnectionString&gt;ENCRYPTED_PASSWORD=00022e684a6b6b6b4574473977486734664d50506551754642497a4b415a46666935385649582f6b67484e4f3074386c684d37555646347141626f6f374b36655664336d2a00;SERVER=proddatabase.postgres.database.usgovcloudapi.net;INSTANCE=sde:postgresql:proddatabase.postgres.database.usgovcloudapi.net;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=proddatabase.postgres.database.usgovcloudapi.net;DATABASE=next_gen_dev;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS&lt;/WorkspaceConnectionString&gt;&lt;WorkspaceFactory&gt;SDE&lt;/WorkspaceFactory&gt;&lt;Dataset&gt;next_gen_dev.sde.AnnexationSubmissions_DEV&lt;/Dataset&gt;&lt;DatasetType&gt;esriDTFeatureClass&lt;/DatasetType&gt;&lt;/CIMStandardDataConnection&gt;" "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;cid&lt;/field_name&gt;&lt;field_type&gt;LONG&lt;/field_type&gt;&lt;field_precision&gt;10&lt;/field_precision&gt;&lt;field_alias&gt;Community ID&lt;/field_alias&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;field_is_required&gt;False&lt;/field_is_required&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;cityname&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_precision&gt;0&lt;/field_precision&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;field_alias&gt;City Name&lt;/field_alias&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;field_is_required&gt;False&lt;/field_is_required&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20241126" Time="205236" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema "CIMDATA=&lt;CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'&gt;&lt;WorkspaceConnectionString&gt;ENCRYPTED_PASSWORD=00022e684a6b6b6b4574473977486734664d50506551754642497a4b415a46666935385649582f6b67484e4f3074386c684d37555646347141626f6f374b36655664336d2a00;SERVER=proddatabase.postgres.database.usgovcloudapi.net;INSTANCE=sde:postgresql:proddatabase.postgres.database.usgovcloudapi.net;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=proddatabase.postgres.database.usgovcloudapi.net;DATABASE=next_gen_dev;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS&lt;/WorkspaceConnectionString&gt;&lt;WorkspaceFactory&gt;SDE&lt;/WorkspaceFactory&gt;&lt;Dataset&gt;next_gen_dev.sde.AnnexationSubmissions_DEV&lt;/Dataset&gt;&lt;DatasetType&gt;esriDTFeatureClass&lt;/DatasetType&gt;&lt;/CIMStandardDataConnection&gt;" "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;cid&lt;/field_name&gt;&lt;field_type&gt;LONG&lt;/field_type&gt;&lt;field_precision&gt;10&lt;/field_precision&gt;&lt;field_alias&gt;Community ID&lt;/field_alias&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;field_is_required&gt;False&lt;/field_is_required&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;cityname&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_precision&gt;0&lt;/field_precision&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;field_alias&gt;City Name&lt;/field_alias&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;field_is_required&gt;False&lt;/field_is_required&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20241126" Time="230011" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_dev.sde\next_gen_dev.sde.AnnexationSubmissions_DEV "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_dca_id&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;return Number(NextSequenceValue ('annexations_dca_id_DEV'))&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;True&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;False&lt;/triggering_events_update&gt;&lt;rule_description&gt;Using DB Sequence annexations_dca_id_DEV to calculate the unique dca_id&lt;/rule_description&gt;&lt;field_name&gt;dca_id&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;True&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;-1&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_dca_id&lt;/rule_name&gt;&lt;evaluation_order&gt;1&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20241127" Time="211325" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema "CIMDATA=&lt;CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'&gt;&lt;WorkspaceConnectionString&gt;ENCRYPTED_PASSWORD=00022e684a6b6b6b4574473977486734664d50506551754642497a4b415a46666935385649582f6b67484e4f3074386c684d37555646347141626f6f374b36655664336d2a00;SERVER=proddatabase.postgres.database.usgovcloudapi.net;INSTANCE=sde:postgresql:proddatabase.postgres.database.usgovcloudapi.net;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=proddatabase.postgres.database.usgovcloudapi.net;DATABASE=next_gen_dev;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS&lt;/WorkspaceConnectionString&gt;&lt;WorkspaceFactory&gt;SDE&lt;/WorkspaceFactory&gt;&lt;Dataset&gt;next_gen_dev.sde.AnnexationSubmissions_DEV&lt;/Dataset&gt;&lt;DatasetType&gt;esriDTFeatureClass&lt;/DatasetType&gt;&lt;/CIMStandardDataConnection&gt;" "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;prg_comm&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_precision&gt;0&lt;/field_precision&gt;&lt;field_length&gt;10000&lt;/field_length&gt;&lt;field_alias&gt;PRG Comments&lt;/field_alias&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;field_is_required&gt;False&lt;/field_is_required&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20241127" Time="211350" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema "CIMDATA=&lt;CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'&gt;&lt;WorkspaceConnectionString&gt;ENCRYPTED_PASSWORD=00022e684a6b6b6b4574473977486734664d50506551754642497a4b415a46666935385649582f6b67484e4f3074386c684d37555646347141626f6f374b36655664336d2a00;SERVER=proddatabase.postgres.database.usgovcloudapi.net;INSTANCE=sde:postgresql:proddatabase.postgres.database.usgovcloudapi.net;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=proddatabase.postgres.database.usgovcloudapi.net;DATABASE=next_gen_dev;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS&lt;/WorkspaceConnectionString&gt;&lt;WorkspaceFactory&gt;SDE&lt;/WorkspaceFactory&gt;&lt;Dataset&gt;next_gen_dev.sde.AnnexationSubmissions_DEV&lt;/Dataset&gt;&lt;DatasetType&gt;esriDTFeatureClass&lt;/DatasetType&gt;&lt;/CIMStandardDataConnection&gt;" "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;prg_comm&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_precision&gt;0&lt;/field_precision&gt;&lt;field_length&gt;10000&lt;/field_length&gt;&lt;field_alias&gt;PRG Comments&lt;/field_alias&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;field_is_required&gt;False&lt;/field_is_required&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20241127" Time="215032" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema "CIMDATA=&lt;CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'&gt;&lt;WorkspaceConnectionString&gt;ENCRYPTED_PASSWORD=00022e684a6b6b6b4574473977486734664d50506551754642497a4b415a46666935385649582f6b67484e4f3074386c684d37555646347141626f6f374b36655664336d2a00;SERVER=proddatabase.postgres.database.usgovcloudapi.net;INSTANCE=sde:postgresql:proddatabase.postgres.database.usgovcloudapi.net;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=proddatabase.postgres.database.usgovcloudapi.net;DATABASE=next_gen_dev;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS&lt;/WorkspaceConnectionString&gt;&lt;WorkspaceFactory&gt;SDE&lt;/WorkspaceFactory&gt;&lt;Dataset&gt;next_gen_dev.sde.AnnexationSubmissions_DEV&lt;/Dataset&gt;&lt;DatasetType&gt;esriDTFeatureClass&lt;/DatasetType&gt;&lt;/CIMStandardDataConnection&gt;" "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AlterField&gt;&lt;field_name&gt;rc_name&lt;/field_name&gt;&lt;field_alias&gt;RC Name&lt;/field_alias&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;clear_field_alias&gt;False&lt;/clear_field_alias&gt;&lt;/AlterField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AlterField&gt;&lt;field_name&gt;internal_status&lt;/field_name&gt;&lt;field_alias&gt;Internal Status&lt;/field_alias&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;clear_field_alias&gt;False&lt;/clear_field_alias&gt;&lt;/AlterField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AlterField&gt;&lt;field_name&gt;external_status&lt;/field_name&gt;&lt;field_alias&gt;Annexation Status&lt;/field_alias&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;clear_field_alias&gt;False&lt;/clear_field_alias&gt;&lt;/AlterField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AlterField&gt;&lt;field_name&gt;automation_status&lt;/field_name&gt;&lt;field_alias&gt;Automation Status&lt;/field_alias&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;clear_field_alias&gt;False&lt;/clear_field_alias&gt;&lt;/AlterField&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20241204" Time="174706" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_dev.sde\next_gen_dev.sde.AnnexationSubmissions_DEV &lt;operationSequence&gt;&lt;workflow&gt;&lt;DisableAttributeRules&gt;&lt;rule_name&gt;annex_dca_id&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DisableAttributeRules&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;</Process>
<Process Date="20241204" Time="175019" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema "CIMDATA=&lt;CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'&gt;&lt;WorkspaceConnectionString&gt;ENCRYPTED_PASSWORD=00022e684a6b6b6b4574473977486734664d50506551754642497a4b415a46666935385649582f6b67484e4f3074386c684d37555646347141626f6f374b36655664336d2a00;SERVER=proddatabase.postgres.database.usgovcloudapi.net;INSTANCE=sde:postgresql:proddatabase.postgres.database.usgovcloudapi.net;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=proddatabase.postgres.database.usgovcloudapi.net;DATABASE=next_gen_dev;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS&lt;/WorkspaceConnectionString&gt;&lt;WorkspaceFactory&gt;SDE&lt;/WorkspaceFactory&gt;&lt;Dataset&gt;next_gen_dev.sde.AnnexationSubmissions_DEV&lt;/Dataset&gt;&lt;DatasetType&gt;esriDTFeatureClass&lt;/DatasetType&gt;&lt;/CIMStandardDataConnection&gt;" &lt;operationSequence&gt;&lt;workflow&gt;&lt;AlterField&gt;&lt;field_name&gt;county&lt;/field_name&gt;&lt;new_field_name&gt;countyname&lt;/new_field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;clear_field_alias&gt;False&lt;/clear_field_alias&gt;&lt;/AlterField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AlterField&gt;&lt;field_name&gt;acreage&lt;/field_name&gt;&lt;new_field_name&gt;total_acre&lt;/new_field_name&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;clear_field_alias&gt;False&lt;/clear_field_alias&gt;&lt;/AlterField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AlterField&gt;&lt;field_name&gt;road_info&lt;/field_name&gt;&lt;new_field_name&gt;road_comm&lt;/new_field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;clear_field_alias&gt;False&lt;/clear_field_alias&gt;&lt;/AlterField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AlterField&gt;&lt;field_name&gt;comments&lt;/field_name&gt;&lt;new_field_name&gt;user_comm&lt;/new_field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;clear_field_alias&gt;False&lt;/clear_field_alias&gt;&lt;/AlterField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AlterField&gt;&lt;field_name&gt;internal_status&lt;/field_name&gt;&lt;new_field_name&gt;status_in&lt;/new_field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;clear_field_alias&gt;False&lt;/clear_field_alias&gt;&lt;/AlterField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AlterField&gt;&lt;field_name&gt;external_status&lt;/field_name&gt;&lt;new_field_name&gt;status_ex&lt;/new_field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;clear_field_alias&gt;False&lt;/clear_field_alias&gt;&lt;/AlterField&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;</Process>
<Process Date="20241204" Time="180713" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_dev.sde\next_gen_dev.sde.AnnexationSubmissions_DEV &lt;operationSequence&gt;&lt;workflow&gt;&lt;DeleteAttributeRule&gt;&lt;rule_name&gt;annex_dca_id&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DeleteAttributeRule&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;</Process>
<Process Date="20241204" Time="181108" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_dev.sde\next_gen_dev.sde.AnnexationSubmissions_DEV "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_dca_id&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;return Number(NextSequenceValue ('annexations_dca_id_DEV'))&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;True&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;False&lt;/triggering_events_update&gt;&lt;rule_description&gt;Using DB Sequence annexations_dca_id_DEV to calculate the unique dca_id&lt;/rule_description&gt;&lt;field_name&gt;dca_id&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;True&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;0&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_dca_id&lt;/rule_name&gt;&lt;evaluation_order&gt;1&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20241205" Time="150158" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_dev.sde\next_gen_dev.sde.AnnexationSubmissions_DEV "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_status_in&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;return 'Awaiting manual review.'&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;True&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;False&lt;/triggering_events_update&gt;&lt;rule_description&gt;By default, set the internal status to 'Awaiting manual review.'&lt;/rule_description&gt;&lt;field_name&gt;status_in&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;False&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;-1&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_status_in&lt;/rule_name&gt;&lt;evaluation_order&gt;2&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20241217" Time="172734" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_dev.sde\next_gen_dev.sde.AnnexationSubmissions_DEV &lt;operationSequence&gt;&lt;workflow&gt;&lt;DeleteAttributeRule&gt;&lt;rule_name&gt;annex_dca_id&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DeleteAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DeleteAttributeRule&gt;&lt;rule_name&gt;annex_status_in&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DeleteAttributeRule&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;</Process>
<Process Date="20241217" Time="173229" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_dev.sde\next_gen_dev.sde.AnnexationSubmissions_DEV "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_dca_id&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;return Number(NextSequenceValue ('annexations_dca_id_DEV'))&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;True&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;False&lt;/triggering_events_update&gt;&lt;rule_description&gt;Using DB Sequence annexations_dca_id_DEV to calculate the unique dca_id&lt;/rule_description&gt;&lt;field_name&gt;dca_id&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;True&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;0&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_dca_id&lt;/rule_name&gt;&lt;evaluation_order&gt;1&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_status_in&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;return 'Awaiting manual review.'&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;True&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;False&lt;/triggering_events_update&gt;&lt;rule_description&gt;By default, set the internal status to 'Awaiting manual review.'&lt;/rule_description&gt;&lt;field_name&gt;status_in&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;False&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;0&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_status_in&lt;/rule_name&gt;&lt;evaluation_order&gt;2&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20250116" Time="194755" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_dev.sde\next_gen_dev.sde.AnnexationSubmissions_DEV &lt;operationSequence&gt;&lt;workflow&gt;&lt;DeleteAttributeRule&gt;&lt;rule_name&gt;annex_dca_id&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DeleteAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DeleteAttributeRule&gt;&lt;rule_name&gt;annex_status_in&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DeleteAttributeRule&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;</Process>
<Process Date="20250116" Time="195321" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema "CIMDATA=&lt;CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'&gt;&lt;WorkspaceConnectionString&gt;ENCRYPTED_PASSWORD=00022e684a6b6b6b4574473977486734664d50506551754642497a4b415a46666935385649582f6b67484e4f3074386c684d37555646347141626f6f374b36655664336d2a00;SERVER=proddatabase.postgres.database.usgovcloudapi.net;INSTANCE=sde:postgresql:proddatabase.postgres.database.usgovcloudapi.net;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=proddatabase.postgres.database.usgovcloudapi.net;DATABASE=next_gen_dev;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS&lt;/WorkspaceConnectionString&gt;&lt;WorkspaceFactory&gt;SDE&lt;/WorkspaceFactory&gt;&lt;Dataset&gt;next_gen_dev.sde.AnnexationSubmissions_DEV&lt;/Dataset&gt;&lt;DatasetType&gt;esriDTFeatureClass&lt;/DatasetType&gt;&lt;/CIMStandardDataConnection&gt;" "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;last_approved_user&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_precision&gt;0&lt;/field_precision&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;field_alias&gt;Last Approved By&lt;/field_alias&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;field_is_required&gt;False&lt;/field_is_required&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20250116" Time="200310" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_dev.sde\next_gen_dev.sde.AnnexationSubmissions_DEV "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_dca_id&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;return Number(NextSequenceValue ('annexations_dca_id_DEV'))&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;True&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;False&lt;/triggering_events_update&gt;&lt;rule_description&gt;Using DB Sequence annexations_dca_id_DEV to calculate the unique dca_id&lt;/rule_description&gt;&lt;field_name&gt;dca_id&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;True&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;0&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_dca_id&lt;/rule_name&gt;&lt;evaluation_order&gt;1&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_status_in&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;return 'Awaiting manual review.'&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;True&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;False&lt;/triggering_events_update&gt;&lt;rule_description&gt;By default, set the internal status to 'Awaiting manual review.'&lt;/rule_description&gt;&lt;field_name&gt;status_in&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;False&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;0&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_status_in&lt;/rule_name&gt;&lt;evaluation_order&gt;2&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20250116" Time="214954" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema "CIMDATA=&lt;CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'&gt;&lt;WorkspaceConnectionString&gt;ENCRYPTED_PASSWORD=00022e684a6b6b6b4574473977486734664d50506551754642497a4b415a46666935385649582f6b67484e4f3074386c684d37555646347141626f6f374b36655664336d2a00;SERVER=proddatabase.postgres.database.usgovcloudapi.net;INSTANCE=sde:postgresql:proddatabase.postgres.database.usgovcloudapi.net;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=proddatabase.postgres.database.usgovcloudapi.net;DATABASE=next_gen_dev;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS&lt;/WorkspaceConnectionString&gt;&lt;WorkspaceFactory&gt;SDE&lt;/WorkspaceFactory&gt;&lt;Dataset&gt;next_gen_dev.sde.AnnexationSubmissions_DEV&lt;/Dataset&gt;&lt;DatasetType&gt;esriDTFeatureClass&lt;/DatasetType&gt;&lt;/CIMStandardDataConnection&gt;" &lt;operationSequence&gt;&lt;workflow&gt;&lt;AssignDomainToField&gt;&lt;field_name&gt;prg_comm&lt;/field_name&gt;&lt;domain_name&gt;AnnexSub_prgComments&lt;/domain_name&gt;&lt;/AssignDomainToField&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;</Process>
<Process Date="20250123" Time="185218" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema "CIMDATA=&lt;CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'&gt;&lt;WorkspaceConnectionString&gt;ENCRYPTED_PASSWORD=00022e684a6b6b6b4574473977486734664d50506551754642497a4b415a46666935385649582f6b67484e4f3074386c684d37555646347141626f6f374b36655664336d2a00;SERVER=proddatabase.postgres.database.usgovcloudapi.net;INSTANCE=sde:postgresql:proddatabase.postgres.database.usgovcloudapi.net;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=proddatabase.postgres.database.usgovcloudapi.net;DATABASE=next_gen_dev;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS&lt;/WorkspaceConnectionString&gt;&lt;WorkspaceFactory&gt;SDE&lt;/WorkspaceFactory&gt;&lt;Dataset&gt;next_gen_dev.sde.AnnexationSubmissions_DEV&lt;/Dataset&gt;&lt;DatasetType&gt;esriDTFeatureClass&lt;/DatasetType&gt;&lt;/CIMStandardDataConnection&gt;" "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AlterField&gt;&lt;field_name&gt;user_comm&lt;/field_name&gt;&lt;field_alias&gt;User Comments&lt;/field_alias&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;clear_field_alias&gt;False&lt;/clear_field_alias&gt;&lt;/AlterField&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20250123" Time="185438" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema "CIMDATA=&lt;CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'&gt;&lt;WorkspaceConnectionString&gt;ENCRYPTED_PASSWORD=00022e684a6b6b6b4574473977486734664d50506551754642497a4b415a46666935385649582f6b67484e4f3074386c684d37555646347141626f6f374b36655664336d2a00;SERVER=proddatabase.postgres.database.usgovcloudapi.net;INSTANCE=sde:postgresql:proddatabase.postgres.database.usgovcloudapi.net;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=proddatabase.postgres.database.usgovcloudapi.net;DATABASE=next_gen_dev;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS&lt;/WorkspaceConnectionString&gt;&lt;WorkspaceFactory&gt;SDE&lt;/WorkspaceFactory&gt;&lt;Dataset&gt;next_gen_dev.sde.AnnexationSubmissions_DEV&lt;/Dataset&gt;&lt;DatasetType&gt;esriDTFeatureClass&lt;/DatasetType&gt;&lt;/CIMStandardDataConnection&gt;" "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AlterField&gt;&lt;field_name&gt;last_edited_user&lt;/field_name&gt;&lt;field_alias&gt;Last Edited User&lt;/field_alias&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;clear_field_alias&gt;False&lt;/clear_field_alias&gt;&lt;/AlterField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AlterField&gt;&lt;field_name&gt;last_edited_date&lt;/field_name&gt;&lt;field_alias&gt;Last Edited Date&lt;/field_alias&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;clear_field_alias&gt;False&lt;/clear_field_alias&gt;&lt;/AlterField&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20250123" Time="190629" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema "CIMDATA=&lt;CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'&gt;&lt;WorkspaceConnectionString&gt;ENCRYPTED_PASSWORD=00022e684a6b6b6b4574473977486734664d50506551754642497a4b415a46666935385649582f6b67484e4f3074386c684d37555646347141626f6f374b36655664336d2a00;SERVER=proddatabase.postgres.database.usgovcloudapi.net;INSTANCE=sde:postgresql:proddatabase.postgres.database.usgovcloudapi.net;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=proddatabase.postgres.database.usgovcloudapi.net;DATABASE=next_gen_dev;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS&lt;/WorkspaceConnectionString&gt;&lt;WorkspaceFactory&gt;SDE&lt;/WorkspaceFactory&gt;&lt;Dataset&gt;next_gen_dev.sde.AnnexationSubmissions_DEV&lt;/Dataset&gt;&lt;DatasetType&gt;esriDTFeatureClass&lt;/DatasetType&gt;&lt;/CIMStandardDataConnection&gt;" "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AlterField&gt;&lt;field_name&gt;created_user&lt;/field_name&gt;&lt;field_alias&gt;Created By&lt;/field_alias&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;clear_field_alias&gt;False&lt;/clear_field_alias&gt;&lt;/AlterField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AlterField&gt;&lt;field_name&gt;created_date&lt;/field_name&gt;&lt;field_alias&gt;Created Date&lt;/field_alias&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;clear_field_alias&gt;False&lt;/clear_field_alias&gt;&lt;/AlterField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AlterField&gt;&lt;field_name&gt;job_id&lt;/field_name&gt;&lt;field_alias&gt;Job ID 1Data Gateway&lt;/field_alias&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;clear_field_alias&gt;False&lt;/clear_field_alias&gt;&lt;/AlterField&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20250124" Time="165825" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_dev.sde\next_gen_dev.sde.AnnexationSubmissions_DEV "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_effective_date&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;// Input date field
var inputDate = $feature.auth_date
// Check if inputDate is not null
if (IsEmpty(inputDate)) {
    return null
}
// Extract year and month
var year = Year(inputDate)
var month = Month(inputDate)
// Determine next month's year and month
if (month == 12) {
    year += 1
    month = 1
} else {
    month += 1
}
// Return the first day of the next month
return Date(year, month, 1)
&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;True&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;False&lt;/triggering_events_update&gt;&lt;rule_description&gt;Auto calculate Effective Date based on Authorization Date value&lt;/rule_description&gt;&lt;field_name&gt;eff_date&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;False&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;-1&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_effective_date&lt;/rule_name&gt;&lt;evaluation_order&gt;3&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20250124" Time="170022" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_dev.sde\next_gen_dev.sde.AnnexationSubmissions_DEV &lt;operationSequence&gt;&lt;workflow&gt;&lt;DeleteAttributeRule&gt;&lt;rule_name&gt;annex_dca_id&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DeleteAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DeleteAttributeRule&gt;&lt;rule_name&gt;annex_status_in&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DeleteAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DeleteAttributeRule&gt;&lt;rule_name&gt;annex_effective_date&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DeleteAttributeRule&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;</Process>
<Process Date="20250124" Time="170716" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_dev.sde\next_gen_dev.sde.AnnexationSubmissions_DEV "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_dca_id&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;return Number(NextSequenceValue ('annexations_dca_id_DEV'))&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;True&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;False&lt;/triggering_events_update&gt;&lt;rule_description&gt;Using DB Sequence annexations_dca_id_DEV to calculate the unique dca_id&lt;/rule_description&gt;&lt;field_name&gt;dca_id&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;True&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;0&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_dca_id&lt;/rule_name&gt;&lt;evaluation_order&gt;1&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_status_in&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;return 'Awaiting manual review.'&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;True&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;False&lt;/triggering_events_update&gt;&lt;rule_description&gt;By default, set the internal status to 'Awaiting manual review.'&lt;/rule_description&gt;&lt;field_name&gt;status_in&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;False&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;0&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_status_in&lt;/rule_name&gt;&lt;evaluation_order&gt;2&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_effective_date&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;// Input date field
var inputDate = $feature.auth_date
// Check if inputDate is not null
if (IsEmpty(inputDate)) {
    return null
}
// Extract year and month
var year = Year(inputDate)
var month = Month(inputDate)
// Determine next month's year and month
if (month == 12) {
    year += 1
    month = 1
} else {
    month += 1
}
// Return the first day of the next month
return Date(year, month, 1)&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;True&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;False&lt;/triggering_events_update&gt;&lt;rule_description&gt;Auto calculate Effective Date based on Authorization Date value&lt;/rule_description&gt;&lt;field_name&gt;eff_date&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;False&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;0&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_effective_date&lt;/rule_name&gt;&lt;evaluation_order&gt;3&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20250128" Time="151526" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_dev.sde\next_gen_dev.sde.AnnexationSubmissions_DEV "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AlterAttributeRule&gt;&lt;rule_name&gt;annex_effective_date&lt;/rule_name&gt;&lt;rule_description&gt;Auto calculate Effective Date based on Authorization Date value&lt;/rule_description&gt;&lt;exclude_from_client_eval&gt;False&lt;/exclude_from_client_eval&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;expression&gt;// Input date field
var inputDate = $feature.auth_date
// Check if inputDate is not null
if (IsEmpty(inputDate)) {
    return null
}
// Extract year and month
var year = Year(inputDate)
var month = Month(inputDate)
// Determine next month's year and month
if (month == 12) {
    year += 1
    month = 1
} else {
    month += 1
}
// Return the first day of the next month
return Date(year, month, 1)&lt;/expression&gt;&lt;category&gt;0&lt;/category&gt;&lt;triggering_events_insert&gt;False&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;True&lt;/triggering_events_update&gt;&lt;/AlterAttributeRule&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20250128" Time="182557" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema "CIMDATA=&lt;CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'&gt;&lt;WorkspaceConnectionString&gt;ENCRYPTED_PASSWORD=00022e684a6b6b6b4574473977486734664d50506551754642497a4b415a46666935385649582f6b67484e4f3074386c684d37555646347141626f6f374b36655664336d2a00;SERVER=proddatabase.postgres.database.usgovcloudapi.net;INSTANCE=sde:postgresql:proddatabase.postgres.database.usgovcloudapi.net;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=proddatabase.postgres.database.usgovcloudapi.net;DATABASE=next_gen_dev;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS&lt;/WorkspaceConnectionString&gt;&lt;WorkspaceFactory&gt;SDE&lt;/WorkspaceFactory&gt;&lt;Dataset&gt;next_gen_dev.sde.AnnexationSubmissions_DEV&lt;/Dataset&gt;&lt;DatasetType&gt;esriDTFeatureClass&lt;/DatasetType&gt;&lt;/CIMStandardDataConnection&gt;" "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;dca_id_label&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_precision&gt;0&lt;/field_precision&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;field_alias&gt;DCA ID Label&lt;/field_alias&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;field_is_required&gt;False&lt;/field_is_required&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddField&gt;&lt;field_name&gt;eff_date_label&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_precision&gt;0&lt;/field_precision&gt;&lt;field_length&gt;255&lt;/field_length&gt;&lt;field_alias&gt;Effective Date Label&lt;/field_alias&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;field_is_required&gt;False&lt;/field_is_required&gt;&lt;/AddField&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20250128" Time="182901" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_dev.sde\next_gen_dev.sde.AnnexationSubmissions_DEV "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_dca_id_label&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;Text($feature.dca_id)&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;True&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;False&lt;/triggering_events_update&gt;&lt;rule_description&gt;Text format DCA ID for Manager App&lt;/rule_description&gt;&lt;field_name&gt;dca_id_label&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;False&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;-1&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_dca_id_label&lt;/rule_name&gt;&lt;evaluation_order&gt;4&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_effective_date_label&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;Text($feature.eff_date)&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;False&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;True&lt;/triggering_events_update&gt;&lt;rule_description&gt;Text format eff_date for Python scripts and all apps&lt;/rule_description&gt;&lt;field_name&gt;eff_date_label&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;False&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;-1&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_effective_date_label&lt;/rule_name&gt;&lt;evaluation_order&gt;5&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20250129" Time="171732" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_dev.sde\next_gen_dev.sde.AnnexationSubmissions_DEV "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AlterAttributeRule&gt;&lt;rule_name&gt;annex_effective_date_label&lt;/rule_name&gt;&lt;rule_description&gt;Text format eff_date for Python scripts and all apps&lt;/rule_description&gt;&lt;exclude_from_client_eval&gt;False&lt;/exclude_from_client_eval&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;expression&gt;// Input date field
var inputDate =$feature.eff_date
// Check if inputDate is not null
if (IsEmpty(inputDate)) {
    return null
}
// Extract year and month
var year = Year(inputDate)
var month = Month(inputDate)
var day = Day(inputDate)
// Return the Effective Date in Text format
return Text(month + "/" + day + "/" + year)&lt;/expression&gt;&lt;category&gt;4294967295&lt;/category&gt;&lt;triggering_events_insert&gt;False&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;True&lt;/triggering_events_update&gt;&lt;/AlterAttributeRule&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20250129" Time="172417" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_dev.sde\next_gen_dev.sde.AnnexationSubmissions_DEV "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AlterAttributeRule&gt;&lt;rule_name&gt;annex_effective_date_label&lt;/rule_name&gt;&lt;rule_description&gt;Text format eff_date for Python scripts and all apps&lt;/rule_description&gt;&lt;exclude_from_client_eval&gt;False&lt;/exclude_from_client_eval&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;expression&gt;// Input date field
var inputDate =$feature.auth_date
// Check if inputDate is not null
if (IsEmpty(inputDate)) {
    return null
}
// Extract year and month
var year = Year(inputDate)
var month = Month(inputDate)
var day = Day(inputDate)
// Return the Effective Date in Text format
return Text(month + "/" + day + "/" + year)&lt;/expression&gt;&lt;category&gt;4294967295&lt;/category&gt;&lt;triggering_events_insert&gt;False&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;True&lt;/triggering_events_update&gt;&lt;/AlterAttributeRule&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20250129" Time="172854" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_dev.sde\next_gen_dev.sde.AnnexationSubmissions_DEV "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AlterAttributeRule&gt;&lt;rule_name&gt;annex_effective_date_label&lt;/rule_name&gt;&lt;rule_description&gt;Text format eff_date for Python scripts and all apps&lt;/rule_description&gt;&lt;exclude_from_client_eval&gt;False&lt;/exclude_from_client_eval&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;expression&gt;// Input date field
var inputDate =$feature.eff_date
// Check if inputDate is not null
if (IsEmpty(inputDate)) {
    return null
}
// Extract year and month
var year = Year(inputDate)
var month = Month(inputDate)
var actual_month = (month +1)
var day = Day(inputDate)
// Return the Effective Date in Text format
return Text(actual_month + "/" + day + "/" + year)&lt;/expression&gt;&lt;category&gt;4294967295&lt;/category&gt;&lt;triggering_events_insert&gt;False&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;True&lt;/triggering_events_update&gt;&lt;/AlterAttributeRule&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20250131" Time="190112" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema "CIMDATA=&lt;CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'&gt;&lt;WorkspaceConnectionString&gt;ENCRYPTED_PASSWORD=00022e684a6b6b6b4574473977486734664d50506551754642497a4b415a46666935385649582f6b67484e4f3074386c684d37555646347141626f6f374b36655664336d2a00;SERVER=proddatabase.postgres.database.usgovcloudapi.net;INSTANCE=sde:postgresql:proddatabase.postgres.database.usgovcloudapi.net;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=proddatabase.postgres.database.usgovcloudapi.net;DATABASE=next_gen_dev;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS&lt;/WorkspaceConnectionString&gt;&lt;WorkspaceFactory&gt;SDE&lt;/WorkspaceFactory&gt;&lt;Dataset&gt;next_gen_dev.sde.AnnexationSubmissions_DEV&lt;/Dataset&gt;&lt;DatasetType&gt;esriDTFeatureClass&lt;/DatasetType&gt;&lt;/CIMStandardDataConnection&gt;" "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AlterField&gt;&lt;field_name&gt;dca_id&lt;/field_name&gt;&lt;field_alias&gt;DCA ID INT&lt;/field_alias&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;clear_field_alias&gt;False&lt;/clear_field_alias&gt;&lt;/AlterField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AlterField&gt;&lt;field_name&gt;eff_date&lt;/field_name&gt;&lt;field_alias&gt;Effective Date Original&lt;/field_alias&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;clear_field_alias&gt;False&lt;/clear_field_alias&gt;&lt;/AlterField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AlterField&gt;&lt;field_name&gt;dca_id_label&lt;/field_name&gt;&lt;field_alias&gt;DCA ID&lt;/field_alias&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;clear_field_alias&gt;False&lt;/clear_field_alias&gt;&lt;/AlterField&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AlterField&gt;&lt;field_name&gt;eff_date_label&lt;/field_name&gt;&lt;field_alias&gt;Effective Date&lt;/field_alias&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_is_nullable&gt;True&lt;/field_is_nullable&gt;&lt;clear_field_alias&gt;False&lt;/clear_field_alias&gt;&lt;/AlterField&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20250131" Time="191246" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_dev.sde\next_gen_dev.sde.AnnexationSubmissions_DEV &lt;operationSequence&gt;&lt;workflow&gt;&lt;DeleteAttributeRule&gt;&lt;rule_name&gt;annex_dca_id&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DeleteAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DeleteAttributeRule&gt;&lt;rule_name&gt;annex_status_in&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DeleteAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DeleteAttributeRule&gt;&lt;rule_name&gt;annex_effective_date&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DeleteAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DeleteAttributeRule&gt;&lt;rule_name&gt;annex_dca_id_label&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DeleteAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DeleteAttributeRule&gt;&lt;rule_name&gt;annex_effective_date_label&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DeleteAttributeRule&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;</Process>
<Process Date="20250131" Time="192407" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_dev.sde\next_gen_dev.sde.AnnexationSubmissions_DEV "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_dca_id&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;return Number(NextSequenceValue ('annexations_dca_id_DEV'))&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;True&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;False&lt;/triggering_events_update&gt;&lt;rule_description&gt;Using DB Sequence annexations_dca_id_DEV to calculate the unique dca_id&lt;/rule_description&gt;&lt;field_name&gt;dca_id&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;True&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;0&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_dca_id&lt;/rule_name&gt;&lt;evaluation_order&gt;1&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_status_in&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;return 'Awaiting manual review.'&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;True&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;False&lt;/triggering_events_update&gt;&lt;rule_description&gt;By default, set the internal status to 'Awaiting manual review.'&lt;/rule_description&gt;&lt;field_name&gt;status_in&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;False&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;0&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_status_in&lt;/rule_name&gt;&lt;evaluation_order&gt;2&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_effective_date&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;// Input date field
var inputDate = $feature.auth_date
// Check if inputDate is not null
if (IsEmpty(inputDate)) {
    return null
}
// Extract year and month
var year = Year(inputDate)
var month = Month(inputDate)
// Determine next month's year and month
if (month == 12) {
    year += 1
    month = 1
} else {
    month += 1
}
// Return the first day of the next month
return Date(year, month, 1)&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;False&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;True&lt;/triggering_events_update&gt;&lt;rule_description&gt;Auto calculate Effective Date based on Authorization Date value&lt;/rule_description&gt;&lt;field_name&gt;eff_date&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;False&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;0&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_effective_date&lt;/rule_name&gt;&lt;evaluation_order&gt;3&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_dca_id_label&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;Text($feature.dca_id)&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;True&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;False&lt;/triggering_events_update&gt;&lt;rule_description&gt;Text format DCA ID for Manager App&lt;/rule_description&gt;&lt;field_name&gt;dca_id_label&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;False&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;0&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_dca_id_label&lt;/rule_name&gt;&lt;evaluation_order&gt;4&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_effective_date_label&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;// Input date field
var inputDate =$feature.eff_date
// Check if inputDate is not null
if (IsEmpty(inputDate)) {
    return null
}
// Extract year and month
var year = Year(inputDate)
var month = Month(inputDate)
var actual_month = (month +1)
var day = Day(inputDate)
// Return the Effective Date in Text format
return Text(actual_month + "/" + day + "/" + year)&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;False&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;True&lt;/triggering_events_update&gt;&lt;rule_description&gt;Text format eff_date for Python scripts and all apps&lt;/rule_description&gt;&lt;field_name&gt;eff_date_label&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;False&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;0&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_effective_date_label&lt;/rule_name&gt;&lt;evaluation_order&gt;5&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20250325" Time="160733" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_dev.sde\next_gen_dev.sde.AnnexationSubmissions_DEV &lt;operationSequence&gt;&lt;workflow&gt;&lt;DeleteAttributeRule&gt;&lt;rule_name&gt;annex_dca_id&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DeleteAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DeleteAttributeRule&gt;&lt;rule_name&gt;annex_status_in&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DeleteAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DeleteAttributeRule&gt;&lt;rule_name&gt;annex_effective_date&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DeleteAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DeleteAttributeRule&gt;&lt;rule_name&gt;annex_dca_id_label&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DeleteAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DeleteAttributeRule&gt;&lt;rule_name&gt;annex_effective_date_label&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DeleteAttributeRule&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;</Process>
<Process Date="20250325" Time="161146" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_dev.sde\next_gen_dev.sde.AnnexationSubmissions_DEV "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_dca_id&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;return Number(NextSequenceValue ('annexations_dca_id_DEV'))&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;True&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;False&lt;/triggering_events_update&gt;&lt;rule_description&gt;Using DB Sequence annexations_dca_id_DEV to calculate the unique dca_id&lt;/rule_description&gt;&lt;field_name&gt;dca_id&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;True&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;0&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_dca_id&lt;/rule_name&gt;&lt;evaluation_order&gt;1&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_status_in&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;return 'Awaiting manual review.'&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;True&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;False&lt;/triggering_events_update&gt;&lt;rule_description&gt;By default, set the internal status to 'Awaiting manual review.'&lt;/rule_description&gt;&lt;field_name&gt;status_in&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;False&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;0&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_status_in&lt;/rule_name&gt;&lt;evaluation_order&gt;2&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_effective_date&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;// Input date field
var inputDate = $feature.auth_date
// Check if inputDate is not null
if (IsEmpty(inputDate)) {
    return null
}
// Extract year and month
var year = Year(inputDate)
var month = Month(inputDate)
// Determine next month's year and month
if (month == 12) {
    year += 1
    month = 1
} else {
    month += 1
}
// Return the first day of the next month
return Date(year, month, 1)&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;False&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;True&lt;/triggering_events_update&gt;&lt;rule_description&gt;Auto calculate Effective Date based on Authorization Date value&lt;/rule_description&gt;&lt;field_name&gt;eff_date&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;False&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;0&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_effective_date&lt;/rule_name&gt;&lt;evaluation_order&gt;3&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_dca_id_label&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;Text($feature.dca_id)&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;True&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;False&lt;/triggering_events_update&gt;&lt;rule_description&gt;Text format DCA ID for Manager App&lt;/rule_description&gt;&lt;field_name&gt;dca_id_label&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;False&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;0&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_dca_id_label&lt;/rule_name&gt;&lt;evaluation_order&gt;4&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_effective_date_label&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;// Input date field
var inputDate =$feature.eff_date
// Check if inputDate is not null
if (IsEmpty(inputDate)) {
    return null
}
// Extract year and month
var year = Year(inputDate)
var month = Month(inputDate)
var actual_month = (month +1)
var day = Day(inputDate)
// Return the Effective Date in Text format
return Text(actual_month + "/" + day + "/" + year)&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;False&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;True&lt;/triggering_events_update&gt;&lt;rule_description&gt;Text format eff_date for Python scripts and all apps&lt;/rule_description&gt;&lt;field_name&gt;eff_date_label&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;False&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;0&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_effective_date_label&lt;/rule_name&gt;&lt;evaluation_order&gt;5&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20250404" Time="185933" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_dev.sde\next_gen_dev.sde.AnnexationSubmissions_DEV &lt;operationSequence&gt;&lt;workflow&gt;&lt;DeleteAttributeRule&gt;&lt;rule_name&gt;annex_dca_id&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DeleteAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DeleteAttributeRule&gt;&lt;rule_name&gt;annex_status_in&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DeleteAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DeleteAttributeRule&gt;&lt;rule_name&gt;annex_effective_date&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DeleteAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DeleteAttributeRule&gt;&lt;rule_name&gt;annex_dca_id_label&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DeleteAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DeleteAttributeRule&gt;&lt;rule_name&gt;annex_effective_date_label&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DeleteAttributeRule&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;</Process>
<Process Date="20250404" Time="190752" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_dev.sde\next_gen_dev.sde.AnnexationSubmissions_DEV "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_dca_id&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;return Number(NextSequenceValue ('annexations_dca_id_DEV'))&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;True&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;False&lt;/triggering_events_update&gt;&lt;rule_description&gt;Using DB Sequence annexations_dca_id_DEV to calculate the unique dca_id&lt;/rule_description&gt;&lt;field_name&gt;dca_id&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;True&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;0&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_dca_id&lt;/rule_name&gt;&lt;evaluation_order&gt;1&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_status_in&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;return 'Awaiting manual review.'&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;True&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;False&lt;/triggering_events_update&gt;&lt;rule_description&gt;By default, set the internal status to 'Awaiting manual review.'&lt;/rule_description&gt;&lt;field_name&gt;status_in&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;False&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;0&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_status_in&lt;/rule_name&gt;&lt;evaluation_order&gt;2&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_effective_date&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;// Input date field
var inputDate = $feature.auth_date
// Check if inputDate is not null
if (IsEmpty(inputDate)) {
    return null
}
// Extract year and month
var year = Year(inputDate)
var month = Month(inputDate)
// Determine next month's year and month
if (month == 12) {
    year += 1
    month = 1
} else {
    month += 1
}
// Return the first day of the next month
return Date(year, month, 1)&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;False&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;True&lt;/triggering_events_update&gt;&lt;rule_description&gt;Auto calculate Effective Date based on Authorization Date value&lt;/rule_description&gt;&lt;field_name&gt;eff_date&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;False&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;0&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_effective_date&lt;/rule_name&gt;&lt;evaluation_order&gt;3&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_dca_id_label&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;Text($feature.dca_id)&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;True&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;False&lt;/triggering_events_update&gt;&lt;rule_description&gt;Text format DCA ID for Manager App&lt;/rule_description&gt;&lt;field_name&gt;dca_id_label&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;False&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;0&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_dca_id_label&lt;/rule_name&gt;&lt;evaluation_order&gt;4&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_effective_date_label&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;// Input date field
var inputDate =$feature.eff_date
// Check if inputDate is not null
if (IsEmpty(inputDate)) {
    return null
}
// Extract year and month
var year = Year(inputDate)
var month = Month(inputDate)
var actual_month = (month +1)
var day = Day(inputDate)
// Return the Effective Date in Text format
return Text(actual_month + "/" + day + "/" + year)&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;False&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;True&lt;/triggering_events_update&gt;&lt;rule_description&gt;Text format eff_date for Python scripts and all apps&lt;/rule_description&gt;&lt;field_name&gt;eff_date_label&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;False&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;0&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_effective_date_label&lt;/rule_name&gt;&lt;evaluation_order&gt;5&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20250414" Time="125616" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_dev.sde\next_gen_dev.sde.AnnexationSubmissions_DEV &lt;operationSequence&gt;&lt;workflow&gt;&lt;DeleteAttributeRule&gt;&lt;rule_name&gt;annex_dca_id&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DeleteAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DeleteAttributeRule&gt;&lt;rule_name&gt;annex_status_in&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DeleteAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DeleteAttributeRule&gt;&lt;rule_name&gt;annex_effective_date&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DeleteAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DeleteAttributeRule&gt;&lt;rule_name&gt;annex_dca_id_label&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DeleteAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DeleteAttributeRule&gt;&lt;rule_name&gt;annex_effective_date_label&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DeleteAttributeRule&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;</Process>
<Process Date="20250414" Time="131148" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_dev.sde\next_gen_dev.sde.AnnexationSubmissions_DEV "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_dca_id&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;return Number(NextSequenceValue ('annexations_dca_id_DEV'))&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;True&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;False&lt;/triggering_events_update&gt;&lt;rule_description&gt;Using DB Sequence annexations_dca_id_DEV to calculate the unique dca_id&lt;/rule_description&gt;&lt;field_name&gt;dca_id&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;True&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;0&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_dca_id&lt;/rule_name&gt;&lt;evaluation_order&gt;1&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_status_in&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;return 'Awaiting manual review.'&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;True&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;False&lt;/triggering_events_update&gt;&lt;rule_description&gt;By default, set the internal status to 'Awaiting manual review.'&lt;/rule_description&gt;&lt;field_name&gt;status_in&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;False&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;0&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_status_in&lt;/rule_name&gt;&lt;evaluation_order&gt;2&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_effective_date&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;// Input date field
var inputDate = $feature.auth_date
// Check if inputDate is not null
if (IsEmpty(inputDate)) {
    return null
}
// Extract year and month
var year = Year(inputDate)
var month = Month(inputDate)
// Determine next month's year and month
if (month == 12) {
    year += 1
    month = 1
} else {
    month += 1
}
// Return the first day of the next month
return Date(year, month, 1)&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;False&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;True&lt;/triggering_events_update&gt;&lt;rule_description&gt;Auto calculate Effective Date based on Authorization Date value&lt;/rule_description&gt;&lt;field_name&gt;eff_date&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;False&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;0&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_effective_date&lt;/rule_name&gt;&lt;evaluation_order&gt;3&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_dca_id_label&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;Text($feature.dca_id)&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;True&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;False&lt;/triggering_events_update&gt;&lt;rule_description&gt;Text format DCA ID for Manager App&lt;/rule_description&gt;&lt;field_name&gt;dca_id_label&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;False&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;0&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_dca_id_label&lt;/rule_name&gt;&lt;evaluation_order&gt;4&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AddAttributeRule&gt;&lt;rule_name&gt;annex_effective_date_label&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;expression&gt;// Input date field
var inputDate =$feature.eff_date
// Check if inputDate is not null
if (IsEmpty(inputDate)) {
    return null
}
// Extract year and month
var year = Year(inputDate)
var month = Month(inputDate)
var actual_month = (month +1)
var day = Day(inputDate)
// Return the Effective Date in Text format
return Text(actual_month + "/" + day + "/" + year)&lt;/expression&gt;&lt;is_editable&gt;True&lt;/is_editable&gt;&lt;triggering_events_insert&gt;False&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;True&lt;/triggering_events_update&gt;&lt;rule_description&gt;Text format eff_date for Python scripts and all apps&lt;/rule_description&gt;&lt;field_name&gt;eff_date_label&lt;/field_name&gt;&lt;exclude_from_client_eval&gt;False&lt;/exclude_from_client_eval&gt;&lt;batch&gt;False&lt;/batch&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;category&gt;0&lt;/category&gt;&lt;/AddAttributeRule&gt;&lt;ReorderAttributeRule&gt;&lt;rule_name&gt;annex_effective_date_label&lt;/rule_name&gt;&lt;evaluation_order&gt;5&lt;/evaluation_order&gt;&lt;/ReorderAttributeRule&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
</lineage>
</DataProperties>
</Esri>
<dataIdInfo>
<idAbs/>
<searchKeys>
<keyword>annexations</keyword>
</searchKeys>
<idPurp>Annexations Submissions layer used for s123 intake - DEV</idPurp>
<idCredit/>
<resConst>
<Consts>
<useLimit/>
</Consts>
</resConst>
<idCitation>
<resTitle>AnnexationSubmissions_survey_DEV</resTitle>
</idCitation>
</dataIdInfo>
<Binary>
<Thumbnail>
<Data EsriPropertyType="PictureX">/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3i5/1
LVjyrWxcf6hqzOC4BroouyOPEL3iuUYDOOKYThSRjp3q/IMjbVWZVGFA7c1vGVznlGxVDvgfPF09
alU5AJwfpSeWn90flTlAyABxVEkyqCQcVZVcCiKPgYHNSHGMZ5rGUtbG8YaXE6e9OG1otuDx3po6
beAPehskYB4PpWUlc1i0h8exQW4OBz7U3d5pBJ+WlBZEIZRn1xRE4ib7u5jUpdTRvRIuQ58sZGKf
2pqnKg4x7U7tWbNVsKaSg0UDIbjhAenNQHhcDv70+7ySgGMZ5qEtkYNawWhz1HqVJBiQkdanjbK5
wOOxqvM2JKkhIJwTjNbyXunNF+8TnLOA2QOnHan9DgE47Z600A7cdSDmnkZxk49awXmdD8hrMWGM
Uwpg5z1qRxxgDio6tGb3HJFt5HApD1p+GKACmFSDihDZMDuWmFSqkKMmnICF5FLnnHepLGMcDJOd
3Wqk8XGRV7gnIwT0pmN2Rx1pwlykzjzGWVIqPyn5xI3Jz0rSe3OeKI7bJy/T0rf2isYezd7Fe1hk
A5Yt9at/Z+uTUyqFGAMUtYubbNo00lqU3gK1CRitEjIxVd0GSCOaqM+5E6dtiSy++30q/VGyGJG+
lXq5qu51UfhIrgboWArPEXzZPNaUhAjJNQVpTlZE1YpspvncD2qpI25ya05IhIpHSs+SB4z0yK3p
yTOWpFoiqWBQX5qNVJNWYY8MD2q5PQiKuyfJA4OBTgAfb196mBUJng80xoyBlcEVyuSudii0u4xk
JORyPSjaCo3HBH5U7Z1Bxj1NInzhFIHuaAQxhtIKtnJ5o3bTnPNOKHZuCknJ6dqhc5BHccGqhZ6E
TutSxHM4OS5Ye9XAQygg5B6VlxNkY9KuWbfuhGx+ZeMe1TUjYujNvRlo0UtMc7UJzisjoKt2q70Y
gkjoRVWeUR9OpqQs+4+YwJ6iq0g3Hmummu5xVZa6EO7cfmqRD0NJsUU5ccelbM50Xojlc5pHOTgU
xT8vHSisLanRfQeVyMhs0IMnnoKZTwCoJND0GtWKz845+lOVTnJpqphzntTyD1Bxjk1BpuBzjjrQ
n7zO04A4zSLknkcd6lRFTO0Yz1qZOxUY3GxQrH3Jz60ShdhzwakpjIGOSSfaovrqaWsrIaOlFK0e
ejYFNxsOOce9aKSZk4tCNn1OfTFLz3FJwzbR160ob1BH1piFprIG+tOooC1wt0KyMT6VaqGL7x+l
TVEndmtNWQ2X/Vmq9WJc+Wcdaqk/PxnnrmnEUxyru5PT0pxjX6VGp2nJJ6ZximNvJ781E5NMFawr
xLuAAB/SmgsTtACKOp6mgfeAJx704xnqCCaXtZMXIt0hfJYDO4GlEqR8MxBHY1H5kmRg8fyqwVWS
PkDmq577go2+EgaXc27GF96XLEK20benH86sYGMYprFVTAx9KfMPk7sgLSjAUgDr0pJAJEMqj516
inBihO88dvano25H2cN71W2pK10Kq435XoalgI+2YA5xzzUKgl2YjHqPerEDL9p56sOKuTujKCtI
v1BM6bSjOVJ9KLiYxKAuNx6Zqk0u5/mOWPpWcYN6m1Soo6CNjoMkDgZpmcVMqlnIGAuM5pkijBI/
/XW0ZLY5pRduYpkliRTo0fOMUiA78+9Ws7V46ngVrKVjKMbsjjLvlVOFBwxxz+FTiIbgI+v+13p2
0JGFX/8AXRhlCnpnjiuKVSTd1sdsYJKxIBjG4YOKCw6YyKYm5vlycjrkU4SbOcU3UtuCiKqnI2gg
H1pwBG8EdqQT9OKeAXXk4zUqfMUopbAhDA4GDThQBjoKYZFV8Hr1pNl7Di2BzSbg44yKaXDYGOKk
ACjgUr3AhDMrVKR93I561GMbiS2T6VJkNg9+9KIkKSAQKQnJ2kUMM4IqMglsdqbuUObbng4NJtbd
jjFPAGBkUvU1SkyeVMVFIc59KmqGJgXI5yKmoGklsRysFjJNVyATyKde/wDHs9ULe5YfKwyPWtYR
bjdGFWaUrMuLgnLHHPfvSTPsYbRkgZxnvUck6YGMY9SaqyXHzsUJORjJpqk5MTqqKLBcNgnr3HpU
inau8Hdg9qzFYq2Qant5GhlIGCj+p6GlUw6iroUK/M7MsgkkkflSqWBBLEAdgadG+6Qll7dqcI84
PbNcq8jexKsgb2ph+aQk444FHlqG+9jA6UwthsZGRVxly/EErtCuo2mklhC4IPXjmhnyOPXvU4w6
DPPrWrltYiMU7lBsrEcevWo4bkxyAjt61buUA+bgKRg1nyxmM57HpW9NqSszmqKUJXRZuLjzW34K
4GOtRJyc1CCWIBNSlgBWijyqyIc3J3ZIZCeBmnoT3NQRsM8mplO5sgHGO1RJWHF3JFiBbp2qNXC7
nZRuzhc9qnhBCDPWmTLz8q7vUAVjJuSsbpcuom5d5YqWPBp0khaUFcge4pVjIUkgnd7dqkUAckAr
0rJr3UjWKbIy0gQZbPPSgl5QAox6+lWdmRj+VIi7PlFZuDb3KsQ7jG6qeuOtSiP0Oc+9MkRWk/nT
iML1IA7+lCQ7DlcOMVWmLxygg49DU/lpjcGP1zUcsYJJOc4okm0J3sMyXUsWxj261OJRs+YEcVD3
UAfKOme9CMHlyRk9s9qmN7gmNMjo5IBXNL5rAZwOalLI7YbFNLRqxDD8cUWtswt5kiPuiBPBpS6j
qaiWVGzg4Apm8njNdEIXREqttCUu2MjAFI10iIeeRTJ3EcGfas0N8p961hSUjOpVcDWtbgTSMOcg
VcrK00fvmP8As/1rVrKqkpWRrRk5RuytfnbZyH2rB818YBwK3NQ/485PpWBXTh0uU5cU3zIeHHXH
NPDA1DSgc102Oa5NT4znIIzxTM0qnBqGropOxft5m+6Yxu9R3qUzrHExckDOAcdM1HafMPp0qdow
RjvnvXnSVpOx6VNtxTMvzkcKTdzMAR1X0NORwsv+ud92AoYegrTCqf4V4PpSlFPRRn6VLV9C2iqr
gkBuPU1I1yAuFGKR4NpyF7cnPSmvGu4KD06nHFLkd7Jmd2lqHms8ZJAz61EF82ErjlaY00cTEjLN
6npQt7mNlwMnoRXZCm1qkc0qiejZA6FGwaTqaCSTknJpyLk5xW5zjOlXLaZeFZsY6VTY4JNLCBK+
KU0nHUqDaloayAsSoxjOc0bxEGViM9veo4w1smSdwxwM1AXWSYs4+UjH0rjcXLbY71JRXvbil7w7
vLdcZ4BXp0/+vSql2xAM6YzyNvvQCYyNpyPrTt5lI2Asanl1sU5q1y4Dghc5pOrHJxVUPPGTlMk+
1CT+czZUginy62Dmur2LZQ5GTn8KdimBiecED3pktwsPDdTxioLJD6g1XYn0HXGajeaSUiONTx12
nP504xXEiCPIRQQdw6mgLEjxMVxux6U1Y5YyMYOepNMgt5UZd07Pt6j1q1kn2pWuKxCYhuz0I6Ux
kKKEwck5FWMqCOePWq1xc4f5enSlyX0RMmkrsYoAIBOcU1pFRzzTYpPnJZTiqcsoYkJwM9a7KFJp
WZx1aiauh91OZWCjoP1qMPx70wknFGBziupRSVjncm3c09Nk3TuOPu+nvWpWNpH/AB8P/u/1rbrz
66tI9DDP3Ctf/wDHnJ9K584zxW/qH/HnJ9KwlUHmunD/AAs58V8aGUjHapPJx6VL5fvUMwKoc7uO
fl610XOawgk4yFb8qsLu71XVgMAtJn/dqyv3Rzmk2NItWs2wlSTg9K0FYMNwOaxquW04Uc89iK5a
1K/vI66FW3usuoMZ9zTiygioS+1A478Yqs9w0h2BWZh6Vzwg5bHRUqKJdlKlRn8Kx5ZCuEz04q8J
d0YB+96VmzcOQRgg11UIWbuctepzJWBlyMmmAZNBJPWlQfNXTscowpufcY3yOMhu1TRtsPyxlc9S
TmmvGpyxJ5GODTFwhJGefU1NrlXsSltzYqe3DeaAgqCMZ6dTWpb23lpzyxrOrNRRpRg5yHNG0rYZ
+B6U37OF9SD61aQDGAMUMQCM9q4lNo73Ti9zLkifzMLnFPiklhBVfyNaI2k5GKaVBU8DNaOqno0Z
exa1TIoXaRcsxzmkMOzJQgN9OtSQ4wVP3geaHBU7hk+tZ9Ta/ugMrtw2ex9KgnyJFwNzNwPalaVV
Ylsrnp6U+MrJLuyfajle4KS2IoA6NtVwAecEVZaPIySS1EsIkwQdrDoRVaT7VF/y0jKjvjmpKJXU
fe4BHccU5ZN6AjoRwfWqYEkgKOx2sOpGKuR7WVQOVXjNK4risgwvtVaYBT8wPXjmpppVXGfujkmq
NzciRtqkYrppRbOatJIJJgsLbR9aoZ5wBmrH3lZe1V9oDZrrhFI45ybB2MYGCob0Pemo5Zxllxz0
oZWY/wAJHuKQK4bomM9qok1tLx9obHXZ/WtasbSP+Ph/93+tbNebiPiPRw3wEF/j7HJnpisEMAeK
3dR/48pPpXPiurD/AAs58V8SHBz35pGOTUgVWH+FN2YNdGhzajQpPSnqCp60ICD7U+k2NIKAcUUU
hlhbo+X5bdPWnxyBYxsOWbqSKqUq7s8VjKkumhrGs9L6k5iZQXL4qF8NnPPvUjMW4Yk+1ToiGUqB
8ijDfWk58nxFxp87fLsUGh+TcppI8fjWk6xYwuQO/tVaS328r83rVQrxloZzoyjqV3+7TVIxg1JT
SgNapmQ+Phxgd62UdcAd/asRBsIPXFW45VIwMIRzXPiItq6OnDzUW0zQ3gDBzThjAJOTVKSWPYR5
hPNTLINg2ndxxmuVppXsdinFu1yYKD83p0oCjHTms3ymbINw457H3zU0EZDjdM55PB6GpUkO5LI3
lzjHcYpxuFCZJGfSmsA4TPqc1Bd7IY+ACxrSC5mkRNuCbRFc3BlIAGAKLaYq+08g8VXByM05OHFd
nIlHlODnblzGvLMsce4/hVE3BkOTg5pssweLYTyKrqcMKzhSSTua1KzbVjSID7VJHyjimFwg56j9
aSIDIzzxg0+WLcmM559ayUUpG0ptw8yk8jS53HjHFVCMHAq7IVVcDFVWT95xnHrXVTfbY45rvuOX
gVHIRuqXAPBppRT0zWiepDIgaUYB5FPEeKXGV5HNO4rF7TCDO2P7v9a1ax9J/wCPl/8Ac/rWxXn1
/iPRw3wFbUP+PKT6VgV0V6u60cH0rDZdnat8O/dsc+KXvIjwVwaeGBFJuDIfWhFPQgV0PzOcfRS7
CO1JSGFFFFABTg5FNooAlUkhyg+bHFWUXChQdwPJNU0Yqc/nU0MnlRfN8yg9R1A9xXDiYO6fQ7MO
0426lnAAIxx3pyJzxgfSs+SSKZv9Xc/NjkHA9KfBsVkm8m5yvIH4Y5rmSaZ0WLElkWLFcCqMgMZI
bqK2GlKRGTBORnFY07GRi5716FCUpbnHiIRjtuIrbuMUuKZH1NSnoK3ZzIrywu7xus7IEbLAfxDH
Q1chYEY/Kq8hP4U+2yXUDrmonHmi0yoStJF9YBjIOPanqjq4Udz1NSMmWJI59cVE+4EE/hivLSSd
z0rCzSNCD3OOKzZC0hyTnJq5LuaDLHJz+NVjGypuII5xXfQslc5cRdysNK7QPSgdRTk6NkZGKZnF
bnMIXBY0ZFRqPmyeKc4wuR3NVYVyxBMobax4Pery4dBzkAYBzWPgetPSVhwGP0rKdLm1RrCty6Mu
3MajoOB0FV1wxwR9KIN0r4OcD3q4kUageWuSD1YVm2qasy1eo7oqmJgwGCAe+OKa6qB1rRBLqfl+
bpiqUobcSU4opzbe46kIpbCMoKZBqE8U48dM00gMAK3Rgy1pXN05/wBj+tbNZWmoElbn+H+tatcN
d3kd2H+Ahuf+Pd6wJnJkx2HFb14dtq5PYVzhO4k+tdGGWjZhin7yJEIxT6gpyNg47V0tHKmTZPrS
Ux3wpwQD2z0pnmP6x/nUlE1Lgikp4PydaQDKKM5opgFS2wzL7YzUVOXOw443ELms6vwM0o6zRYhO
5XxwpY4rRVgq88Y4qJIUiiCgcD1ps7LHHgjkHPXrXBCDbPQk+VNsZczgKQOvSsxzxj1qRmLHJpGC
npk/WvQpwUFY86pNzd2RoCPpT6aXVCAWA+tCyIxwrAnrVtmYj5PbipocROp60ymq2W60nqrDWjub
hCsq8DmmPhFIAAU8Z9KZbSK6Ak9O1MvJwMICCO4rg5Hzcp6SqLl5mV53xLt6gd6W8kB2KG4AqvI2
6TBPNEoyQDXWoJW8jhdRu/mNDds0juqrluKAoB4pHDFcK20+uM1qZjDNEerCpCMqABTNkvXzBj/d
qUYxzRcCADJqaFMyLjn60rbcZFRxlvM3L2obuhbM21iSFNzYA7ml+0W//PVPTrRuSSACQAgjkGog
lrkBY0yPQf59BXnNSbPTTjFEizwMQRIh9OajcRurMjBh3x2py21qD8sSAj0FEiRW1u+xFXd6dzRF
tMc0nHUoBQ3uRUeNq59TTosbj60BCQOM12nAWtNO6dj/ALP9a0qzdNBEr59K0q5K3xHZh/gIb1d1
o49qwvLwc1v3RK2zkdQKwZZ2fit8Pexz4q3MiPHzc9KGXb3oHHPanlA3NdVzlIWJ2YABPvQoY8BE
qTYaeBgUnYauKOBTh9w02nHhB7mpGNooopgFXbRFaMA4znJqlV2y5LnPtisa3wm+H+MulwRgYx61
k3dxvkIU8CtCbPksB1NYsgZHwymlh4LcMRNvQUOakBzUQ6dKdHn8K6WjmQ1yQ5BdB6ZFCNl8CRD7
CpSATkgU4IvUAA1BQ05I4pgU59Kko7U7isKJXjzsPJoY9ycmm0xQS3NFkO7HqpL5NPOPxpVYAYxQ
zgjAGKVwIWyCMdKfRjNTC3JTduGfShtLcEm9iMfc4pMHGe1ByDigEjvQAlJtHbindaSmAh3EY3HA
qPc6t1INS0Y5oTET2t46NhxkHvUt5IWVV7HmqdPbLKDnOOKzcFzcxqqkuVxGgkHIq3Hh13VTq5Cu
2EY5J5oqbCp76liz2+e20kjb1NaFULPcZGzjGKv1yVNzuo/CVb84spD7Vz+CxroL4Zs5KxAAOldG
Hfus5sUvfQgUAYp1FOVe56Vu2c4gGTigjBoLc5FJSAco5z2pCcmkpu8ZxTsA6kyMkUbhSFQ3I60C
HCp4JfKc54R8c+9VlJ6EU9WZDlTipnHmVi4T5Xc0JJQThXA/rVSRwWPSoScnJpQpPapjBRHKbkP4
cYyBUbgRnB4NO2c4pShB61SJGA5GaUHBpMYJA6ZoqhEpCkVGcA+tMLimF8ihRYNktMdsDA600EqK
aTk1SRNydCCMmgkZ61CCR0NITmlyhcnB9KlimKsATxVdCTx2qQNjsPyqZIpMlmC53DvUNWNqsuM5
NQEYOKmI2JRRRViCiiigBeuBQRg4pKd976ikA2rYkSOIbj2qrg4zUTKSfWk4qQ1Jo0dOk8y5fn+H
+ta1ZGlrtmf/AHf61r1xV/iO7D/CV73/AI9XrHVM8npWze/8ej/SsQkmtqHwmOJ+JDjtB6U1mz9K
Siug5gooopgIRUZU56VLRTTFYiCsakAwMUtFJsLBSqCxwOtABPQVahi2LuP3qmUrIqMbsakO3qCS
OvFJOcAc4PoKuMNqAdPaqFwSXrODcnc1mlFWQ15GcDPamUUVrYxuNZsfWmbjipSM0AY4qriIlUuc
CnbCp9afginKpY4pcwWItnFMZGAO0ZPapypHY06KNncACjmHylQCQk/KvB/vU9UdiMoAPY5q0NOE
kpGwcnJrQttPSD+FQPSs5VlE0hRlIygMcUYrZlskkORgfhUD2Yj981KrRZUqEkZyttNGCzcA81ow
2oZuF/E1aW1QdaUq0UONCUkZQtm2571GYnBwRW4IIx2z9aT7PGGzj8KlVzR4YwzGwOMUoidui1tG
1Q+ooFsgbPPTpT9uifqzMQoy9QabyK3Wtoz0GKrSWpBwFyPUU41kyZYeSM9Wyv0oIVvappIih6VC
68cCtE09jJprct6cuJ2/3f61p1l6b/r2/wB3+talclb4juw/wEN0u63YetYrqUYg0UVrQMMTuNoo
orpOYKOtFFAEqRE/jT/svvRRWTkzRRQv2X/aP5U8W6ZBGeKKKjmZfKrEgUDoKmiA2kk/hRRUT2NI
bj7kDKt7VnyxFmJFFFOk7ImtuV2Ur1pKKK6UczADJwKvQWZbqKKKyqyaWhtRipPUsrZgHBUYPepR
axDoKKK4nUl3O1U49hWt426g0JBHGOFooq7sr2cexLsUNuxzTqKKkYgqN4y5BzRRQhSJFUKMAYpa
KKBiUUUUALRRRQAlFFFAEckav1FUrm2CHK96KKunJ3MasU07iWCbZ3+laVFFTV3Ch8J//9k=</Data>
</Thumbnail>
</Binary>
</metadata>
