|
|
| 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 |
|
|
|
|
|
| EMPLOYEE_ID |
varchar2 |
20 |
√ |
|
null |
|
|
| SSN |
raw |
32 |
√ |
|
null |
|
|
| DOB |
raw |
32 |
√ |
|
null |
|
|
| NUM_ASSIGNED |
number |
6 |
√ |
|
null |
|
|
| NUM_CLOSED |
number |
6 |
√ |
|
null |
|
|
| NUM_PENDING |
number |
6 |
√ |
|
null |
|
|
| OFFICER_ID |
number |
38 |
√ |
|
null |
|
|
| PLACE_OF_BIRTH |
raw |
512 |
√ |
|
null |
|
|
| EMERGENCY_CONTACT |
varchar2 |
255 |
√ |
|
null |
|
|
| EMERGENCY_PHONE |
varchar2 |
14 |
√ |
|
null |
|
|
| LNAME |
raw |
64 |
√ |
|
null |
|
|
| EMP_TYPE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| FNAME |
raw |
64 |
√ |
|
null |
|
|
| DL_NUMBER |
varchar2 |
30 |
√ |
|
null |
|
|
| LOGIN_ID |
varchar2 |
100 |
√ |
|
null |
|
|
| MIDDLE_NAME |
raw |
64 |
√ |
|
null |
|
|
| LONGEVITY_DATE |
date |
7 |
√ |
|
null |
|
|
| ATT_ID |
number |
6 |
√ |
|
null |
|
|
| AGENCY_CODE |
varchar2 |
30 |
|
|
|
|
|
| BLOOD_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| LAST_ASSIGNED_DATE |
date |
7 |
√ |
|
null |
|
|
| DL_STATE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| RACE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| SEX_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| TITLE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| ETHNICITY_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| ACTIVE |
varchar2 |
1 |
|
|
|
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT
EJS_EMP_ID,
EMPLOYEE_ID,
ENC_SSN,
ENC_DOB,
NUM_ASSIGNED,
NUM_CLOSED,
NUM_PENDING,
OFFICER_ID,
ENC_PLACE_OF_BIRTH,
EMERGENCY_CONTACT,
EMERGENCY_PHONE,
ENC_LNAME,
EMP_TYPE_CODE,
ENC_FNAME,
DL_NUMBER,
LOGIN_ID,
ENC_MNAME,
LONGEVITY_DATE,
ATT_ID,
AGENCY_CODE,
BLOOD_CODE,
LAST_ASSIGNED_DATE,
DL_STATE_CODE,
RACE_CODE,
SEX_CODE,
TITLE_CODE,
ETHNICITY_CODE,
ACTIVE
FROM EMPLOYEES
Possibly Referenced Tables/Views:
