|
|
| 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 |
| INC_CASE_ACT_ID |
number |
0 |
|
|
|
|
|
| INC_CASE_ID |
number |
0 |
|
|
|
|
|
| ACTIVITY_CODE_TYPE |
varchar2 |
30 |
|
|
|
|
|
| ACTIVITY_CODE |
varchar2 |
30 |
|
|
|
|
|
| ACTIVITY_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| ACTIVITY_DATE |
date |
7 |
√ |
|
null |
|
|
| CREATOR_ID |
varchar2 |
100 |
√ |
|
null |
|
|
| CREATOR_DATE |
date |
7 |
√ |
|
null |
|
|
| UPDATOR_ID |
varchar2 |
100 |
√ |
|
null |
|
|
| UPDATOR_DATE |
date |
7 |
√ |
|
null |
|
|
| MINUTES_SPENT |
number |
0 |
√ |
|
null |
|
|
| START_DATE |
date |
7 |
√ |
|
null |
|
|
| END_DATE |
date |
7 |
√ |
|
null |
|
|
| REVIEW_DATE |
date |
7 |
√ |
|
null |
|
|
| PRIORITY_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| PRIORITY_CODE_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| PRIORITY_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| STATUS_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| STATUS_CODE_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| STATUS_CODE_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT
ICA.INC_CASE_ACT_ID,
ICA.INC_CASE_ID,
ICA.ACTIVITY_CODE_TYPE,
ICA.ACTIVITY_CODE,
ACTIVITY_CODE.DESCRIPTION,
ICA.ACTIVITY_DATE,
ICA.CREATOR_ID,
ICA.CREATOR_DATE,
ICA.UPDATOR_ID,
ICA.UPDATOR_DATE,
ICA.MINUTES_SPENT,
ICA.START_DATE,
ICA.END_DATE,
ICA.REVIEW_DATE,
ICA.PRIORITY_CODE,
ICA.PRIORITY_CODE_TYPE,
PRIORITY_CODE.DESCRIPTION,
ICA.STATUS_CODE,
ICA.STATUS_CODE_TYPE,
STATUS_CODE.DESCRIPTION
FROM INC_CASE_ACTIVITIES ICA
LEFT OUTER JOIN EJS_CODES ACTIVITY_CODE ON ACTIVITY_CODE.CODE_TYPE = ICA.ACTIVITY_CODE_TYPE AND ACTIVITY_CODE.CODE = ICA.ACTIVITY_CODE
LEFT OUTER JOIN EJS_CODES PRIORITY_CODE ON PRIORITY_CODE.CODE_TYPE = ICA.PRIORITY_CODE_TYPE AND PRIORITY_CODE.CODE = ICA.PRIORITY_CODE
LEFT OUTER JOIN EJS_CODES STATUS_CODE ON STATUS_CODE.CODE_TYPE = ICA.STATUS_CODE_TYPE AND STATUS_CODE.CODE = ICA.STATUS_CODE
Possibly Referenced Tables/Views:
