Model Directory_Data_Upload*
Object Name | Object Type | Layer Name |
---|---|---|
APRCRVW | SQL Table | Default |
APRDRVW | SQL Table | Default |
APRERVW | SQL Table | Default |
APRSRVW | SQL Table | Default |
ATVDSRC | SQL Table | Default |
SPRIDEN | SQL Table | Default |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
APRCRVW_PIDM |   | NUMBER(8,0) | No | * |   |
APRCRVW_DSRC_CODE |   | VARCHAR2(10) | No | * | * |
APRCRVW_LOAD_DATE |   | DATE | No | * |   |
APRCRVW_ACCEPTED_IND |   | VARCHAR2(1) | No |   |   |
APRCRVW_ACTIVITY_DATE |   | DATE | No |   |   |
APRCRVW_USER |   | VARCHAR2(30) | No |   |   |
APRCRVW_SEQ_NO |   | NUMBER(2,0) | No | * |   |
APRCRVW_SOURCE_DATE |   | DATE | No |   |   |
APRCRVW_LAST_NAME |   | VARCHAR2(60) | Yes |   |   |
APRCRVW_FIRST_NAME |   | VARCHAR2(60) | Yes |   |   |
APRCRVW_MI |   | VARCHAR2(60) | Yes |   |   |
APRCRVW_SEX |   | VARCHAR2(1) | Yes |   |   |
APRCRVW_BIRTH_DATE |   | DATE | Yes |   |   |
APRCRVW_SSN |   | VARCHAR2(15) | Yes |   |   |
APRCRVW_ATYP_CODE |   | VARCHAR2(2) | Yes |   |   |
APRCRVW_XREF_CODE |   | VARCHAR2(3) | Yes |   |   |
APRCRVW_CHLD_PIDM |   | NUMBER(8,0) | Yes |   |   |
APRCRVW_DISP_WEB_IND |   | VARCHAR2(1) | Yes |   |   |
APRCRVW_DECEASED_IND |   | VARCHAR2(1) | Yes |   |   |
APRCRVW_DECEASED_DATE |   | DATE | Yes |   |   |
APRCRVW_OK_FOR_NOTES_IND |   | VARCHAR2(1) | Yes |   |   |
APRCRVW_OTHR_PIDM |   | NUMBER(8,0) | Yes |   |   |
APRCRVW_OTHR_XREF_CODE |   | VARCHAR2(3) | Yes |   |   |
APRCRVW_COMMENT |   | LONG | Yes |   |   |
APRCRVW_SURNAME_PREFIX |   | VARCHAR2(60) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
APRCRVW_DSRC_CODE | ATVDSRC_CODE | ATVDSRC |
Index Name | Index Type | Column Name |
---|---|---|
PK_APRCRVW | Unique | APRCRVW_PIDM |
PK_APRCRVW | Unique | APRCRVW_DSRC_CODE |
PK_APRCRVW | Unique | APRCRVW_LOAD_DATE |
PK_APRCRVW | Unique | APRCRVW_SEQ_NO |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
SPRIDEN | SQL Table | S10B80.SATURN | Join |
APVLRVW | SQL View | S10B80.BANINST1 | Use (select) |
P_LOAD_APRCHLD | Oracle Package Procedure | S10B80.BANINST1.APKLDRD | Rely On |
P_LOAD_CHILD | Oracle Package Procedure | S10B80.BANINST1.APKLDRD | Rely On |
P_LOAD_CHILD | Oracle Package Procedure | S10B80.BANINST1.APKLDRD | Use (select)Rely On |
APRCRVW | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_APRCRVW | SQL Index | S10B80.ALUMNI | Rely On |
ATVDSRC | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:40:52:000 | 04/02/2008 13:49:15:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
APRDRVW_PIDM |   | NUMBER(8,0) | No | * |   |
APRDRVW_DSRC_CODE |   | VARCHAR2(10) | No | * | * |
APRDRVW_LOAD_DATE |   | DATE | No | * |   |
APRDRVW_ACCEPTED_IND |   | VARCHAR2(1) | No |   |   |
APRDRVW_ACTIVITY_DATE |   | DATE | No |   |   |
APRDRVW_USER |   | VARCHAR2(30) | No |   |   |
APRDRVW_SEQ_NO |   | NUMBER(2,0) | No | * |   |
APRDRVW_SOURCE_DATE |   | DATE | No |   |   |
APRDRVW_SBGI_CODE |   | VARCHAR2(6) | Yes |   |   |
APRDRVW_INST_NAME |   | VARCHAR2(60) | Yes |   |   |
APRDRVW_DEG_NAME |   | VARCHAR2(15) | Yes |   |   |
APRDRVW_MAJOR_NAME |   | VARCHAR2(60) | Yes |   |   |
APRDRVW_MAJOR_NAME2 |   | VARCHAR2(60) | Yes |   |   |
APRDRVW_MAJOR_NAME3 |   | VARCHAR2(60) | Yes |   |   |
APRDRVW_DEGC_CODE |   | VARCHAR2(6) | Yes |   |   |
APRDRVW_DATE |   | DATE | Yes |   |   |
APRDRVW_ACYR_CODE |   | VARCHAR2(4) | Yes |   |   |
APRDRVW_MAJR_CODE |   | VARCHAR2(4) | Yes |   |   |
APRDRVW_MAJR_CODE2 |   | VARCHAR2(4) | Yes |   |   |
APRDRVW_MAJR_CODE3 |   | VARCHAR2(4) | Yes |   |   |
APRDRVW_COLL_CODE |   | VARCHAR2(2) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
APRDRVW_DSRC_CODE | ATVDSRC_CODE | ATVDSRC |
Index Name | Index Type | Column Name |
---|---|---|
PK_APRDRVW | Unique | APRDRVW_PIDM |
PK_APRDRVW | Unique | APRDRVW_DSRC_CODE |
PK_APRDRVW | Unique | APRDRVW_LOAD_DATE |
PK_APRDRVW | Unique | APRDRVW_SEQ_NO |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
SPRIDEN | SQL Table | S10B80.SATURN | Join |
APVLRVW | SQL View | S10B80.BANINST1 | Use (select) |
P_LOAD_DEGREE | Oracle Package Procedure | S10B80.BANINST1.APKLDRD | Rely On |
P_LOAD_DEGREE | Oracle Package Procedure | S10B80.BANINST1.APKLDRD | Use (select)Rely On |
APRDRVW | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_APRDRVW | SQL Index | S10B80.ALUMNI | Rely On |
ATVDSRC | SQL Table | S10B80.ALUMNI | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:43:34:000 | 04/02/2008 13:49:19:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
APRERVW_PIDM |   | NUMBER(8,0) | No | * |   |
APRERVW_DSRC_CODE |   | VARCHAR2(10) | No | * | * |
APRERVW_LOAD_DATE |   | DATE | No | * |   |
APRERVW_ACCEPTED_IND |   | VARCHAR2(1) | No |   |   |
APRERVW_ACTIVITY_DATE |   | DATE | No |   |   |
APRERVW_USER |   | VARCHAR2(30) | No |   |   |
APRERVW_SEQ_NO |   | NUMBER(2,0) | No | * |   |
APRERVW_SOURCE_DATE |   | DATE | No |   |   |
APRERVW_EMPR_NAME |   | VARCHAR2(60) | Yes |   |   |
APRERVW_JOBC_CODE |   | VARCHAR2(3) | Yes |   |   |
APRERVW_EMPL_POSITION |   | VARCHAR2(60) | Yes |   |   |
APRERVW_FROM_DATE |   | DATE | Yes |   |   |
APRERVW_TO_DATE |   | DATE | Yes |   |   |
APRERVW_EMPR_PIDM |   | NUMBER(8,0) | Yes |   |   |
APRERVW_SICC_CODE |   | VARCHAR2(4) | Yes |   |   |
APRERVW_XREF_CODE |   | VARCHAR2(3) | Yes |   |   |
APRERVW_EMPS_CODE |   | VARCHAR2(1) | Yes |   |   |
APRERVW_WKLY_HOURS |   | NUMBER(5,2) | Yes |   |   |
APRERVW_PRIMARY_IND |   | VARCHAR2(1) | Yes |   |   |
APRERVW_JOBC_CODE2 |   | VARCHAR2(3) | Yes |   |   |
APRERVW_JOBC_CODE3 |   | VARCHAR2(3) | Yes |   |   |
APRERVW_JOBC_CODE4 |   | VARCHAR2(3) | Yes |   |   |
APRERVW_MG_IND |   | VARCHAR2(1) | Yes |   |   |
APRERVW_ATYP_CODE |   | VARCHAR2(2) | Yes |   |   |
APRERVW_ASRC_CODE |   | VARCHAR2(4) | Yes |   |   |
APRERVW_ADDR_FROM_DATE |   | DATE | Yes |   |   |
APRERVW_ADDR_TO_DATE |   | DATE | Yes |   |   |
APRERVW_STREET_LINE1 |   | VARCHAR2(75) | Yes |   |   |
APRERVW_STREET_LINE2 |   | VARCHAR2(75) | Yes |   |   |
APRERVW_STREET_LINE3 |   | VARCHAR2(75) | Yes |   |   |
APRERVW_CITY |   | VARCHAR2(50) | Yes |   |   |
APRERVW_STAT_CODE |   | VARCHAR2(3) | Yes |   |   |
APRERVW_ZIP |   | VARCHAR2(30) | Yes |   |   |
APRERVW_CNTY_CODE |   | VARCHAR2(5) | Yes |   |   |
APRERVW_NATN_CODE |   | VARCHAR2(5) | Yes |   |   |
APRERVW_DELIVERY_POINT |   | NUMBER(2,0) | Yes |   |   |
APRERVW_CORRECTION_DIGIT |   | NUMBER(1,0) | Yes |   |   |
APRERVW_CARRIER_ROUTE |   | VARCHAR2(4) | Yes |   |   |
APRERVW_TELE_CODE |   | VARCHAR2(4) | Yes |   |   |
APRERVW_PHONE_AREA |   | VARCHAR2(6) | Yes |   |   |
APRERVW_PHONE_NUMBER |   | VARCHAR2(12) | Yes |   |   |
APRERVW_PHONE_EXT |   | VARCHAR2(10) | Yes |   |   |
APRERVW_FAX_TELE_CODE |   | VARCHAR2(4) | Yes |   |   |
APRERVW_FAX_AREA |   | VARCHAR2(6) | Yes |   |   |
APRERVW_FAX_NUMBER |   | VARCHAR2(12) | Yes |   |   |
APRERVW_EMAIL_CODE |   | VARCHAR2(4) | Yes |   |   |
APRERVW_EMAIL_ADDRESS |   | VARCHAR2(128) | Yes |   |   |
APRERVW_COOP_IND |   | VARCHAR2(1) | No |   |   |
APRERVW_STREET_LINE4 |   | VARCHAR2(75) | Yes |   |   |
APRERVW_CTRY_CODE_PHONE |   | VARCHAR2(4) | Yes |   |   |
APRERVW_HOUSE_NUMBER |   | VARCHAR2(10) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
APRERVW_DSRC_CODE | ATVDSRC_CODE | ATVDSRC |
Index Name | Index Type | Column Name |
---|---|---|
PK_APRERVW | Unique | APRERVW_PIDM |
PK_APRERVW | Unique | APRERVW_DSRC_CODE |
PK_APRERVW | Unique | APRERVW_LOAD_DATE |
PK_APRERVW | Unique | APRERVW_SEQ_NO |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
SPRIDEN | SQL Table | S10B80.SATURN | Join |
APVLRVW | SQL View | S10B80.BANINST1 | Use (select) |
P_LOAD_EMPLOYER | Oracle Package Procedure | S10B80.BANINST1.APKLDRD | Rely On |
P_LOAD_EMPLOYER | Oracle Package Procedure | S10B80.BANINST1.APKLDRD | Use (select)Rely On |
APRERVW | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_APRERVW | SQL Index | S10B80.ALUMNI | Rely On |
ATVDSRC | SQL Table | S10B80.ALUMNI | Refer (no action) |
AT_APRERVW_INSERT_ROW | SQL Trigger | S10B80.ALUMNI | Fire (Insert,before,each row) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:46:20:000 | 04/02/2008 13:49:22:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
APRSRVW_PIDM |   | NUMBER(8,0) | No | * |   |
APRSRVW_DSRC_CODE |   | VARCHAR2(10) | No | * | * |
APRSRVW_LOAD_DATE |   | DATE | No | * |   |
APRSRVW_ACCEPTED_IND |   | VARCHAR2(1) | No |   |   |
APRSRVW_ACTIVITY_DATE |   | DATE | No |   |   |
APRSRVW_USER |   | VARCHAR2(30) | No |   |   |
APRSRVW_SEQ_NO |   | NUMBER(2,0) | No | * |   |
APRSRVW_SOURCE_DATE |   | DATE | No |   |   |
APRSRVW_MARS_IND |   | VARCHAR2(1) | Yes |   |   |
APRSRVW_SPS_PIDM |   | NUMBER(8,0) | Yes |   |   |
APRSRVW_LAST_NAME |   | VARCHAR2(60) | Yes |   |   |
APRSRVW_FIRST_NAME |   | VARCHAR2(60) | Yes |   |   |
APRSRVW_MI |   | VARCHAR2(60) | Yes |   |   |
APRSRVW_MAIDEN_NAME |   | VARCHAR2(60) | Yes |   |   |
APRSRVW_NAME_PREFIX |   | VARCHAR2(20) | Yes |   |   |
APRSRVW_NAME_SUFFIX |   | VARCHAR2(20) | Yes |   |   |
APRSRVW_BIRTH_DATE |   | DATE | Yes |   |   |
APRSRVW_SPS_COMMENT |   | VARCHAR2(60) | Yes |   |   |
APRSRVW_MRTL_CODE |   | VARCHAR2(1) | Yes |   |   |
APRSRVW_MRTL_START_DATE |   | DATE | Yes |   |   |
APRSRVW_MRTL_END_DATE |   | DATE | Yes |   |   |
APRSRVW_DEAD_IND |   | VARCHAR2(1) | Yes |   |   |
APRSRVW_DEAD_DATE |   | DATE | Yes |   |   |
APRSRVW_XREF_CODE |   | VARCHAR2(3) | Yes |   |   |
APRSRVW_ATYP_CODE |   | VARCHAR2(2) | Yes |   |   |
APRSRVW_ASRC_CODE |   | VARCHAR2(4) | Yes |   |   |
APRSRVW_ADDR_FROM_DATE |   | DATE | Yes |   |   |
APRSRVW_ADDR_TO_DATE |   | DATE | Yes |   |   |
APRSRVW_STREET_LINE1 |   | VARCHAR2(75) | Yes |   |   |
APRSRVW_STREET_LINE2 |   | VARCHAR2(75) | Yes |   |   |
APRSRVW_STREET_LINE3 |   | VARCHAR2(75) | Yes |   |   |
APRSRVW_CITY |   | VARCHAR2(50) | Yes |   |   |
APRSRVW_STAT_CODE |   | VARCHAR2(3) | Yes |   |   |
APRSRVW_ZIP |   | VARCHAR2(30) | Yes |   |   |
APRSRVW_CNTY_CODE |   | VARCHAR2(5) | Yes |   |   |
APRSRVW_NATN_CODE |   | VARCHAR2(5) | Yes |   |   |
APRSRVW_DELIVERY_POINT |   | NUMBER(2,0) | Yes |   |   |
APRSRVW_CORRECTION_DIGIT |   | NUMBER(1,0) | Yes |   |   |
APRSRVW_CARRIER_ROUTE |   | VARCHAR2(4) | Yes |   |   |
APRSRVW_TELE_CODE |   | VARCHAR2(4) | Yes |   |   |
APRSRVW_PHONE_AREA |   | VARCHAR2(6) | Yes |   |   |
APRSRVW_PHONE_NUMBER |   | VARCHAR2(12) | Yes |   |   |
APRSRVW_PHONE_EXT |   | VARCHAR2(10) | Yes |   |   |
APRSRVW_FAX_TELE_CODE |   | VARCHAR2(4) | Yes |   |   |
APRSRVW_FAX_AREA |   | VARCHAR2(6) | Yes |   |   |
APRSRVW_FAX_NUMBER |   | VARCHAR2(12) | Yes |   |   |
APRSRVW_EMAIL_CODE |   | VARCHAR2(4) | Yes |   |   |
APRSRVW_EMAIL_ADDRESS |   | VARCHAR2(128) | Yes |   |   |
APRSRVW_CTRY_CODE_PHONE |   | VARCHAR2(4) | Yes |   |   |
APRSRVW_SURNAME_PREFIX |   | VARCHAR2(60) | Yes |   |   |
APRSRVW_STREET_LINE4 |   | VARCHAR2(75) | Yes |   |   |
APRSRVW_HOUSE_NUMBER |   | VARCHAR2(10) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
APRSRVW_DSRC_CODE | ATVDSRC_CODE | ATVDSRC |
Index Name | Index Type | Column Name |
---|---|---|
PK_APRSRVW | Unique | APRSRVW_PIDM |
PK_APRSRVW | Unique | APRSRVW_DSRC_CODE |
PK_APRSRVW | Unique | APRSRVW_LOAD_DATE |
PK_APRSRVW | Unique | APRSRVW_SEQ_NO |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
SPRIDEN | SQL Table | S10B80.SATURN | Join |
APVLRVW | SQL View | S10B80.BANINST1 | Use (select) |
P_LOAD_SPOUSE | Oracle Package Procedure | S10B80.BANINST1.APKLDRD | Rely On |
P_LOAD_SPOUSE | Oracle Package Procedure | S10B80.BANINST1.APKLDRD | Use (select)Rely On |
APRSRVW | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_APRSRVW | SQL Index | S10B80.ALUMNI | Rely On |
ATVDSRC | SQL Table | S10B80.ALUMNI | Refer (no action) |
AT_APRSRVW_INSERT_ROW | SQL Trigger | S10B80.ALUMNI | Fire (Insert,before,each row) |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:42:17:000 | 04/02/2008 13:49:17:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
ATVDSRC_CODE |   | VARCHAR2(10) | No | * |   |
ATVDSRC_DESC |   | VARCHAR2(60) | No |   |   |
ATVDSRC_ACTIVITY_DATE |   | DATE | No |   |   |
ATVDSRC_USER |   | VARCHAR2(30) | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_ATVDSRC | Unique | ATVDSRC_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
APRCRVW | SQL Table | S10B80.ALUMNI | Refer (no action) |
APRDRVW | SQL Table | S10B80.ALUMNI | Refer (no action) |
APRERVW | SQL Table | S10B80.ALUMNI | Refer (no action) |
APRSRVW | SQL Table | S10B80.ALUMNI | Refer (no action) |
APRTRAN | SQL Table | S10B80.ALUMNI | Refer (no action) |
F_ATVDSRC_EQUAL | Oracle Package Function | S10B80.BANINST1.AOKPVAL | Use (select) |
ATVDSRC | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_ATVDSRC | SQL Index | S10B80.ALUMNI | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:41:19:000 | 04/02/2008 13:49:16:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
SPRIDEN_PIDM |   | NUMBER(8,0) | No |   | * |
SPRIDEN_ID |   | VARCHAR2(9) | No |   | * |
SPRIDEN_LAST_NAME |   | VARCHAR2(60) | No |   |   |
SPRIDEN_FIRST_NAME |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_MI |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_CHANGE_IND |   | VARCHAR2(1) | Yes |   |   |
SPRIDEN_ENTITY_IND |   | VARCHAR2(1) | Yes |   |   |
SPRIDEN_ACTIVITY_DATE |   | DATE | No |   |   |
SPRIDEN_USER |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_ORIGIN |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_SEARCH_LAST_NAME |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_SEARCH_FIRST_NAME |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_SEARCH_MI |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_SOUNDEX_LAST_NAME |   | CHAR(4) | Yes |   |   |
SPRIDEN_SOUNDEX_FIRST_NAME |   | CHAR(4) | Yes |   |   |
SPRIDEN_NTYP_CODE |   | VARCHAR2(4) | Yes |   | * |
SPRIDEN_CREATE_USER |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_CREATE_DATE |   | DATE | Yes |   |   |
SPRIDEN_DATA_ORIGIN |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_CREATE_FDMN_CODE |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_SURNAME_PREFIX |   | VARCHAR2(60) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
SPRIDEN_NTYP_CODE | GTVNTYP_CODE | GTVNTYP |
SPRIDEN_PIDM | GOBEACC_PIDM | GOBEACC |
SPRIDEN_PIDM | SFRSTCR_PIDM | SFRSTCR |
SPRIDEN_PIDM | SPBPERS_PIDM | SPBPERS |
SPRIDEN_PIDM | NBRBJOB_PIDM | NBRBJOB |
SPRIDEN_PIDM | SIBINST_PIDM | SIBINST |
SPRIDEN_PIDM | SHRTTRM_PIDM | SHRTTRM |
SPRIDEN_PIDM | SARADAP_PIDM | SARADAP |
SPRIDEN_PIDM | GLBEXTR_KEY | GLBEXTR |
SPRIDEN_PIDM | SHRDGMR_PIDM | SHRDGMR |
SPRIDEN_PIDM | RORSTAT_PIDM | RORSTAT |
SPRIDEN_PIDM | APRXREF_XREF_PIDM | APRXREF |
SPRIDEN_PIDM | SHBCOMI_PIDM | SHBCOMI |
SPRIDEN_PIDM | AFRCSLT_PIDM | AFRCSLT |
SPRIDEN_PIDM | APRCATG_PIDM | APRCATG |
SPRIDEN_PIDM | SIRASGN_PIDM | SIRASGN |
SPRIDEN_PIDM | APRCSPS_SPS_PIDM | APRCSPS |
SPRIDEN_PIDM | SGBSTDN_PIDM | SGBSTDN |
SPRIDEN_PIDM | PERJOBP_PIDM | PERJOBP |
SPRIDEN_PIDM | AFRCTYP_CONSTITUENT_PIDM | AFRCTYP |
SPRIDEN_PIDM | AMRINFO_PIDM | AMRINFO |
SPRIDEN_PIDM | SORHSCH_PIDM | SORHSCH |
SPRIDEN_PIDM | RERSTID_PIDM | RERSTID |
SPRIDEN_PIDM | AOBORGN_PIDM | AOBORGN |
SPRIDEN_PIDM | GOBSRVR_PIDM | GOBSRVR |
SPRIDEN_PIDM | APRDHIS_PIDM | APRDHIS |
SPRIDEN_PIDM | SLRRMAT_PIDM | SLRRMAT |
SPRIDEN_PIDM | SABSTUD_PIDM | SABSTUD |
SPRIDEN_PIDM | SGRASSI_PIDM | SGRASSI |
SPRIDEN_PIDM | SHTTRAN_PIDM | SHTTRAN |
SPRIDEN_PIDM | APBCONS_PIDM | APBCONS |
SPRIDEN_PIDM | ASRSSAG_PIDM | ASRSSAG |
SPRIDEN_PIDM | SABIDEN_PIDM | SABIDEN |
SPRIDEN_PIDM | SFRENRL_PIDM | SFRENRL |
SPRIDEN_PIDM | SHRGCOL_PIDM | SHRGCOL |
SPRIDEN_PIDM | SFBETRM_PIDM | SFBETRM |
SPRIDEN_PIDM | SRBRECR_PIDM | SRBRECR |
SPRIDEN_PIDM | PABAPPL_PIDM | PABAPPL |
SPRIDEN_PIDM | PEBEMPL_PIDM | PEBEMPL |
SPRIDEN_PIDM | SORPCOL_PIDM | SORPCOL |
SPRIDEN_PIDM | SPRHOLD_PIDM | SPRHOLD |
SPRIDEN_PIDM | RPRATRM_PIDM | RPRATRM |
SPRIDEN_PIDM | SHRCOMM_PIDM_MEMBER | SHRCOMM |
SPRIDEN_PIDM | RPRAWRD_PIDM | RPRAWRD |
SPRIDEN_PIDM | ASRSORG_PIDM | ASRSORG |
SPRIDEN_PIDM | SLRRASG_PIDM | SLRRASG |
SPRIDEN_PIDM | SMBSLIB_PIDM | SMBSLIB |
SPRIDEN_PIDM | APRCHLD_CHLD_PIDM | APRCHLD |
SPRIDEN_PIDM | APREHIS_EMPR_PIDM | APREHIS |
SPRIDEN_PIDM | PERBARG_PIDM | PERBARG |
SPRIDEN_PIDM | PARAPIN_PIDM | PARAPIN |
SPRIDEN_PIDM | SPRADDR_PIDM | SPRADDR |
SPRIDEN_PIDM | PDRBDED_PIDM | PDRBDED |
SPRIDEN_PIDM | SORAROL_PIDM | SORAROL |
SPRIDEN_PIDM | SERDTGL_PIDM | SERDTGL |
SPRIDEN_PIDM | SERDTND_PIDM | SERDTND |
SPRIDEN_PIDM | SERDTSR_PIDM | SERDTSR |
SPRIDEN_PIDM | SLBEVNT_AGENCY_PIDM | SLBEVNT |
SPRIDEN_PIDM | RORLOGM_PIDM | RORLOGM |
SPRIDEN_PIDM | RNRTMNT_PIDM | RNRTMNT |
SPRIDEN_PIDM | SHBHEAD_PIDM | SHBHEAD |
SPRIDEN_PIDM | SMRRQCM_ORIG_PIDM | SMRRQCM |
SPRIDEN_PIDM | SMRRQCM_PIDM | SMRRQCM |
SPRIDEN_PIDM | GORSVAS_ACT_SITE_PIDM | GORSVAS |
SPRIDEN_PIDM | GORSEVD_DEP_PIDM | GORSEVD |
SPRIDEN_PIDM | GORSVEI_EMPLOYER_PIDM | GORSVEI |
SPRIDEN_PIDM | GOBSEVS_PIDM | GOBSEVS |
SPRIDEN_PIDM | PERJOBS_COMMENT_PIDM | PERJOBS |
SPRIDEN_PIDM | PERJOBS_PIDM | PERJOBS |
SPRIDEN_PIDM | AGBMGID_EMPR_PIDM | AGBMGID |
SPRIDEN_PIDM | AGBMGID_EMPL_PIDM | AGBMGID |
SPRIDEN_PIDM | AORCONT_CONTACT_PIDM | AORCONT |
SPRIDEN_PIDM | SORAINF_PIDM | SORAINF |
SPRIDEN_PIDM | NBRJOBS_PIDM | NBRJOBS |
SPRIDEN_PIDM | GORSEVS_PIDM | GORSEVS |
SPRIDEN_PIDM | PDRBENE_BENE_PIDM | PDRBENE |
SPRIDEN_PIDM | APRCHIS_PIDM | APRCHIS |
SPRIDEN_PIDM | PERREVW_PIDM | PERREVW |
SPRIDEN_PIDM | GERATTD_PIDM | GERATTD |
SPRIDEN_PIDM | SGRADVR_ADVR_PIDM | SGRADVR |
SPRIDEN_PIDM | SGRADVR_PIDM | SGRADVR |
SPRIDEN_PIDM | FABINVH_VEND_CHECK_PIDM | FABINVH |
SPRIDEN_PIDM | FABINVH_VEND_PIDM | FABINVH |
SPRIDEN_PIDM | PERJOBH_COMMENT_PIDM | PERJOBH |
SPRIDEN_PIDM | PERTETH_TRANS_PIDM | PERTETH |
SPRIDEN_PIDM | PERROUT_ACTION_PIDM | PERROUT |
SPRIDEN_PIDM | PERROUT_APPR_PIDM | PERROUT |
SPRIDEN_PIDM | FTVVEND_PIDM | FTVVEND |
SPRIDEN_PIDM | GOBTPAC_PIDM | GOBTPAC |
SPRIDEN_PIDM | FRBGRNT_AGENCY_PIDM | FRBGRNT |
SPRIDEN_PIDM | AMRSTAF_PIDM | AMRSTAF |
SPRIDEN_PIDM | SHRMRKS_PIDM | SHRMRKS |
SPRIDEN_PIDM | SHRCMRK_PIDM | SHRCMRK |
SPRIDEN_PIDM | SHRSMRK_PIDM | SHRSMRK |
SPRIDEN_PIDM | NBREJOB_PIDM | NBREJOB |
SPRIDEN_PIDM | SHRNCRS_ADVR_PIDM | SHRNCRS |
SPRIDEN_PIDM | SHRTCKN_PIDM | SHRTCKN |
SPRIDEN_PIDM | NBTJOBF_EMPLOYEE_PIDM | NBTJOBF |
SPRIDEN_PIDM | RCRAPP1_PIDM | RCRAPP1 |
SPRIDEN_PIDM | RPRLAPP_LENDER_PIDM | RPRLAPP |
SPRIDEN_PIDM | SFRAREG_PIDM | SFRAREG |
SPRIDEN_PIDM | PERFJOB_PIDM | PERFJOB |
SPRIDEN_PIDM | AMRPLAN_PIDM | AMRPLAN |
SPRIDEN_PIDM | GORVISA_PIDM | GORVISA |
SPRIDEN_ID | SRTIDEN_ID | SRTIDEN |
SPRIDEN_PIDM | SRTIDEN_PIDM | SRTIDEN |
SPRIDEN_PIDM | PERFCNT_PIDM | PERFCNT |
SPRIDEN_PIDM | APRACYR_PIDM | APRACYR |
SPRIDEN_PIDM | SHTTRTC_PIDM | SHTTRTC |
SPRIDEN_PIDM | GOBUMAP_PIDM | GOBUMAP |
SPRIDEN_PIDM | AORJPST_EMPR_PIDM | AORJPST |
SPRIDEN_PIDM | FTVIMGR_IMGR_CODE_PIDM | FTVIMGR |
SPRIDEN_PIDM | APRCRVW_PIDM | APRCRVW |
SPRIDEN_PIDM | APRERVW_PIDM | APRERVW |
SPRIDEN_PIDM | APRSRVW_PIDM | APRSRVW |
SPRIDEN_PIDM | APRDRVW_PIDM | APRDRVW |
Index Name | Index Type | Column Name |
---|---|---|
SPRIDEN_INDEX_ID |   | SPRIDEN_ID |
SPRIDEN_INDEX_ID |   | SPRIDEN_ENTITY_IND |
SPRIDEN_INDEX_ID |   | SPRIDEN_CHANGE_IND |
SPRIDEN_INDEX_PERS |   | SPRIDEN_LAST_NAME |
SPRIDEN_INDEX_PERS |   | SPRIDEN_FIRST_NAME |
SPRIDEN_INDEX_PERS |   | SPRIDEN_MI |
SPRIDEN_INDEX_PERS |   | SPRIDEN_ENTITY_IND |
SPRIDEN_INDEX_PERS |   | SPRIDEN_CHANGE_IND |
SPRIDEN_INDEX_SEARCH |   | SPRIDEN_SEARCH_LAST_NAME |
SPRIDEN_INDEX_SEARCH |   | SPRIDEN_SEARCH_FIRST_NAME |
SPRIDEN_INDEX_SEARCH |   | SPRIDEN_SEARCH_MI |
SPRIDEN_INDEX_SOUNDEX |   | SPRIDEN_SOUNDEX_LAST_NAME |
SPRIDEN_INDEX_SOUNDEX |   | SPRIDEN_SOUNDEX_FIRST_NAME |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_PIDM |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_ID |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_LAST_NAME |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_FIRST_NAME |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_MI |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_CHANGE_IND |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_NTYP_CODE |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:48:43:000 | 04/02/2008 21:17:58:000 |
Objects list |
---|
User link |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRIDEN and APRCRVW | SATURN |
Link type | Between | And |
---|---|---|
Join | SPRIDEN | APRCRVW |
Objects list |
---|
User link |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRIDEN and APRERVW | SATURN |
Link type | Between | And |
---|---|---|
Join | SPRIDEN | APRERVW |
Objects list |
---|
User link |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRIDEN and APRSRVW | SATURN |
Link type | Between | And |
---|---|---|
Join | SPRIDEN | APRSRVW |
Objects list |
---|
User link |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRIDEN and APRDRVW | SATURN |
Link type | Between | And |
---|---|---|
Join | SPRIDEN | APRDRVW |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between APRCRVW and ATVDSRC (FK1_APRCRVW_INV_ATVDSRC_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
APRCRVW | APRCRVW_DSRC_CODE | ATVDSRC_CODE | ATVDSRC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between APRSRVW and ATVDSRC (FK1_APRSRVW_INV_ATVDSRC_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
APRSRVW | APRSRVW_DSRC_CODE | ATVDSRC_CODE | ATVDSRC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between APRDRVW and ATVDSRC (FK1_APRDRVW_INV_ATVDSRC_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
APRDRVW | APRDRVW_DSRC_CODE | ATVDSRC_CODE | ATVDSRC | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between APRERVW and ATVDSRC (FK1_APRERVW_INV_ATVDSRC_CODE) | ALUMNI |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
APRERVW | APRERVW_DSRC_CODE | ATVDSRC_CODE | ATVDSRC | (1,1)-(0,n) |