Model Individual*
Object Name | Object Type | Layer Name |
---|---|---|
APBCONS | SQL Table | Default |
APRACYR | SQL Table | Default |
APRADEG | SQL Table | Default |
APRCATG | SQL Table | Default |
APRCHIS | SQL Table | Default |
APRCHLD | SQL Table | Default |
APRCSPS | SQL Table | Default |
APRDHIS | SQL Table | Default |
APREHIS | SQL Table | Default |
APRXREF | SQL Table | Default |
ASRSSAG | SQL Table | Default |
ATVDOTT | SQL Table | Default |
ATVINCM | SQL Table | Default |
SPRADDR | SQL Table | Default |
SPRIDEN | SQL Table | Default |
STVATYP | SQL Table | Default |
STVCOLL | SQL Table | Default |
STVNATN | SQL Table | Default |
STVSTAT | SQL Table | Default |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
APBCONS_PIDM |   | NUMBER(8,0) | No | * | * |
APBCONS_PREF_LAST_NAME |   | VARCHAR2(60) | Yes |   |   |
APBCONS_PREF_FIRST_NAME |   | VARCHAR2(60) | Yes |   |   |
APBCONS_PREF_MI |   | VARCHAR2(60) | Yes |   |   |
APBCONS_NICKNAME |   | VARCHAR2(40) | Yes |   |   |
APBCONS_GRAD_NAME |   | VARCHAR2(120) | Yes |   |   |
APBCONS_PARENTS_NAME |   | VARCHAR2(50) | Yes |   |   |
APBCONS_MAIDEN_LAST_NAME |   | VARCHAR2(25) | Yes |   |   |
APBCONS_PREF_CLAS |   | VARCHAR2(4) | No |   |   |
APBCONS_COLL_CODE_PREF |   | VARCHAR2(2) | Yes |   | * |
APBCONS_HOME_CITY |   | VARCHAR2(50) | Yes |   |   |
APBCONS_STAT_CODE_HOME |   | VARCHAR2(3) | Yes |   | * |
APBCONS_NATN_CODE_HOME |   | VARCHAR2(5) | Yes |   | * |
APBCONS_CM_NAME |   | VARCHAR2(120) | Yes |   |   |
APBCONS_ATYP_CODE_CM |   | VARCHAR2(2) | Yes |   | * |
APBCONS_DOTT_CODE |   | VARCHAR2(4) | Yes |   | * |
APBCONS_INCM_CODE |   | VARCHAR2(2) | Yes |   | * |
APBCONS_ATYP_CODE_PREF |   | VARCHAR2(2) | Yes |   | * |
APBCONS_ADDR_NAME |   | VARCHAR2(120) | Yes |   |   |
APBCONS_ACTIVITY_DATE |   | DATE | No |   |   |
APBCONS_ATYP_CODE_GEOR |   | VARCHAR2(2) | Yes |   | * |
APBCONS_SOCIETY_NAME |   | VARCHAR2(120) | Yes |   |   |
APBCONS_DATA_ORIGIN |   | VARCHAR2(30) | Yes |   |   |
APBCONS_USER_ID |   | VARCHAR2(30) | Yes |   |   |
APBCONS_SURNAME_PREFIX |   | VARCHAR2(60) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
APBCONS_NATN_CODE_HOME | STVNATN_CODE | STVNATN |
APBCONS_STAT_CODE_HOME | STVSTAT_CODE | STVSTAT |
APBCONS_INCM_CODE | ATVINCM_CODE | ATVINCM |
APBCONS_DOTT_CODE | ATVDOTT_CODE | ATVDOTT |
APBCONS_COLL_CODE_PREF | STVCOLL_CODE | STVCOLL |
APBCONS_ATYP_CODE_GEOR | STVATYP_CODE | STVATYP |
APBCONS_ATYP_CODE_CM | STVATYP_CODE | STVATYP |
APBCONS_ATYP_CODE_PREF | STVATYP_CODE | STVATYP |
APBCONS_PIDM | APRDHIS_PIDM | APRDHIS |
APBCONS_PIDM | APRCHIS_PIDM | APRCHIS |
APBCONS_PIDM | APRACYR_PIDM | APRACYR |
Index Name | Index Type | Column Name |
---|---|---|
APBCONS_KEY_INDEX2 |   | APBCONS_PREF_CLAS |
APBCONS_KEY_INDEX3 |   | APBCONS_COLL_CODE_PREF |
PK_APBCONS | Unique | APBCONS_PIDM |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
APBCONS_KEY_INDEX2 | SQL Index | S10B80.ALUMNI | Rely On |
APBCONS_KEY_INDEX3 | SQL Index | S10B80.ALUMNI | Rely On |
PK_APBCONS | SQL Index | S10B80.ALUMNI | Rely On |
APRACYR | SQL Table | S10B80.ALUMNI | Join |
APRCHIS | SQL Table | S10B80.ALUMNI | Join |
APRDHIS | SQL Table | S10B80.ALUMNI | Join |
ATVDOTT | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVINCM | SQL Table | S10B80.ALUMNI | Refer (no action) |
STVATYP | SQL Table | S10B80.SATURN | Refer (no action) |
STVCOLL | 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:41:11:000 | 04/02/2008 13:49:16:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
APRACYR_PIDM |   | NUMBER(8,0) | No | * | * |
APRACYR_SACT_CODE |   | VARCHAR2(3) | Yes |   |   |
APRACYR_YEAR |   | NUMBER(4,0) | No | * |   |
APRACYR_ACTIVITY_DATE |   | DATE | No |   |   |
APRACYR_ACTC_CODE |   | VARCHAR2(8) | No | * | * |
Column name | is Foreign Key For Column | on Table |
---|---|---|
APRACYR_PIDM | APRACTY_PIDM | APRACTY |
APRACYR_ACTC_CODE | APRACTY_ACTC_CODE | APRACTY |
APRACYR_ACTC_CODE | STVACTC_CODE | STVACTC |
Index Name | Index Type | Column Name |
---|---|---|
PK_APRACYR | Unique | APRACYR_PIDM |
PK_APRACYR | Unique | APRACYR_ACTC_CODE |
PK_APRACYR | Unique | APRACYR_YEAR |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
APBCONS | SQL Table | S10B80.ALUMNI | Join |
APRADEG | SQL Table | S10B80.ALUMNI | Join |
APRAMAJ | SQL Table | S10B80.ALUMNI | Join |
SPBPERS | SQL Table | S10B80.SATURN | Join |
SPRIDEN | SQL Table | S10B80.SATURN | Join |
APVACTY | SQL View | S10B80.BANINST1 | Use (select) |
F_ACTIVITY_CODE_INFO | SQL Function | S10B80.BANINST1 | Use (select) |
ACTC_TYPE | Oracle Package Type | S10B80.BANINST1.BWAKADVS | Rely On |
APRACYR_REC | Oracle Package Variable | S10B80.BANINST1.BWAKADVS | Rely On |
APRACYRVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWAKADVS | Use (select)Rely On |
ONEYEARVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWAKADVS | Use (select)Rely On |
SEARCHVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWAKADVS | Use (select) |
P_DISP_ACTIVITIES | Oracle Package Procedure | S10B80.BANINST1.BWDKCPRF | Use (select) |
P_INSERT_ADVISOR | Oracle Package Procedure | S10B80.BANINST1.BWAKADVS | Use (Insert) |
APRACYR | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_APRACYR | SQL Index | S10B80.ALUMNI | Rely On |
APRACTY | SQL Table | S10B80.ALUMNI | Refer (no action) |
STVACTC | SQL Table | S10B80.SATURN | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:42:34:000 | 04/02/2008 13:49:17:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
APRADEG_PIDM |   | NUMBER(8,0) | No | * | * |
APRADEG_SEQ_NO |   | NUMBER(5,0) | No | * |   |
APRADEG_SBGI_CODE |   | VARCHAR2(6) | Yes |   | * |
APRADEG_DEGC_CODE |   | VARCHAR2(6) | Yes |   | * |
APRADEG_DATE |   | DATE | Yes |   |   |
APRADEG_HONR_CODE |   | VARCHAR2(6) | Yes |   | * |
APRADEG_COLL_CODE |   | VARCHAR2(2) | Yes |   | * |
APRADEG_ACTIVITY_DATE |   | DATE | No |   |   |
APRADEG_ACYR_CODE |   | VARCHAR2(4) | Yes |   | * |
APRADEG_ACYR_CODE_BULLETIN |   | VARCHAR2(4) | Yes |   | * |
APRADEG_CAMP_CODE |   | VARCHAR2(3) | Yes |   | * |
APRADEG_DEPT_CODE |   | VARCHAR2(4) | Yes |   | * |
APRADEG_COMMENTS |   | VARCHAR2(2000) | Yes |   |   |
APRADEG_MAJR_CODE_MINR_1 |   | VARCHAR2(4) | Yes |   | * |
APRADEG_MAJR_CODE_MINR_2 |   | VARCHAR2(4) | Yes |   | * |
APRADEG_MAJR_CODE_CONC_1 |   | VARCHAR2(4) | Yes |   | * |
APRADEG_MAJR_CODE_CONC_2 |   | VARCHAR2(4) | Yes |   | * |
APRADEG_MAJR_CODE_CONC_3 |   | VARCHAR2(4) | Yes |   | * |
APRADEG_MAJR_CODE_CONC_4 |   | VARCHAR2(4) | Yes |   | * |
APRADEG_MAJR_CODE_CONC_5 |   | VARCHAR2(4) | Yes |   | * |
APRADEG_MAJR_CODE_CONC_6 |   | VARCHAR2(4) | Yes |   | * |
APRADEG_DEPT_CODE_2 |   | VARCHAR2(4) | Yes |   | * |
APRADEG_HONR_CODE_2 |   | VARCHAR2(6) | Yes |   | * |
APRADEG_HONR_CODE_3 |   | VARCHAR2(6) | Yes |   | * |
APRADEG_HONR_CODE_4 |   | VARCHAR2(6) | Yes |   | * |
APRADEG_HONR_CODE_5 |   | VARCHAR2(6) | Yes |   | * |
APRADEG_HOND_CODE_1 |   | VARCHAR2(6) | Yes |   | * |
APRADEG_HOND_CODE_2 |   | VARCHAR2(6) | Yes |   | * |
APRADEG_HOND_CODE_3 |   | VARCHAR2(6) | Yes |   | * |
APRADEG_HOND_CODE_4 |   | VARCHAR2(6) | Yes |   | * |
APRADEG_HOND_CODE_5 |   | VARCHAR2(6) | Yes |   | * |
APRADEG_OK_FOR_NOTES_IND |   | VARCHAR2(1) | Yes |   |   |
APRADEG_DISP_NOTES_IND |   | VARCHAR2(1) | Yes |   |   |
APRADEG_DISP_NOTES_DATE |   | DATE | Yes |   |   |
APRADEG_USER |   | VARCHAR2(30) | No |   |   |
APRADEG_REVIEWED_IND |   | VARCHAR2(1) | Yes |   |   |
APRADEG_REVIEWED_USER |   | VARCHAR2(30) | Yes |   |   |
APRADEG_MAJOR_COMMENT |   | VARCHAR2(60) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
APRADEG_PIDM | APBCONS_PIDM | APBCONS |
APRADEG_ACYR_CODE | STVACYR_CODE | STVACYR |
APRADEG_ACYR_CODE_BULLETIN | STVACYR_CODE | STVACYR |
APRADEG_COLL_CODE | STVCOLL_CODE | STVCOLL |
APRADEG_MAJR_CODE_MINR_1 | STVMAJR_CODE | STVMAJR |
APRADEG_MAJR_CODE_MINR_2 | STVMAJR_CODE | STVMAJR |
APRADEG_MAJR_CODE_CONC_1 | STVMAJR_CODE | STVMAJR |
APRADEG_MAJR_CODE_CONC_2 | STVMAJR_CODE | STVMAJR |
APRADEG_MAJR_CODE_CONC_3 | STVMAJR_CODE | STVMAJR |
APRADEG_MAJR_CODE_CONC_4 | STVMAJR_CODE | STVMAJR |
APRADEG_MAJR_CODE_CONC_5 | STVMAJR_CODE | STVMAJR |
APRADEG_MAJR_CODE_CONC_6 | STVMAJR_CODE | STVMAJR |
APRADEG_DEGC_CODE | STVDEGC_CODE | STVDEGC |
APRADEG_DEPT_CODE | STVDEPT_CODE | STVDEPT |
APRADEG_DEPT_CODE_2 | STVDEPT_CODE | STVDEPT |
APRADEG_CAMP_CODE | STVCAMP_CODE | STVCAMP |
APRADEG_HOND_CODE_3 | STVHOND_CODE | STVHOND |
APRADEG_HOND_CODE_4 | STVHOND_CODE | STVHOND |
APRADEG_HOND_CODE_5 | STVHOND_CODE | STVHOND |
APRADEG_HOND_CODE_1 | STVHOND_CODE | STVHOND |
APRADEG_HOND_CODE_2 | STVHOND_CODE | STVHOND |
APRADEG_HONR_CODE | STVHONR_CODE | STVHONR |
APRADEG_HONR_CODE_2 | STVHONR_CODE | STVHONR |
APRADEG_HONR_CODE_3 | STVHONR_CODE | STVHONR |
APRADEG_HONR_CODE_4 | STVHONR_CODE | STVHONR |
APRADEG_HONR_CODE_5 | STVHONR_CODE | STVHONR |
APRADEG_SBGI_CODE | STVSBGI_CODE | STVSBGI |
APRADEG_PIDM | APRACYR_PIDM | APRACYR |
Index Name | Index Type | Column Name |
---|---|---|
PK_APRADEG | Unique | APRADEG_PIDM |
PK_APRADEG | Unique | APRADEG_SEQ_NO |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
APRAMAJ | SQL Table | S10B80.ALUMNI | Refer (no action) |
AUBINST | SQL Table | S10B80.ALUMNI | Join |
F_CHECK_FOR_MORE | SQL Function | S10B80.BANINST1 | Use (select) |
F_INST_DEGR | SQL Function | S10B80.BANINST1 | Use (select) |
F_OTHER_INST_DEGR | SQL Function | S10B80.BANINST1 | Use (select) |
DEGC_TYPE | Oracle Package Type | S10B80.BANINST1.BWAKADVS | Rely On |
APRADEG_REC | Oracle Package Variable | S10B80.BANINST1.BWDKSRCH | Rely On |
APRADEG_REC | Oracle Package Variable | S10B80.BANINST1.BWDKCPRF | Rely On |
HOLD_DEGREE_COLL1 | Oracle Package Variable | S10B80.BANINST1.BWDKSRCH | Rely On |
HOLD_DEGREE_COLL2 | Oracle Package Variable | S10B80.BANINST1.BWDKSRCH | Rely On |
HOLD_DEGREE_COLL3 | Oracle Package Variable | S10B80.BANINST1.BWDKSRCH | Rely On |
HOLD_DEGREE_YR1 | Oracle Package Variable | S10B80.BANINST1.BWDKSRCH | Rely On |
HOLD_DEGREE_YR2 | Oracle Package Variable | S10B80.BANINST1.BWDKSRCH | Rely On |
HOLD_DEGREE_YR3 | Oracle Package Variable | S10B80.BANINST1.BWDKSRCH | Rely On |
APRADEGVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKCPRF | Use (select)Rely On |
SEARCHVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWAKADVS | Use (select) |
P_EVALUATE_MG_ELIGIBILITY | Oracle Package Procedure | S10B80.BANINST1.AXKEXMG | Use (select) |
P_LOAD_DEGREE | Oracle Package Procedure | S10B80.BANINST1.APKLDRD | Rely On |
P_LOAD_DEGREE | Oracle Package Procedure | S10B80.BANINST1.APKLDRD | Use (Insert,update,select)Rely On |
F_GET_DEGREE_CHANGES_IND | Oracle Package Function | S10B80.BANINST1.APKWIND | Use (select) |
APRADEG | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_APRADEG | SQL Index | S10B80.ALUMNI | Rely On |
APBCONS | SQL Table | S10B80.ALUMNI | Refer (no action) |
APRACYR | SQL Table | S10B80.ALUMNI | Join |
STVACYR | SQL Table | S10B80.SATURN | Refer (no action) |
STVCAMP | SQL Table | S10B80.SATURN | Refer (no action) |
STVCOLL | SQL Table | S10B80.SATURN | Refer (no action) |
STVDEGC | SQL Table | S10B80.SATURN | Refer (no action) |
STVDEPT | SQL Table | S10B80.SATURN | Refer (no action) |
STVHOND | SQL Table | S10B80.SATURN | Refer (no action) |
STVHONR | SQL Table | S10B80.SATURN | Refer (no action) |
STVMAJR | SQL Table | S10B80.SATURN | Refer (no action) |
STVSBGI | SQL Table | S10B80.SATURN | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:42:52:000 | 04/02/2008 13:49:18:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
APRCATG_PIDM |   | NUMBER(8,0) | No | * | * |
APRCATG_DONR_CODE |   | VARCHAR2(4) | No | * | * |
APRCATG_ACTIVITY_DATE |   | DATE | No |   |   |
APRCATG_DATA_ORIGIN |   | VARCHAR2(30) | Yes |   |   |
APRCATG_USER_ID |   | VARCHAR2(30) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
APRCATG_DONR_CODE | ATVDONR_CODE | ATVDONR |
APRCATG_PIDM | APBCONS_PIDM | APBCONS |
Index Name | Index Type | Column Name |
---|---|---|
APRCATG_KEY_INDEX2 |   | APRCATG_DONR_CODE |
PK_APRCATG | Unique | APRCATG_PIDM |
PK_APRCATG | Unique | APRCATG_DONR_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
APRCATG_KEY_INDEX2 | SQL Index | S10B80.ALUMNI | Rely On |
PK_APRCATG | SQL Index | S10B80.ALUMNI | Rely On |
APBCONS | SQL Table | S10B80.ALUMNI | Join |
ATVDONR | SQL Table | S10B80.ALUMNI | Refer (no action) |
AT_APRCATG_AR_LDI | SQL Trigger | S10B80.ALUMNI | Fire (Insert,update,delete,after,each row) |
AT_APRCATG_AS_LDI | SQL Trigger | S10B80.ALUMNI | Fire (Insert,update,delete,after,all rows) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:46:06:000 | 04/02/2008 13:49:22:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
APRCHIS_PIDM |   | NUMBER(8,0) | No | * |   |
APRCHIS_CAMPAIGN |   | VARCHAR2(5) | No | * | * |
APRCHIS_FISC_CODE |   | NUMBER(4,0) | No | * | * |
APRCHIS_AMT_PLEDGED |   | NUMBER(13,2) | Yes |   |   |
APRCHIS_AMT_PLEDGED_PAID |   | NUMBER(13,2) | Yes |   |   |
APRCHIS_AMT_GIFT |   | NUMBER(13,2) | Yes |   |   |
APRCHIS_AMT_MEMO |   | NUMBER(13,2) | Yes |   |   |
APRCHIS_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
APRCHIS_FISC_CODE | ATVFISC_CODE | ATVFISC |
APRCHIS_CAMPAIGN | AFBCAMP_CAMPAIGN | AFBCAMP |
Index Name | Index Type | Column Name |
---|---|---|
APRCHIS_KEY_INDEX2 |   | APRCHIS_FISC_CODE |
APRCHIS_KEY_INDEX2 |   | APRCHIS_PIDM |
APRCHIS_KEY_INDEX3 |   | APRCHIS_CAMPAIGN |
PK_APRCHIS | Unique | APRCHIS_PIDM |
PK_APRCHIS | Unique | APRCHIS_CAMPAIGN |
PK_APRCHIS | Unique | APRCHIS_FISC_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
APRCHIS_KEY_INDEX2 | SQL Index | S10B80.ALUMNI | Rely On |
APRCHIS_KEY_INDEX3 | SQL Index | S10B80.ALUMNI | Rely On |
PK_APRCHIS | SQL Index | S10B80.ALUMNI | Rely On |
AFBCAMP | SQL Table | S10B80.ALUMNI | Join |
ATVFISC | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:45:25:000 | 04/02/2008 13:49:21:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
APRCHLD_PIDM |   | NUMBER(8,0) | No | * | * |
APRCHLD_SEQ_NO |   | NUMBER(5,0) | No | * |   |
APRCHLD_LAST_NAME |   | VARCHAR2(60) | Yes |   |   |
APRCHLD_FIRST_NAME |   | VARCHAR2(60) | Yes |   |   |
APRCHLD_MI |   | VARCHAR2(60) | Yes |   |   |
APRCHLD_SEX |   | VARCHAR2(1) | Yes |   |   |
APRCHLD_BIRTH_DATE |   | DATE | Yes |   |   |
APRCHLD_SSN |   | VARCHAR2(15) | Yes |   |   |
APRCHLD_ATYP_CODE |   | VARCHAR2(2) | Yes |   | * |
APRCHLD_ACTIVITY_DATE |   | DATE | No |   |   |
APRCHLD_XREF_CODE |   | VARCHAR2(3) | Yes |   | * |
APRCHLD_CHLD_PIDM |   | NUMBER(8,0) | Yes |   | * |
APRCHLD_DISP_WEB_IND |   | VARCHAR2(1) | Yes |   |   |
APRCHLD_DECEASED_IND |   | VARCHAR2(1) | Yes |   |   |
APRCHLD_DECEASED_DATE |   | DATE | Yes |   |   |
APRCHLD_OK_FOR_NOTES_IND |   | VARCHAR2(1) | Yes |   |   |
APRCHLD_DISP_NOTES_IND |   | VARCHAR2(1) | Yes |   |   |
APRCHLD_DISP_NOTES_DATE |   | DATE | Yes |   |   |
APRCHLD_USER |   | VARCHAR2(30) | No |   |   |
APRCHLD_REVIEWED_IND |   | VARCHAR2(1) | Yes |   |   |
APRCHLD_REVIEWED_USER |   | VARCHAR2(30) | Yes |   |   |
APRCHLD_COMMENT |   | LONG | Yes |   |   |
APRCHLD_SURNAME_PREFIX |   | VARCHAR2(60) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
APRCHLD_PIDM | APBCONS_PIDM | APBCONS |
APRCHLD_XREF_CODE | ATVXREF_CODE | ATVXREF |
APRCHLD_ATYP_CODE | STVATYP_CODE | STVATYP |
APRCHLD_CHLD_PIDM | SPBPERS_PIDM | SPBPERS |
Index Name | Index Type | Column Name |
---|---|---|
PK_APRCHLD | Unique | APRCHLD_PIDM |
PK_APRCHLD | Unique | APRCHLD_SEQ_NO |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
SPRIDEN | SQL Table | S10B80.SATURN | Join |
APVCHLD | SQL View | S10B80.BANINST1 | Use (select) |
F_CHECK_FOR_MORE | SQL Function | S10B80.BANINST1 | Use (select) |
APRCHLD_REC | Oracle Package Variable | S10B80.BANINST1.BWDKCPRF | Rely On |
APRCHLDVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKCPRF | Use (select)Rely On |
APRCHLD_MAX_SEQ_NO_C | Oracle Package Cursor | S10B80.BANINST1.APKLDRD | Use (select) |
UT_AB_ADV_INDIVIDUALDELETEAPI | Oracle Package Procedure | S10B80.BANINST1.UT_AB_ADV_INDIVIDUAL | Use (Insert) |
P_LOAD_APRCHLD | Oracle Package Procedure | S10B80.BANINST1.APKLDRD | Rely On |
P_LOAD_APRCHLD | Oracle Package Procedure | S10B80.BANINST1.APKLDRD | Use (Insert,update,select)Rely On |
F_GET_CHILD_CHANGES_IND | Oracle Package Function | S10B80.BANINST1.APKWIND | Use (select) |
F_INLONG_APRCHLD | Oracle Package Function | S10B80.BANINST1.AOKLONG | Use (select) |
F_LONGTOCHAR_APRCHLD | Oracle Package Function | S10B80.BANINST1.AOKLONG | Use (select) |
APRCHLD | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_APRCHLD | SQL Index | S10B80.ALUMNI | Rely On |
APBCONS | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVXREF | SQL Table | S10B80.ALUMNI | Refer (no action) |
SPBPERS | SQL Table | S10B80.SATURN | Join |
STVATYP | SQL Table | S10B80.SATURN | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:45:33:000 | 04/02/2008 13:49:21:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
APRCSPS_PIDM |   | NUMBER(8,0) | No |   | * |
APRCSPS_MARS_IND |   | VARCHAR2(1) | No |   |   |
APRCSPS_ACTIVITY_DATE |   | DATE | No |   |   |
APRCSPS_SPS_PIDM |   | NUMBER(8,0) | Yes |   | * |
APRCSPS_LAST_NAME |   | VARCHAR2(60) | Yes |   |   |
APRCSPS_FIRST_NAME |   | VARCHAR2(60) | Yes |   |   |
APRCSPS_MAIDEN_NAME |   | VARCHAR2(60) | Yes |   |   |
APRCSPS_NAME_PREFIX |   | VARCHAR2(20) | Yes |   |   |
APRCSPS_NAME_SUFFIX |   | VARCHAR2(20) | Yes |   |   |
APRCSPS_BIRTH_DATE |   | DATE | Yes |   |   |
APRCSPS_SPS_COMMENT |   | VARCHAR2(60) | Yes |   |   |
APRCSPS_MRTL_CODE |   | VARCHAR2(1) | Yes |   | * |
APRCSPS_MRTL_START_DATE |   | DATE | Yes |   |   |
APRCSPS_MRTL_END_DATE |   | DATE | Yes |   |   |
APRCSPS_DEAD_IND |   | VARCHAR2(1) | Yes |   |   |
APRCSPS_DEAD_DATE |   | DATE | Yes |   |   |
APRCSPS_XREF_CODE |   | VARCHAR2(3) | Yes |   | * |
APRCSPS_MI |   | VARCHAR2(60) | Yes |   |   |
APRCSPS_SURNAME_PREFIX |   | VARCHAR2(60) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
APRCSPS_PIDM | APBCONS_PIDM | APBCONS |
APRCSPS_XREF_CODE | ATVXREF_CODE | ATVXREF |
APRCSPS_MRTL_CODE | STVMRTL_CODE | STVMRTL |
APRCSPS_SPS_PIDM | SPBPERS_PIDM | SPBPERS |
APRCSPS_PIDM | APRDHIS_PIDM | APRDHIS |
APRCSPS_PIDM | APRCHIS_PIDM | APRCHIS |
APRCSPS_SPS_PIDM | APRCATG_PIDM | APRCATG |
Index Name | Index Type | Column Name |
---|---|---|
APRCSPS_KEY_INDEX |   | APRCSPS_PIDM |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
SPRIDEN | SQL Table | S10B80.SATURN | Join |
ADVDSG1 | SQL View | S10B80.BANINST1 | Use (select) |
AFVCMP1 | SQL View | S10B80.BANINST1 | Use (select) |
APVCSPS | SQL View | S10B80.BANINST1 | Use (select) |
F_SPOUSE_INFO | SQL Function | S10B80.BANINST1 | Use (select) |
SPOUSE_TYPE | Oracle Package Type | S10B80.BANINST1.BWAKPLDG | Rely On |
APRCSPSVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKLIBS | Use (select)Rely On |
APRCSPS_REC | Oracle Package Variable | S10B80.BANINST1.BWAKCHIS | Rely On |
APRCSPS_REC | Oracle Package Variable | S10B80.BANINST1.BWDKSRCH | Rely On |
APRCSPS_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPSRC | Rely On |
APRCSPS_REC | Oracle Package Variable | S10B80.BANINST1.BWDKGHIS | Rely On |
APRCSPS_REC | Oracle Package Variable | S10B80.BANINST1.BWDKLIBS | Rely On |
APRCSPS_REC | Oracle Package Variable | S10B80.BANINST1.BWDKCPRF | Rely On |
APRCSPS_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPPRF | Rely On |
APRCSPSVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKSRCH | Use (select)Rely On |
APRCSPSVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPSRC | Use (select)Rely On |
APRCSPSVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKCPRF | Use (select)Rely On |
APRCSPSVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPPRF | Use (select)Rely On |
SPOUSEVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWAKPLDG | Use (select) |
UT_AB_ADV_INDIVIDUALDELETEAPI | Oracle Package Procedure | S10B80.BANINST1.UT_AB_ADV_INDIVIDUAL | Use (Insert) |
P_LOAD_SPOUSE | Oracle Package Procedure | S10B80.BANINST1.APKLDRD | Rely On |
P_LOAD_SPOUSE | Oracle Package Procedure | S10B80.BANINST1.APKLDRD | Use (Insert,update,select)Rely On |
P_SEARCH_RESULTS | Oracle Package Procedure | S10B80.BANINST1.BWDKPSRC | Rely On |
F_CVT_GET_CURR_SPS | Oracle Package Function | S10B80.BANINST1.AOKLIBS | Use (select) |
APRCSPS | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
APRCSPS_KEY_INDEX | SQL Index | S10B80.ALUMNI | Rely On |
APBCONS | SQL Table | S10B80.ALUMNI | Refer (no action) |
APRCATG | SQL Table | S10B80.ALUMNI | Join |
APRCHIS | SQL Table | S10B80.ALUMNI | Join |
APRDHIS | SQL Table | S10B80.ALUMNI | Join |
ATVXREF | SQL Table | S10B80.ALUMNI | Refer (no action) |
SPBPERS | SQL Table | S10B80.SATURN | Join |
STVMRTL | SQL Table | S10B80.SATURN | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:41:44:000 | 04/02/2008 13:49:16:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
APRDHIS_PIDM |   | NUMBER(8,0) | No | * |   |
APRDHIS_DESG |   | VARCHAR2(10) | No | * |   |
APRDHIS_FISC_CODE |   | NUMBER(4,0) | No | * | * |
APRDHIS_AMT_PLEDGED |   | NUMBER(13,2) | Yes |   |   |
APRDHIS_AMT_PLEDGED_PAID |   | NUMBER(13,2) | Yes |   |   |
APRDHIS_AMT_GIFT |   | NUMBER(13,2) | Yes |   |   |
APRDHIS_AMT_MEMO |   | NUMBER(13,2) | Yes |   |   |
APRDHIS_ACTIVITY_DATE |   | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
APRDHIS_FISC_CODE | ATVFISC_CODE | ATVFISC |
Index Name | Index Type | Column Name |
---|---|---|
APRDHIS_KEY_INDEX2 |   | APRDHIS_FISC_CODE |
APRDHIS_KEY_INDEX2 |   | APRDHIS_PIDM |
APRDHIS_KEY_INDEX3 |   | APRDHIS_DESG |
PK_APRDHIS | Unique | APRDHIS_PIDM |
PK_APRDHIS | Unique | APRDHIS_DESG |
PK_APRDHIS | Unique | APRDHIS_FISC_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
ADBDESG | SQL Table | S10B80.ALUMNI | Join |
APBCONS | SQL Table | S10B80.ALUMNI | Join |
APRCSPS | SQL Table | S10B80.ALUMNI | Join |
SPBPERS | SQL Table | S10B80.SATURN | Join |
SPRIDEN | SQL Table | S10B80.SATURN | Join |
ADVDSG1 | SQL View | S10B80.BANINST1 | Use (select) |
AGVDHIS | SQL View | S10B80.BANINST1 | Use (select) |
F_DESIGNATION_GIVING | SQL Function | S10B80.BANINST1 | Use (select) |
F_SPOUSE_DESG_GIVING_INFO | SQL Function | S10B80.BANINST1 | Use (select) |
DESGDHIS_TYPE | Oracle Package Type | S10B80.BANINST1.BWAKCHIS | Rely On |
DESGDHIS_TYPE | Oracle Package Type | S10B80.BANINST1.BWDKGHIS | Rely On |
DESGDHISVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWAKCHIS | Use (select) |
DESGDHISVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKGHIS | Use (select) |
P_APRDHIS | Oracle Package Procedure | S10B80.BANINST1.AGKGIFT | Rely On |
P_APRDHIS | Oracle Package Procedure | S10B80.BANINST1.AGKGIFT | Use (Insert,update,select) |
APRDHIS | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
APRDHIS_KEY_INDEX2 | SQL Index | S10B80.ALUMNI | Rely On |
APRDHIS_KEY_INDEX3 | SQL Index | S10B80.ALUMNI | Rely On |
PK_APRDHIS | SQL Index | S10B80.ALUMNI | Rely On |
ATVFISC | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:40:55:000 | 04/02/2008 13:49:15: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 |
---|---|---|---|---|---|
APRXREF_PIDM |   | NUMBER(8,0) | No | * |   |
APRXREF_XREF_CODE |   | VARCHAR2(3) | No | * | * |
APRXREF_XREF_PIDM |   | NUMBER(8,0) | No | * | * |
APRXREF_ACTIVITY_DATE |   | DATE | No |   |   |
APRXREF_CM_PRI_IND |   | VARCHAR2(1) | Yes |   |   |
APRXREF_HOUSEHOLD_IND |   | VARCHAR2(1) | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
APRXREF_XREF_CODE | ATVXREF_CODE | ATVXREF |
APRXREF_XREF_PIDM | APBCONS_PIDM | APBCONS |
APRXREF_XREF_PIDM | SPBPERS_PIDM | SPBPERS |
APRXREF_XREF_CODE | AGBSPRL_XREF_CODE | AGBSPRL |
Index Name | Index Type | Column Name |
---|---|---|
PK_APRXREF | Unique | APRXREF_PIDM |
PK_APRXREF | Unique | APRXREF_XREF_CODE |
PK_APRXREF | Unique | APRXREF_XREF_PIDM |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AGBIDRL | SQL Table | S10B80.ALUMNI | Join |
AGRIDRL | SQL Table | S10B80.ALUMNI | Join |
AGRSPRL | SQL Table | S10B80.ALUMNI | Join |
APREHIS | SQL Table | S10B80.ALUMNI | Join |
SPRIDEN | SQL Table | S10B80.SATURN | Join |
APVSHR1 | SQL View | S10B80.BANINST1 | Use (select) |
APVXREF | SQL View | S10B80.BANINST1 | Use (select) |
F_CHECK_FOR_MORE | SQL Function | S10B80.BANINST1 | Use (select) |
F_CROSS_REFERENCE_INFO | SQL Function | S10B80.BANINST1 | Use (select) |
DISXREF_TYPE | Oracle Package Type | S10B80.BANINST1.BWAKCHIS | Rely On |
DISXREF_TYPE | Oracle Package Type | S10B80.BANINST1.BWDKGHIS | Rely On |
APRXREF_REC | Oracle Package Variable | S10B80.BANINST1.BWAKCHIS | Rely On |
APRXREF_REC | Oracle Package Variable | S10B80.BANINST1.BWDKGHIS | Rely On |
APRXREF_REC | Oracle Package Variable | S10B80.BANINST1.BWDKCPRF | Rely On |
APRXREFSPOUSEVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWAKCHIS | Use (select) |
APRXREFVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWAKCHIS | Use (select)Rely On |
APRXREFVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKGHIS | Use (select)Rely On |
APRXREFVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKCPRF | Use (select)Rely On |
COMCHISVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKGHIS | Use (select) |
DISXREFVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWAKCHIS | Use (select) |
DISXREFVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKGHIS | Use (select) |
INDIVIDSPLITINFOC | Oracle Package Cursor | S10B80.BANINST1.AGKGIFT | Use (select) |
INDIVIDSPLITRULEC | Oracle Package Cursor | S10B80.BANINST1.AGKGIFT | Use (select) |
INSTSPLITINFOC | Oracle Package Cursor | S10B80.BANINST1.AGKGIFT | Use (select) |
INSTSPLITRULEC | Oracle Package Cursor | S10B80.BANINST1.AGKGIFT | Use (select) |
SPLITINDIVIDC | Oracle Package Cursor | S10B80.BANINST1.BWAKCPMT | Use (select) |
SPLITINSTC | Oracle Package Cursor | S10B80.BANINST1.BWAKCPMT | Use (select) |
XREF_CHIS_CURSOR | Oracle Package Cursor | S10B80.BANINST1.BWAKCHIS | Use (select) |
XREF_CHIS_CURSOR | Oracle Package Cursor | S10B80.BANINST1.BWDKGHIS | Use (select) |
P_INSERT_AGTOGIV_DATA | Oracle Package Procedure | S10B80.BANINST1.AGKGRPT | Use (select) |
SPOUSE_PIDM | Oracle Package Variable | S10B80.BANINST1.BWAKCHIS | Rely On |
P_APTADDR_IN_USE | Oracle Package Procedure | S10B80.BANINST1.AOKHHLD | Use (select) |
P_EVALUATE_MG_ELIGIBILITY | Oracle Package Procedure | S10B80.BANINST1.AXKEXMG | Use (select) |
P_LOAD_APRXREF | Oracle Package Procedure | S10B80.BANINST1.APKLDRD | Rely On |
P_LOAD_APRXREF | Oracle Package Procedure | S10B80.BANINST1.APKLDRD | Use (Insert,select) |
F_GET_PRIMARY_SPS_PIDM | Oracle Package Function | S10B80.BANINST1.AOKLIBS | Use (select) |
F_HOUSEHOLD_COUNT | Oracle Package Function | S10B80.BANINST1.AOKHHLD | Use (select) |
F_HOUSEHOLD_PIDM | Oracle Package Function | S10B80.BANINST1.AOKHHLD | Use (select) |
APRXREF | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_APRXREF | SQL Index | S10B80.ALUMNI | Rely On |
AGBSPRL | SQL Table | S10B80.ALUMNI | Join |
APBCONS | SQL Table | S10B80.ALUMNI | Join |
ATVXREF | SQL Table | S10B80.ALUMNI | Refer (no action) |
SPBPERS | SQL Table | S10B80.SATURN | Join |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:41:27:000 | 04/02/2008 13:49:16:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
ASRSSAG_SOL_ORG |   | VARCHAR2(5) | No | * | * |
ASRSSAG_PIDM |   | NUMBER(8,0) | No | * | * |
ASRSSAG_DCYR_CODE |   | NUMBER(4,0) | No | * | * |
ASRSSAG_ACTIVITY_DATE |   | DATE | No |   |   |
ASRSSAG_USER |   | VARCHAR2(30) | No |   |   |
ASRSSAG_DOLLAR_GOAL |   | NUMBER(11,2) | Yes |   |   |
ASRSSAG_PARTICIPATION_GOAL |   | NUMBER(6,0) | Yes |   |   |
ASRSSAG_DONOR_COUNT_GOAL |   | NUMBER(6,0) | Yes |   |   |
ASRSSAG_REPORT_TO_PIDM |   | NUMBER(8,0) | Yes |   |   |
ASRSSAG_MAX_CONTACTS |   | NUMBER(3,0) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
ASRSSAG_DCYR_CODE | ATVDCYR_CODE | ATVDCYR |
ASRSSAG_SOL_ORG | ASBSORG_SOL_ORG | ASBSORG |
ASRSSAG_PIDM | APBCONS_PIDM | APBCONS |
Index Name | Index Type | Column Name |
---|---|---|
PK_ASRSSAG | Unique | ASRSSAG_SOL_ORG |
PK_ASRSSAG | Unique | ASRSSAG_PIDM |
PK_ASRSSAG | Unique | ASRSSAG_DCYR_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
ASRSORG | SQL Table | S10B80.ALUMNI | Join |
SPRIDEN | SQL Table | S10B80.SATURN | Join |
ASVSSAG | SQL View | S10B80.BANINST1 | Use (select) |
ASVYEAR | SQL View | S10B80.BANINST1 | Use (select) |
ASRSSAG | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_ASRSSAG | SQL Index | S10B80.ALUMNI | Rely On |
APBCONS | SQL Table | S10B80.ALUMNI | Join |
ASBSORG | SQL Table | S10B80.ALUMNI | Refer (no action) |
ATVDCYR | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:46:31:000 | 04/02/2008 13:49:22:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
ATVDOTT_CODE |   | VARCHAR2(4) | No | * |   |
ATVDOTT_DESC |   | VARCHAR2(60) | No |   |   |
ATVDOTT_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_ATVDOTT | Unique | ATVDOTT_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
APBCONS | SQL Table | S10B80.ALUMNI | Refer (no action) |
F_GET_DESC_ALUMNI | SQL Function | S10B80.BANINST1 | Use (select) |
DOTT_TYPE | Oracle Package Type | S10B80.BANINST1.BWAKADVS | Rely On |
ATVDOTT_REC | Oracle Package Variable | S10B80.BANINST1.BWDKCPRF | Rely On |
ATVDOTT_REC | Oracle Package Variable | S10B80.BANINST1.BWAKADVS | Rely On |
ATVDOTTVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKCPRF | Use (select)Rely On |
ATVDOTTVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWAKADVS | Use (select)Rely On |
DOTTVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWAKADVS | Use (select) |
ATVDOTT_C | Oracle Package Cursor | S10B80.BANINST1.AB_ATVDOTT | Rely On |
ATVDOTT_C | Oracle Package Cursor | S10B80.BANINST1.AB_ATVDOTT | Use (select)Rely On |
F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.AB_ATVDOTT | Rely On |
F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.AB_ATVDOTT | Rely On |
ATVDOTT | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_ATVDOTT | SQL Index | S10B80.ALUMNI | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:44:37:000 | 04/02/2008 13:49:20:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
ATVINCM_CODE |   | VARCHAR2(2) | No | * |   |
ATVINCM_DESC |   | VARCHAR2(30) | No |   |   |
ATVINCM_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_ATVINCM | Unique | ATVINCM_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
APBCONS | SQL Table | S10B80.ALUMNI | Refer (no action) |
F_GET_DESC_ALUMNI | SQL Function | S10B80.BANINST1 | Use (select) |
ATVINCM_REC | Oracle Package Variable | S10B80.BANINST1.BWDKSRCH | Rely On |
ATVINCM_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPSRC | Rely On |
ATVINCM_REC | Oracle Package Variable | S10B80.BANINST1.BWDKCPRF | Rely On |
ATVINCMVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKCPRF | Use (select)Rely On |
CONSINCMVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKSRCH | Use (select)Rely On |
CONSINCMVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPSRC | Use (select)Rely On |
ATVINCM_C | Oracle Package Cursor | S10B80.BANINST1.AB_ATVINCM | Rely On |
ATVINCM_C | Oracle Package Cursor | S10B80.BANINST1.AB_ATVINCM | Use (select)Rely On |
F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.AB_ATVINCM | Rely On |
F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.AB_ATVINCM | Rely On |
ATVINCM | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_ATVINCM | SQL Index | S10B80.ALUMNI | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:42:40:000 | 04/02/2008 13:49:18: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 |
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 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
STVCOLL_CODE |   | VARCHAR2(2) | No | * |   |
STVCOLL_DESC |   | VARCHAR2(30) | No |   |   |
STVCOLL_ADDR_STREET_LINE1 |   | VARCHAR2(75) | Yes |   |   |
STVCOLL_ADDR_STREET_LINE2 |   | VARCHAR2(75) | Yes |   |   |
STVCOLL_ADDR_STREET_LINE3 |   | VARCHAR2(75) | Yes |   |   |
STVCOLL_ADDR_CITY |   | VARCHAR2(50) | Yes |   |   |
STVCOLL_ADDR_STATE |   | VARCHAR2(2) | Yes |   |   |
STVCOLL_ADDR_COUNTRY |   | VARCHAR2(28) | Yes |   |   |
STVCOLL_ADDR_ZIP_CODE |   | VARCHAR2(10) | Yes |   |   |
STVCOLL_ACTIVITY_DATE |   | DATE | Yes |   |   |
STVCOLL_SYSTEM_REQ_IND |   | VARCHAR2(1) | Yes |   |   |
STVCOLL_VR_MSG_NO |   | NUMBER(6,0) | Yes |   |   |
STVCOLL_STATSCAN_CDE3 |   | VARCHAR2(6) | Yes |   |   |
STVCOLL_DICD_CODE |   | VARCHAR2(3) | Yes |   |   |
STVCOLL_HOUSE_NUMBER |   | VARCHAR2(10) | Yes |   |   |
STVCOLL_ADDR_STREET_LINE4 |   | VARCHAR2(75) | Yes |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_STVCOLL | Unique | STVCOLL_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
AABMINT | SQL Table | S10B80.ALUMNI | Refer (no action) |
ADBDESG | SQL Table | S10B80.ALUMNI | Refer (no action) |
APBCONS | SQL Table | S10B80.ALUMNI | Refer (no action) |
APRADEG | SQL Table | S10B80.ALUMNI | Refer (no action) |
ASBSORG | SQL Table | S10B80.ALUMNI | Refer (no action) |
GTVEMPH | SQL Table | S10B80.GENERAL | Refer (no action) |
PEBEMPL | SQL Table | S10B80.PAYROLL | Refer (no action) |
PERFASG | SQL Table | S10B80.PAYROLL | Refer (no action) |
PERFNIO | SQL Table | S10B80.PAYROLL | Refer (no action) |
PERFNIS | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTRSCHD | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTRSCLV | SQL Table | S10B80.PAYROLL | Refer (no action) |
SARADAP | SQL Table | S10B80.SATURN | Refer (no action) |
SARCHKB | SQL Table | S10B80.SATURN | Refer (no action) |
SARDCSN | SQL Table | S10B80.SATURN | Refer (no action) |
SARQKER | SQL Table | S10B80.SATURN | Refer (no action) |
SARRRFT | SQL Table | S10B80.SATURN | Refer (no action) |
SARWAAD | SQL Table | S10B80.SATURN | Refer (no action) |
SARWADF | SQL Table | S10B80.SATURN | Refer (no action) |
SCBCDEP | SQL Table | S10B80.SATURN | Refer (no action) |
SCBCDTL | SQL Table | S10B80.SATURN | Refer (no action) |
SCBCRSE | SQL Table | S10B80.SATURN | Refer (no action) |
SCRCDTX | SQL Table | S10B80.SATURN | Refer (no action) |
SCRFEES | SQL Table | S10B80.SATURN | Refer (no action) |
SCRRCOL | SQL Table | S10B80.SATURN | Refer (no action) |
SDBPROG | SQL Table | S10B80.SATURN | Refer (no action) |
SFRMHRS | SQL Table | S10B80.SATURN | Refer (no action) |
SFRRGFE | SQL Table | S10B80.SATURN | Refer (no action) |
SFRTMSL | SQL Table | S10B80.SATURN | Refer (no action) |
SFRTMST | SQL Table | S10B80.SATURN | Refer (no action) |
SGBSTDN | SQL Table | S10B80.SATURN | Refer (no action) |
SGRASSI | SQL Table | S10B80.SATURN | Refer (no action) |
SHBCOMI | SQL Table | S10B80.SATURN | Refer (no action) |
SHBGADS | SQL Table | S10B80.SATURN | Refer (no action) |
SHBGELR | SQL Table | S10B80.SATURN | Refer (no action) |
SHBGSCH | SQL Table | S10B80.SATURN | Refer (no action) |
SHRASDL | SQL Table | S10B80.SATURN | Refer (no action) |
SHRASGE | SQL Table | S10B80.SATURN | Refer (no action) |
SHRASTR | SQL Table | S10B80.SATURN | Refer (no action) |
SHRCAST | SQL Table | S10B80.SATURN | Refer (no action) |
SHRCOMM | SQL Table | S10B80.SATURN | Refer (no action) |
SHRDGMR | SQL Table | S10B80.SATURN | Refer (no action) |
SHRPREV | SQL Table | S10B80.SATURN | Refer (no action) |
SHRPRGE | SQL Table | S10B80.SATURN | Refer (no action) |
SHRTCKN | SQL Table | S10B80.SATURN | Refer (no action) |
SIRDPCL | SQL Table | S10B80.SATURN | Refer (no action) |
SIRNIST | SQL Table | S10B80.SATURN | Refer (no action) |
SIRNLVA | SQL Table | S10B80.SATURN | Refer (no action) |
SMRACAA | SQL Table | S10B80.SATURN | Refer (no action) |
SMRAQUA | SQL Table | S10B80.SATURN | Refer (no action) |
SMRAREX | SQL Table | S10B80.SATURN | Refer (no action) |
SMRARSA | SQL Table | S10B80.SATURN | Refer (no action) |
SMRARUL | SQL Table | S10B80.SATURN | Refer (no action) |
SMRGCAA | SQL Table | S10B80.SATURN | Refer (no action) |
SMRGREX | SQL Table | S10B80.SATURN | Refer (no action) |
SMRGRSA | SQL Table | S10B80.SATURN | Refer (no action) |
SMRGRUL | SQL Table | S10B80.SATURN | Refer (no action) |
SMRIECO | SQL Table | S10B80.SATURN | Refer (no action) |
SMRPCRS | SQL Table | S10B80.SATURN | Refer (no action) |
SMRPRLE | SQL Table | S10B80.SATURN | Refer (no action) |
SMRPRRQ | SQL Table | S10B80.SATURN | Refer (no action) |
SMRPRSA | SQL Table | S10B80.SATURN | Refer (no action) |
SMRRQCM | SQL Table | S10B80.SATURN | Refer (no action) |
SMRSACA | SQL Table | S10B80.SATURN | Refer (no action) |
SMRSARE | SQL Table | S10B80.SATURN | Refer (no action) |
SMRSARS | SQL Table | S10B80.SATURN | Refer (no action) |
SMRSARU | SQL Table | S10B80.SATURN | Refer (no action) |
SMRSGCA | SQL Table | S10B80.SATURN | Refer (no action) |
SMRSGRE | SQL Table | S10B80.SATURN | Refer (no action) |
SMRSGRS | SQL Table | S10B80.SATURN | Refer (no action) |
SMRSGRU | SQL Table | S10B80.SATURN | Refer (no action) |
SMRSPRS | SQL Table | S10B80.SATURN | Refer (no action) |
SMTPRRQ | SQL Table | S10B80.SATURN | Refer (no action) |
SOBCSPR | SQL Table | S10B80.SATURN | Refer (no action) |
SOBCURR | SQL Table | S10B80.SATURN | Refer (no action) |
SOBEXCR | SQL Table | S10B80.SATURN | Refer (no action) |
SOBODTE | SQL Table | S10B80.SATURN | Refer (no action) |
SOBROPR | SQL Table | S10B80.SATURN | Refer (no action) |
SORCCOL | SQL Table | S10B80.SATURN | Refer (no action) |
SORCOMM | SQL Table | S10B80.SATURN | Refer (no action) |
SORDEGR | SQL Table | S10B80.SATURN | Refer (no action) |
SOREQUI | SQL Table | S10B80.SATURN | Refer (no action) |
SOREXTN | SQL Table | S10B80.SATURN | Refer (no action) |
SORLCDF | SQL Table | S10B80.SATURN | Refer (no action) |
SORLCUR | SQL Table | S10B80.SATURN | Refer (no action) |
SORRFND | SQL Table | S10B80.SATURN | Refer (no action) |
SORRSTS | SQL Table | S10B80.SATURN | Refer (no action) |
SORWDSP | SQL Table | S10B80.SATURN | Join |
SRBPRED | SQL Table | S10B80.SATURN | Refer (no action) |
SRBRECR | SQL Table | S10B80.SATURN | Refer (no action) |
SRTPREL | SQL Table | S10B80.SATURN | Refer (no action) |
SSBDFEE | SQL Table | S10B80.SATURN | Refer (no action) |
SSBOVRR | SQL Table | S10B80.SATURN | Refer (no action) |
SSRFEES | SQL Table | S10B80.SATURN | Refer (no action) |
SSRRCOL | SQL Table | S10B80.SATURN | Refer (no action) |
SSRRESV | SQL Table | S10B80.SATURN | Refer (no action) |
ST_STVCOLL_AR_LDI | SQL Trigger | S10B80.SATURN | Rely On |
AG_EVENTS_AND_FUNCTIONS | SQL View | S10B80.BANINST1 | Use (select) |
GEVEVN1 | SQL View | S10B80.BANINST1 | Join |
SAVADMT | SQL View | S10B80.BANINST1 | Use (select) |
SOVCOLL | SQL View | S10B80.BANINST1 | Use (select) |
SOVDATA | SQL View | S10B80.BANINST1 | Use (select) |
SOVDEGR | SQL View | S10B80.BANINST1 | Use (select) |
SOVDGMR | SQL View | S10B80.BANINST1 | Use (select) |
SOVDGMR_OJ | SQL View | S10B80.BANINST1 | Use (select) |
SOVSTDN | SQL View | S10B80.BANINST1 | Use (select) |
F_GET_DESC_ALUMNI | SQL Function | S10B80.BANINST1 | Use (select) |
F_GET_DESC_FNC | SQL Function | S10B80.BANINST1 | Use (select) |
F_STUDENT_GET_DESC | SQL Function | S10B80.BANINST1 | Use (select) |
COLLEGE_REC_TYPE | Oracle Package Type | S10B80.BANINST1.ICSCKCOM | Rely On |
COLL_TYPE | Oracle Package Type | S10B80.BANINST1.BWAKSRCH | Rely On |
SORCMJRC | Oracle Package Cursor | S10B80.BANINST1.BWSKXMIS | Use (select) |
STVCOLLVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKLIBS | Use (select)Rely On |
STVCOLL_TAB_TYPE | Oracle Package Type | S10B80.BANINST1.SOKTABS | Rely On |
STVCOLL_REC | Oracle Package Variable | S10B80.BANINST1.BWDKSRCH | Rely On |
STVCOLL_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPSRC | Rely On |
STVCOLL_REC | Oracle Package Variable | S10B80.BANINST1.BWDKLIBS | Rely On |
STVCOLL_REC | Oracle Package Variable | S10B80.BANINST1.BWDKCPRF | Rely On |
COLLEGE_REC_TYPE | Oracle Package Type | S10B80.BANINST1.ICSCKLDI | Rely On |
GT_CURRICULUM_REC | Oracle Package Type | S10B80.BANINST1.SP_HOUSING_PROFILE | Rely On |
GETSTVCOLLC | Oracle Package Cursor | S10B80.BANINST1.BWAKALOG | Use (select)Rely On |
PREFCOLLVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKSRCH | Use (select)Rely On |
PREFCOLLVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPSRC | Use (select)Rely On |
STVCOLLVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKSRCH | Use (select)Rely On |
STVCOLLVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPSRC | Use (select)Rely On |
STVCOLLVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKCPRF | Use (select)Rely On |
STVCOLL_ADDRESSC | Oracle Package Cursor | S10B80.BANINST1.BWSKWTRR | Rely On |
STVCOLL_ADDRESSC | Oracle Package Cursor | S10B80.BANINST1.BWSKWTRR | Use (select) |
STVCOLL_C | Oracle Package Cursor | S10B80.BANINST1.BWCKSMDS | Use (select) |
STVCOLL_LISTC | Oracle Package Cursor | S10B80.BANINST1.BWSKWTRR | Use (select) |
P_CREATE_APPL | Oracle Package Procedure | S10B80.BANINST1.TS_STUDENT_OAPERF | Rely On |
P_DELETE_ALL | Oracle Package Procedure | S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBCVAR | Use (delete,select) |
P_LEARNER_CURRICULUM | Oracle Package Procedure | S10B80.BANINST1.TS_SB_FEEASSESSMENT_ASSMT | Rely On |
P_LEARNER_CURRICULUM | Oracle Package Procedure | S10B80.BANINST1.TS_SB_GRADEROLL | Rely On |
P_LEARNER_CURRICULUM | Oracle Package Procedure | S10B80.BANINST1.TS_SB_REGISTRATION | Rely On |
P_LEARNER_CURRICULUM | Oracle Package Procedure | S10B80.BANINST1.TS_SB_FEEASSESSMENT_RULES | Rely On |
P_LEARNER_CURRICULUM | Oracle Package Procedure | S10B80.BANINST1.TS_SB_CURRICULUM | Rely On |
P_ONETIMEVALUES | Oracle Package Procedure | S10B80.BANINST1.TS_STUDENT_OAPERF | Rely On |
P_ONETIMEVALUES | Oracle Package Procedure | S10B80.BANINST1.TS_STUDENT_OAPERF | Use (Insert,select) |
P_PRINT_COLLEGES | Oracle Package Procedure | S10B80.BANINST1.BWPKFLTR | Rely On |
P_PROC_SET_INFO | Oracle Package Procedure | S10B80.BANINST1.BWSKWTRR | Rely On |
P_SFRRGFE | Oracle Package Procedure | S10B80.BANINST1.TS_SB_FEEASSESSMENT_ASSMT | Rely On |
P_SFRRGFE | Oracle Package Procedure | S10B80.BANINST1.TS_SB_FEEASSESSMENT_RULES | Rely On |
P_VALIDATION | Oracle Package Procedure | S10B80.BANINST1.TS_STUDENT_OAPERF | Use (Insert) |
P_VALIDATION_DATA | Oracle Package Procedure | S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBC | Use (Insert) |
P_VALIDATION_DATA | Oracle Package Procedure | S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBT | Use (Insert) |
P_VALIDATION_DATA | Oracle Package Procedure | S10B80.BANINST1.TS_SB_FEEASSESSMENT_ASSMT | Use (Insert) |
P_VALIDATION_DATA | Oracle Package Procedure | S10B80.BANINST1.TS_SB_FEEASSESSMENT_RBCVAR | Use (Insert) |
P_VALIDATION_DATA | Oracle Package Procedure | S10B80.BANINST1.TS_SB_GRADEROLL | Use (Insert) |
P_VALIDATION_DATA | Oracle Package Procedure | S10B80.BANINST1.TS_SB_REGISTRATION | Use (Insert) |
P_VALIDATION_DATA | Oracle Package Procedure | S10B80.BANINST1.TS_SB_FEEASSESSMENT_RULES | Use (Insert) |
P_VALIDATION_DATA | Oracle Package Procedure | S10B80.BANINST1.TS_SB_FEEASSESSMENT_DD | Use (Insert) |
P_VALIDATION_DATA | Oracle Package Procedure | S10B80.BANINST1.TS_SB_CURRICULUM | Use (Insert) |
P_VALIDATION_DATA | Oracle Package Procedure | S10B80.BANINST1.TS_SB_FEEASSESSMENT_SWAPPING | Use (Insert) |
TESTCASE_CC | Oracle Package Procedure | S10B80.BANINST1.TS_SB_FEEASSESSMENT_RULES | Rely On |
STVCOLL_REC | Oracle Package Variable | S10B80.BANINST1.BWSKRSTA | Rely On |
STVCOLL_REC | Oracle Package Variable | S10B80.BANINST1.BWAKALOG | Rely On |
APBCONSCOLLSVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWAKSRCH | Use (select) |
STVCOLLC | Oracle Package Cursor | S10B80.BANINST1.STKCOLL | Use (select)Rely On |
STVCOLL_C | Oracle Package Cursor | S10B80.BANINST1.GB_STVCOLL | Rely On |
STVCOLL_C | Oracle Package Cursor | S10B80.BANINST1.GB_STVCOLL | Use (select)Rely On |
STVCOLL_WDSP_C | Oracle Package Cursor | S10B80.BANINST1.BWCKLIBS | Use (select)Rely On |
P_CAT_SEARCH | Oracle Package Procedure | S10B80.BANINST1.BWCKCTLG | Rely On |
P_CHECKBASE | Oracle Package Procedure | S10B80.BANINST1.SOKCURR | Rely On |
P_CHECKCURRICULUM | Oracle Package Procedure | S10B80.BANINST1.SOKCURR | Rely On |
P_CHECKPROGRAMMAJOR | Oracle Package Procedure | S10B80.BANINST1.SOKCURR | Rely On |
P_CREATE_SECTION_DFT_RULES | Oracle Package Procedure | S10B80.BANINST1.SSKOLRP | Rely On |
P_DELETE_STVCOLL | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_DELETE_STVCOLL | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (delete) |
P_DISPCURRENT_TABLE | Oracle Package Procedure | S10B80.BANINST1.BWCKCAPP | Rely On |
P_DISPLAY_COURSES | Oracle Package Procedure | S10B80.BANINST1.SB_COURSE_CATALOG | Rely On |
P_DISPLAY_COURSES | Oracle Package Procedure | S10B80.BANINST1.BWCKCTLG | Rely On |
P_DISPLAY_INFO | Oracle Package Procedure | S10B80.BANINST1.BWCKCTLG | Rely On |
P_DISPLAY_INFO | Oracle Package Procedure | S10B80.BANINST1.BWCKCTLG | Use (select)Rely On |
P_DISPLAY_STEP_EIGHT | Oracle Package Procedure | S10B80.BANINST1.BWCKSMDS | Rely On |
P_DISPLAY_STEP_FIVE | Oracle Package Procedure | S10B80.BANINST1.BWCKSMDS | Rely On |
P_DISPLAY_STEP_FOUR | Oracle Package Procedure | S10B80.BANINST1.BWCKSMDS | Rely On |
P_DISPLAY_STEP_NINE | Oracle Package Procedure | S10B80.BANINST1.BWCKSMDS | Rely On |
P_DISPLAY_STEP_SEVEN | Oracle Package Procedure | S10B80.BANINST1.BWCKSMDS | Rely On |
P_DISPLAY_STEP_SIX | Oracle Package Procedure | S10B80.BANINST1.BWCKSMDS | Rely On |
P_DISPLAY_STEP_THREE | Oracle Package Procedure | S10B80.BANINST1.BWCKSMDS | Rely On |
P_DISPLAY_STEP_THREE | Oracle Package Procedure | S10B80.BANINST1.BWCKSMDS | Use (select)Rely On |
P_DISP_CONFIRM | Oracle Package Procedure | S10B80.BANINST1.BWSKWTRR | Rely On |
P_DISP_PAYMENT_TYPE | Oracle Package Procedure | S10B80.BANINST1.BWSKWTRR | Rely On |
P_DISP_TRANSCRIPT_ADDRESS | Oracle Package Procedure | S10B80.BANINST1.BWSKWTRR | Rely On |
P_DISP_TRANSCRIPT_REQUEST_DATA | Oracle Package Procedure | S10B80.BANINST1.BWSKWTRR | Rely On |
P_DISP_TRANSCRIPT_REQUEST_TYPE | Oracle Package Procedure | S10B80.BANINST1.BWSKWTRR | Rely On |
P_DISP_TRANS_REQUEST_CHARGES | Oracle Package Procedure | S10B80.BANINST1.BWSKWTRR | Rely On |
P_DO_WHATIF_CAPP | Oracle Package Procedure | S10B80.BANINST1.BWCKCMPL | Rely On |
P_FACCLAWAITSUM | Oracle Package Procedure | S10B80.BANINST1.BWLKFCWL | Rely On |
P_FACSCHED | Oracle Package Procedure | S10B80.BANINST1.BWLKIFAC | Rely On |
P_FORMAT_BASE_CURR | Oracle Package Procedure | S10B80.BANINST1.BWCKSMDS | Rely On |
P_GETACCESSIBLECOLLDEPT | Oracle Package Procedure | S10B80.BANINST1.SOKEPRT | Use (select) |
P_GET_SMBPOGN | Oracle Package Procedure | S10B80.BANINST1.SMKXAPI | Rely On |
P_GET_SMRAOSA | Oracle Package Procedure | S10B80.BANINST1.SMKXAPI | Rely On |
P_GET_SMRDOEX | Oracle Package Procedure | S10B80.BANINST1.SMKXAPI | Rely On |
P_GET_SMRGOSA | Oracle Package Procedure | S10B80.BANINST1.SMKXAPI | Rely On |
P_GET_SMRPOSA | Oracle Package Procedure | S10B80.BANINST1.SMKXAPI | Rely On |
P_GET_SMRRQCM | Oracle Package Procedure | S10B80.BANINST1.SMKXAPI | Rely On |
P_GET_STVCOLL_ROW | Oracle Package Procedure | S10B80.BANINST1.STKSELS | Rely On |
P_INSERT_STVCOLL | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_INSERT_STVCOLL | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (Insert) |
P_INSERT_WHATIF_SMRRQCM | Oracle Package Procedure | S10B80.BANINST1.BWCKCMPL | Rely On |
P_MIGRATE_PROSPECT | Oracle Package Procedure | S10B80.BANINST1.SRKPREL | Rely On |
P_PRINT_CRSE_INFO_WINDOW | Oracle Package Procedure | S10B80.BANINST1.BWPKFLDT | Rely On |
P_SAVE_COLLEGE | Oracle Package Procedure | S10B80.BANINST1.ICSCKLDI | Rely On |
P_SEND_COLLEGE | Oracle Package Procedure | S10B80.BANINST1.ICSCKLDI | Rely On |
P_UPDATE_STVCOLL | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_UPDATE_STVCOLL | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (update) |
P_VALIDATE | Oracle Package Procedure | S10B80.BANINST1.AOKPVAL | Rely On |
P_VERIFYDATA | Oracle Package Procedure | S10B80.BANINST1.SOKCURR | Rely On |
P_WHATIF_FINAL_STEP | Oracle Package Procedure | S10B80.BANINST1.BWCKSMDS | Rely On |
P_WHATIF_NEXT_STEP | Oracle Package Procedure | S10B80.BANINST1.BWCKSMDS | Rely On |
P_WHATIF_SUBMIT | Oracle Package Procedure | S10B80.BANINST1.BWCKSMDS | Rely On |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_FIELDOFSTUDY | Use (Insert) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_AB_ADV_INDIVIDUAL | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_GRADAPP_ELIGIBLE | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_ADMISSIONSAPPLICATION | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_CLASSTIMES | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_LEARNERMODULE | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_TRANSCRIPT_REQ_NAME | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_BLDGDEFINITION | Use (Insert) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_GRADAPP_SELRULE | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_INSTITUTION_ROLE | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_PCOL_DEGREE | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_SECTION | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_FAC_SCHRATE | Use (Insert) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_FAC_NISTCOMP | Use (Insert) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_CURRICULUM | Use (Insert) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SP_HOUSING_PROFILE | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_COURSE | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_FAC_SCLRATE | Use (Insert) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_BLDGDEFINITION | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_WL_NOTIFICATION | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_WL_REORDERING | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_COURSE_LABOR | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SP_LDICOURSE | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_LEARNER | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_WL_EXCLUSION | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_FAC_NIOLCOMP | Use (Insert) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SP_TRANSFER_CRSE | Rely On |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SP_TRANSFER_CRSE | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SP_LDIPERSON | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GP_CARDHOLDER | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_CRSE_SELECT_PRI | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_SECTION_LABOR | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_FACASSIGNMENT | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_FACULTY | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_WL_COLLECTOR | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_WL_SECTION_CTRL | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_LEARNEROUTCOME | Use (Insert,select) |
UT_TEARDOWN | Oracle Package Procedure | S10B80.BANINST1.UT_SB_BLDGDEFINITION | Use (delete) |
F_CHECKCURRICULUM | Oracle Package Function | S10B80.BANINST1.SAKDCRV | Rely On |
F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_STVCOLL | Rely On |
F_COLL_CHK | Oracle Package Function | S10B80.BANINST1.SAKPCOM | Use (select) |
F_FTE_FACTOR | Oracle Package Function | S10B80.BANINST1.SIKLOAD | Rely On |
F_GETCODEDESCRIPTION | Oracle Package Function | S10B80.BANINST1.BWLKSECR | Use (select) |
F_GET_COLLEGE | Oracle Package Function | S10B80.BANINST1.ICSCKLDI | Rely On |
F_GET_COLLEGE | Oracle Package Function | S10B80.BANINST1.ICSCKCOM | Rely On |
F_GET_COLLEGE | Oracle Package Function | S10B80.BANINST1.ICSCKCOM | Use (select) |
F_GET_COLL_DESC | Oracle Package Function | S10B80.BANINST1.STVFUNC | Rely On |
F_GET_COLL_DESC | Oracle Package Function | S10B80.BANINST1.STVFUNC | Use (select) |
F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_STVCOLL | Rely On |
F_MATCH_CURRICULUM | Oracle Package Function | S10B80.BANINST1.SOKCCUR | Rely On |
F_NIST_COMPENSATION_APPLIED | Oracle Package Function | S10B80.BANINST1.SIKAFLA | Rely On |
F_NIST_COMPENSATION_EXTRACTED | Oracle Package Function | S10B80.BANINST1.SIKAFLA | Rely On |
F_STVCOLL_LIKE | Oracle Package Function | S10B80.BANINST1.AOKPVAL | Use (select) |
GET_COLL_DESC | Oracle Package Function | S10B80.BANINST1.BWCKSMDS | Rely On |
GET_COLL_DESC | Oracle Package Function | S10B80.BANINST1.BWCKSMDS | Use (select) |
GET_COLL_DESC | Oracle Package Function | S10B80.BANINST1.BWCKSMLT | Rely On |
GET_COLL_DESC | Oracle Package Function | S10B80.BANINST1.BWCKSMLT | Use (select) |
GET_COLL_DESC | Oracle Package Function | S10B80.BANINST1.BWCKCAPP | Rely On |
GET_COLL_DESC | Oracle Package Function | S10B80.BANINST1.BWCKCAPP | Use (select) |
STVCOLL | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_STVCOLL | SQL Index | S10B80.SATURN | Rely On |
ST_STVCOLL_AR_LDI | SQL Trigger | S10B80.SATURN | Fire (Insert,update,delete,after,each row) |
ST_STVCOLL_AS_LDI | SQL Trigger | S10B80.SATURN | Fire (Insert,update,delete,after,all rows) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:50:54:000 | 04/02/2008 21:18:13:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
STVNATN_CODE |   | VARCHAR2(5) | No | * |   |
STVNATN_NATION |   | VARCHAR2(30) | No |   |   |
STVNATN_CAPITAL |   | VARCHAR2(20) | Yes |   |   |
STVNATN_AREA |   | NUMBER(22,0) | Yes |   |   |
STVNATN_POPULATION |   | NUMBER(22,0) | Yes |   |   |
STVNATN_ACTIVITY_DATE |   | DATE | No |   |   |
STVNATN_EDI_EQUIV |   | VARCHAR2(2) | Yes |   |   |
STVNATN_LMS_EQUIV |   | VARCHAR2(2) | Yes |   |   |
STVNATN_POSTAL_MASK |   | VARCHAR2(15) | Yes |   |   |
STVNATN_TELE_MASK |   | VARCHAR2(15) | Yes |   |   |
STVNATN_STATSCAN_CDE |   | VARCHAR2(5) | Yes |   |   |
STVNATN_SCOD_CODE_ISO |   | VARCHAR2(3) | Yes |   |   |
STVNATN_SSA_REPORTING_EQUIV |   | VARCHAR2(2) | Yes |   |   |
STVNATN_SEVIS_EQUIV |   | VARCHAR2(2) | Yes |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_STVNATN | Unique | STVNATN_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
STVNATN | Oracle Synonym | S10B80.FAISMGR | Rely On |
AORCONT | SQL Table | S10B80.ALUMNI | Refer (no action) |
APBCONS | SQL Table | S10B80.ALUMNI | Refer (no action) |
APBWIDN | SQL Table | S10B80.ALUMNI | Refer (no action) |
GOBINTL | SQL Table | S10B80.GENERAL | Refer (no action) |
GOBSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
GORSEVD | SQL Table | S10B80.GENERAL | Refer (no action) |
GORVISA | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVCURR | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVZIPC | SQL Table | S10B80.GENERAL | Refer (no action) |
GUBINST | SQL Table | S10B80.GENERAL | Refer (no action) |
GURAPAY | SQL Table | S10B80.GENERAL | Refer (no action) |
PPREXPE | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTRHSIL | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTRJBLN | SQL Table | S10B80.PAYROLL | Refer (no action) |
PXRMTER | SQL Table | S10B80.PAYROLL | Refer (no action) |
PXRMTIN | SQL Table | S10B80.PAYROLL | Refer (no action) |
RJBPLBD | SQL Table | S10B80.FAISMGR | Refer (no action) |
RPBLNDR | SQL Table | S10B80.FAISMGR | Refer (no action) |
RPRLAPP | SQL Table | S10B80.FAISMGR | Refer (no action) |
RPRLARF | SQL Table | S10B80.FAISMGR | Refer (no action) |
SABSUPL | SQL Table | S10B80.SATURN | Refer (no action) |
SFRENRL | SQL Table | S10B80.SATURN | Refer (no action) |
SHBDIPL | SQL Table | S10B80.SATURN | Refer (no action) |
SHBGAPP | SQL Table | S10B80.SATURN | Refer (no action) |
SHTTRAN | SQL Table | S10B80.SATURN | Refer (no action) |
SHTTRTC | SQL Table | S10B80.SATURN | Refer (no action) |
SMRPRRQ | SQL Table | S10B80.SATURN | Refer (no action) |
SMTPRRQ | SQL Table | S10B80.SATURN | Refer (no action) |
SOBSBGI | SQL Table | S10B80.SATURN | Refer (no action) |
SPBPERS | SQL Table | S10B80.SATURN | Refer (no action) |
SPRADDR | SQL Table | S10B80.SATURN | Refer (no action) |
SPREMRG | SQL Table | S10B80.SATURN | Refer (no action) |
SPRINTL | SQL Table | S10B80.SATURN | Refer (no action) |
SRTADDR | SQL Table | S10B80.SATURN | Refer (no action) |
SRTHSCH | SQL Table | S10B80.SATURN | Refer (no action) |
SRTINTL | SQL Table | S10B80.SATURN | Refer (no action) |
SRTPCOL | SQL Table | S10B80.SATURN | Refer (no action) |
SRTSUPL | SQL Table | S10B80.SATURN | Refer (no action) |
STVEMPL | SQL Table | S10B80.SATURN | Refer (no action) |
AF_VENDOR_VOLUME | SQL View | S10B80.BANINST1 | Use (select) |
APVADRS | SQL View | S10B80.BANINST1 | Use (select) |
GOVSVDP | SQL View | S10B80.BANINST1 | Use (select) |
GOVSVEV | SQL View | S10B80.BANINST1 | Use (select) |
GOVSVSD | SQL View | S10B80.BANINST1 | Use (select) |
PAVAPPL | SQL View | S10B80.BANINST1 | Use (select) |
PEVEMPL | SQL View | S10B80.BANINST1 | Use (select) |
POVDATA | SQL View | S10B80.BANINST1 | Use (select) |
PPVADRS | SQL View | S10B80.BANINST1 | Use (select) |
RPVADDR | SQL View | S10B80.BANINST1 | Use (select) |
RPVADRS | SQL View | S10B80.BANINST1 | Use (select) |
RPVFDRS | SQL View | S10B80.BANINST1 | Use (select) |
SAVADRS | SQL View | S10B80.BANINST1 | Use (select) |
SGVADRS | SQL View | S10B80.BANINST1 | Use (select) |
SPVADDF | SQL View | S10B80.BANINST1 | Use (select) |
SPVADDI | SQL View | S10B80.BANINST1 | Use (select) |
SPVADDS | SQL View | S10B80.BANINST1 | Use (select) |
SPVADRS | SQL View | S10B80.BANINST1 | Use (select) |
SPVINTL | SQL View | S10B80.BANINST1 | Use (select) |
SRVADRS | SQL View | S10B80.BANINST1 | Use (select) |
STVNATV | SQL View | S10B80.BANINST1 | Use (select) |
F_COMMON_GET_DESC | SQL Function | S10B80.BANINST1 | Use (select) |
F_GET_DESC | SQL Function | S10B80.BANINST1 | Use (select) |
F_GET_DESC_ALUMNI | SQL Function | S10B80.BANINST1 | Use (select) |
F_GET_DESC_FNC | SQL Function | S10B80.BANINST1 | Use (select) |
F_STUDENT_GET_DESC | SQL Function | S10B80.BANINST1 | Use (select) |
ADDRESS_REC_TYPE | Oracle Package Type | S10B80.BANINST1.ICSPKCOM | Rely On |
NATN_CUR | Oracle Package Cursor | S10B80.BANINST1.BWSKALOG | Use (select) |
STVNATN_REC | Oracle Package Variable | S10B80.BANINST1.BWDKSRCH | Rely On |
STVNATN_REC | Oracle Package Variable | S10B80.BANINST1.BWDKCPRF | Rely On |
STVNATN_REC | Oracle Package Variable | S10B80.BANINST1.BWAKADVS | Rely On |
STVNATN_REC | Oracle Package Variable | S10B80.BANINST1.BWGKOADR | Rely On |
STVNATN_REC | Oracle Package Variable | S10B80.BANINST1.BWAKJPST | Rely On |
GETSTVNATNC | Oracle Package Cursor | S10B80.BANINST1.BWAKALOG | Use (select)Rely On |
STVNATNC | Oracle Package Cursor | S10B80.BANINST1.BWSKWTRR | Use (select) |
STVNATNVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKSRCH | Use (select)Rely On |
STVNATNVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKCPRF | Use (select)Rely On |
STVNATNVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWAKJPST | Use (select)Rely On |
STVNATN_LISTC | Oracle Package Cursor | S10B80.BANINST1.BWSKRQST | Use (select) |
P_GENOPTIONSNATN | Oracle Package Procedure | S10B80.BANINST1.BWGKOADR | Rely On |
P_LOOKUPSBGICODE | Oracle Package Procedure | S10B80.BANINST1.BWSKWPRO | Use (select) |
CUR_OF_NATN | Oracle Package Variable | S10B80.BANINST1.BWPKEDIR | Rely On |
CUR_PR_NATN | Oracle Package Variable | S10B80.BANINST1.BWPKEDIR | Rely On |
GV_NATION_CODE1 | Oracle Package Variable | S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT | Rely On |
GV_NATION_CODE2 | Oracle Package Variable | S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT | Rely On |
GV_NATION_CODE3 | Oracle Package Variable | S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT | Rely On |
GV_NATION_CODE4 | Oracle Package Variable | S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT | Rely On |
GV_NATN_DESC | Oracle Package Variable | S10B80.BANINST1.BWSKRQST | Rely On |
STVNATN_REC | Oracle Package Variable | S10B80.BANINST1.BWGKOEMR | Rely On |
STVNATN_REC | Oracle Package Variable | S10B80.BANINST1.BWAKALOG | Rely On |
STVNATN_REC | Oracle Package Variable | S10B80.BANINST1.BWGKOPRF | Rely On |
F_GET_NATN_DESC | Oracle Package Function | S10B80.BANINST1.BWSKWTRR | Rely On |
F_GET_NATN_DESC | Oracle Package Function | S10B80.BANINST1.BWSKWTRR | Use (select) |
STVNATNC | Oracle Package Cursor | S10B80.BANINST1.STKNATN | Use (select)Rely On |
STVNATNLISTC | Oracle Package Cursor | S10B80.BANINST1.BWSKLIST | Use (select)Rely On |
STVNATNLISTC | Oracle Package Cursor | S10B80.BANINST1.GOKLIBS | Use (select)Rely On |
STVNATN_C | Oracle Package Cursor | S10B80.BANINST1.GB_STVNATN | Rely On |
STVNATN_C | Oracle Package Cursor | S10B80.BANINST1.GB_STVNATN | Use (select)Rely On |
P_CCPAYMENTSTATUS | Oracle Package Procedure | S10B80.BANINST1.BWAKCPMT | Rely On |
P_CCPAYMENTSTATUS | Oracle Package Procedure | S10B80.BANINST1.BWAKNGFT | Rely On |
P_CCPAYMENTSTATUS | Oracle Package Procedure | S10B80.BANINST1.BWSKAPMT | Rely On |
P_CCPAYMENTSTATUS | Oracle Package Procedure | S10B80.BANINST1.BWCKCPMT | Rely On |
P_CC_PAYMENT_STATUS | Oracle Package Procedure | S10B80.BANINST1.BWSKWCCP | Rely On |
P_COLLECT_CREDIT_CARD_INFO | Oracle Package Procedure | S10B80.BANINST1.BWGKCCRD | Rely On |
P_CREDITCARDPAYMENT | Oracle Package Procedure | S10B80.BANINST1.BWAKCPMT | Rely On |
P_CREDITCARDPAYMENT | Oracle Package Procedure | S10B80.BANINST1.BWSKAPMT | Rely On |
P_CREDITCARDPAYMENT | Oracle Package Procedure | S10B80.BANINST1.BWCKCPMT | Rely On |
P_CREDIT_CARD_PAYMENT | Oracle Package Procedure | S10B80.BANINST1.BWSKWCCP | Rely On |
P_DELETE_STVNATN | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_DELETE_STVNATN | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (delete) |
P_DISPADDRVIEW | Oracle Package Procedure | S10B80.BANINST1.BWLKOSAD | Rely On |
P_DISPADDRVIEW | Oracle Package Procedure | S10B80.BANINST1.BWGKOADR | Rely On |
P_DISPSTATUS | Oracle Package Procedure | S10B80.BANINST1.BWSKASTA | Rely On |
P_DISPSTATUSSARADAP | Oracle Package Procedure | S10B80.BANINST1.BWSKASTA | Rely On |
P_DISP_CONFIRM | Oracle Package Procedure | S10B80.BANINST1.BWSKWTRR | Rely On |
P_DISP_DIPLOMA_ADDR | Oracle Package Procedure | S10B80.BANINST1.BWSKGRAD | Use (select) |
P_DISP_STATUS_OF_ORDER | Oracle Package Procedure | S10B80.BANINST1.BWSKWTRR | Rely On |
P_DISP_TRANSCRIPT_REQUEST_TYPE | Oracle Package Procedure | S10B80.BANINST1.BWSKWTRR | Rely On |
P_EDIT_SHIP_CODE | Oracle Package Procedure | S10B80.BANINST1.FSKSHIP | Rely On |
P_EDIT_SHIP_CODE | Oracle Package Procedure | S10B80.BANINST1.FSKSHIP | Use (select) |
P_GET_SOBSBGI_INFO | Oracle Package Procedure | S10B80.BANINST1.SB_PESCXML_TRANDATA_IMP | Use (select) |
P_INSERT_INTL | Oracle Package Procedure | S10B80.BANINST1.SRKPREL | Rely On |
P_INSERT_INTL | Oracle Package Procedure | S10B80.BANINST1.SRKPREL | Use (select) |
P_INSERT_STVNATN | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_INSERT_STVNATN | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (Insert) |
P_LOAD_INTL | Oracle Package Procedure | S10B80.BANINST1.SAKL030 | Rely On |
P_LOAD_INTL | Oracle Package Procedure | S10B80.BANINST1.SAKL030 | Use (select) |
P_LOOKUP_SBGI_CODE | Oracle Package Procedure | S10B80.BANINST1.BWSKALOG | Use (select) |
P_MAKE_A_DONATION | Oracle Package Procedure | S10B80.BANINST1.BWAKNGFT | Rely On |
P_PROCADDRUPDATE | Oracle Package Procedure | S10B80.BANINST1.BWGKOGAD | Rely On |
P_PURCHASEORDER | Oracle Package Procedure | S10B80.BANINST1.BWFKPURR | Rely On |
P_PURCHASEORDER | Oracle Package Procedure | S10B80.BANINST1.BWFKPURR | Use (select) |
P_REQUISITION | Oracle Package Procedure | S10B80.BANINST1.BWFKREQN | Rely On |
P_REQUISITION | Oracle Package Procedure | S10B80.BANINST1.BWFKREQN | Use (select) |
P_UPDATE_STVNATN | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_UPDATE_STVNATN | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (update) |
P_VALADDRUPDATE | Oracle Package Procedure | S10B80.BANINST1.BWGKOADR | Rely On |
P_VALIDATION_DISPLAY | Oracle Package Procedure | S10B80.BANINST1.BWGKCCRD | Rely On |
P_VIEWDCSR | Oracle Package Procedure | S10B80.BANINST1.BWFKVDCR | Rely On |
P_VIEWINV | Oracle Package Procedure | S10B80.BANINST1.BWFKVINV | Rely On |
P_VIEWPUR | Oracle Package Procedure | S10B80.BANINST1.BWFKVPUR | Rely On |
P_VIEWREQ | Oracle Package Procedure | S10B80.BANINST1.BWFKVREQ | Rely On |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_EXPERIENCE | Use (Insert) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_VISA | Use (Insert) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_DRIVER_LICENSE | Use (Insert) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SP_HOUSING_PROFILE | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_BIO | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_CERTIFICATION | Use (Insert) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GP_CARDHOLDER | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_GRADAPP | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_EFDTEST | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_EMERGENCY_CONTACT | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GP_ENTITY_ADDRESS | Use (Insert) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_TB_MISC_HEADER | Use (Insert) |
F_CALC_NATION | Oracle Package Function | S10B80.BANINST1.ICSPKCOM | Rely On |
F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_STVNATN | Rely On |
F_DOMESTIC_ADDR | Oracle Package Function | S10B80.BANINST1.SHKPXML | Rely On |
F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_STVNATN | Rely On |
F_GET_NATN_DESC | Oracle Package Function | S10B80.BANINST1.BWFKVDOC | Rely On |
F_GET_NATN_DESC | Oracle Package Function | S10B80.BANINST1.BWFKVDOC | Use (select) |
F_GET_NATN_DESC | Oracle Package Function | S10B80.BANINST1.TTKSELS | Rely On |
F_GET_NATN_DESC | Oracle Package Function | S10B80.BANINST1.TTKSELS | Use (select) |
F_GET_STVNATN_DESC | Oracle Package Function | S10B80.BANINST1.FRKIDEN | Rely On |
F_GET_STVNATN_DESC | Oracle Package Function | S10B80.BANINST1.FRKIDEN | Use (select) |
F_OPEN_STVNATN_RC | Oracle Package Function | S10B80.BANINST1.NOKEPCR | Use (select) |
F_SORXREF_CHK | Oracle Package Function | S10B80.BANINST1.SAKPCOM | Use (select) |
F_SORXREF_VAL | Oracle Package Function | S10B80.BANINST1.SAKPCOM | Use (select) |
STVNATN | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_STVNATN | SQL Index | S10B80.SATURN | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 10:35:08:000 | 04/02/2008 21:17:58:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
STVSTAT_CODE |   | VARCHAR2(3) | No | * | * |
STVSTAT_DESC |   | VARCHAR2(30) | No |   |   |
STVSTAT_ACTIVITY_DATE |   | DATE | No |   |   |
STVSTAT_EDI_EQUIV |   | VARCHAR2(2) | Yes |   |   |
STVSTAT_STATSCAN_CDE |   | VARCHAR2(5) | Yes |   |   |
STVSTAT_IPEDS_CDE |   | VARCHAR2(5) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
STVSTAT_CODE | SIBFACD_BIRTH_STATE | SIBFACD |
Index Name | Index Type | Column Name |
---|---|---|
PK_STVSTAT | Unique | STVSTAT_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
STVSTAT | Oracle Synonym | S10B80.FAISMGR | Rely On |
AORCONT | SQL Table | S10B80.ALUMNI | Refer (no action) |
AORJPST | SQL Table | S10B80.ALUMNI | Join |
APBCONS | SQL Table | S10B80.ALUMNI | Refer (no action) |
APBWIDN | SQL Table | S10B80.ALUMNI | Refer (no action) |
GOBSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
GORSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
GORSVAS | SQL Table | S10B80.GENERAL | Refer (no action) |
GORSVEI | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVZIPC | SQL Table | S10B80.GENERAL | Refer (no action) |
GUBINST | SQL Table | S10B80.GENERAL | Refer (no action) |
GURAPAY | SQL Table | S10B80.GENERAL | Refer (no action) |
PEREEO5 | SQL Table | S10B80.PAYROLL | Refer (no action) |
PPREXPE | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTRERST | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTRINST | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTRLOCN | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTRSCHL | SQL Table | S10B80.PAYROLL | Refer (no action) |
PXRMTER | SQL Table | S10B80.PAYROLL | Refer (no action) |
PXRMTIN | SQL Table | S10B80.PAYROLL | Refer (no action) |
RHRRQST | SQL Table | S10B80.FAISMGR | Refer (no action) |
RJBPLBD | SQL Table | S10B80.FAISMGR | Refer (no action) |
RORCAMP | SQL Table | S10B80.FAISMGR | Refer (no action) |
RPBLNDR | SQL Table | S10B80.FAISMGR | Refer (no action) |
RPRLAPP | SQL Table | S10B80.FAISMGR | Refer (no action) |
RPRLARF | SQL Table | S10B80.FAISMGR | Refer (no action) |
SABSUPL | SQL Table | S10B80.SATURN | Refer (no action) |
SFRENRL | SQL Table | S10B80.SATURN | Refer (no action) |
SHBDIPL | SQL Table | S10B80.SATURN | Refer (no action) |
SHBGAPP | SQL Table | S10B80.SATURN | Refer (no action) |
SHTTRAN | SQL Table | S10B80.SATURN | Refer (no action) |
SHTTRTC | SQL Table | S10B80.SATURN | Refer (no action) |
SMRPRRQ | SQL Table | S10B80.SATURN | Refer (no action) |
SMTPRRQ | SQL Table | S10B80.SATURN | Refer (no action) |
SOBSBGI | SQL Table | S10B80.SATURN | Refer (no action) |
SORMSTA | SQL Table | S10B80.SATURN | Refer (no action) |
SORT22A | SQL Table | S10B80.SATURN | Refer (no action) |
SPBPERS | SQL Table | S10B80.SATURN | Refer (no action) |
SPRADDR | SQL Table | S10B80.SATURN | Refer (no action) |
SPREMRG | SQL Table | S10B80.SATURN | Refer (no action) |
SRTADDR | SQL Table | S10B80.SATURN | Refer (no action) |
SRTHSCH | SQL Table | S10B80.SATURN | Refer (no action) |
SRTSUPL | SQL Table | S10B80.SATURN | Refer (no action) |
STVEMPL | SQL Table | S10B80.SATURN | Refer (no action) |
APVADRS | SQL View | S10B80.BANINST1 | Use (select) |
GOVSVEV | SQL View | S10B80.BANINST1 | Use (select) |
GOVSVSD | SQL View | S10B80.BANINST1 | Use (select) |
PAVAPPL | SQL View | S10B80.BANINST1 | Use (select) |
PEVEMPL | SQL View | S10B80.BANINST1 | Use (select) |
POVDATA | SQL View | S10B80.BANINST1 | Use (select) |
PPVADRS | SQL View | S10B80.BANINST1 | Use (select) |
PPVFACD | SQL View | S10B80.BANINST1 | Use (select) |
RPVADDR | SQL View | S10B80.BANINST1 | Use (select) |
RPVADRS | SQL View | S10B80.BANINST1 | Use (select) |
RPVFDRS | SQL View | S10B80.BANINST1 | Use (select) |
SAVADRS | SQL View | S10B80.BANINST1 | Use (select) |
SGVADRS | SQL View | S10B80.BANINST1 | Use (select) |
SIVFACD | SQL View | S10B80.BANINST1 | Use (select) |
SPVADDF | SQL View | S10B80.BANINST1 | Use (select) |
SPVADDI | SQL View | S10B80.BANINST1 | Use (select) |
SPVADDS | SQL View | S10B80.BANINST1 | Use (select) |
SPVADRS | SQL View | S10B80.BANINST1 | Use (select) |
SRVADRS | SQL View | S10B80.BANINST1 | Use (select) |
F_GET_DESC_ALUMNI | SQL Function | S10B80.BANINST1 | Use (select) |
F_GET_DESC_FNC | SQL Function | S10B80.BANINST1 | Use (select) |
F_GET_STVSTAT_IPEDS_CDE | SQL Function | S10B80.BANINST1 | Rely On |
F_GET_STVSTAT_IPEDS_CDE | SQL Function | S10B80.BANINST1 | Use (select)Rely On |
STAT_TYPE | Oracle Package Type | S10B80.BANINST1.BWAKJPST | Rely On |
STAT_CUR | Oracle Package Cursor | S10B80.BANINST1.BWSKALOG | Use (select) |
STVSTAT_REC | Oracle Package Variable | S10B80.BANINST1.BWDKSRCH | Rely On |
STVSTAT_REC | Oracle Package Variable | S10B80.BANINST1.BWDKPSRC | Rely On |
STVSTAT_REC | Oracle Package Variable | S10B80.BANINST1.BWAKADVS | Rely On |
STVSTAT_REC | Oracle Package Variable | S10B80.BANINST1.BWGKOADR | Rely On |
STVSTAT_REC | Oracle Package Variable | S10B80.BANINST1.BWAKJPST | Rely On |
AORJPSTSTATVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWAKJPST | Use (select) |
GETSTVSTATC | Oracle Package Cursor | S10B80.BANINST1.BWAKALOG | Use (select)Rely On |
STVSTATC | Oracle Package Cursor | S10B80.BANINST1.BWSKWTRR | Use (select) |
STVSTATVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKSRCH | Use (select)Rely On |
STVSTATVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKPSRC | Use (select)Rely On |
STVSTATVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWAKADVS | Use (select)Rely On |
STVSTATVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWAKJPST | Use (select)Rely On |
STVSTAT_LISTC | Oracle Package Cursor | S10B80.BANINST1.BWSKRQST | Use (select) |
STVSTAT_LISTC | Oracle Package Cursor | S10B80.BANINST1.BWSKWTRR | Use (select) |
P_GENOPTIONSSTAT | Oracle Package Procedure | S10B80.BANINST1.BWGKOADR | Rely On |
P_LOOKUPSBGICODE | Oracle Package Procedure | S10B80.BANINST1.BWSKWPRO | Use (select) |
ACAD_STAT_CODE | Oracle Package Variable | S10B80.BANINST1.BWCKGSTU | Rely On |
GV_STAT_CODE1 | Oracle Package Variable | S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT | Rely On |
GV_STAT_DESC | Oracle Package Variable | S10B80.BANINST1.BWSKRQST | Rely On |
STVSTAT_REC | Oracle Package Variable | S10B80.BANINST1.BWGKOEMR | Rely On |
STVSTAT_REC | Oracle Package Variable | S10B80.BANINST1.BWAKALOG | Rely On |
F_GET_STAT_DESC | Oracle Package Function | S10B80.BANINST1.BWSKWTRR | Rely On |
F_GET_STAT_DESC | Oracle Package Function | S10B80.BANINST1.BWSKWTRR | Use (select) |
STVSTATC | Oracle Package Cursor | S10B80.BANINST1.STKSTAT | Use (select)Rely On |
STVSTATLISTC | Oracle Package Cursor | S10B80.BANINST1.BWSKLIST | Use (select)Rely On |
STVSTATLISTC | Oracle Package Cursor | S10B80.BANINST1.GOKLIBS | Use (select)Rely On |
STVSTAT_C | Oracle Package Cursor | S10B80.BANINST1.GB_STVSTAT | Rely On |
STVSTAT_C | Oracle Package Cursor | S10B80.BANINST1.GB_STVSTAT | Use (select)Rely On |
P_COLLECT_CREDIT_CARD_INFO | Oracle Package Procedure | S10B80.BANINST1.BWGKCCRD | Rely On |
P_CREDITCARDPAYMENT | Oracle Package Procedure | S10B80.BANINST1.BWAKCPMT | Rely On |
P_CREDITCARDPAYMENT | Oracle Package Procedure | S10B80.BANINST1.BWSKAPMT | Rely On |
P_CREDITCARDPAYMENT | Oracle Package Procedure | S10B80.BANINST1.BWCKCPMT | Rely On |
P_CREDIT_CARD_PAYMENT | Oracle Package Procedure | S10B80.BANINST1.BWSKWCCP | Rely On |
P_DELETE_STVSTAT | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_DELETE_STVSTAT | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (delete) |
P_DISPADDRVIEW | Oracle Package Procedure | S10B80.BANINST1.BWLKOSAD | Rely On |
P_DISPADDRVIEW | Oracle Package Procedure | S10B80.BANINST1.BWGKOADR | Rely On |
P_DISPSTATUS | Oracle Package Procedure | S10B80.BANINST1.BWSKASTA | Rely On |
P_DISPSTATUSSARADAP | Oracle Package Procedure | S10B80.BANINST1.BWSKASTA | Rely On |
P_DISP_CONFIRM | Oracle Package Procedure | S10B80.BANINST1.BWSKWTRR | Rely On |
P_DISP_DIPLOMA_ADDR | Oracle Package Procedure | S10B80.BANINST1.BWSKGRAD | Use (select) |
P_DISP_STATUS_OF_ORDER | Oracle Package Procedure | S10B80.BANINST1.BWSKWTRR | Rely On |
P_DISP_TRANSCRIPT_REQUEST_TYPE | Oracle Package Procedure | S10B80.BANINST1.BWSKWTRR | Rely On |
P_INSERT_STVSTAT | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_INSERT_STVSTAT | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (Insert) |
P_LOOKUP_SBGI_CODE | Oracle Package Procedure | S10B80.BANINST1.BWSKALOG | Use (select) |
P_MAKE_A_DONATION | Oracle Package Procedure | S10B80.BANINST1.BWAKNGFT | Rely On |
P_PROCADDRUPDATE | Oracle Package Procedure | S10B80.BANINST1.BWGKOGAD | Rely On |
P_UPDATE_STVSTAT | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_UPDATE_STVSTAT | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (update) |
P_VALADDRUPDATE | Oracle Package Procedure | S10B80.BANINST1.BWGKOADR | Rely On |
P_VALIDATION_DISPLAY | Oracle Package Procedure | S10B80.BANINST1.BWGKCCRD | Rely On |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_EXPERIENCE | Use (Insert) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_DRIVER_LICENSE | Use (Insert) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SP_HOUSING_PROFILE | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_BIO | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_CERTIFICATION | Use (Insert) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SP_LDIPERSON | Use (Insert) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GP_CARDHOLDER | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_ADDRESS | Use (select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_GRADAPP | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GP_ENTITY_ADDRESS | Use (Insert) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_TB_MISC_HEADER | Use (Insert) |
F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_STVSTAT | Rely On |
F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_STVSTAT | Rely On |
F_GET_STAT_DESC | Oracle Package Function | S10B80.BANINST1.TTKSELS | Rely On |
F_GET_STAT_DESC | Oracle Package Function | S10B80.BANINST1.TTKSELS | Use (select) |
STVSTAT | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_STVSTAT | SQL Index | S10B80.SATURN | Rely On |
SIBFACD | SQL Table | S10B80.SATURN | Join |
Creation Date | Analysis Date |
---|---|
04/02/2008 10:35:10:000 | 04/02/2008 21:17:58:000 |
Objects list |
---|
schema-view : S10B80.BANINST1.APVXREF |
Link Type | Link | Project |
---|---|---|
Join | Link Between APRXREF and APBCONS | ALUMNI |
Link type | Between | And |
---|---|---|
Join | APRXREF | APBCONS |
Objects list |
---|
schema-view : S10B80.BANINST1.ADVDSG1 |
Link Type | Link | Project |
---|---|---|
Join | Link Between APBCONS and APRDHIS | ALUMNI |
Link type | Between | And |
---|---|---|
Join | APBCONS | APRDHIS |
Objects list |
---|
schema-view : S10B80.BANINST1.ADVDSG1 |
Link Type | Link | Project |
---|---|---|
Join | Link Between APRCSPS and APRDHIS | ALUMNI |
Link type | Between | And |
---|---|---|
Join | APRCSPS | APRDHIS |
Objects list |
---|
schema-view : S10B80.BANINST1.ASVCAMP
schema-view : S10B80.BANINST1.APVCNI1 schema-view : S10B80.BANINST1.AOVIDEN schema-view : S10B80.BANINST1.APVCONS scope-cursor : S10B80.BANINST1.BWAKSRCH.SPRIDENVIEWC scope-cursor : S10B80.BANINST1.BWAKSRCH.SPRIDENPREVSOUNDLIKEC scope-cursor : S10B80.BANINST1.BWAKSRCH.SPRIDENPREVSOUNDC scope-cursor : S10B80.BANINST1.BWAKSRCH.SPRIDENPREVLIKEC scope-cursor : S10B80.BANINST1.BWAKSRCH.SPRIDENPREVEXACTC |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRIDEN and APBCONS | SATURN |
Link type | Between | And |
---|---|---|
Join | SPRIDEN | APBCONS |
Objects list |
---|
schema-view : S10B80.BANINST1.ASVYEAR |
Link Type | Link | Project |
---|---|---|
Join | Link Between ASRSSAG and APBCONS | ALUMNI |
Link type | Between | And |
---|---|---|
Join | ASRSSAG | APBCONS |
Objects list |
---|
schema-view : S10B80.BANINST1.AOVIDEN |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRADDR and APBCONS | SATURN |
Link type | Between | And |
---|---|---|
Join | SPRADDR | APBCONS |
Objects list |
---|
schema-view : S10B80.BANINST1.AFVCMP1 |
Link Type | Link | Project |
---|---|---|
Join | Link Between APBCONS and APRCHIS | ALUMNI |
Link type | Between | And |
---|---|---|
Join | APBCONS | APRCHIS |
Objects list |
---|
schema-view : S10B80.BANINST1.AFVCMP1 |
Link Type | Link | Project |
---|---|---|
Join | Link Between APRCSPS and APRCHIS | ALUMNI |
Link type | Between | And |
---|---|---|
Join | APRCSPS | APRCHIS |
Objects list |
---|
scope-cursor : S10B80.BANINST1.BWAKSRCH.SPRIDENVIEWC
scope-cursor : S10B80.BANINST1.BWAKSRCH.SPRIDENPREVSOUNDLIKEC scope-cursor : S10B80.BANINST1.BWAKSRCH.SPRIDENPREVSOUNDC scope-cursor : S10B80.BANINST1.BWAKSRCH.SPRIDENPREVLIKEC scope-cursor : S10B80.BANINST1.BWAKSRCH.SPRIDENPREVEXACTC |
Link Type | Link | Project |
---|---|---|
Join | Link Between APRCATG and APBCONS | ALUMNI |
Link type | Between | And |
---|---|---|
Join | APRCATG | APBCONS |
Objects list |
---|
scope-cursor : S10B80.BANINST1.BWAKPLDG.SPOUSEVIEWC |
Link Type | Link | Project |
---|---|---|
Join | Link Between APRCSPS and APRCATG | ALUMNI |
Link type | Between | And |
---|---|---|
Join | APRCSPS | APRCATG |
Objects list |
---|
scope-procedure : S10B80.BANINST1.AXKEXMG.P_EVALUATE_MG_ELIGIBILITY |
Link Type | Link | Project |
---|---|---|
Join | Link Between APREHIS and APRXREF | ALUMNI |
Link type | Between | And |
---|---|---|
Join | APREHIS | APRXREF |
Objects list |
---|
scope-cursor : S10B80.BANINST1.BWAKADVS.SEARCHVIEWC |
Link Type | Link | Project |
---|---|---|
Join | Link Between APBCONS and APRACYR | ALUMNI |
Link type | Between | And |
---|---|---|
Join | APBCONS | APRACYR |
Objects list |
---|
scope-cursor : S10B80.BANINST1.BWAKADVS.SEARCHVIEWC |
Link Type | Link | Project |
---|---|---|
Join | Link Between APRADEG and APRACYR | ALUMNI |
Link type | Between | And |
---|---|---|
Join | APRADEG | APRACYR |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between APBCONS and STVNATN (FK1_APBCONS_INV_STVNATN_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
APBCONS | APBCONS_NATN_CODE_HOME | STVNATN_CODE | STVNATN | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between APBCONS and STVSTAT (FK1_APBCONS_INV_STVSTAT_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
APBCONS | APBCONS_STAT_CODE_HOME | STVSTAT_CODE | STVSTAT | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between APRCSPS and APBCONS (FK1_APRCSPS_INV_APBCONS_KEY) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
APRCSPS | APRCSPS_PIDM | APBCONS_PIDM | APBCONS | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between APBCONS and ATVINCM (FK1_APBCONS_INV_ATVINCM_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
APBCONS | APBCONS_INCM_CODE | ATVINCM_CODE | ATVINCM | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between APRADEG and APBCONS (FK1_APRADEG_INV_APBCONS_KEY) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
APRADEG | APRADEG_PIDM | APBCONS_PIDM | APBCONS | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between APREHIS and APBCONS (FK1_APREHIS_INV_APBCONS_KEY) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
APREHIS | APREHIS_PIDM | APBCONS_PIDM | APBCONS | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between APBCONS and ATVDOTT (FK1_APBCONS_INV_ATVDOTT_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
APBCONS | APBCONS_DOTT_CODE | ATVDOTT_CODE | ATVDOTT | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between APRCHLD and APBCONS (FK1_APRCHLD_INV_APBCONS_KEY) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
APRCHLD | APRCHLD_PIDM | APBCONS_PIDM | APBCONS | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between APBCONS and STVATYP (FK1_APBCONS_INV_STVATYP_CODE) | ALUMNI |
Refer (no action) | Link Informative Foreign Key Between APBCONS and STVATYP (FK2_APBCONS_INV_STVATYP_CODE) | ALUMNI |
Refer (no action) | Link Informative Foreign Key Between APBCONS and STVATYP (FK3_APBCONS_INV_STVATYP_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
APBCONS | APBCONS_ATYP_CODE_GEOR | STVATYP_CODE | STVATYP | (0,1)-(0,n) |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
APBCONS | APBCONS_ATYP_CODE_CM | STVATYP_CODE | STVATYP | (0,1)-(0,n) |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
APBCONS | APBCONS_ATYP_CODE_PREF | STVATYP_CODE | STVATYP | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between APRCHLD and STVATYP (FK1_APRCHLD_INV_STVATYP_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
APRCHLD | APRCHLD_ATYP_CODE | STVATYP_CODE | STVATYP | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between APBCONS and STVCOLL (FK1_APBCONS_INV_STVCOLL_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
APBCONS | APBCONS_COLL_CODE_PREF | STVCOLL_CODE | STVCOLL | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between APRADEG and STVCOLL (FK1_APRADEG_INV_STVCOLL_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
APRADEG | APRADEG_COLL_CODE | STVCOLL_CODE | STVCOLL | (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) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between SPRADDR and STVNATN (FK1_SPRADDR_INV_STVNATN_CODE) | SATURN |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
SPRADDR | SPRADDR_NATN_CODE | STVNATN_CODE | STVNATN | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between SPRADDR and STVSTAT (FK1_SPRADDR_INV_STVSTAT_CODE) | SATURN |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
SPRADDR | SPRADDR_STAT_CODE | STVSTAT_CODE | STVSTAT | (0,1)-(0,n) |