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