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