|
EMPLOYEE DEFINITIONS GUIDE
| |
|
|
|
*Required Data |
Column Name |
Data Type |
Length |
Example |
Default |
Required |
| Employee Number |
Character |
10 |
0A1234 |
None |
Yes |
| Username |
Character |
20 |
Adminuser01 |
None |
Yes |
| Password |
Character |
20 |
Ps$23erT |
None |
Yes |
| Prefix |
Character |
5 |
Mr |
None |
No |
| Last Name |
Character |
30 |
Gates |
None |
Yes |
| First Name |
Character |
30 |
Bill |
None |
Yes |
| Middle Initial |
Character |
1 |
W |
None |
No |
| Suffix |
Character |
5 |
Sr |
None |
No |
| Hire Date |
Date |
mm/dd/yyyy |
2004-10-13 |
None |
Yes |
| Home Street Address1 |
Character |
50 |
1234 Main |
None |
No |
| Home Street Address2 |
Character |
50 |
Apt # 123 |
None |
No |
| City |
Character |
30 |
Houston |
None |
No |
| State |
Character |
20 |
TX |
None |
No |
| ZIP |
Character |
10 |
77058-1102 |
None |
No |
| Country |
Character |
50 |
USA |
None |
No |
| Gender |
Character |
1 |
M |
M |
No |
| F |
| Birthday |
Date |
|
1970-1-1 |
None |
No |
| Email Address |
Character |
100 |
Joe@mycomp.com |
None |
No |
| Alt Email Address |
Character |
100 |
Joe@hotmail.com |
None |
No |
| Cell Number |
Character |
14 |
281-218-1111 |
None |
No |
| Pager Number |
Character |
14 |
281-650-1111 |
None |
No |
| Office Phone |
Character |
14 |
281-111-1111 |
None |
No |
| Home Phone |
|
14 |
281-111-1111 |
None |
No |
| Social Security Number |
Character |
9 |
111071111 |
None |
No |
| Country of Citizenship |
Character |
30 |
USA |
None |
No |
| Immigration Status |
Character |
30 |
H1B |
None |
No |
| Ethnicity |
Character |
15 |
Asian |
None |
No |
| Black |
| White |
| Hispanic |
| Latino |
| Native Hawaiian |
| Pacific Islander |
| Exempt Status |
Character |
10 |
Exempt |
Non-Exempt |
Yes |
| Non-Exempt |
| Organization |
Character |
10 |
OH |
First one
It finds in
the
Organiza
tion table |
No |
| Employee Type |
Character |
50 |
Full Time Unbenefited |
Full
Time
Benefited |
Yes |
Full Time
Benefited |
| Part Time |
| Consultant |
Temporary
Worker |
| Employment Status |
Boolean |
|
TRUE |
TRUE |
No |
| FALSE |
| Emergency Contact |
Character |
40 |
John Doe hubby |
None |
No |
| Emergency Contact Phone |
Character |
14 |
2812811111 |
None |
No |
| Office Location |
Character |
15 |
JSC Bldg 11 |
None |
No |
| Comments |
Character |
1024 |
Some comments go here |
None |
No |
|
|
| |
|
