|
|
| 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 |
| COUNT |
number |
0 |
√ |
|
null |
|
|
| TIME_CATEGORY_DESC |
varchar2 |
50 |
√ |
|
null |
|
|
| TIME_CATEGORY_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| START_DATE |
date |
7 |
√ |
|
null |
|
|
| START_DATE_TIME |
date |
7 |
√ |
|
null |
|
|
| DAY |
varchar2 |
36 |
√ |
|
null |
|
|
| MONTH |
varchar2 |
36 |
√ |
|
null |
|
|
| YEAR |
varchar2 |
4 |
√ |
|
null |
|
|
| AGENCY_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| SHIFT_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| OFFICER_ID |
number |
0 |
√ |
|
null |
|
| OFFICERS.OFFICER_ID
|
Implied Constraint R |
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT
CAST(SUM((AH.END_DATE_TIME - AH.START_DATE_TIME) * 24*60) AS INTEGER) as COUNT,
nvl(ATCC.DESCRIPTION,'Not Specified') as TIME_CATEGORY_DESC, -- wheaaaaa to do
AH.ATC_CODE as TIME_CATEGORY_CODE,
TRUNC(AH.START_DATE_TIME) as START_DATE,
AH.START_DATE_TIME as START_DATE_TIME,
TRIM(TO_CHAR (AH.START_DATE_TIME, 'DAY')) AS DAY,
TRIM(TO_CHAR (AH.START_DATE_TIME, 'MONTH')) AS MONTH,
TRIM(TO_CHAR (AH.START_DATE_TIME, 'YYYY')) AS YEAR,
A.AGENCY_CODE,
A.SHIFT_CODE,
AL.OFFICER_ID
FROM
ACTIVITY_HEADERS AH
INNER JOIN ASSIGNMENTS A ON AH.ASSIGN_ID = A.ASSIGN_ID
INNER JOIN ASSIGNMENT_LOGS AL ON A.ASSIGN_ID = AL.ASSIGN_ID
INNER JOIN ACTIVITY_TIME_CATEGORY_CODES ATCC ON AH.ATC_CODE = ATCC.ATC_CODE
GROUP BY
nvl(ATCC.DESCRIPTION,'Not Specified'),
AH.ATC_CODE,
TRUNC(AH.START_DATE_TIME),
AH.START_DATE_TIME,
TO_CHAR (AH.START_DATE_TIME, 'DAY'),
TO_CHAR (AH.START_DATE_TIME, 'MONTH'),
TO_CHAR (AH.START_DATE_TIME, 'YYYY'),
A.AGENCY_CODE,
A.SHIFT_CODE,
AL.OFFICER_ID
ORDER BY TRUNC(AH.START_DATE_TIME) DESC
Possibly Referenced Tables/Views:
