/
PM_USER_PARAMS Table

PM_USER_PARAMS Table

Sep 04, 2018

  • 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.