Model Answer_A_Survey
Object Name | Object Type | Layer Name |
---|---|---|
GLBEXTR | SQL Table | Default |
GLVEXTR | SQL View | Default |
GOBSRVR | SQL Table | Default |
GORSRVR | SQL Table | Default |
GUBSRVY | SQL Table | Default |
GURSRVQ | SQL Table | Default |
GURSVRL | SQL Table | Default |
SPRIDEN | SQL Table | Default |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GLBEXTR_APPLICATION |   | VARCHAR2(30) | No | * | * |
GLBEXTR_SELECTION |   | VARCHAR2(30) | No | * | * |
GLBEXTR_CREATOR_ID |   | VARCHAR2(30) | No | * | * |
GLBEXTR_USER_ID |   | VARCHAR2(30) | No | * |   |
GLBEXTR_KEY |   | VARCHAR2(80) | No | * |   |
GLBEXTR_ACTIVITY_DATE |   | DATE | No |   |   |
GLBEXTR_SYS_IND |   | VARCHAR2(1) | No |   |   |
GLBEXTR_SLCT_IND |   | VARCHAR2(1) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GLBEXTR_APPLICATION | GLBSLCT_APPLICATION | GLBSLCT |
GLBEXTR_SELECTION | GLBSLCT_SELECTION | GLBSLCT |
GLBEXTR_CREATOR_ID | GLBSLCT_CREATOR_ID | GLBSLCT |
Index Name | Index Type | Column Name |
---|---|---|
PK_GLBEXTR | Unique | GLBEXTR_APPLICATION |
PK_GLBEXTR | Unique | GLBEXTR_SELECTION |
PK_GLBEXTR | Unique | GLBEXTR_CREATOR_ID |
PK_GLBEXTR | Unique | GLBEXTR_USER_ID |
PK_GLBEXTR | Unique | GLBEXTR_KEY |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GLBEXTR | SQL Index | S10B80.GENERAL | Rely On |
GLBSLCT | SQL Table | S10B80.GENERAL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:29:33:000 | 04/02/2008 21:17:53:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GOBSRVR_PIDM |   | NUMBER(8,0) | No | * |   |
GOBSRVR_NAME |   | VARCHAR2(15) | No | * |   |
GOBSRVR_ACTIVITY_DATE |   | DATE | No |   |   |
GOBSRVR_USER |   | VARCHAR2(30) | No |   |   |
GOBSRVR_DECLINED_IND |   | VARCHAR2(1) | No |   |   |
GOBSRVR_COMPLETE_IND |   | VARCHAR2(1) | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_GOBSRVR | Unique | GOBSRVR_PIDM |
PK_GOBSRVR | Unique | GOBSRVR_NAME |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GORSRVR | SQL Table | S10B80.GENERAL | Refer (no action) |
SPRIDEN | SQL Table | S10B80.SATURN | Join |
GOVSRVR | SQL View | S10B80.BANINST1 | Use (select) |
GOBSRVR_REC | Oracle Package Variable | S10B80.BANINST1.BWGKSRVY | Rely On |
P_MODIFYRESPONSEHEAD | Oracle Package Procedure | S10B80.BANINST1.BWGKSRVY | Use (Insert,update) |
GOBSRVRREADC | Oracle Package Cursor | S10B80.BANINST1.BWGKSRVY | Use (select)Rely On |
GOBSRVR | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GOBSRVR | SQL Index | S10B80.GENERAL | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:30:54:000 | 04/02/2008 21:17:54:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GORSRVR_PIDM |   | NUMBER(8,0) | No | * | * |
GORSRVR_NAME |   | VARCHAR2(15) | No | * | * |
GORSRVR_QUESTION_NO |   | NUMBER(3,0) | No | * |   |
GORSRVR_ACTIVITY_DATE |   | DATE | No |   |   |
GORSRVR_USER |   | VARCHAR2(30) | No |   |   |
GORSRVR_RESPONSE_1 |   | VARCHAR2(1) | Yes |   |   |
GORSRVR_RESPONSE_2 |   | VARCHAR2(1) | Yes |   |   |
GORSRVR_RESPONSE_3 |   | VARCHAR2(1) | Yes |   |   |
GORSRVR_RESPONSE_4 |   | VARCHAR2(1) | Yes |   |   |
GORSRVR_RESPONSE_5 |   | VARCHAR2(1) | Yes |   |   |
GORSRVR_COMMENTS |   | VARCHAR2(2000) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GORSRVR_PIDM | GOBSRVR_PIDM | GOBSRVR |
GORSRVR_NAME | GOBSRVR_NAME | GOBSRVR |
Index Name | Index Type | Column Name |
---|---|---|
PK_GORSRVR | Unique | GORSRVR_PIDM |
PK_GORSRVR | Unique | GORSRVR_NAME |
PK_GORSRVR | Unique | GORSRVR_QUESTION_NO |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GORSRVR_ADS | SQL View | S10B80.BANINST1 | Use (select) |
GORSRVR_SUB | SQL View | S10B80.BANINST1 | Use (select) |
GORSRVR_REC | Oracle Package Variable | S10B80.BANINST1.BWGKSRVY | Rely On |
P_MODIFYRESPONSES | Oracle Package Procedure | S10B80.BANINST1.BWGKSRVY | Use (Insert,update) |
GORSRVRREADC | Oracle Package Cursor | S10B80.BANINST1.BWGKSRVY | Use (select)Rely On |
GORSRVR | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GORSRVR | SQL Index | S10B80.GENERAL | Rely On |
GOBSRVR | SQL Table | S10B80.GENERAL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:28:11:000 | 04/02/2008 21:17:51:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GUBSRVY_NAME |   | VARCHAR2(15) | No | * |   |
GUBSRVY_TITLE |   | VARCHAR2(60) | No |   |   |
GUBSRVY_DISP_WEB_IND |   | VARCHAR2(1) | No |   |   |
GUBSRVY_ACTIVITY_DATE |   | DATE | No |   |   |
GUBSRVY_USER |   | VARCHAR2(30) | No |   |   |
GUBSRVY_FROM_DATE |   | DATE | Yes |   |   |
GUBSRVY_TO_DATE |   | DATE | Yes |   |   |
GUBSRVY_EXTR_APPLICATION |   | VARCHAR2(30) | Yes |   |   |
GUBSRVY_EXTR_SELECTION |   | VARCHAR2(30) | Yes |   |   |
GUBSRVY_EXTR_CREATOR_ID |   | VARCHAR2(30) | Yes |   |   |
GUBSRVY_EXTR_USER_ID |   | VARCHAR2(30) | Yes |   |   |
GUBSRVY_INFO |   | VARCHAR2(2000) | Yes |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_GUBSRVY | Unique | GUBSRVY_NAME |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GURSRVQ | SQL Table | S10B80.GENERAL | Refer (no action) |
GURSVRL | SQL Table | S10B80.GENERAL | Refer (no action) |
GUBSRVY_REC | Oracle Package Variable | S10B80.BANINST1.BWGKSRVY | Rely On |
GUBSRVYDISPC | Oracle Package Cursor | S10B80.BANINST1.BWGKSRVY | Use (select)Rely On |
GUBSRVYREADC | Oracle Package Cursor | S10B80.BANINST1.BWGKSRVY | Use (select)Rely On |
GUBSRVY | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GUBSRVY | SQL Index | S10B80.GENERAL | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:31:33:000 | 04/02/2008 21:17:55:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GURSRVQ_NAME |   | VARCHAR2(15) | No | * | * |
GURSRVQ_QUESTION_NO |   | NUMBER(3,0) | No | * |   |
GURSRVQ_ACTIVITY_DATE |   | DATE | No |   |   |
GURSRVQ_USER |   | VARCHAR2(30) | No |   |   |
GURSRVQ_MULT_RESP_IND |   | VARCHAR2(1) | No |   |   |
GURSRVQ_TEXT |   | VARCHAR2(1000) | No |   |   |
GURSRVQ_ALLOW_COMMENTS_IND |   | VARCHAR2(1) | No |   |   |
GURSRVQ_RESPONSE_1_TEXT |   | VARCHAR2(60) | Yes |   |   |
GURSRVQ_RESPONSE_2_TEXT |   | VARCHAR2(60) | Yes |   |   |
GURSRVQ_RESPONSE_3_TEXT |   | VARCHAR2(60) | Yes |   |   |
GURSRVQ_RESPONSE_4_TEXT |   | VARCHAR2(60) | Yes |   |   |
GURSRVQ_RESPONSE_5_TEXT |   | VARCHAR2(60) | Yes |   |   |
GURSRVQ_COMMENTS_TEXT |   | VARCHAR2(60) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GURSRVQ_NAME | GUBSRVY_NAME | GUBSRVY |
Index Name | Index Type | Column Name |
---|---|---|
PK_GURSRVQ | Unique | GURSRVQ_NAME |
PK_GURSRVQ | Unique | GURSRVQ_QUESTION_NO |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GURSRVQ_ADD | SQL View | S10B80.BANINST1 | Use (select) |
GURSRVQ_ADS | SQL View | S10B80.BANINST1 | Use (select) |
GURSRVQ_SUB | SQL View | S10B80.BANINST1 | Use (select) |
GURSRVQ_REC | Oracle Package Variable | S10B80.BANINST1.BWGKSRVY | Rely On |
GURSRVQREADC_MSC | Oracle Package Cursor | S10B80.BANINST1.BWGKSRVY | Use (select)Rely On |
GURSRVQREADC | Oracle Package Cursor | S10B80.BANINST1.BWGKSRVY | Use (select)Rely On |
GURSRVQ | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GURSRVQ | SQL Index | S10B80.GENERAL | Rely On |
GUBSRVY | SQL Table | S10B80.GENERAL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:28:42:000 | 04/02/2008 21:17:52:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GURSVRL_NAME |   | VARCHAR2(15) | No | * | * |
GURSVRL_ROLE |   | VARCHAR2(30) | No | * |   |
GURSVRL_ACTIVITY_DATE |   | DATE | No |   |   |
GURSVRL_USER |   | VARCHAR2(30) | No |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GURSVRL_NAME | GUBSRVY_NAME | GUBSRVY |
Index Name | Index Type | Column Name |
---|---|---|
PK_GURSVRL | Unique | GURSVRL_NAME |
PK_GURSVRL | Unique | GURSVRL_ROLE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GURSVRL_REC | Oracle Package Variable | S10B80.BANINST1.BWGKSRVY | Rely On |
GURSVRLREADC | Oracle Package Cursor | S10B80.BANINST1.BWGKSRVY | Use (select)Rely On |
GURSVRL | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GURSVRL | SQL Index | S10B80.GENERAL | Rely On |
GUBSRVY | SQL Table | S10B80.GENERAL | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:31:50:000 | 04/02/2008 21:17:55:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
SPRIDEN_PIDM |   | NUMBER(8,0) | No |   | * |
SPRIDEN_ID |   | VARCHAR2(9) | No |   | * |
SPRIDEN_LAST_NAME |   | VARCHAR2(60) | No |   |   |
SPRIDEN_FIRST_NAME |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_MI |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_CHANGE_IND |   | VARCHAR2(1) | Yes |   |   |
SPRIDEN_ENTITY_IND |   | VARCHAR2(1) | Yes |   |   |
SPRIDEN_ACTIVITY_DATE |   | DATE | No |   |   |
SPRIDEN_USER |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_ORIGIN |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_SEARCH_LAST_NAME |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_SEARCH_FIRST_NAME |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_SEARCH_MI |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_SOUNDEX_LAST_NAME |   | CHAR(4) | Yes |   |   |
SPRIDEN_SOUNDEX_FIRST_NAME |   | CHAR(4) | Yes |   |   |
SPRIDEN_NTYP_CODE |   | VARCHAR2(4) | Yes |   | * |
SPRIDEN_CREATE_USER |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_CREATE_DATE |   | DATE | Yes |   |   |
SPRIDEN_DATA_ORIGIN |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_CREATE_FDMN_CODE |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_SURNAME_PREFIX |   | VARCHAR2(60) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
SPRIDEN_NTYP_CODE | GTVNTYP_CODE | GTVNTYP |
SPRIDEN_PIDM | GOBEACC_PIDM | GOBEACC |
SPRIDEN_PIDM | SFRSTCR_PIDM | SFRSTCR |
SPRIDEN_PIDM | SPBPERS_PIDM | SPBPERS |
SPRIDEN_PIDM | NBRBJOB_PIDM | NBRBJOB |
SPRIDEN_PIDM | SIBINST_PIDM | SIBINST |
SPRIDEN_PIDM | SHRTTRM_PIDM | SHRTTRM |
SPRIDEN_PIDM | SARADAP_PIDM | SARADAP |
SPRIDEN_PIDM | GLBEXTR_KEY | GLBEXTR |
SPRIDEN_PIDM | SHRDGMR_PIDM | SHRDGMR |
SPRIDEN_PIDM | RORSTAT_PIDM | RORSTAT |
SPRIDEN_PIDM | APRXREF_XREF_PIDM | APRXREF |
SPRIDEN_PIDM | SHBCOMI_PIDM | SHBCOMI |
SPRIDEN_PIDM | AFRCSLT_PIDM | AFRCSLT |
SPRIDEN_PIDM | APRCATG_PIDM | APRCATG |
SPRIDEN_PIDM | SIRASGN_PIDM | SIRASGN |
SPRIDEN_PIDM | APRCSPS_SPS_PIDM | APRCSPS |
SPRIDEN_PIDM | SGBSTDN_PIDM | SGBSTDN |
SPRIDEN_PIDM | PERJOBP_PIDM | PERJOBP |
SPRIDEN_PIDM | AFRCTYP_CONSTITUENT_PIDM | AFRCTYP |
SPRIDEN_PIDM | AMRINFO_PIDM | AMRINFO |
SPRIDEN_PIDM | SORHSCH_PIDM | SORHSCH |
SPRIDEN_PIDM | RERSTID_PIDM | RERSTID |
SPRIDEN_PIDM | AOBORGN_PIDM | AOBORGN |
SPRIDEN_PIDM | GOBSRVR_PIDM | GOBSRVR |
SPRIDEN_PIDM | APRDHIS_PIDM | APRDHIS |
SPRIDEN_PIDM | SLRRMAT_PIDM | SLRRMAT |
SPRIDEN_PIDM | SABSTUD_PIDM | SABSTUD |
SPRIDEN_PIDM | SGRASSI_PIDM | SGRASSI |
SPRIDEN_PIDM | SHTTRAN_PIDM | SHTTRAN |
SPRIDEN_PIDM | APBCONS_PIDM | APBCONS |
SPRIDEN_PIDM | ASRSSAG_PIDM | ASRSSAG |
SPRIDEN_PIDM | SABIDEN_PIDM | SABIDEN |
SPRIDEN_PIDM | SFRENRL_PIDM | SFRENRL |
SPRIDEN_PIDM | SHRGCOL_PIDM | SHRGCOL |
SPRIDEN_PIDM | SFBETRM_PIDM | SFBETRM |
SPRIDEN_PIDM | SRBRECR_PIDM | SRBRECR |
SPRIDEN_PIDM | PABAPPL_PIDM | PABAPPL |
SPRIDEN_PIDM | PEBEMPL_PIDM | PEBEMPL |
SPRIDEN_PIDM | SORPCOL_PIDM | SORPCOL |
SPRIDEN_PIDM | SPRHOLD_PIDM | SPRHOLD |
SPRIDEN_PIDM | RPRATRM_PIDM | RPRATRM |
SPRIDEN_PIDM | SHRCOMM_PIDM_MEMBER | SHRCOMM |
SPRIDEN_PIDM | RPRAWRD_PIDM | RPRAWRD |
SPRIDEN_PIDM | ASRSORG_PIDM | ASRSORG |
SPRIDEN_PIDM | SLRRASG_PIDM | SLRRASG |
SPRIDEN_PIDM | SMBSLIB_PIDM | SMBSLIB |
SPRIDEN_PIDM | APRCHLD_CHLD_PIDM | APRCHLD |
SPRIDEN_PIDM | APREHIS_EMPR_PIDM | APREHIS |
SPRIDEN_PIDM | PERBARG_PIDM | PERBARG |
SPRIDEN_PIDM | PARAPIN_PIDM | PARAPIN |
SPRIDEN_PIDM | SPRADDR_PIDM | SPRADDR |
SPRIDEN_PIDM | PDRBDED_PIDM | PDRBDED |
SPRIDEN_PIDM | SORAROL_PIDM | SORAROL |
SPRIDEN_PIDM | SERDTGL_PIDM | SERDTGL |
SPRIDEN_PIDM | SERDTND_PIDM | SERDTND |
SPRIDEN_PIDM | SERDTSR_PIDM | SERDTSR |
SPRIDEN_PIDM | SLBEVNT_AGENCY_PIDM | SLBEVNT |
SPRIDEN_PIDM | RORLOGM_PIDM | RORLOGM |
SPRIDEN_PIDM | RNRTMNT_PIDM | RNRTMNT |
SPRIDEN_PIDM | SHBHEAD_PIDM | SHBHEAD |
SPRIDEN_PIDM | SMRRQCM_ORIG_PIDM | SMRRQCM |
SPRIDEN_PIDM | SMRRQCM_PIDM | SMRRQCM |
SPRIDEN_PIDM | GORSVAS_ACT_SITE_PIDM | GORSVAS |
SPRIDEN_PIDM | GORSEVD_DEP_PIDM | GORSEVD |
SPRIDEN_PIDM | GORSVEI_EMPLOYER_PIDM | GORSVEI |
SPRIDEN_PIDM | GOBSEVS_PIDM | GOBSEVS |
SPRIDEN_PIDM | PERJOBS_COMMENT_PIDM | PERJOBS |
SPRIDEN_PIDM | PERJOBS_PIDM | PERJOBS |
SPRIDEN_PIDM | AGBMGID_EMPR_PIDM | AGBMGID |
SPRIDEN_PIDM | AGBMGID_EMPL_PIDM | AGBMGID |
SPRIDEN_PIDM | AORCONT_CONTACT_PIDM | AORCONT |
SPRIDEN_PIDM | SORAINF_PIDM | SORAINF |
SPRIDEN_PIDM | NBRJOBS_PIDM | NBRJOBS |
SPRIDEN_PIDM | GORSEVS_PIDM | GORSEVS |
SPRIDEN_PIDM | PDRBENE_BENE_PIDM | PDRBENE |
SPRIDEN_PIDM | APRCHIS_PIDM | APRCHIS |
SPRIDEN_PIDM | PERREVW_PIDM | PERREVW |
SPRIDEN_PIDM | GERATTD_PIDM | GERATTD |
SPRIDEN_PIDM | SGRADVR_ADVR_PIDM | SGRADVR |
SPRIDEN_PIDM | SGRADVR_PIDM | SGRADVR |
SPRIDEN_PIDM | FABINVH_VEND_CHECK_PIDM | FABINVH |
SPRIDEN_PIDM | FABINVH_VEND_PIDM | FABINVH |
SPRIDEN_PIDM | PERJOBH_COMMENT_PIDM | PERJOBH |
SPRIDEN_PIDM | PERTETH_TRANS_PIDM | PERTETH |
SPRIDEN_PIDM | PERROUT_ACTION_PIDM | PERROUT |
SPRIDEN_PIDM | PERROUT_APPR_PIDM | PERROUT |
SPRIDEN_PIDM | FTVVEND_PIDM | FTVVEND |
SPRIDEN_PIDM | GOBTPAC_PIDM | GOBTPAC |
SPRIDEN_PIDM | FRBGRNT_AGENCY_PIDM | FRBGRNT |
SPRIDEN_PIDM | AMRSTAF_PIDM | AMRSTAF |
SPRIDEN_PIDM | SHRMRKS_PIDM | SHRMRKS |
SPRIDEN_PIDM | SHRCMRK_PIDM | SHRCMRK |
SPRIDEN_PIDM | SHRSMRK_PIDM | SHRSMRK |
SPRIDEN_PIDM | NBREJOB_PIDM | NBREJOB |
SPRIDEN_PIDM | SHRNCRS_ADVR_PIDM | SHRNCRS |
SPRIDEN_PIDM | SHRTCKN_PIDM | SHRTCKN |
SPRIDEN_PIDM | NBTJOBF_EMPLOYEE_PIDM | NBTJOBF |
SPRIDEN_PIDM | RCRAPP1_PIDM | RCRAPP1 |
SPRIDEN_PIDM | RPRLAPP_LENDER_PIDM | RPRLAPP |
SPRIDEN_PIDM | SFRAREG_PIDM | SFRAREG |
SPRIDEN_PIDM | PERFJOB_PIDM | PERFJOB |
SPRIDEN_PIDM | AMRPLAN_PIDM | AMRPLAN |
SPRIDEN_PIDM | GORVISA_PIDM | GORVISA |
SPRIDEN_ID | SRTIDEN_ID | SRTIDEN |
SPRIDEN_PIDM | SRTIDEN_PIDM | SRTIDEN |
SPRIDEN_PIDM | PERFCNT_PIDM | PERFCNT |
SPRIDEN_PIDM | APRACYR_PIDM | APRACYR |
SPRIDEN_PIDM | SHTTRTC_PIDM | SHTTRTC |
SPRIDEN_PIDM | GOBUMAP_PIDM | GOBUMAP |
SPRIDEN_PIDM | AORJPST_EMPR_PIDM | AORJPST |
SPRIDEN_PIDM | FTVIMGR_IMGR_CODE_PIDM | FTVIMGR |
SPRIDEN_PIDM | APRCRVW_PIDM | APRCRVW |
SPRIDEN_PIDM | APRERVW_PIDM | APRERVW |
SPRIDEN_PIDM | APRSRVW_PIDM | APRSRVW |
SPRIDEN_PIDM | APRDRVW_PIDM | APRDRVW |
Index Name | Index Type | Column Name |
---|---|---|
SPRIDEN_INDEX_ID |   | SPRIDEN_ID |
SPRIDEN_INDEX_ID |   | SPRIDEN_ENTITY_IND |
SPRIDEN_INDEX_ID |   | SPRIDEN_CHANGE_IND |
SPRIDEN_INDEX_PERS |   | SPRIDEN_LAST_NAME |
SPRIDEN_INDEX_PERS |   | SPRIDEN_FIRST_NAME |
SPRIDEN_INDEX_PERS |   | SPRIDEN_MI |
SPRIDEN_INDEX_PERS |   | SPRIDEN_ENTITY_IND |
SPRIDEN_INDEX_PERS |   | SPRIDEN_CHANGE_IND |
SPRIDEN_INDEX_SEARCH |   | SPRIDEN_SEARCH_LAST_NAME |
SPRIDEN_INDEX_SEARCH |   | SPRIDEN_SEARCH_FIRST_NAME |
SPRIDEN_INDEX_SEARCH |   | SPRIDEN_SEARCH_MI |
SPRIDEN_INDEX_SOUNDEX |   | SPRIDEN_SOUNDEX_LAST_NAME |
SPRIDEN_INDEX_SOUNDEX |   | SPRIDEN_SOUNDEX_FIRST_NAME |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_PIDM |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_ID |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_LAST_NAME |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_FIRST_NAME |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_MI |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_CHANGE_IND |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_NTYP_CODE |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:48:43:000 | 04/02/2008 21:17:58:000 |
Column Name | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|
GLVEXTR_APPLICATION | VARCHAR2(30) | No |   |   |
GLVEXTR_SELECTION | VARCHAR2(30) | No |   |   |
GLVEXTR_CREATOR_ID | VARCHAR2(30) | No |   |   |
GLVEXTR_USER_ID | VARCHAR2(30) | No |   |   |
GLVEXTR_KEY | VARCHAR2(80) | No |   |   |
GLVEXTR_NAME | VARCHAR2(125) | Yes |   |   |
GLVEXTR_ID | VARCHAR2(9) | No |   |   |
GLVEXTR_SYS_IND | VARCHAR2(1) | No |   |   |
GLVEXTR_ACTIVITY_DATE | DATE | No |   |   |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GLVEXTR_REC | Oracle Package Variable | S10B80.BANINST1.BWGKSRVY | Rely On |
GLVEXTRREADC | Oracle Package Cursor | S10B80.BANINST1.BWGKSRVY | Use (select)Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GLBEXTR | SQL Table | S10B80.GENERAL | Use (select) |
SPRIDEN | SQL Table | S10B80.SATURN | Use (select) |
DATE | Oracle Package Type | S10B80.SYS.STANDARD | Rely On |
VARCHAR2 | Oracle Package Type | S10B80.SYS.STANDARD | Rely On |
GLBEXTR | Oracle Synonym | S10B80.PUBLIC | Use (select) |
SPRIDEN | Oracle Synonym | S10B80.PUBLIC | Use (select) |
DECODE | Oracle Package Function | S10B80.SYS.STANDARD | Call |
Creation Date | Analysis Date |
---|---|
04/04/2008 21:04:28:000 | 04/04/2008 21:57:35:000 |
Objects list |
---|
schema-view : S10B80.BANINST1.GLVEXTR
schema-view : S10B80.BANINST1.APVBRWS scope-procedure : S10B80.BANINST1.BWDKPSRC.P_BUILD_POP_SEL_IDS_RESULTS |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRIDEN and GLBEXTR | SATURN |
Link type | Between | And |
---|---|---|
Join | SPRIDEN | GLBEXTR |
Objects list |
---|
schema-view : S10B80.BANINST1.GOVSRVR |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRIDEN and GOBSRVR | SATURN |
Link type | Between | And |
---|---|---|
Join | SPRIDEN | GOBSRVR |
Link Type | Link | Project |
---|---|---|
Use (select) | Link Between GLVEXTR and SPRIDEN | BANINST1 |
Link type | Between | And |
---|---|---|
Use (select) | GLVEXTR | SPRIDEN |
Link Type | Link | Project |
---|---|---|
Use (select) | Link Between GLVEXTR and GLBEXTR | BANINST1 |
Link type | Between | And |
---|---|---|
Use (select) | GLVEXTR | GLBEXTR |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GORSRVR and GOBSRVR (FK1_GORSRVR_INV_GOBSRVR_KEY) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GORSRVR | GORSRVR_PIDM | GOBSRVR_PIDM | GOBSRVR | (1,1)-(0,n) |
GORSRVR | GORSRVR_NAME | GOBSRVR_NAME | GOBSRVR | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GURSRVQ and GUBSRVY (FK1_GURSRVQ_INV_GUBSRVY_KEY) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GURSRVQ | GURSRVQ_NAME | GUBSRVY_NAME | GUBSRVY | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GURSVRL and GUBSRVY (FK1_GURSVRL_INV_GUBSRVY_KEY) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GURSVRL | GURSVRL_NAME | GUBSRVY_NAME | GUBSRVY | (1,1)-(0,n) |