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 H On the hire date F First of month following hire date O Next open enrollment effective date I On the hire date if hired on 1st, 1st of next month otherwise M First of month following the waiting period D The day following the waiting period N Next open enrollment date following the waiting period
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
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