|
|
| Legend: |
| Primary key columns |
| Columns with indexes |
| Implied relationships |
| Excluded column relationships |
| < n > number of related tables |
|
|
| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| EJS_EMP_ID |
number |
30 |
|
|
|
|
|
| LNAME |
raw |
64 |
√ |
|
null |
|
|
| FNAME |
raw |
64 |
√ |
|
null |
|
|
| MIDDLE_NAME |
raw |
64 |
√ |
|
null |
|
|
| EMPLOYEE_ID |
varchar2 |
20 |
√ |
|
null |
|
|
| AGENCY_CODE |
varchar2 |
30 |
|
|
|
|
|
| EMP_TYPE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| NUM_ASSIGNED |
number |
6 |
√ |
|
null |
|
|
| NUM_CLOSED |
number |
6 |
√ |
|
null |
|
|
| NUM_PENDING |
number |
6 |
√ |
|
null |
|
|
| LAST_ASSIGNED_DATE |
date |
7 |
√ |
|
null |
|
|
| TITLE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| LOGIN_ID |
varchar2 |
100 |
√ |
|
null |
|
|
| ETHNICITY_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| SEX_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| RACE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| DOB |
raw |
32 |
√ |
|
null |
|
|
| SSN |
raw |
32 |
√ |
|
null |
|
|
| BLOOD_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| DL_NUMBER |
varchar2 |
30 |
√ |
|
null |
|
|
| DL_STATE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| EMP_LANG_CODE |
varchar2 |
30 |
|
|
|
|
|
| LANG_TYPE_CODE |
varchar2 |
30 |
|
|
|
|
|
| ACTIVE |
varchar2 |
1 |
|
|
|
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT
E.EJS_EMP_ID
,E.ENC_LNAME
,E.ENC_FNAME
,E.ENC_MNAME
,E.EMPLOYEE_ID
,E.AGENCY_CODE
,E.EMP_TYPE_CODE
,E.NUM_ASSIGNED
,E.NUM_CLOSED
,E.NUM_PENDING
,E.LAST_ASSIGNED_DATE
,E.TITLE_CODE
,E.LOGIN_ID
,E.ETHNICITY_CODE
,E.SEX_CODE
,E.RACE_CODE
,E.ENC_DOB
,E.ENC_SSN
,E.BLOOD_CODE
,E.DL_NUMBER
,E.DL_STATE_CODE
,EL.EMP_LANG_CODE
,EL.LANG_TYPE_CODE
,E.ACTIVE
from employees e
, emp_languages el
WHERE e.ejs_emp_id = el.ejs_emp_id
Possibly Referenced Tables/Views:
