Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
emplid | varchar | 11 | √ | null |
|
|
||
name_type | varchar | 3 | √ | null |
|
|
||
effdt | timestamp | 22 | √ | null |
|
|
||
name | varchar | 50 | √ | null |
|
|
||
name_prefix | varchar | 4 | √ | null |
|
|
||
name_title | varchar | 30 | √ | null |
|
|
||
last_name | varchar | 30 | √ | null |
|
|
||
first_name | varchar | 30 | √ | null |
|
|
||
middle_name | varchar | 30 | √ | null |
|
|
||
eff_status | varchar | 1 | √ | null |
|
|
Table contained 0 rows