Editing HumanResources.Employee (table)
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone.
Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 388: | Line 388: | ||
| not null | | not null | ||
| | | | ||
− | | Primary key for Employee records. | + | | Primary key for Employee records.PK_Employee_EmployeeID |
|- valign="top" | |- valign="top" | ||
| NationalIDNumber | | NationalIDNumber | ||
Line 394: | Line 394: | ||
| not null | | not null | ||
| | | | ||
− | | Unique national identification number such as a social security number. | + | | Unique national identification number such as a social security number.AK_Employee_NationalIDNumber |
|- valign="top" | |- valign="top" | ||
| ContactID | | ContactID | ||
Line 400: | Line 400: | ||
| not null | | not null | ||
| | | | ||
− | | Identifies the employee in the Contact table. Foreign key to Contact.ContactID. | + | | Identifies the employee in the Contact table. Foreign key to Contact.ContactID. |
|- valign="top" | |- valign="top" | ||
| LoginID | | LoginID | ||
Line 406: | Line 406: | ||
| not null | | not null | ||
| | | | ||
− | | Network login. | + | | Network login.AK_Employee_LoginID |
|- valign="top" | |- valign="top" | ||
| ManagerID | | ManagerID | ||
Line 412: | Line 412: | ||
| null | | null | ||
| | | | ||
− | | Manager to whom the employee is assigned. Foreign Key to Employee. | + | | Manager to whom the employee is assigned. Foreign Key to Employee.MIX_Employee_ManagerID |
|- valign="top" | |- valign="top" | ||
| Title | | Title | ||
Line 418: | Line 418: | ||
| not null | | not null | ||
| | | | ||
− | | Work title such as Buyer or Sales Representative. | + | | Work title such as Buyer or Sales Representative. |
|- valign="top" | |- valign="top" | ||
| BirthDate | | BirthDate | ||
Line 424: | Line 424: | ||
| not null | | not null | ||
| | | | ||
− | | Date of birth. | + | | Date of birth. |
|- valign="top" | |- valign="top" | ||
| MaritalStatus | | MaritalStatus | ||
Line 430: | Line 430: | ||
| not null | | not null | ||
| | | | ||
− | | M = Married, S = Single | + | | M = Married, S = Single |
|- valign="top" | |- valign="top" | ||
| Gender | | Gender | ||
Line 436: | Line 436: | ||
| not null | | not null | ||
| | | | ||
− | | M = Male, F = Female | + | | M = Male, F = Female |
|- valign="top" | |- valign="top" | ||
| HireDate | | HireDate | ||
Line 442: | Line 442: | ||
| not null | | not null | ||
| | | | ||
− | | Employee hired on this date. | + | | Employee hired on this date. |
|- valign="top" | |- valign="top" | ||
| SalariedFlag | | SalariedFlag | ||
Line 448: | Line 448: | ||
| not null | | not null | ||
| (1) | | (1) | ||
− | | Job classification. 0 = Hourly, not exempt from collective bargaining. 1 = Salaried, exempt from collective bargaining. | + | | Job classification. 0 = Hourly, not exempt from collective bargaining. 1 = Salaried, exempt from collective bargaining. |
|- valign="top" | |- valign="top" | ||
| VacationHours | | VacationHours | ||
Line 454: | Line 454: | ||
| not null | | not null | ||
| (0) | | (0) | ||
− | | Number of available vacation hours. | + | | Number of available vacation hours. |
|- valign="top" | |- valign="top" | ||
| SickLeaveHours | | SickLeaveHours | ||
Line 460: | Line 460: | ||
| not null | | not null | ||
| (0) | | (0) | ||
− | | Number of available sick leave hours. | + | | Number of available sick leave hours. |
|- valign="top" | |- valign="top" | ||
| CurrentFlag | | CurrentFlag | ||
Line 466: | Line 466: | ||
| not null | | not null | ||
| (1) | | (1) | ||
− | | 0 = Inactive, 1 = Active | + | | 0 = Inactive, 1 = Active |
|- valign="top" | |- valign="top" | ||
| rowguid | | rowguid | ||
Line 472: | Line 472: | ||
| not null | | not null | ||
| (NEWID()) | | (NEWID()) | ||
− | | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. | + | | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.AK_Employee_rowguid |
|- valign="top" | |- valign="top" | ||
| ModifiedDate | | ModifiedDate | ||
Line 478: | Line 478: | ||
| not null | | not null | ||
| (GETDATE()) | | (GETDATE()) | ||
− | | Date and time the record was last updated. | + | | Date and time the record was last updated. |
|} | |} | ||