|
|
| 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 |
| EMP_TYPE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| AGENCY_CODE |
varchar2 |
30 |
|
|
|
|
|
| EMPLOYEE_ID |
varchar2 |
20 |
√ |
|
null |
|
|
| LNAME |
raw |
64 |
√ |
|
null |
|
|
| FNAME |
raw |
64 |
√ |
|
null |
|
|
| MIDDLE_NAME |
raw |
64 |
√ |
|
null |
|
|
| EJS_EMP_ID |
number |
30 |
|
|
|
|
|
| ACTIVE |
varchar2 |
1 |
|
|
|
|
|
| LONGEVITY_DATE |
date |
7 |
√ |
|
null |
|
|
| START_DATE |
date |
7 |
√ |
|
null |
|
|
| DOB |
raw |
32 |
√ |
|
null |
|
|
| END_DATE |
date |
7 |
√ |
|
null |
|
|
| RANK_TITLE_CODE |
varchar2 |
5 |
√ |
|
null |
|
|
| SRV_ASSIGN_CODE |
varchar2 |
5 |
√ |
|
null |
|
|
| EMP_CATCD_CAT_CODE |
varchar2 |
5 |
√ |
|
null |
|
|
| ASSIGN_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| SENIORITY_YEARS_MONTHS |
varchar2 |
4000 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT EMPLOYEES.EMP_TYPE_CODE,
EMPLOYEES.AGENCY_CODE,
EMPLOYEES.EMPLOYEE_ID,
EMPLOYEES.ENC_LNAME,
EMPLOYEES.ENC_FNAME,
EMPLOYEES.ENC_MNAME,
EMPLOYEES.EJS_EMP_ID,
EMPLOYEES.ACTIVE,
EMPLOYEES.LONGEVITY_DATE,
EMP_SERVICE_HISTORIES.START_DATE,
EMPLOYEES.ENC_DOB,
EMP_SERVICE_HISTORIES.END_DATE,
EMP_SERVICE_HISTORIES.RANK_TITLE_CODE,
EMP_SERVICE_HISTORIES.SRV_ASSIGN_CODE,
EMP_SERVICE_HISTORIES.EMP_CATCD_CAT_CODE,
EMP_SERVICE_HISTORIES.ASSIGN_CODE,
Emp_Seniority_service(EMPLOYEES.EJS_EMP_ID)
FROM EMP_SERVICE_HISTORIES EMP_SERVICE_HISTORIES,EMPLOYEES
EMPLOYEES
WHERE(EMP_SERVICE_HISTORIES.EJS_EMP_ID(+) = EMPLOYEES.EJS_EMP_ID)
Possibly Referenced Tables/Views:
