Time Leave Accrual Domain

This domain is used to report on leave accruals.

The domains consists of the following columns (NOTE: Column names could be renamed so you might see different names based on your side configuration, so the following names are the base names of the system)

Column ID	Column Name (From DBLabels.properties)	Data Type	Description

Column ID	Column Name (From DBLabels.properties)	Data Type	Description
EMP_ACTIVE	Active Employee	String	Employee Active Yes or No
EMPLY_ID	Employee ID	String	Employee Id
HOME_FUNC_CODE	Home Function Code	String	Home Function Code
HOME_DEPT_CODE	Home Department Code	String	Home Department Code
HOME_DEPT_NAME	Home Department	String	Home Department Name
HOME_FUNC_NAME	Home Function	String	Home Function Name
HOME_LOC_CODE	Home Location Code	String	Home Location Code
HOME_LOC_NAME	Home Location	String	Home Location Name
HOME_OPT_CODE	Home Operating Unit Code	String	Home Operating Unit Code
HOME_OPT_NAME	Home Operating Unit	String	Home Operating Unit Name
LAST_FIRST	Full Name (Last, First)	String	Employee/User Last Name, First Name
OTHER_EMPLY_ID1	Other Employee ID1	String	Employee Other id1 that is mapped to OTHER_EMPLY_ID1 in the employee table
OTHER_EMPLY_ID2	Other Employee ID2	String	Employee Other id2
SSN	SSN	String	Employee Other id that is mapped to SSN field.
VENDOR_ID	Vendor ID	String	Vendor ID
VENDOR_NAME	Vendor	String	Vendor Name
EMPLY_TYPE	Employee Type Code	String	Employee Type ID
EMPLY_TYPE_NAME	Employee Type	String	Employee Type Name
FIRST_LAST	Full Name (First Last)	String	Employee/User First Name Last Name
REPORTING_TYPE	Reporting Type	String	Reporting Period Type ID and Name
EmployeeEndDate	Employee End Date	Date	Employee End (Termination) Date
EmployeeStartDate	Employee Start Date	Date	Employee Start Date
FULL_PART	Full/Part Time	String	Full or Part Time
MethodName	Method Name	String	Leave Method Name
AccrualRate	Base Accrual Rate	Decimal	Accrual Rate
PaidDaysLimit	Paid Days Limit	Integer	Number of fully paid days needed to allow accrual.
PeriodDays	Period Days	Integer	Number of working days in period
YearsOfService	Years Of Service	Integer	Years of Service
TC_GRP_ID	Time Code Group ID	String	Time Code Group ID
AssignLevel	Assign Level	String	Method Assignment Type: Global Employee
MethodStart	Method Start date	Date	Start Date of Accrual Method
AccrualEmployeeStart	Accrual Employee Start	Date	Start date of accrual for employee
AccrualPeriodEnd	Period End date	Date	Accrual Period End Date
AccrualPeriodStart	Period Start date	Date	Accrual Period Start Date
DateTime Stamp	DateTime Stamp	DateTime
PrevioseDateOfService	Previose Date Of Service	Date	Previous Date of Service (If employee has been hired more than once)
AccraulFunctionID	Accraul Function ID	String	Accrual Function Code
AccraulFunctionName	Accraul Function Name	String	Accrual Name
AccrualDeptID	Accrual Department ID	String	Accrual Department ID
AccrualDeptName	Accrual Department Name	String	Accrual Department Name
AccrualEmpTypeID	Accrual Employee Type ID	String	Accrual Employee Type ID
AccrualEmpTypeName	Accrual Employee Type Name	String	Accrual Employee Type Name
AccrualFieldType	Accrual Field Type	String	Accrual Method Assignment Field ID
AccrualFieldValue	Accrual Field Value	String	Accrual Method Assignment Value
AccrualLocationID	Accrual Location ID	String	Accrual Location ID
AccrualLocationName	Accrual Location Name	String	Accrual Location Name
AccrualOpUnitID	Accrual Operating Unit ID	String	Accrual Operating Unit ID
AccrualOpUnitName	Accrual Operating Unit Name	String	Accrual Operating Unit Name
AccrualReportingType	Accrual Reporting Type	String	Reporting Type Name accrual is based on
TimeCodeGroupName	Time Code Group Name	String	Time Code Group Name accrual is based on
CarryExpired	Carry Over Expired
CarryOverAmount	Carry Over Amount	Decimal	Carry Over Amount Allowed
CarryOverType	Carry Over Type	String	Carry Over Type
LimitAmount	Limit Amount	Decimal	Hours Limit
NewYear	New Year	String
RateType	Rate Type	String	Accrual Rate Type
PeriodStatus	Period Status	String	Unlocked Period Computed Period Computed Ending Balance
AccruedHours	Accrued Hours	Decimal	Accrued Hours
BankHours	Bank Hours	Decimal	Bank Hours
CompHours	Comp Hours	Decimal	Comp Hours
ManuallyAdded	Adjusted Balance	Decimal	Adjusted Balance
SavedHours	Unapplied Accrual Hours above limit	Decimal	Unapplied Accrual Hours above limit
TakenHours	Hours Taken	Decimal	Hours Taken
EndingBalance	Ending Balance	Decimal	Ending Balance