When an Assignment Level User Page is configured, it is possible to also have a duplicate Authorization Level User Page configured at one time.
This is achieved by marking the box named Duplicate at Authorization Level when configuring a user table. Duplicate tables allow for the same data that is in an Authorization to be transferred to an Assignment and vice versa. Transferring the data between an Authorization and Assignment is explained in the approval authorization article.
When Duplicate at Authorization Level is selected, the Authorization table is created in the database with the prefix of UT_AUTH_STAGE_[Assignment Table Name]. This indicates that the table is a duplicate of an assignment table.
The Authorization table will not be visible within the User Table list on the User Table Configuration screen and is only accessible through the database. The Assignment and Authorization tables can both be used for user page configurations however.
Once created, the Authorization and Assignment tables will forever be linked. The duplication is not reversible. Any changes made to the Assignment table will be made to the corresponding Authorization table. If the Assignment table is deleted, the Authorization table will also be deleted. If it happens that there are fields in one of the tables and not the other, that data will not be updated between the two tables. This should not occur unless the tables are manually manipulated in the database.
