ALEX_TS_USER_ATTRIBUTES (Staging table)

Column name Data type Required Default updateable Data target Comments
USER_EKEY** VARCHAR (255) Yes* No ALTS_USER_ATTRIBUTES.USER_ID User external key --Primary Key
ACTIVE_STATUS SMALLINT Yes* Yes N/A If active, user is allowed to use Timesheets application
  • 1 = Active
  • 0 = Inactive
When inactive, record remains; but the user is removed from HRBkgTSRoleGroup.
LABOR_STATUS_EKEY VARCHAR (255) No Yes ALTS_USER_ATTRIBUTES.LABOR_STATUS_ID User labor status external key
EMP_STATUS_EKEY VARCHAR (255) No Yes ALTS_USER_ATTRIBUTES.EMP_STATUS_ID User employment status external key
TAX_LOCATION_EKEY VARCHAR (255) No Yes ALTS_USER_ATTRIBUTES.LOCATION_ID Default tax location external key.
JOB_CLASS_EKEY VARCHAR (255) No Yes ALTS_USER_ATTRIBUTES.JOB_CLASS_ID External key of user’s job classification
TS_PROFILE_EKEY VARCHAR (255) Yes* Yes ALTS_USER_ATTRIBUTES.TS_PROFILE_ID External key of user’s timesheet profile

*System required field

**Value must be unique