ALEX_ER_USER_PREFERENCE (Staging Table)

Column name Data type Required Default update able Data target Comments
USER_EKEY** VARCHAR (255) Yes* No ALER_USER_PREFERENCE.USER_ID User external key --Primary Key
ACTIVE_STATUS SMALLINT Yes* Yes N/A If active, user is allowed to use Expense Reports application
  • 1 = active
  • 0 = inactive
When inactive, record remains; but the user is removed from HRBkgERRole Group.
PROJECT_NUMBER_EKEY VARCHAR (255) No No ALER_USER_PREFERENCE.PROJECT_NUMBER_ID Project Number external key --

*System required field

**Value must be unique