|
|
| 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 |
| FLDINT_ID |
number |
0 |
|
|
|
|
|
| FLDINT_DATE |
date |
7 |
|
|
|
|
|
| FLDINT_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| FLDINT_TYPE_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| AGENCY_CODE |
varchar2 |
30 |
|
|
|
|
|
| AGENCY_DESC |
varchar2 |
40 |
√ |
|
null |
|
|
| SUMMARY |
varchar2 |
2000 |
√ |
|
null |
|
|
| AGENCY_ONLY_YN |
varchar2 |
1 |
√ |
|
null |
|
|
| SECURITY_LEVEL |
number |
0 |
√ |
|
null |
|
|
| INTELL_ONLY_YN |
varchar2 |
1 |
√ |
|
null |
|
|
| ADDRESS_ID |
number |
0 |
|
|
|
|
|
| STREET_NUMBER |
varchar2 |
10 |
√ |
|
null |
|
|
| DIRECTION_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| STREET_NAME |
varchar2 |
40 |
√ |
|
null |
|
|
| STREET_TYPE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| STREET_TYPE_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| ADDRESS_SUBTYPE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| ADDRESS_SUBTYPE_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| SUB_NUMBER |
varchar2 |
50 |
√ |
|
null |
|
|
| INTRSECT1_STREET_NUMBER |
varchar2 |
10 |
√ |
|
null |
|
|
| INTRSECT1_DIR |
varchar2 |
30 |
√ |
|
null |
|
|
| INTRSECT1_NAME |
varchar2 |
40 |
√ |
|
null |
|
|
| ADDITIONAL_INFO |
varchar2 |
255 |
√ |
|
null |
|
|
| BEAT |
varchar2 |
30 |
√ |
|
null |
|
|
| SUB_BEAT |
varchar2 |
30 |
√ |
|
null |
|
|
| CITY |
varchar2 |
40 |
√ |
|
null |
|
|
| STATE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| STATE_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| ZIP5 |
varchar2 |
30 |
√ |
|
null |
|
|
| ZIP4 |
varchar2 |
5 |
√ |
|
null |
|
|
| FLDINT_OFFICER_INFO |
varchar2 |
4000 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT F.FLDINT_ID,
F.FLDINT_DATE,
F.FLDINT_TYPE,
(SELECT FT.DESCRIPTION FROM EJS_CODES FT WHERE FT.CODE = F.FLDINT_TYPE AND FT.CODE_TYPE = F.FLDINT_TYPE_TYPE) AS FLDINT_TYPE_DESC,
F.AGENCY_CODE,
(SELECT AG.AGENCY_DESC FROM AGENCY_CODES AG WHERE AG.AGENCY_CODE = F.AGENCY_CODE) AS AGENCY_DESC,
F.SUMMARY,
F.AGENCY_ONLY_YN,
F.SECURITY_LEVEL,
F.INTELL_ONLY_YN,
FA.ADDRESS_ID,
A.STREET_NUMBER,
A.DIRCT_CD_DIRECTION_CODE,
A.STREET_NAME,
A.STREET_CD_STREET_TYPE_CODE,
(SELECT DESCRIPTION FROM EJS_CODES WHERE CODE = A.STREET_CD_STREET_TYPE_CODE AND CODE_TYPE = A.STREET_CD_STREET_TYPE_COD_TYPE) AS STREET_TYPE_DESC,
A.ADDR_SC_ADDRESS_SUBTYPE_CODE,
(SELECT DESCRIPTION FROM EJS_CODES WHERE CODE = A.ADDR_SC_ADDRESS_SUBTYPE_CODE AND CODE_TYPE = A.ADDR_SC_ADDRESS_SUBTYPE_C_TYPE) AS ADDRESS_SUBTYPE_DESC,
A.SUB_NUMBER,
A.INTRSECT1_STREET_NUMBER,
A.INTRSECT1_DIR,
A.INTRSECT1_NAME,
FA.FI_ADDR_COMMENT,
A.BEAT,
A.SUB_BEAT,
A.CITY,
A.STATE_CD_STATE_CODE,
(SELECT ST.DESCRIPTION FROM EJS_CODES ST WHERE ST.CODE = A.STATE_CD_STATE_CODE AND ST.CODE_TYPE = A.STATE_CD_STATE_CODE_TYPE) AS STATE_DESC,
A.ZIP5,
TO_CHAR(A.ZIP4, 'FM0000'),
JOIN(CURSOR(SELECT O.TITLE||' '||O.FNAME||' '||O.LNAME||'-'||O.INTERNAL_ID||'/'||ORC.ROLE_DESC
FROM OFFICERS O, FLDINT_OFFICERS FO, OFFICER_ROLE_CODES ORC
WHERE F.FLDINT_ID = FO.FLDINT_ID
AND FO.OFFICER_ID = O.OFFICER_ID
AND FO.ROLE_CODE = ORC.ROLE_CODE ),' | ')
FROM FIELD_INTERVIEWS F, ADDRESSES A, FLDINT_ADDRESSES FA
WHERE FA.ADDRESS_ID = A.ADDRESS_ID
AND FA.FLDINT_ID = F.FLDINT_ID
Possibly Referenced Tables/Views:
