Details:Employee

TABLE DETAIL REFERENCE: Employee

(USA VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE	RELATES TO
ListID	12	VARCHAR	36	True	False	False	False	%s	Yes
TimeCreated	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
TimeModified	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
EditSequence	12	VARCHAR	16	True	False	False	False	%s
Name	12	VARCHAR	41	True	False	False	False	%s
IsActive	-7	BIT	1	True	True	True	False	1 0 true false
Salutation	12	VARCHAR	15	True	True	True	False	%s
FirstName	12	VARCHAR	25	True	True	True	False	%s
MiddleName	12	VARCHAR	5	True	True	True	False	%s
LastName	12	VARCHAR	25	True	True	True	False	%s
JobTitle	12	VARCHAR	41	True	True	True	False	%s
SupervisorRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
SupervisorRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
Department	12	VARCHAR	31	True	True	True	False	%s
Description	12	VARCHAR	64	True	True	True	False	%s
TargetBonus	3	DECIMAL	17	True	True	True	False	%10.2f
EmployeeAddressAddr1	12	VARCHAR	41	True	True	True	False	%s
EmployeeAddressAddr2	12	VARCHAR	41	True	True	True	False	%s
EmployeeAddressCity	12	VARCHAR	31	True	True	True	False	%s
EmployeeAddressState	12	VARCHAR	21	True	True	True	False	%s
EmployeeAddressProvince	12	VARCHAR	21	True	True	True	False	%s
EmployeeAddressCounty	12	VARCHAR	21	True	True	True	False	%s
EmployeeAddressPostalCode	12	VARCHAR	13	True	True	True	False	%s
PrintAs	12	VARCHAR	41	True	True	True	False	%s
Phone	12	VARCHAR	21	True	True	True	False	%s
Mobile	12	VARCHAR	21	True	True	True	False	%s
Pager	12	VARCHAR	21	True	True	True	False	%s
PagerPIN	12	VARCHAR	10	True	True	True	False	%s
AltPhone	12	VARCHAR	21	True	True	True	False	%s
Fax	12	VARCHAR	21	True	True	True	False	%s
SSN	12	VARCHAR	11	True	False	True	False	%s
SIN	12	VARCHAR	11	True	False	True	False	%s
NiNumber	12	VARCHAR	11	True	False	True	False	%s
MaritalStatus	12	VARCHAR	6	True	False	False	False	Single Married
Email	12	VARCHAR	1023	True	True	True	False	%s
AdditionalContactRef1ContactName	12	VARCHAR	40	True	True	True	False	%s
AdditionalContactRef1ContactValue	12	VARCHAR	255	True	True	True	False	%s
AdditionalContactRef2ContactName	12	VARCHAR	40	True	True	True	False	%s
AdditionalContactRef2ContactValue	12	VARCHAR	255	True	True	True	False	%s
AdditionalContactRef3ContactName	12	VARCHAR	40	True	True	True	False	%s
AdditionalContactRef3ContactValue	12	VARCHAR	255	True	True	True	False	%s
AdditionalContactRef4ContactName	12	VARCHAR	40	True	True	True	False	%s
AdditionalContactRef4ContactValue	12	VARCHAR	255	True	True	True	False	%s
AdditionalContactRef5ContactName	12	VARCHAR	40	True	True	True	False	%s
AdditionalContactRef5ContactValue	12	VARCHAR	255	True	True	True	False	%s
AdditionalContactRef6ContactName	12	VARCHAR	40	True	True	True	False	%s
AdditionalContactRef6ContactValue	12	VARCHAR	255	True	True	True	False	%s
AdditionalContactRef7ContactName	12	VARCHAR	40	True	True	True	False	%s
AdditionalContactRef7ContactValue	12	VARCHAR	255	True	True	True	False	%s
AdditionalContactRef8ContactName	12	VARCHAR	40	True	True	True	False	%s
AdditionalContactRef8ContactValue	12	VARCHAR	255	True	True	True	False	%s
EmergencyContactsPrimaryContactName	12	VARCHAR	41	True	True	True	False	%s
EmergencyContactsPrimaryContactValue	12	VARCHAR	255	True	True	True	False	%s
EmergencyContactsPrimaryContactRelation	12	VARCHAR	9	True	True	True	False	Spouse Partner Mother Father Sister Brother Son Daughter Friend Other
EmergencyContactsSecondaryContactName	12	VARCHAR	41	True	True	True	False	%s
EmergencyContactsSecondaryContactValue	12	VARCHAR	255	True	True	True	False	%s
EmergencyContactsSecondaryContactRelation	12	VARCHAR	9	True	True	True	False	Spouse Partner Mother Father Sister Brother Son Daughter Friend Other
EmployeeType	12	VARCHAR	9	True	False	True	False	Regular Officer Statutory Owner
PartOrFullTime	12	VARCHAR	9	True	True	True	False	PartTime FullTime
Exempt	12	VARCHAR	9	True	True	True	False	Exempt NonExempt
KeyEmployee	12	VARCHAR	9	True	True	True	False	Yes No
Gender	12	VARCHAR	6	True	False	True	False	Female Male
Sex	12	VARCHAR	6	True	False	True	False	Female Male
HiredDate	9	DATE	6	True	False	True	False	CCCC-MM-DD
OriginalHireDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
AdjustedServiceDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
ReleasedDate	9	DATE	6	True	False	True	False	CCCC-MM-DD
BirthDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
USCitizen	12	VARCHAR	9	True	True	True	False	Yes No
Ethnicity	12	VARCHAR	15	True	True	True	False	AmericianIndian Asian Black Hawaiian Hispanic White TwoOrMoreRaces
Disabled	12	VARCHAR	9	True	True	True	False	Yes No
DisabilityDesc	12	VARCHAR	25	True	True	True	False	%s
OnFile	12	VARCHAR	9	True	True	True	False	Yes No
WorkAuthExpireDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
USVeteran	12	VARCHAR	9	True	True	True	False	Yes No
MilitaryStatus	12	VARCHAR	9	True	True	True	False	Active Reserve
AccountNumber	12	VARCHAR	99	True	True	True	False	%s
Notes	12	VARCHAR	4096	True	True	True	False	%s
BillingRateRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
BillingRateRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
PayrollInfoPayPeriod	12	VARCHAR	11	True	True	True	False	Daily Weekly Biweekly Semimonthly Monthly Quarterly Yearly
PayrollInfoClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PayrollInfoClassRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
PayrollInfoUseTimeDataToCreatePaychecks	12	VARCHAR	16	True	True	True	False	NotSet UseTimeData DoNotUseTimeData
PayrollInfoSickHoursHoursAvailable	8	DOUBLE	8	True	True	True	False	PTnHnMnS
PayrollInfoSickHoursAccrualPeriod	12	VARCHAR	19	True	True	True	False	BeginningOfYear EveryPaycheck EveryHourOnPaycheck
PayrollInfoSickHoursHoursAccrued	8	DOUBLE	8	True	True	True	False	PTnHnMnS
PayrollInfoSickHoursMaximumHours	8	DOUBLE	8	True	True	True	False	PTnHnMnS
PayrollInfoSickHoursIsResettingHoursEachNewYear	-7	BIT	1	True	True	True	False	1 0 true false
PayrollInfoSickHoursHoursUsed	8	DOUBLE	8	True	True	True	False	PTnHnMnS
PayrollInfoSickHoursAccrualStartDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
PayrollInfoVacationHoursHoursAvailable	8	DOUBLE	8	True	True	True	False	PTnHnMnS
PayrollInfoVacationHoursAccrualPeriod	12	VARCHAR	19	True	True	True	False	BeginningOfYear EveryPaycheck EveryHourOnPaycheck
PayrollInfoVacationHoursHoursAccrued	8	DOUBLE	8	True	True	True	False	PTnHnMnS
PayrollInfoVacationHoursMaximumHours	8	DOUBLE	8	True	True	True	False	PTnHnMnS
PayrollInfoVacationHoursIsResetHoursEachNewYear	-7	BIT	1	True	True	True	False	1 0 true false
PayrollInfoVacationHoursHoursUsed	8	DOUBLE	8	True	True	True	False	PTnHnMnS
PayrollInfoVacationHoursAccrualStartDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
ExternalGUID	12	VARCHAR	40	True	False	True	False	{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}
CustomFieldLastReviewDate	12	VARCHAR	30	True	True	True	False	%s
CustomFieldSpecialSkills	12	VARCHAR	30	True	True	True	False	%s

QODBC.com Tools for QuickBooks