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