Features of User Defined Columns#
Pro | Con |
---|---|
End users can create these and no special knowledge of the system is required | The data is stored in an abstraction table and is not natively linked to the table it is related to. |
Date Sensitive changes will carry forward the values | This abstraction has the potential, if there are a lot of user defined fields, to impact performance |
UserCalcs can read (not update) these values | Any use of a user defined field in any kind of processing (programming, where clauses, lists of values) is not recommended. Instead, please consider the use of a user defined column |
Workflow UserCalcs cannot access the NewValue of them | No change audit logging is available for UDFs |
Supported by Object Security and Form Object Security | |
Interface programs like UEEF and UPPHF can access these natively, within the tables identified | |
Can be accessed using the P2K_SMGETUDF function by external report writers and by P2K_SMPUTUDF by stored procedures to set the value. | |
Does not require database access or system restart |