Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Status | varchar | 50 | √ | null |
|
|
||
| Employee ID | varchar | 50 | √ | null |
|
|
||
| Company Email | varchar | 110 | √ | null |
|
|
||
| Personal Email | varchar | 110 | √ | null |
|
|
||
| First Name | varchar | 300 | √ | null |
|
|
||
| Last Name | varchar | 300 | √ | null |
|
|
||
| Job Title | varchar | 100 | √ | null |
|
|
||
| Manager ID | varchar | 50 | √ | null |
|
|
||
| Date of Birth | date | 6 | √ | null |
|
|
||
| Birth Year | int | 4 | √ | null |
|
|
||
| Age Group | varchar | 20 | √ | null |
|
|
||
| Seniority Date | datetime | 16,3 | √ | null |
|
|
||
| Tenure | varchar | 20 | √ | null |
|
|
||
| Termination Date | datetime | 16,3 | √ | null |
|
|
||
| Voluntary | varchar | 20 | √ | null |
|
|
||
| Regrettable | varchar | 20 | √ | null |
|
|
||
| Division | varchar | 100 | √ | null |
|
|
||
| Region | varchar | 100 | √ | null |
|
|
||
| Building | varchar | 100 | √ | null |
|
|
||
| Department | varchar | 100 | √ | null |
|
|
||
| Company | varchar | 100 | √ | null |
|
|
||
| Pay Group | varchar | 100 | √ | null |
|
|
||
| Employee Type | varchar | 2000 | √ | null |
|
|
||
| Gender | varchar | 100 | √ | null |
|
|
||
| Ethnic ID | varchar | 2000 | √ | null |
|
|
||
| Disability Status | varchar | 20 | √ | null |
|
|
||
| Veteran Status | varchar | 20 | √ | null |
|
|
||
| Project | varchar | 2000 | √ | null |
|
|
||
| State | varchar | 600 | √ | null |
|
|
||
| SSO Username | varchar | 200 | √ | null |
|
|
||
| Employment Status Code | varchar | 20 | √ | null |
|
|
||
| Last Hire Date | date | 6 | √ | null |
|
|
||
| AVA_insdate | datetime2 | 16 | √ | (getdate()) |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors