<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<metadata xml:lang="en">
<Esri>
<CreaDate>20250414</CreaDate>
<CreaTime>13281700</CreaTime>
<ArcGISFormat>1.0</ArcGISFormat>
<SyncOnce>TRUE</SyncOnce>
<DataProperties>
<lineage>
<Process Date="20250414" Time="132817" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\CreateFeatureclass">CreateFeatureclass C:\SDE\next_gen_prod.sde Annexations_Submissions_PROD Point # No No "PROJCS["NAD_1983_StatePlane_Georgia_West_FIPS_1002_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",2296583.333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-84.16666666666667],PARAMETER["Scale_Factor",0.9999],PARAMETER["Latitude_Of_Origin",30.0],UNIT["Foot_US",0.3048006096012192]];-16150100 -43703500 3048.00609601219;-100000 10000;-100000 10000;3.28083333333333E-03;0.001;0.001;IsHighPrecision" # # # # #</Process>
<Process Date="20250414" Time="132824" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_prod.sde\Annexations_Submissions_PROD "&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_alias&gt;DCA ID&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;dca_id&lt;/field_name&gt;&lt;field_type&gt;Long&lt;/field_type&gt;&lt;field_alias&gt;DCA ID INT&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;cityname&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_alias&gt;City 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;countyname&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;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;status_ex&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_alias&gt;Annexation Status&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_default_value&gt;Annexation Filing In-Process&lt;/field_default_value&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;status_in&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_alias&gt;Internal Status&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_default_value&gt;Awaiting manual review.&lt;/field_default_value&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;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;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_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_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_label&lt;/field_name&gt;&lt;field_type&gt;TEXT&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;255&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 Original&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;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;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;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;total_acre&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;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;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_comm&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;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;user_comm&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_alias&gt;User 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;cid&lt;/field_name&gt;&lt;field_type&gt;Long&lt;/field_type&gt;&lt;field_alias&gt;Community 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;last_approved_user&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&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_length&gt;255&lt;/field_length&gt;&lt;/AddField&gt;&lt;/workflow&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_alias&gt;PRG 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;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;automation_status&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_alias&gt;Automation Status&lt;/field_alias&gt;&lt;field_is_nullable&gt;TRUE&lt;/field_is_nullable&gt;&lt;field_default_value&gt;Manual Review Pending&lt;/field_default_value&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;job_id&lt;/field_name&gt;&lt;field_type&gt;TEXT&lt;/field_type&gt;&lt;field_alias&gt;Job ID 1Data Gateway&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;/operationSequence&gt;"</Process>
<Process Date="20250414" Time="132826" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\AssignDefaultToField">AssignDefaultToField C:\SDE\next_gen_prod.sde\Annexations_Submissions_PROD status_ex "Annexation Filing In-Process" # DO_NOT_CLEAR</Process>
<Process Date="20250414" Time="132828" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\AssignDefaultToField">AssignDefaultToField C:\SDE\next_gen_prod.sde\Annexations_Submissions_PROD status_in "Awaiting manual review." # DO_NOT_CLEAR</Process>
<Process Date="20250414" Time="132830" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\AssignDefaultToField">AssignDefaultToField C:\SDE\next_gen_prod.sde\Annexations_Submissions_PROD automation_status "Manual Review Pending" # DO_NOT_CLEAR</Process>
<Process Date="20250414" Time="132832" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_prod.sde\Annexations_Submissions_PROD &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="20250414" Time="165423" 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=00022e683256433755746656635979467744514e6d4f667235734a46556b4475422b626733544832614f686564696b712f33305352333642624b354a4d4e4835375562682a00;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_prod;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS&lt;/WorkspaceConnectionString&gt;&lt;WorkspaceFactory&gt;SDE&lt;/WorkspaceFactory&gt;&lt;Dataset&gt;next_gen_prod.sde.Annexations_Submissions_PROD&lt;/Dataset&gt;&lt;DatasetType&gt;esriDTFeatureClass&lt;/DatasetType&gt;&lt;/CIMStandardDataConnection&gt;" "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AddGlobalIDs /&gt;&lt;/workflow&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="20250414" Time="165542" 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=00022e683256433755746656635979467744514e6d4f667235734a46556b4475422b626733544832614f686564696b712f33305352333642624b354a4d4e4835375562682a00;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_prod;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS&lt;/WorkspaceConnectionString&gt;&lt;WorkspaceFactory&gt;SDE&lt;/WorkspaceFactory&gt;&lt;Dataset&gt;next_gen_prod.sde.Annexations_Submissions_PROD&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 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;/operationSequence&gt;"</Process>
<Process Date="20250415" Time="201738" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_prod.sde\next_gen_prod.sde.Annexations_Submissions_PROD "&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_PROD'))&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_PROD 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="20250424" Time="140628" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_prod.sde\next_gen_prod.sde.Annexations_Submissions_PROD "&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;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;/AlterAttributeRule&gt;&lt;/workflow&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;0&lt;/category&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;/AlterAttributeRule&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20250424" Time="140649" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_prod.sde\next_gen_prod.sde.Annexations_Submissions_PROD "&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;True&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;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;0&lt;/category&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;True&lt;/triggering_events_update&gt;&lt;/AlterAttributeRule&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20250424" Time="141903" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_prod.sde\next_gen_prod.sde.Annexations_Submissions_PROD "&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;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;/AlterAttributeRule&gt;&lt;/workflow&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;0&lt;/category&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;/AlterAttributeRule&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process>
<Process Date="20250424" Time="203518" 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=00022e683256433755746656635979467744514e6d4f667235734a46556b4475422b626733544832614f686564696b712f33305352333642624b354a4d4e4835375562682a00;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_prod;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS&lt;/WorkspaceConnectionString&gt;&lt;WorkspaceFactory&gt;SDE&lt;/WorkspaceFactory&gt;&lt;Dataset&gt;next_gen_prod.sde.Annexations_Submissions_PROD&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;status_ex&lt;/field_name&gt;&lt;domain_name&gt;AnnexSub_externalStatus&lt;/domain_name&gt;&lt;/AssignDomainToField&gt;&lt;AssignDefaultToField&gt;&lt;field_name&gt;status_ex&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;AssignDomainToField&gt;&lt;field_name&gt;status_in&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;prg_comm&lt;/field_name&gt;&lt;domain_name&gt;AnnexSub_prgComments&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="20250429" Time="001731" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_prod.sde\next_gen_prod.sde.Annexations_Submissions_PROD &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="20250429" Time="002707" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_prod.sde\next_gen_prod.sde.Annexations_Submissions_PROD "&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_PROD'))&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_PROD 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;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;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 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="20250513" Time="141821" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_prod.sde\next_gen_prod.sde.Annexations_Submissions_PROD &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="20250513" Time="142527" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_prod.sde\next_gen_prod.sde.Annexations_Submissions_PROD "&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_PROD'))&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_PROD 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;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;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 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="20250513" Time="142548" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_prod.sde\next_gen_prod.sde.Annexations_Submissions_PROD "&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_PROD'))&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_PROD 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;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;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 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="20250513" Time="142710" ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema">UpdateSchema C:\SDE\next_gen_prod.sde\next_gen_prod.sde.Annexations_Submissions_PROD "&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_PROD'))&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_PROD 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;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;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 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>PROD</keyword>
<keyword>view</keyword>
<keyword>s123</keyword>
<keyword>form</keyword>
<keyword>Annexations</keyword>
<keyword>Submissions</keyword>
</searchKeys>
<idPurp>Annexations Submissions PROD view layer used in the Survey123 Form</idPurp>
<idCredit/>
<resConst>
<Consts>
<useLimit/>
</Consts>
</resConst>
<idCitation>
<resTitle>Annexations_Submissions_survey_PROD</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/9oADAMBAAIRAxEAPwD3MZHa
lzxSbz3wKX6j8qgBnA5YgU8cLmqsszxO24eZGfTqtOM6SRfumzjkgdqLWEmSySJHgu4QepOKrXFz
EPlMiEj/AGhVWWNL4ETfNGP4T396jfRrHjMAJPf1qW7jZYjKSpvV1YeqnIpyRlmPA6elMtLGG1Rh
DGEUnJAq8oPAqUiRiRKqhSBz1OKhKqOwwox0qyV2jJNVMHoe7f8A16begyWKFcAsOtOXbk/KOuKQ
SZTeRj0qHcWKr3JyaV+gXLRQEHCis92GSuOe/FaIGFxk5rNntp3Vgo3HPdsUpXEyW3dAMEcVPviy
BgVjfY7xSPvj1/emlEFwsqli2M8/vTSu0FzSljw+6PGM8gVXZzIpDqflPFKcib931A7U6O3Mq5bj
n86V29hEWwFc457UuCXz37VYa2YDIwAO1MRSzFR1pWYCwQhpCW5A6VdMYwDTY02KAMk08s390itE
tCkhNwXvVO9ecrstiBI3RmHyir+zg5Apgiz+dVYaMuOHWnziazx2+VqsWdvexhlvZInP8JjB/XNX
0Qpxx9aRuCKYMToKiux/or8HIGQKkZ1TG6opJS3A6VPMkS9iZDuQEdxUj8Lgd6jQ/IMHjFDcjNO4
yF4FLGUrl8YB9qsLIQPuN+lNKkg80/I2YPWhAHmH+435j/Go95z9xv0qROD0prSDzSmB9abYDWY9
QjfpQuSM+WePcU8gDpSqcjHtQBEzA5Y5+lL+dSGLIyODUW8DgnB9KLFEjMrHimg++RVWYFZW6gE1
Gu/OAxFZ8+pPMXzF0akWNQThQMjn3p6lgoHXik+9gVp6AQeSqEhVHNSowUcinGMgUpHoKEgGjG7c
Rj0xUi/Q0ijd6USHAwOtAEchycdR3qA/vJCBjHBNSspAx3NIAEZccDFS9QI5iAAo7Uy3XMuSDgjI
p+wFiTzmpwAFwKm2txDxhowcU3nbihSQMUgPO2rYxkpwh4yPaofso3by2fwqyMfhSgZqbXERRxqp
4GKkK45I+lOVMfWm8k/SqSsMinfC4xnNJFGCmSvNSlQcZFPUZ9hStqAxSUOCCV/OpMh+APzFP4HS
o5CVw/p1+lWMapcSYbJ+lSMOOOKXjAKnrSE5yKQCI3rTTznFA60YxSuIrTMS/sKYTVswiTnODUXk
YOG6Vm4sVhYGygHcVJ6ikVEXJHWlNWgQo5FB6UKcDihmGcmgY8cYzTFiBfcTzmnk8dKF460wHFQa
jwVbNSZqNnwducmmxjiSD7UbVpnKnmpR060IEVJmB+XHNJAg35PpU5RWHNIsaoe9Ryu9xWJBzwOl
MUbC3zcnpTi/pUf86tsCTccdeaUDAyxxTAMDOefSkZ+Bk0rgPLBWJHeosknPU9qaclc8gU6IEdet
AEoyetNlRflPvS85HUVHKwJKjJI5Jp3AVlB4xxTwh460KRxSl6QA67V4NIQACc0md3fNNPyHPUUX
uABgijP5U/dwCRx7VDKRkY6+lOVGIGDwetCAlEgP3c/WmkjNKFCqABS4H0NNgNI4zTio25zTJG2j
1PpWa/8AadxNvt5Yoox/BIvNIDVBK8EUM2eKqWgvgW+2SROMDbsGMetWgcGi4DUyoweCOlI7hBz3
ply0wQGGMOwPQnHFZUsd5NKWZHQE8gSdKUvIGa8ZJTn86kDZ+lZcEl5Cqo0WV7sXzVweYxzgikmI
srnPFBUnrTRkd6Bk+uaoYjRsDxzTQ+Qc8YqSQOF4bFVZYS6EMSue9Fh2K41azRvmuF9cH0qe31Gy
updkM6O57DrVHyI93z2LMfUCrlnbRIPMFqIXycZHP1p2sBeAGQB1pwUY96jbdjcOopyElckUIBcD
0GfWmmNAc96fnJ6UuaYEbcjPakp+088cGm7W9qmzENpckcUd6KQCrgcnrTR940jHaMis+6v3t5lS
G3ecN97Z/B9aYGiXxyOaQ5Y5brWOdWliBLabddcAYFW7a/luJdjWNxEP7zjApagXs4pFljLEbskd
qcB/s1C6xxsWUAMTTBBPuY8kgAdKSFAFb34oZ95I4JPoalRNowKm2txCjlAaWkRTtI54OKcCgYjH
IqrDEyoGTTWkZkIA49acR6YNMYBVx3NAGfdzTRgC2RZZuu1zgY71HHeawUB/s+PGez1o+SVIJHPe
pgBjjp7Uxj0JZF3cEjkUmDyKOwNIM+hxQIUgheRUZ2q3QDNOL5GCarup39zUtgyfpS5pq/dwacME
daAAEU1kV/XPrSnrxTwQBx1oQFWUFQExyKkibK+4pJ8thu/86YkiRI0kjBQoyc9hStroIuALijtx
Vb7bbpnM8YH+8KmjkSRQ8bBlPcHIqyh4PYjmmTwpPHsccGnl8UjjjimBQOnQ4K5frn7xp0NmIJA6
k5AI5Ykf54q1jHOOakUYHNLcQig9aUnAGKCdtA6Z6mnsMbnHtRwenUU3cu7JOKX7vQ5qRDgSOppd
9R5zRRcANFZIsL0phdTlUYwP3eaeljerIh/tORlDAlTGOQD0pWAvuNzAdqhCAuxVcevHWrOM01QQ
TnjPagBFYt24qQZo45oBAOD0oQEc/meUTE6o/YsMiseeylmkLuIGdupCkf1rSncu4GeM44qWKMc7
hU3u7IRn22n3FqQYmhBPUkHp+day8kUZGfalDY7VSGCthnFIxDHpTMnzST6UyCUShmA43ED3qrg2
SltuKQ8EZA570HnFOznp0pXAdnjH601VCEj1p5B28VGTwKYCnrRk4xUM1zDBgyyom7puOKzzq5DH
AhYdsSjpU3A1CQByaFw4ziqQvIpmQeZHvI+4HBq6vAFCeohcdqTA/wD1U49aSgAC/XFLsGOP50A4
NOkTchA4zTQynLOi/KMsfQVHLCJkxIPl7qRkN7GrUVrHEdx+ZvU08gEnjihaDKMej6TJmVbSPHTp
xx7VcghhtYfLgjCKDnCjAqt81pMTtJhc9B2NWxzzTbFckwDyaN3PNAwvfimtznBoGKWGDQOelRkH
FOU7V56UJiHAjPPSmrLG+4I2dpwcHpVCSVrx2S3lwinDsP6VZghSCIInPqT1NDYFjaDkkVTkkcBv
LIB7Zq1uOwjvVRl2nFTJ21Ex8Nx5jbXQqw/I1MSM1VpwdsdanmuCHicA8jipQwYAiqzQuORzT9+F
AxyKE31AnpG5YVDHOuSGcZHvU4ZTxuHPvVIZDdMUtnKkg44IqVRuQA9xzTZo/MiZM4zxmnBdqgZz
gdfWn0F1GeWgPT8akFJjoKXBxmlYYUZxRQelAENxJ5UZk9AaWJRFEi9TjmmXeTEBjI3DNT44qugu
oY4pwxSBgDzSZ4yKkZKWzxUZ4NG7I+ajNO4DGjR+JFDDtkVFJaRBgVRR9BVjrUbNsbnpSauA1baJ
HB2LuHcCpX+77jpWcdSuRK6jTpmQfddSMH9avQu0sIZ42jY9VbqKLWAkHNOxjrTASORT1OWzQAmK
eTwOeaCw6U3g9aoBQPXvQQAcg0KVx1pH9qAAqGGD09qbho8n7y/qKdnbSMdyFexpXABzTgAoyeaj
jY454YcGn5IxnpQAEgiqE4uLiQwr+7jB+Zu5HtV00h5IpANjiWGMJGAAKB0J704jg00ce1ILjRJ8
3NRSXMBRcTRkE8fMKklQsmF/PFYktqnmZs7CKQJwQx2/N+P4Vai5ITaNL7RCBnzUHOOWFL58X/Pa
P/voVjyWly7Evo9u2cciarltplsYFM1lHG/dVJYD8a3p0klZowlLszZKkcmonjGC2atkgmmMoPHG
DXO4nRYzksLeVizR9Tk89TUg0y0OR5f45/CrQUKMDtS4pK6DUNoRVVRx0xQQRQz4HPFIZQsRaRlV
fVjgVW4CgcinbhioxPGMfvU5/wBoU/zojzvT/voUgEpCQOtOZlHPb2poVWbdjr2pAB+YYPSmrnaP
bipCmORVO4uDApKruZui+pp2AtgcH1oHHWsZtYulbb/ZshPb5hirdhez3bYks5IRjO5iCM0WCxdI
Oc44oGTUnyjrSAA0WAaFPekkUcLgA0/ODTZBvxjk0DRnT6tFb3LQtDMcYAZEyDTTrUWwsLe4IU4P
yYrQjjESbVAHOeKlCgr6GgRl2+sQzyLGIZ1LHALJxWmgyfpSlSO2aaDhju4H0p2Adt9TSNgDj1pP
pSYzSAcBmlII7ZpFGOP1qQDAxmhICPk80c4p5IHB4z0pDkcdaLARDiVvwqTcNtMdd3JyD6imqcEq
eoouA7+CgD05NGfmpnmYfrg5xQlcVyVEzkkUbQPxpGd1GccVE0xPQfjWsaTZEppEzEJ1YVWJBOcA
UlFdEKSjqYTqOWgUUUVoZlzIak3kcYpvajB9a86533H9B6+tINvUnmm05WAGDT5gHYHTrVG8tPtY
8p13Q/xIe9X8jGe9ID0NMZlf8I/YuihosYOeDj8Kc2hWOQfIww6EGtIyYPA4o8wdxSuBGFAAGOlL
QWyTxRUiFzgVBd5EIZV5B6+lTHpTHBfKdu9NMEZyI0zHBy1aFuGSFVPBFOWNFxhQKcD3pBcVjkUq
tgYxQfmoA7jmmA7bkc00jk5NOX9aXq34UxkeMH2p/QZ7UuB2ppORjP4UbAKHFMY5oyB1FJkZpXEA
25+YUYGeBSHJFSL05oAFX3peQeaaMgj0p5NMY3Cs2SOlDHBz1FRSTLEAXYDNM+0RH+MUmwJjzzUM
p2up9eDSrIrEhWBqKVwE3McYOfpSETDPWmSDB3Y61Q/tG++YJpwlX+FvNC5H0pqXV/JcoslgI4z9
5vNzj9K2pxfYzm7dTTeQHpUVFFdcYpbHNKTluFFFFMkKKKKALAyKXn1pD2FBrzbncLRijOaCaBid
TS96VQM8mgrg0AIaKUgDqetA5OKdgsJ3pPWpMBTSbMkk8UWAYCM4NAOSx/Ch1xkDrS7cIpHTFHQA
704DIwaaOop+0Z70IBAvbvT1GBSdfrSqeOaoYDGc4pOrEc0pODk0EjIIoAOnY0wjBzUlNccdKGAH
kVFjnincgUg5qWIPalU46g07aOhoOePSmkFgDAjB60cGmsR0IqKUSFP3TAHryOtK+oXKuobvMA2n
AHWqg6VpxziXKOMMOCppDAnmbggxUyWoJlO3il3B1+Uepq66ADJIOalVMnBxQdowHGOfzq4RE3Yh
2hQDjj+VNpWwScdKSu6EeVHJOXMwoooqiAooooAKKKKALHelxxTsDHvTK82x3hjFHejk80o96ACg
k8U4jOOetKFAxmnYBhbnBGaVG4PHemP941DN5ipuT6mi4y2G55pS/tVeCYTIM4DelWAnHNPUBhyx
JoQErsP8P8qkUcUxRl3J6Z4osAqrzn0p9AHFIeKewDS3Jqrc3c0cf7iISS9lJwKskEnpSYBIGKm7
EU7e71B5USewCKThmDg4960cCk25xnHFLj0qhiD09KCQRTJJBGNzYAHU1Re7luS0dmCo6GVhwPpQ
BYuL2C3O0tmT+6OTU0LM8YaRNjHqPSmQwJEoY4aXABcjk1KTkc0AHfrTSCD7UH1zSbuRUiHYDj3p
pQoM04kckGmkluvShgQyRLJIJCMMvcd6eTmlxnFITzg0nqIcmdwx2pJXTaR1NCsBkg1FI2cLjGP5
1vRjdmdSVkMooorrOUKKKKACiiigApM0HgU2mhNl1vvGm9s0u9AO/wCVNLqe/wClea0egOo3DOMj
NMLrjPX8Krk5JNS3YRcBXBJNKSCo5zmq8UYblmAH1qb5c4yMU02NB1pfK3YPSkRlVsbh+dSh1Pcf
nVIojjt0iJZV5NRXM0kasIx8xHy59as7l/vD86a5U45FOwjMSXWcj91bEf75/OtGAsY/nAyeTj1p
OOuR+dNSURvhmGGPFCAsDjig0cGgUAIORRt6gU6kNAABig+1JuoUdzQA2RVdCrrkHrRgIuFXA9qc
epz0NID8v6UAMK00k5xmntlRioyKhiHEnFJkjkik+lKOTQIcrhh6UjNmozKgbFPzkCi9x3D6A005
wSOTTiD1xQFDcE4oSuxEaAMCTwO9RnrT2AXK55pldtKNkc1SV3YKKKK1MgooooAKKKDQA0nmkooq
iS6W3MM9Kc3TAFMVt3OMetODDJ715h6I2jbkZwKCQOaia6RRtBz9KAJtmOQo/Kl25H3R+VUW1SFX
KEjcOxpq6mnmAF0Ck4pjsXygB5ApTtB+6PypizLKu5CGHTIowT1NLYRKFX+6KGRcfdH5UxckgbjQ
cnjccU7juOVV6YBqC9izBuQfMh3cVNjB4P50khDRMGHbmmmJ7Do3Ekat6jNBbafWqlqWECcEqOmD
2qcuP7rUS02Em2iXJIzigNkZPWokkIyCrY+lIXAPIIpXGO8wbwtTdarbk9f0qRZE6ZoQx/YioJpz
ChIUt3AHenswJ+9+tNIU46HFJiM3+2J9zf8AEsvP++Ku28pnhEhjeMn+FxgirGcrnv3pKTBjCahk
kIOBU7CopGAT69KlkkAq1H9wGquec1YUAoinoamG40Sq4b7rA/SlQrkhsUwoCeRz603Yd/3vzFaJ
jEmH7z/CmU+RGBDEg5pld1L4TjqfEFFFFaEBRRRQAUjUtMPWmhMKKKKZJYLbVG09Pas4a5axNIsv
mIwPeJvXHXHSiiuCPU9B9Cu2t287IqyuVbp+7YfnxVoZY4UEn2oorOW5a2G/Zg4ZiMNj0qKGzcMA
WLDp8wGPrRRV8qM+Z3Ni2iWGHbwee1POM8UUVDLHBeM0FgMdKKKEAYyc5pHwwxjrRRQA1VVRgDA9
qQgjpzRRSAA208nH1rOn12zt5mjmMisCR9wnj8KKKaAafEOm45mcH08pv8K0IZ47iBZY+UYZBII/
nRRSAeFU44FPMSEcAUUVSAY0S4yPxpuwEcA5+tFFIBDH7mmlAw5LEUUVLENMCgZyalZQFXHYiiik
hodSMyqRzk+lFFUCGSEnjFR0UV20vgOSr8QUUUVqZhRRRQAHpTKKKaJYUUUUxH//2Q==</Data>
</Thumbnail>
</Binary>
</metadata>
