Model Multi-Visa
Object Name | Object Type | Layer Name |
---|---|---|
GOBINTL | SQL Table | Default |
GORDOCM | SQL Table | Default |
GORVISA | SQL Table | Default |
GTVCELG | SQL Table | Default |
GTVDOCM | SQL Table | Default |
GTVSRCE | SQL Table | Default |
GTVVISS | SQL Table | Default |
SARADAP | SQL Table | Default |
SARCHKL | SQL Table | Default |
SPRIDEN | SQL Table | Default |
STVADMR | SQL Table | Default |
STVEMPT | SQL Table | Default |
STVLANG | SQL Table | Default |
STVNATN | SQL Table | Default |
STVPENT | SQL Table | Default |
STVSPON | SQL Table | Default |
STVVTYP | SQL Table | Default |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GOBINTL_PIDM |   | NUMBER(8,0) | No | * | * |
GOBINTL_SPOUSE_IND |   | VARCHAR2(1) | No |   |   |
GOBINTL_SIGNATURE_IND |   | VARCHAR2(1) | No |   |   |
GOBINTL_USER_ID |   | VARCHAR2(30) | No |   |   |
GOBINTL_ACTIVITY_DATE |   | DATE | No |   |   |
GOBINTL_PASSPORT_ID |   | VARCHAR2(25) | Yes |   |   |
GOBINTL_NATN_CODE_ISSUE |   | VARCHAR2(5) | Yes |   | * |
GOBINTL_PASSPORT_EXP_DATE |   | DATE | Yes |   |   |
GOBINTL_I94_STATUS |   | VARCHAR2(3) | Yes |   |   |
GOBINTL_I94_DATE |   | DATE | Yes |   |   |
GOBINTL_REG_NUMBER |   | VARCHAR2(11) | Yes |   |   |
GOBINTL_DURATION |   | VARCHAR2(1) | Yes |   |   |
GOBINTL_CELG_CODE |   | VARCHAR2(6) | Yes |   | * |
GOBINTL_CERT_NUMBER |   | VARCHAR2(11) | Yes |   |   |
GOBINTL_CERT_DATE_ISSUE |   | DATE | Yes |   |   |
GOBINTL_CERT_DATE_RECEIPT |   | DATE | Yes |   |   |
GOBINTL_ADMR_CODE |   | VARCHAR2(4) | Yes |   | * |
GOBINTL_NATN_CODE_BIRTH |   | VARCHAR2(5) | Yes |   | * |
GOBINTL_NATN_CODE_LEGAL |   | VARCHAR2(5) | Yes |   | * |
GOBINTL_LANG_CODE |   | VARCHAR2(3) | Yes |   | * |
GOBINTL_SPON_CODE |   | VARCHAR2(3) | Yes |   | * |
GOBINTL_EMPT_CODE |   | VARCHAR2(3) | Yes |   | * |
GOBINTL_FOREIGN_SSN |   | VARCHAR2(15) | Yes |   |   |
GOBINTL_CHILD_NUMBER |   | NUMBER(2,0) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GOBINTL_NATN_CODE_ISSUE | STVNATN_CODE | STVNATN |
GOBINTL_NATN_CODE_BIRTH | STVNATN_CODE | STVNATN |
GOBINTL_NATN_CODE_LEGAL | STVNATN_CODE | STVNATN |
GOBINTL_CELG_CODE | GTVCELG_CODE | GTVCELG |
GOBINTL_EMPT_CODE | STVEMPT_CODE | STVEMPT |
GOBINTL_LANG_CODE | STVLANG_CODE | STVLANG |
GOBINTL_ADMR_CODE | STVADMR_CODE | STVADMR |
GOBINTL_SPON_CODE | STVSPON_CODE | STVSPON |
GOBINTL_PIDM | PEBEMPL_PIDM | PEBEMPL |
GOBINTL_PIDM | GORVISA_PIDM | GORVISA |
GOBINTL_PIDM | SARCHKL_PIDM | SARCHKL |
GOBINTL_ADMR_CODE | SARCHKL_ADMR_CODE | SARCHKL |
Index Name | Index Type | Column Name |
---|---|---|
PK_GOBINTL | Unique | GOBINTL_PIDM |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GOBINTL | SQL Index | S10B80.GENERAL | Rely On |
GORVISA | SQL Table | S10B80.GENERAL | Join |
GTVCELG | SQL Table | S10B80.GENERAL | Refer (no action) |
PEBEMPL | SQL Table | S10B80.PAYROLL | Join |
SARCHKL | SQL Table | S10B80.SATURN | Join |
STVADMR | SQL Table | S10B80.SATURN | Refer (no action) |
STVEMPT | SQL Table | S10B80.SATURN | Refer (no action) |
STVLANG | SQL Table | S10B80.SATURN | Refer (no action) |
STVNATN | SQL Table | S10B80.SATURN | Refer (no action) |
STVSPON | SQL Table | S10B80.SATURN | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:28:22:000 | 04/02/2008 21:17:51:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GORDOCM_PIDM |   | NUMBER(8,0) | No | * | * |
GORDOCM_SEQ_NO |   | NUMBER(3,0) | No | * | * |
GORDOCM_VTYP_CODE |   | VARCHAR2(2) | No | * | * |
GORDOCM_VISA_NUMBER |   | VARCHAR2(18) | Yes |   |   |
GORDOCM_DOCM_CODE |   | VARCHAR2(6) | No | * | * |
GORDOCM_DISPOSITION |   | VARCHAR2(1) | No |   |   |
GORDOCM_USER_ID |   | VARCHAR2(30) | No |   |   |
GORDOCM_ACTIVITY_DATE |   | DATE | No |   |   |
GORDOCM_SRCE_CODE |   | VARCHAR2(6) | Yes |   | * |
GORDOCM_REQUEST_DATE |   | DATE | Yes |   |   |
GORDOCM_RECEIVED_DATE |   | DATE | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GORDOCM_PIDM | GORVISA_PIDM | GORVISA |
GORDOCM_SEQ_NO | GORVISA_SEQ_NO | GORVISA |
GORDOCM_VTYP_CODE | GORVISA_VTYP_CODE | GORVISA |
GORDOCM_DOCM_CODE | GTVDOCM_CODE | GTVDOCM |
GORDOCM_SRCE_CODE | GTVSRCE_CODE | GTVSRCE |
GORDOCM_VTYP_CODE | STVVTYP_CODE | STVVTYP |
Index Name | Index Type | Column Name |
---|---|---|
PK_GORDOCM | Unique | GORDOCM_PIDM |
PK_GORDOCM | Unique | GORDOCM_SEQ_NO |
PK_GORDOCM | Unique | GORDOCM_VTYP_CODE |
PK_GORDOCM | Unique | GORDOCM_DOCM_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
P_DELETE | Oracle Package Procedure | S10B80.BANINST1.GB_VISA | Use (select) |
P_GORDOCM_DELETE_ROW | Oracle Package Procedure | S10B80.BANINST1.GOKINTL | Rely On |
P_GORDOCM_DELETE_ROW | Oracle Package Procedure | S10B80.BANINST1.GOKINTL | Use (delete) |
P_GORDOCM_INSERT | Oracle Package Procedure | S10B80.BANINST1.GOKINTL | Rely On |
P_GORDOCM_INSERT | Oracle Package Procedure | S10B80.BANINST1.GOKINTL | Use (Insert) |
P_GORDOCM_UPDATE_ROW | Oracle Package Procedure | S10B80.BANINST1.GOKINTL | Rely On |
P_GORDOCM_UPDATE_ROW | Oracle Package Procedure | S10B80.BANINST1.GOKINTL | Use (update) |
P_UPDATE | Oracle Package Procedure | S10B80.BANINST1.GB_VISA | Use (update) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_VISA | Use (Insert) |
F_GORDOCM_SELECT | Oracle Package Function | S10B80.BANINST1.GOKINTL | Rely On |
F_GORDOCM_SELECT | Oracle Package Function | S10B80.BANINST1.GOKINTL | Use (select)Rely On |
GORDOCM | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GORDOCM | SQL Index | S10B80.GENERAL | Rely On |
GORVISA | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVDOCM | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVSRCE | SQL Table | S10B80.GENERAL | Refer (no action) |
STVVTYP | SQL Table | S10B80.SATURN | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:32:11:000 | 04/02/2008 21:17:56:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GORVISA_PIDM |   | NUMBER(8,0) | No | * | * |
GORVISA_SEQ_NO |   | NUMBER(3,0) | No | * |   |
GORVISA_VTYP_CODE |   | VARCHAR2(2) | No | * | * |
GORVISA_VISA_NUMBER |   | VARCHAR2(18) | Yes |   |   |
GORVISA_NATN_CODE_ISSUE |   | VARCHAR2(5) | Yes |   | * |
GORVISA_VISS_CODE |   | VARCHAR2(6) | Yes |   | * |
GORVISA_VISA_START_DATE |   | DATE | Yes |   |   |
GORVISA_VISA_EXPIRE_DATE |   | DATE | Yes |   |   |
GORVISA_ENTRY_IND |   | VARCHAR2(1) | No |   |   |
GORVISA_USER_ID |   | VARCHAR2(30) | No |   |   |
GORVISA_ACTIVITY_DATE |   | DATE | No |   |   |
GORVISA_VISA_REQ_DATE |   | DATE | Yes |   |   |
GORVISA_VISA_ISSUE_DATE |   | DATE | Yes |   |   |
GORVISA_PENT_CODE |   | VARCHAR2(3) | Yes |   | * |
GORVISA_NO_ENTRIES |   | VARCHAR2(2) | Yes |   |   |
GORVISA_DATA_ORIGIN |   | VARCHAR2(30) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
GORVISA_NATN_CODE_ISSUE | STVNATN_CODE | STVNATN |
GORVISA_VISS_CODE | GTVVISS_CODE | GTVVISS |
GORVISA_PENT_CODE | STVPENT_CODE | STVPENT |
GORVISA_VTYP_CODE | STVVTYP_CODE | STVVTYP |
GORVISA_PIDM | SARADAP_PIDM | SARADAP |
GORVISA_PIDM | PEBEMPL_PIDM | PEBEMPL |
Index Name | Index Type | Column Name |
---|---|---|
PK_GORVISA | Unique | GORVISA_PIDM |
PK_GORVISA | Unique | GORVISA_SEQ_NO |
PK_GORVISA | Unique | GORVISA_VTYP_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GORVISA | SQL Index | S10B80.GENERAL | Rely On |
GTVVISS | SQL Table | S10B80.GENERAL | Refer (no action) |
PEBEMPL | SQL Table | S10B80.PAYROLL | Join |
SARADAP | SQL Table | S10B80.SATURN | Join |
STVNATN | SQL Table | S10B80.SATURN | Refer (no action) |
STVPENT | SQL Table | S10B80.SATURN | Refer (no action) |
STVVTYP | SQL Table | S10B80.SATURN | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:28:00:000 | 04/02/2008 21:17:51:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GTVCELG_CODE |   | VARCHAR2(6) | No | * |   |
GTVCELG_DESC |   | VARCHAR2(30) | No |   |   |
GTVCELG_USER_ID |   | VARCHAR2(30) | No |   |   |
GTVCELG_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_GTVCELG | Unique | GTVCELG_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GOBINTL | SQL Table | S10B80.GENERAL | Refer (no action) |
GORSDAV | SQL Table | S10B80.GENERAL | Join |
GTVCELG_ADD | SQL View | S10B80.BANINST1 | Use (select) |
GTVCELG_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVCELG | Rely On |
GTVCELG_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVCELG | Use (select)Rely On |
F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_GTVCELG | Rely On |
F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_GTVCELG | Rely On |
GTVCELG | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GTVCELG | SQL Index | S10B80.GENERAL | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:30:35:000 | 04/02/2008 21:17:54:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GTVDOCM_CODE |   | VARCHAR2(6) | No | * |   |
GTVDOCM_DESC |   | VARCHAR2(30) | No |   |   |
GTVDOCM_USER_ID |   | VARCHAR2(30) | No |   |   |
GTVDOCM_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_GTVDOCM | Unique | GTVDOCM_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GORDOCM | SQL Table | S10B80.GENERAL | Refer (no action) |
GORSDAV | SQL Table | S10B80.GENERAL | Join |
GTVDOCM_ADD | SQL View | S10B80.BANINST1 | Use (select) |
GTVDOCM_ADS | SQL View | S10B80.BANINST1 | Use (select) |
GTVDOCM_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVDOCM | Rely On |
GTVDOCM_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVDOCM | Use (select)Rely On |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_VISA | Use (Insert) |
F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_GTVDOCM | Rely On |
F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_GTVDOCM | Rely On |
GTVDOCM | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GTVDOCM | SQL Index | S10B80.GENERAL | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:28:40:000 | 04/02/2008 21:17:52:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GTVSRCE_CODE |   | VARCHAR2(6) | No | * |   |
GTVSRCE_DESC |   | VARCHAR2(30) | No |   |   |
GTVSRCE_USER_ID |   | VARCHAR2(30) | No |   |   |
GTVSRCE_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_GTVSRCE | Unique | GTVSRCE_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GORDOCM | SQL Table | S10B80.GENERAL | Refer (no action) |
GORSDAV | SQL Table | S10B80.GENERAL | Join |
GTVSRCE_ADD | SQL View | S10B80.BANINST1 | Use (select) |
GTVSRCE_ADS | SQL View | S10B80.BANINST1 | Use (select) |
GTVSRCE_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSRCE | Rely On |
GTVSRCE_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSRCE | Use (select)Rely On |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_ADDRESS | Use (select) |
F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_GTVSRCE | Rely On |
F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_GTVSRCE | Rely On |
GTVSRCE | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GTVSRCE | SQL Index | S10B80.GENERAL | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:29:55:000 | 04/02/2008 21:17:53:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
GTVVISS_CODE |   | VARCHAR2(6) | No | * |   |
GTVVISS_DESC |   | VARCHAR2(30) | No |   |   |
GTVVISS_USER_ID |   | VARCHAR2(30) | No |   |   |
GTVVISS_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_GTVVISS | Unique | GTVVISS_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GORSDAV | SQL Table | S10B80.GENERAL | Join |
GORVISA | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVVISS_ADD | SQL View | S10B80.BANINST1 | Use (select) |
GTVVISS_ADS | SQL View | S10B80.BANINST1 | Use (select) |
GTVVISS_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVVISS | Rely On |
GTVVISS_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVVISS | Use (select)Rely On |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_VISA | Use (Insert) |
F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_GTVVISS | Rely On |
F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_GTVVISS | Rely On |
GTVVISS | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_GTVVISS | SQL Index | S10B80.GENERAL | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:30:00:000 | 04/02/2008 21:17:53:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
SARADAP_PIDM |   | NUMBER(8,0) | No | * | * |
SARADAP_TERM_CODE_ENTRY |   | VARCHAR2(6) | No | * | * |
SARADAP_APPL_NO |   | NUMBER(2,0) | No | * | * |
SARADAP_LEVL_CODE |   | VARCHAR2(2) | Yes |   | * |
SARADAP_APPL_DATE |   | DATE | No |   |   |
SARADAP_APST_CODE |   | VARCHAR2(1) | No |   | * |
SARADAP_APST_DATE |   | DATE | No |   |   |
SARADAP_MAINT_IND |   | VARCHAR2(1) | No |   |   |
SARADAP_ADMT_CODE |   | VARCHAR2(2) | Yes |   | * |
SARADAP_STYP_CODE |   | VARCHAR2(1) | No |   | * |
SARADAP_CAMP_CODE |   | VARCHAR2(3) | Yes |   | * |
SARADAP_SITE_CODE |   | VARCHAR2(3) | Yes |   | * |
SARADAP_COLL_CODE_1 |   | VARCHAR2(2) | Yes |   | * |
SARADAP_DEGC_CODE_1 |   | VARCHAR2(6) | Yes |   | * |
SARADAP_MAJR_CODE_1 |   | VARCHAR2(4) | Yes |   | * |
SARADAP_COLL_CODE_2 |   | VARCHAR2(2) | Yes |   | * |
SARADAP_DEGC_CODE_2 |   | VARCHAR2(6) | Yes |   | * |
SARADAP_MAJR_CODE_2 |   | VARCHAR2(4) | Yes |   | * |
SARADAP_RESD_CODE |   | VARCHAR2(1) | No |   | * |
SARADAP_FULL_PART_IND |   | VARCHAR2(1) | Yes |   | * |
SARADAP_SESS_CODE |   | VARCHAR2(1) | Yes |   | * |
SARADAP_WRSN_CODE |   | VARCHAR2(2) | Yes |   | * |
SARADAP_INTV_CODE |   | VARCHAR2(1) | Yes |   | * |
SARADAP_FEE_IND |   | VARCHAR2(1) | Yes |   |   |
SARADAP_FEE_DATE |   | DATE | Yes |   |   |
SARADAP_ACTIVITY_DATE |   | DATE | No |   |   |
SARADAP_RATE_CODE |   | VARCHAR2(5) | Yes |   | * |
SARADAP_EGOL_CODE |   | VARCHAR2(2) | Yes |   | * |
SARADAP_EDLV_CODE |   | VARCHAR2(3) | Yes |   | * |
SARADAP_MAJR_CODE_CONC_1 |   | VARCHAR2(4) | Yes |   | * |
SARADAP_DEPT_CODE |   | VARCHAR2(4) | Yes |   | * |
SARADAP_SBGI_CODE |   | VARCHAR2(6) | Yes |   | * |
SARADAP_RECR_CODE |   | VARCHAR2(3) | Yes |   | * |
SARADAP_RTYP_CODE |   | VARCHAR2(2) | Yes |   | * |
SARADAP_DEPT_CODE_2 |   | VARCHAR2(4) | Yes |   | * |
SARADAP_MAJR_CODE_CONC_2 |   | VARCHAR2(4) | Yes |   | * |
SARADAP_PROGRAM_1 |   | VARCHAR2(12) | Yes |   | * |
SARADAP_TERM_CODE_CTLG_1 |   | VARCHAR2(6) | Yes |   | * |
SARADAP_MAJR_CODE_1_2 |   | VARCHAR2(4) | Yes |   | * |
SARADAP_DEPT_CODE_1_2 |   | VARCHAR2(4) | Yes |   | * |
SARADAP_MAJR_CODE_CONC_1_2 |   | VARCHAR2(4) | Yes |   | * |
SARADAP_MAJR_CODE_CONC_1_3 |   | VARCHAR2(4) | Yes |   | * |
SARADAP_MAJR_CODE_CONC_121 |   | VARCHAR2(4) | Yes |   | * |
SARADAP_MAJR_CODE_CONC_122 |   | VARCHAR2(4) | Yes |   | * |
SARADAP_MAJR_CODE_CONC_123 |   | VARCHAR2(4) | Yes |   | * |
SARADAP_MAJR_CODE_MINR_1_1 |   | VARCHAR2(4) | Yes |   | * |
SARADAP_MAJR_CODE_MINR_1_2 |   | VARCHAR2(4) | Yes |   | * |
SARADAP_PROGRAM_2 |   | VARCHAR2(12) | Yes |   | * |
SARADAP_TERM_CODE_CTLG_2 |   | VARCHAR2(6) | Yes |   | * |
SARADAP_LEVL_CODE_2 |   | VARCHAR2(2) | Yes |   | * |
SARADAP_CAMP_CODE_2 |   | VARCHAR2(3) | Yes |   | * |
SARADAP_MAJR_CODE_2_2 |   | VARCHAR2(4) | Yes |   | * |
SARADAP_DEPT_CODE_2_2 |   | VARCHAR2(4) | Yes |   | * |
SARADAP_MAJR_CODE_CONC_211 |   | VARCHAR2(4) | Yes |   | * |
SARADAP_MAJR_CODE_CONC_212 |   | VARCHAR2(4) | Yes |   | * |
SARADAP_MAJR_CODE_CONC_213 |   | VARCHAR2(4) | Yes |   | * |
SARADAP_MAJR_CODE_CONC_221 |   | VARCHAR2(4) | Yes |   | * |
SARADAP_MAJR_CODE_CONC_222 |   | VARCHAR2(4) | Yes |   | * |
SARADAP_MAJR_CODE_CONC_223 |   | VARCHAR2(4) | Yes |   | * |
SARADAP_MAJR_CODE_MINR_2_1 |   | VARCHAR2(4) | Yes |   | * |
SARADAP_MAJR_CODE_MINR_2_2 |   | VARCHAR2(4) | Yes |   | * |
SARADAP_CURR_RULE_1 |   | NUMBER(8,0) | Yes |   | * |
SARADAP_CMJR_RULE_1_1 |   | NUMBER(8,0) | Yes |   | * |
SARADAP_CCON_RULE_11_1 |   | NUMBER(8,0) | Yes |   | * |
SARADAP_CCON_RULE_11_2 |   | NUMBER(8,0) | Yes |   | * |
SARADAP_CCON_RULE_11_3 |   | NUMBER(8,0) | Yes |   | * |
SARADAP_CMJR_RULE_1_2 |   | NUMBER(8,0) | Yes |   | * |
SARADAP_CCON_RULE_12_1 |   | NUMBER(8,0) | Yes |   | * |
SARADAP_CCON_RULE_12_2 |   | NUMBER(8,0) | Yes |   | * |
SARADAP_CCON_RULE_12_3 |   | NUMBER(8,0) | Yes |   | * |
SARADAP_CMNR_RULE_1_1 |   | NUMBER(8,0) | Yes |   | * |
SARADAP_CMNR_RULE_1_2 |   | NUMBER(8,0) | Yes |   | * |
SARADAP_CURR_RULE_2 |   | NUMBER(8,0) | Yes |   | * |
SARADAP_CMJR_RULE_2_1 |   | NUMBER(8,0) | Yes |   | * |
SARADAP_CCON_RULE_21_1 |   | NUMBER(8,0) | Yes |   | * |
SARADAP_CCON_RULE_21_2 |   | NUMBER(8,0) | Yes |   | * |
SARADAP_CCON_RULE_21_3 |   | NUMBER(8,0) | Yes |   | * |
SARADAP_CMJR_RULE_2_2 |   | NUMBER(8,0) | Yes |   | * |
SARADAP_CCON_RULE_22_1 |   | NUMBER(8,0) | Yes |   | * |
SARADAP_CCON_RULE_22_2 |   | NUMBER(8,0) | Yes |   | * |
SARADAP_CCON_RULE_22_3 |   | NUMBER(8,0) | Yes |   | * |
SARADAP_CMNR_RULE_2_1 |   | NUMBER(8,0) | Yes |   | * |
SARADAP_CMNR_RULE_2_2 |   | NUMBER(8,0) | Yes |   | * |
SARADAP_WEB_ACCT_MISC_IND |   | VARCHAR2(1) | Yes |   |   |
SARADAP_WEB_CASHIER_USER |   | VARCHAR2(30) | Yes |   |   |
SARADAP_WEB_TRANS_NO |   | NUMBER(8,0) | Yes |   |   |
SARADAP_WEB_AMOUNT |   | NUMBER(12,2) | Yes |   |   |
SARADAP_WEB_RECEIPT_NUMBER |   | NUMBER(8,0) | Yes |   |   |
SARADAP_WAIV_CODE |   | VARCHAR2(4) | Yes |   | * |
SARADAP_DATA_ORIGIN |   | VARCHAR2(30) | Yes |   |   |
SARADAP_USER_ID |   | VARCHAR2(30) | Yes |   |   |
SARADAP_APPL_PREFERENCE |   | NUMBER(2,0) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
SARADAP_SITE_CODE | STVSITE_CODE | STVSITE |
SARADAP_RECR_CODE | STVRECR_CODE | STVRECR |
SARADAP_SBGI_CODE | STVSBGI_CODE | STVSBGI |
SARADAP_CCON_RULE_22_1 | SORCCON_CCON_RULE | SORCCON |
SARADAP_CCON_RULE_22_2 | SORCCON_CCON_RULE | SORCCON |
SARADAP_CCON_RULE_22_3 | SORCCON_CCON_RULE | SORCCON |
SARADAP_CCON_RULE_11_1 | SORCCON_CCON_RULE | SORCCON |
SARADAP_CCON_RULE_11_2 | SORCCON_CCON_RULE | SORCCON |
SARADAP_CCON_RULE_11_3 | SORCCON_CCON_RULE | SORCCON |
SARADAP_CCON_RULE_12_1 | SORCCON_CCON_RULE | SORCCON |
SARADAP_CCON_RULE_12_2 | SORCCON_CCON_RULE | SORCCON |
SARADAP_CCON_RULE_12_3 | SORCCON_CCON_RULE | SORCCON |
SARADAP_CCON_RULE_21_1 | SORCCON_CCON_RULE | SORCCON |
SARADAP_CCON_RULE_21_2 | SORCCON_CCON_RULE | SORCCON |
SARADAP_CCON_RULE_21_3 | SORCCON_CCON_RULE | SORCCON |
SARADAP_MAJR_CODE_MINR_1_2 | STVMAJR_CODE | STVMAJR |
SARADAP_MAJR_CODE_2_2 | STVMAJR_CODE | STVMAJR |
SARADAP_MAJR_CODE_CONC_1_3 | STVMAJR_CODE | STVMAJR |
SARADAP_MAJR_CODE_CONC_221 | STVMAJR_CODE | STVMAJR |
SARADAP_MAJR_CODE_CONC_222 | STVMAJR_CODE | STVMAJR |
SARADAP_MAJR_CODE_CONC_223 | STVMAJR_CODE | STVMAJR |
SARADAP_MAJR_CODE_MINR_1_1 | STVMAJR_CODE | STVMAJR |
SARADAP_MAJR_CODE_CONC_213 | STVMAJR_CODE | STVMAJR |
SARADAP_MAJR_CODE_MINR_2_1 | STVMAJR_CODE | STVMAJR |
SARADAP_MAJR_CODE_CONC_212 | STVMAJR_CODE | STVMAJR |
SARADAP_MAJR_CODE_1 | STVMAJR_CODE | STVMAJR |
SARADAP_MAJR_CODE_MINR_2_2 | STVMAJR_CODE | STVMAJR |
SARADAP_MAJR_CODE_CONC_211 | STVMAJR_CODE | STVMAJR |
SARADAP_MAJR_CODE_2 | STVMAJR_CODE | STVMAJR |
SARADAP_MAJR_CODE_CONC_1 | STVMAJR_CODE | STVMAJR |
SARADAP_MAJR_CODE_CONC_2 | STVMAJR_CODE | STVMAJR |
SARADAP_MAJR_CODE_1_2 | STVMAJR_CODE | STVMAJR |
SARADAP_MAJR_CODE_CONC_1_2 | STVMAJR_CODE | STVMAJR |
SARADAP_MAJR_CODE_CONC_121 | STVMAJR_CODE | STVMAJR |
SARADAP_MAJR_CODE_CONC_122 | STVMAJR_CODE | STVMAJR |
SARADAP_MAJR_CODE_CONC_123 | STVMAJR_CODE | STVMAJR |
SARADAP_PROGRAM_1 | SMRPRLE_PROGRAM | SMRPRLE |
SARADAP_PROGRAM_2 | SMRPRLE_PROGRAM | SMRPRLE |
SARADAP_CURR_RULE_1 | SOBCURR_CURR_RULE | SOBCURR |
SARADAP_CURR_RULE_2 | SOBCURR_CURR_RULE | SOBCURR |
SARADAP_CMJR_RULE_1_1 | SORCMJR_CMJR_RULE | SORCMJR |
SARADAP_CMJR_RULE_1_2 | SORCMJR_CMJR_RULE | SORCMJR |
SARADAP_CMJR_RULE_2_1 | SORCMJR_CMJR_RULE | SORCMJR |
SARADAP_CMJR_RULE_2_2 | SORCMJR_CMJR_RULE | SORCMJR |
SARADAP_CMNR_RULE_1_1 | SORCMNR_CMNR_RULE | SORCMNR |
SARADAP_CMNR_RULE_1_2 | SORCMNR_CMNR_RULE | SORCMNR |
SARADAP_CMNR_RULE_2_1 | SORCMNR_CMNR_RULE | SORCMNR |
SARADAP_CMNR_RULE_2_2 | SORCMNR_CMNR_RULE | SORCMNR |
SARADAP_ADMT_CODE | STVADMT_CODE | STVADMT |
SARADAP_APST_CODE | STVAPST_CODE | STVAPST |
SARADAP_CAMP_CODE | STVCAMP_CODE | STVCAMP |
SARADAP_CAMP_CODE_2 | STVCAMP_CODE | STVCAMP |
SARADAP_COLL_CODE_1 | STVCOLL_CODE | STVCOLL |
SARADAP_COLL_CODE_2 | STVCOLL_CODE | STVCOLL |
SARADAP_DEGC_CODE_1 | STVDEGC_CODE | STVDEGC |
SARADAP_DEGC_CODE_2 | STVDEGC_CODE | STVDEGC |
SARADAP_DEPT_CODE | STVDEPT_CODE | STVDEPT |
SARADAP_DEPT_CODE_2 | STVDEPT_CODE | STVDEPT |
SARADAP_DEPT_CODE_1_2 | STVDEPT_CODE | STVDEPT |
SARADAP_DEPT_CODE_2_2 | STVDEPT_CODE | STVDEPT |
SARADAP_EDLV_CODE | STVEDLV_CODE | STVEDLV |
SARADAP_EGOL_CODE | STVEGOL_CODE | STVEGOL |
SARADAP_INTV_CODE | STVINTV_CODE | STVINTV |
SARADAP_LEVL_CODE | STVLEVL_CODE | STVLEVL |
SARADAP_LEVL_CODE_2 | STVLEVL_CODE | STVLEVL |
SARADAP_RATE_CODE | STVRATE_CODE | STVRATE |
SARADAP_RESD_CODE | STVRESD_CODE | STVRESD |
SARADAP_RTYP_CODE | STVRTYP_CODE | STVRTYP |
SARADAP_SESS_CODE | STVSESS_CODE | STVSESS |
SARADAP_STYP_CODE | STVSTYP_CODE | STVSTYP |
SARADAP_TERM_CODE_ENTRY | STVTERM_CODE | STVTERM |
SARADAP_TERM_CODE_CTLG_1 | STVTERM_CODE | STVTERM |
SARADAP_TERM_CODE_CTLG_2 | STVTERM_CODE | STVTERM |
SARADAP_WAIV_CODE | STVWAIV_CODE | STVWAIV |
SARADAP_WRSN_CODE | STVWRSN_CODE | STVWRSN |
SARADAP_TERM_CODE_ENTRY | SORLCUR_TERM_CODE | SORLCUR |
SARADAP_APPL_NO | SORLCUR_KEY_SEQNO | SORLCUR |
SARADAP_PIDM | SORLCUR_PIDM | SORLCUR |
SARADAP_RESD_CODE | SARDCSN_RESD_CODE | SARDCSN |
SARADAP_ADMT_CODE | SARDCSN_ADMT_CODE | SARDCSN |
SARADAP_STYP_CODE | SARDCSN_STYP_CODE | SARDCSN |
SARADAP_SESS_CODE | SARDCSN_SESS_CODE | SARDCSN |
SARADAP_FULL_PART_IND | SARDCSN_FULL_PART_IND | SARDCSN |
SARADAP_TERM_CODE_ENTRY | SARDCSN_TERM_CODE | SARDCSN |
SARADAP_TERM_CODE_ENTRY | SABVWID_TERM_CODE | SABVWID |
SARADAP_APPL_NO | SABVWID_APPL_NO | SABVWID |
SARADAP_PIDM | SABVWID_PIDM | SABVWID |
SARADAP_PIDM | SORHSCH_PIDM | SORHSCH |
SARADAP_PIDM | SRBRECR_PIDM | SRBRECR |
SARADAP_TERM_CODE_ENTRY | SRBRECR_TERM_CODE | SRBRECR |
Index Name | Index Type | Column Name |
---|---|---|
PK_SARADAP | Unique | SARADAP_PIDM |
PK_SARADAP | Unique | SARADAP_TERM_CODE_ENTRY |
PK_SARADAP | Unique | SARADAP_APPL_NO |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_SARADAP | SQL Index | S10B80.SATURN | Rely On |
SABVWID | SQL Table | S10B80.SATURN | Join |
SARDCSN | SQL Table | S10B80.SATURN | Join |
SMRPRLE | SQL Table | S10B80.SATURN | Refer (no action) |
SOBCURR | SQL Table | S10B80.SATURN | Refer (no action) |
SORCCON | SQL Table | S10B80.SATURN | Refer (no action) |
SORCMJR | SQL Table | S10B80.SATURN | Refer (no action) |
SORCMNR | SQL Table | S10B80.SATURN | Refer (no action) |
SORHSCH | SQL Table | S10B80.SATURN | Join |
SORLCUR | SQL Table | S10B80.SATURN | Join |
SRBRECR | SQL Table | S10B80.SATURN | Join |
STVADMT | SQL Table | S10B80.SATURN | Refer (no action) |
STVAPST | SQL Table | S10B80.SATURN | Refer (no action) |
STVCAMP | SQL Table | S10B80.SATURN | Refer (no action) |
STVCOLL | SQL Table | S10B80.SATURN | Refer (no action) |
STVDEGC | SQL Table | S10B80.SATURN | Refer (no action) |
STVDEPT | SQL Table | S10B80.SATURN | Refer (no action) |
STVEDLV | SQL Table | S10B80.SATURN | Refer (no action) |
STVEGOL | SQL Table | S10B80.SATURN | Refer (no action) |
STVINTV | SQL Table | S10B80.SATURN | Refer (no action) |
STVLEVL | SQL Table | S10B80.SATURN | Refer (no action) |
STVMAJR | SQL Table | S10B80.SATURN | Refer (no action) |
STVRATE | SQL Table | S10B80.SATURN | Refer (no action) |
STVRECR | SQL Table | S10B80.SATURN | Refer (no action) |
STVRESD | SQL Table | S10B80.SATURN | Refer (no action) |
STVRTYP | SQL Table | S10B80.SATURN | Refer (no action) |
STVSBGI | SQL Table | S10B80.SATURN | Refer (no action) |
STVSESS | SQL Table | S10B80.SATURN | Refer (no action) |
STVSITE | SQL Table | S10B80.SATURN | Refer (no action) |
STVSTYP | SQL Table | S10B80.SATURN | Refer (no action) |
STVTERM | SQL Table | S10B80.SATURN | Refer (no action) |
STVWAIV | SQL Table | S10B80.SATURN | Refer (no action) |
STVWRSN | SQL Table | S10B80.SATURN | Refer (no action) |
ST_ICAIR_APPLICATION_RECEIVED | SQL Trigger | S10B80.SATURN | Fire (Insert,after,each row) |
ST_SARADAP_AR_LDI | SQL Trigger | S10B80.SATURN | Fire (Insert,update,delete,after,each row) |
ST_SARADAP_AS_LDI | SQL Trigger | S10B80.SATURN | Fire (Insert,update,delete,after,all rows) |
Creation Date | Analysis Date |
---|---|
04/02/2008 21:04:44:000 | 04/02/2008 21:18:24:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
SARCHKL_PIDM |   | NUMBER(8,0) | No | * | * |
SARCHKL_TERM_CODE_ENTRY |   | VARCHAR2(6) | No | * | * |
SARCHKL_APPL_NO |   | NUMBER(2,0) | No | * | * |
SARCHKL_ADMR_CODE |   | VARCHAR2(4) | No | * | * |
SARCHKL_MANDATORY_IND |   | VARCHAR2(1) | Yes |   |   |
SARCHKL_REQ_DATE1 |   | DATE | Yes |   |   |
SARCHKL_REQ_DATE2 |   | DATE | Yes |   |   |
SARCHKL_REQ_COUNT |   | NUMBER(3,0) | Yes |   |   |
SARCHKL_DEADLINE_DATE |   | DATE | Yes |   |   |
SARCHKL_RECEIVE_DATE |   | DATE | Yes |   |   |
SARCHKL_COMMENT |   | VARCHAR2(30) | Yes |   |   |
SARCHKL_CODE_VALUE |   | VARCHAR2(10) | Yes |   |   |
SARCHKL_SOURCE |   | VARCHAR2(1) | No |   |   |
SARCHKL_SOURCE_DATE |   | DATE | No |   |   |
SARCHKL_ACTIVITY_DATE |   | DATE | No |   |   |
SARCHKL_PRINT_IND |   | VARCHAR2(1) | Yes |   |   |
SARCHKL_CKSR_CODE |   | VARCHAR2(15) | Yes |   | * |
SARCHKL_CKST_CODE |   | VARCHAR2(15) | Yes |   | * |
Column name | is Foreign Key For Column | on Table |
---|---|---|
SARCHKL_CKSR_CODE | STVCKSR_CODE | STVCKSR |
SARCHKL_CKST_CODE | STVCKST_CODE | STVCKST |
SARCHKL_ADMR_CODE | STVADMR_CODE | STVADMR |
SARCHKL_TERM_CODE_ENTRY | STVTERM_CODE | STVTERM |
SARCHKL_PIDM | SARADAP_PIDM | SARADAP |
SARCHKL_TERM_CODE_ENTRY | SARADAP_TERM_CODE_ENTRY | SARADAP |
SARCHKL_APPL_NO | SARADAP_APPL_NO | SARADAP |
SARCHKL_ADMR_CODE | ESBLINK_ADMR_CODE | ESBLINK |
Index Name | Index Type | Column Name |
---|---|---|
PK_SARCHKL | Unique | SARCHKL_PIDM |
PK_SARCHKL | Unique | SARCHKL_TERM_CODE_ENTRY |
PK_SARCHKL | Unique | SARCHKL_APPL_NO |
PK_SARCHKL | Unique | SARCHKL_ADMR_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_SARCHKL | SQL Index | S10B80.SATURN | Rely On |
ESBLINK | SQL Table | S10B80.BANIMGR | Join |
SARADAP | SQL Table | S10B80.SATURN | Refer (no action) |
STVADMR | SQL Table | S10B80.SATURN | Refer (no action) |
STVCKSR | SQL Table | S10B80.SATURN | Refer (no action) |
STVCKST | SQL Table | S10B80.SATURN | Refer (no action) |
STVTERM | SQL Table | S10B80.SATURN | Refer (no action) |
ET_SARCHKL_ADR_EXTSOL | SQL Trigger | S10B80.BANIMGR | Fire (delete,after,each row) |
ET_SARCHKL_AIR_EXTSOL | SQL Trigger | S10B80.BANIMGR | Fire (Insert,after,each row) |
ET_SARCHKL_AUR_EXTSOL | SQL Trigger | S10B80.BANIMGR | Fire (update,after,each row) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:42:14:000 | 04/02/2008 21:18:05:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
SPRIDEN_PIDM |   | NUMBER(8,0) | No |   | * |
SPRIDEN_ID |   | VARCHAR2(9) | No |   | * |
SPRIDEN_LAST_NAME |   | VARCHAR2(60) | No |   |   |
SPRIDEN_FIRST_NAME |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_MI |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_CHANGE_IND |   | VARCHAR2(1) | Yes |   |   |
SPRIDEN_ENTITY_IND |   | VARCHAR2(1) | Yes |   |   |
SPRIDEN_ACTIVITY_DATE |   | DATE | No |   |   |
SPRIDEN_USER |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_ORIGIN |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_SEARCH_LAST_NAME |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_SEARCH_FIRST_NAME |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_SEARCH_MI |   | VARCHAR2(60) | Yes |   |   |
SPRIDEN_SOUNDEX_LAST_NAME |   | CHAR(4) | Yes |   |   |
SPRIDEN_SOUNDEX_FIRST_NAME |   | CHAR(4) | Yes |   |   |
SPRIDEN_NTYP_CODE |   | VARCHAR2(4) | Yes |   | * |
SPRIDEN_CREATE_USER |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_CREATE_DATE |   | DATE | Yes |   |   |
SPRIDEN_DATA_ORIGIN |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_CREATE_FDMN_CODE |   | VARCHAR2(30) | Yes |   |   |
SPRIDEN_SURNAME_PREFIX |   | VARCHAR2(60) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
SPRIDEN_NTYP_CODE | GTVNTYP_CODE | GTVNTYP |
SPRIDEN_PIDM | GOBEACC_PIDM | GOBEACC |
SPRIDEN_PIDM | SFRSTCR_PIDM | SFRSTCR |
SPRIDEN_PIDM | SPBPERS_PIDM | SPBPERS |
SPRIDEN_PIDM | NBRBJOB_PIDM | NBRBJOB |
SPRIDEN_PIDM | SIBINST_PIDM | SIBINST |
SPRIDEN_PIDM | SHRTTRM_PIDM | SHRTTRM |
SPRIDEN_PIDM | SARADAP_PIDM | SARADAP |
SPRIDEN_PIDM | GLBEXTR_KEY | GLBEXTR |
SPRIDEN_PIDM | SHRDGMR_PIDM | SHRDGMR |
SPRIDEN_PIDM | RORSTAT_PIDM | RORSTAT |
SPRIDEN_PIDM | APRXREF_XREF_PIDM | APRXREF |
SPRIDEN_PIDM | SHBCOMI_PIDM | SHBCOMI |
SPRIDEN_PIDM | AFRCSLT_PIDM | AFRCSLT |
SPRIDEN_PIDM | APRCATG_PIDM | APRCATG |
SPRIDEN_PIDM | SIRASGN_PIDM | SIRASGN |
SPRIDEN_PIDM | APRCSPS_SPS_PIDM | APRCSPS |
SPRIDEN_PIDM | SGBSTDN_PIDM | SGBSTDN |
SPRIDEN_PIDM | PERJOBP_PIDM | PERJOBP |
SPRIDEN_PIDM | AFRCTYP_CONSTITUENT_PIDM | AFRCTYP |
SPRIDEN_PIDM | AMRINFO_PIDM | AMRINFO |
SPRIDEN_PIDM | SORHSCH_PIDM | SORHSCH |
SPRIDEN_PIDM | RERSTID_PIDM | RERSTID |
SPRIDEN_PIDM | AOBORGN_PIDM | AOBORGN |
SPRIDEN_PIDM | GOBSRVR_PIDM | GOBSRVR |
SPRIDEN_PIDM | APRDHIS_PIDM | APRDHIS |
SPRIDEN_PIDM | SLRRMAT_PIDM | SLRRMAT |
SPRIDEN_PIDM | SABSTUD_PIDM | SABSTUD |
SPRIDEN_PIDM | SGRASSI_PIDM | SGRASSI |
SPRIDEN_PIDM | SHTTRAN_PIDM | SHTTRAN |
SPRIDEN_PIDM | APBCONS_PIDM | APBCONS |
SPRIDEN_PIDM | ASRSSAG_PIDM | ASRSSAG |
SPRIDEN_PIDM | SABIDEN_PIDM | SABIDEN |
SPRIDEN_PIDM | SFRENRL_PIDM | SFRENRL |
SPRIDEN_PIDM | SHRGCOL_PIDM | SHRGCOL |
SPRIDEN_PIDM | SFBETRM_PIDM | SFBETRM |
SPRIDEN_PIDM | SRBRECR_PIDM | SRBRECR |
SPRIDEN_PIDM | PABAPPL_PIDM | PABAPPL |
SPRIDEN_PIDM | PEBEMPL_PIDM | PEBEMPL |
SPRIDEN_PIDM | SORPCOL_PIDM | SORPCOL |
SPRIDEN_PIDM | SPRHOLD_PIDM | SPRHOLD |
SPRIDEN_PIDM | RPRATRM_PIDM | RPRATRM |
SPRIDEN_PIDM | SHRCOMM_PIDM_MEMBER | SHRCOMM |
SPRIDEN_PIDM | RPRAWRD_PIDM | RPRAWRD |
SPRIDEN_PIDM | ASRSORG_PIDM | ASRSORG |
SPRIDEN_PIDM | SLRRASG_PIDM | SLRRASG |
SPRIDEN_PIDM | SMBSLIB_PIDM | SMBSLIB |
SPRIDEN_PIDM | APRCHLD_CHLD_PIDM | APRCHLD |
SPRIDEN_PIDM | APREHIS_EMPR_PIDM | APREHIS |
SPRIDEN_PIDM | PERBARG_PIDM | PERBARG |
SPRIDEN_PIDM | PARAPIN_PIDM | PARAPIN |
SPRIDEN_PIDM | SPRADDR_PIDM | SPRADDR |
SPRIDEN_PIDM | PDRBDED_PIDM | PDRBDED |
SPRIDEN_PIDM | SORAROL_PIDM | SORAROL |
SPRIDEN_PIDM | SERDTGL_PIDM | SERDTGL |
SPRIDEN_PIDM | SERDTND_PIDM | SERDTND |
SPRIDEN_PIDM | SERDTSR_PIDM | SERDTSR |
SPRIDEN_PIDM | SLBEVNT_AGENCY_PIDM | SLBEVNT |
SPRIDEN_PIDM | RORLOGM_PIDM | RORLOGM |
SPRIDEN_PIDM | RNRTMNT_PIDM | RNRTMNT |
SPRIDEN_PIDM | SHBHEAD_PIDM | SHBHEAD |
SPRIDEN_PIDM | SMRRQCM_ORIG_PIDM | SMRRQCM |
SPRIDEN_PIDM | SMRRQCM_PIDM | SMRRQCM |
SPRIDEN_PIDM | GORSVAS_ACT_SITE_PIDM | GORSVAS |
SPRIDEN_PIDM | GORSEVD_DEP_PIDM | GORSEVD |
SPRIDEN_PIDM | GORSVEI_EMPLOYER_PIDM | GORSVEI |
SPRIDEN_PIDM | GOBSEVS_PIDM | GOBSEVS |
SPRIDEN_PIDM | PERJOBS_COMMENT_PIDM | PERJOBS |
SPRIDEN_PIDM | PERJOBS_PIDM | PERJOBS |
SPRIDEN_PIDM | AGBMGID_EMPR_PIDM | AGBMGID |
SPRIDEN_PIDM | AGBMGID_EMPL_PIDM | AGBMGID |
SPRIDEN_PIDM | AORCONT_CONTACT_PIDM | AORCONT |
SPRIDEN_PIDM | SORAINF_PIDM | SORAINF |
SPRIDEN_PIDM | NBRJOBS_PIDM | NBRJOBS |
SPRIDEN_PIDM | GORSEVS_PIDM | GORSEVS |
SPRIDEN_PIDM | PDRBENE_BENE_PIDM | PDRBENE |
SPRIDEN_PIDM | APRCHIS_PIDM | APRCHIS |
SPRIDEN_PIDM | PERREVW_PIDM | PERREVW |
SPRIDEN_PIDM | GERATTD_PIDM | GERATTD |
SPRIDEN_PIDM | SGRADVR_ADVR_PIDM | SGRADVR |
SPRIDEN_PIDM | SGRADVR_PIDM | SGRADVR |
SPRIDEN_PIDM | FABINVH_VEND_CHECK_PIDM | FABINVH |
SPRIDEN_PIDM | FABINVH_VEND_PIDM | FABINVH |
SPRIDEN_PIDM | PERJOBH_COMMENT_PIDM | PERJOBH |
SPRIDEN_PIDM | PERTETH_TRANS_PIDM | PERTETH |
SPRIDEN_PIDM | PERROUT_ACTION_PIDM | PERROUT |
SPRIDEN_PIDM | PERROUT_APPR_PIDM | PERROUT |
SPRIDEN_PIDM | FTVVEND_PIDM | FTVVEND |
SPRIDEN_PIDM | GOBTPAC_PIDM | GOBTPAC |
SPRIDEN_PIDM | FRBGRNT_AGENCY_PIDM | FRBGRNT |
SPRIDEN_PIDM | AMRSTAF_PIDM | AMRSTAF |
SPRIDEN_PIDM | SHRMRKS_PIDM | SHRMRKS |
SPRIDEN_PIDM | SHRCMRK_PIDM | SHRCMRK |
SPRIDEN_PIDM | SHRSMRK_PIDM | SHRSMRK |
SPRIDEN_PIDM | NBREJOB_PIDM | NBREJOB |
SPRIDEN_PIDM | SHRNCRS_ADVR_PIDM | SHRNCRS |
SPRIDEN_PIDM | SHRTCKN_PIDM | SHRTCKN |
SPRIDEN_PIDM | NBTJOBF_EMPLOYEE_PIDM | NBTJOBF |
SPRIDEN_PIDM | RCRAPP1_PIDM | RCRAPP1 |
SPRIDEN_PIDM | RPRLAPP_LENDER_PIDM | RPRLAPP |
SPRIDEN_PIDM | SFRAREG_PIDM | SFRAREG |
SPRIDEN_PIDM | PERFJOB_PIDM | PERFJOB |
SPRIDEN_PIDM | AMRPLAN_PIDM | AMRPLAN |
SPRIDEN_PIDM | GORVISA_PIDM | GORVISA |
SPRIDEN_ID | SRTIDEN_ID | SRTIDEN |
SPRIDEN_PIDM | SRTIDEN_PIDM | SRTIDEN |
SPRIDEN_PIDM | PERFCNT_PIDM | PERFCNT |
SPRIDEN_PIDM | APRACYR_PIDM | APRACYR |
SPRIDEN_PIDM | SHTTRTC_PIDM | SHTTRTC |
SPRIDEN_PIDM | GOBUMAP_PIDM | GOBUMAP |
SPRIDEN_PIDM | AORJPST_EMPR_PIDM | AORJPST |
SPRIDEN_PIDM | FTVIMGR_IMGR_CODE_PIDM | FTVIMGR |
SPRIDEN_PIDM | APRCRVW_PIDM | APRCRVW |
SPRIDEN_PIDM | APRERVW_PIDM | APRERVW |
SPRIDEN_PIDM | APRSRVW_PIDM | APRSRVW |
SPRIDEN_PIDM | APRDRVW_PIDM | APRDRVW |
Index Name | Index Type | Column Name |
---|---|---|
SPRIDEN_INDEX_ID |   | SPRIDEN_ID |
SPRIDEN_INDEX_ID |   | SPRIDEN_ENTITY_IND |
SPRIDEN_INDEX_ID |   | SPRIDEN_CHANGE_IND |
SPRIDEN_INDEX_PERS |   | SPRIDEN_LAST_NAME |
SPRIDEN_INDEX_PERS |   | SPRIDEN_FIRST_NAME |
SPRIDEN_INDEX_PERS |   | SPRIDEN_MI |
SPRIDEN_INDEX_PERS |   | SPRIDEN_ENTITY_IND |
SPRIDEN_INDEX_PERS |   | SPRIDEN_CHANGE_IND |
SPRIDEN_INDEX_SEARCH |   | SPRIDEN_SEARCH_LAST_NAME |
SPRIDEN_INDEX_SEARCH |   | SPRIDEN_SEARCH_FIRST_NAME |
SPRIDEN_INDEX_SEARCH |   | SPRIDEN_SEARCH_MI |
SPRIDEN_INDEX_SOUNDEX |   | SPRIDEN_SOUNDEX_LAST_NAME |
SPRIDEN_INDEX_SOUNDEX |   | SPRIDEN_SOUNDEX_FIRST_NAME |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_PIDM |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_ID |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_LAST_NAME |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_FIRST_NAME |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_MI |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_CHANGE_IND |
SPRIDEN_KEY_INDEX | Unique | SPRIDEN_NTYP_CODE |
Creation Date | Analysis Date |
---|---|
04/02/2008 13:48:43:000 | 04/02/2008 21:17:58:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
STVADMR_CODE |   | VARCHAR2(4) | No | * |   |
STVADMR_DESC |   | VARCHAR2(30) | No |   |   |
STVADMR_TABLE_NAME |   | VARCHAR2(7) | Yes |   |   |
STVADMR_ACTIVITY_DATE |   | DATE | No |   |   |
STVADMR_VR_MSG_NO |   | NUMBER(6,0) | Yes |   |   |
STVADMR_VR_ELIG_IND |   | VARCHAR2(1) | Yes |   |   |
STVADMR_DISP_WEB_IND |   | VARCHAR2(1) | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_STVADMR | Unique | STVADMR_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
ESBLINK | SQL Table | S10B80.BANIMGR | Refer (no action) |
GOBINTL | SQL Table | S10B80.GENERAL | Refer (no action) |
SARCHKB | SQL Table | S10B80.SATURN | Refer (no action) |
SARCHKL | SQL Table | S10B80.SATURN | Refer (no action) |
SARQUAN | SQL Table | S10B80.SATURN | Refer (no action) |
SARRQST | SQL Table | S10B80.SATURN | Refer (no action) |
SARWADF | SQL Table | S10B80.SATURN | Refer (no action) |
SARWUDQ | SQL Table | S10B80.SATURN | Refer (no action) |
SORHSCH | SQL Table | S10B80.SATURN | Refer (no action) |
SORPCOL | SQL Table | S10B80.SATURN | Refer (no action) |
SORTEST | SQL Table | S10B80.SATURN | Refer (no action) |
SPRINTL | SQL Table | S10B80.SATURN | Refer (no action) |
STVSBGI | SQL Table | S10B80.SATURN | Refer (no action) |
STVTESC | SQL Table | S10B80.SATURN | Refer (no action) |
STVVTYP | SQL Table | S10B80.SATURN | Refer (no action) |
F_STUDENT_GET_DESC | SQL Function | S10B80.BANINST1 | Use (select) |
ALL_SARCHKLC | Oracle Package Cursor | S10B80.BANINST1.SAKLIBS | Use (select) |
SARCHKLC | Oracle Package Cursor | S10B80.BANINST1.SAKLIBS | Use (select) |
STVADMRC | Oracle Package Cursor | S10B80.BANINST1.STKADMR | Use (select)Rely On |
STVADMR_C | Oracle Package Cursor | S10B80.BANINST1.GB_STVADMR | Rely On |
STVADMR_C | Oracle Package Cursor | S10B80.BANINST1.GB_STVADMR | Use (select)Rely On |
P_DELETE_STVADMR | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_DELETE_STVADMR | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (delete) |
P_DISPSTATUS | Oracle Package Procedure | S10B80.BANINST1.BWSKASTA | Rely On |
P_DISPSTATUSSARADAP | Oracle Package Procedure | S10B80.BANINST1.BWSKASTA | Rely On |
P_GET_STVADMR_ROW | Oracle Package Procedure | S10B80.BANINST1.STKSELS | Rely On |
P_INSERT_SORHSCH | Oracle Package Procedure | S10B80.BANINST1.SRKPREL | Rely On |
P_INSERT_STVADMR | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_INSERT_STVADMR | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (Insert) |
P_LOAD_INTL | Oracle Package Procedure | S10B80.BANINST1.SAKL030 | Rely On |
P_STVADMR_AIR | Oracle Package Procedure | S10B80.BANINST1.EOKSRTS | Rely On |
P_STVADMR_AUR | Oracle Package Procedure | S10B80.BANINST1.EOKSRTS | Rely On |
P_UPDATE_STVADMR | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_UPDATE_STVADMR | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (update) |
P_VR_BUILD_MISSING_REQ | Oracle Package Procedure | S10B80.BANINST1.VRSKAADM | Rely On |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_ADMISSIONSAPPLICATION | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_TRANSFER_EQUIV | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_TRANSFER_CRSE | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_PCOL_DEGREE | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_TRANSFER_CRSE_ATTR | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_PRIOR_COLLEGE | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_TRANSFER_EQUIV_ATTR | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_TRANSFER_EQUIV_CMT | Use (Insert,select) |
F_CHECK_VALIDATION_TABLE | Oracle Package Function | S10B80.BANINST1.EOKSLNK | Rely On |
F_CHECK_VALIDATION_TABLE | Oracle Package Function | S10B80.BANINST1.EOKSLNK | Use (select) |
F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_STVADMR | Rely On |
F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_STVADMR | Rely On |
STVADMR | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_STVADMR | SQL Index | S10B80.SATURN | Rely On |
ET_STVADMR_AIR_EXTSOL | SQL Trigger | S10B80.BANIMGR | Fire (Insert,after,each row) |
ET_STVADMR_AUR_EXTSOL | SQL Trigger | S10B80.BANIMGR | Fire (update,after,each row) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:43:17:000 | 04/02/2008 21:18:06:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
STVEMPT_CODE |   | VARCHAR2(3) | No | * |   |
STVEMPT_DESC |   | VARCHAR2(30) | No |   |   |
STVEMPT_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_STVEMPT | Unique | STVEMPT_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GOBINTL | SQL Table | S10B80.GENERAL | Refer (no action) |
SPRINTL | SQL Table | S10B80.SATURN | Refer (no action) |
SPVINTL | SQL View | S10B80.BANINST1 | Use (select) |
STVEMPTC | Oracle Package Cursor | S10B80.BANINST1.STKEMPT | Use (select)Rely On |
STVEMPT_C | Oracle Package Cursor | S10B80.BANINST1.GB_STVEMPT | Rely On |
STVEMPT_C | Oracle Package Cursor | S10B80.BANINST1.GB_STVEMPT | Use (select)Rely On |
P_DELETE_STVEMPT | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_DELETE_STVEMPT | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (delete) |
P_INSERT_STVEMPT | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_INSERT_STVEMPT | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (Insert) |
P_UPDATE_STVEMPT | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_UPDATE_STVEMPT | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (update) |
F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_STVEMPT | Rely On |
F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_STVEMPT | Rely On |
STVEMPT | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_STVEMPT | SQL Index | S10B80.SATURN | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:35:37:000 | 04/02/2008 21:17:59:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
STVLANG_CODE |   | VARCHAR2(3) | No | * |   |
STVLANG_DESC |   | VARCHAR2(30) | No |   |   |
STVLANG_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_STVLANG | Unique | STVLANG_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GOBINTL | SQL Table | S10B80.GENERAL | Refer (no action) |
SPRINTL | SQL Table | S10B80.SATURN | Refer (no action) |
SPVINTL | SQL View | S10B80.BANINST1 | Use (select) |
STVLANGC | Oracle Package Cursor | S10B80.BANINST1.STKLANG | Use (select)Rely On |
STVLANG_C | Oracle Package Cursor | S10B80.BANINST1.GB_STVLANG | Rely On |
STVLANG_C | Oracle Package Cursor | S10B80.BANINST1.GB_STVLANG | Use (select)Rely On |
P_DELETE_STVLANG | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_DELETE_STVLANG | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (delete) |
P_INSERT_STVLANG | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_INSERT_STVLANG | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (Insert) |
P_UPDATE_STVLANG | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_UPDATE_STVLANG | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (update) |
F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_STVLANG | Rely On |
F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_STVLANG | Rely On |
STVLANG | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_STVLANG | SQL Index | S10B80.SATURN | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:39:32:000 | 04/02/2008 21:18:03:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
STVNATN_CODE |   | VARCHAR2(5) | No | * |   |
STVNATN_NATION |   | VARCHAR2(30) | No |   |   |
STVNATN_CAPITAL |   | VARCHAR2(20) | Yes |   |   |
STVNATN_AREA |   | NUMBER(22,0) | Yes |   |   |
STVNATN_POPULATION |   | NUMBER(22,0) | Yes |   |   |
STVNATN_ACTIVITY_DATE |   | DATE | No |   |   |
STVNATN_EDI_EQUIV |   | VARCHAR2(2) | Yes |   |   |
STVNATN_LMS_EQUIV |   | VARCHAR2(2) | Yes |   |   |
STVNATN_POSTAL_MASK |   | VARCHAR2(15) | Yes |   |   |
STVNATN_TELE_MASK |   | VARCHAR2(15) | Yes |   |   |
STVNATN_STATSCAN_CDE |   | VARCHAR2(5) | Yes |   |   |
STVNATN_SCOD_CODE_ISO |   | VARCHAR2(3) | Yes |   |   |
STVNATN_SSA_REPORTING_EQUIV |   | VARCHAR2(2) | Yes |   |   |
STVNATN_SEVIS_EQUIV |   | VARCHAR2(2) | Yes |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_STVNATN | Unique | STVNATN_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
STVNATN | Oracle Synonym | S10B80.FAISMGR | Rely On |
AORCONT | SQL Table | S10B80.ALUMNI | Refer (no action) |
APBCONS | SQL Table | S10B80.ALUMNI | Refer (no action) |
APBWIDN | SQL Table | S10B80.ALUMNI | Refer (no action) |
GOBINTL | SQL Table | S10B80.GENERAL | Refer (no action) |
GOBSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
GORSEVD | SQL Table | S10B80.GENERAL | Refer (no action) |
GORVISA | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVCURR | SQL Table | S10B80.GENERAL | Refer (no action) |
GTVZIPC | SQL Table | S10B80.GENERAL | Refer (no action) |
GUBINST | SQL Table | S10B80.GENERAL | Refer (no action) |
GURAPAY | SQL Table | S10B80.GENERAL | Refer (no action) |
PPREXPE | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTRHSIL | SQL Table | S10B80.PAYROLL | Refer (no action) |
PTRJBLN | SQL Table | S10B80.PAYROLL | Refer (no action) |
PXRMTER | SQL Table | S10B80.PAYROLL | Refer (no action) |
PXRMTIN | SQL Table | S10B80.PAYROLL | Refer (no action) |
RJBPLBD | SQL Table | S10B80.FAISMGR | Refer (no action) |
RPBLNDR | SQL Table | S10B80.FAISMGR | Refer (no action) |
RPRLAPP | SQL Table | S10B80.FAISMGR | Refer (no action) |
RPRLARF | SQL Table | S10B80.FAISMGR | Refer (no action) |
SABSUPL | SQL Table | S10B80.SATURN | Refer (no action) |
SFRENRL | SQL Table | S10B80.SATURN | Refer (no action) |
SHBDIPL | SQL Table | S10B80.SATURN | Refer (no action) |
SHBGAPP | SQL Table | S10B80.SATURN | Refer (no action) |
SHTTRAN | SQL Table | S10B80.SATURN | Refer (no action) |
SHTTRTC | SQL Table | S10B80.SATURN | Refer (no action) |
SMRPRRQ | SQL Table | S10B80.SATURN | Refer (no action) |
SMTPRRQ | SQL Table | S10B80.SATURN | Refer (no action) |
SOBSBGI | SQL Table | S10B80.SATURN | Refer (no action) |
SPBPERS | SQL Table | S10B80.SATURN | Refer (no action) |
SPRADDR | SQL Table | S10B80.SATURN | Refer (no action) |
SPREMRG | SQL Table | S10B80.SATURN | Refer (no action) |
SPRINTL | SQL Table | S10B80.SATURN | Refer (no action) |
SRTADDR | SQL Table | S10B80.SATURN | Refer (no action) |
SRTHSCH | SQL Table | S10B80.SATURN | Refer (no action) |
SRTINTL | SQL Table | S10B80.SATURN | Refer (no action) |
SRTPCOL | SQL Table | S10B80.SATURN | Refer (no action) |
SRTSUPL | SQL Table | S10B80.SATURN | Refer (no action) |
STVEMPL | SQL Table | S10B80.SATURN | Refer (no action) |
AF_VENDOR_VOLUME | SQL View | S10B80.BANINST1 | Use (select) |
APVADRS | SQL View | S10B80.BANINST1 | Use (select) |
GOVSVDP | SQL View | S10B80.BANINST1 | Use (select) |
GOVSVEV | SQL View | S10B80.BANINST1 | Use (select) |
GOVSVSD | SQL View | S10B80.BANINST1 | Use (select) |
PAVAPPL | SQL View | S10B80.BANINST1 | Use (select) |
PEVEMPL | SQL View | S10B80.BANINST1 | Use (select) |
POVDATA | SQL View | S10B80.BANINST1 | Use (select) |
PPVADRS | SQL View | S10B80.BANINST1 | Use (select) |
RPVADDR | SQL View | S10B80.BANINST1 | Use (select) |
RPVADRS | SQL View | S10B80.BANINST1 | Use (select) |
RPVFDRS | SQL View | S10B80.BANINST1 | Use (select) |
SAVADRS | SQL View | S10B80.BANINST1 | Use (select) |
SGVADRS | SQL View | S10B80.BANINST1 | Use (select) |
SPVADDF | SQL View | S10B80.BANINST1 | Use (select) |
SPVADDI | SQL View | S10B80.BANINST1 | Use (select) |
SPVADDS | SQL View | S10B80.BANINST1 | Use (select) |
SPVADRS | SQL View | S10B80.BANINST1 | Use (select) |
SPVINTL | SQL View | S10B80.BANINST1 | Use (select) |
SRVADRS | SQL View | S10B80.BANINST1 | Use (select) |
STVNATV | SQL View | S10B80.BANINST1 | Use (select) |
F_COMMON_GET_DESC | SQL Function | S10B80.BANINST1 | Use (select) |
F_GET_DESC | SQL Function | S10B80.BANINST1 | Use (select) |
F_GET_DESC_ALUMNI | SQL Function | S10B80.BANINST1 | Use (select) |
F_GET_DESC_FNC | SQL Function | S10B80.BANINST1 | Use (select) |
F_STUDENT_GET_DESC | SQL Function | S10B80.BANINST1 | Use (select) |
ADDRESS_REC_TYPE | Oracle Package Type | S10B80.BANINST1.ICSPKCOM | Rely On |
NATN_CUR | Oracle Package Cursor | S10B80.BANINST1.BWSKALOG | Use (select) |
STVNATN_REC | Oracle Package Variable | S10B80.BANINST1.BWDKSRCH | Rely On |
STVNATN_REC | Oracle Package Variable | S10B80.BANINST1.BWDKCPRF | Rely On |
STVNATN_REC | Oracle Package Variable | S10B80.BANINST1.BWAKADVS | Rely On |
STVNATN_REC | Oracle Package Variable | S10B80.BANINST1.BWGKOADR | Rely On |
STVNATN_REC | Oracle Package Variable | S10B80.BANINST1.BWAKJPST | Rely On |
GETSTVNATNC | Oracle Package Cursor | S10B80.BANINST1.BWAKALOG | Use (select)Rely On |
STVNATNC | Oracle Package Cursor | S10B80.BANINST1.BWSKWTRR | Use (select) |
STVNATNVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKSRCH | Use (select)Rely On |
STVNATNVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWDKCPRF | Use (select)Rely On |
STVNATNVIEWC | Oracle Package Cursor | S10B80.BANINST1.BWAKJPST | Use (select)Rely On |
STVNATN_LISTC | Oracle Package Cursor | S10B80.BANINST1.BWSKRQST | Use (select) |
P_GENOPTIONSNATN | Oracle Package Procedure | S10B80.BANINST1.BWGKOADR | Rely On |
P_LOOKUPSBGICODE | Oracle Package Procedure | S10B80.BANINST1.BWSKWPRO | Use (select) |
CUR_OF_NATN | Oracle Package Variable | S10B80.BANINST1.BWPKEDIR | Rely On |
CUR_PR_NATN | Oracle Package Variable | S10B80.BANINST1.BWPKEDIR | Rely On |
GV_NATION_CODE1 | Oracle Package Variable | S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT | Rely On |
GV_NATION_CODE2 | Oracle Package Variable | S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT | Rely On |
GV_NATION_CODE3 | Oracle Package Variable | S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT | Rely On |
GV_NATION_CODE4 | Oracle Package Variable | S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT | Rely On |
GV_NATN_DESC | Oracle Package Variable | S10B80.BANINST1.BWSKRQST | Rely On |
STVNATN_REC | Oracle Package Variable | S10B80.BANINST1.BWGKOEMR | Rely On |
STVNATN_REC | Oracle Package Variable | S10B80.BANINST1.BWAKALOG | Rely On |
STVNATN_REC | Oracle Package Variable | S10B80.BANINST1.BWGKOPRF | Rely On |
F_GET_NATN_DESC | Oracle Package Function | S10B80.BANINST1.BWSKWTRR | Rely On |
F_GET_NATN_DESC | Oracle Package Function | S10B80.BANINST1.BWSKWTRR | Use (select) |
STVNATNC | Oracle Package Cursor | S10B80.BANINST1.STKNATN | Use (select)Rely On |
STVNATNLISTC | Oracle Package Cursor | S10B80.BANINST1.BWSKLIST | Use (select)Rely On |
STVNATNLISTC | Oracle Package Cursor | S10B80.BANINST1.GOKLIBS | Use (select)Rely On |
STVNATN_C | Oracle Package Cursor | S10B80.BANINST1.GB_STVNATN | Rely On |
STVNATN_C | Oracle Package Cursor | S10B80.BANINST1.GB_STVNATN | Use (select)Rely On |
P_CCPAYMENTSTATUS | Oracle Package Procedure | S10B80.BANINST1.BWAKCPMT | Rely On |
P_CCPAYMENTSTATUS | Oracle Package Procedure | S10B80.BANINST1.BWAKNGFT | Rely On |
P_CCPAYMENTSTATUS | Oracle Package Procedure | S10B80.BANINST1.BWSKAPMT | Rely On |
P_CCPAYMENTSTATUS | Oracle Package Procedure | S10B80.BANINST1.BWCKCPMT | Rely On |
P_CC_PAYMENT_STATUS | Oracle Package Procedure | S10B80.BANINST1.BWSKWCCP | Rely On |
P_COLLECT_CREDIT_CARD_INFO | Oracle Package Procedure | S10B80.BANINST1.BWGKCCRD | Rely On |
P_CREDITCARDPAYMENT | Oracle Package Procedure | S10B80.BANINST1.BWAKCPMT | Rely On |
P_CREDITCARDPAYMENT | Oracle Package Procedure | S10B80.BANINST1.BWSKAPMT | Rely On |
P_CREDITCARDPAYMENT | Oracle Package Procedure | S10B80.BANINST1.BWCKCPMT | Rely On |
P_CREDIT_CARD_PAYMENT | Oracle Package Procedure | S10B80.BANINST1.BWSKWCCP | Rely On |
P_DELETE_STVNATN | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_DELETE_STVNATN | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (delete) |
P_DISPADDRVIEW | Oracle Package Procedure | S10B80.BANINST1.BWLKOSAD | Rely On |
P_DISPADDRVIEW | Oracle Package Procedure | S10B80.BANINST1.BWGKOADR | Rely On |
P_DISPSTATUS | Oracle Package Procedure | S10B80.BANINST1.BWSKASTA | Rely On |
P_DISPSTATUSSARADAP | Oracle Package Procedure | S10B80.BANINST1.BWSKASTA | Rely On |
P_DISP_CONFIRM | Oracle Package Procedure | S10B80.BANINST1.BWSKWTRR | Rely On |
P_DISP_DIPLOMA_ADDR | Oracle Package Procedure | S10B80.BANINST1.BWSKGRAD | Use (select) |
P_DISP_STATUS_OF_ORDER | Oracle Package Procedure | S10B80.BANINST1.BWSKWTRR | Rely On |
P_DISP_TRANSCRIPT_REQUEST_TYPE | Oracle Package Procedure | S10B80.BANINST1.BWSKWTRR | Rely On |
P_EDIT_SHIP_CODE | Oracle Package Procedure | S10B80.BANINST1.FSKSHIP | Rely On |
P_EDIT_SHIP_CODE | Oracle Package Procedure | S10B80.BANINST1.FSKSHIP | Use (select) |
P_GET_SOBSBGI_INFO | Oracle Package Procedure | S10B80.BANINST1.SB_PESCXML_TRANDATA_IMP | Use (select) |
P_INSERT_INTL | Oracle Package Procedure | S10B80.BANINST1.SRKPREL | Rely On |
P_INSERT_INTL | Oracle Package Procedure | S10B80.BANINST1.SRKPREL | Use (select) |
P_INSERT_STVNATN | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_INSERT_STVNATN | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (Insert) |
P_LOAD_INTL | Oracle Package Procedure | S10B80.BANINST1.SAKL030 | Rely On |
P_LOAD_INTL | Oracle Package Procedure | S10B80.BANINST1.SAKL030 | Use (select) |
P_LOOKUP_SBGI_CODE | Oracle Package Procedure | S10B80.BANINST1.BWSKALOG | Use (select) |
P_MAKE_A_DONATION | Oracle Package Procedure | S10B80.BANINST1.BWAKNGFT | Rely On |
P_PROCADDRUPDATE | Oracle Package Procedure | S10B80.BANINST1.BWGKOGAD | Rely On |
P_PURCHASEORDER | Oracle Package Procedure | S10B80.BANINST1.BWFKPURR | Rely On |
P_PURCHASEORDER | Oracle Package Procedure | S10B80.BANINST1.BWFKPURR | Use (select) |
P_REQUISITION | Oracle Package Procedure | S10B80.BANINST1.BWFKREQN | Rely On |
P_REQUISITION | Oracle Package Procedure | S10B80.BANINST1.BWFKREQN | Use (select) |
P_UPDATE_STVNATN | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_UPDATE_STVNATN | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (update) |
P_VALADDRUPDATE | Oracle Package Procedure | S10B80.BANINST1.BWGKOADR | Rely On |
P_VALIDATION_DISPLAY | Oracle Package Procedure | S10B80.BANINST1.BWGKCCRD | Rely On |
P_VIEWDCSR | Oracle Package Procedure | S10B80.BANINST1.BWFKVDCR | Rely On |
P_VIEWINV | Oracle Package Procedure | S10B80.BANINST1.BWFKVINV | Rely On |
P_VIEWPUR | Oracle Package Procedure | S10B80.BANINST1.BWFKVPUR | Rely On |
P_VIEWREQ | Oracle Package Procedure | S10B80.BANINST1.BWFKVREQ | Rely On |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_EXPERIENCE | Use (Insert) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_VISA | Use (Insert) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_DRIVER_LICENSE | Use (Insert) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SP_HOUSING_PROFILE | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_BIO | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_PB_CERTIFICATION | Use (Insert) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GP_CARDHOLDER | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SB_GRADAPP | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_EFDTEST | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_EMERGENCY_CONTACT | Use (Insert,select) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GP_ENTITY_ADDRESS | Use (Insert) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_TB_MISC_HEADER | Use (Insert) |
F_CALC_NATION | Oracle Package Function | S10B80.BANINST1.ICSPKCOM | Rely On |
F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_STVNATN | Rely On |
F_DOMESTIC_ADDR | Oracle Package Function | S10B80.BANINST1.SHKPXML | Rely On |
F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_STVNATN | Rely On |
F_GET_NATN_DESC | Oracle Package Function | S10B80.BANINST1.BWFKVDOC | Rely On |
F_GET_NATN_DESC | Oracle Package Function | S10B80.BANINST1.BWFKVDOC | Use (select) |
F_GET_NATN_DESC | Oracle Package Function | S10B80.BANINST1.TTKSELS | Rely On |
F_GET_NATN_DESC | Oracle Package Function | S10B80.BANINST1.TTKSELS | Use (select) |
F_GET_STVNATN_DESC | Oracle Package Function | S10B80.BANINST1.FRKIDEN | Rely On |
F_GET_STVNATN_DESC | Oracle Package Function | S10B80.BANINST1.FRKIDEN | Use (select) |
F_OPEN_STVNATN_RC | Oracle Package Function | S10B80.BANINST1.NOKEPCR | Use (select) |
F_SORXREF_CHK | Oracle Package Function | S10B80.BANINST1.SAKPCOM | Use (select) |
F_SORXREF_VAL | Oracle Package Function | S10B80.BANINST1.SAKPCOM | Use (select) |
STVNATN | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_STVNATN | SQL Index | S10B80.SATURN | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 10:35:08:000 | 04/02/2008 21:17:58:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
STVPENT_CODE |   | VARCHAR2(3) | No | * |   |
STVPENT_DESC |   | VARCHAR2(30) | Yes |   |   |
STVPENT_ACTIVITY_DATE |   | DATE | No |   |   |
STVPENT_SEVIS_EQUIV |   | VARCHAR2(3) | Yes |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_STVPENT | Unique | STVPENT_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_STVPENT | SQL Index | S10B80.SATURN | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:41:40:000 | 04/02/2008 21:18:05:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
STVSPON_CODE |   | VARCHAR2(3) | No | * |   |
STVSPON_DESC |   | VARCHAR2(30) | Yes |   |   |
STVSPON_ACTIVITY_DATE |   | DATE | No |   |   |
Index Name | Index Type | Column Name |
---|---|---|
PK_STVSPON | Unique | STVSPON_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GOBINTL | SQL Table | S10B80.GENERAL | Refer (no action) |
SPRINTL | SQL Table | S10B80.SATURN | Refer (no action) |
SPVINTL | SQL View | S10B80.BANINST1 | Use (select) |
STVSPONC | Oracle Package Cursor | S10B80.BANINST1.STKSPON | Use (select)Rely On |
STVSPON_C | Oracle Package Cursor | S10B80.BANINST1.GB_STVSPON | Rely On |
STVSPON_C | Oracle Package Cursor | S10B80.BANINST1.GB_STVSPON | Use (select)Rely On |
P_DELETE_STVSPON | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_DELETE_STVSPON | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (delete) |
P_INSERT_STVSPON | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_INSERT_STVSPON | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (Insert) |
P_UPDATE_STVSPON | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_UPDATE_STVSPON | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (update) |
F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_STVSPON | Rely On |
F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_STVSPON | Rely On |
STVSPON | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_STVSPON | SQL Index | S10B80.SATURN | Rely On |
Creation Date | Analysis Date |
---|---|
04/02/2008 21:03:02:000 | 04/02/2008 21:18:22:000 |
Column Name | Label | Column Type | Allow NULL | PK | FK |
---|---|---|---|---|---|
STVVTYP_CODE |   | VARCHAR2(2) | No | * |   |
STVVTYP_DESC |   | VARCHAR2(30) | No |   |   |
STVVTYP_ACTIVITY_DATE |   | DATE | No |   |   |
STVVTYP_ADMR_CODE |   | VARCHAR2(4) | Yes |   | * |
STVVTYP_NON_RES_IND |   | VARCHAR2(1) | Yes |   |   |
STVVTYP_VR_MSG_NO |   | NUMBER(6,0) | Yes |   |   |
STVVTYP_DISP_WEB_IND |   | RAW(1) | Yes |   |   |
STVVTYP_STATSCAN_CDE2 |   | NUMBER(1,0) | Yes |   |   |
STVVTYP_SEVIS_EQUIV |   | VARCHAR2(2) | Yes |   |   |
Column name | is Foreign Key For Column | on Table |
---|---|---|
STVVTYP_ADMR_CODE | STVADMR_CODE | STVADMR |
Index Name | Index Type | Column Name |
---|---|---|
PK_STVVTYP | Unique | STVVTYP_CODE |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
GOBSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
GORDOCM | SQL Table | S10B80.GENERAL | Refer (no action) |
GORSEVD | SQL Table | S10B80.GENERAL | Refer (no action) |
GORVISA | SQL Table | S10B80.GENERAL | Refer (no action) |
SCRFEES | SQL Table | S10B80.SATURN | Refer (no action) |
SFRMHRS | SQL Table | S10B80.SATURN | Refer (no action) |
SFRRGFE | SQL Table | S10B80.SATURN | Refer (no action) |
SPRINTL | SQL Table | S10B80.SATURN | Refer (no action) |
SRTINTL | SQL Table | S10B80.SATURN | Refer (no action) |
SSBDFEE | SQL Table | S10B80.SATURN | Refer (no action) |
SSRFEES | SQL Table | S10B80.SATURN | Refer (no action) |
GOVSVDP | SQL View | S10B80.BANINST1 | Use (select) |
GOVSVEV | SQL View | S10B80.BANINST1 | Use (select) |
GOVSVSD | SQL View | S10B80.BANINST1 | Use (select) |
SPVINTL | SQL View | S10B80.BANINST1 | Use (select) |
F_GET_DESC | SQL Function | S10B80.BANINST1 | Use (select) |
F_GET_DESC_FNC | SQL Function | S10B80.BANINST1 | Use (select) |
P_VALIDATION_DATA | Oracle Package Procedure | S10B80.BANINST1.TS_SB_FEEASSESSMENT_ASSMT | Use (Insert) |
P_VALIDATION_DATA | Oracle Package Procedure | S10B80.BANINST1.TS_SB_GRADEROLL | Use (Insert) |
P_VALIDATION_DATA | Oracle Package Procedure | S10B80.BANINST1.TS_SB_REGISTRATION | Use (Insert) |
P_VALIDATION_DATA | Oracle Package Procedure | S10B80.BANINST1.TS_SB_FEEASSESSMENT_RULES | Use (Insert) |
P_VALIDATION_DATA | Oracle Package Procedure | S10B80.BANINST1.TS_SB_CURRICULUM | Use (Insert) |
STVVTYPC | Oracle Package Cursor | S10B80.BANINST1.STKVTYP | Use (select)Rely On |
STVVTYP_C | Oracle Package Cursor | S10B80.BANINST1.GB_STVVTYP | Rely On |
STVVTYP_C | Oracle Package Cursor | S10B80.BANINST1.GB_STVVTYP | Use (select)Rely On |
P_DELETE_STVVTYP | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_DELETE_STVVTYP | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (delete) |
P_INSERT_INTL | Oracle Package Procedure | S10B80.BANINST1.SRKPREL | Rely On |
P_INSERT_INTL | Oracle Package Procedure | S10B80.BANINST1.SRKPREL | Use (select) |
P_INSERT_STVVTYP | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_INSERT_STVVTYP | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (Insert) |
P_INTL_INSCHECKLIST | Oracle Package Procedure | S10B80.BANINST1.SAKCHKB | Use (select) |
P_INTL_UPDCHECKLIST | Oracle Package Procedure | S10B80.BANINST1.SAKCHKB | Rely On |
P_INTL_UPDCHECKLIST | Oracle Package Procedure | S10B80.BANINST1.SAKCHKB | Use (select) |
P_INTL_UPDCOMMENT | Oracle Package Procedure | S10B80.BANINST1.SAKCHKB | Use (select) |
P_UPDATE_STVVTYP | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
P_UPDATE_STVVTYP | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (update) |
UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_GB_VISA | Use (Insert) |
F_CHECK_NONRESIDENT_STATUS | Oracle Package Function | S10B80.BANINST1.GOKINTL | Use (select) |
F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_STVVTYP | Rely On |
F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_STVVTYP | Rely On |
STVVTYP | Oracle Synonym | S10B80.PUBLIC | Rely On |
Object Name | Object Type | Parent Name | Link Type |
---|---|---|---|
PK_STVVTYP | SQL Index | S10B80.SATURN | Rely On |
STVADMR | SQL Table | S10B80.SATURN | Refer (no action) |
Creation Date | Analysis Date |
---|---|
04/02/2008 20:53:57:000 | 04/02/2008 21:18:15:000 |
Objects list |
---|
schema-view : S10B80.BANINST1.SAVLIF1
schema-view : S10B80.BANINST1.SAVADMT schema-view : S10B80.BANINST1.SAVAMC2 schema-view : S10B80.BANINST1.SAVAMCD schema-view : S10B80.BANINST1.SAVAMCT schema-view : S10B80.BANINST1.SAVADM2_N |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRIDEN and SARADAP | SATURN |
Link type | Between | And |
---|---|---|
Join | SPRIDEN | SARADAP |
Objects list |
---|
schema-view : S10B80.BANINST1.SAVAMCD |
Link Type | Link | Project |
---|---|---|
Join | Link Between GORVISA and SARADAP | GENERAL |
Link type | Between | And |
---|---|---|
Join | GORVISA | SARADAP |
Objects list |
---|
schema-view : S10B80.BANINST1.SPVINTL
schema-view : S10B80.BANINST1.SPVINTL_OJ scope-procedure : S10B80.BANINST1.SRKPREL.P_MIGRATE_PROSPECT scope-procedure : S10B80.BANINST1.SAKCHKB.P_INTL_INSCHECKLIST scope-procedure : S10B80.BANINST1.SAKCHKB.P_INTL_UPDCHECKLIST |
Link Type | Link | Project |
---|---|---|
Join | Link Between GOBINTL and GORVISA | GENERAL |
Link type | Between | And |
---|---|---|
Join | GOBINTL | GORVISA |
Objects list |
---|
scope-function : S10B80.BANINST1.GOKVISA.F_CHECK_VISA |
Link Type | Link | Project |
---|---|---|
Join | Link Between SPRIDEN and GORVISA | SATURN |
Link type | Between | And |
---|---|---|
Join | SPRIDEN | GORVISA |
Objects list |
---|
scope-procedure : S10B80.BANINST1.SAKCHKB.P_INTL_UPDCHECKLIST
scope-procedure : S10B80.BANINST1.SAKCHKB.P_INTL_UPDCOMMENT |
Link Type | Link | Project |
---|---|---|
Join | Link Between GOBINTL and SARCHKL | GENERAL |
Link type | Between | And |
---|---|---|
Join | GOBINTL | SARCHKL |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GORVISA and STVNATN (FK1_GORVISA_INV_STVNATN_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GORVISA | GORVISA_NATN_CODE_ISSUE | STVNATN_CODE | STVNATN | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GOBINTL and STVNATN (FK1_GOBINTL_INV_STVNATN_CODE) | GENERAL |
Refer (no action) | Link Informative Foreign Key Between GOBINTL and STVNATN (FK2_GOBINTL_INV_STVNATN_CODE) | GENERAL |
Refer (no action) | Link Informative Foreign Key Between GOBINTL and STVNATN (FK3_GOBINTL_INV_STVNATN_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GOBINTL | GOBINTL_NATN_CODE_ISSUE | STVNATN_CODE | STVNATN | (0,1)-(0,n) |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GOBINTL | GOBINTL_NATN_CODE_BIRTH | STVNATN_CODE | STVNATN | (0,1)-(0,n) |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GOBINTL | GOBINTL_NATN_CODE_LEGAL | STVNATN_CODE | STVNATN | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GORVISA and GTVVISS (FK1_GORVISA_INV_GTVVISS_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GORVISA | GORVISA_VISS_CODE | GTVVISS_CODE | GTVVISS | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GOBINTL and GTVCELG (FK1_GOBINTL_INV_GTVCELG_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GOBINTL | GOBINTL_CELG_CODE | GTVCELG_CODE | GTVCELG | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GORDOCM and GORVISA (FK1_GORDOCM_INV_GORVISA_KEY) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GORDOCM | GORDOCM_PIDM | GORVISA_PIDM | GORVISA | (1,1)-(0,n) |
GORDOCM | GORDOCM_SEQ_NO | GORVISA_SEQ_NO | GORVISA | (1,1)-(0,n) |
GORDOCM | GORDOCM_VTYP_CODE | GORVISA_VTYP_CODE | GORVISA | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GORDOCM and GTVDOCM (FK1_GORDOCM_INV_GTVDOCM_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GORDOCM | GORDOCM_DOCM_CODE | GTVDOCM_CODE | GTVDOCM | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GORDOCM and GTVSRCE (FK1_GORDOCM_INV_GTVSRCE_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GORDOCM | GORDOCM_SRCE_CODE | GTVSRCE_CODE | GTVSRCE | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GOBINTL and STVEMPT (FK1_GOBINTL_INV_STVEMPT_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GOBINTL | GOBINTL_EMPT_CODE | STVEMPT_CODE | STVEMPT | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GOBINTL and STVLANG (FK1_GOBINTL_INV_STVLANG_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GOBINTL | GOBINTL_LANG_CODE | STVLANG_CODE | STVLANG | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GORVISA and STVPENT (FK1_GORVISA_INV_STVPENT_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GORVISA | GORVISA_PENT_CODE | STVPENT_CODE | STVPENT | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between SARCHKL and STVADMR (FK1_SARCHKL_INV_STVADMR_CODE) | SATURN |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
SARCHKL | SARCHKL_ADMR_CODE | STVADMR_CODE | STVADMR | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GOBINTL and STVADMR (FK1_GOBINTL_INV_STVADMR_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GOBINTL | GOBINTL_ADMR_CODE | STVADMR_CODE | STVADMR | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GORDOCM and STVVTYP (FK1_GORDOCM_INV_STVVTYP_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GORDOCM | GORDOCM_VTYP_CODE | STVVTYP_CODE | STVVTYP | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GORVISA and STVVTYP (FK1_GORVISA_INV_STVVTYP_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GORVISA | GORVISA_VTYP_CODE | STVVTYP_CODE | STVVTYP | (1,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between STVVTYP and STVADMR (FK1_STVVTYP_INV_STVADMR_CODE) | SATURN |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
STVVTYP | STVVTYP_ADMR_CODE | STVADMR_CODE | STVADMR | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between GOBINTL and STVSPON (FK1_GOBINTL_INV_STVSPON_CODE) | GENERAL |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
GOBINTL | GOBINTL_SPON_CODE | STVSPON_CODE | STVSPON | (0,1)-(0,n) |
Link Type | Link | Project |
---|---|---|
Refer (no action) | Link Informative Foreign Key Between SARCHKL and SARADAP (FK1_SARCHKL_INV_SARADAP_KEY) | SATURN |
Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
---|---|---|---|---|
SARCHKL | SARCHKL_PIDM | SARADAP_PIDM | SARADAP | (1,1)-(0,n) |
SARCHKL | SARCHKL_TERM_CODE_ENTRY | SARADAP_TERM_CODE_ENTRY | SARADAP | (1,1)-(0,n) |
SARCHKL | SARCHKL_APPL_NO | SARADAP_APPL_NO | SARADAP | (1,1)-(0,n) |