|
|
| 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 |
| MASTER_PERSON_ID |
number |
0 |
|
|
|
|
|
| PERSON_ID |
number |
0 |
|
|
|
|
|
| MN_ID |
number |
0 |
|
|
|
|
|
| FNAME |
varchar2 |
80 |
√ |
|
null |
|
|
| MNAME |
varchar2 |
80 |
√ |
|
null |
|
|
| LNAME |
varchar2 |
100 |
√ |
|
null |
|
|
| SSN |
number |
0 |
√ |
|
null |
|
|
| DOB |
date |
7 |
√ |
|
null |
|
|
| SEX_CODE |
varchar2 |
30 |
|
|
|
|
|
| SEX_CODE_TYPE |
varchar2 |
30 |
|
|
|
|
|
| SEX_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| RACE_CODE |
varchar2 |
30 |
|
|
|
|
|
| RACE_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| NAME_TYPE_CODE |
varchar2 |
30 |
|
|
|
|
|
| NAME_TYPE_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| SECURITY_LEVEL_CODE |
number |
0 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT
MP.MASTER_PERSON_ID,
P.PERSON_ID,
MN.MN_ID,
MN.FNAME,
MN.MNAME,
MN.LNAME,
MN.SSN,
MN.DOB,
SC.CODE AS SEX_CODE,
SC.CODE_TYPE AS SEX_CODE_TYPE,
SC.DESCRIPTION AS SEX_DESC,
RC.CODE AS RACE_CODE,
RC.DESCRIPTION AS RACE_DESC,
NTC.CODE AS NAME_TYPE_CODE,
NTC.DESCRIPTION AS NAME_TYPE_DESC,
MP.INDX_SEC_LEVEL_CODE AS SECURITY_LEVEL_CODE
FROM MASTER_PEOPLE MP
INNER JOIN PEOPLE P ON MP.MASTER_PERSON_ID = P.MASTER_PERSON_ID
INNER JOIN MASTER_NAMES MN ON P.PERSON_ID = MN.PER_PERSON_ID
INNER JOIN EJS_CODES SC ON MP.SEX_CODE_TYPE = SC.CODE_TYPE AND MP.SEX_CODE = SC.CODE
INNER JOIN EJS_CODES RC ON MP.RACE_CODE_TYPE = RC.CODE_TYPE AND MP.RACE_CODE = RC.CODE
INNER JOIN EJS_CODES NTC ON MN.NAME_TYPE_CODE_TYPE = NTC.CODE_TYPE AND MN.NAME_TYPE_CODE = NTC.CODE
Possibly Referenced Tables/Views:
