EligCodes

EligRuleID		BigID	12	The unique Rule ID from the EligRule table
EligCodesID		BigID	12	The unique EligCode ID
ExtCodeID	LocationID, DivID, etc.	BigID	12	If this is a division, location, dept, job class, job title, code then the id number of the code goes here. i.e. If this is a location code and Bellevue was chosen then the location code of ‘2’ would go here.
ExtType	Indicates type of EligCode	Enum	1	The type of code that this would be, i.e. salary, empstatus, location, division,job class, state etc.	ENUM L Location V Division D Department C Job Class J Job Title E Employment Status P State/Province S Salary Type Z Zipcode/Postal Code G Age X Gender H Hours worked per week
EmpStatus	Employment Status	Enum	1	If code type is ‘E’ then the status code is put here , ‘F’ Full time, ‘P’ Part time etc.	ENUM
SalaryType	Salary Type (E, N, H, X)	Enum	1	If the code type column is ‘S’ then the salary type is here, ‘S’ salary , ‘H ‘for hourly etc.	ENUM E Salary Exempt H Hourly Non-Exempt N Salary Non-Exempt X Hourly Exempt
State	State Code	Varchar	2	If code type is ‘P’ then state or province code is put here
ZipCode	Zip Code	Varchar	10	If code type is ‘Z’ then zipcode or postal code is sput here
JobClass	Position Class	Varchar	80
LstModBy	Last Modified By Name	Varchar	40
LstModDate	Last Modified Date	Date	32
LockSeqNbr	*SYSTEM* Row Sequence Nbr	Long	12