TABLE DETAIL REFERENCE: EmployeeAddtionalNote
(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 | |
| 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 | |
| AdditionalNotesRetNoteID | 4 | INTEGER | 4 | True | True | False | False | %11.0f | |
| AdditionalNotesRetDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
| AdditionalNotesRetNote | 12 | VARCHAR | 4095 | 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} | |
| FQPrimaryKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey | |
| CustomFieldLastReviewDate | 12 | VARCHAR | 30 | True | True | True | False | %s | |
| CustomFieldSpecialSkills | 12 | VARCHAR | 30 | True | True | True | False | %s |