TABLE DETAIL REFERENCE: Employee

(Online 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	10	True	False	False	False	%s
Organization	-7	BIT	1	True	True	True	False	1 0 true false
Name	12	VARCHAR	100	True	True	True	False	%s
IsActive	-7	BIT	1	True	True	False	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	25	True	True	True	False	%s
LastName	12	VARCHAR	25	True	True	True	False	%s
Suffix	12	VARCHAR	10	True	True	True	False	%s
PrintAs	12	VARCHAR	110	True	True	True	False	%s
Phone	12	VARCHAR	21	True	True	True	False	%s
Mobile	12	VARCHAR	21	True	True	True	False	%s
AltPhone	12	VARCHAR	21	True	True	True	False	%s
Email	12	VARCHAR	100	True	True	True	False	%s
EmployeeNumber	12	VARCHAR	100	True	True	True	False	%s
SSN	12	VARCHAR	100	True	True	True	False	%s
EmployeeAddressAddr1	12	VARCHAR	500	True	True	True	False	%s
EmployeeAddressAddr2	12	VARCHAR	500	True	True	True	False	%s
EmployeeAddressAddr3	12	VARCHAR	500	True	True	True	False	%s
EmployeeAddressAddr4	12	VARCHAR	500	True	True	True	False	%s
EmployeeAddressCity	12	VARCHAR	255	True	True	True	False	%s
EmployeeAddressState	12	VARCHAR	255	True	True	True	False	%s
EmployeeAddressPostalCode	12	VARCHAR	30	True	True	True	False	%s
EmployeeAddressCountry	12	VARCHAR	255	True	True	True	False	%s
BillableTime	-7	BIT	1	True	True	True	False	1 0 true false
BillRate	3	DECIMAL	18	True	True	True	False	%10.7f
BirthDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
Gender	12	VARCHAR	100	True	True	True	False	%s
HiredDate	9	DATE	6	True	False	True	False	CCCC-MM-DD
ReleasedDate	9	DATE	6	True	False	True	False	CCCC-MM-DD