Model Organization*
Object Name | Object Type | Layer Name |
---|---|---|
AOBORGN | SQL Table | Default |
AORCONT | SQL Table | Default |
AORFUND | SQL Table | Default |
AORJPST | SQL Table | Default |
AORMACC | SQL Table | Default |
AORMAST | SQL Table | Default |
AORMCTL | SQL Table | Default |
AORMDEF | SQL Table | Default |
AORMEDU | SQL Table | Default |
AORMERQ | SQL Table | Default |
AORMGCD | SQL Table | Default |
AORMGCM | SQL Table | Default |
AORMIND | SQL Table | Default |
AORMLOC | SQL Table | Default |
AORMLVL | SQL Table | Default |
AORMNAT | SQL Table | Default |
AORMNED | SQL Table | Default |
AORMPRO | SQL Table | Default |
AORMPUR | SQL Table | Default |
AORMRTO | SQL Table | Default |
APREHIS | SQL Table | Default |
ATVJOBC | SQL Table | Default |
ATVMDIS | SQL Table | Default |
ATVSICC | SQL Table | Default |
SPRADDR | SQL Table | Default |
SPRIDEN | SQL Table | Default |
STVATYP | SQL Table | Default |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AOBORGN_PIDM |   | NUMBER(8,0) | No | * | * |
AOBORGN_EIN |   | VARCHAR2(9) | Yes |   |   |
AOBORGN_BUSINESS |   | VARCHAR2(30) | No |   |   |
AOBORGN_SICC_CODE |   | VARCHAR2(4) | Yes |   | * |
AOBORGN_MATCH_PCT |   | NUMBER(3,0) | Yes |   |   |
AOBORGN_MATCH_ORG_MAX |   | NUMBER(11,2) | Yes |   |   |
AOBORGN_MATCH_PERSON_MAX |   | NUMBER(11,2) | Yes |   |   |
AOBORGN_ATYP_CODE |   | VARCHAR2(2) | Yes |   | * |
AOBORGN_JOBC_CODE |   | VARCHAR2(3) | Yes |   | * |
AOBORGN_TITLE_CONTACT |   | VARCHAR2(60) | Yes |   |   |
AOBORGN_LAST_NAME_CONTACT |   | VARCHAR2(60) | Yes |   |   |
AOBORGN_FIRST_NAME_CONTACT |   | VARCHAR2(60) | Yes |   |   |
AOBORGN_MI_CONTACT |   | VARCHAR2(60) | Yes |   |   |
AOBORGN_ACTIVITY_DATE |   | DATE | No |   |   |
AOBORGN_MG_PIDM |   | NUMBER(8,0) | Yes |   |   |
AOBORGN_EMPL_CNT |   | NUMBER(9,0) | Yes |   |   |
AOBORGN_EMPL_PT_PROF |   | NUMBER(9,0) | Yes |   |   |
AOBORGN_EMPL_FT_PROF |   | NUMBER(9,0) | Yes |   |   |
AOBORGN_TOT_REVENUE |   | NUMBER(12,0) | Yes |   |   |
AOBORGN_TOT_ASSETS |   | NUMBER(12,0) | Yes |   |   |
AOBORGN_TOT_EARNINGS |   | NUMBER(12,0) | Yes |   |   |
AOBORGN_PRE_TAX_PROFIT |   | NUMBER(12,0) | Yes |   |   |
AOBORGN_GRANT_LOW |   | NUMBER(12,0) | Yes |   |   |
AOBORGN_GRANT_HIGH |   | NUMBER(12,0) | Yes |   |   |
AOBORGN_PROP_DEADLINE_MM |   | VARCHAR2(2) | Yes |   |   |
AOBORGN_PROP_DEADLINE_DD |   | VARCHAR2(2) | Yes |   |   |
AOBORGN_YEAR_INC |   | NUMBER(4,0) | Yes |   |   |
AOBORGN_BEG_FY_MM |   | VARCHAR2(2) | Yes |   |   |
AOBORGN_BEG_FY_DD |   | VARCHAR2(2) | Yes |   |   |
AOBORGN_END_FY_MM |   | VARCHAR2(2) | Yes |   |   |
AOBORGN_END_FY_DD |   | VARCHAR2(2) | Yes |   |   |
AOBORGN_OTH_ED_MG_IND |   | VARCHAR2(1) | Yes |   |   |
AOBORGN_STATE_ASSOC_MG_IND |   | VARCHAR2(1) | Yes |   |   |
AOBORGN_DESG_MG_IND |   | VARCHAR2(1) | Yes |   |   |
AOBORGN_MDIS_CODE |   | VARCHAR2(1) | Yes |   | * |
AOBORGN_MDIS_MM |   | VARCHAR2(2) | Yes |   |   |
AOBORGN_MDIS_DD |   | VARCHAR2(2) | Yes |   |   |
AOBORGN_MDIS_DEADLINE_MM |   | VARCHAR2(2) | Yes |   |   |
AOBORGN_MDIS_DEADLINE_DD |   | VARCHAR2(2) | Yes |   |   |
AOBORGN_DUPL_MG_IND |   | VARCHAR2(1) | Yes |   |   |
AOBORGN_MG_ACK_IND |   | VARCHAR2(1) | Yes |   |   |
AOBORGN_MGMT_MG_IND |   | VARCHAR2(1) | Yes |   |   |
AOBORGN_MATCH_PERS_INST_YR |   | NUMBER(11,2) | Yes |   |   |
AOBORGN_MATCH_ORG_CEILING_YR |   | NUMBER(11,2) | Yes |   |   |
AOBORGN_MATCH_ORG_EMPL_YR |   | NUMBER(11,2) | Yes |   |   |
AOBORGN_MATCH_MINIMUM |   | NUMBER(11,2) | Yes |   |   |
AOBORGN_SOCIETY_NAME |   | VARCHAR2(120) | Yes |   |   |
AOBORGN_YEAR_MG |   | NUMBER(4,0) | Yes |   |   |
AOBORGN_FINANCIALS_DATE |   | DATE | Yes |   |   |
AOBORGN_MG_LOAD_UPDATE_DATE |   | DATE | Yes |   |   |
AOBORGN_MG_LOAD_SOURCE |   | VARCHAR2(1) | Yes |   |   |
AOBORGN_MG_RECEIPT_IND |   | VARCHAR2(1) | Yes |   |   |
AOBORGN_MATCH_MAXIMUM |   | NUMBER(11,2) | Yes |   |   |
AOBORGN_PREFIX_CONTACT |   | VARCHAR2(20) | Yes |   |   |
AOBORGN_SUFFIX_CONTACT |   | VARCHAR2(20) | Yes |   |   |
AOBORGN_MG_LOAD_ID |   | VARCHAR2(9) | Yes |   |   |
AOBORGN_DATA_ORIGIN |   | VARCHAR2(30) | Yes |   |   |
AOBORGN_USER_ID |   | VARCHAR2(30) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AOBORGN_SICC_CODE | ATVSICC_CODE | ATVSICC |
AOBORGN_MDIS_CODE | ATVMDIS_CODE | ATVMDIS |
AOBORGN_JOBC_CODE | ATVJOBC_CODE | ATVJOBC |
AOBORGN_ATYP_CODE | STVATYP_CODE | STVATYP |
AOBORGN_PIDM | APREHIS_EMPR_PIDM | APREHIS |
Index Name | Index Type | Column Name |
---|---|---|
PK_AOBORGN | Unique | AOBORGN_PIDM |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_AOBORGN | SQL Index | S10B80.ALUMNI | Rely On |
APREHIS | SQL Table | S10B80.ALUMNI | Join |
ATVJOBC | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVMDIS | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVSICC | SQL Table | S10B80.ALUMNI | Refer (no action) |
STVATYP | SQL Table | S10B80.SATURN | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:42:19:000 | 04/02/2008 13:49:17:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AORCONT_PIDM |   | NUMBER(8,0) | No |   | * |
AORCONT_SEQ_NO |   | NUMBER(23,20) | No |   |   |
AORCONT_CONTACT_PIDM |   | NUMBER(8,0) | Yes |   |   |
AORCONT_LAST_NAME |   | VARCHAR2(60) | Yes |   |   |
AORCONT_FIRST_NAME |   | VARCHAR2(60) | Yes |   |   |
AORCONT_MI |   | VARCHAR2(60) | Yes |   |   |
AORCONT_OCON_CODE |   | VARCHAR2(3) | Yes |   | * |
AORCONT_JOBC_CODE |   | VARCHAR2(3) | Yes |   | * |
AORCONT_TITLE |   | VARCHAR2(60) | Yes |   |   |
AORCONT_ATYP_CODE |   | VARCHAR2(2) | Yes |   | * |
AORCONT_ADDR_LINE1 |   | VARCHAR2(75) | Yes |   |   |
AORCONT_ADDR_LINE2 |   | VARCHAR2(75) | Yes |   |   |
AORCONT_ADDR_LINE3 |   | VARCHAR2(75) | Yes |   |   |
AORCONT_ADDR_LINE4 |   | VARCHAR2(75) | Yes |   |   |
AORCONT_ADDR_CITY |   | VARCHAR2(50) | Yes |   |   |
AORCONT_STAT_CODE_ADDR |   | VARCHAR2(3) | Yes |   | * |
AORCONT_ZIPC_CODE_ADDR |   | VARCHAR2(30) | Yes |   |   |
AORCONT_CNTY_CODE_ADDR |   | VARCHAR2(5) | Yes |   | * |
AORCONT_NATN_CODE_ADDR |   | VARCHAR2(5) | Yes |   | * |
AORCONT_PHONE_AREA |   | VARCHAR2(6) | Yes |   |   |
AORCONT_PHONE_NUMBER |   | VARCHAR2(12) | Yes |   |   |
AORCONT_PHONE_EXT |   | VARCHAR2(10) | Yes |   |   |
AORCONT_DATE |   | DATE | Yes |   |   |
AORCONT_ACTIVITY_DATE |   | DATE | No |   |   |
AORCONT_DELIVERY_POINT |   | NUMBER(2,0) | Yes |   |   |
AORCONT_CORRECTION_DIGIT |   | NUMBER(2,0) | Yes |   |   |
AORCONT_CARRIER_ROUTE |   | VARCHAR2(4) | Yes |   |   |
AORCONT_CONT_ORG_IND |   | VARCHAR2(1) | Yes |   |   |
AORCONT_NAME_PREFIX |   | VARCHAR2(20) | Yes |   |   |
AORCONT_NAME_SUFFIX |   | VARCHAR2(20) | Yes |   |   |
AORCONT_CTRY_CODE_PHONE |   | VARCHAR2(4) | Yes |   |   |
AORCONT_SURNAME_PREFIX |   | VARCHAR2(60) | Yes |   |   |
AORCONT_HOUSE_NUMBER |   | VARCHAR2(10) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AORCONT_PIDM | AOBORGN_PIDM | AOBORGN |
AORCONT_OCON_CODE | ATVOCON_CODE | ATVOCON |
AORCONT_NATN_CODE_ADDR | STVNATN_CODE | STVNATN |
AORCONT_STAT_CODE_ADDR | STVSTAT_CODE | STVSTAT |
AORCONT_JOBC_CODE | ATVJOBC_CODE | ATVJOBC |
AORCONT_CNTY_CODE_ADDR | STVCNTY_CODE | STVCNTY |
AORCONT_ATYP_CODE | STVATYP_CODE | STVATYP |
Index Name | Index Type | Column Name |
---|---|---|
AORCONT_KEY_INDEX |   | AORCONT_PIDM |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
SPRIDEN | SQL Table | S10B80.SATURN | Join |
AOVCONT | SQL View | S10B80.BANINST1 | Use (select) |
F_SECONDARY_CONTACT_ADDRESS | SQL Function | S10B80.BANINST1 | Use (select) |
F_SECONDARY_CONTACT_NAME | SQL Function | S10B80.BANINST1 | Use (select) |
F_SECONDARY_CONTACT_PIDM | SQL Function | S10B80.BANINST1 | Use (select) |
F_SECONDARY_CONTACT_TYPE | SQL Function | S10B80.BANINST1 | Use (select) |
AORCONT_REC | Oracle Package Variable | S10B80.BANINST1.BWDKCPRF | Rely On |
AORCONTVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKCPRF | Use (select)Rely On |
UT_AB_ADV_ORGANIZATIOND_API | Oracle Package Procedure | S10B80.BANINST1.UT_AB_ADV_ORGANIZATION | Use (Insert) |
AORCONT | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AORCONT_KEY_INDEX | SQL Index | S10B80.ALUMNI | Rely On |
AOBORGN | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVJOBC | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVOCON | SQL Table | S10B80.ALUMNI | Refer (no action) |
STVATYP | SQL Table | S10B80.SATURN | Refer (no action) |
STVCNTY | SQL Table | S10B80.SATURN | Refer (no action) |
STVNATN | SQL Table | S10B80.SATURN | Refer (no action) |
STVSTAT | SQL Table | S10B80.SATURN | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:46:01:000 | 04/02/2008 13:49:22:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AORFUND_PIDM |   | NUMBER(8,0) | No | * | * |
AORFUND_FUND_CODE |   | VARCHAR2(6) | No | * | * |
AORFUND_ACTIVITY_DATE |   | DATE | No |   |   |
AORFUND_COMMENT |   | VARCHAR2(60) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AORFUND_PIDM | AOBORGN_PIDM | AOBORGN |
AORFUND_FUND_CODE | ATVFUND_CODE | ATVFUND |
Index Name | Index Type | Column Name |
---|---|---|
PK_AORFUND | Unique | AORFUND_PIDM |
PK_AORFUND | Unique | AORFUND_FUND_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
F_CHECK_FOR_MORE | SQL Function | S10B80.BANINST1 | Use (select) |
F_FUND_INFO | SQL Function | S10B80.BANINST1 | Use (select) |
AORFUND_REC | Oracle Package Variable | S10B80.BANINST1.BWDKCPRF | Rely On |
AORFUNDVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKCPRF | Use (select)Rely On |
UT_AB_ADV_ORGANIZATIOND_API | Oracle Package Procedure | S10B80.BANINST1.UT_AB_ADV_ORGANIZATION | Use (Insert) |
AORFUND | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_AORFUND | SQL Index | S10B80.ALUMNI | Rely On |
AOBORGN | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVFUND | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:45:48:000 | 04/02/2008 13:49:21:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AORJPST_EMPR_PIDM |   | NUMBER(8,0) | No |   | * |
AORJPST_TITLE |   | VARCHAR2(60) | No |   |   |
AORJPST_USER |   | VARCHAR2(30) | No |   |   |
AORJPST_ACTIVITY_DATE |   | DATE | No |   |   |
AORJPST_SUBMIT_DATE |   | DATE | No |   |   |
AORJPST_ACPT_APPL_UNTIL |   | DATE | No |   |   |
AORJPST_CONTACT_NAME |   | VARCHAR2(60) | No |   |   |
AORJPST_DESC |   | VARCHAR2(2000) | No |   |   |
AORJPST_LOCATION |   | VARCHAR2(30) | No |   |   |
AORJPST_DISP_WEB_IND |   | VARCHAR2(1) | No |   |   |
AORJPST_CONTACT_EMAIL |   | VARCHAR2(128) | Yes |   |   |
AORJPST_REVIEWED_IND |   | VARCHAR2(1) | Yes |   |   |
AORJPST_REVIEWED_USER |   | VARCHAR2(30) | Yes |   |   |
AORJPST_EMPL_PIDM |   | NUMBER(8,0) | Yes |   |   |
AORJPST_EMPR_URL |   | VARCHAR2(120) | Yes |   |   |
AORJPST_STREET_LINE1 |   | VARCHAR2(75) | Yes |   |   |
AORJPST_STREET_LINE2 |   | VARCHAR2(75) | Yes |   |   |
AORJPST_STREET_LINE3 |   | VARCHAR2(75) | Yes |   |   |
AORJPST_CITY |   | VARCHAR2(50) | Yes |   |   |
AORJPST_STAT_CODE |   | VARCHAR2(3) | Yes |   | * |
AORJPST_ZIP |   | VARCHAR2(30) | Yes |   |   |
AORJPST_NATN_CODE |   | VARCHAR2(5) | Yes |   |   |
AORJPST_PHONE_AREA |   | VARCHAR2(6) | Yes |   |   |
AORJPST_PHONE_NUMBER |   | VARCHAR2(12) | Yes |   |   |
AORJPST_PHONE_EXT |   | VARCHAR2(10) | Yes |   |   |
AORJPST_FAX_AREA |   | VARCHAR2(6) | Yes |   |   |
AORJPST_FAX_NUMBER |   | VARCHAR2(12) | Yes |   |   |
AORJPST_JOBC_CODE_1 |   | VARCHAR2(3) | Yes |   | * |
AORJPST_JOBC_CODE_2 |   | VARCHAR2(3) | Yes |   | * |
AORJPST_JOBC_CODE_3 |   | VARCHAR2(3) | Yes |   | * |
AORJPST_REQMNT |   | CLOB | No |   |   |
AORJPST_STREET_LINE4 |   | VARCHAR2(75) | Yes |   |   |
AORJPST_HOUSE_NUMBER |   | VARCHAR2(10) | Yes |   |   |
AORJPST_CTRY_CODE_PHONE |   | VARCHAR2(4) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AORJPST_EMPR_PIDM | AOBORGN_PIDM | AOBORGN |
AORJPST_JOBC_CODE_1 | ATVJOBC_CODE | ATVJOBC |
AORJPST_JOBC_CODE_2 | ATVJOBC_CODE | ATVJOBC |
AORJPST_JOBC_CODE_3 | ATVJOBC_CODE | ATVJOBC |
AORJPST_STAT_CODE | STVSTAT_CODE | STVSTAT |
Index Name | Index Type | Column Name |
---|---|---|
AORJPST_EMPL_INDEX |   | AORJPST_EMPL_PIDM |
AORJPST_EMPL_INDEX |   | AORJPST_TITLE |
AORJPST_EMPR_INDEX |   | AORJPST_EMPR_PIDM |
AORJPST_EMPR_INDEX |   | AORJPST_TITLE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AORJPST_EMPL_INDEX | SQL Index | S10B80.ALUMNI | Rely On |
AORJPST_EMPR_INDEX | SQL Index | S10B80.ALUMNI | Rely On |
AOBORGN | SQL Table | S10B80.ALUMNI | Join |
ATVJOBC | SQL Table | S10B80.ALUMNI | Join |
STVSTAT | SQL Table | S10B80.SATURN | Join |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:45:08:000 | 04/02/2008 13:49:20:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AORMACC_PIDM |   | NUMBER(8,0) | No | * | * |
AORMACC_MACC_CODE |   | VARCHAR2(1) | No | * | * |
AORMACC_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AORMACC_PIDM | AOBORGN_PIDM | AOBORGN |
AORMACC_MACC_CODE | ATVMACC_CODE | ATVMACC |
Index Name | Index Type | Column Name |
---|---|---|
PK_AORMACC | Unique | AORMACC_PIDM |
PK_AORMACC | Unique | AORMACC_MACC_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
UT_AB_ADV_ORGANIZATIOND_API | Oracle Package Procedure | S10B80.BANINST1.UT_AB_ADV_ORGANIZATION | Use (Insert) |
AORMACC | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_AORMACC | SQL Index | S10B80.ALUMNI | Rely On |
AOBORGN | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVMACC | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:45:51:000 | 04/02/2008 13:49:21:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AORMAST_PIDM |   | NUMBER(8,0) | No | * | * |
AORMAST_MAST_CODE |   | VARCHAR2(1) | No | * | * |
AORMAST_ACTIVITY_DATE |   | DATE | No |   |   |
AORMAST_ATTEND_YEARS |   | NUMBER(2,0) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AORMAST_PIDM | AOBORGN_PIDM | AOBORGN |
AORMAST_MAST_CODE | ATVMAST_CODE | ATVMAST |
Index Name | Index Type | Column Name |
---|---|---|
PK_AORMAST | Unique | AORMAST_PIDM |
PK_AORMAST | Unique | AORMAST_MAST_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
UT_AB_ADV_ORGANIZATIOND_API | Oracle Package Procedure | S10B80.BANINST1.UT_AB_ADV_ORGANIZATION | Use (Insert) |
P_EVALUATE_MG_ELIGIBILITY | Oracle Package Procedure | S10B80.BANINST1.AXKEXMG | Use (select) |
AORMAST | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_AORMAST | SQL Index | S10B80.ALUMNI | Rely On |
AOBORGN | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVMAST | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:46:09:000 | 04/02/2008 13:49:22:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AORMCTL_PIDM |   | NUMBER(8,0) | No | * | * |
AORMCTL_MCTL_CODE |   | VARCHAR2(1) | No | * | * |
AORMCTL_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AORMCTL_MCTL_CODE | ATVMCTL_CODE | ATVMCTL |
AORMCTL_PIDM | AOBORGN_PIDM | AOBORGN |
Index Name | Index Type | Column Name |
---|---|---|
PK_AORMCTL | Unique | AORMCTL_PIDM |
PK_AORMCTL | Unique | AORMCTL_MCTL_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
UT_AB_ADV_ORGANIZATIOND_API | Oracle Package Procedure | S10B80.BANINST1.UT_AB_ADV_ORGANIZATION | Use (Insert) |
AORMCTL | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_AORMCTL | SQL Index | S10B80.ALUMNI | Rely On |
AOBORGN | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVMCTL | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:41:03:000 | 04/02/2008 13:49:16:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AORMDEF_PIDM |   | NUMBER(8,0) | No | * | * |
AORMDEF_MDEF_CODE |   | VARCHAR2(1) | No | * | * |
AORMDEF_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AORMDEF_MDEF_CODE | ATVMDEF_CODE | ATVMDEF |
AORMDEF_PIDM | AOBORGN_PIDM | AOBORGN |
Index Name | Index Type | Column Name |
---|---|---|
PK_AORMDEF | Unique | AORMDEF_PIDM |
PK_AORMDEF | Unique | AORMDEF_MDEF_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
UT_AB_ADV_ORGANIZATIOND_API | Oracle Package Procedure | S10B80.BANINST1.UT_AB_ADV_ORGANIZATION | Use (Insert) |
AORMDEF | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_AORMDEF | SQL Index | S10B80.ALUMNI | Rely On |
AOBORGN | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVMDEF | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:41:37:000 | 04/02/2008 13:49:16:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AORMEDU_PIDM |   | NUMBER(8,0) | No | * | * |
AORMEDU_MEDU_CODE |   | VARCHAR2(1) | No | * | * |
AORMEDU_USER |   | VARCHAR2(30) | No |   |   |
AORMEDU_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AORMEDU_PIDM | AOBORGN_PIDM | AOBORGN |
AORMEDU_MEDU_CODE | ATVMEDU_CODE | ATVMEDU |
Index Name | Index Type | Column Name |
---|---|---|
PK_AORMEDU | Unique | AORMEDU_PIDM |
PK_AORMEDU | Unique | AORMEDU_MEDU_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
UT_AB_ADV_ORGANIZATIOND_API | Oracle Package Procedure | S10B80.BANINST1.UT_AB_ADV_ORGANIZATION | Use (Insert) |
AORMEDU | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_AORMEDU | SQL Index | S10B80.ALUMNI | Rely On |
AOBORGN | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVMEDU | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:42:25:000 | 04/02/2008 13:49:17:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AORMERQ_PIDM |   | NUMBER(8,0) | No | * | * |
AORMERQ_MERQ_CODE |   | VARCHAR2(1) | No | * | * |
AORMERQ_ACTIVITY_DATE |   | DATE | No |   |   |
AORMERQ_TIME_REQ |   | NUMBER(5,2) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AORMERQ_PIDM | AOBORGN_PIDM | AOBORGN |
AORMERQ_MERQ_CODE | ATVMERQ_CODE | ATVMERQ |
Index Name | Index Type | Column Name |
---|---|---|
PK_AORMERQ | Unique | AORMERQ_PIDM |
PK_AORMERQ | Unique | AORMERQ_MERQ_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
UT_AB_ADV_ORGANIZATIOND_API | Oracle Package Procedure | S10B80.BANINST1.UT_AB_ADV_ORGANIZATION | Use (Insert) |
P_EVALUATE_MG_ELIGIBILITY | Oracle Package Procedure | S10B80.BANINST1.AXKEXMG | Use (select) |
AORMERQ | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_AORMERQ | SQL Index | S10B80.ALUMNI | Rely On |
AOBORGN | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVMERQ | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:42:43:000 | 04/02/2008 13:49:18:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AORMGCD_PIDM |   | NUMBER(8,0) | No | * | * |
AORMGCD_CAMPAIGN |   | VARCHAR2(5) | No | * |   |
AORMGCD_DESG |   | VARCHAR2(10) | No | * |   |
AORMGCD_PERCENT |   | NUMBER(5,2) | No |   |   |
AORMGCD_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AORMGCD_PIDM | AOBORGN_PIDM | AOBORGN |
Index Name | Index Type | Column Name |
---|---|---|
PK_AORMGCD | Unique | AORMGCD_PIDM |
PK_AORMGCD | Unique | AORMGCD_CAMPAIGN |
PK_AORMGCD | Unique | AORMGCD_DESG |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
UT_AB_ADV_ORGANIZATIOND_API | Oracle Package Procedure | S10B80.BANINST1.UT_AB_ADV_ORGANIZATION | Use (Insert) |
AORMGCD | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_AORMGCD | SQL Index | S10B80.ALUMNI | Rely On |
AOBORGN | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:44:15:000 | 04/02/2008 13:49:19:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AORMGCM_PIDM |   | NUMBER(8,0) | No |   | * |
AORMGCM_SEQ_NO |   | NUMBER(9,2) | No |   |   |
AORMGCM_COMMENT |   | VARCHAR2(2000) | No |   |   |
AORMGCM_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AORMGCM_PIDM | AOBORGN_PIDM | AOBORGN |
Index Name | Index Type | Column Name |
---|---|---|
AORMGCM_KEY_INDEX |   | AORMGCM_PIDM |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
UT_AB_ADV_ORGANIZATIOND_API | Oracle Package Procedure | S10B80.BANINST1.UT_AB_ADV_ORGANIZATION | Use (Insert) |
AORMGCM | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AORMGCM_KEY_INDEX | SQL Index | S10B80.ALUMNI | Rely On |
AOBORGN | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:44:16:000 | 04/02/2008 13:49:19:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AORMIND_PIDM |   | NUMBER(8,0) | No | * | * |
AORMIND_MIND_CODE |   | VARCHAR2(1) | No | * | * |
AORMIND_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AORMIND_PIDM | AOBORGN_PIDM | AOBORGN |
AORMIND_MIND_CODE | ATVMIND_CODE | ATVMIND |
Index Name | Index Type | Column Name |
---|---|---|
PK_AORMIND | Unique | AORMIND_PIDM |
PK_AORMIND | Unique | AORMIND_MIND_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
UT_AB_ADV_ORGANIZATIOND_API | Oracle Package Procedure | S10B80.BANINST1.UT_AB_ADV_ORGANIZATION | Use (Insert) |
AORMIND | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_AORMIND | SQL Index | S10B80.ALUMNI | Rely On |
AOBORGN | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVMIND | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:46:24:000 | 04/02/2008 13:49:22:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AORMLOC_PIDM |   | NUMBER(8,0) | No | * | * |
AORMLOC_MLOC_CODE |   | VARCHAR2(1) | No | * | * |
AORMLOC_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AORMLOC_PIDM | AOBORGN_PIDM | AOBORGN |
AORMLOC_MLOC_CODE | ATVMLOC_CODE | ATVMLOC |
Index Name | Index Type | Column Name |
---|---|---|
PK_AORMLOC | Unique | AORMLOC_PIDM |
PK_AORMLOC | Unique | AORMLOC_MLOC_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
UT_AB_ADV_ORGANIZATIOND_API | Oracle Package Procedure | S10B80.BANINST1.UT_AB_ADV_ORGANIZATION | Use (Insert) |
AORMLOC | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_AORMLOC | SQL Index | S10B80.ALUMNI | Rely On |
AOBORGN | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVMLOC | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:42:16:000 | 04/02/2008 13:49:17:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AORMLVL_PIDM |   | NUMBER(8,0) | No | * | * |
AORMLVL_MLVL_CODE |   | VARCHAR2(1) | No | * | * |
AORMLVL_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AORMLVL_PIDM | AOBORGN_PIDM | AOBORGN |
AORMLVL_MLVL_CODE | ATVMLVL_CODE | ATVMLVL |
Index Name | Index Type | Column Name |
---|---|---|
PK_AORMLVL | Unique | AORMLVL_PIDM |
PK_AORMLVL | Unique | AORMLVL_MLVL_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
UT_AB_ADV_ORGANIZATIOND_API | Oracle Package Procedure | S10B80.BANINST1.UT_AB_ADV_ORGANIZATION | Use (Insert) |
AORMLVL | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_AORMLVL | SQL Index | S10B80.ALUMNI | Rely On |
AOBORGN | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVMLVL | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:42:25:000 | 04/02/2008 13:49:17:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AORMNAT_PIDM |   | NUMBER(8,0) | No | * | * |
AORMNAT_MNAT_CODE |   | VARCHAR2(1) | No | * | * |
AORMNAT_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AORMNAT_PIDM | AOBORGN_PIDM | AOBORGN |
AORMNAT_MNAT_CODE | ATVMNAT_CODE | ATVMNAT |
Index Name | Index Type | Column Name |
---|---|---|
PK_AORMNAT | Unique | AORMNAT_PIDM |
PK_AORMNAT | Unique | AORMNAT_MNAT_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
UT_AB_ADV_ORGANIZATIOND_API | Oracle Package Procedure | S10B80.BANINST1.UT_AB_ADV_ORGANIZATION | Use (Insert) |
AORMNAT | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_AORMNAT | SQL Index | S10B80.ALUMNI | Rely On |
AOBORGN | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVMNAT | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:43:45:000 | 04/02/2008 13:49:19:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AORMNED_PIDM |   | NUMBER(8,0) | No | * | * |
AORMNED_MNED_CODE |   | VARCHAR2(3) | No | * | * |
AORMNED_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AORMNED_PIDM | AOBORGN_PIDM | AOBORGN |
AORMNED_MNED_CODE | ATVMNED_CODE | ATVMNED |
Index Name | Index Type | Column Name |
---|---|---|
PK_AORMNED | Unique | AORMNED_PIDM |
PK_AORMNED | Unique | AORMNED_MNED_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
UT_AB_ADV_ORGANIZATIOND_API | Oracle Package Procedure | S10B80.BANINST1.UT_AB_ADV_ORGANIZATION | Use (Insert) |
AORMNED | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_AORMNED | SQL Index | S10B80.ALUMNI | Rely On |
AOBORGN | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVMNED | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:43:49:000 | 04/02/2008 13:49:19:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AORMPRO_PIDM |   | NUMBER(8,0) | No | * | * |
AORMPRO_MPRO_CODE |   | VARCHAR2(1) | No | * | * |
AORMPRO_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AORMPRO_PIDM | AOBORGN_PIDM | AOBORGN |
AORMPRO_MPRO_CODE | ATVMPRO_CODE | ATVMPRO |
Index Name | Index Type | Column Name |
---|---|---|
PK_AORMPRO | Unique | AORMPRO_PIDM |
PK_AORMPRO | Unique | AORMPRO_MPRO_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
UT_AB_ADV_ORGANIZATIOND_API | Oracle Package Procedure | S10B80.BANINST1.UT_AB_ADV_ORGANIZATION | Use (Insert) |
AORMPRO | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_AORMPRO | SQL Index | S10B80.ALUMNI | Rely On |
AOBORGN | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVMPRO | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:46:08:000 | 04/02/2008 13:49:22:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AORMPUR_PIDM |   | NUMBER(8,0) | No | * | * |
AORMPUR_MPUR_CODE |   | VARCHAR2(1) | No | * | * |
AORMPUR_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AORMPUR_PIDM | AOBORGN_PIDM | AOBORGN |
AORMPUR_MPUR_CODE | ATVMPUR_CODE | ATVMPUR |
Index Name | Index Type | Column Name |
---|---|---|
PK_AORMPUR | Unique | AORMPUR_PIDM |
PK_AORMPUR | Unique | AORMPUR_MPUR_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
UT_AB_ADV_ORGANIZATIOND_API | Oracle Package Procedure | S10B80.BANINST1.UT_AB_ADV_ORGANIZATION | Use (Insert) |
P_EVALUATE_MG_ELIGIBILITY | Oracle Package Procedure | S10B80.BANINST1.AXKEXMG | Use (select) |
AORMPUR | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_AORMPUR | SQL Index | S10B80.ALUMNI | Rely On |
AOBORGN | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVMPUR | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:46:12:000 | 04/02/2008 13:49:22:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
AORMRTO_PIDM |   | NUMBER(8,0) | No |   | * |
AORMRTO_ACTIVITY_DATE |   | DATE | No |   |   |
AORMRTO_PERCENT |   | NUMBER(5,2) | Yes |   |   |
AORMRTO_BEG_AMT |   | NUMBER(13,2) | Yes |   |   |
AORMRTO_END_AMT |   | NUMBER(13,2) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
AORMRTO_PIDM | AOBORGN_PIDM | AOBORGN |
Index Name | Index Type | Column Name |
---|---|---|
AORMRTO_KEY_INDEX |   | AORMRTO_PIDM |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
F_MULTIPLE_RATIOS | SQL Function | S10B80.BANINST1 | Use (select) |
UT_AB_ADV_ORGANIZATIOND_API | Oracle Package Procedure | S10B80.BANINST1.UT_AB_ADV_ORGANIZATION | Use (Insert) |
P_EVALUATE_MG_ELIGIBILITY | Oracle Package Procedure | S10B80.BANINST1.AXKEXMG | Use (select) |
F_EMPR_MATCH | Oracle Package Function | S10B80.BANINST1.AXKEXMG | Rely On |
F_EMPR_MATCH | Oracle Package Function | S10B80.BANINST1.AXKEXMG | Use (select) |
AORMRTO | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AORMRTO_KEY_INDEX | SQL Index | S10B80.ALUMNI | Rely On |
AOBORGN | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:41:00:000 | 04/02/2008 13:49:16:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
APREHIS_PIDM |   | NUMBER(8,0) | No | * | * |
APREHIS_SEQ_NO |   | NUMBER(5,0) | No | * |   |
APREHIS_EMPR_NAME |   | VARCHAR2(60) | Yes |   |   |
APREHIS_JOBC_CODE |   | VARCHAR2(3) | Yes |   | * |
APREHIS_EMPL_POSITION |   | VARCHAR2(60) | Yes |   |   |
APREHIS_FROM_DATE |   | DATE | Yes |   |   |
APREHIS_TO_DATE |   | DATE | Yes |   |   |
APREHIS_EMPR_PIDM |   | NUMBER(8,0) | Yes |   |   |
APREHIS_EMPR_ID |   | VARCHAR2(9) | Yes |   |   |
APREHIS_ACTIVITY_DATE |   | DATE | No |   |   |
APREHIS_SICC_CODE |   | VARCHAR2(4) | Yes |   | * |
APREHIS_XREF_CODE |   | VARCHAR2(3) | Yes |   | * |
APREHIS_EMPS_CODE |   | VARCHAR2(1) | Yes |   | * |
APREHIS_WKLY_HOURS |   | NUMBER(5,2) | Yes |   |   |
APREHIS_USER |   | VARCHAR2(30) | No |   |   |
APREHIS_PRIMARY_IND |   | VARCHAR2(1) | Yes |   |   |
APREHIS_ATYP_CODE |   | VARCHAR2(2) | Yes |   |   |
APREHIS_ATYP_SEQNO |   | NUMBER(2,0) | Yes |   |   |
APREHIS_JOBC_CODE2 |   | VARCHAR2(3) | Yes |   |   |
APREHIS_JOBC_CODE3 |   | VARCHAR2(3) | Yes |   |   |
APREHIS_JOBC_CODE4 |   | VARCHAR2(3) | Yes |   |   |
APREHIS_OK_FOR_NOTES_IND |   | VARCHAR2(1) | Yes |   |   |
APREHIS_DISP_NOTES_IND |   | VARCHAR2(1) | Yes |   |   |
APREHIS_DISP_NOTES_DATE |   | DATE | Yes |   |   |
APREHIS_MG_IND |   | VARCHAR2(1) | Yes |   |   |
APREHIS_REVIEWED_IND |   | VARCHAR2(1) | Yes |   |   |
APREHIS_REVIEWED_USER |   | VARCHAR2(30) | Yes |   |   |
APREHIS_COMMENT |   | LONG | Yes |   |   |
APREHIS_COOP_IND |   | VARCHAR2(1) | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
APREHIS_PIDM | APBCONS_PIDM | APBCONS |
APREHIS_SICC_CODE | ATVSICC_CODE | ATVSICC |
APREHIS_XREF_CODE | ATVXREF_CODE | ATVXREF |
APREHIS_EMPS_CODE | ATVEMPS_CODE | ATVEMPS |
APREHIS_JOBC_CODE | ATVJOBC_CODE | ATVJOBC |
APREHIS_PIDM | APRXREF_XREF_PIDM | APRXREF |
Index Name | Index Type | Column Name |
---|---|---|
APREHIS_EMPR_INDEX |   | APREHIS_EMPR_PIDM |
PK_APREHIS | Unique | APREHIS_PIDM |
PK_APREHIS | Unique | APREHIS_SEQ_NO |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AOBORGN | SQL Table | S10B80.ALUMNI | Join |
SPRIDEN | SQL Table | S10B80.SATURN | Join |
APVEHIS | SQL View | S10B80.BANINST1 | Use (select) |
F_JOB_INFO | SQL Function | S10B80.BANINST1 | Use (select) |
EHIS_TYPE | Oracle Package Type | S10B80.BANINST1.BWAKADVS | Rely On |
APREHIS_REC | Oracle Package Variable | S10B80.BANINST1.BWDKSRCH | Rely On |
APREHIS_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPSRC | Rely On |
APREHIS_REC | Oracle Package Variable | S10B80.BANINST1.BWDKCPRF | Rely On |
ACTVEHISVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKCPRF | Use (select)Rely On |
APREHISSEQVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKCPRF | Use (select)Rely On |
APREHISVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPSRC | Use (select)Rely On |
APREHISVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKCPRF | Use (select)Rely On |
APREHISVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWAKADVS | Use (select) |
EMPLOYERVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWAKJPST | Use (select) |
PRIMEHISVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKCPRF | Use (select)Rely On |
P_DISP_GIFT_SUMMARY | Oracle Package Procedure | S10B80.BANINST1.BWAKCPMT | Use (select) |
UT_AB_ADV_INDIVIDUALDELETEAPI | Oracle Package Procedure | S10B80.BANINST1.UT_AB_ADV_INDIVIDUAL | Use (Insert) |
P_CONVERT_SGRDUTY_COMMENTS | Oracle Package Procedure | S10B80.BANINST1.APKSTDI | Use (update) |
P_CREDITCARDPAYMENT | Oracle Package Procedure | S10B80.BANINST1.BWAKCPMT | Use (select) |
P_EVALUATE_MG_ELIGIBILITY | Oracle Package Procedure | S10B80.BANINST1.AXKEXMG | Use (select) |
P_LOAD_EMPLOYER | Oracle Package Procedure | S10B80.BANINST1.APKLDRD | Rely On |
P_LOAD_EMPLOYER | Oracle Package Procedure | S10B80.BANINST1.APKLDRD | Use (Insert,update,select)Rely On |
F_GET_EMPLOYMENT_CHANGES_IND | Oracle Package Function | S10B80.BANINST1.APKWIND | Use (select) |
F_INLONG_APREHIS | Oracle Package Function | S10B80.BANINST1.AOKLONG | Use (select) |
F_LONGTOCHAR_APREHIS | Oracle Package Function | S10B80.BANINST1.AOKLONG | Use (select) |
APREHIS | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
APREHIS_EMPR_INDEX | SQL Index | S10B80.ALUMNI | Rely On |
PK_APREHIS | SQL Index | S10B80.ALUMNI | Rely On |
APBCONS | SQL Table | S10B80.ALUMNI | Refer (no action) |
APRXREF | SQL Table | S10B80.ALUMNI | Join |
ATVEMPS | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVJOBC | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVSICC | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVXREF | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:43:39:000 | 04/02/2008 13:49:19:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
ATVJOBC_CODE |   | VARCHAR2(3) | No | * |   |
ATVJOBC_DESC |   | VARCHAR2(60) | No |   |   |
ATVJOBC_ACTIVITY_DATE |   | DATE | No |   |   |
ATVJOBC_DISP_WEB_IND |   | VARCHAR2(1) | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_ATVJOBC | Unique | ATVJOBC_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AOBORGN | SQL Table | S10B80.ALUMNI | Refer (no action) |
AORCONT | SQL Table | S10B80.ALUMNI | Refer (no action) |
AORJPST | SQL Table | S10B80.ALUMNI | Join |
APREHIS | SQL Table | S10B80.ALUMNI | Refer (no action) |
F_GET_DESC_ALUMNI | SQL Function | S10B80.BANINST1 | Use (select) |
JOBC_TYPE | Oracle Package Type | S10B80.BANINST1.BWAKJPST | Rely On |
ATVJOBC_REC | Oracle Package Variable | S10B80.BANINST1.BWDKSRCH | Rely On |
ATVJOBC_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPSRC | Rely On |
ATVJOBC_REC | Oracle Package Variable | S10B80.BANINST1.BWDKCPRF | Rely On |
ATVJOBC_REC | Oracle Package Variable | S10B80.BANINST1.BWAKJPST | Rely On |
AORJPSTJOBCVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWAKJPST | Use (select) |
ATVJOBCVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKCPRF | Use (select)Rely On |
ATVJOBCVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWAKJPST | Use (select)Rely On |
EHISJOBCVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKSRCH | Use (select)Rely On |
EHISJOBCVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPSRC | Use (select)Rely On |
ATVJOBC_C | Oracle Package Cursor | S10B80.BANINST1.AB_ATVJOBC | Rely On |
ATVJOBC_C | Oracle Package Cursor | S10B80.BANINST1.AB_ATVJOBC | Use (select)Rely On |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_AB_ADV_ORGANIZATION | Use (Insert,select) |
F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.AB_ATVJOBC | Rely On |
F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.AB_ATVJOBC | Rely On |
ATVJOBC | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_ATVJOBC | SQL Index | S10B80.ALUMNI | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:46:22:000 | 04/02/2008 13:49:22:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
ATVMDIS_CODE |   | VARCHAR2(1) | No | * |   |
ATVMDIS_DESC |   | VARCHAR2(30) | No |   |   |
ATVMDIS_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_ATVMDIS | Unique | ATVMDIS_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AOBORGN | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVMDIS_REC | Oracle Package Variable | S10B80.BANINST1.BWDKCPRF | Rely On |
ATVMDISVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKCPRF | Use (select)Rely On |
ATVMDIS_C | Oracle Package Cursor | S10B80.BANINST1.AB_ATVMDIS | Rely On |
ATVMDIS_C | Oracle Package Cursor | S10B80.BANINST1.AB_ATVMDIS | Use (select)Rely On |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_AB_ADV_ORGANIZATION | Use (Insert,select) |
F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.AB_ATVMDIS | Rely On |
F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.AB_ATVMDIS | Rely On |
ATVMDIS | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_ATVMDIS | SQL Index | S10B80.ALUMNI | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:44:26:000 | 04/02/2008 13:49:20:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
ATVSICC_CODE |   | VARCHAR2(4) | No | * |   |
ATVSICC_DESC |   | VARCHAR2(60) | No |   |   |
ATVSICC_ACTIVITY_DATE |   | DATE | No |   |   |
ATVSICC_DISP_WEB_IND |   | VARCHAR2(1) | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_ATVSICC | Unique | ATVSICC_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AOBORGN | SQL Table | S10B80.ALUMNI | Refer (no action) |
APREHIS | SQL Table | S10B80.ALUMNI | Refer (no action) |
F_GET_DESC_ALUMNI | SQL Function | S10B80.BANINST1 | Use (select) |
SICC_TYPE | Oracle Package Type | S10B80.BANINST1.BWAKJPST | Rely On |
ATVSICC_REC | Oracle Package Variable | S10B80.BANINST1.BWDKCPRF | Rely On |
ATVSICC_REC | Oracle Package Variable | S10B80.BANINST1.BWAKADVS | Rely On |
AORJPSTSICCVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWAKJPST | Use (select) |
ATVSICCVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKCPRF | Use (select)Rely On |
ATVSICCVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWAKADVS | Use (select)Rely On |
ATVSICC_C | Oracle Package Cursor | S10B80.BANINST1.AB_ATVSICC | Rely On |
ATVSICC_C | Oracle Package Cursor | S10B80.BANINST1.AB_ATVSICC | Use (select)Rely On |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_AB_ADV_ORGANIZATION | Use (Insert,select) |
F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.AB_ATVSICC | Rely On |
F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.AB_ATVSICC | Rely On |
ATVSICC | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_ATVSICC | SQL Index | S10B80.ALUMNI | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:44:08:000 | 04/02/2008 13:49:19:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
SPRADDR_PIDM |   | NUMBER(8,0) | No |   | * |
SPRADDR_ATYP_CODE |   | VARCHAR2(2) | No |   | * |
SPRADDR_SEQNO |   | NUMBER(2,0) | No |   | * |
SPRADDR_FROM_DATE |   | DATE | Yes |   |   |
SPRADDR_TO_DATE |   | DATE | Yes |   |   |
SPRADDR_STREET_LINE1 |   | VARCHAR2(75) | Yes |   |   |
SPRADDR_STREET_LINE2 |   | VARCHAR2(75) | Yes |   |   |
SPRADDR_STREET_LINE3 |   | VARCHAR2(75) | Yes |   |   |
SPRADDR_CITY |   | VARCHAR2(50) | No |   | * |
SPRADDR_STAT_CODE |   | VARCHAR2(3) | Yes |   | * |
SPRADDR_ZIP |   | VARCHAR2(30) | Yes |   |   |
SPRADDR_CNTY_CODE |   | VARCHAR2(5) | Yes |   | * |
SPRADDR_NATN_CODE |   | VARCHAR2(5) | Yes |   | * |
SPRADDR_PHONE_AREA |   | VARCHAR2(6) | Yes |   |   |
SPRADDR_PHONE_NUMBER |   | VARCHAR2(12) | Yes |   |   |
SPRADDR_PHONE_EXT |   | VARCHAR2(10) | Yes |   |   |
SPRADDR_STATUS_IND |   | VARCHAR2(1) | Yes |   |   |
SPRADDR_ACTIVITY_DATE |   | DATE | No |   |   |
SPRADDR_USER |   | VARCHAR2(30) | Yes |   |   |
SPRADDR_ASRC_CODE |   | VARCHAR2(4) | Yes |   | * |
SPRADDR_DELIVERY_POINT |   | NUMBER(2,0) | Yes |   |   |
SPRADDR_CORRECTION_DIGIT |   | NUMBER(1,0) | Yes |   |   |
SPRADDR_CARRIER_ROUTE |   | VARCHAR2(4) | Yes |   |   |
SPRADDR_GST_TAX_ID |   | VARCHAR2(15) | Yes |   |   |
SPRADDR_REVIEWED_IND |   | VARCHAR2(1) | Yes |   |   |
SPRADDR_REVIEWED_USER |   | VARCHAR2(30) | Yes |   |   |
SPRADDR_DATA_ORIGIN |   | VARCHAR2(30) | Yes |   |   |
SPRADDR_CTRY_CODE_PHONE |   | VARCHAR2(4) | Yes |   |   |
SPRADDR_HOUSE_NUMBER |   | VARCHAR2(10) | Yes |   |   |
SPRADDR_STREET_LINE4 |   | VARCHAR2(75) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
SPRADDR_ASRC_CODE | STVASRC_CODE | STVASRC |
SPRADDR_ATYP_CODE | STVATYP_CODE | STVATYP |
SPRADDR_CNTY_CODE | STVCNTY_CODE | STVCNTY |
SPRADDR_NATN_CODE | STVNATN_CODE | STVNATN |
SPRADDR_STAT_CODE | STVSTAT_CODE | STVSTAT |
SPRADDR_PIDM | GORCGEO_PIDM | GORCGEO |
SPRADDR_ATYP_CODE | GORCGEO_ATYP_CODE | GORCGEO |
SPRADDR_SEQNO | GORCGEO_ADDR_SEQNO | GORCGEO |
SPRADDR_ATYP_CODE | GTVSDAX_EXTERNAL_CODE | GTVSDAX |
SPRADDR_PIDM | NBRBJOB_PIDM | NBRBJOB |
SPRADDR_PIDM | SARADAP_PIDM | SARADAP |
SPRADDR_PIDM | AMRINFO_PIDM | AMRINFO |
SPRADDR_CITY | SORGEOR_START_RANGE | SORGEOR |
SPRADDR_STAT_CODE | SORGEOR_END_RANGE | SORGEOR |
SPRADDR_STAT_CODE | SORGEOR_START_RANGE | SORGEOR |
SPRADDR_CNTY_CODE | SORGEOR_START_RANGE | SORGEOR |
SPRADDR_NATN_CODE | SORGEOR_START_RANGE | SORGEOR |
SPRADDR_PIDM | SFBETRM_PIDM | SFBETRM |
SPRADDR_PIDM | PEBEMPL_PIDM | PEBEMPL |
SPRADDR_PIDM | PABAPPL_PIDM | PABAPPL |
SPRADDR_ATYP_CODE | APBCONS_ATYP_CODE_PREF | APBCONS |
SPRADDR_PIDM | SRBRECR_PIDM | SRBRECR |
SPRADDR_PIDM | GORSVAS_ACT_SITE_PIDM | GORSVAS |
SPRADDR_ATYP_CODE | GORSVAS_ATYP_CODE | GORSVAS |
SPRADDR_PIDM | GORSVEI_EMPLOYER_PIDM | GORSVEI |
SPRADDR_ATYP_CODE | GORSVEI_ATYP_CODE | GORSVEI |
SPRADDR_ATYP_CODE | AOBORGN_ATYP_CODE | AOBORGN |
SPRADDR_SEQNO | SPRTELE_ADDR_SEQNO | SPRTELE |
SPRADDR_ATYP_CODE | SPRTELE_ATYP_CODE | SPRTELE |
SPRADDR_PIDM | SPRTELE_PIDM | SPRTELE |
SPRADDR_ATYP_CODE | SARERUL_VALUE | SARERUL |
SPRADDR_ATYP_CODE | GORICCR_VALUE | GORICCR |
SPRADDR_STAT_CODE | SPRCOLR_VALUE_ATYP | SPRCOLR |
SPRADDR_ATYP_CODE | GORADRL_ATYP_CODE | GORADRL |
SPRADDR_ATYP_CODE | SORMSTA_ATYP_CODE | SORMSTA |
SPRADDR_STAT_CODE | SORMSTA_STAT_CODE | SORMSTA |
Index Name | Index Type | Column Name |
---|---|---|
SPRADDR_KEY_INDEX | Unique | SPRADDR_PIDM |
SPRADDR_KEY_INDEX | Unique | SPRADDR_ATYP_CODE |
SPRADDR_KEY_INDEX | Unique | SPRADDR_SEQNO |
SPRADDR_KEY_INDEX | Unique | SPRADDR_STATUS_IND |
SPRADDR_KEY_INDEX2 |   | SPRADDR_PIDM |
SPRADDR_KEY_INDEX2 |   | SPRADDR_ATYP_CODE |
SPRADDR_KEY_INDEX2 |   | SPRADDR_SEQNO |
SPRADDR_KEY_INDEX2 |   | SPRADDR_STATUS_IND |
SPRADDR_KEY_INDEX2 |   | SPRADDR_FROM_DATE |
SPRADDR_KEY_INDEX2 |   | SPRADDR_TO_DATE |
SPRADDR_KEY_INDEX3 |   | SPRADDR_USER |
SPRADDR_KEY_INDEX3 |   | SPRADDR_ASRC_CODE |
SPRADDR_KEY_INDEX3 |   | SPRADDR_ACTIVITY_DATE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
SPRADDR_KEY_INDEX | SQL Index | S10B80.SATURN | Rely On |
SPRADDR_KEY_INDEX2 | SQL Index | S10B80.SATURN | Rely On |
SPRADDR_KEY_INDEX3 | SQL Index | S10B80.SATURN | Rely On |
AMRINFO | SQL Table | S10B80.ALUMNI | Join |
AOBORGN | SQL Table | S10B80.ALUMNI | Join |
APBCONS | SQL Table | S10B80.ALUMNI | Join |
GORADRL | SQL Table | S10B80.GENERAL | Join |
GORCGEO | SQL Table | S10B80.GENERAL | Join |
GORICCR | SQL Table | S10B80.GENERAL | Join |
GORSVAS | SQL Table | S10B80.GENERAL | Join |
GORSVEI | SQL Table | S10B80.GENERAL | Join |
GTVSDAX | SQL Table | S10B80.GENERAL | Join |
NBRBJOB | SQL Table | S10B80.POSNCTL | Join |
PABAPPL | SQL Table | S10B80.PAYROLL | Join |
PEBEMPL | SQL Table | S10B80.PAYROLL | Join |
SARADAP | SQL Table | S10B80.SATURN | Join |
SARERUL | SQL Table | S10B80.SATURN | Join |
SFBETRM | SQL Table | S10B80.SATURN | Join |
SORGEOR | SQL Table | S10B80.SATURN | Join |
SORMSTA | SQL Table | S10B80.SATURN | Join |
SPRCOLR | SQL Table | S10B80.SATURN | Join |
SPRTELE | SQL Table | S10B80.SATURN | Join |
SRBRECR | SQL Table | S10B80.SATURN | Join |
STVASRC | SQL Table | S10B80.SATURN | Refer (no action) |
STVATYP | SQL Table | S10B80.SATURN | Refer (no action) |
STVCNTY | SQL Table | S10B80.SATURN | Refer (no action) |
STVNATN | SQL Table | S10B80.SATURN | Refer (no action) |
STVSTAT | SQL Table | S10B80.SATURN | Refer (no action) |
ST_SPRADDR_AR_LDI | SQL Trigger | S10B80.SATURN | Fire (Insert,update,delete,after,each row) |
ST_SPRADDR_AS_LDI | SQL Trigger | S10B80.SATURN | Fire (Insert,update,delete,after,all rows) |
ST_SPRADDR_DELETE_ROW | SQL Trigger | S10B80.SATURN | Fire (delete,before,each row) |
ST_SPRADDR_INSERT_ROW | SQL Trigger | S10B80.SATURN | Fire (Insert,before,each row) |
ST_SPRADDR_UPDATE_ROW | SQL Trigger | S10B80.SATURN | Fire (update,before,each row) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:57:07:000 | 04/02/2008 21:18:18:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
SPRIDEN_PIDM |   | NUMBER(8,0) | No |   | * |
SPRIDEN_ID |   | VARCHAR2(9) | No |   | * |
SPRIDEN_LAST_NAME |   | VARCHAR2(60) | No |   |   |
SPRIDEN_FIRST_NAME |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_MI |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_CHANGE_IND |   | VARCHAR2(1) | Yes |   |   |
SPRIDEN_ENTITY_IND |   | VARCHAR2(1) | Yes |   |   |
SPRIDEN_ACTIVITY_DATE |   | DATE | No |   |   |
SPRIDEN_USER |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_ORIGIN |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_SEARCH_LAST_NAME |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_SEARCH_FIRST_NAME |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_SEARCH_MI |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_SOUNDEX_LAST_NAME |   | CHAR(4) | Yes |   |   |
SPRIDEN_SOUNDEX_FIRST_NAME |   | CHAR(4) | Yes |   |   |
SPRIDEN_NTYP_CODE |   | VARCHAR2(4) | Yes |   | * |
SPRIDEN_CREATE_USER |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_CREATE_DATE |   | DATE | Yes |   |   |
SPRIDEN_DATA_ORIGIN |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_CREATE_FDMN_CODE |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_SURNAME_PREFIX |   | VARCHAR2(60) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
SPRIDEN_NTYP_CODE | GTVNTYP_CODE | GTVNTYP |
SPRIDEN_PIDM | GOBEACC_PIDM | GOBEACC |
SPRIDEN_PIDM | SFRSTCR_PIDM | SFRSTCR |
SPRIDEN_PIDM | SPBPERS_PIDM | SPBPERS |
SPRIDEN_PIDM | NBRBJOB_PIDM | NBRBJOB |
SPRIDEN_PIDM | SIBINST_PIDM | SIBINST |
SPRIDEN_PIDM | SHRTTRM_PIDM | SHRTTRM |
SPRIDEN_PIDM | SARADAP_PIDM | SARADAP |
SPRIDEN_PIDM | GLBEXTR_KEY | GLBEXTR |
SPRIDEN_PIDM | SHRDGMR_PIDM | SHRDGMR |
SPRIDEN_PIDM | RORSTAT_PIDM | RORSTAT |
SPRIDEN_PIDM | APRXREF_XREF_PIDM | APRXREF |
SPRIDEN_PIDM | SHBCOMI_PIDM | SHBCOMI |
SPRIDEN_PIDM | AFRCSLT_PIDM | AFRCSLT |
SPRIDEN_PIDM | APRCATG_PIDM | APRCATG |
SPRIDEN_PIDM | SIRASGN_PIDM | SIRASGN |
SPRIDEN_PIDM | APRCSPS_SPS_PIDM | APRCSPS |
SPRIDEN_PIDM | SGBSTDN_PIDM | SGBSTDN |
SPRIDEN_PIDM | PERJOBP_PIDM | PERJOBP |
SPRIDEN_PIDM | AFRCTYP_CONSTITUENT_PIDM | AFRCTYP |
SPRIDEN_PIDM | AMRINFO_PIDM | AMRINFO |
SPRIDEN_PIDM | SORHSCH_PIDM | SORHSCH |
SPRIDEN_PIDM | RERSTID_PIDM | RERSTID |
SPRIDEN_PIDM | AOBORGN_PIDM | AOBORGN |
SPRIDEN_PIDM | GOBSRVR_PIDM | GOBSRVR |
SPRIDEN_PIDM | APRDHIS_PIDM | APRDHIS |
SPRIDEN_PIDM | SLRRMAT_PIDM | SLRRMAT |
SPRIDEN_PIDM | SABSTUD_PIDM | SABSTUD |
SPRIDEN_PIDM | SGRASSI_PIDM | SGRASSI |
SPRIDEN_PIDM | SHTTRAN_PIDM | SHTTRAN |
SPRIDEN_PIDM | APBCONS_PIDM | APBCONS |
SPRIDEN_PIDM | ASRSSAG_PIDM | ASRSSAG |
SPRIDEN_PIDM | SABIDEN_PIDM | SABIDEN |
SPRIDEN_PIDM | SFRENRL_PIDM | SFRENRL |
SPRIDEN_PIDM | SHRGCOL_PIDM | SHRGCOL |
SPRIDEN_PIDM | SFBETRM_PIDM | SFBETRM |
SPRIDEN_PIDM | SRBRECR_PIDM | SRBRECR |
SPRIDEN_PIDM | PABAPPL_PIDM | PABAPPL |
SPRIDEN_PIDM | PEBEMPL_PIDM | PEBEMPL |
SPRIDEN_PIDM | SORPCOL_PIDM | SORPCOL |
SPRIDEN_PIDM | SPRHOLD_PIDM | SPRHOLD |
SPRIDEN_PIDM | RPRATRM_PIDM | RPRATRM |
SPRIDEN_PIDM | SHRCOMM_PIDM_MEMBER | SHRCOMM |
SPRIDEN_PIDM | RPRAWRD_PIDM | RPRAWRD |
SPRIDEN_PIDM | ASRSORG_PIDM | ASRSORG |
SPRIDEN_PIDM | SLRRASG_PIDM | SLRRASG |
SPRIDEN_PIDM | SMBSLIB_PIDM | SMBSLIB |
SPRIDEN_PIDM | APRCHLD_CHLD_PIDM | APRCHLD |
SPRIDEN_PIDM | APREHIS_EMPR_PIDM | APREHIS |
SPRIDEN_PIDM | PERBARG_PIDM | PERBARG |
SPRIDEN_PIDM | PARAPIN_PIDM | PARAPIN |
SPRIDEN_PIDM | SPRADDR_PIDM | SPRADDR |
SPRIDEN_PIDM | PDRBDED_PIDM | PDRBDED |
SPRIDEN_PIDM | SORAROL_PIDM | SORAROL |
SPRIDEN_PIDM | SERDTGL_PIDM | SERDTGL |
SPRIDEN_PIDM | SERDTND_PIDM | SERDTND |
SPRIDEN_PIDM | SERDTSR_PIDM | SERDTSR |
SPRIDEN_PIDM | SLBEVNT_AGENCY_PIDM | SLBEVNT |
SPRIDEN_PIDM | RORLOGM_PIDM | RORLOGM |
SPRIDEN_PIDM | RNRTMNT_PIDM | RNRTMNT |
SPRIDEN_PIDM | SHBHEAD_PIDM | SHBHEAD |
SPRIDEN_PIDM | SMRRQCM_ORIG_PIDM | SMRRQCM |
SPRIDEN_PIDM | SMRRQCM_PIDM | SMRRQCM |
SPRIDEN_PIDM | GORSVAS_ACT_SITE_PIDM | GORSVAS |
SPRIDEN_PIDM | GORSEVD_DEP_PIDM | GORSEVD |
SPRIDEN_PIDM | GORSVEI_EMPLOYER_PIDM | GORSVEI |
SPRIDEN_PIDM | GOBSEVS_PIDM | GOBSEVS |
SPRIDEN_PIDM | PERJOBS_COMMENT_PIDM | PERJOBS |
SPRIDEN_PIDM | PERJOBS_PIDM | PERJOBS |
SPRIDEN_PIDM | AGBMGID_EMPR_PIDM | AGBMGID |
SPRIDEN_PIDM | AGBMGID_EMPL_PIDM | AGBMGID |
SPRIDEN_PIDM | AORCONT_CONTACT_PIDM | AORCONT |
SPRIDEN_PIDM | SORAINF_PIDM | SORAINF |
SPRIDEN_PIDM | NBRJOBS_PIDM | NBRJOBS |
SPRIDEN_PIDM | GORSEVS_PIDM | GORSEVS |
SPRIDEN_PIDM | PDRBENE_BENE_PIDM | PDRBENE |
SPRIDEN_PIDM | APRCHIS_PIDM | APRCHIS |
SPRIDEN_PIDM | PERREVW_PIDM | PERREVW |
SPRIDEN_PIDM | GERATTD_PIDM | GERATTD |
SPRIDEN_PIDM | SGRADVR_ADVR_PIDM | SGRADVR |
SPRIDEN_PIDM | SGRADVR_PIDM | SGRADVR |
SPRIDEN_PIDM | FABINVH_VEND_CHECK_PIDM | FABINVH |
SPRIDEN_PIDM | FABINVH_VEND_PIDM | FABINVH |
SPRIDEN_PIDM | PERJOBH_COMMENT_PIDM | PERJOBH |
SPRIDEN_PIDM | PERTETH_TRANS_PIDM | PERTETH |
SPRIDEN_PIDM | PERROUT_ACTION_PIDM | PERROUT |
SPRIDEN_PIDM | PERROUT_APPR_PIDM | PERROUT |
SPRIDEN_PIDM | FTVVEND_PIDM | FTVVEND |
SPRIDEN_PIDM | GOBTPAC_PIDM | GOBTPAC |
SPRIDEN_PIDM | FRBGRNT_AGENCY_PIDM | FRBGRNT |
SPRIDEN_PIDM | AMRSTAF_PIDM | AMRSTAF |
SPRIDEN_PIDM | SHRMRKS_PIDM | SHRMRKS |
SPRIDEN_PIDM | SHRCMRK_PIDM | SHRCMRK |
SPRIDEN_PIDM | SHRSMRK_PIDM | SHRSMRK |
SPRIDEN_PIDM | NBREJOB_PIDM | NBREJOB |
SPRIDEN_PIDM | SHRNCRS_ADVR_PIDM | SHRNCRS |
SPRIDEN_PIDM | SHRTCKN_PIDM | SHRTCKN |
SPRIDEN_PIDM | NBTJOBF_EMPLOYEE_PIDM | NBTJOBF |
SPRIDEN_PIDM | RCRAPP1_PIDM | RCRAPP1 |
SPRIDEN_PIDM | RPRLAPP_LENDER_PIDM | RPRLAPP |
SPRIDEN_PIDM | SFRAREG_PIDM | SFRAREG |
SPRIDEN_PIDM | PERFJOB_PIDM | PERFJOB |
SPRIDEN_PIDM | AMRPLAN_PIDM | AMRPLAN |
SPRIDEN_PIDM | GORVISA_PIDM | GORVISA |
SPRIDEN_ID | SRTIDEN_ID | SRTIDEN |
SPRIDEN_PIDM | SRTIDEN_PIDM | SRTIDEN |
SPRIDEN_PIDM | PERFCNT_PIDM | PERFCNT |
SPRIDEN_PIDM | APRACYR_PIDM | APRACYR |
SPRIDEN_PIDM | SHTTRTC_PIDM | SHTTRTC |
SPRIDEN_PIDM | GOBUMAP_PIDM | GOBUMAP |
SPRIDEN_PIDM | AORJPST_EMPR_PIDM | AORJPST |
SPRIDEN_PIDM | FTVIMGR_IMGR_CODE_PIDM | FTVIMGR |
SPRIDEN_PIDM | APRCRVW_PIDM | APRCRVW |
SPRIDEN_PIDM | APRERVW_PIDM | APRERVW |
SPRIDEN_PIDM | APRSRVW_PIDM | APRSRVW |
SPRIDEN_PIDM | APRDRVW_PIDM | APRDRVW |
Index Name | Index Type | Column Name |
---|---|---|
SPRIDEN_INDEX_ID |   | SPRIDEN_ID |
SPRIDEN_INDEX_ID |   | SPRIDEN_ENTITY_IND |
SPRIDEN_INDEX_ID |   | SPRIDEN_CHANGE_IND |
SPRIDEN_INDEX_PERS |   | SPRIDEN_LAST_NAME |
SPRIDEN_INDEX_PERS |   | SPRIDEN_FIRST_NAME |
SPRIDEN_INDEX_PERS |   | SPRIDEN_MI |
SPRIDEN_INDEX_PERS |   | SPRIDEN_ENTITY_IND |
SPRIDEN_INDEX_PERS |   | SPRIDEN_CHANGE_IND |
SPRIDEN_INDEX_SEARCH |   | SPRIDEN_SEARCH_LAST_NAME |
SPRIDEN_INDEX_SEARCH |   | SPRIDEN_SEARCH_FIRST_NAME |
SPRIDEN_INDEX_SEARCH |   | SPRIDEN_SEARCH_MI |
SPRIDEN_INDEX_SOUNDEX |   | SPRIDEN_SOUNDEX_LAST_NAME |
SPRIDEN_INDEX_SOUNDEX |   | SPRIDEN_SOUNDEX_FIRST_NAME |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_PIDM |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_ID |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_LAST_NAME |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_FIRST_NAME |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_MI |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_CHANGE_IND |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_NTYP_CODE |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:48:43:000 | 04/02/2008 21:17:58:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
STVATYP_CODE |   | VARCHAR2(2) | No | * |   |
STVATYP_DESC |   | VARCHAR2(30) | Yes |   |   |
STVATYP_ACTIVITY_DATE |   | DATE | No |   |   |
STVATYP_SYSTEM_REQ_IND |   | VARCHAR2(1) | Yes |   |   |
STVATYP_TELE_CODE |   | VARCHAR2(4) | Yes |   | * |
STVATYP_UPDATE_WEB_IND |   | RAW(1) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
STVATYP_TELE_CODE | STVTELE_CODE | STVTELE |
Index Name | Index Type | Column Name |
---|---|---|
PK_STVATYP | Unique | STVATYP_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_STVATYP | SQL Index | S10B80.SATURN | Rely On |
STVTELE | SQL Table | S10B80.SATURN | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:48:46:000 | 04/02/2008 21:18:11:000 |
Objects list |
---|
schema-function : S10B80.BANINST1.F_MATCHING_GIFT_COMPANY_NAME
schema-view : S10B80.BANINST1.AOVORG1 schema-view : S10B80.BANINST1.APVBRWS schema-view : S10B80.BANINST1.AOVCOMP schema-view : S10B80.BANINST1.AOVORGN scope-function : S10B80.BANINST1.AOKPVAL.F_AOBORGN_EQUAL |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRIDEN and AOBORGN | SATURN |
Link type | Between | And |
---|---|---|
Join | SPRIDEN | AOBORGN |
Objects list |
---|
schema-view : S10B80.BANINST1.APVEHIS
scope-cursor : S10B80.BANINST1.BWAKJPST.EMPLOYERVIEWC |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRIDEN and APREHIS | SATURN |
Link type | Between | And |
---|---|---|
Join | SPRIDEN | APREHIS |
Objects list |
---|
schema-view : S10B80.BANINST1.SPVADDF_OJ
schema-view : S10B80.BANINST1.SPVADDS_OJ schema-view : S10B80.BANINST1.SOVGEOR schema-view : S10B80.BANINST1.AOVIDEN schema-view : S10B80.BANINST1.AOVCOMP schema-view : S10B80.BANINST1.SPVADDF schema-view : S10B80.BANINST1.SPVADDR schema-view : S10B80.BANINST1.SPVPERS schema-view : S10B80.BANINST1.SPVADDS schema-view : S10B80.BANINST1.ALVADDS scope-function : S10B80.BANINST1.GB_IDENTIFICATION.F_IDNAME_SEARCH scope-function : S10B80.BANINST1.GB_IDENTIFICATION.F_SSNNAME_SEARCH scope-procedure : S10B80.BANINST1.BWFKVREQ.P_VIEWREQ scope-function : S10B80.BANINST1.TEST_LVH.F_IDNAME_SEARCH scope-procedure : S10B80.BANINST1.BWFKVPUR.P_VIEWPUR scope-procedure : S10B80.BANINST1.BWFKVINV.P_VIEWINV |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRIDEN and SPRADDR | SATURN |
Link type | Between | And |
---|---|---|
Join | SPRIDEN | SPRADDR |
Objects list |
---|
schema-view : S10B80.BANINST1.AOVCOMP |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRADDR and AOBORGN | SATURN |
Link type | Between | And |
---|---|---|
Join | SPRADDR | AOBORGN |
Objects list |
---|
schema-view : S10B80.BANINST1.AOVCONT |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRIDEN and AORCONT | SATURN |
Link type | Between | And |
---|---|---|
Join | SPRIDEN | AORCONT |
Objects list |
---|
scope-procedure : S10B80.BANINST1.AXKEXMG.P_EVALUATE_MG_ELIGIBILITY
scope-cursor : S10B80.BANINST1.BWAKADVS.APREHISVIEWC |
Link Type | Link | Project |
---|---|---|
Join | Link Between AOBORGN and APREHIS | ALUMNI |
Link type | Between | And |
---|---|---|
Join | AOBORGN | APREHIS |
Objects list |
---|
scope-cursor : S10B80.BANINST1.BWAKJPST.SEARCHVIEWC
scope-cursor : S10B80.BANINST1.BWAKJPST.AORJPSTSICCVIEWC |
Link Type | Link | Project |
---|---|---|
Join | Link Between AORJPST and AOBORGN | ALUMNI |
Link type | Between | And |
---|---|---|
Join | AORJPST | AOBORGN |
Objects list |
---|
scope-cursor : S10B80.BANINST1.BWAKJPST.SEARCHVIEWC
scope-cursor : S10B80.BANINST1.BWAKJPST.AORJPSTCOMPVIEWC scope-cursor : S10B80.BANINST1.BWAKJPST.AORJPSTVIEWC |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRIDEN and AORJPST | SATURN |
Link type | Between | And |
---|---|---|
Join | SPRIDEN | AORJPST |
Objects list |
---|
scope-cursor : S10B80.BANINST1.BWAKJPST.AORJPSTJOBCVIEWC |
Link Type | Link | Project |
---|---|---|
Join | Link Between AORJPST and ATVJOBC | ALUMNI |
Link type | Between | And |
---|---|---|
Join | AORJPST | ATVJOBC |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AORMCTL and AOBORGN (FK1_AORMCTL_INV_AOBORGN_KEY) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AORMCTL | AORMCTL_PIDM | AOBORGN_PIDM | AOBORGN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AORMDEF and AOBORGN (FK1_AORMDEF_INV_AOBORGN_KEY) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AORMDEF | AORMDEF_PIDM | AOBORGN_PIDM | AOBORGN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AORMLOC and AOBORGN (FK1_AORMLOC_INV_AOBORGN_KEY) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AORMLOC | AORMLOC_PIDM | AOBORGN_PIDM | AOBORGN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AORMRTO and AOBORGN (FK1_AORMRTO_INV_AOBORGN_KEY) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AORMRTO | AORMRTO_PIDM | AOBORGN_PIDM | AOBORGN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AORMEDU and AOBORGN (FK1_AORMEDU_INV_AOBORGN_KEY) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AORMEDU | AORMEDU_PIDM | AOBORGN_PIDM | AOBORGN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AORMLVL and AOBORGN (FK1_AORMLVL_INV_AOBORGN_KEY) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AORMLVL | AORMLVL_PIDM | AOBORGN_PIDM | AOBORGN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AORMERQ and AOBORGN (FK1_AORMERQ_INV_AOBORGN_KEY) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AORMERQ | AORMERQ_PIDM | AOBORGN_PIDM | AOBORGN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AORMNAT and AOBORGN (FK1_AORMNAT_INV_AOBORGN_KEY) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AORMNAT | AORMNAT_PIDM | AOBORGN_PIDM | AOBORGN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AORMNED and AOBORGN (FK1_AORMNED_INV_AOBORGN_KEY) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AORMNED | AORMNED_PIDM | AOBORGN_PIDM | AOBORGN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AOBORGN and ATVSICC (FK1_AOBORGN_INV_ATVSICC_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AOBORGN | AOBORGN_SICC_CODE | ATVSICC_CODE | ATVSICC | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between APREHIS and ATVSICC (FK1_APREHIS_INV_ATVSICC_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
APREHIS | APREHIS_SICC_CODE | ATVSICC_CODE | ATVSICC | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AORMGCD and AOBORGN (FK1_AORMGCD_INV_AOBORGN_KEY) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AORMGCD | AORMGCD_PIDM | AOBORGN_PIDM | AOBORGN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AORMGCM and AOBORGN (FK1_AORMGCM_INV_AOBORGN_KEY) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AORMGCM | AORMGCM_PIDM | AOBORGN_PIDM | AOBORGN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AOBORGN and ATVMDIS (FK1_AOBORGN_INV_ATVMDIS_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AOBORGN | AOBORGN_MDIS_CODE | ATVMDIS_CODE | ATVMDIS | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AORFUND and AOBORGN (FK1_AORFUND_INV_AOBORGN_KEY) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AORFUND | AORFUND_PIDM | AOBORGN_PIDM | AOBORGN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AORMACC and AOBORGN (FK1_AORMACC_INV_AOBORGN_KEY) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AORMACC | AORMACC_PIDM | AOBORGN_PIDM | AOBORGN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AORCONT and AOBORGN (FK1_AORCONT_INV_AOBORGN_KEY) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AORCONT | AORCONT_PIDM | AOBORGN_PIDM | AOBORGN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AORMPRO and AOBORGN (FK1_AORMPRO_INV_AOBORGN_KEY) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AORMPRO | AORMPRO_PIDM | AOBORGN_PIDM | AOBORGN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AORMAST and AOBORGN (FK1_AORMAST_INV_AOBORGN_KEY) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AORMAST | AORMAST_PIDM | AOBORGN_PIDM | AOBORGN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AORMPUR and AOBORGN (FK1_AORMPUR_INV_AOBORGN_KEY) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AORMPUR | AORMPUR_PIDM | AOBORGN_PIDM | AOBORGN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AOBORGN and ATVJOBC (FK1_AOBORGN_INV_ATVJOBC_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AOBORGN | AOBORGN_JOBC_CODE | ATVJOBC_CODE | ATVJOBC | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AORCONT and ATVJOBC (FK1_AORCONT_INV_ATVJOBC_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AORCONT | AORCONT_JOBC_CODE | ATVJOBC_CODE | ATVJOBC | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between APREHIS and ATVJOBC (FK1_APREHIS_INV_ATVJOBC_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
APREHIS | APREHIS_JOBC_CODE | ATVJOBC_CODE | ATVJOBC | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AORMIND and AOBORGN (FK1_AORMIND_INV_AOBORGN_KEY) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AORMIND | AORMIND_PIDM | AOBORGN_PIDM | AOBORGN | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AOBORGN and STVATYP (FK1_AOBORGN_INV_STVATYP_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AOBORGN | AOBORGN_ATYP_CODE | STVATYP_CODE | STVATYP | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between AORCONT and STVATYP (FK1_AORCONT_INV_STVATYP_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
AORCONT | AORCONT_ATYP_CODE | STVATYP_CODE | STVATYP | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between SPRADDR and STVATYP (FK1_SPRADDR_INV_STVATYP_CODE) | SATURN |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
SPRADDR | SPRADDR_ATYP_CODE | STVATYP_CODE | STVATYP | (1,1)-(0,n) |