XM_USER_BENEFITS
| Entity Name | XM_USER_BENEFITS |
|---|---|
| Entity Type | Independent |
| Definition |
| Attribute | Datatype | Width | Definition |
|---|---|---|---|
| USER_ID | Integer | 38 | User id |
| BENEFIT_TYPE | Varchar | 255 | The benefit code vacation, personal day, PTO,... are represented as project code |
| AVAILABLE_DAYS | Number | 7,2 | The total number of hours available to this employee. |
| RECEIVED_YTD_DAYS | Number | 7,2 | Number of hours received YTD. |
| TAKEN_YTD_DAYS | Number | 7,2 | Number of hours taken YTD> |
| EFFECTIVE_DATE | date | the date this benefit bank balance data is effective | |
| CHANGE_TIMESTAMP | date |