Model SEVIS
| Object Name | Object Type | Layer Name |
|---|---|---|
| GOBSEVS | SQL Table | Default |
| GORSEVD | SQL Table | Default |
| GORSEVH | SQL Table | Default |
| GORSEVS | SQL Table | Default |
| GORSVAH | SQL Table | Default |
| GORSVAS | SQL Table | Default |
| GORSVEI | SQL Table | Default |
| GTVSVCC | SQL Table | Default |
| GTVSVCP | SQL Table | Default |
| GTVSVCR | SQL Table | Default |
| GTVSVCT | SQL Table | Default |
| GTVSVDT | SQL Table | Default |
| GTVSVEL | SQL Table | Default |
| GTVSVEP | SQL Table | Default |
| GTVSVFT | SQL Table | Default |
| GTVSVGO | SQL Table | Default |
| GTVSVIO | SQL Table | Default |
| GTVSVIT | SQL Table | Default |
| GTVSVPC | SQL Table | Default |
| GTVSVRP | SQL Table | Default |
| GTVSVTR | SQL Table | Default |
| GTVSVTS | SQL Table | Default |
| SPBPERS | SQL Table | Default |
| SPRIDEN | SQL Table | Default |
| STVRELT | SQL Table | Default |
Table GOBSEVS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GOBSEVS_PIDM | NUMBER(8,0) | No | * | * | |
| GOBSEVS_ENG_PROF_REQ_IND | VARCHAR2(1) | No | |||
| GOBSEVS_ENG_PROF_MET_IND | VARCHAR2(1) | No | |||
| GOBSEVS_CRIMINAL_CONVICT_IND | VARCHAR2(1) | No | |||
| GOBSEVS_TERMINATE_STUDENT_IND | VARCHAR2(1) | No | |||
| GOBSEVS_EXTEND_FAILURE_IND | VARCHAR2(1) | No | |||
| GOBSEVS_TRANSFER_FAIL_IND | VARCHAR2(1) | No | |||
| GOBSEVS_APPROVAL_FAIL_IND | VARCHAR2(1) | No | |||
| GOBSEVS_OTHER_INFRACT_IND | VARCHAR2(1) | No | |||
| GOBSEVS_ACTIVITY_DATE | DATE | No | |||
| GOBSEVS_USER_ID | VARCHAR2(30) | No | |||
| GOBSEVS_BIRTH_NATN_CODE | VARCHAR2(5) | Yes | * | ||
| GOBSEVS_LEGAL_NATN_CODE | VARCHAR2(5) | Yes | * | ||
| GOBSEVS_PROGRAM_BEGIN_DATE | DATE | Yes | |||
| GOBSEVS_PROGRAM_END_DATE | DATE | Yes | |||
| GOBSEVS_PROGRAM_ENROLL_DATE | DATE | Yes | |||
| GOBSEVS_ENG_PROF_REASON | VARCHAR2(500) | Yes | |||
| GOBSEVS_ACADEMIC_TERM_MONTHS | NUMBER(3,0) | Yes | |||
| GOBSEVS_TUITION_EXPENSE | NUMBER(17,2) | Yes | |||
| GOBSEVS_PERSONAL_FUNDS | NUMBER(17,2) | Yes | |||
| GOBSEVS_TRANS_CDE | VARCHAR2(10) | Yes | |||
| GOBSEVS_SEVIS_ID | VARCHAR2(11) | Yes | |||
| GOBSEVS_VTYP_CODE | VARCHAR2(2) | Yes | * | ||
| GOBSEVS_SVCR_CODE | VARCHAR2(4) | Yes | * | ||
| GOBSEVS_SESSION_START_DATE | DATE | Yes | |||
| GOBSEVS_SESSION_END_DATE | DATE | Yes | |||
| GOBSEVS_TRANSFER_COMMENT | VARCHAR2(500) | Yes | |||
| GOBSEVS_ISSUE_COMMENT | VARCHAR2(500) | Yes | |||
| GOBSEVS_SVEL_CODE | VARCHAR2(2) | Yes | * | ||
| GOBSEVS_MAJR_CODE | VARCHAR2(4) | Yes | * | ||
| GOBSEVS_STUDY_LENGTH | NUMBER(3,0) | Yes | |||
| GOBSEVS_LIVING_EXPENSES | NUMBER(17,2) | Yes | |||
| GOBSEVS_SVFT_CODE | VARCHAR2(2) | Yes | * | ||
| GOBSEVS_AUTH_START_DATE | DATE | Yes | |||
| GOBSEVS_COMPLETION_REMARKS | VARCHAR2(500) | Yes | |||
| GOBSEVS_NEW_PROGRAM_END_DATE | DATE | Yes | |||
| GOBSEVS_DA_PROGRAM_START_DATE | DATE | Yes | |||
| GOBSEVS_DA_PROGRAM_END_DATE | DATE | Yes | |||
| GOBSEVS_DISC_ACTION_TEXT | VARCHAR2(500) | Yes | |||
| GOBSEVS_EMPLOYMENT_CDE | VARCHAR2(2) | Yes | |||
| GOBSEVS_EMPLOYMENT_COMMENT | VARCHAR2(500) | Yes | |||
| GOBSEVS_EMPLOYMENT_START_DATE | DATE | Yes | |||
| GOBSEVS_EMPLOYMENT_END_DATE | DATE | Yes | |||
| GOBSEVS_EMPLOYMENT_TYPE_CDE | VARCHAR2(2) | Yes | |||
| GOBSEVS_EMPLOYER_LAST_NAME | VARCHAR2(500) | Yes | |||
| GOBSEVS_EMPLOYER_FIRST_NAME | VARCHAR2(60) | Yes | |||
| GOBSEVS_EMP_ADDRESS_LINE1 | VARCHAR2(75) | Yes | |||
| GOBSEVS_EMP_ADDRESS_LINE2 | VARCHAR2(75) | Yes | |||
| GOBSEVS_EMPLOYER_CITY | VARCHAR2(60) | Yes | |||
| GOBSEVS_EMPLOYER_STATE | VARCHAR2(2) | Yes | |||
| GOBSEVS_EMPLOYER_ZIP | VARCHAR2(30) | Yes | |||
| GOBSEVS_COURSE_RELEVANCE | VARCHAR2(500) | Yes | |||
| GOBSEVS_EXTEND_END_DATE | DATE | Yes | |||
| GOBSEVS_SVTR_CODE | VARCHAR2(6) | Yes | * | ||
| GOBSEVS_TERMINATE_DATE | DATE | Yes | |||
| GOBSEVS_APPROVAL_FAIL_COMMENT | VARCHAR2(500) | Yes | |||
| GOBSEVS_OTHER_INFRACT_COMMENT | VARCHAR2(500) | Yes | |||
| GOBSEVS_SVEP_CODE | VARCHAR2(4) | Yes | * | ||
| GOBSEVS_END_PROGRAM_EFF_DATE | DATE | Yes | |||
| GOBSEVS_EV_FORM_NUMBER | VARCHAR2(40) | Yes | |||
| GOBSEVS_SVRP_CODE | VARCHAR2(2) | Yes | * | ||
| GOBSEVS_REPRINT_REASON_COMMENT | VARCHAR2(500) | Yes | |||
| GOBSEVS_SVCR_COMMENT | VARCHAR2(500) | Yes | |||
| GOBSEVS_PRINT_REQUEST_IND | VARCHAR2(1) | No | |||
| GOBSEVS_DEPENDENT_EXPENSES | NUMBER(17,2) | Yes | |||
| GOBSEVS_OTHER_FUNDS | NUMBER(17,2) | Yes | |||
| GOBSEVS_OTHER_FUNDS_COMMENT | VARCHAR2(500) | Yes | |||
| GOBSEVS_OTHER_EXPENSES | NUMBER(17,2) | Yes | |||
| GOBSEVS_OTHER_EXP_COMMENT | VARCHAR2(500) | Yes | |||
| GOBSEVS_AUTH_END_DATE | DATE | Yes | |||
| GOBSEVS_NEW_PROGRAM_START_DATE | DATE | Yes | |||
| GOBSEVS_SVPC_CODE | VARCHAR2(3) | Yes | * | ||
| GOBSEVS_SVSC_CODE | VARCHAR2(7) | Yes | |||
| GOBSEVS_SVSC_COMMENT | VARCHAR2(500) | Yes | |||
| GOBSEVS_COMMUTER_IND | VARCHAR2(1) | No | |||
| GOBSEVS_ADMISSION_NUMBER | VARCHAR2(11) | Yes | |||
| GOBSEVS_DRIVERS_LIC_NUMBER | VARCHAR2(30) | Yes | |||
| GOBSEVS_STAT_CODE_DRIVERS_LIC | VARCHAR2(2) | Yes | * | ||
| GOBSEVS_TIN | VARCHAR2(15) | Yes | |||
| GOBSEVS_MAJR_CODE_2 | VARCHAR2(4) | Yes | * | ||
| GOBSEVS_MAJR_CODE_MINR | VARCHAR2(4) | Yes | * | ||
| GOBSEVS_SCHOOL_FUNDS | NUMBER(17,2) | Yes | |||
| GOBSEVS_SCHOOL_FUNDS_COMMENT | VARCHAR2(500) | Yes | |||
| GOBSEVS_EMPLOYMENT_FUNDS | NUMBER(17,2) | Yes | |||
| GOBSEVS_FUNDING_COMMENT | VARCHAR2(500) | Yes | |||
| GOBSEVS_SVFT_COMMENT | VARCHAR2(500) | Yes | |||
| GOBSEVS_SVEP_COMMENT | VARCHAR2(500) | Yes | |||
| GOBSEVS_DA_COMMENT | VARCHAR2(500) | Yes | |||
| GOBSEVS_SVTR_COMMENT | VARCHAR2(500) | Yes | |||
| GOBSEVS_PASSPORT_NUMBER | VARCHAR2(25) | Yes | |||
| GOBSEVS_NATN_CODE_PASSPORT | VARCHAR2(5) | Yes | * | ||
| GOBSEVS_PASSPORT_EXPIRE_DATE | DATE | Yes | |||
| GOBSEVS_VISA_NUMBER | VARCHAR2(25) | Yes | |||
| GOBSEVS_SVCP_CODE | VARCHAR2(3) | Yes | * | ||
| GOBSEVS_VISA_EXPIRE_DATE | DATE | Yes | |||
| GOBSEVS_PENT_CODE | VARCHAR2(3) | Yes | * | ||
| GOBSEVS_PENT_COMMENT | VARCHAR2(500) | Yes | |||
| GOBSEVS_ENTRY_DATE | DATE | Yes | |||
| GOBSEVS_EMPL_AUTH_IND | VARCHAR2(1) | No | |||
| GOBSEVS_RFC_COMMENT | VARCHAR2(500) | Yes | |||
| GOBSEVS_EDIT_PROGRAM_COMMENT | VARCHAR2(500) | Yes | |||
| GOBSEVS_EMPLOYMENT_TIME_CDE | VARCHAR2(2) | Yes | |||
| GOBSEVS_PROGRAM_SPONSOR_FUNDS | NUMBER(17,2) | Yes | |||
| GOBSEVS_GOVT_ORG_FUNDS | NUMBER(17,2) | Yes | |||
| GOBSEVS_SVGO_CODE | VARCHAR2(6) | Yes | * | ||
| GOBSEVS_GOVT_ORG_FUNDS_2 | NUMBER(17,2) | Yes | |||
| GOBSEVS_SVGO_CODE_2 | VARCHAR2(6) | Yes | * | ||
| GOBSEVS_INTL_ORG_FUNDS | NUMBER(17,2) | Yes | |||
| GOBSEVS_SVIO_CODE | VARCHAR2(6) | Yes | * | ||
| GOBSEVS_INTL_ORG_FUNDS_2 | NUMBER(17,2) | Yes | |||
| GOBSEVS_SVIO_CODE_2 | VARCHAR2(6) | Yes | * | ||
| GOBSEVS_EV_GOVT_FUNDS | NUMBER(17,2) | Yes | |||
| GOBSEVS_BINATION_FUNDS | NUMBER(17,2) | Yes | |||
| GOBSEVS_OTHER_ORG_FUNDS | NUMBER(17,2) | Yes | |||
| GOBSEVS_PROGRAM_START_IND | VARCHAR2(1) | No | |||
| GOBSEVS_EXTEND_PROGRAM_COMMENT | VARCHAR2(500) | Yes | |||
| GOBSEVS_AMEND_PROGRAM_COMMENT | VARCHAR2(500) | Yes | |||
| GOBSEVS_MATRICULATION_CDE | VARCHAR2(2) | Yes | |||
| GOBSEVS_EXTEND_FAILURE_COMMENT | VARCHAR2(500) | Yes | |||
| GOBSEVS_CONCLUDE_TRANS_COMMENT | VARCHAR2(500) | Yes | |||
| GOBSEVS_BIRTH_CITY | VARCHAR2(200) | Yes | |||
| GOBSEVS_EDIT_BIO_COMMENT | VARCHAR2(500) | Yes | |||
| GOBSEVS_ATYP_CODE_ACT_SITE | VARCHAR2(2) | Yes | * | ||
| GOBSEVS_NATN_CODE_PERM_RES | VARCHAR2(5) | Yes | |||
| GOBSEVS_FIN_SUPPORT_COMMENT | VARCHAR2(500) | Yes | |||
| GOBSEVS_SVIT_CODE | VARCHAR2(3) | Yes | * | ||
| GOBSEVS_ACT_SITE_NAME | VARCHAR2(60) | Yes | |||
| GOBSEVS_ACT_SITE_COMMENT | VARCHAR2(500) | Yes | |||
| GOBSEVS_SVCC_CODE | VARCHAR2(3) | Yes | * | ||
| GOBSEVS_SCHOOL_CDE | VARCHAR2(15) | Yes | |||
| GOBSEVS_PROGRAM_CDE | VARCHAR2(9) | Yes | |||
| GOBSEVS_OFFICER_ID | VARCHAR2(10) | Yes | |||
| GOBSEVS_SVEL_COMMENT | VARCHAR2(500) | Yes | |||
| GOBSEVS_SVCA_CODE | VARCHAR2(2) | Yes | * | ||
| GOBSEVS_SVCA_COMMENT | VARCHAR2(500) | Yes | |||
| GOBSEVS_VISA_ISSUE_DATE | DATE | Yes | |||
| GOBSEVS_SVGO_NAME | VARCHAR2(60) | Yes | |||
| GOBSEVS_SVGO_NAME_2 | VARCHAR2(60) | Yes | |||
| GOBSEVS_SVIO_NAME | VARCHAR2(60) | Yes | |||
| GOBSEVS_SVIO_NAME_2 | VARCHAR2(60) | Yes | |||
| GOBSEVS_OTHER_ORG_NAME | VARCHAR2(60) | Yes | |||
| GOBSEVS_SVFT_CANCEL_IND | VARCHAR2(1) | No | |||
| GOBSEVS_VERIFY_STATUS_IND | VARCHAR2(1) | No | |||
| GOBSEVS_EXTENSION_CANCEL_IND | VARCHAR2(1) | No | |||
| GOBSEVS_NOSHOW_IND | VARCHAR2(1) | No | |||
| GOBSEVS_SVSC_DESC | VARCHAR2(500) | Yes | |||
| GOBSEVS_BIRTH_NATN_REASON_CDE | VARCHAR2(2) | Yes | |||
| GOBSEVS_SVEL_CANCEL_IND | VARCHAR2(1) | No | |||
| GOBSEVS_EMPLOYER_SURNAME_PREF | VARCHAR2(60) | Yes | |||
| GOBSEVS_EMP_ADDRESS_LINE3 | VARCHAR2(75) | Yes | |||
| GOBSEVS_EMP_ADDRESS_LINE4 | VARCHAR2(75) | Yes | |||
| GOBSEVS_SVCT_CODE | VARCHAR2(3) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| GOBSEVS_BIRTH_NATN_CODE | STVNATN_CODE | STVNATN |
| GOBSEVS_LEGAL_NATN_CODE | STVNATN_CODE | STVNATN |
| GOBSEVS_NATN_CODE_PASSPORT | STVNATN_CODE | STVNATN |
| GOBSEVS_STAT_CODE_DRIVERS_LIC | STVSTAT_CODE | STVSTAT |
| GOBSEVS_SVCA_CODE | GTVSVCA_CODE | GTVSVCA |
| GOBSEVS_SVCC_CODE | GTVSVCC_CODE | GTVSVCC |
| GOBSEVS_SVCP_CODE | GTVSVCP_CODE | GTVSVCP |
| GOBSEVS_SVCR_CODE | GTVSVCR_CODE | GTVSVCR |
| GOBSEVS_SVCT_CODE | GTVSVCT_CODE | GTVSVCT |
| GOBSEVS_SVEL_CODE | GTVSVEL_CODE | GTVSVEL |
| GOBSEVS_SVEP_CODE | GTVSVEP_CODE | GTVSVEP |
| GOBSEVS_SVFT_CODE | GTVSVFT_CODE | GTVSVFT |
| GOBSEVS_SVGO_CODE | GTVSVGO_CODE | GTVSVGO |
| GOBSEVS_SVGO_CODE_2 | GTVSVGO_CODE | GTVSVGO |
| GOBSEVS_SVIO_CODE | GTVSVIO_CODE | GTVSVIO |
| GOBSEVS_SVIO_CODE_2 | GTVSVIO_CODE | GTVSVIO |
| GOBSEVS_SVIT_CODE | GTVSVIT_CODE | GTVSVIT |
| GOBSEVS_SVPC_CODE | GTVSVPC_CODE | GTVSVPC |
| GOBSEVS_SVRP_CODE | GTVSVRP_CODE | GTVSVRP |
| GOBSEVS_SVTR_CODE | GTVSVTR_CODE | GTVSVTR |
| GOBSEVS_PENT_CODE | STVPENT_CODE | STVPENT |
| GOBSEVS_MAJR_CODE | STVMAJR_CODE | STVMAJR |
| GOBSEVS_MAJR_CODE_2 | STVMAJR_CODE | STVMAJR |
| GOBSEVS_MAJR_CODE_MINR | STVMAJR_CODE | STVMAJR |
| GOBSEVS_VTYP_CODE | STVVTYP_CODE | STVVTYP |
| GOBSEVS_ATYP_CODE_ACT_SITE | STVATYP_CODE | STVATYP |
| GOBSEVS_PIDM | GORSEVS_PIDM | GORSEVS |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GOBSEVS | Unique | GOBSEVS_PIDM |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GORSVAS | SQL Table | S10B80.GENERAL | Join |
| GORSVEI | SQL Table | S10B80.GENERAL | Join |
| SPBPERS | SQL Table | S10B80.SATURN | Join |
| SPRIDEN | SQL Table | S10B80.SATURN | Join |
| GOVSVAS | SQL View | S10B80.BANINST1 | Use (select) |
| GOVSVEI | SQL View | S10B80.BANINST1 | Use (select) |
| GOVSVEV | SQL View | S10B80.BANINST1 | Use (select) |
| GOVSVSD | SQL View | S10B80.BANINST1 | Use (select) |
| GOVSVTS | SQL View | S10B80.BANINST1 | Use (select) |
| P_COMPARE_CURRENT_EV | Oracle Package Procedure | S10B80.BANINST1.GOKSVIS | Use (update) |
| P_COMPARE_CURRENT_STU | Oracle Package Procedure | S10B80.BANINST1.GOKSVIS | Use (update) |
| P_CREATE_EV | Oracle Package Procedure | S10B80.BANINST1.GOKSVSQ | Use (Insert) |
| P_CREATE_STUDENT | Oracle Package Procedure | S10B80.BANINST1.GOKSVSQ | Use (Insert) |
| P_PROCESS_IMPORT_DATA | Oracle Package Procedure | S10B80.BANINST1.GOKSVEX | Use (update) |
| P_PROCESS_SQL_RULES | Oracle Package Procedure | S10B80.BANINST1.GOKSVSQ | Use (select) |
| P_UPDATE_GOBSEVS | Oracle Package Procedure | S10B80.BANINST1.GOKSVEX | Rely On |
| P_UPDATE_GOBSEVS | Oracle Package Procedure | S10B80.BANINST1.GOKSVEX | Use (update) |
| GOBSEVS | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GOBSEVS | SQL Index | S10B80.GENERAL | Rely On |
| GORSEVS | SQL Table | S10B80.GENERAL | Join |
| GTVSVCA | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVCC | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVCP | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVCR | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVCT | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVEL | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVEP | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVFT | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVGO | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVIO | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVIT | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVPC | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVRP | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVTR | SQL Table | S10B80.GENERAL | Refer (no action) |
| STVATYP | SQL Table | S10B80.SATURN | Refer (no action) |
| STVMAJR | SQL Table | S10B80.SATURN | Refer (no action) |
| STVNATN | SQL Table | S10B80.SATURN | Refer (no action) |
| STVPENT | SQL Table | S10B80.SATURN | Refer (no action) |
| STVSTAT | SQL Table | S10B80.SATURN | Refer (no action) |
| STVVTYP | SQL Table | S10B80.SATURN | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 20:32:26:000 | 04/02/2008 21:17:56:000 |
Table GORSEVD| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GORSEVD_PIDM | NUMBER(8,0) | No | * | ||
| GORSEVD_SEQ_NO | NUMBER(2,0) | No | * | ||
| GORSEVD_RELT_CODE | VARCHAR2(3) | No | * | ||
| GORSEVD_ACTIVITY_DATE | DATE | No | |||
| GORSEVD_USER_ID | VARCHAR2(30) | No | |||
| GORSEVD_DEP_PIDM | NUMBER(8,0) | Yes | |||
| GORSEVD_DEP_LAST_NAME | VARCHAR2(60) | Yes | |||
| GORSEVD_DEP_FIRST_NAME | VARCHAR2(60) | Yes | |||
| GORSEVD_DEP_MIDDLE_NAME | VARCHAR2(60) | Yes | |||
| GORSEVD_DEP_BIRTH_NATN_CODE | VARCHAR2(5) | Yes | * | ||
| GORSEVD_DEP_LEGAL_NATN_CODE | VARCHAR2(5) | Yes | * | ||
| GORSEVD_DEP_BIRTH_DATE | DATE | Yes | |||
| GORSEVD_DEP_SEVIS_ID | VARCHAR2(11) | Yes | |||
| GORSEVD_SVDT_CODE | VARCHAR2(2) | Yes | * | ||
| GORSEVD_GENDER | VARCHAR2(1) | Yes | |||
| GORSEVD_VTYP_CODE | VARCHAR2(2) | Yes | * | ||
| GORSEVD_DEP_BIRTH_CITY | VARCHAR2(200) | Yes | |||
| GORSEVD_NATN_CODE_PERM_RES | VARCHAR2(5) | Yes | * | ||
| GORSEVD_TERMINATE_EFF_DATE | DATE | Yes | |||
| GORSEVD_DEP_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVD_SVDT_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVD_DEP_NAME_SUFFIX | VARCHAR2(3) | Yes | |||
| GORSEVD_CANCEL_CDE | VARCHAR2(2) | Yes | |||
| GORSEVD_REPRINT_REQUEST_IND | VARCHAR2(1) | No | |||
| GORSEVD_DELETE_IND | VARCHAR2(1) | No | |||
| GORSEVD_SVRP_CODE | VARCHAR2(2) | Yes | |||
| GORSEVD_SVRP_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVD_BIRTH_NATN_REASON_CDE | VARCHAR2(2) | Yes | |||
| GORSEVD_FORM_PURPOSE_CDE | VARCHAR2(2) | Yes | |||
| GORSEVD_DEP_SURNAME_PREFIX | VARCHAR2(60) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| GORSEVD_DEP_BIRTH_NATN_CODE | STVNATN_CODE | STVNATN |
| GORSEVD_DEP_LEGAL_NATN_CODE | STVNATN_CODE | STVNATN |
| GORSEVD_NATN_CODE_PERM_RES | STVNATN_CODE | STVNATN |
| GORSEVD_SVDT_CODE | GTVSVDT_CODE | GTVSVDT |
| GORSEVD_RELT_CODE | STVRELT_CODE | STVRELT |
| GORSEVD_VTYP_CODE | STVVTYP_CODE | STVVTYP |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GORSEVD | Unique | GORSEVD_PIDM |
| PK_GORSEVD | Unique | GORSEVD_SEQ_NO |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| SPBPERS | SQL Table | S10B80.SATURN | Join |
| SPRIDEN | SQL Table | S10B80.SATURN | Join |
| GOVSVDP | SQL View | S10B80.BANINST1 | Use (select) |
| P_COMPARE_CURRENT_DEP | Oracle Package Procedure | S10B80.BANINST1.GOKSVIS | Use (update,delete) |
| P_CREATE_DEP_ROW | Oracle Package Procedure | S10B80.BANINST1.GOKSVIS | Rely On |
| P_PROCESS_IMPORT_DATA | Oracle Package Procedure | S10B80.BANINST1.GOKSVEX | Use (update) |
| P_SELECT_CURRENT_DEP | Oracle Package Procedure | S10B80.BANINST1.GOKSVIS | Rely On |
| P_SELECT_GOVSVDP | Oracle Package Procedure | S10B80.BANINST1.GOKSVIS | Rely On |
| GORSEVD | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GORSEVD | SQL Index | S10B80.GENERAL | Rely On |
| GTVSVDT | SQL Table | S10B80.GENERAL | Refer (no action) |
| STVNATN | SQL Table | S10B80.SATURN | Refer (no action) |
| STVRELT | SQL Table | S10B80.SATURN | Refer (no action) |
| STVVTYP | SQL Table | S10B80.SATURN | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 20:29:22:000 | 04/02/2008 21:17:52:000 |
Table GORSEVH| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GORSEVH_PIDM | NUMBER(8,0) | No | * | * | |
| GORSEVH_SEVIS_SEQ_NO | NUMBER(3,0) | No | * | * | |
| GORSEVH_SEQ_NO | NUMBER(3,0) | No | * | ||
| GORSEVH_RELT_CDE | VARCHAR2(3) | No | |||
| GORSEVH_ACTIVITY_DATE | DATE | No | |||
| GORSEVH_USER_ID | VARCHAR2(30) | No | |||
| GORSEVH_DEP_PIDM | NUMBER(8,0) | Yes | |||
| GORSEVH_DEP_LAST_NAME | VARCHAR2(60) | Yes | |||
| GORSEVH_DEP_FIRST_NAME | VARCHAR2(60) | Yes | |||
| GORSEVH_DEP_MIDDLE_NAME | VARCHAR2(60) | Yes | |||
| GORSEVH_DEP_BIRTH_NATN_CDE | VARCHAR2(2) | Yes | |||
| GORSEVH_DEP_LEGAL_NATN_CDE | VARCHAR2(2) | Yes | |||
| GORSEVH_DEP_BIRTH_DATE | DATE | Yes | |||
| GORSEVH_DEP_SEVIS_ID | VARCHAR2(11) | Yes | |||
| GORSEVH_SVDT_CODE | VARCHAR2(2) | Yes | * | ||
| GORSEVH_GENDER | VARCHAR2(1) | Yes | |||
| GORSEVH_VTYP_CDE | VARCHAR2(2) | Yes | |||
| GORSEVH_DEP_BIRTH_CITY | VARCHAR2(200) | Yes | |||
| GORSEVH_NATN_CDE_PERM_RES | VARCHAR2(2) | Yes | |||
| GORSEVH_TERMINATE_EFF_DATE | DATE | Yes | |||
| GORSEVH_DEP_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVH_SVDT_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVH_DEP_NAME_SUFFIX | VARCHAR2(3) | Yes | |||
| GORSEVH_CANCEL_CDE | VARCHAR2(2) | Yes | |||
| GORSEVH_REPRINT_REQUEST_IND | VARCHAR2(1) | No | |||
| GORSEVH_DELETE_IND | VARCHAR2(1) | No | |||
| GORSEVH_SVRP_CODE | VARCHAR2(2) | Yes | |||
| GORSEVH_SVRP_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVH_BIRTH_NATN_REASON_CDE | VARCHAR2(2) | Yes | |||
| GORSEVH_FORM_PURPOSE_CDE | VARCHAR2(2) | Yes | |||
| GORSEVH_DEP_SURNAME_PREFIX | VARCHAR2(60) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| GORSEVH_PIDM | GORSEVS_PIDM | GORSEVS |
| GORSEVH_SEVIS_SEQ_NO | GORSEVS_SEQ_NO | GORSEVS |
| GORSEVH_SVDT_CODE | GTVSVDT_CODE | GTVSVDT |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GORSEVH | Unique | GORSEVH_PIDM |
| PK_GORSEVH | Unique | GORSEVH_SEVIS_SEQ_NO |
| PK_GORSEVH | Unique | GORSEVH_SEQ_NO |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| P_COMPARE_CURRENT_DEP | Oracle Package Procedure | S10B80.BANINST1.GOKSVIS | Rely On |
| P_CREATE_GORSEVH | Oracle Package Procedure | S10B80.BANINST1.GOKSVIS | Rely On |
| P_GORSEVH_INSERT | Oracle Package Procedure | S10B80.BANINST1.GOKSVIS | Rely On |
| P_GORSEVH_INSERT | Oracle Package Procedure | S10B80.BANINST1.GOKSVIS | Use (Insert) |
| P_GORSEVH_INSERT_ALL | Oracle Package Procedure | S10B80.BANINST1.GOKSVIS | Rely On |
| P_GORSEVH_INSERT_DEP_ROWS | Oracle Package Procedure | S10B80.BANINST1.GOKSVIS | Rely On |
| P_GORSEVH_INSERT_DEP_ROWS | Oracle Package Procedure | S10B80.BANINST1.GOKSVIS | Use (select)Rely On |
| P_GORSEVH_INSERT_ONE | Oracle Package Procedure | S10B80.BANINST1.GOKSVIS | Rely On |
| P_GORSEVH_INSERT_ONE | Oracle Package Procedure | S10B80.BANINST1.GOKSVIS | Use (select) |
| P_SELECT_CURRENT_DEP | Oracle Package Procedure | S10B80.BANINST1.GOKSVIS | Rely On |
| P_SELECT_CURRENT_DEP | Oracle Package Procedure | S10B80.BANINST1.GOKSVIS | Use (select)Rely On |
| GORSEVH | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GORSEVH | SQL Index | S10B80.GENERAL | Rely On |
| GORSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVDT | SQL Table | S10B80.GENERAL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 20:29:24:000 | 04/02/2008 21:17:53:000 |
Table GORSEVS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GORSEVS_PIDM | NUMBER(8,0) | No | * | ||
| GORSEVS_SEQ_NO | NUMBER(3,0) | No | * | ||
| GORSEVS_SUBMIT_DATE | DATE | No | |||
| GORSEVS_ENG_PROF_REQ_IND | VARCHAR2(1) | No | |||
| GORSEVS_ENG_PROF_MET_IND | VARCHAR2(1) | No | |||
| GORSEVS_CRIMINAL_CONVICT_IND | VARCHAR2(1) | No | |||
| GORSEVS_TERMINATE_STUDENT_IND | VARCHAR2(1) | No | |||
| GORSEVS_EXTEND_FAILURE_IND | VARCHAR2(1) | No | |||
| GORSEVS_TRANSFER_FAIL_IND | VARCHAR2(1) | No | |||
| GORSEVS_APPROVAL_FAIL_IND | VARCHAR2(1) | No | |||
| GORSEVS_OTHER_INFRACT_IND | VARCHAR2(1) | No | |||
| GORSEVS_TRANS_CDE | VARCHAR2(10) | Yes | |||
| GORSEVS_ACTIVITY_DATE | DATE | No | |||
| GORSEVS_USER_ID | VARCHAR2(30) | No | |||
| GORSEVS_FIRST_NAME | VARCHAR2(60) | Yes | |||
| GORSEVS_MI | VARCHAR2(60) | Yes | |||
| GORSEVS_LAST_NAME | VARCHAR2(60) | Yes | |||
| GORSEVS_BIRTH_DATE | DATE | Yes | |||
| GORSEVS_BIRTH_NATN_CDE | VARCHAR2(2) | Yes | |||
| GORSEVS_LEGAL_NATN_CDE | VARCHAR2(2) | Yes | |||
| GORSEVS_USA_STREET_LINE1 | VARCHAR2(75) | Yes | |||
| GORSEVS_USA_STREET_LINE2 | VARCHAR2(75) | Yes | |||
| GORSEVS_USA_CITY | VARCHAR2(60) | Yes | |||
| GORSEVS_USA_STAT_CODE | VARCHAR2(2) | Yes | * | ||
| GORSEVS_USA_ZIP | VARCHAR2(30) | Yes | |||
| GORSEVS_NONUSA_STREET_LINE1 | VARCHAR2(75) | Yes | |||
| GORSEVS_NONUSA_STREET_LINE2 | VARCHAR2(75) | Yes | |||
| GORSEVS_NONUSA_CITY | VARCHAR2(60) | Yes | |||
| GORSEVS_NONUSA_STATE | VARCHAR2(34) | Yes | |||
| GORSEVS_NONUSA_ZIP | VARCHAR2(30) | Yes | |||
| GORSEVS_NONUSA_NATN_CDE | VARCHAR2(2) | Yes | |||
| GORSEVS_PROGRAM_BEGIN_DATE | DATE | Yes | |||
| GORSEVS_PROGRAM_END_DATE | DATE | Yes | |||
| GORSEVS_PROGRAM_ENROLL_DATE | DATE | Yes | |||
| GORSEVS_ENG_PROF_REASON | VARCHAR2(500) | Yes | |||
| GORSEVS_ACADEMIC_TERM_MONTHS | NUMBER(3,0) | Yes | |||
| GORSEVS_TUITION_EXPENSE | NUMBER(17,2) | Yes | |||
| GORSEVS_PERSONAL_FUNDS | NUMBER(17,2) | Yes | |||
| GORSEVS_SEVIS_ID | VARCHAR2(11) | Yes | |||
| GORSEVS_VTYP_CDE | VARCHAR2(2) | Yes | |||
| GORSEVS_SVCR_CODE | VARCHAR2(4) | Yes | * | ||
| GORSEVS_SESSION_START_DATE | DATE | Yes | |||
| GORSEVS_SESSION_END_DATE | DATE | Yes | |||
| GORSEVS_TRANSFER_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVS_ISSUE_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVS_SVEL_CODE | VARCHAR2(2) | Yes | * | ||
| GORSEVS_MAJR_CDE | VARCHAR2(7) | Yes | |||
| GORSEVS_STUDY_LENGTH | NUMBER(3,0) | Yes | |||
| GORSEVS_LIVING_EXPENSES | NUMBER(17,2) | Yes | |||
| GORSEVS_SVFT_CODE | VARCHAR2(2) | Yes | * | ||
| GORSEVS_AUTH_START_DATE | DATE | Yes | |||
| GORSEVS_COMPLETION_REMARKS | VARCHAR2(500) | Yes | |||
| GORSEVS_NEW_PROGRAM_END_DATE | DATE | Yes | |||
| GORSEVS_DA_PROGRAM_START_DATE | DATE | Yes | |||
| GORSEVS_DA_PROGRAM_END_DATE | DATE | Yes | |||
| GORSEVS_DISC_ACTION_TEXT | VARCHAR2(500) | Yes | |||
| GORSEVS_EMPLOYMENT_CDE | VARCHAR2(2) | Yes | |||
| GORSEVS_EMPLOYMENT_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVS_EMPLOYMENT_START_DATE | DATE | Yes | |||
| GORSEVS_EMPLOYMENT_END_DATE | DATE | Yes | |||
| GORSEVS_EMPLOYMENT_TYPE_CDE | VARCHAR2(2) | Yes | |||
| GORSEVS_EMPLOYER_LAST_NAME | VARCHAR2(500) | Yes | |||
| GORSEVS_EMPLOYER_FIRST_NAME | VARCHAR2(60) | Yes | |||
| GORSEVS_EMP_ADDRESS_LINE1 | VARCHAR2(75) | Yes | |||
| GORSEVS_EMP_ADDRESS_LINE2 | VARCHAR2(75) | Yes | |||
| GORSEVS_EMPLOYER_CITY | VARCHAR2(60) | Yes | |||
| GORSEVS_EMPLOYER_STATE | VARCHAR2(2) | Yes | |||
| GORSEVS_EMPLOYER_ZIP | VARCHAR2(30) | Yes | |||
| GORSEVS_COURSE_RELEVANCE | VARCHAR2(500) | Yes | |||
| GORSEVS_EXTEND_END_DATE | DATE | Yes | |||
| GORSEVS_SVTR_CODE | VARCHAR2(6) | Yes | * | ||
| GORSEVS_TERMINATE_DATE | DATE | Yes | |||
| GORSEVS_APPROVAL_FAIL_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVS_OTHER_INFRACT_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVS_SVEP_CODE | VARCHAR2(4) | Yes | * | ||
| GORSEVS_END_PROGRAM_EFF_DATE | DATE | Yes | |||
| GORSEVS_EV_FORM_NUMBER | VARCHAR2(40) | Yes | |||
| GORSEVS_SVRP_CODE | VARCHAR2(2) | Yes | * | ||
| GORSEVS_REPRINT_REASON_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVS_CREATE_DATE | DATE | Yes | |||
| GORSEVS_STATUS_CDE | VARCHAR2(20) | Yes | |||
| GORSEVS_RESULT_CODE_MESSAGE | VARCHAR2(500) | Yes | |||
| GORSEVS_SVTS_CODE | VARCHAR2(1) | No | * | ||
| GORSEVS_SVCR_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVS_PRINT_REQUEST_IND | VARCHAR2(1) | No | |||
| GORSEVS_DEPENDENT_EXPENSES | NUMBER(17,2) | Yes | |||
| GORSEVS_OTHER_FUNDS | NUMBER(17,2) | Yes | |||
| GORSEVS_OTHER_FUNDS_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVS_OTHER_EXPENSES | NUMBER(17,2) | Yes | |||
| GORSEVS_OTHER_EXP_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVS_AUTH_END_DATE | DATE | Yes | |||
| GORSEVS_NEW_PROGRAM_START_DATE | DATE | Yes | |||
| GORSEVS_SVPC_CODE | VARCHAR2(3) | Yes | * | ||
| GORSEVS_SVSC_CODE | VARCHAR2(7) | Yes | |||
| GORSEVS_SVSC_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVS_GENDER | VARCHAR2(1) | Yes | |||
| GORSEVS_NAME_SUFFIX | VARCHAR2(3) | Yes | |||
| GORSEVS_COMMUTER_IND | VARCHAR2(1) | No | |||
| GORSEVS_ADMISSION_NUMBER | VARCHAR2(11) | Yes | |||
| GORSEVS_DRIVERS_LIC_NUMBER | VARCHAR2(30) | Yes | |||
| GORSEVS_STAT_CODE_DRIVERS_LIC | VARCHAR2(2) | Yes | * | ||
| GORSEVS_SSN | VARCHAR2(15) | Yes | |||
| GORSEVS_TIN | VARCHAR2(15) | Yes | |||
| GORSEVS_MAJR_CDE_2 | VARCHAR2(7) | Yes | |||
| GORSEVS_MAJR_CDE_MINR | VARCHAR2(7) | Yes | |||
| GORSEVS_SCHOOL_FUNDS | NUMBER(17,2) | Yes | |||
| GORSEVS_SCHOOL_FUNDS_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVS_EMPLOYMENT_FUNDS | NUMBER(17,2) | Yes | |||
| GORSEVS_FUNDING_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVS_SVFT_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVS_SVEP_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVS_DA_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVS_SVTR_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVS_PASSPORT_NUMBER | VARCHAR2(25) | Yes | |||
| GORSEVS_NATN_CDE_PASSPORT | VARCHAR2(2) | Yes | |||
| GORSEVS_PASSPORT_EXPIRE_DATE | DATE | Yes | |||
| GORSEVS_VISA_NUMBER | VARCHAR2(25) | Yes | |||
| GORSEVS_SVCP_CODE | VARCHAR2(3) | Yes | |||
| GORSEVS_VISA_EXPIRE_DATE | DATE | Yes | |||
| GORSEVS_PENT_CDE | VARCHAR2(3) | Yes | |||
| GORSEVS_PENT_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVS_ENTRY_DATE | DATE | Yes | |||
| GORSEVS_EMPL_AUTH_IND | VARCHAR2(1) | No | |||
| GORSEVS_RESCIND_REC_IND | VARCHAR2(1) | No | |||
| GORSEVS_RFC_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVS_EDIT_PROGRAM_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVS_EMPLOYMENT_TIME_CDE | VARCHAR2(2) | Yes | |||
| GORSEVS_ACT_SITE_ADDR_LINE1 | VARCHAR2(75) | Yes | |||
| GORSEVS_ACT_SITE_ADDR_LINE2 | VARCHAR2(75) | Yes | |||
| GORSEVS_ACT_SITE_CITY | VARCHAR2(60) | Yes | |||
| GORSEVS_STAT_CODE_ACT_SITE | VARCHAR2(2) | Yes | * | ||
| GORSEVS_ACT_SITE_ZIP | VARCHAR2(30) | Yes | |||
| GORSEVS_PROGRAM_SPONSOR_FUNDS | NUMBER(17,2) | Yes | |||
| GORSEVS_GOVT_ORG_FUNDS | NUMBER(17,2) | Yes | |||
| GORSEVS_SVGO_CODE | VARCHAR2(6) | Yes | * | ||
| GORSEVS_GOVT_ORG_FUNDS_2 | NUMBER(17,2) | Yes | |||
| GORSEVS_SVGO_CODE_2 | VARCHAR2(6) | Yes | * | ||
| GORSEVS_INTL_ORG_FUNDS | NUMBER(17,2) | Yes | |||
| GORSEVS_SVIO_CODE | VARCHAR2(6) | Yes | * | ||
| GORSEVS_INTL_ORG_FUNDS_2 | NUMBER(17,2) | Yes | |||
| GORSEVS_SVIO_CODE_2 | VARCHAR2(6) | Yes | * | ||
| GORSEVS_EV_GOVT_FUNDS | NUMBER(17,2) | Yes | |||
| GORSEVS_BINATION_FUNDS | NUMBER(17,2) | Yes | |||
| GORSEVS_OTHER_ORG_FUNDS | NUMBER(17,2) | Yes | |||
| GORSEVS_PROGRAM_START_IND | VARCHAR2(1) | No | |||
| GORSEVS_EXTEND_PROGRAM_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVS_AMEND_PROGRAM_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVS_MATRICULATION_CDE | VARCHAR2(2) | Yes | |||
| GORSEVS_EXTEND_FAILURE_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVS_CONCLUDE_TRANS_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVS_BIRTH_CITY | VARCHAR2(200) | Yes | |||
| GORSEVS_NATN_CDE_PERM_RES | VARCHAR2(2) | Yes | |||
| GORSEVS_EDIT_BIO_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVS_STRUCTURE_UPDATE | VARCHAR2(40) | Yes | |||
| GORSEVS_ZIP_ROUTING_CDE | VARCHAR2(4) | Yes | |||
| GORSEVS_US_FUNDS_IND | VARCHAR2(1) | No | |||
| GORSEVS_FIN_SUPPORT_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVS_SVIT_CODE | VARCHAR2(3) | Yes | |||
| GORSEVS_ACT_SITE_NAME | VARCHAR2(60) | Yes | |||
| GORSEVS_ACT_SITE_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVS_SVCC_CODE | VARCHAR2(3) | Yes | * | ||
| GORSEVS_SVEL_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVS_REQUEST_ID | VARCHAR2(20) | Yes | |||
| GORSEVS_SCHOOL_CDE | VARCHAR2(15) | Yes | |||
| GORSEVS_PROGRAM_CDE | VARCHAR2(9) | Yes | |||
| GORSEVS_OFFICER_ID | VARCHAR2(10) | Yes | |||
| GORSEVS_SVFT_CANCEL_IND | VARCHAR2(1) | No | |||
| GORSEVS_SVCA_CODE | VARCHAR2(2) | Yes | * | ||
| GORSEVS_SVCA_COMMENT | VARCHAR2(500) | Yes | |||
| GORSEVS_VERIFY_STATUS_IND | VARCHAR2(1) | No | |||
| GORSEVS_EXTENSION_CANCEL_IND | VARCHAR2(1) | No | |||
| GORSEVS_VISA_ISSUE_DATE | DATE | Yes | |||
| GORSEVS_PRIOR_SVFT_CODE | VARCHAR2(2) | Yes | |||
| GORSEVS_PRIOR_AUTH_START_DATE | DATE | Yes | |||
| GORSEVS_PRIOR_AUTH_END_DATE | DATE | Yes | |||
| GORSEVS_SVGO_NAME | VARCHAR2(60) | Yes | |||
| GORSEVS_SVGO_NAME_2 | VARCHAR2(60) | Yes | |||
| GORSEVS_SVIO_NAME | VARCHAR2(60) | Yes | |||
| GORSEVS_SVIO_NAME_2 | VARCHAR2(60) | Yes | |||
| GORSEVS_OTHER_ORG_NAME | VARCHAR2(60) | Yes | |||
| GORSEVS_NOSHOW_IND | VARCHAR2(1) | No | |||
| GORSEVS_BIRTH_NATN_REASON_CDE | VARCHAR2(2) | Yes | |||
| GORSEVS_SEVIS_RECORD_STATUS | VARCHAR2(10) | Yes | |||
| GORSEVS_SVSC_DESC | VARCHAR2(500) | Yes | |||
| GORSEVS_SVEL_CANCEL_IND | VARCHAR2(1) | No | |||
| GORSEVS_ACT_SITE_ADDR_LINE3 | VARCHAR2(75) | Yes | |||
| GORSEVS_ACT_SITE_ADDR_LINE4 | VARCHAR2(75) | Yes | |||
| GORSEVS_EMPLOYER_SURNAME_PREF | VARCHAR2(60) | Yes | |||
| GORSEVS_EMP_ADDRESS_LINE3 | VARCHAR2(75) | Yes | |||
| GORSEVS_EMP_ADDRESS_LINE4 | VARCHAR2(75) | Yes | |||
| GORSEVS_HOUSE_NUMBER | VARCHAR2(10) | Yes | |||
| GORSEVS_NONUSA_STREET_LINE3 | VARCHAR2(75) | Yes | |||
| GORSEVS_NONUSA_STREET_LINE4 | VARCHAR2(75) | Yes | |||
| GORSEVS_SURNAME_PREFIX | VARCHAR2(60) | Yes | |||
| GORSEVS_USA_STREET_LINE3 | VARCHAR2(75) | Yes | |||
| GORSEVS_USA_STREET_LINE4 | VARCHAR2(75) | Yes | |||
| GORSEVS_SVCT_CODE | VARCHAR2(3) | Yes | * |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| GORSEVS_USA_STAT_CODE | STVSTAT_CODE | STVSTAT |
| GORSEVS_STAT_CODE_DRIVERS_LIC | STVSTAT_CODE | STVSTAT |
| GORSEVS_STAT_CODE_ACT_SITE | STVSTAT_CODE | STVSTAT |
| GORSEVS_SVCA_CODE | GTVSVCA_CODE | GTVSVCA |
| GORSEVS_SVCC_CODE | GTVSVCC_CODE | GTVSVCC |
| GORSEVS_SVCR_CODE | GTVSVCR_CODE | GTVSVCR |
| GORSEVS_SVCT_CODE | GTVSVCT_CODE | GTVSVCT |
| GORSEVS_SVEL_CODE | GTVSVEL_CODE | GTVSVEL |
| GORSEVS_SVEP_CODE | GTVSVEP_CODE | GTVSVEP |
| GORSEVS_SVFT_CODE | GTVSVFT_CODE | GTVSVFT |
| GORSEVS_SVGO_CODE | GTVSVGO_CODE | GTVSVGO |
| GORSEVS_SVGO_CODE_2 | GTVSVGO_CODE | GTVSVGO |
| GORSEVS_SVIO_CODE | GTVSVIO_CODE | GTVSVIO |
| GORSEVS_SVIO_CODE_2 | GTVSVIO_CODE | GTVSVIO |
| GORSEVS_SVPC_CODE | GTVSVPC_CODE | GTVSVPC |
| GORSEVS_SVRP_CODE | GTVSVRP_CODE | GTVSVRP |
| GORSEVS_SVTR_CODE | GTVSVTR_CODE | GTVSVTR |
| GORSEVS_SVTS_CODE | GTVSVTS_CODE | GTVSVTS |
| Index Name | Index Type | Column Name |
|---|---|---|
| GORSEVS_KEY_INDEX | GORSEVS_SVTS_CODE | |
| GORSEVS_KEY_INDEX2 | Unique | GORSEVS_REQUEST_ID |
| PK_GORSEVS | Unique | GORSEVS_PIDM |
| PK_GORSEVS | Unique | GORSEVS_SEQ_NO |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GORSEVS_KEY_INDEX | SQL Index | S10B80.GENERAL | Rely On |
| GORSEVS_KEY_INDEX2 | SQL Index | S10B80.GENERAL | Rely On |
| PK_GORSEVS | SQL Index | S10B80.GENERAL | Rely On |
| GTVSVCA | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVCC | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVCR | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVCT | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVEL | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVEP | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVFT | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVGO | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVIO | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVPC | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVRP | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVTR | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVTS | SQL Table | S10B80.GENERAL | Refer (no action) |
| STVSTAT | SQL Table | S10B80.SATURN | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 20:29:27:000 | 04/02/2008 21:17:53:000 |
Table GORSVAH| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GORSVAH_PIDM | NUMBER(8,0) | No | * | * | |
| GORSVAH_SEVIS_SEQ_NO | NUMBER(3,0) | No | * | * | |
| GORSVAH_SEQ_NO | NUMBER(3,0) | No | * | ||
| GORSVAH_ACT_SITE_NAME | VARCHAR2(60) | No | |||
| GORSVAH_TERMINATION_IND | VARCHAR2(1) | No | |||
| GORSVAH_ACTIVITY_DATE | DATE | No | |||
| GORSVAH_USER_ID | VARCHAR2(30) | No | |||
| GORSVAH_STREET_LINE1 | VARCHAR2(75) | Yes | |||
| GORSVAH_STREET_LINE2 | VARCHAR2(75) | Yes | |||
| GORSVAH_CITY | VARCHAR2(60) | Yes | |||
| GORSVAH_STAT_CODE | VARCHAR2(2) | Yes | |||
| GORSVAH_ZIP | VARCHAR2(30) | Yes | |||
| GORSVAH_ROUTING_CDE | VARCHAR2(4) | Yes | |||
| GORSVAH_ACT_SITE_COMMENT | VARCHAR2(500) | Yes | |||
| GORSVAH_PRIMARY_SITE_IND | VARCHAR2(1) | No | |||
| GORSVAH_PRIOR_SITE_NAME | VARCHAR2(60) | Yes | |||
| GORSVAH_HOUSE_NUMBER | VARCHAR2(10) | Yes | |||
| GORSVAH_STREET_LINE3 | VARCHAR2(75) | Yes | |||
| GORSVAH_STREET_LINE4 | VARCHAR2(75) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| GORSVAH_PIDM | GORSEVS_PIDM | GORSEVS |
| GORSVAH_SEVIS_SEQ_NO | GORSEVS_SEQ_NO | GORSEVS |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GORSVAH | Unique | GORSVAH_PIDM |
| PK_GORSVAH | Unique | GORSVAH_SEVIS_SEQ_NO |
| PK_GORSVAH | Unique | GORSVAH_SEQ_NO |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GORSVAH | SQL Index | S10B80.GENERAL | Rely On |
| GORSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 20:30:42:000 | 04/02/2008 21:17:54:000 |
Table GORSVAS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GORSVAS_PIDM | NUMBER(8,0) | No | * | * | |
| GORSVAS_SEQ_NO | NUMBER(3,0) | No | * | ||
| GORSVAS_ACT_SITE_NAME | VARCHAR2(60) | No | |||
| GORSVAS_TERMINATION_IND | VARCHAR2(1) | No | |||
| GORSVAS_ACTIVITY_DATE | DATE | No | |||
| GORSVAS_USER_ID | VARCHAR2(30) | No | |||
| GORSVAS_ACT_SITE_PIDM | NUMBER(8,0) | Yes | |||
| GORSVAS_ATYP_CODE | VARCHAR2(2) | Yes | * | ||
| GORSVAS_STREET_LINE1 | VARCHAR2(75) | Yes | |||
| GORSVAS_STREET_LINE2 | VARCHAR2(75) | Yes | |||
| GORSVAS_CITY | VARCHAR2(60) | Yes | |||
| GORSVAS_STAT_CODE | VARCHAR2(3) | Yes | * | ||
| GORSVAS_ZIP | VARCHAR2(30) | Yes | |||
| GORSVAS_ACT_SITE_COMMENT | VARCHAR2(500) | Yes | |||
| GORSVAS_PRIMARY_SITE_IND | VARCHAR2(1) | No | |||
| GORSVAS_HOUSE_NUMBER | VARCHAR2(10) | Yes | |||
| GORSVAS_STREET_LINE3 | VARCHAR2(75) | Yes | |||
| GORSVAS_STREET_LINE4 | VARCHAR2(75) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| GORSVAS_STAT_CODE | STVSTAT_CODE | STVSTAT |
| GORSVAS_ATYP_CODE | STVATYP_CODE | STVATYP |
| GORSVAS_PIDM | GOBSEVS_PIDM | GOBSEVS |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GORSVAS | Unique | GORSVAS_PIDM |
| PK_GORSVAS | Unique | GORSVAS_SEQ_NO |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| SPRADDR | SQL Table | S10B80.SATURN | Join |
| SPRIDEN | SQL Table | S10B80.SATURN | Join |
| GOVSVAS | SQL View | S10B80.BANINST1 | Use (select) |
| P_CREATE_ACT_ROW | Oracle Package Procedure | S10B80.BANINST1.GOKSVIS | Rely On |
| P_CREATE_HISTORY | Oracle Package Procedure | S10B80.BANINST1.GOKSVIS | Use (select) |
| P_SELECT_CURRENT_ACT_SITE | Oracle Package Procedure | S10B80.BANINST1.GOKSVIS | Rely On |
| P_SELECT_GOVSVAS | Oracle Package Procedure | S10B80.BANINST1.GOKSVIS | Rely On |
| GORSVAS | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GORSVAS | SQL Index | S10B80.GENERAL | Rely On |
| GOBSEVS | SQL Table | S10B80.GENERAL | Join |
| STVATYP | SQL Table | S10B80.SATURN | Refer (no action) |
| STVSTAT | SQL Table | S10B80.SATURN | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 20:30:43:000 | 04/02/2008 21:17:54:000 |
Table GORSVEI| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GORSVEI_PIDM | NUMBER(8,0) | No | * | * | |
| GORSVEI_SEQ_NO | NUMBER(3,0) | No | * | ||
| GORSVEI_EMP_AUTH_IND | VARCHAR2(1) | No | |||
| GORSVEI_EMPLOYMENT_TYPE_CDE | VARCHAR2(2) | No | |||
| GORSVEI_ACTIVITY_DATE | DATE | No | |||
| GORSVEI_USER_ID | VARCHAR2(30) | No | |||
| GORSVEI_EMPLOYER_NAME | VARCHAR2(500) | Yes | |||
| GORSVEI_EMPLOYMENT_CDE | VARCHAR2(2) | Yes | |||
| GORSVEI_EMPLOYMENT_TIME_CDE | VARCHAR2(2) | Yes | |||
| GORSVEI_START_DATE | DATE | Yes | |||
| GORSVEI_END_DATE | DATE | Yes | |||
| GORSVEI_EMPLOYER_PIDM | NUMBER(8,0) | Yes | |||
| GORSVEI_ATYP_CODE | VARCHAR2(2) | Yes | * | ||
| GORSVEI_STREET_LINE1 | VARCHAR2(75) | Yes | |||
| GORSVEI_STREET_LINE2 | VARCHAR2(75) | Yes | |||
| GORSVEI_CITY | VARCHAR2(60) | Yes | |||
| GORSVEI_STAT_CODE | VARCHAR2(3) | Yes | * | ||
| GORSVEI_ZIP | VARCHAR2(30) | Yes | |||
| GORSVEI_COURSE_RELEVANCE | VARCHAR2(500) | Yes | |||
| GORSVEI_EMPLOYMENT_COMMENT | VARCHAR2(500) | Yes | |||
| GORSVEI_RECOMMENDATION | VARCHAR2(500) | Yes | |||
| GORSVEI_OPT_ACAD_YR_MET_IND | VARCHAR2(1) | No | |||
| GORSVEI_CANCEL_IND | VARCHAR2(1) | No | |||
| GORSVEI_HOUSE_NUMBER | VARCHAR2(10) | Yes | |||
| GORSVEI_STREET_LINE3 | VARCHAR2(75) | Yes | |||
| GORSVEI_STREET_LINE4 | VARCHAR2(75) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| GORSVEI_STAT_CODE | STVSTAT_CODE | STVSTAT |
| GORSVEI_ATYP_CODE | STVATYP_CODE | STVATYP |
| GORSVEI_PIDM | GOBSEVS_PIDM | GOBSEVS |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GORSVEI | Unique | GORSVEI_PIDM |
| PK_GORSVEI | Unique | GORSVEI_SEQ_NO |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| SPRADDR | SQL Table | S10B80.SATURN | Join |
| SPRIDEN | SQL Table | S10B80.SATURN | Join |
| GOVSVEI | SQL View | S10B80.BANINST1 | Use (select) |
| P_CREATE_EMP_ROW | Oracle Package Procedure | S10B80.BANINST1.GOKSVIS | Rely On |
| P_CREATE_HISTORY | Oracle Package Procedure | S10B80.BANINST1.GOKSVIS | Use (select) |
| P_SELECT_CURRENT_EMP_INFO | Oracle Package Procedure | S10B80.BANINST1.GOKSVIS | Rely On |
| P_SELECT_GOVSVEI | Oracle Package Procedure | S10B80.BANINST1.GOKSVIS | Rely On |
| GORSVEI | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GORSVEI | SQL Index | S10B80.GENERAL | Rely On |
| GOBSEVS | SQL Table | S10B80.GENERAL | Join |
| STVATYP | SQL Table | S10B80.SATURN | Refer (no action) |
| STVSTAT | SQL Table | S10B80.SATURN | Refer (no action) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 20:30:52:000 | 04/02/2008 21:17:54:000 |
Table GTVSVCC| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GTVSVCC_CODE | VARCHAR2(3) | No | * | ||
| GTVSVCC_DESC | VARCHAR2(60) | No | |||
| GTVSVCC_ACTIVITY_DATE | DATE | No | |||
| GTVSVCC_USER_ID | VARCHAR2(30) | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GTVSVCC | Unique | GTVSVCC_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GOBSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
| GORSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
| GOVSVEV | SQL View | S10B80.BANINST1 | Use (select) |
| GTVSVCC_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVCC | Rely On |
| GTVSVCC_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVCC | Use (select)Rely On |
| F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_GTVSVCC | Rely On |
| F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_GTVSVCC | Rely On |
| GTVSVCC | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GTVSVCC | SQL Index | S10B80.GENERAL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 20:33:11:000 | 04/02/2008 21:17:57:000 |
Table GTVSVCP| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GTVSVCP_CODE | VARCHAR2(3) | No | * | ||
| GTVSVCP_DESC | VARCHAR2(30) | No | |||
| GTVSVCP_ACTIVITY_DATE | DATE | No | |||
| GTVSVCP_USER_ID | VARCHAR2(30) | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GTVSVCP | Unique | GTVSVCP_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GOBSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
| GOVSVSD | SQL View | S10B80.BANINST1 | Use (select) |
| GTVSVCP_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVCP | Rely On |
| GTVSVCP_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVCP | Use (select)Rely On |
| F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_GTVSVCP | Rely On |
| F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_GTVSVCP | Rely On |
| GTVSVCP | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GTVSVCP | SQL Index | S10B80.GENERAL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 20:33:12:000 | 04/02/2008 21:17:57:000 |
Table GTVSVCR| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GTVSVCR_CODE | VARCHAR2(4) | No | * | ||
| GTVSVCR_DESC | VARCHAR2(30) | No | |||
| GTVSVCR_USAGE_IND | VARCHAR2(1) | No | |||
| GTVSVCR_ACTIVITY_DATE | DATE | No | |||
| GTVSVCR_USER_ID | VARCHAR2(30) | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GTVSVCR | Unique | GTVSVCR_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GOBSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
| GORSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
| GOVSVEV | SQL View | S10B80.BANINST1 | Use (select) |
| GOVSVSD | SQL View | S10B80.BANINST1 | Use (select) |
| GOVSVTS | SQL View | S10B80.BANINST1 | Use (select) |
| GTVSVCR_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVCR | Rely On |
| GTVSVCR_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVCR | Use (select)Rely On |
| P_CREATE_HISTORY | Oracle Package Procedure | S10B80.BANINST1.GOKSVIS | Use (select) |
| P_SELECT_CURRENT_SEVIS | Oracle Package Procedure | S10B80.BANINST1.GOKSVIS | Use (select) |
| F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_GTVSVCR | Rely On |
| F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_GTVSVCR | Rely On |
| GTVSVCR | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GTVSVCR | SQL Index | S10B80.GENERAL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 20:33:13:000 | 04/02/2008 21:17:57:000 |
Table GTVSVCT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GTVSVCT_CODE | VARCHAR2(3) | No | * | ||
| GTVSVCT_DESC | VARCHAR2(60) | No | |||
| GTVSVCT_ACTIVITY_DATE | DATE | No | |||
| GTVSVCT_USER_ID | VARCHAR2(30) | No | |||
| GTVSVCT_DATA_ORIGIN | VARCHAR2(30) | Yes |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GTVSVCT | Unique | GTVSVCT_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GOBSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
| GORSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVCT_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVCT | Rely On |
| GTVSVCT_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVCT | Use (select)Rely On |
| F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_GTVSVCT | Rely On |
| F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_GTVSVCT | Rely On |
| GTVSVCT | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GTVSVCT | SQL Index | S10B80.GENERAL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 20:33:14:000 | 04/02/2008 21:17:57:000 |
Table GTVSVDT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GTVSVDT_CODE | VARCHAR2(2) | No | * | ||
| GTVSVDT_DESC | VARCHAR2(30) | No | |||
| GTVSVDT_ACTIVITY_DATE | DATE | No | |||
| GTVSVDT_USER_ID | VARCHAR2(30) | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GTVSVDT | Unique | GTVSVDT_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GORSEVD | SQL Table | S10B80.GENERAL | Refer (no action) |
| GORSEVH | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVDT_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVDT | Rely On |
| GTVSVDT_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVDT | Use (select)Rely On |
| F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_GTVSVDT | Rely On |
| F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_GTVSVDT | Rely On |
| GTVSVDT | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GTVSVDT | SQL Index | S10B80.GENERAL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 20:33:16:000 | 04/02/2008 21:17:57:000 |
Table GTVSVEL| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GTVSVEL_CODE | VARCHAR2(2) | No | * | ||
| GTVSVEL_DESC | VARCHAR2(30) | No | |||
| GTVSVEL_ACTIVITY_DATE | DATE | No | |||
| GTVSVEL_USER_ID | VARCHAR2(30) | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GTVSVEL | Unique | GTVSVEL_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GOBSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
| GORSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVEL_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVEL | Rely On |
| GTVSVEL_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVEL | Use (select)Rely On |
| F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_GTVSVEL | Rely On |
| F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_GTVSVEL | Rely On |
| GTVSVEL | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GTVSVEL | SQL Index | S10B80.GENERAL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 20:33:17:000 | 04/02/2008 21:17:57:000 |
Table GTVSVEP| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GTVSVEP_CODE | VARCHAR2(4) | No | * | ||
| GTVSVEP_DESC | VARCHAR2(30) | No | |||
| GTVSVEP_ACTIVITY_DATE | DATE | No | |||
| GTVSVEP_USER_ID | VARCHAR2(30) | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GTVSVEP | Unique | GTVSVEP_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GOBSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
| GORSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVEP_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVEP | Rely On |
| GTVSVEP_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVEP | Use (select)Rely On |
| F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_GTVSVEP | Rely On |
| F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_GTVSVEP | Rely On |
| GTVSVEP | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GTVSVEP | SQL Index | S10B80.GENERAL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 20:33:18:000 | 04/02/2008 21:17:57:000 |
Table GTVSVFT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GTVSVFT_CODE | VARCHAR2(2) | No | * | ||
| GTVSVFT_DESC | VARCHAR2(30) | No | |||
| GTVSVFT_ACTIVITY_DATE | DATE | No | |||
| GTVSVFT_USER_ID | VARCHAR2(30) | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GTVSVFT | Unique | GTVSVFT_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GOBSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
| GORSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVFT_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVFT | Rely On |
| GTVSVFT_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVFT | Use (select)Rely On |
| F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_GTVSVFT | Rely On |
| F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_GTVSVFT | Rely On |
| GTVSVFT | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GTVSVFT | SQL Index | S10B80.GENERAL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 20:33:20:000 | 04/02/2008 21:17:57:000 |
Table GTVSVGO| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GTVSVGO_CODE | VARCHAR2(6) | No | * | ||
| GTVSVGO_DESC | VARCHAR2(30) | No | |||
| GTVSVGO_ACTIVITY_DATE | DATE | No | |||
| GTVSVGO_USER_ID | VARCHAR2(30) | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GTVSVGO | Unique | GTVSVGO_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GOBSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
| GORSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVGO_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVGO | Rely On |
| GTVSVGO_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVGO | Use (select)Rely On |
| F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_GTVSVGO | Rely On |
| F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_GTVSVGO | Rely On |
| GTVSVGO | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GTVSVGO | SQL Index | S10B80.GENERAL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 20:33:22:000 | 04/02/2008 21:17:57:000 |
Table GTVSVIO| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GTVSVIO_CODE | VARCHAR2(6) | No | * | ||
| GTVSVIO_DESC | VARCHAR2(30) | No | |||
| GTVSVIO_ACTIVITY_DATE | DATE | No | |||
| GTVSVIO_USER_ID | VARCHAR2(30) | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GTVSVIO | Unique | GTVSVIO_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GOBSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
| GORSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVIO_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVIO | Rely On |
| GTVSVIO_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVIO | Use (select)Rely On |
| F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_GTVSVIO | Rely On |
| F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_GTVSVIO | Rely On |
| GTVSVIO | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GTVSVIO | SQL Index | S10B80.GENERAL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 20:33:24:000 | 04/02/2008 21:17:57:000 |
Table GTVSVIT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GTVSVIT_CODE | VARCHAR2(3) | No | * | ||
| GTVSVIT_DESC | VARCHAR2(60) | No | |||
| GTVSVIT_ACTIVITY_DATE | DATE | No | |||
| GTVSVIT_USER_ID | VARCHAR2(30) | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GTVSVIT | Unique | GTVSVIT_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GOBSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
| GOVSVEV | SQL View | S10B80.BANINST1 | Use (select) |
| GTVSVIT_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVIT | Rely On |
| GTVSVIT_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVIT | Use (select)Rely On |
| F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_GTVSVIT | Rely On |
| F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_GTVSVIT | Rely On |
| GTVSVIT | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GTVSVIT | SQL Index | S10B80.GENERAL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 20:33:25:000 | 04/02/2008 21:17:57:000 |
Table GTVSVPC| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GTVSVPC_CODE | VARCHAR2(3) | No | * | ||
| GTVSVPC_DESC | VARCHAR2(30) | No | |||
| GTVSVPC_ACTIVITY_DATE | DATE | No | |||
| GTVSVPC_USER_ID | VARCHAR2(30) | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GTVSVPC | Unique | GTVSVPC_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GOBSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
| GORSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVPC_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVPC | Rely On |
| GTVSVPC_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVPC | Use (select)Rely On |
| F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_GTVSVPC | Rely On |
| F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_GTVSVPC | Rely On |
| GTVSVPC | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GTVSVPC | SQL Index | S10B80.GENERAL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 20:33:41:000 | 04/02/2008 21:17:58:000 |
Table GTVSVRP| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GTVSVRP_CODE | VARCHAR2(2) | No | * | ||
| GTVSVRP_DESC | VARCHAR2(30) | No | |||
| GTVSVRP_ACTIVITY_DATE | DATE | No | |||
| GTVSVRP_USER_ID | VARCHAR2(30) | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GTVSVRP | Unique | GTVSVRP_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GOBSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
| GORSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVRP_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVRP | Rely On |
| GTVSVRP_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVRP | Use (select)Rely On |
| F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_GTVSVRP | Rely On |
| F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_GTVSVRP | Rely On |
| GTVSVRP | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GTVSVRP | SQL Index | S10B80.GENERAL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 20:33:44:000 | 04/02/2008 21:17:58:000 |
Table GTVSVTR| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GTVSVTR_CODE | VARCHAR2(6) | No | * | ||
| GTVSVTR_DESC | VARCHAR2(30) | No | |||
| GTVSVTR_USAGE_IND | VARCHAR2(1) | No | |||
| GTVSVTR_ACTIVITY_DATE | DATE | No | |||
| GTVSVTR_USER_ID | VARCHAR2(30) | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GTVSVTR | Unique | GTVSVTR_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GOBSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
| GORSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
| GOVSVEV | SQL View | S10B80.BANINST1 | Use (select) |
| GOVSVSD | SQL View | S10B80.BANINST1 | Use (select) |
| GTVSVTR_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVTR | Rely On |
| GTVSVTR_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVTR | Use (select)Rely On |
| F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_GTVSVTR | Rely On |
| F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_GTVSVTR | Rely On |
| GTVSVTR | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GTVSVTR | SQL Index | S10B80.GENERAL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 20:33:48:000 | 04/02/2008 21:17:58:000 |
Table GTVSVTS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| GTVSVTS_CODE | VARCHAR2(1) | No | * | ||
| GTVSVTS_DESC | VARCHAR2(30) | No | |||
| GTVSVTS_SYSTEM_REQ_IND | VARCHAR2(1) | No | |||
| GTVSVTS_ACTIVITY_DATE | DATE | No | |||
| GTVSVTS_USER_ID | VARCHAR2(30) | No |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_GTVSVTS | Unique | GTVSVTS_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GORSEVS | SQL Table | S10B80.GENERAL | Refer (no action) |
| GTVSVTS_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVTS | Rely On |
| GTVSVTS_C | Oracle Package Cursor | S10B80.BANINST1.GB_GTVSVTS | Use (select)Rely On |
| F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_GTVSVTS | Rely On |
| F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_GTVSVTS | Rely On |
| GTVSVTS | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_GTVSVTS | SQL Index | S10B80.GENERAL | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 20:33:49:000 | 04/02/2008 21:17:58:000 |
Table SPBPERS| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SPBPERS_PIDM | NUMBER(8,0) | No | * | * | |
| SPBPERS_SSN | VARCHAR2(15) | Yes | |||
| SPBPERS_BIRTH_DATE | DATE | Yes | |||
| SPBPERS_LGCY_CODE | VARCHAR2(1) | Yes | * | ||
| SPBPERS_ETHN_CODE | VARCHAR2(2) | Yes | * | ||
| SPBPERS_MRTL_CODE | VARCHAR2(1) | Yes | * | ||
| SPBPERS_RELG_CODE | VARCHAR2(2) | Yes | * | ||
| SPBPERS_SEX | VARCHAR2(1) | Yes | |||
| SPBPERS_CONFID_IND | VARCHAR2(1) | Yes | |||
| SPBPERS_DEAD_IND | VARCHAR2(1) | Yes | |||
| SPBPERS_VETC_FILE_NUMBER | VARCHAR2(10) | Yes | |||
| SPBPERS_LEGAL_NAME | VARCHAR2(500) | Yes | |||
| SPBPERS_PREF_FIRST_NAME | VARCHAR2(60) | Yes | |||
| SPBPERS_NAME_PREFIX | VARCHAR2(20) | Yes | |||
| SPBPERS_NAME_SUFFIX | VARCHAR2(20) | Yes | |||
| SPBPERS_ACTIVITY_DATE | DATE | No | |||
| SPBPERS_VERA_IND | VARCHAR2(1) | Yes | |||
| SPBPERS_CITZ_IND | VARCHAR2(1) | Yes | |||
| SPBPERS_DEAD_DATE | DATE | Yes | |||
| SPBPERS_PIN | RAW(1) | Yes | |||
| SPBPERS_CITZ_CODE | VARCHAR2(2) | Yes | * | ||
| SPBPERS_HAIR_CODE | VARCHAR2(2) | Yes | |||
| SPBPERS_EYES_CODE | VARCHAR2(2) | Yes | |||
| SPBPERS_CITY_BIRTH | VARCHAR2(50) | Yes | |||
| SPBPERS_STAT_CODE_BIRTH | VARCHAR2(3) | Yes | * | ||
| SPBPERS_DRIVER_LICENSE | VARCHAR2(20) | Yes | |||
| SPBPERS_STAT_CODE_DRIVER | VARCHAR2(3) | Yes | * | ||
| SPBPERS_NATN_CODE_DRIVER | VARCHAR2(5) | Yes | * | ||
| SPBPERS_UOMS_CODE_HEIGHT | VARCHAR2(4) | Yes | * | ||
| SPBPERS_HEIGHT | NUMBER(2,0) | Yes | |||
| SPBPERS_UOMS_CODE_WEIGHT | VARCHAR2(4) | Yes | * | ||
| SPBPERS_WEIGHT | NUMBER(4,0) | Yes | |||
| SPBPERS_SDVET_IND | VARCHAR2(1) | Yes | |||
| SPBPERS_LICENSE_ISSUED_DATE | DATE | Yes | |||
| SPBPERS_LICENSE_EXPIRES_DATE | DATE | Yes | |||
| SPBPERS_INCAR_IND | VARCHAR2(1) | Yes | |||
| SPBPERS_WEBID | RAW(1) | Yes | |||
| SPBPERS_WEB_LAST_ACCESS | RAW(1) | Yes | |||
| SPBPERS_PIN_DISABLED_IND | RAW(1) | Yes | |||
| SPBPERS_ITIN | NUMBER(9,0) | Yes | |||
| SPBPERS_ACTIVE_DUTY_SEPR_DATE | DATE | Yes | |||
| SPBPERS_DATA_ORIGIN | VARCHAR2(30) | Yes | |||
| SPBPERS_USER_ID | VARCHAR2(30) | Yes | |||
| SPBPERS_ETHN_CDE | VARCHAR2(1) | Yes | |||
| SPBPERS_CONFIRMED_RE_CDE | VARCHAR2(1) | Yes | |||
| SPBPERS_CONFIRMED_RE_DATE | DATE | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SPBPERS_UOMS_CODE_HEIGHT | GTVUOMS_CODE | GTVUOMS |
| SPBPERS_UOMS_CODE_WEIGHT | GTVUOMS_CODE | GTVUOMS |
| SPBPERS_NATN_CODE_DRIVER | STVNATN_CODE | STVNATN |
| SPBPERS_RELG_CODE | STVRELG_CODE | STVRELG |
| SPBPERS_STAT_CODE_BIRTH | STVSTAT_CODE | STVSTAT |
| SPBPERS_STAT_CODE_DRIVER | STVSTAT_CODE | STVSTAT |
| SPBPERS_CITZ_CODE | STVCITZ_CODE | STVCITZ |
| SPBPERS_MRTL_CODE | STVMRTL_CODE | STVMRTL |
| SPBPERS_ETHN_CODE | STVETHN_CODE | STVETHN |
| SPBPERS_LGCY_CODE | STVLGCY_CODE | STVLGCY |
| SPBPERS_PIDM | SARADAP_PIDM | SARADAP |
| SPBPERS_PIDM | SHRTTRM_PIDM | SHRTTRM |
| SPBPERS_PIDM | RORSTAT_PIDM | RORSTAT |
| SPBPERS_CITZ_CODE | SARDCSN_CITZ_CODE | SARDCSN |
| SPBPERS_PIDM | APRDHIS_PIDM | APRDHIS |
| SPBPERS_PIDM | SLRRMAT_PIDM | SLRRMAT |
| SPBPERS_PIDM | SFBETRM_PIDM | SFBETRM |
| SPBPERS_PIDM | SRBRECR_PIDM | SRBRECR |
| SPBPERS_PIDM | SGBSTDN_PIDM | SGBSTDN |
| SPBPERS_PIDM | RPRATRM_PIDM | RPRATRM |
| SPBPERS_PIDM | GORSEVD_DEP_PIDM | GORSEVD |
| SPBPERS_PIDM | GOBSEVS_PIDM | GOBSEVS |
| SPBPERS_PIDM | APRCHIS_PIDM | APRCHIS |
| SPBPERS_PIDM | PEBEMPL_PIDM | PEBEMPL |
| SPBPERS_PIDM | NBRBJOB_PIDM | NBRBJOB |
| SPBPERS_PIDM | GOREMAL_PIDM | GOREMAL |
| SPBPERS_PIDM | SPRMEDI_PIDM | SPRMEDI |
| SPBPERS_PIDM | APRACYR_PIDM | APRACYR |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SPBPERS | Unique | SPBPERS_PIDM |
| SPBPERS_SSN_INDEX | SPBPERS_SSN |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_SPBPERS | SQL Index | S10B80.SATURN | Rely On |
| SPBPERS_SSN_INDEX | SQL Index | S10B80.SATURN | Rely On |
| APRACYR | SQL Table | S10B80.ALUMNI | Join |
| APRCHIS | SQL Table | S10B80.ALUMNI | Join |
| APRDHIS | SQL Table | S10B80.ALUMNI | Join |
| GOBSEVS | SQL Table | S10B80.GENERAL | Join |
| GOREMAL | SQL Table | S10B80.GENERAL | Join |
| GORSEVD | SQL Table | S10B80.GENERAL | Join |
| GTVUOMS | SQL Table | S10B80.GENERAL | Refer (no action) |
| NBRBJOB | SQL Table | S10B80.POSNCTL | Join |
| PEBEMPL | SQL Table | S10B80.PAYROLL | Join |
| RORSTAT | SQL Table | S10B80.FAISMGR | Join |
| RPRATRM | SQL Table | S10B80.FAISMGR | Join |
| SARADAP | SQL Table | S10B80.SATURN | Join |
| SARDCSN | SQL Table | S10B80.SATURN | Join |
| SFBETRM | SQL Table | S10B80.SATURN | Join |
| SGBSTDN | SQL Table | S10B80.SATURN | Join |
| SHRTTRM | SQL Table | S10B80.SATURN | Join |
| SLRRMAT | SQL Table | S10B80.SATURN | Join |
| SPRMEDI | SQL Table | S10B80.SATURN | Join |
| SRBRECR | SQL Table | S10B80.SATURN | Join |
| STVCITZ | SQL Table | S10B80.SATURN | Refer (no action) |
| STVETHN | SQL Table | S10B80.SATURN | Refer (no action) |
| STVLGCY | SQL Table | S10B80.SATURN | Refer (no action) |
| STVMRTL | SQL Table | S10B80.SATURN | Refer (no action) |
| STVNATN | SQL Table | S10B80.SATURN | Refer (no action) |
| STVRELG | SQL Table | S10B80.SATURN | Refer (no action) |
| STVSTAT | SQL Table | S10B80.SATURN | Refer (no action) |
| ET_SPBPERS_AIR_EXTSOL | SQL Trigger | S10B80.BANIMGR | Fire (Insert,after,each row) |
| ET_SPBPERS_AUR_EXTSOL | SQL Trigger | S10B80.BANIMGR | Fire (update,after,each row) |
| ST_SPBPERS_AR_LDI | SQL Trigger | S10B80.SATURN | Fire (Insert,update,delete,after,each row) |
| ST_SPBPERS_AS_LDI | SQL Trigger | S10B80.SATURN | Fire (Insert,update,delete,after,all rows) |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 20:40:04:000 | 04/02/2008 21:18:03:000 |
Table SPRIDEN| 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 |
Table STVRELT| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| STVRELT_CODE | VARCHAR2(1) | No | * | ||
| STVRELT_DESC | VARCHAR2(30) | Yes | |||
| STVRELT_ACTIVITY_DATE | DATE | No | |||
| STVRELT_SEVIS_EQUIV | VARCHAR2(3) | Yes |
| Index Name | Index Type | Column Name |
|---|---|---|
| PK_STVRELT | Unique | STVRELT_CODE |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| GORSEVD | SQL Table | S10B80.GENERAL | Refer (no action) |
| SORFOLK | SQL Table | S10B80.SATURN | Refer (no action) |
| SPREMRG | SQL Table | S10B80.SATURN | Refer (no action) |
| GOVSVDP | SQL View | S10B80.BANINST1 | Use (select) |
| F_STUDENT_GET_DESC | SQL Function | S10B80.BANINST1 | Use (select) |
| STVRELT_REC | Oracle Package Variable | S10B80.BANINST1.BWGKOEMR | Rely On |
| STVRELTC | Oracle Package Cursor | S10B80.BANINST1.STKRELT | Use (select)Rely On |
| STVRELTLISTC | Oracle Package Cursor | S10B80.BANINST1.GOKLIBS | Use (select)Rely On |
| STVRELT_C | Oracle Package Cursor | S10B80.BANINST1.GB_STVRELT | Rely On |
| STVRELT_C | Oracle Package Cursor | S10B80.BANINST1.GB_STVRELT | Use (select)Rely On |
| P_DELETE_STVRELT | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
| P_DELETE_STVRELT | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (delete) |
| P_INSERT_STVRELT | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
| P_INSERT_STVRELT | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (Insert) |
| P_UPDATE_STVRELT | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Rely On |
| P_UPDATE_STVRELT | Oracle Package Procedure | S10B80.BANINST1.TS_SB_VALIDATION | Use (update) |
| UT_SETUP | Oracle Package Procedure | S10B80.BANINST1.UT_SP_HOUSING_PROFILE | Use (Insert,select) |
| F_CODE_EXISTS | Oracle Package Function | S10B80.BANINST1.GB_STVRELT | Rely On |
| F_GET_DESCRIPTION | Oracle Package Function | S10B80.BANINST1.GB_STVRELT | Rely On |
| STVRELT | Oracle Synonym | S10B80.PUBLIC | Rely On |
| Object Name | Object Type | Parent Name | Link Type |
|---|---|---|---|
| PK_STVRELT | SQL Index | S10B80.SATURN | Rely On |
| Creation Date | Analysis Date |
|---|---|
| 04/02/2008 20:34:15:000 | 04/02/2008 21:17:58:000 |
Link between SPRIDEN and SPBPERS| Objects list |
|---|
| schema-view : S10B80.BANINST1.PEVJOB1
schema-view : S10B80.BANINST1.GPVENT1 schema-view : S10B80.BANINST1.AOVORG1 schema-view : S10B80.BANINST1.GOVSRVR schema-view : S10B80.BANINST1.PAVAPPL schema-view : S10B80.BANINST1.PEVPRF1 schema-view : S10B80.BANINST1.PEVVER2 schema-view : S10B80.BANINST1.APVCNI1 schema-function : S10B80.BANINST1.F_BENEFICIARY_INFO schema-view : S10B80.BANINST1.PDVDED1 schema-view : S10B80.BANINST1.ROVFINS schema-view : S10B80.BANINST1.GUVALTI schema-view : S10B80.BANINST1.AOVIDEN schema-view : S10B80.BANINST1.AT_AR_BALANCE_BY_ENTITY schema-view : S10B80.BANINST1.APVBRWS schema-view : S10B80.BANINST1.SPVPERS schema-view : S10B80.BANINST1.SPVCURR scope-function : S10B80.BANINST1.GB_IDENTIFICATION.F_IDNAME_SEARCH scope-function : S10B80.BANINST1.GB_IDENTIFICATION.F_SSNNAME_SEARCH scope-cursor : S10B80.BANINST1.ICSPKCOM.PERSON_C scope-cursor : S10B80.BANINST1.PP_W2_2006.EMPL_C scope-cursor : S10B80.BANINST1.PP_W2_2007.EMPL_C scope-cursor : S10B80.BANINST1.SPKLIBS.FULL_NAME_C scope-function : S10B80.BANINST1.TEST_LVH.F_IDNAME_SEARCH scope-procedure : S10B80.BANINST1.SB_PESCXML_PERSON_EXP.P_PERSON_ELEMENT scope-procedure : S10B80.BANINST1.PB_W2_FEDERAL_RULES.P_VALIDATE scope-procedure : S10B80.BANINST1.PP_W2.P_CREATE_W2 scope-function : S10B80.BANINST1.GOKVISA.F_CHECK_CITZ scope-function : S10B80.BANINST1.SHKTRAN.F_IDEN_NAME scope-function : S10B80.BANINST1.SHKTRAN.F_TRANSCRIPT_NAME scope-function : S10B80.BANINST1.BWPKEPCR.F_GET_ID scope-function : S10B80.BANINST1.GB_PERSON.F_GET_PERSON_BY_ID scope-procedure : S10B80.BANINST1.PDKDEDN.P_EDIT_EMPLOYEE_ID |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SPRIDEN and SPBPERS | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SPRIDEN | SPBPERS |
Link between GORSVAS and GOBSEVS| Objects list |
|---|
| schema-view : S10B80.BANINST1.GOVSVAS |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between GORSVAS and GOBSEVS | GENERAL |
| Link type | Between | And |
|---|---|---|
| Join | GORSVAS | GOBSEVS |
Link between SPRIDEN and GORSVAS| Objects list |
|---|
| schema-view : S10B80.BANINST1.GOVSVAS |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SPRIDEN and GORSVAS | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SPRIDEN | GORSVAS |
Link between SPRIDEN and GORSEVD| Objects list |
|---|
| schema-view : S10B80.BANINST1.GOVSVDP |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SPRIDEN and GORSEVD | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SPRIDEN | GORSEVD |
Link between SPBPERS and GORSEVD| Objects list |
|---|
| schema-view : S10B80.BANINST1.GOVSVDP |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SPBPERS and GORSEVD | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SPBPERS | GORSEVD |
Link between GORSVEI and GOBSEVS| Objects list |
|---|
| schema-view : S10B80.BANINST1.GOVSVEI |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between GORSVEI and GOBSEVS | GENERAL |
| Link type | Between | And |
|---|---|---|
| Join | GORSVEI | GOBSEVS |
Link between SPRIDEN and GORSVEI| Objects list |
|---|
| schema-view : S10B80.BANINST1.GOVSVEI |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SPRIDEN and GORSVEI | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SPRIDEN | GORSVEI |
Link between SPRIDEN and GOBSEVS| Objects list |
|---|
| schema-view : S10B80.BANINST1.GOVSVEV
schema-view : S10B80.BANINST1.GOVSVSD |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SPRIDEN and GOBSEVS | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SPRIDEN | GOBSEVS |
Link between SPBPERS and GOBSEVS| Objects list |
|---|
| schema-view : S10B80.BANINST1.GOVSVEV
schema-view : S10B80.BANINST1.GOVSVSD |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SPBPERS and GOBSEVS | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SPBPERS | GOBSEVS |
Link between SPRIDEN and GORSEVS| Objects list |
|---|
| schema-view : S10B80.BANINST1.GOVSVTS |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between SPRIDEN and GORSEVS | SATURN |
| Link type | Between | And |
|---|---|---|
| Join | SPRIDEN | GORSEVS |
Link between GOBSEVS and GORSEVS| Objects list |
|---|
| schema-view : S10B80.BANINST1.GOVSVTS |
| Link Type | Link | Project |
|---|---|---|
| Join | Link Between GOBSEVS and GORSEVS | GENERAL |
| Link type | Between | And |
|---|---|---|
| Join | GOBSEVS | GORSEVS |
Link between GORSEVH and GORSEVS| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GORSEVH and GORSEVS (FK1_GORSEVH_INV_GORSEVS_KEY) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GORSEVH | GORSEVH_PIDM | GORSEVS_PIDM | GORSEVS | (1,1)-(0,n) |
| GORSEVH | GORSEVH_SEVIS_SEQ_NO | GORSEVS_SEQ_NO | GORSEVS | (1,1)-(0,n) |
Link between GORSVAH and GORSEVS| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GORSVAH and GORSEVS (FK1_GORSVAH_INV_GORSEVS_KEY) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GORSVAH | GORSVAH_PIDM | GORSEVS_PIDM | GORSEVS | (1,1)-(0,n) |
| GORSVAH | GORSVAH_SEVIS_SEQ_NO | GORSEVS_SEQ_NO | GORSEVS | (1,1)-(0,n) |
Link between GOBSEVS and GTVSVCC| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GOBSEVS and GTVSVCC (FK1_GOBSEVS_INV_GTVSVCC_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GOBSEVS | GOBSEVS_SVCC_CODE | GTVSVCC_CODE | GTVSVCC | (0,1)-(0,n) |
Link between GORSEVS and GTVSVCC| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GORSEVS and GTVSVCC (FK1_GORSEVS_INV_GTVSVCC_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GORSEVS | GORSEVS_SVCC_CODE | GTVSVCC_CODE | GTVSVCC | (0,1)-(0,n) |
Link between GOBSEVS and GTVSVCP| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GOBSEVS and GTVSVCP (FK1_GOBSEVS_INV_GTVSVCP_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GOBSEVS | GOBSEVS_SVCP_CODE | GTVSVCP_CODE | GTVSVCP | (0,1)-(0,n) |
Link between GOBSEVS and GTVSVCR| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GOBSEVS and GTVSVCR (FK1_GOBSEVS_INV_GTVSVCR_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GOBSEVS | GOBSEVS_SVCR_CODE | GTVSVCR_CODE | GTVSVCR | (0,1)-(0,n) |
Link between GORSEVS and GTVSVCR| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GORSEVS and GTVSVCR (FK1_GORSEVS_INV_GTVSVCR_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GORSEVS | GORSEVS_SVCR_CODE | GTVSVCR_CODE | GTVSVCR | (0,1)-(0,n) |
Link between GOBSEVS and GTVSVCT| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GOBSEVS and GTVSVCT (FK1_GOBSEVS_INV_GTVSVCT_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GOBSEVS | GOBSEVS_SVCT_CODE | GTVSVCT_CODE | GTVSVCT | (0,1)-(0,n) |
Link between GORSEVS and GTVSVCT| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GORSEVS and GTVSVCT (FK1_GORSEVS_INV_GTVSVCT_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GORSEVS | GORSEVS_SVCT_CODE | GTVSVCT_CODE | GTVSVCT | (0,1)-(0,n) |
Link between GORSEVD and GTVSVDT| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GORSEVD and GTVSVDT (FK1_GORSEVD_INV_GTVSVDT_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GORSEVD | GORSEVD_SVDT_CODE | GTVSVDT_CODE | GTVSVDT | (0,1)-(0,n) |
Link between GORSEVH and GTVSVDT| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GORSEVH and GTVSVDT (FK1_GORSEVH_INV_GTVSVDT_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GORSEVH | GORSEVH_SVDT_CODE | GTVSVDT_CODE | GTVSVDT | (0,1)-(0,n) |
Link between GOBSEVS and GTVSVEL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GOBSEVS and GTVSVEL (FK1_GOBSEVS_INV_GTVSVEL_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GOBSEVS | GOBSEVS_SVEL_CODE | GTVSVEL_CODE | GTVSVEL | (0,1)-(0,n) |
Link between GORSEVS and GTVSVEL| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GORSEVS and GTVSVEL (FK1_GORSEVS_INV_GTVSVEL_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GORSEVS | GORSEVS_SVEL_CODE | GTVSVEL_CODE | GTVSVEL | (0,1)-(0,n) |
Link between GOBSEVS and GTVSVEP| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GOBSEVS and GTVSVEP (FK1_GOBSEVS_INV_GTVSVEP_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GOBSEVS | GOBSEVS_SVEP_CODE | GTVSVEP_CODE | GTVSVEP | (0,1)-(0,n) |
Link between GORSEVS and GTVSVEP| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GORSEVS and GTVSVEP (FK1_GORSEVS_INV_GTVSVEP_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GORSEVS | GORSEVS_SVEP_CODE | GTVSVEP_CODE | GTVSVEP | (0,1)-(0,n) |
Link between GOBSEVS and GTVSVFT| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GOBSEVS and GTVSVFT (FK1_GOBSEVS_INV_GTVSVFT_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GOBSEVS | GOBSEVS_SVFT_CODE | GTVSVFT_CODE | GTVSVFT | (0,1)-(0,n) |
Link between GORSEVS and GTVSVFT| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GORSEVS and GTVSVFT (FK1_GORSEVS_INV_GTVSVFT_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GORSEVS | GORSEVS_SVFT_CODE | GTVSVFT_CODE | GTVSVFT | (0,1)-(0,n) |
Link between GOBSEVS and GTVSVGO| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GOBSEVS and GTVSVGO (FK1_GOBSEVS_INV_GTVSVGO_CODE) | GENERAL |
| Refer (no action) | Link Informative Foreign Key Between GOBSEVS and GTVSVGO (FK2_GOBSEVS_INV_GTVSVGO_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GOBSEVS | GOBSEVS_SVGO_CODE | GTVSVGO_CODE | GTVSVGO | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GOBSEVS | GOBSEVS_SVGO_CODE_2 | GTVSVGO_CODE | GTVSVGO | (0,1)-(0,n) |
Link between GORSEVS and GTVSVGO| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GORSEVS and GTVSVGO (FK1_GORSEVS_INV_GTVSVGO_CODE) | GENERAL |
| Refer (no action) | Link Informative Foreign Key Between GORSEVS and GTVSVGO (FK2_GORSEVS_INV_GTVSVGO_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GORSEVS | GORSEVS_SVGO_CODE | GTVSVGO_CODE | GTVSVGO | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GORSEVS | GORSEVS_SVGO_CODE_2 | GTVSVGO_CODE | GTVSVGO | (0,1)-(0,n) |
Link between GOBSEVS and GTVSVIO| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GOBSEVS and GTVSVIO (FK1_GOBSEVS_INV_GTVSVIO_CODE) | GENERAL |
| Refer (no action) | Link Informative Foreign Key Between GOBSEVS and GTVSVIO (FK2_GOBSEVS_INV_GTVSVIO_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GOBSEVS | GOBSEVS_SVIO_CODE | GTVSVIO_CODE | GTVSVIO | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GOBSEVS | GOBSEVS_SVIO_CODE_2 | GTVSVIO_CODE | GTVSVIO | (0,1)-(0,n) |
Link between GORSEVS and GTVSVIO| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GORSEVS and GTVSVIO (FK1_GORSEVS_INV_GTVSVIO_CODE) | GENERAL |
| Refer (no action) | Link Informative Foreign Key Between GORSEVS and GTVSVIO (FK2_GORSEVS_INV_GTVSVIO_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GORSEVS | GORSEVS_SVIO_CODE | GTVSVIO_CODE | GTVSVIO | (0,1)-(0,n) |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GORSEVS | GORSEVS_SVIO_CODE_2 | GTVSVIO_CODE | GTVSVIO | (0,1)-(0,n) |
Link between GOBSEVS and GTVSVIT| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GOBSEVS and GTVSVIT (FK1_GOBSEVS_INV_GTVSVIT_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GOBSEVS | GOBSEVS_SVIT_CODE | GTVSVIT_CODE | GTVSVIT | (0,1)-(0,n) |
Link between GOBSEVS and GTVSVPC| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GOBSEVS and GTVSVPC (FK1_GOBSEVS_INV_GTVSVPC_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GOBSEVS | GOBSEVS_SVPC_CODE | GTVSVPC_CODE | GTVSVPC | (0,1)-(0,n) |
Link between GORSEVS and GTVSVPC| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GORSEVS and GTVSVPC (FK1_GORSEVS_INV_GTVSVPC_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GORSEVS | GORSEVS_SVPC_CODE | GTVSVPC_CODE | GTVSVPC | (0,1)-(0,n) |
Link between GOBSEVS and GTVSVRP| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GOBSEVS and GTVSVRP (FK1_GOBSEVS_INV_GTVSVRP_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GOBSEVS | GOBSEVS_SVRP_CODE | GTVSVRP_CODE | GTVSVRP | (0,1)-(0,n) |
Link between GORSEVS and GTVSVRP| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GORSEVS and GTVSVRP (FK1_GORSEVS_INV_GTVSVRP_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GORSEVS | GORSEVS_SVRP_CODE | GTVSVRP_CODE | GTVSVRP | (0,1)-(0,n) |
Link between GOBSEVS and GTVSVTR| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GOBSEVS and GTVSVTR (FK1_GOBSEVS_INV_GTVSVTR_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GOBSEVS | GOBSEVS_SVTR_CODE | GTVSVTR_CODE | GTVSVTR | (0,1)-(0,n) |
Link between GORSEVS and GTVSVTR| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GORSEVS and GTVSVTR (FK1_GORSEVS_INV_GTVSVTR_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GORSEVS | GORSEVS_SVTR_CODE | GTVSVTR_CODE | GTVSVTR | (0,1)-(0,n) |
Link between GORSEVS and GTVSVTS| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GORSEVS and GTVSVTS (FK1_GORSEVS_INV_GTVSVTS_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GORSEVS | GORSEVS_SVTS_CODE | GTVSVTS_CODE | GTVSVTS | (1,1)-(0,n) |
Link between GORSEVD and STVRELT| Link Type | Link | Project |
|---|---|---|
| Refer (no action) | Link Informative Foreign Key Between GORSEVD and STVRELT (FK1_GORSEVD_INV_STVRELT_CODE) | GENERAL |
| Table name | Table Column Name | Foreign Key Column Name | On Table | Cardinalities |
|---|---|---|---|---|
| GORSEVD | GORSEVD_RELT_CODE | STVRELT_CODE | STVRELT | (1,1)-(0,n) |