Model Constituent*
Object Name | Object Type | Layer Name |
---|---|---|
APBCONS | TABLE | Default |
APRACYR | TABLE | Default |
APRADEG | TABLE | Default |
APRCHIS | TABLE | Default |
APRCHLD | TABLE | Default |
APRCSPS | TABLE | Default |
APRDHIS | TABLE | Default |
APREHIS | TABLE | Default |
ASRSSAG | TABLE | Default |
ATVDOTT | TABLE | Default |
ATVINCM | TABLE | Default |
SPRADDR | TABLE | Default |
SPRIDEN | TABLE | Default |
STVATYP | TABLE | Default |
STVCOLL | TABLE | Default |
STVNATN | TABLE | Default |
STVSTAT | TABLE | Default |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
APBCONS_PIDM | APBCONS_PIDM | NUMBER(8,0) | No | * |   |
APBCONS_PREF_LAST_NAME | APBCONS_PREF_LAST_NAME | VARCHAR2(25) | Yes |   |   |
APBCONS_PREF_FIRST_NAME | APBCONS_PREF_FIRST_NAME | VARCHAR2(15) | Yes |   |   |
APBCONS_PREF_MI | APBCONS_PREF_MI | VARCHAR2(1) | Yes |   |   |
APBCONS_NICKNAME | APBCONS_NICKNAME | VARCHAR2(40) | Yes |   |   |
APBCONS_GRAD_NAME | APBCONS_GRAD_NAME | VARCHAR2(60) | Yes |   |   |
APBCONS_PARENTS_NAME | APBCONS_PARENTS_NAME | VARCHAR2(50) | Yes |   |   |
APBCONS_MAIDEN_LAST_NAME | APBCONS_MAIDEN_LAST_NAME | VARCHAR2(25) | Yes |   |   |
APBCONS_PREF_CLAS | APBCONS_PREF_CLAS | VARCHAR2(4) | No |   |   |
APBCONS_COLL_CODE_PREF | APBCONS_COLL_CODE_PREF | VARCHAR2(2) | Yes |   | * |
APBCONS_HOME_CITY | APBCONS_HOME_CITY | VARCHAR2(20) | Yes |   |   |
APBCONS_STAT_CODE_HOME | APBCONS_STAT_CODE_HOME | VARCHAR2(3) | Yes |   | * |
APBCONS_NATN_CODE_HOME | APBCONS_NATN_CODE_HOME | VARCHAR2(5) | Yes |   | * |
APBCONS_CM_NAME | APBCONS_CM_NAME | VARCHAR2(50) | Yes |   |   |
APBCONS_ATYP_CODE_CM | APBCONS_ATYP_CODE_CM | VARCHAR2(2) | Yes |   | * |
APBCONS_DOTT_CODE | APBCONS_DOTT_CODE | VARCHAR2(4) | Yes |   | * |
APBCONS_INCM_CODE | APBCONS_INCM_CODE | VARCHAR2(2) | Yes |   | * |
APBCONS_ATYP_CODE_PREF | APBCONS_ATYP_CODE_PREF | VARCHAR2(2) | Yes |   | * |
APBCONS_ADDR_NAME | APBCONS_ADDR_NAME | VARCHAR2(35) | Yes |   |   |
APBCONS_ACTIVITY_DATE | APBCONS_ACTIVITY_DATE | DATE | No |   |   |
APBCONS_ATYP_CODE_GEOR | APBCONS_ATYP_CODE_GEOR | VARCHAR2(2) | Yes |   | * |
APBCONS_SOCIETY_NAME | APBCONS_SOCIETY_NAME | VARCHAR2(60) | Yes |   |   |
APBCONS_DATA_ORIGIN | APBCONS_DATA_ORIGIN | VARCHAR2(30) | Yes |   |   |
APBCONS_USER_ID | APBCONS_USER_ID | VARCHAR2(30) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
APBCONS_DOTT_CODE | ATVDOTT_CODE | ATVDOTT |
APBCONS_ATYP_CODE_PREF | STVATYP_CODE | STVATYP |
APBCONS_ATYP_CODE_CM | STVATYP_CODE | STVATYP |
APBCONS_ATYP_CODE_GEOR | STVATYP_CODE | STVATYP |
APBCONS_COLL_CODE_PREF | STVCOLL_CODE | STVCOLL |
APBCONS_NATN_CODE_HOME | STVNATN_CODE | STVNATN |
APBCONS_STAT_CODE_HOME | STVSTAT_CODE | STVSTAT |
APBCONS_INCM_CODE | ATVINCM_CODE | ATVINCM |
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 | INDEX | "S4B70.SCT.COM".ALUMNI | Rely On |
APBCONS_KEY_INDEX3 | INDEX | "S4B70.SCT.COM".ALUMNI | Rely On |
PK_APBCONS | INDEX | "S4B70.SCT.COM".ALUMNI | Rely On |
ATVDOTT | TABLE | "S4B70.SCT.COM".ALUMNI | Refer (no action) |
ATVINCM | TABLE | "S4B70.SCT.COM".ALUMNI | Refer (no action) |
STVATYP | TABLE | "S4B70.SCT.COM".SATURN | Refer (no action) |
STVCOLL | TABLE | "S4B70.SCT.COM".SATURN | Refer (no action) |
STVNATN | TABLE | "S4B70.SCT.COM".SATURN | Refer (no action) |
STVSTAT | TABLE | "S4B70.SCT.COM".SATURN | Refer (no action) |
Creation Date | Analysis Date |
---|---|
12/13/2005 01:46:40:000 | 12/13/2005 19:35:19:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
APRACYR_PIDM | APRACYR_PIDM | NUMBER(8,0) | No | * | * |
APRACYR_SACT_CODE | APRACYR_SACT_CODE | VARCHAR2(3) | Yes |   |   |
APRACYR_YEAR | APRACYR_YEAR | NUMBER(4,0) | No | * | * |
APRACYR_ACTIVITY_DATE | APRACYR_ACTIVITY_DATE | DATE | No |   |   |
APRACYR_ACTC_CODE | 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 |
APRACYR_PIDM | APRADEG_PIDM | APRADEG |
APRACYR_YEAR | APRADEG_ACYR_CODE | APRADEG |
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 |
---|---|---|---|
ins_sprt_acyr | C/C++ Function | [F:\BANNER\C\APPSTDI.PC] | Use (Insert,select) |
insacyr | C/C++ Function | [F:\BANNER\C\APPSTDI.PC] | Use (Insert,select) |
APRACYR | SYNONYM | "S4B70.SCT.COM".PUBLIC | Rely On |
APVACTY | VIEW | "S4B70.SCT.COM".BANINST1 | Use (select) |
F_ACTIVITY_CODE_INFO | FUNCTION | "S4B70.SCT.COM".BANINST1 | Use (select) |
ACTC_TYPE | Package Type | "S4B70.SCT.COM".BANINST1.BWAKADVS | Rely On |
APRACYR_REC | Package variable | "S4B70.SCT.COM".BANINST1.BWAKADVS | Rely On |
F_GET_ACTIVITY_YEAR_COUNT | Package function | "S4B70.SCT.COM".BANINST1.AOKODSF | Use (select) |
P_DISP_ACTIVITIES | Package procedure | "S4B70.SCT.COM".BANINST1.BWDKCPRF | Use (select) |
APRACYRVIEWC | Package cursor | "S4B70.SCT.COM".BANINST1.BWAKADVS | Use (select)Rely On |
ONEYEARVIEWC | Package cursor | "S4B70.SCT.COM".BANINST1.BWAKADVS | Use (select)Rely On |
SEARCHVIEWC | Package cursor | "S4B70.SCT.COM".BANINST1.BWAKADVS | Use (select) |
P_INSERT_ADVISOR | Package procedure | "S4B70.SCT.COM".BANINST1.BWAKADVS | Use (Insert) |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_APRACYR | INDEX | "S4B70.SCT.COM".ALUMNI | Rely On |
APRACTY | TABLE | "S4B70.SCT.COM".ALUMNI | Refer (no action) |
APRADEG | TABLE | "S4B70.SCT.COM".ALUMNI | Join |
STVACTC | TABLE | "S4B70.SCT.COM".SATURN | Refer (no action) |
Creation Date | Analysis Date |
---|---|
12/13/2005 01:46:40:000 | 12/13/2005 19:35:19:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
APRADEG_PIDM | APRADEG_PIDM | NUMBER(8,0) | No | * | * |
APRADEG_SEQ_NO | APRADEG_SEQ_NO | NUMBER(5,0) | No | * |   |
APRADEG_SBGI_CODE | APRADEG_SBGI_CODE | VARCHAR2(6) | Yes |   | * |
APRADEG_DEGC_CODE | APRADEG_DEGC_CODE | VARCHAR2(6) | Yes |   | * |
APRADEG_DATE | APRADEG_DATE | DATE | Yes |   |   |
APRADEG_HONR_CODE | APRADEG_HONR_CODE | VARCHAR2(6) | Yes |   | * |
APRADEG_COLL_CODE | APRADEG_COLL_CODE | VARCHAR2(2) | Yes |   | * |
APRADEG_ACTIVITY_DATE | APRADEG_ACTIVITY_DATE | DATE | No |   |   |
APRADEG_ACYR_CODE | APRADEG_ACYR_CODE | VARCHAR2(4) | Yes |   | * |
APRADEG_ACYR_CODE_BULLETIN | APRADEG_ACYR_CODE_BULLETIN | VARCHAR2(4) | Yes |   | * |
APRADEG_CAMP_CODE | APRADEG_CAMP_CODE | VARCHAR2(3) | Yes |   | * |
APRADEG_DEPT_CODE | APRADEG_DEPT_CODE | VARCHAR2(4) | Yes |   | * |
APRADEG_COMMENTS | APRADEG_COMMENTS | VARCHAR2(2000) | Yes |   |   |
APRADEG_MAJR_CODE_MINR_1 | APRADEG_MAJR_CODE_MINR_1 | VARCHAR2(4) | Yes |   | * |
APRADEG_MAJR_CODE_MINR_2 | APRADEG_MAJR_CODE_MINR_2 | VARCHAR2(4) | Yes |   | * |
APRADEG_MAJR_CODE_CONC_1 | APRADEG_MAJR_CODE_CONC_1 | VARCHAR2(4) | Yes |   | * |
APRADEG_MAJR_CODE_CONC_2 | APRADEG_MAJR_CODE_CONC_2 | VARCHAR2(4) | Yes |   | * |
APRADEG_MAJR_CODE_CONC_3 | APRADEG_MAJR_CODE_CONC_3 | VARCHAR2(4) | Yes |   | * |
APRADEG_MAJR_CODE_CONC_4 | APRADEG_MAJR_CODE_CONC_4 | VARCHAR2(4) | Yes |   | * |
APRADEG_MAJR_CODE_CONC_5 | APRADEG_MAJR_CODE_CONC_5 | VARCHAR2(4) | Yes |   | * |
APRADEG_MAJR_CODE_CONC_6 | APRADEG_MAJR_CODE_CONC_6 | VARCHAR2(4) | Yes |   | * |
APRADEG_DEPT_CODE_2 | APRADEG_DEPT_CODE_2 | VARCHAR2(4) | Yes |   | * |
APRADEG_HONR_CODE_2 | APRADEG_HONR_CODE_2 | VARCHAR2(6) | Yes |   | * |
APRADEG_HONR_CODE_3 | APRADEG_HONR_CODE_3 | VARCHAR2(6) | Yes |   | * |
APRADEG_HONR_CODE_4 | APRADEG_HONR_CODE_4 | VARCHAR2(6) | Yes |   | * |
APRADEG_HONR_CODE_5 | APRADEG_HONR_CODE_5 | VARCHAR2(6) | Yes |   | * |
APRADEG_HOND_CODE_1 | APRADEG_HOND_CODE_1 | VARCHAR2(6) | Yes |   | * |
APRADEG_HOND_CODE_2 | APRADEG_HOND_CODE_2 | VARCHAR2(6) | Yes |   | * |
APRADEG_HOND_CODE_3 | APRADEG_HOND_CODE_3 | VARCHAR2(6) | Yes |   | * |
APRADEG_HOND_CODE_4 | APRADEG_HOND_CODE_4 | VARCHAR2(6) | Yes |   | * |
APRADEG_HOND_CODE_5 | APRADEG_HOND_CODE_5 | VARCHAR2(6) | Yes |   | * |
APRADEG_OK_FOR_NOTES_IND | APRADEG_OK_FOR_NOTES_IND | VARCHAR2(1) | Yes |   |   |
APRADEG_DISP_NOTES_IND | APRADEG_DISP_NOTES_IND | VARCHAR2(1) | Yes |   |   |
APRADEG_DISP_NOTES_DATE | APRADEG_DISP_NOTES_DATE | DATE | Yes |   |   |
APRADEG_USER | APRADEG_USER | VARCHAR2(30) | No |   |   |
APRADEG_REVIEWED_IND | APRADEG_REVIEWED_IND | VARCHAR2(1) | Yes |   |   |
APRADEG_REVIEWED_USER | APRADEG_REVIEWED_USER | VARCHAR2(30) | Yes |   |   |
APRADEG_MAJOR_COMMENT | APRADEG_MAJOR_COMMENT | VARCHAR2(60) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
APRADEG_COLL_CODE | STVCOLL_CODE | STVCOLL |
APRADEG_DEGC_CODE | STVDEGC_CODE | STVDEGC |
APRADEG_DEPT_CODE | STVDEPT_CODE | STVDEPT |
APRADEG_DEPT_CODE_2 | STVDEPT_CODE | STVDEPT |
APRADEG_HOND_CODE_1 | STVHOND_CODE | STVHOND |
APRADEG_HOND_CODE_2 | STVHOND_CODE | STVHOND |
APRADEG_HOND_CODE_3 | STVHOND_CODE | STVHOND |
APRADEG_HOND_CODE_4 | STVHOND_CODE | STVHOND |
APRADEG_HOND_CODE_5 | 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_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_SBGI_CODE | STVSBGI_CODE | STVSBGI |
APRADEG_PIDM | APBCONS_PIDM | APBCONS |
APRADEG_ACYR_CODE | STVACYR_CODE | STVACYR |
APRADEG_ACYR_CODE_BULLETIN | STVACYR_CODE | STVACYR |
APRADEG_CAMP_CODE | STVCAMP_CODE | STVCAMP |
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 |
---|---|---|---|
PK_APRADEG | INDEX | "S4B70.SCT.COM".ALUMNI | Rely On |
APBCONS | TABLE | "S4B70.SCT.COM".ALUMNI | Refer (no action) |
STVACYR | TABLE | "S4B70.SCT.COM".SATURN | Refer (no action) |
STVCAMP | TABLE | "S4B70.SCT.COM".SATURN | Refer (no action) |
STVCOLL | TABLE | "S4B70.SCT.COM".SATURN | Refer (no action) |
STVDEGC | TABLE | "S4B70.SCT.COM".SATURN | Refer (no action) |
STVDEPT | TABLE | "S4B70.SCT.COM".SATURN | Refer (no action) |
STVHOND | TABLE | "S4B70.SCT.COM".SATURN | Refer (no action) |
STVHONR | TABLE | "S4B70.SCT.COM".SATURN | Refer (no action) |
STVMAJR | TABLE | "S4B70.SCT.COM".SATURN | Refer (no action) |
STVSBGI | TABLE | "S4B70.SCT.COM".SATURN | Refer (no action) |
Creation Date | Analysis Date |
---|---|
12/13/2005 01:46:40:000 | 12/13/2005 19:35:18:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
APRCHIS_PIDM | APRCHIS_PIDM | NUMBER(8,0) | No | * |   |
APRCHIS_CAMPAIGN | APRCHIS_CAMPAIGN | VARCHAR2(5) | No | * |   |
APRCHIS_FISC_CODE | APRCHIS_FISC_CODE | NUMBER(4,0) | No | * | * |
APRCHIS_AMT_PLEDGED | APRCHIS_AMT_PLEDGED | NUMBER(13,2) | Yes |   |   |
APRCHIS_AMT_PLEDGED_PAID | APRCHIS_AMT_PLEDGED_PAID | NUMBER(13,2) | Yes |   |   |
APRCHIS_AMT_GIFT | APRCHIS_AMT_GIFT | NUMBER(13,2) | Yes |   |   |
APRCHIS_AMT_MEMO | APRCHIS_AMT_MEMO | NUMBER(13,2) | Yes |   |   |
APRCHIS_ACTIVITY_DATE | APRCHIS_ACTIVITY_DATE | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
APRCHIS_FISC_CODE | ATVFISC_CODE | ATVFISC |
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 | INDEX | "S4B70.SCT.COM".ALUMNI | Rely On |
APRCHIS_KEY_INDEX3 | INDEX | "S4B70.SCT.COM".ALUMNI | Rely On |
PK_APRCHIS | INDEX | "S4B70.SCT.COM".ALUMNI | Rely On |
ATVFISC | TABLE | "S4B70.SCT.COM".ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
12/13/2005 01:46:40:000 | 12/13/2005 19:35:18:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
APRCHLD_PIDM | APRCHLD_PIDM | NUMBER(8,0) | No | * | * |
APRCHLD_SEQ_NO | APRCHLD_SEQ_NO | NUMBER(5,0) | No | * |   |
APRCHLD_LAST_NAME | APRCHLD_LAST_NAME | VARCHAR2(25) | Yes |   |   |
APRCHLD_FIRST_NAME | APRCHLD_FIRST_NAME | VARCHAR2(15) | Yes |   |   |
APRCHLD_MI | APRCHLD_MI | VARCHAR2(1) | Yes |   |   |
APRCHLD_SEX | APRCHLD_SEX | VARCHAR2(1) | Yes |   |   |
APRCHLD_BIRTH_DATE | APRCHLD_BIRTH_DATE | DATE | Yes |   |   |
APRCHLD_SSN | APRCHLD_SSN | VARCHAR2(9) | Yes |   |   |
APRCHLD_ATYP_CODE | APRCHLD_ATYP_CODE | VARCHAR2(2) | Yes |   | * |
APRCHLD_ACTIVITY_DATE | APRCHLD_ACTIVITY_DATE | DATE | No |   |   |
APRCHLD_XREF_CODE | APRCHLD_XREF_CODE | VARCHAR2(3) | Yes |   | * |
APRCHLD_CHLD_PIDM | APRCHLD_CHLD_PIDM | NUMBER(8,0) | Yes |   |   |
APRCHLD_DISP_WEB_IND | APRCHLD_DISP_WEB_IND | VARCHAR2(1) | Yes |   |   |
APRCHLD_DECEASED_IND | APRCHLD_DECEASED_IND | VARCHAR2(1) | Yes |   |   |
APRCHLD_DECEASED_DATE | APRCHLD_DECEASED_DATE | DATE | Yes |   |   |
APRCHLD_OK_FOR_NOTES_IND | APRCHLD_OK_FOR_NOTES_IND | VARCHAR2(1) | Yes |   |   |
APRCHLD_DISP_NOTES_IND | APRCHLD_DISP_NOTES_IND | VARCHAR2(1) | Yes |   |   |
APRCHLD_DISP_NOTES_DATE | APRCHLD_DISP_NOTES_DATE | DATE | Yes |   |   |
APRCHLD_USER | APRCHLD_USER | VARCHAR2(30) | No |   |   |
APRCHLD_REVIEWED_IND | APRCHLD_REVIEWED_IND | VARCHAR2(1) | Yes |   |   |
APRCHLD_REVIEWED_USER | APRCHLD_REVIEWED_USER | VARCHAR2(30) | Yes |   |   |
APRCHLD_COMMENT | APRCHLD_COMMENT | LONG | 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 |
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 |
---|---|---|---|
PK_APRCHLD | INDEX | "S4B70.SCT.COM".ALUMNI | Rely On |
APBCONS | TABLE | "S4B70.SCT.COM".ALUMNI | Refer (no action) |
ATVXREF | TABLE | "S4B70.SCT.COM".ALUMNI | Refer (no action) |
STVATYP | TABLE | "S4B70.SCT.COM".SATURN | Refer (no action) |
Creation Date | Analysis Date |
---|---|
12/13/2005 01:46:40:000 | 12/13/2005 19:35:21:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
APRCSPS_PIDM | APRCSPS_PIDM | NUMBER(8,0) | No |   | * |
APRCSPS_MARS_IND | APRCSPS_MARS_IND | VARCHAR2(1) | No |   |   |
APRCSPS_ACTIVITY_DATE | APRCSPS_ACTIVITY_DATE | DATE | No |   |   |
APRCSPS_SPS_PIDM | APRCSPS_SPS_PIDM | NUMBER(8,0) | Yes |   | * |
APRCSPS_LAST_NAME | APRCSPS_LAST_NAME | VARCHAR2(60) | Yes |   |   |
APRCSPS_FIRST_NAME | APRCSPS_FIRST_NAME | VARCHAR2(15) | Yes |   |   |
APRCSPS_MAIDEN_NAME | APRCSPS_MAIDEN_NAME | VARCHAR2(60) | Yes |   |   |
APRCSPS_NAME_PREFIX | APRCSPS_NAME_PREFIX | VARCHAR2(20) | Yes |   |   |
APRCSPS_NAME_SUFFIX | APRCSPS_NAME_SUFFIX | VARCHAR2(20) | Yes |   |   |
APRCSPS_BIRTH_DATE | APRCSPS_BIRTH_DATE | DATE | Yes |   |   |
APRCSPS_SPS_COMMENT | APRCSPS_SPS_COMMENT | VARCHAR2(60) | Yes |   |   |
APRCSPS_MRTL_CODE | APRCSPS_MRTL_CODE | VARCHAR2(1) | Yes |   | * |
APRCSPS_MRTL_START_DATE | APRCSPS_MRTL_START_DATE | DATE | Yes |   |   |
APRCSPS_MRTL_END_DATE | APRCSPS_MRTL_END_DATE | DATE | Yes |   |   |
APRCSPS_DEAD_IND | APRCSPS_DEAD_IND | VARCHAR2(1) | Yes |   |   |
APRCSPS_DEAD_DATE | APRCSPS_DEAD_DATE | DATE | Yes |   |   |
APRCSPS_XREF_CODE | APRCSPS_XREF_CODE | VARCHAR2(3) | Yes |   | * |
APRCSPS_MI | APRCSPS_MI | VARCHAR2(15) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
APRCSPS_XREF_CODE | ATVXREF_CODE | ATVXREF |
APRCSPS_PIDM | APBCONS_PIDM | APBCONS |
APRCSPS_MRTL_CODE | STVMRTL_CODE | STVMRTL |
APRCSPS_SPS_PIDM | SPRIDEN_PIDM | SPRIDEN |
APRCSPS_SPS_PIDM | SPBPERS_PIDM | SPBPERS |
Index Name | Index Type | Column Name |
---|---|---|
APRCSPS_KEY_INDEX |   | APRCSPS_PIDM |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
APRCSPS_KEY_INDEX | INDEX | "S4B70.SCT.COM".ALUMNI | Rely On |
APBCONS | TABLE | "S4B70.SCT.COM".ALUMNI | Refer (no action) |
ATVXREF | TABLE | "S4B70.SCT.COM".ALUMNI | Refer (no action) |
SPBPERS | TABLE | "S4B70.SCT.COM".SATURN | Join |
SPRIDEN | TABLE | "S4B70.SCT.COM".SATURN | Join |
STVMRTL | TABLE | "S4B70.SCT.COM".SATURN | Refer (no action) |
Creation Date | Analysis Date |
---|---|
12/13/2005 01:46:40:000 | 12/13/2005 19:35:19:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
APRDHIS_PIDM | APRDHIS_PIDM | NUMBER(8,0) | No | * |   |
APRDHIS_DESG | APRDHIS_DESG | VARCHAR2(10) | No | * | * |
APRDHIS_FISC_CODE | APRDHIS_FISC_CODE | NUMBER(4,0) | No | * | * |
APRDHIS_AMT_PLEDGED | APRDHIS_AMT_PLEDGED | NUMBER(13,2) | Yes |   |   |
APRDHIS_AMT_PLEDGED_PAID | APRDHIS_AMT_PLEDGED_PAID | NUMBER(13,2) | Yes |   |   |
APRDHIS_AMT_GIFT | APRDHIS_AMT_GIFT | NUMBER(13,2) | Yes |   |   |
APRDHIS_AMT_MEMO | APRDHIS_AMT_MEMO | NUMBER(13,2) | Yes |   |   |
APRDHIS_ACTIVITY_DATE | APRDHIS_ACTIVITY_DATE | DATE | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
APRDHIS_DESG | ADBDESG_DESG | ADBDESG |
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 |
---|---|---|---|
APRDHIS_KEY_INDEX2 | INDEX | "S4B70.SCT.COM".ALUMNI | Rely On |
APRDHIS_KEY_INDEX3 | INDEX | "S4B70.SCT.COM".ALUMNI | Rely On |
PK_APRDHIS | INDEX | "S4B70.SCT.COM".ALUMNI | Rely On |
ADBDESG | TABLE | "S4B70.SCT.COM".ALUMNI | Join |
ATVFISC | TABLE | "S4B70.SCT.COM".ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
12/13/2005 01:46:40:000 | 12/13/2005 19:35:19:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
APREHIS_PIDM | APREHIS_PIDM | NUMBER(8,0) | No | * | * |
APREHIS_SEQ_NO | APREHIS_SEQ_NO | NUMBER(5,0) | No | * |   |
APREHIS_EMPR_NAME | APREHIS_EMPR_NAME | VARCHAR2(60) | Yes |   |   |
APREHIS_JOBC_CODE | APREHIS_JOBC_CODE | VARCHAR2(3) | Yes |   | * |
APREHIS_EMPL_POSITION | APREHIS_EMPL_POSITION | VARCHAR2(60) | Yes |   |   |
APREHIS_FROM_DATE | APREHIS_FROM_DATE | DATE | Yes |   |   |
APREHIS_TO_DATE | APREHIS_TO_DATE | DATE | Yes |   |   |
APREHIS_EMPR_PIDM | APREHIS_EMPR_PIDM | NUMBER(8,0) | Yes |   |   |
APREHIS_EMPR_ID | APREHIS_EMPR_ID | VARCHAR2(9) | Yes |   |   |
APREHIS_ACTIVITY_DATE | APREHIS_ACTIVITY_DATE | DATE | No |   |   |
APREHIS_SICC_CODE | APREHIS_SICC_CODE | VARCHAR2(4) | Yes |   | * |
APREHIS_XREF_CODE | APREHIS_XREF_CODE | VARCHAR2(3) | Yes |   | * |
APREHIS_EMPS_CODE | APREHIS_EMPS_CODE | VARCHAR2(1) | Yes |   | * |
APREHIS_WKLY_HOURS | APREHIS_WKLY_HOURS | NUMBER(5,2) | Yes |   |   |
APREHIS_USER | APREHIS_USER | VARCHAR2(30) | No |   |   |
APREHIS_PRIMARY_IND | APREHIS_PRIMARY_IND | VARCHAR2(1) | Yes |   |   |
APREHIS_ATYP_CODE | APREHIS_ATYP_CODE | VARCHAR2(2) | Yes |   |   |
APREHIS_ATYP_SEQNO | APREHIS_ATYP_SEQNO | NUMBER(2,0) | Yes |   |   |
APREHIS_JOBC_CODE2 | APREHIS_JOBC_CODE2 | VARCHAR2(3) | Yes |   |   |
APREHIS_JOBC_CODE3 | APREHIS_JOBC_CODE3 | VARCHAR2(3) | Yes |   |   |
APREHIS_JOBC_CODE4 | APREHIS_JOBC_CODE4 | VARCHAR2(3) | Yes |   |   |
APREHIS_OK_FOR_NOTES_IND | APREHIS_OK_FOR_NOTES_IND | VARCHAR2(1) | Yes |   |   |
APREHIS_DISP_NOTES_IND | APREHIS_DISP_NOTES_IND | VARCHAR2(1) | Yes |   |   |
APREHIS_DISP_NOTES_DATE | APREHIS_DISP_NOTES_DATE | DATE | Yes |   |   |
APREHIS_MG_IND | APREHIS_MG_IND | VARCHAR2(1) | Yes |   |   |
APREHIS_REVIEWED_IND | APREHIS_REVIEWED_IND | VARCHAR2(1) | Yes |   |   |
APREHIS_REVIEWED_USER | APREHIS_REVIEWED_USER | VARCHAR2(30) | Yes |   |   |
APREHIS_COMMENT | APREHIS_COMMENT | LONG | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
APREHIS_XREF_CODE | ATVXREF_CODE | ATVXREF |
APREHIS_EMPS_CODE | ATVEMPS_CODE | ATVEMPS |
APREHIS_JOBC_CODE | ATVJOBC_CODE | ATVJOBC |
APREHIS_SICC_CODE | ATVSICC_CODE | ATVSICC |
APREHIS_PIDM | APBCONS_PIDM | APBCONS |
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 |
---|---|---|---|
APREHIS_EMPR_INDEX | INDEX | "S4B70.SCT.COM".ALUMNI | Rely On |
PK_APREHIS | INDEX | "S4B70.SCT.COM".ALUMNI | Rely On |
APBCONS | TABLE | "S4B70.SCT.COM".ALUMNI | Refer (no action) |
ATVEMPS | TABLE | "S4B70.SCT.COM".ALUMNI | Refer (no action) |
ATVJOBC | TABLE | "S4B70.SCT.COM".ALUMNI | Refer (no action) |
ATVSICC | TABLE | "S4B70.SCT.COM".ALUMNI | Refer (no action) |
ATVXREF | TABLE | "S4B70.SCT.COM".ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
12/13/2005 01:46:40:000 | 12/13/2005 19:35:19:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
ASRSSAG_SOL_ORG | ASRSSAG_SOL_ORG | VARCHAR2(5) | No | * | * |
ASRSSAG_PIDM | ASRSSAG_PIDM | NUMBER(8,0) | No | * | * |
ASRSSAG_DCYR_CODE | ASRSSAG_DCYR_CODE | NUMBER(4,0) | No | * | * |
ASRSSAG_ACTIVITY_DATE | ASRSSAG_ACTIVITY_DATE | DATE | No |   |   |
ASRSSAG_USER | ASRSSAG_USER | VARCHAR2(30) | No |   |   |
ASRSSAG_DOLLAR_GOAL | ASRSSAG_DOLLAR_GOAL | NUMBER(11,2) | Yes |   |   |
ASRSSAG_PARTICIPATION_GOAL | ASRSSAG_PARTICIPATION_GOAL | NUMBER(6,0) | Yes |   |   |
ASRSSAG_DONOR_COUNT_GOAL | ASRSSAG_DONOR_COUNT_GOAL | NUMBER(6,0) | Yes |   |   |
ASRSSAG_REPORT_TO_PIDM | ASRSSAG_REPORT_TO_PIDM | NUMBER(8,0) | Yes |   |   |
ASRSSAG_MAX_CONTACTS | ASRSSAG_MAX_CONTACTS | NUMBER(3,0) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
ASRSSAG_SOL_ORG | ASBSORG_SOL_ORG | ASBSORG |
ASRSSAG_DCYR_CODE | ATVDCYR_CODE | ATVDCYR |
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 |
---|---|---|---|
check_cpidm2 | C/C++ Function | [F:\BANNER\C\AGPTLMK.PC] | Use (select) |
ins_asrssag | C/C++ Function | [F:\BANNER\C\ASPSOLA.PC] | Use (Insert) |
no_year_info | C/C++ Function | [F:\BANNER\C\ASPSOLA.PC] | Use |
ASRSSAG | SYNONYM | "S4B70.SCT.COM".PUBLIC | Rely On |
ASRSORG | TABLE | "S4B70.SCT.COM".ALUMNI | Join |
SPRIDEN | TABLE | "S4B70.SCT.COM".SATURN | Join |
ASVSSAG | VIEW | "S4B70.SCT.COM".BANINST1 | Use (select) |
ASVYEAR | VIEW | "S4B70.SCT.COM".BANINST1 | Use (select) |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_ASRSSAG | INDEX | "S4B70.SCT.COM".ALUMNI | Rely On |
APBCONS | TABLE | "S4B70.SCT.COM".ALUMNI | Join |
ASBSORG | TABLE | "S4B70.SCT.COM".ALUMNI | Refer (no action) |
ATVDCYR | TABLE | "S4B70.SCT.COM".ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
12/13/2005 01:46:40:000 | 12/13/2005 19:35:20:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
ATVDOTT_CODE | ATVDOTT_CODE | VARCHAR2(4) | No | * |   |
ATVDOTT_DESC | ATVDOTT_DESC | VARCHAR2(60) | No |   |   |
ATVDOTT_ACTIVITY_DATE | ATVDOTT_ACTIVITY_DATE | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_ATVDOTT | Unique | ATVDOTT_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_ATVDOTT | INDEX | "S4B70.SCT.COM".ALUMNI | Rely On |
Creation Date | Analysis Date |
---|---|
12/13/2005 01:46:40:000 | 12/13/2005 19:35:19:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
ATVINCM_CODE | ATVINCM_CODE | VARCHAR2(2) | No | * |   |
ATVINCM_DESC | ATVINCM_DESC | VARCHAR2(30) | No |   |   |
ATVINCM_ACTIVITY_DATE | ATVINCM_ACTIVITY_DATE | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_ATVINCM | Unique | ATVINCM_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
get_income | C/C++ Function | [F:\BANNER\C\APPCUPD.PC] | Use (select) |
selconsincome | C/C++ Function | [F:\BANNER\C\APPCLST.PC] | Use (select) |
ATVINCM | SYNONYM | "S4B70.SCT.COM".PUBLIC | Rely On |
APBCONS | TABLE | "S4B70.SCT.COM".ALUMNI | Refer (no action) |
F_GET_DESC_ALUMNI | FUNCTION | "S4B70.SCT.COM".BANINST1 | Use (select) |
ATVINCM_C | Package cursor | "S4B70.SCT.COM".BANINST1.AB_ATVINCM | Rely On |
ATVINCM_C | Package cursor | "S4B70.SCT.COM".BANINST1.AB_ATVINCM | Use (select)Rely On |
ATVINCM_REC | Package variable | "S4B70.SCT.COM".BANINST1.BWDKCPRF | Rely On |
ATVINCM_REC | Package variable | "S4B70.SCT.COM".BANINST1.BWDKPSRC | Rely On |
F_CODE_EXISTS | Package function | "S4B70.SCT.COM".BANINST1.AB_ATVINCM | Rely On |
F_GET_DESCRIPTION | Package function | "S4B70.SCT.COM".BANINST1.AB_ATVINCM | Rely On |
ATVINCMVIEWC | Package cursor | "S4B70.SCT.COM".BANINST1.BWDKCPRF | Use (select)Rely On |
CONSINCMVIEWC | Package cursor | "S4B70.SCT.COM".BANINST1.BWDKPSRC | Use (select)Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_ATVINCM | INDEX | "S4B70.SCT.COM".ALUMNI | Rely On |
Creation Date | Analysis Date |
---|---|
12/13/2005 01:46:40:000 | 12/13/2005 19:35:20:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
SPRADDR_PIDM | SPRADDR_PIDM | NUMBER(8,0) | No |   | * |
SPRADDR_ATYP_CODE | SPRADDR_ATYP_CODE | VARCHAR2(2) | No |   | * |
SPRADDR_SEQNO | SPRADDR_SEQNO | NUMBER(2,0) | No |   | * |
SPRADDR_FROM_DATE | SPRADDR_FROM_DATE | DATE | Yes |   |   |
SPRADDR_TO_DATE | SPRADDR_TO_DATE | DATE | Yes |   |   |
SPRADDR_STREET_LINE1 | SPRADDR_STREET_LINE1 | VARCHAR2(30) | Yes |   |   |
SPRADDR_STREET_LINE2 | SPRADDR_STREET_LINE2 | VARCHAR2(30) | Yes |   |   |
SPRADDR_STREET_LINE3 | SPRADDR_STREET_LINE3 | VARCHAR2(30) | Yes |   |   |
SPRADDR_CITY | SPRADDR_CITY | VARCHAR2(20) | No |   | * |
SPRADDR_STAT_CODE | SPRADDR_STAT_CODE | VARCHAR2(3) | Yes |   | * |
SPRADDR_ZIP | SPRADDR_ZIP | VARCHAR2(10) | Yes |   |   |
SPRADDR_CNTY_CODE | SPRADDR_CNTY_CODE | VARCHAR2(5) | Yes |   | * |
SPRADDR_NATN_CODE | SPRADDR_NATN_CODE | VARCHAR2(5) | Yes |   | * |
SPRADDR_PHONE_AREA | SPRADDR_PHONE_AREA | VARCHAR2(3) | Yes |   |   |
SPRADDR_PHONE_NUMBER | SPRADDR_PHONE_NUMBER | VARCHAR2(7) | Yes |   |   |
SPRADDR_PHONE_EXT | SPRADDR_PHONE_EXT | VARCHAR2(4) | Yes |   |   |
SPRADDR_STATUS_IND | SPRADDR_STATUS_IND | VARCHAR2(1) | Yes |   |   |
SPRADDR_ACTIVITY_DATE | SPRADDR_ACTIVITY_DATE | DATE | No |   |   |
SPRADDR_USER | SPRADDR_USER | VARCHAR2(30) | Yes |   |   |
SPRADDR_ASRC_CODE | SPRADDR_ASRC_CODE | VARCHAR2(4) | Yes |   | * |
SPRADDR_DELIVERY_POINT | SPRADDR_DELIVERY_POINT | NUMBER(2,0) | Yes |   |   |
SPRADDR_CORRECTION_DIGIT | SPRADDR_CORRECTION_DIGIT | NUMBER(1,0) | Yes |   |   |
SPRADDR_CARRIER_ROUTE | SPRADDR_CARRIER_ROUTE | VARCHAR2(4) | Yes |   |   |
SPRADDR_GST_TAX_ID | SPRADDR_GST_TAX_ID | VARCHAR2(15) | Yes |   |   |
SPRADDR_REVIEWED_IND | SPRADDR_REVIEWED_IND | VARCHAR2(1) | Yes |   |   |
SPRADDR_REVIEWED_USER | SPRADDR_REVIEWED_USER | VARCHAR2(30) | Yes |   |   |
SPRADDR_DATA_ORIGIN | SPRADDR_DATA_ORIGIN | VARCHAR2(30) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
SPRADDR_PIDM | SPRIDEN_PIDM | SPRIDEN |
SPRADDR_ATYP_CODE | AOBORGN_ATYP_CODE | AOBORGN |
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 | FRBGRNT_AGENCY_PIDM | FRBGRNT |
SPRADDR_ATYP_CODE | FRBGRNT_AGENCY_ADDR_CODE | FRBGRNT |
SPRADDR_SEQNO | FRBGRNT_AGENCY_ADDR_SEQ_NUM | FRBGRNT |
SPRADDR_SEQNO | FRRGRPI_ADDR_SEQNO | FRRGRPI |
SPRADDR_ATYP_CODE | FRRGRPI_ADDR_TYPE | FRRGRPI |
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_NATN_CODE | STVNATN_CODE | STVNATN |
SPRADDR_ASRC_CODE | STVASRC_CODE | STVASRC |
SPRADDR_ATYP_CODE | STVATYP_CODE | STVATYP |
SPRADDR_CNTY_CODE | STVCNTY_CODE | STVCNTY |
SPRADDR_STAT_CODE | STVSTAT_CODE | STVSTAT |
SPRADDR_ATYP_CODE | FTVVEND_VEND_CHECK_ATYP_CODE | FTVVEND |
SPRADDR_SEQNO | FTVVEND_VEND_CHECK_ADDR_SEQNO | FTVVEND |
SPRADDR_PIDM | FTVVEND_PIDM | FTVVEND |
SPRADDR_ATYP_CODE | FTVVEND_ATYP_CODE | FTVVEND |
SPRADDR_SEQNO | FTVVEND_ADDR_SEQNO | FTVVEND |
SPRADDR_PIDM | SPRTELE_PIDM | SPRTELE |
SPRADDR_ATYP_CODE | SPRTELE_ATYP_CODE | SPRTELE |
SPRADDR_SEQNO | SPRTELE_SEQNO | SPRTELE |
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 |
Creation Date | Analysis Date |
---|---|
12/13/2005 01:46:40:000 | 12/13/2005 19:35:38:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
SPRIDEN_PIDM | SPRIDEN_PIDM | NUMBER(8,0) | No |   | * |
SPRIDEN_ID | SPRIDEN_ID | VARCHAR2(9) | No |   | * |
SPRIDEN_LAST_NAME | SPRIDEN_LAST_NAME | VARCHAR2(60) | No |   |   |
SPRIDEN_FIRST_NAME | SPRIDEN_FIRST_NAME | VARCHAR2(15) | Yes |   |   |
SPRIDEN_MI | SPRIDEN_MI | VARCHAR2(15) | Yes |   |   |
SPRIDEN_CHANGE_IND | SPRIDEN_CHANGE_IND | VARCHAR2(1) | Yes |   |   |
SPRIDEN_ENTITY_IND | SPRIDEN_ENTITY_IND | VARCHAR2(1) | Yes |   |   |
SPRIDEN_ACTIVITY_DATE | SPRIDEN_ACTIVITY_DATE | DATE | No |   |   |
SPRIDEN_USER | SPRIDEN_USER | VARCHAR2(30) | Yes |   |   |
SPRIDEN_ORIGIN | SPRIDEN_ORIGIN | VARCHAR2(30) | Yes |   |   |
SPRIDEN_SEARCH_LAST_NAME | SPRIDEN_SEARCH_LAST_NAME | VARCHAR2(60) | Yes |   |   |
SPRIDEN_SEARCH_FIRST_NAME | SPRIDEN_SEARCH_FIRST_NAME | VARCHAR2(15) | Yes |   |   |
SPRIDEN_SEARCH_MI | SPRIDEN_SEARCH_MI | VARCHAR2(15) | Yes |   |   |
SPRIDEN_SOUNDEX_LAST_NAME | SPRIDEN_SOUNDEX_LAST_NAME | CHAR(4) | Yes |   |   |
SPRIDEN_SOUNDEX_FIRST_NAME | SPRIDEN_SOUNDEX_FIRST_NAME | CHAR(4) | Yes |   |   |
SPRIDEN_NTYP_CODE | SPRIDEN_NTYP_CODE | VARCHAR2(4) | Yes |   |   |
SPRIDEN_CREATE_USER | SPRIDEN_CREATE_USER | VARCHAR2(30) | Yes |   |   |
SPRIDEN_CREATE_DATE | SPRIDEN_CREATE_DATE | DATE | Yes |   |   |
SPRIDEN_DATA_ORIGIN | SPRIDEN_DATA_ORIGIN | VARCHAR2(30) | Yes |   |   |
SPRIDEN_CREATE_FDMN_CODE | SPRIDEN_CREATE_FDMN_CODE | VARCHAR2(30) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
SPRIDEN_PIDM | RPRATRM_PIDM | RPRATRM |
SPRIDEN_PIDM | AGRPIDS_XREF_PIDM | AGRPIDS |
SPRIDEN_PIDM | AGRPIDS_PIDM | AGRPIDS |
SPRIDEN_PIDM | ASRSSAG_PIDM | ASRSSAG |
SPRIDEN_PIDM | AOBORGN_PIDM | AOBORGN |
SPRIDEN_PIDM | ASRSORG_PIDM | ASRSORG |
SPRIDEN_PIDM | AGRGIDS_XREF_PIDM | AGRGIDS |
SPRIDEN_PIDM | AGRGIDS_PIDM | AGRGIDS |
SPRIDEN_PIDM | AGBPLDG_PIDM | AGBPLDG |
SPRIDEN_PIDM | AGRPMEM_PIDM | AGRPMEM |
SPRIDEN_PIDM | AGRPMEM_MEMO_PIDM | AGRPMEM |
SPRIDEN_PIDM | AGRGMEM_PIDM | AGRGMEM |
SPRIDEN_PIDM | AGRGMEM_MEMO_PIDM | AGRGMEM |
SPRIDEN_PIDM | AGRGPAY_PIDM | AGRGPAY |
SPRIDEN_PIDM | APRXREF_XREF_PIDM | APRXREF |
SPRIDEN_PIDM | GLBEXTR_KEY | GLBEXTR |
SPRIDEN_PIDM | AGBMGID_EMPR_PIDM | AGBMGID |
SPRIDEN_PIDM | AGBMGID_EMPL_PIDM | AGBMGID |
SPRIDEN_PIDM | FRRPRPI_ID_PIDM | FRRPRPI |
SPRIDEN_PIDM | FIRBOND_IMGR_CODE_PIDM | FIRBOND |
SPRIDEN_PIDM | FPBAGRH_VEND_PIDM | FPBAGRH |
SPRIDEN_PIDM | FTVAGCY_AGCY_CODE_PIDM | FTVAGCY |
SPRIDEN_PIDM | APRCATG_PIDM | APRCATG |
SPRIDEN_PIDM | AARMEMB_RENEWAL_PIDM | AARMEMB |
SPRIDEN_PIDM | AARMEMB_REMINDER_PIDM | AARMEMB |
SPRIDEN_PIDM | APRDRVW_PIDM | APRDRVW |
SPRIDEN_PIDM | FRBGRNT_AGENCY_PIDM | FRBGRNT |
SPRIDEN_PIDM | FRRGRPI_ID_PIDM | FRRGRPI |
SPRIDEN_PIDM | FPRBIDV_VEND_PIDM | FPRBIDV |
SPRIDEN_PIDM | FPBREQH_VEND_PIDM | FPBREQH |
SPRIDEN_PIDM | FIRCERD_IMGR_CODE_PIDM | FIRCERD |
SPRIDEN_PIDM | FIRMMKT_IMGR_CODE_PIDM | FIRMMKT |
SPRIDEN_PIDM | FIRPRTY_IMGR_CODE_PIDM | FIRPRTY |
SPRIDEN_PIDM | FTVFMGR_FMGR_CODE_PIDM | FTVFMGR |
SPRIDEN_PIDM | FIRSTCK_IMGR_CODE_PIDM | FIRSTCK |
SPRIDEN_PIDM | FIRSTOP_IMGR_CODE_PIDM | FIRSTOP |
SPRIDEN_PIDM | GERFGST_PIDM | GERFGST |
SPRIDEN_PIDM | GERATTD_PIDM | GERATTD |
SPRIDEN_PIDM | GEBFUNC_SPNSR_ORGN_PIDM | GEBFUNC |
SPRIDEN_PIDM | GORSEVS_PIDM | GORSEVS |
SPRIDEN_PIDM | GORSEVD_DEP_PIDM | GORSEVD |
SPRIDEN_PIDM | GOBSEVS_PIDM | GOBSEVS |
SPRIDEN_PIDM | GORSVAS_ACT_SITE_PIDM | GORSVAS |
SPRIDEN_PIDM | GORSVEI_EMPLOYER_PIDM | GORSVEI |
SPRIDEN_PIDM | PERTETH_TRANS_PIDM | PERTETH |
SPRIDEN_PIDM | PERHSIP_PIDM | PERHSIP |
SPRIDEN_PIDM | GOBSRVR_PIDM | GOBSRVR |
SPRIDEN_PIDM | NBRJOBS_PIDM | NBRJOBS |
SPRIDEN_PIDM | GOBEACC_PIDM | GOBEACC |
SPRIDEN_PIDM | NOBTRAN_PIDM | NOBTRAN |
SPRIDEN_PIDM | PCBPERS_COBRA_BFCTR_PIDM | PCBPERS |
SPRIDEN_PIDM | PDRBENE_BENE_PIDM | PDRBENE |
SPRIDEN_PIDM | NBRBJOB_PIDM | NBRBJOB |
SPRIDEN_PIDM | PERBARG_PIDM | PERBARG |
SPRIDEN_PIDM | PERJOBS_PIDM | PERJOBS |
SPRIDEN_PIDM | TBBCONT_PIDM | TBBCONT |
SPRIDEN_PIDM | TBRCOLC_PIDM | TBRCOLC |
SPRIDEN_PIDM | TBBCSTU_STU_PIDM | TBBCSTU |
SPRIDEN_PIDM | TBBACCT_PIDM | TBBACCT |
SPRIDEN_PIDM | TBBESTU_PIDM | TBBESTU |
SPRIDEN_PIDM | TBRACCD_PIDM | TBRACCD |
SPRIDEN_PIDM | FTVCARD_CARDHOLDER_PIDM | FTVCARD |
SPRIDEN_PIDM | FCREMPO_PIDM | FCREMPO |
SPRIDEN_PIDM | FABINVH_VEND_PIDM | FABINVH |
SPRIDEN_PIDM | APBCONS_PIDM | APBCONS |
SPRIDEN_PIDM | APRERVW_PIDM | APRERVW |
SPRIDEN_PIDM | APRSRVW_PIDM | APRSRVW |
SPRIDEN_PIDM | APRCRVW_PIDM | APRCRVW |
SPRIDEN_PIDM | SIBINST_PIDM | SIBINST |
SPRIDEN_PIDM | SLBEVNT_AGENCY_PIDM | SLBEVNT |
SPRIDEN_PIDM | SHTTRAN_PIDM | SHTTRAN |
SPRIDEN_PIDM | SMBSLIB_PIDM | SMBSLIB |
SPRIDEN_PIDM | SMBAOGN_PIDM | SMBAOGN |
SPRIDEN_PIDM | SMRRQCM_ORIG_PIDM | SMRRQCM |
SPRIDEN_PIDM | SMRRQCM_PIDM | SMRRQCM |
SPRIDEN_ID | SRTIDEN_ID | SRTIDEN |
SPRIDEN_PIDM | SRTIDEN_PIDM | SRTIDEN |
SPRIDEN_PIDM | SHBDIPL_PIDM | SHBDIPL |
SPRIDEN_PIDM | SORPCOL_PIDM | SORPCOL |
SPRIDEN_PIDM | SLRRMAT_PIDM | SLRRMAT |
SPRIDEN_PIDM | SORHSCH_PIDM | SORHSCH |
SPRIDEN_PIDM | SHBCATT_PIDM | SHBCATT |
SPRIDEN_PIDM | SORAINF_PIDM | SORAINF |
SPRIDEN_PIDM | GERPART_PIDM | GERPART |
SPRIDEN_PIDM | SPBPERS_PIDM | SPBPERS |
SPRIDEN_PIDM | PEBEMPL_PIDM | PEBEMPL |
SPRIDEN_PIDM | FTVVEND_PIDM | FTVVEND |
SPRIDEN_PIDM | FTVCUST_PIDM | FTVCUST |
SPRIDEN_PIDM | FRBPROP_AGENCY_PIDM | FRBPROP |
SPRIDEN_PIDM | RNRTMNT_PIDM | RNRTMNT |
SPRIDEN_PIDM | SIRASGN_PIDM | SIRASGN |
SPRIDEN_PIDM | SORAROL_PIDM | SORAROL |
SPRIDEN_PIDM | SABSTUD_PIDM | SABSTUD |
SPRIDEN_PIDM | SGBSTDN_PIDM | SGBSTDN |
SPRIDEN_PIDM | SFRENRL_PIDM | SFRENRL |
SPRIDEN_PIDM | SMBPOGN_PIDM | SMBPOGN |
SPRIDEN_PIDM | SGRASSI_PIDM | SGRASSI |
SPRIDEN_PIDM | SHBHEAD_PIDM | SHBHEAD |
SPRIDEN_PIDM | RORLOGM_PIDM | RORLOGM |
SPRIDEN_PIDM | SFRSTCR_PIDM | SFRSTCR |
SPRIDEN_PIDM | SHRDGMR_PIDM | SHRDGMR |
SPRIDEN_PIDM | AMRCONF_PIDM | AMRCONF |
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 |
---|---|
12/13/2005 01:46:40:000 | 12/13/2005 19:35:40:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
STVATYP_CODE | STVATYP_CODE | VARCHAR2(2) | No | * |   |
STVATYP_DESC | STVATYP_DESC | VARCHAR2(30) | Yes |   |   |
STVATYP_ACTIVITY_DATE | STVATYP_ACTIVITY_DATE | DATE | No |   |   |
STVATYP_SYSTEM_REQ_IND | STVATYP_SYSTEM_REQ_IND | VARCHAR2(1) | Yes |   |   |
STVATYP_TELE_CODE | STVATYP_TELE_CODE | VARCHAR2(4) | Yes |   | * |
STVATYP_UPDATE_WEB_IND | 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 | INDEX | "S4B70.SCT.COM".SATURN | Rely On |
STVTELE | TABLE | "S4B70.SCT.COM".SATURN | Refer (no action) |
Creation Date | Analysis Date |
---|---|
12/13/2005 01:46:40:000 | 12/13/2005 19:35:45:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
STVCOLL_CODE | STVCOLL_CODE | VARCHAR2(2) | No | * |   |
STVCOLL_DESC | STVCOLL_DESC | VARCHAR2(30) | No |   |   |
STVCOLL_ADDR_STREET_LINE1 | STVCOLL_ADDR_STREET_LINE1 | VARCHAR2(30) | Yes |   |   |
STVCOLL_ADDR_STREET_LINE2 | STVCOLL_ADDR_STREET_LINE2 | VARCHAR2(30) | Yes |   |   |
STVCOLL_ADDR_STREET_LINE3 | STVCOLL_ADDR_STREET_LINE3 | VARCHAR2(30) | Yes |   |   |
STVCOLL_ADDR_CITY | STVCOLL_ADDR_CITY | VARCHAR2(20) | Yes |   |   |
STVCOLL_ADDR_STATE | STVCOLL_ADDR_STATE | VARCHAR2(2) | Yes |   |   |
STVCOLL_ADDR_COUNTRY | STVCOLL_ADDR_COUNTRY | VARCHAR2(28) | Yes |   |   |
STVCOLL_ADDR_ZIP_CODE | STVCOLL_ADDR_ZIP_CODE | VARCHAR2(10) | Yes |   |   |
STVCOLL_ACTIVITY_DATE | STVCOLL_ACTIVITY_DATE | DATE | Yes |   |   |
STVCOLL_SYSTEM_REQ_IND | STVCOLL_SYSTEM_REQ_IND | VARCHAR2(1) | Yes |   |   |
STVCOLL_VR_MSG_NO | STVCOLL_VR_MSG_NO | NUMBER(6,0) | Yes |   |   |
STVCOLL_STATSCAN_CDE3 | STVCOLL_STATSCAN_CDE3 | VARCHAR2(6) | Yes |   |   |
STVCOLL_DICD_CODE | STVCOLL_DICD_CODE | VARCHAR2(3) | Yes |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_STVCOLL | Unique | STVCOLL_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_STVCOLL | INDEX | "S4B70.SCT.COM".SATURN | Rely On |
ST_STVCOLL_AR_LDI | TRIGGER | "S4B70.SCT.COM".SATURN | Fire (Insert,update,delete,after,each row) |
ST_STVCOLL_AS_LDI | TRIGGER | "S4B70.SCT.COM".SATURN | Fire (Insert,update,delete,after,all rows) |
Creation Date | Analysis Date |
---|---|
12/13/2005 01:46:40:000 | 12/13/2005 19:35:38:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
STVNATN_CODE | STVNATN_CODE | VARCHAR2(5) | No | * |   |
STVNATN_NATION | STVNATN_NATION | VARCHAR2(30) | No |   |   |
STVNATN_CAPITAL | STVNATN_CAPITAL | VARCHAR2(20) | Yes |   |   |
STVNATN_AREA | STVNATN_AREA | NUMBER(22,0) | Yes |   |   |
STVNATN_POPULATION | STVNATN_POPULATION | NUMBER(22,0) | Yes |   |   |
STVNATN_ACTIVITY_DATE | STVNATN_ACTIVITY_DATE | DATE | No |   |   |
STVNATN_EDI_EQUIV | STVNATN_EDI_EQUIV | VARCHAR2(2) | Yes |   |   |
STVNATN_LMS_EQUIV | STVNATN_LMS_EQUIV | VARCHAR2(2) | Yes |   |   |
STVNATN_POSTAL_MASK | STVNATN_POSTAL_MASK | VARCHAR2(15) | Yes |   |   |
STVNATN_TELE_MASK | STVNATN_TELE_MASK | VARCHAR2(15) | Yes |   |   |
STVNATN_STATSCAN_CDE | STVNATN_STATSCAN_CDE | VARCHAR2(5) | Yes |   |   |
STVNATN_SCOD_CODE_ISO | STVNATN_SCOD_CODE_ISO | VARCHAR2(3) | Yes |   |   |
STVNATN_SSA_REPORTING_EQUIV | STVNATN_SSA_REPORTING_EQUIV | VARCHAR2(2) | Yes |   |   |
STVNATN_SEVIS_EQUIV | 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 |
---|---|---|---|
PK_STVNATN | INDEX | "S4B70.SCT.COM".SATURN | Rely On |
Creation Date | Analysis Date |
---|---|
12/13/2005 01:46:40:000 | 12/13/2005 19:35:40:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
STVSTAT_CODE | STVSTAT_CODE | VARCHAR2(3) | No | * |   |
STVSTAT_DESC | STVSTAT_DESC | VARCHAR2(30) | No |   |   |
STVSTAT_ACTIVITY_DATE | STVSTAT_ACTIVITY_DATE | DATE | No |   |   |
STVSTAT_EDI_EQUIV | STVSTAT_EDI_EQUIV | VARCHAR2(2) | Yes |   |   |
STVSTAT_STATSCAN_CDE | STVSTAT_STATSCAN_CDE | VARCHAR2(5) | Yes |   |   |
STVSTAT_IPEDS_CDE | STVSTAT_IPEDS_CDE | VARCHAR2(5) | Yes |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_STVSTAT | Unique | STVSTAT_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_STVSTAT | INDEX | "S4B70.SCT.COM".SATURN | Rely On |
Creation Date | Analysis Date |
---|---|
12/13/2005 01:46:40:000 | 12/13/2005 19:35:45:000 |
Objects list |
---|
forms-pl/sql-library-procedure : BANNER7_FORMS.AOQRPLS.A$_SEL_ID_INFO
forms-pl/sql-library-procedure : BANNER7_FORMS.AOQRPLS.A$_SEL_ID_PERS_INFO forms-module-procedure : BANNER7_FORMS.AMACONT.A$_SEL_ID_INFO forms-module-procedure : BANNER7_FORMS.AOQOLIB.A$_SEL_ID_INFO forms-module-procedure : BANNER7_FORMS.AOQOLIB.A$_SEL_ID_PERS_INFO forms-module-procedure : BANNER7_FORMS.APAIDEN.SEL_ID_INFO_CUSTOM forms-data-block-trigger : BANNER7_FORMS.APACONS.APRCSPS.QUERY_IDEN_PERS forms-module-procedure : BANNER7_FORMS.ASICONT.SEL_NON_CONS_ID_INFO forms-pl/sql-library-procedure : BANNER7_FORMS_10G.AOQRPLS.A$_SEL_ID_INFO forms-pl/sql-library-procedure : BANNER7_FORMS_10G.AOQRPLS.A$_SEL_ID_PERS_INFO forms-module-procedure : BANNER7_FORMS_10G.AOQOLIB.A$_SEL_ID_INFO forms-module-procedure : BANNER7_FORMS_10G.AOQOLIB.A$_SEL_ID_PERS_INFO forms-module-procedure : BANNER7_FORMS_10G.APAIDEN.SEL_ID_INFO_CUSTOM forms-data-block-trigger : BANNER7_FORMS_10G.APACONS.APRCSPS.QUERY_IDEN_PERS forms-module-procedure : BANNER7_FORMS_10G.ASICONT.SEL_NON_CONS_ID_INFO |
Link Type | Link | Project |
---|---|---|
Join | Link Between APRCSPS and SPRIDEN | SATURN |
Link type | Between | And |
---|---|---|
Join | APRCSPS | SPRIDEN |
Objects list |
---|
forms-module-record-group : BANNER7_FORMS.AGAPSOL.YEAR_SOL_4_ORG_RG
forms-module-record-group : BANNER7_FORMS.AOQOLIB.YEAR_SOL_4_ORG_RG forms-module-record-group : BANNER7_FORMS.AOQOLIB.ASRSSAG_RG forms-module-record-group : BANNER7_FORMS.AGAGSOL.YEAR_SOL_4_ORG_RG forms-module-record-group : BANNER7_FORMS.AGAWPLG.YEAR_SOL_4_ORG_RG forms-module-record-group : BANNER7_FORMS.AGAPMAS.YEAR_SOL_4_ORG_RG forms-module-record-group : BANNER7_FORMS.ASAMRES.YEAR_SOL_4_ORG_RG schema-view : S4B70.BANINST1.ASVYEAR forms-module-record-group : BANNER7_FORMS.ASASIGN.ASRSSAG_RG forms-module-record-group : BANNER7_FORMS.ASASIGN.YEAR_SOL_4_ORG_RG forms-module-record-group : BANNER7_FORMS.ASIPOOL.YEAR_SOL_4_ORG_RG schema-view : S4B70.BANINST1.ASVSSAG forms-module-record-group : BANNER7_FORMS.ASAASCT.ASRSSAG_RG forms-module-record-group : BANNER7_FORMS.ASAASCT.SOL_FOR_ORG_ALL_YRS_RG forms-module-record-group : BANNER7_FORMS.ASAASCT.YEAR_SOL_4_ORG_RG forms-module-record-group : BANNER7_FORMS.ASAUNCT.YEAR_SOL_4_ORG_RG forms-module-record-group : BANNER7_FORMS_10G.ASAMRES.YEAR_SOL_4_ORG_RG forms-module-record-group : BANNER7_FORMS_10G.AGAPSOL.YEAR_SOL_4_ORG_RG forms-module-record-group : BANNER7_FORMS_10G.AOQOLIB.YEAR_SOL_4_ORG_RG forms-module-record-group : BANNER7_FORMS_10G.AOQOLIB.ASRSSAG_RG forms-module-record-group : BANNER7_FORMS_10G.ASASIGN.ASRSSAG_RG forms-module-record-group : BANNER7_FORMS_10G.ASASIGN.YEAR_SOL_4_ORG_RG forms-module-record-group : BANNER7_FORMS_10G.AGAGSOL.YEAR_SOL_4_ORG_RG forms-module-record-group : BANNER7_FORMS_10G.AGAWPLG.YEAR_SOL_4_ORG_RG forms-module-record-group : BANNER7_FORMS_10G.ASIPOOL.YEAR_SOL_4_ORG_RG forms-module-record-group : BANNER7_FORMS_10G.ASAASCT.ASRSSAG_RG forms-module-record-group : BANNER7_FORMS_10G.ASAASCT.SOL_FOR_ORG_ALL_YRS_RG forms-module-record-group : BANNER7_FORMS_10G.ASAASCT.YEAR_SOL_4_ORG_RG forms-module-record-group : BANNER7_FORMS_10G.AGAPMAS.YEAR_SOL_4_ORG_RG forms-module-record-group : BANNER7_FORMS_10G.ASAUNCT.YEAR_SOL_4_ORG_RG |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRIDEN and ASRSSAG | ALUMNI |
Link type | Between | And |
---|---|---|
Join | SPRIDEN | ASRSSAG |
Objects list |
---|
schema-view : S4B70.BANINST1.AOVCOMP
forms-module-trigger : BANNER7_FORMS.FRA134B.DISPLAY_FIELDS forms-module-trigger : BANNER7_FORMS.FRA272B.DISPLAY_FIELDS forms-module-trigger : BANNER7_FORMS.FRAGENB.DISPLAY_FIELDS forms-module-trigger : BANNER7_FORMS.FRA269R.DISPLAY_FIELDS forms-module-trigger : BANNER7_FORMS.FRA272R.DISPLAY_FIELDS forms-module-trigger : BANNER7_FORMS.FRAGENR.DISPLAY_FIELDS forms-module-trigger : BANNER7_FORMS.FRA270B.DISPLAY_FIELDS schema-view : S4B70.BANINST1.SPVPERS schema-view : S4B70.BANINST1.SOVGEOR schema-view : S4B70.BANINST1.SPVADDS forms-module-trigger : BANNER7_FORMS_10G.FRA134B.DISPLAY_FIELDS forms-module-trigger : BANNER7_FORMS_10G.FRA272B.DISPLAY_FIELDS forms-module-trigger : BANNER7_FORMS_10G.FRAGENB.DISPLAY_FIELDS forms-module-trigger : BANNER7_FORMS_10G.FRA269R.DISPLAY_FIELDS forms-module-trigger : BANNER7_FORMS_10G.FRA272R.DISPLAY_FIELDS forms-module-trigger : BANNER7_FORMS_10G.FRAGENR.DISPLAY_FIELDS forms-module-trigger : BANNER7_FORMS_10G.FRA270B.DISPLAY_FIELDS |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRADDR and SPRIDEN | SATURN |
Link type | Between | And |
---|---|---|
Join | SPRADDR | SPRIDEN |
Objects list |
---|
schema-view : S4B70.BANINST1.ASVCAMP
forms-data-block-trigger : BANNER7_FORMS.APACONS.APRCSPS.QUERY_IDEN_PERS forms-data-block-item-trigger : BANNER7_FORMS.APACONS.APRCSPS.SPS_ID."POST-CHANGE" forms-data-block-trigger : BANNER7_FORMS_10G.APACONS.APRCSPS.QUERY_IDEN_PERS forms-data-block-item-trigger : BANNER7_FORMS_10G.APACONS.APRCSPS.SPS_ID."POST-CHANGE" |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRIDEN and APBCONS | ALUMNI |
Link type | Between | And |
---|---|---|
Join | SPRIDEN | APBCONS |
Objects list |
---|
schema-view : S4B70.BANINST1.ASVYEAR |
Link Type | Link | Project |
---|---|---|
Join | Link Between ASRSSAG and APBCONS | ALUMNI |
Link type | Between | And |
---|---|---|
Join | ASRSSAG | APBCONS |
Objects list |
---|
User link |
Link Type | Link | Project |
---|---|---|
Join | Link Between APRACYR and APRADEG | ALUMNI |
Link type | Between | And |
---|---|---|
Join | APRACYR | APRADEG |
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 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) |
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 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_PREF | 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_GEOR | 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 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 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 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 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) |