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 | |
| 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 |