|
|
| 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 |
| PERMIT_ID |
number |
0 |
|
|
|
|
| PERMITS.PERMIT_ID
|
Implied Constraint R |
|
| PERMIT_NO |
varchar2 |
40 |
√ |
|
null |
|
|
| PERMIT_TYPE_CODE |
varchar2 |
30 |
|
|
|
|
|
| PERMIT_TYPE_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| PERMIT_STATUS_CODE |
varchar2 |
30 |
|
|
|
|
|
| PERMIT_STATUS_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| PERMIT_REASON_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| PERMIT_REASON_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| APP_DATE |
date |
7 |
√ |
|
null |
|
|
| ISSUED_BY |
varchar2 |
255 |
√ |
|
null |
|
|
| ISSUE_DATE |
date |
7 |
√ |
|
null |
|
|
| PROCESS_DATE |
date |
7 |
√ |
|
null |
|
|
| PROCESSED_BY |
varchar2 |
30 |
√ |
|
null |
|
|
| EXPIRE_DATE |
date |
7 |
√ |
|
null |
|
|
| REVIEW_DATE |
date |
7 |
√ |
|
null |
|
|
| REVIEWED_BY |
varchar2 |
30 |
√ |
|
null |
|
|
| COMMENTS |
varchar2 |
255 |
√ |
|
null |
|
|
| CREATOR_ID |
varchar2 |
100 |
√ |
|
null |
|
|
| CREATOR_DATE |
date |
7 |
√ |
|
null |
|
|
| UPDATOR_ID |
varchar2 |
100 |
√ |
|
null |
|
|
| UPDATOR_DATE |
date |
7 |
√ |
|
null |
|
|
| REC_ID |
number |
0 |
√ |
|
null |
|
|
| AGENCY_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| AGENCY_DESC |
varchar2 |
40 |
√ |
|
null |
|
|
| PURCHASE_TYPE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| PURCHASE_TYPE_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| NEXT_INSPECTION_DATE |
date |
7 |
√ |
|
null |
|
|
| INSPECTED_DATE |
date |
7 |
√ |
|
null |
|
|
| INSPECTED_BY |
varchar2 |
30 |
√ |
|
null |
|
|
| NEXT_REVIEW_DATE |
date |
7 |
√ |
|
null |
|
|
| PERMIT_ROLE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| PERMIT_ROLE_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| LNAME |
varchar2 |
100 |
√ |
|
null |
|
|
| FNAME |
varchar2 |
80 |
√ |
|
null |
|
|
| PERSON_NAME |
varchar2 |
181 |
√ |
|
null |
|
|
| NAME_TYPE_CODE |
varchar2 |
30 |
|
|
|
|
|
| NAME_TYPE_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT
P.PERMIT_ID
, P.PERMIT_NO
, P.PERMIT_TYPE_CODE
, (SELECT TYP.DESCRIPTION FROM EJS_CODES TYP WHERE TYP.CODE = P.PERMIT_TYPE_CODE AND TYP.CODE_TYPE = P.PERMIT_TYPE_CODE_TYPE)
, P.PERMIT_STATUS_CODE
, (SELECT ST.DESCRIPTION FROM EJS_CODES ST WHERE ST.CODE = P.PERMIT_STATUS_CODE AND ST.CODE_TYPE = P.PERMIT_STATUS_CODE_TYPE)
, P.PERMIT_REASON_CODE
, (SELECT RSN.DESCRIPTION FROM EJS_CODES RSN WHERE RSN.CODE = P.PERMIT_REASON_CODE AND RSN.CODE_TYPE = P.PERMIT_REASON_CODE_TYPE)
, P.APP_DATE
, P.ISSUED_BY
, P.ISSUE_DATE
, P.PROCESS_DATE
, P.PROCESSED_BY
, P.EXPIRE_DATE
, P.REVIEW_DATE
, P.REVIEWED_BY
, P.COMMENTS
, P.CREATOR_ID
, P.CREATOR_DATE
, P.UPDATOR_ID
, P.UPDATOR_DATE
--, PERMIT_REASON_CODE_TYPE
--, PERMIT_STATUS_CODE_TYPE
--, PERMIT_TYPE_CODE_TYPE
, P.REC_ID
, P.AGENCY_CODE
, (SELECT AG.AGENCY_DESC FROM AGENCY_CODES AG WHERE AG.AGENCY_CODE = P.AGENCY_CODE)
--, P.PURCHASE_TYPE_CODE_TYPE
, P.PURCHASE_TYPE_CODE
, (SELECT PUR.DESCRIPTION FROM EJS_CODES PUR WHERE PUR.CODE = P.PURCHASE_TYPE_CODE AND PUR.CODE_TYPE = P.PURCHASE_TYPE_CODE_TYPE)
, P.NEXT_INSPECTION_DATE
, P.INSPECTED_DATE
, P.INSPECTED_BY
, P.NEXT_REVIEW_DATE
, PP.permit_role_code
, (SELECT R.DESCRIPTION FROM EJS_CODES R WHERE R.CODE = PP.PERMIT_ROLE_CODE AND R.CODE_TYPE = PP.PERMIT_ROLE_CODE_TYPE)
, MN.LNAME
, MN.FNAME
, MN.FNAME||' '||LNAME
, MN.NAME_TYPE_CODE
, (SELECT N.DESCRIPTION FROM EJS_CODES N WHERE N.CODE = MN.NAME_TYPE_CODE AND N.CODE_TYPE = MN.NAME_TYPE_CODE_TYPE)
FROM PERMITS P
INNER JOIN PERMIT_PEOPLE PP ON P.PERMIT_ID = PP.PERMIT_ID
INNER JOIN PEOPLE PEOP ON PP.PERSON_ID = PEOP.PERSON_ID
INNER JOIN MASTER_NAMES MN ON PEOP.PERSON_ID = MN.PER_PERSON_ID
WHERE NAME_TYPE_CODE = 'P'
Possibly Referenced Tables/Views:
