Question: When we set up PF on our own server (On-Premise), is the User table pre-configure? Can we add fields/columns? Currently, PF users on the OD version have the email address as their primary key. We are looking to assign an additional UserID field (numeric, alphanumeric) that we can access / retrieve when a user completes a form instance.
Fields and columns can be added. These new db entries should persist. You could also configure the Connection Agent to point to the your own User table as well and access all this information using the Connect Command which would give you access to all the information from a form.