EligRule

EligRuleID		BigID	12
CompanyID	Company Identifier	SmallID	12
RuleName		Text	16000	The text name of the rule.
Descrip	Description	Varchar	500	Text description of the rule.
BeneStart	Benefit Start Date	Enum	1		ENUM E On the eligibility date H On the hire date I On the hire date if hired on 1st, 1st of next month otherwise F First of month following hire date Q First of quarter following hire date N Next open enrollment date following the waiting period D The day following the waiting period M First of month following the waiting period R First of quarter following the waiting period O Next open enrollment effective date
FemalesEligFlg	Y/N - females are eligible?	Varchar	1	Y if females are eligible.
MalesEligFlg	Y/N - males are eligible?	Varchar	1	Y if males are eligible.
MaxAgeFlg	Maximum Age Flag	Varchar	1	Y if there is a maximum age?
MaxAge	Maximum Age	Long	12	The maximum age, if MaxAgeFlg = Y
MinAgeFlg	Minimum Age Flag	Varchar	1	Y if there is a minimum age.
MinAge	Minimum Age	Long	12	The minimum age, if MinAgeFlg = Y
MinHours	Minimum Hours	Number	22	Y if there is a minimum number of hours required.
MinHrsFlg	Minimum Hours Flag	Varchar	1	The mimimum hours required, if MinHours = Y
MinLOSMonths	Minimum length of service in months for eligibility	Long	12	For support of the length of service date limits.
MaxLOSMonths	Maximum length of service in months for eligibility	Long	12	For support of the length of service date limits.
MinHireDate	Min Hire date for eligibility	Date	32	For support of the hire date limits.
MaxHireDate	Max Hire date for eligibility	Date	32	For support of the hire date limits.
MinRuleDate	Min Rule date for eligibility	Date	32	For support of the fixed cut-off date limits.
MaxRuleDate	Max Rule date for eligibility	Date	32	For support of the fixed cut-off date limits.
MinSalary	Minimum salary date for eligibility	Number	22	For support of minimum compensation amount added to Elig 5.
WaitPeriod	Waiting Period	Long	12	The waiting period.
WaitPrUnit	Waiting Period Unit	Enum	1	Unit of the waiting period, days, months etc.	ENUM D Days W Weeks M Months Y Years
LstModBy	Last Modified By Name	Varchar	40
LstModDate	Last Modified Date	Date	32
LockSeqNbr	*SYSTEM* Row Sequence Nbr	Long	12