Employee Table

Back to list of tables.

Column	Data type	Data type name	Length	Can be queried?	Can be updated?	Can be inserted?	Mandatory when inserting?	Format	Refers To	Version introduced in	Edition available in
ListID	12	VARCHAR	36	True	False	False	False	%s	ListID	1.0	US, CA, UK
TimeCreated	93	TIMESTAMP	23	True	False	False	False	CCCC-MM-DDThh:mm:ssZ		1.0	US, CA, UK
TimeModified	93	TIMESTAMP	23	True	False	False	False	CCCC-MM-DDThh:mm:ssZ		1.0	US, CA, UK
EditSequence	12	VARCHAR	16	True	False	False	False	%s		1.0	US, CA, UK
Name	12	VARCHAR	41	True	False	False	False	%s		1.0	US, CA, UK
IsActive	-7	BIT	2	True	True	True	False	1 0 true false		1.0	US, CA, UK
Salutation	12	VARCHAR	15	True	True	True	False	%s		1.0	US, CA, UK
FirstName	12	VARCHAR	25	True	True	True	False	%s		1.0	US, CA, UK
MiddleName	12	VARCHAR	25	True	True	True	False	%s		1.0	US, CA, UK
LastName	12	VARCHAR	25	True	True	True	False	%s		1.0	US, CA, UK
JobTitle	12	VARCHAR	41	True	True	True	False	%s		12.0	US, CA, UK
SupervisorRef_ListID	12	VARCHAR	36	True	True	True	False	%s		13.0	US
SupervisorRef_FullName	12	VARCHAR	159	True	True	True	False	%s		13.0	US
Department	12	VARCHAR	91	True	True	True	False	%s		13.0	US
Description	12	VARCHAR	1023	True	True	True	False	%s		13.0	US
TargetBonus	2	NUMERIC	15	True	True	True	False	%10.2f		13.0	US
EmployeeAddress_Addr1	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
EmployeeAddress_Addr2	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
EmployeeAddress_City	12	VARCHAR	31	True	True	True	False	%s		1.0	US, CA, UK
EmployeeAddress_State	12	VARCHAR	21	True	True	True	False	%s		1.0	US, CA, UK
EmployeeAddress_PostalCode	12	VARCHAR	13	True	True	True	False	%s		1.0	US, CA, UK
PrintAs	12	VARCHAR	41	True	True	True	False	%s		1.0	US, CA, UK
Phone	12	VARCHAR	21	True	True	True	False	%s		1.0	US, CA, UK
Mobile	12	VARCHAR	21	True	True	True	False	%s		2.1	US, CA, UK
Pager	12	VARCHAR	21	True	True	True	False	%s		2.1	US, CA, UK
PagerPIN	12	VARCHAR	10	True	True	True	False	%s		2.1	US, CA, UK
AltPhone	12	VARCHAR	21	True	True	True	False	%s		1.0	US, CA, UK
Fax	12	VARCHAR	21	True	True	True	False	%s		2.1	US, CA, UK
SSN	12	VARCHAR	11	True	False	True	False	%s		2.0	US, CA, UK
SSN	12	VARCHAR	11	True	False	True	False	%s		2.0	US, CA, UK
Email	12	VARCHAR	1023	True	True	True	False	%s		1.0	US, CA, UK
AdditionalContactRef_ContactName1	12	VARCHAR	40	True	True	True	False	%s		12.0	US, CA, UK
AdditionalContactRef_ContactValue1	12	VARCHAR	255	True	True	True	False	%s		12.0	US, CA, UK
AdditionalContactRef_ContactName2	12	VARCHAR	40	True	True	True	False	%s		12.0	US, CA, UK
AdditionalContactRef_ContactValue2	12	VARCHAR	255	True	True	True	False	%s		12.0	US, CA, UK
AdditionalContactRef_ContactName3	12	VARCHAR	40	True	True	True	False	%s		12.0	US, CA, UK
AdditionalContactRef_ContactValue4	12	VARCHAR	255	True	True	True	False	%s		12.0	US, CA, UK
AdditionalContactRef_ContactName4	12	VARCHAR	40	True	True	True	False	%s		12.0	US, CA, UK
AdditionalContactRef_ContactValue4	12	VARCHAR	255	True	True	True	False	%s		12.0	US, CA, UK
AdditionalContactRef_ContactName5	12	VARCHAR	40	True	True	True	False	%s		12.0	US, CA, UK
AdditionalContactRef_ContactValue5	12	VARCHAR	255	True	True	True	False	%s		12.0	US, CA, UK
AdditionalContactRef_ContactName6	12	VARCHAR	40	True	True	True	False	%s		12.0	US, CA, UK
AdditionalContactRef_ContactValue6	12	VARCHAR	255	True	True	True	False	%s		12.0	US, CA, UK
AdditionalContactRef_ContactName7	12	VARCHAR	40	True	True	True	False	%s		12.0	US, CA, UK
AdditionalContactRef_ContactValue7	12	VARCHAR	255	True	True	True	False	%s		12.0	US, CA, UK
AdditionalContactRef_ContactName8	12	VARCHAR	40	True	True	True	False	%s		12.0	US, CA, UK
AdditionalContactRef_ContactValue8	12	VARCHAR	255	True	True	True	False	%s		12.0	US, CA, UK
EmployeeType	12	VARCHAR	9	True	False	True	False	Regular Officer Statutory Owner		1.0	US, CA, UK
PartOrFullTime	12	VARCHAR	8	True	True	True	False	PartTime FullTime		13.0	US
Exempt	12	VARCHAR	9	True	True	True	False	Exempt NonExempt		13.0	US
KeyEmployee	12	VARCHAR	3	True	True	True	False	Yes No		13.0	US
Gender	12	VARCHAR	6	True	False	True	False	Female Male		1.0	US, CA, UK
HiredDate	91	DATE	10	True	False	True	False	CCCC-MM-DD		1.0	US, CA, UK
OriginalHireDate	91	DATE	10	True	True	True	False	CCCC-MM-DD		13.0	US
AdjustedServiceDate	91	DATE	10	True	True	True	False	CCCC-MM-DD		13.0	US
ReleasedDate	91	DATE	10	True	False	True	False	CCCC-MM-DD		1.0	US, CA, UK
BirthDate	91	DATE	6	True	True	True	False	CCCC-MM-DD		2.0	US
USCitizen	12	VARCHAR	3	True	True	True	False	Yes No		13.0	US
Ethnicity	12	VARCHAR	15	True	True	True	False	AmericianIndian Asian Black Hawaiian Hispanic White TwoOrMoreRaces		13.0	US
Disabled	12	VARCHAR	3	True	True	True	False	Yes No		13.0	US, CA, UK
DisabilityDesc	12	VARCHAR	25	True	True	True	False	%s		13.0	US
OnFile	12	VARCHAR	3	True	True	True	False	Yes No		13.0	US
WorkAuthExpireDate	91	DATE	6	True	True	True	False	CCCC-MM-DD		13.0	US
USVeteran	12	VARCHAR	3	True	True	True	False	Yes No		13.0	US
MilitaryStatus	12	VARCHAR	7	True	True	True	False	Active Reserve		13.0	US
AccountNumber	12	VARCHAR	99	True	True	True	False	%s		13.0	US, CA, UK
Notes	12	VARCHAR	4095	True	True	True	False	%s		2.1	US, CA, UK
BillingRateRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	6.0	US, CA, UK
BillingRateRef_FullName	12	VARCHAR	31	True	True	True	False	%s	FullName	6.0	US, CA, UK
PayrollInfo_PayPeriod	12	VARCHAR	11	True	True	True	False	Daily Weekly Biweekly Semimonthly Monthly Quarterly Yearly		2.0	US, CA, UK
PayrollInfo_ClassRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	2.0	US, CA, UK
PayrollInfo_ClassRef_FullName	12	VARCHAR	31	True	True	True	False	%s	FullName	2.0	US, CA, UK
PayrollInfo_IsUsingTimeDataToCreatePaychecks	-7	BIT	2							2.0	US, CA, UK
PayrollInfo_UseTimeDataToCreatePaychecks	12	VARCHAR	16	True	True	True	False	NotSet UseTimeData DoNotUseTimeData		3.0	US, CA, UK
PayrollInfo_SickHours_HoursAvailable	12	VARCHAR	15	True	True	True	False	PTnHnMnS		2.0	US, CA, UK
PayrollInfo_SickHours_AccrualPeriod	12	VARCHAR	19	True	True	True	False	BeginningOfYear EveryPaycheck EveryHourOnPaycheck		2.0	US, CA, UK
PayrollInfo_SickHours_HoursAccrued	8	VARCHAR	8	True	True	True	False	PTnHnMnS		2.0	US, CA, UK
PayrollInfo_SickHoursMaximumHours	12	VARCHAR	15	True	True	True	False	PTnHnMnS		2.0	US, CA, UK
PayrollInfo_SickHours_IsResettingHoursEachNewYear	-7	BIT	2	True	True	True	False	1 0 true false		2.0	US, CA, UK
PayrollInfo_SickHours_HoursUsed	12	VARCHAR	15	True	True	True	False	PTnHnMnS		5.0	US, CA, UK
PayrollInfo_SickHours_AccrualStartDate	91	DATE	10	True	True	True	False	CCCC-MM-DD		5.0	US, CA, UK
ExternalGUID	12	VARCHAR	40	True	False	True	False	{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}		8.0	US, CA, UK
CFBDay	12	VARCHAR	255	True	True	True	False	%s		1.0	US, CA, UK
CFDateoflastraise	12	VARCHAR	255	True	True	True	False	%s		1.0	US, CA, UK
CFSpousesName	12	VARCHAR	255	True	True	True	False	%s		1.0	US, CA, UK

• About Easysoft

• Contact us
• About us
• Clients
• Blog
• Careers

• Products

• ODBC drivers
• JDBC drivers
• Bridges and gateways
• In development

• Services

• Consultancy
• Training
• Custom development

• Licensing

• Product licenses
• Prices

• Support

• Support home
• Solution wizard
• Getting Started Guides
• User Guides
• Knowledge Base

• Search

• Easysoft.com
• Documentation
• Knowledge Base

• Popular Resources

• Developer area
• Client applications

• Legal

• Privacy statement

© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.

• 
• 
•