- The PM_USER_PARAMS table contains parameters that are specific to the user.
- The ID is an auto generated number.
- The USER_ID is associated with a humanly legible name in the format that the user prefers.
- The PARAM_NAME_CD is associated with the object in the CODE_LOOKUP table.
PM_USER_PARAMS |
|
|
PK |
ID |
int |
|
USER_ID |
varchar(50) |
|
PARAM_NAME_CD |
varchar(50) |
|
VALUE |
varchar(255) |
|
DATATYPE_CD |
varchar(50) |
- A "_PARAMS" table contains name-value pairs associated with a user that can occur more than once or vary from user to user. An "@" in place of a USER_ID means that the parameters applies to all users not explicitly listed.
