FIELD NAME |
TYPE |
LENGTH |
QRY |
MOD |
INS |
REQ INS |
VALIDATE |
REL |
ListID |
Varchar |
36 |
True |
False |
False |
N/A |
String |
|
TimeCreated |
Timestamp |
27 |
True |
False |
False |
N/A |
CCCC-MM-DDThh:mm:ssZ |
|
TimeModified |
Timestamp |
27 |
True |
False |
False |
N/A |
CCCC-MM-DDThh:mm:ssZ |
|
EditSequence |
Varchar |
16 |
True |
False |
False |
N/A |
String |
|
Name |
Varchar |
41 |
True |
False |
False |
N/A |
String |
|
IsActive |
Bit |
5 |
True |
True |
True |
No |
1 0 true false |
|
Salutation |
Varchar |
15 |
True |
True |
True |
No |
String |
|
FirstName |
Varchar |
25 |
True |
True |
True |
No |
String |
|
MiddleName |
Varchar |
5 |
True |
True |
True |
No |
String |
|
LastName |
Varchar |
25 |
True |
True |
True |
No |
String |
|
EmployeeAddressAddr1 |
Varchar |
41 |
True |
True |
True |
No |
String |
|
EmployeeAddressAddr2 |
Varchar |
41 |
True |
True |
True |
No |
String |
|
EmployeeAddressCity |
Varchar |
31 |
True |
True |
True |
No |
String |
|
EmployeeAddressState |
Varchar |
21 |
True |
True |
True |
No |
String |
|
EmployeeAddressPostalCode |
Varchar |
13 |
True |
True |
True |
No |
String |
|
PrintAs |
Varchar |
41 |
True |
True |
True |
No |
String |
|
Phone |
Varchar |
21 |
True |
True |
True |
No |
String |
|
Mobile |
Varchar |
21 |
True |
True |
True |
No |
String |
|
Pager |
Varchar |
21 |
True |
True |
True |
No |
String |
|
PagerPIN |
Varchar |
10 |
True |
True |
True |
No |
String |
|
AltPhone |
Varchar |
21 |
True |
True |
True |
No |
String |
|
Fax |
Varchar |
21 |
True |
True |
True |
No |
String |
|
SSN |
Varchar |
15 |
True |
False |
True |
No |
String |
|
Email |
Varchar |
1023 |
True |
False |
True |
No |
String |
|
EmployeeType |
Varchar |
9 |
True |
False |
True |
No |
Regular Officer Statutory Owner |
|
Gender |
Varchar |
6 |
True |
False |
True |
No |
Female Male |
|
HiredDate |
Date |
10 |
True |
False |
True |
No |
CCCC-MM-DD |
|
ReleasedDate |
Date |
10 |
True |
False |
True |
No |
CCCC-MM-DD |
|
BirthDate |
Date |
10 |
True |
True |
True |
No |
CCCC-MM-DD |
|
AccountNumber |
Varchar |
99 |
True |
True |
True |
No |
String |
|
Notes |
Varchar |
4096 |
True |
True |
True |
No |
String |
|
BillingRateRefListID |
Varchar |
36 |
True |
False |
True |
No |
String |
|
BillingRateRefFullName |
Varchar |
31 |
True |
True |
True |
No |
String |
|
PayrollInfoPayPeriod |
Varchar |
11 |
True |
True |
True |
No |
Daily Weekly Biweekly Semimonthly Monthly Quarterly Yearly |
|
PayrollInfoClassRefListID |
Varchar |
36 |
True |
False |
True |
No |
String |
|
PayrollInfoClassRefFullName |
Varchar |
159 |
True |
True |
True |
No |
String |
|
PayrollInfoEarningsClearEarnings |
Bit |
5 |
True |
True |
True |
No |
1 0 true false |
|
PayrollInfoEarningsSeqNo |
Integer |
13 |
True |
False |
False |
N/A |
SubSeqNo |
|
PayrollInfoEarningsPayrollItemWageRefListID |
Varchar |
36 |
True |
False |
True |
No |
String |
|
PayrollInfoEarningsPayrollItemWageRefFullName |
Varchar |
31 |
True |
True |
True |
No |
String |
|
PayrollInfoEarningsRate |
Decimal |
14 |
True |
True |
True |
No |
8.5 |
|
PayrollInfoEarningsRatePercent |
Decimal |
13 |
True |
True |
True |
No |
7.5 |
|
PayrollInfoUseTimeDataToCreatePaychecks |
Varchar |
16 |
True |
True |
True |
No |
NotSet UseTimeData DoNotUseTimeData |
|
PayrollInfoSickHoursHoursAvailable |
Double |
15 |
True |
True |
True |
No |
PTnHnMnS |
|
PayrollInfoSickHoursAccrualPeriod |
Varchar |
19 |
True |
True |
True |
No |
BeginningOfYear EveryPaycheck EveryHourOnPaycheck |
|
PayrollInfoSickHoursHoursAccrued |
Double |
15 |
True |
True |
True |
No |
PTnHnMnS |
|
PayrollInfoSickHoursMaximumHours |
Double |
15 |
True |
True |
True |
No |
PTnHnMnS |
|
PayrollInfoSickHoursIsResettingHoursEachNewYear |
Bit |
5 |
True |
True |
True |
No |
1 0 true false |
|
PayrollInfoSickHoursHoursUsed |
Double |
15 |
True |
True |
True |
No |
PTnHnMnS |
|
PayrollInfoSickHoursAccrualStartDate |
Date |
10 |
True |
True |
True |
No |
CCCC-MM-DD |
|
PayrollInfoVacationHoursHoursAvailable |
Double |
15 |
True |
True |
True |
No |
PTnHnMnS |
|
PayrollInfoVacationHoursAccrualPeriod |
Varchar |
19 |
True |
True |
True |
No |
BeginningOfYear EveryPaycheck EveryHourOnPaycheck |
|
PayrollInfoVacationHoursHoursAccrued |
Double |
15 |
True |
True |
True |
No |
PTnHnMnS |
|
PayrollInfoVacationHoursMaximumHours |
Double |
15 |
True |
True |
True |
No |
PTnHnMnS |
|
PayrollInfoVacationHoursIsResetHoursEachNewYear |
Bit |
5 |
True |
True |
True |
No |
1 0 true false |
|
PayrollInfoVacationHoursHoursUsed |
Double |
15 |
True |
True |
True |
No |
PTnHnMnS |
|
PayrollInfoVacationHoursAccrualStartDate |
Date |
10 |
True |
True |
True |
No |
CCCC-MM-DD |
|
FQSaveToCache |
Bit |
5 |
True |
True |
True |
No |
FQSaveToCache |
|
FQPrimaryKey |
Varchar |
110 |
True |
False |
False |
N/A |
FQPrimaryKey |
|