ALEX_TS_USER_BILLABLE_RATES (Staging table)
| Column name | Data type | Required | Default updateable | Data target | Comments |
|---|---|---|---|---|---|
| USER_EKEY** | VARCHAR (255) | No | No | ALTS_USER_BILLABLE_RATE.USER_ID | User external key |
| PROJECT_EKEY** | VARCHAR (255) | No | No | ALTS_USER_BILLABLE_RATE.PROJECT_NUMBER_ID | Project external key |
| CHARGE_ROLE_EKEY** | VARCHAR (40) | No | No | ALTS_USER_BILLABLE_RATE.CHARGE_ROLE_ID | Charge Role external key |
| EFFECTIVE_DATE** | DATETIME | No | Yes | ALTS_USER_BILLABLE_RATE.EFFECTIVE_DATE | Effective date of billable rate. Must contain only a date component without the time component. |
| BILLABLE_RATE | NUMERIC (20,2) | Yes* | Yes | ALTS_USER_BILLABLE_RATE.TS_BILLABLE_RATE | This is the users default billable rate |
| BILLABLE_RATE_CURRENCY_EKEY | VARCHAR (255) | Yes* | Yes | ALTS_USER_BILLABLE_RATE.TS_BILLABLE_RATE_ID | Users billable rate currency external key |
| EXPIRATION_DATE | DATETIME | No | Yes | ALTS_USER_BILLABLE_RATE.EXPIRATION_DATE | Expiration date of the billable rate. |
*System required field
** Combination of (user_ekey, project_ekey, charge_role_ekey, effective_date) must be unique