ALEX_BENEFIT_ITEM (Staging table)
| Column name | Data type | Required | Default update able | Data target | Comments |
|---|---|---|---|---|---|
| USER_EKEY** | VARCHAR (255) | Yes* | No | ALCO_BENEFIT_ITEM.USER_ID | External key of user |
| PROJECT_EKEY** | VARCHAR (255) | Yes* | No | ALCO_BENEFIT_ITEM.PROJECT_NUMBER_ID | External key of project |
| TOTAL_AVAILABLE | NUMERIC (7, 2) | Yes* | Yes | ALCO_BENEFIT_ITEM.TOTAL_AVAILABLE | Total number of hours available |
| RECEIVED_YTD | NUMERIC (7, 2) | Yes* | Yes | ALCO_BENEFIT_ITEM.RECEIVED_YTD | Number of hours received YTD |
| TAKEN_YTD | NUMERIC (7, 2) | Yes* | Yes | ALCO_BENEFIT_ITEM.TAKEN_YTD | Number of hours taken YTD |
| EFFECTIVE_DATE | DATETIME | Yes* | Yes | ALCO_BENEFIT_ITEM.EFFECTIVE_DATE | YTD from this date |
* System required field
** Combination of (user_ekey, project_ekey) must be unique