Model View
Table GOBINTL
Object Full Name
Source Code Comments
Columns Comments for GOBINTL_PIDM (# 1)
Source Code Comments
Columns Comments for GOBINTL_SPOUSE_IND (# 2)
Source Code Comments
Columns Comments for GOBINTL_SIGNATURE_IND (# 3)
Source Code Comments
Columns Comments for GOBINTL_USER_ID (# 4)
Source Code Comments
Columns Comments for GOBINTL_ACTIVITY_DATE (# 5)
Source Code Comments
Columns Comments for GOBINTL_PASSPORT_ID (# 6)
Source Code Comments
Columns Comments for GOBINTL_NATN_CODE_ISSUE (# 7)
Source Code Comments
Columns Comments for GOBINTL_PASSPORT_EXP_DATE (# 8)
Source Code Comments
Columns Comments for GOBINTL_I94_STATUS (# 9)
Source Code Comments
Columns Comments for GOBINTL_I94_DATE (# 10)
Source Code Comments
Columns Comments for GOBINTL_REG_NUMBER (# 11)
Source Code Comments
Columns Comments for GOBINTL_DURATION (# 12)
Source Code Comments
Columns Comments for GOBINTL_CELG_CODE (# 13)
Source Code Comments
Columns Comments for GOBINTL_CERT_NUMBER (# 14)
Source Code Comments
Columns Comments for GOBINTL_CERT_DATE_ISSUE (# 15)
Source Code Comments
Columns Comments for GOBINTL_CERT_DATE_RECEIPT (# 16)
Source Code Comments
Columns Comments for GOBINTL_ADMR_CODE (# 17)
Source Code Comments
Columns Comments for GOBINTL_NATN_CODE_BIRTH (# 18)
Source Code Comments
Columns Comments for GOBINTL_NATN_CODE_LEGAL (# 19)
Source Code Comments
Columns Comments for GOBINTL_LANG_CODE (# 20)
Source Code Comments
Columns Comments for GOBINTL_SPON_CODE (# 21)
Source Code Comments
Columns Comments for GOBINTL_EMPT_CODE (# 22)
Source Code Comments
Columns Comments for GOBINTL_FOREIGN_SSN (# 23)
Source Code Comments
Columns Comments for GOBINTL_CHILD_NUMBER (# 24)
Source Code Comments
Table GORDOCM
Object Full Name
Source Code Comments
Columns Comments for GORDOCM_PIDM (# 1)
Source Code Comments
Columns Comments for GORDOCM_SEQ_NO (# 2)
Source Code Comments
Columns Comments for GORDOCM_VTYP_CODE (# 3)
Source Code Comments
Columns Comments for GORDOCM_VISA_NUMBER (# 4)
Source Code Comments
Columns Comments for GORDOCM_DOCM_CODE (# 5)
Source Code Comments
Columns Comments for GORDOCM_DISPOSITION (# 6)
Source Code Comments
Columns Comments for GORDOCM_USER_ID (# 7)
Source Code Comments
Columns Comments for GORDOCM_ACTIVITY_DATE (# 8)
Source Code Comments
Columns Comments for GORDOCM_SRCE_CODE (# 9)
Source Code Comments
Columns Comments for GORDOCM_REQUEST_DATE (# 10)
Source Code Comments
Columns Comments for GORDOCM_RECEIVED_DATE (# 11)
Source Code Comments
Table GORVISA
Object Full Name
Source Code Comments
Columns Comments for GORVISA_PIDM (# 1)
Source Code Comments
Columns Comments for GORVISA_SEQ_NO (# 2)
Source Code Comments
Columns Comments for GORVISA_VTYP_CODE (# 3)
Source Code Comments
Columns Comments for GORVISA_VISA_NUMBER (# 4)
Source Code Comments
Columns Comments for GORVISA_NATN_CODE_ISSUE (# 5)
Source Code Comments
Columns Comments for GORVISA_VISS_CODE (# 6)
Source Code Comments
Columns Comments for GORVISA_VISA_START_DATE (# 7)
Source Code Comments
Columns Comments for GORVISA_VISA_EXPIRE_DATE (# 8)
Source Code Comments
Columns Comments for GORVISA_ENTRY_IND (# 9)
Source Code Comments
Columns Comments for GORVISA_USER_ID (# 10)
Source Code Comments
Columns Comments for GORVISA_ACTIVITY_DATE (# 11)
Source Code Comments
Columns Comments for GORVISA_VISA_REQ_DATE (# 12)
Source Code Comments
Columns Comments for GORVISA_VISA_ISSUE_DATE (# 13)
Source Code Comments
Columns Comments for GORVISA_PENT_CODE (# 14)
Source Code Comments
Columns Comments for GORVISA_NO_ENTRIES (# 15)
Source Code Comments
Columns Comments for GORVISA_DATA_ORIGIN (# 16)
Source Code Comments
Table GTVCELG
Object Full Name
Source Code Comments
Columns Comments for GTVCELG_CODE (# 1)
Source Code Comments
Columns Comments for GTVCELG_DESC (# 2)
Source Code Comments
Columns Comments for GTVCELG_USER_ID (# 3)
Source Code Comments
Columns Comments for GTVCELG_ACTIVITY_DATE (# 4)
Source Code Comments
Table GTVDOCM
Object Full Name
Source Code Comments
Columns Comments for GTVDOCM_CODE (# 1)
Source Code Comments
Columns Comments for GTVDOCM_DESC (# 2)
Source Code Comments
Columns Comments for GTVDOCM_USER_ID (# 3)
Source Code Comments
Columns Comments for GTVDOCM_ACTIVITY_DATE (# 4)
Source Code Comments
Table GTVSRCE
Object Full Name
Source Code Comments
Columns Comments for GTVSRCE_CODE (# 1)
Source Code Comments
Columns Comments for GTVSRCE_DESC (# 2)
Source Code Comments
Columns Comments for GTVSRCE_USER_ID (# 3)
Source Code Comments
Columns Comments for GTVSRCE_ACTIVITY_DATE (# 4)
Source Code Comments
Table GTVVISS
Object Full Name
Source Code Comments
Columns Comments for GTVVISS_CODE (# 1)
Source Code Comments
Columns Comments for GTVVISS_DESC (# 2)
Source Code Comments
Columns Comments for GTVVISS_USER_ID (# 3)
Source Code Comments
Columns Comments for GTVVISS_ACTIVITY_DATE (# 4)
Source Code Comments
Table SARADAP
Object Full Name
Source Code Comments
Lock
Columns Comments for SARADAP_PIDM (# 1)
Source Code Comments
Columns Comments for SARADAP_TERM_CODE_ENTRY (# 2)
Source Code Comments
Columns Comments for SARADAP_APPL_NO (# 3)
Source Code Comments
Columns Comments for SARADAP_LEVL_CODE (# 4)
Source Code Comments
Columns Comments for SARADAP_APPL_DATE (# 5)
Source Code Comments
Columns Comments for SARADAP_APST_CODE (# 6)
Source Code Comments
Columns Comments for SARADAP_APST_DATE (# 7)
Source Code Comments
Columns Comments for SARADAP_MAINT_IND (# 8)
Source Code Comments
Columns Comments for SARADAP_ADMT_CODE (# 9)
Source Code Comments
Columns Comments for SARADAP_STYP_CODE (# 10)
Source Code Comments
Columns Comments for SARADAP_CAMP_CODE (# 11)
Source Code Comments
Columns Comments for SARADAP_SITE_CODE (# 12)
Source Code Comments
Columns Comments for SARADAP_COLL_CODE_1 (# 13)
Source Code Comments
Columns Comments for SARADAP_DEGC_CODE_1 (# 14)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_1 (# 15)
Source Code Comments
Columns Comments for SARADAP_COLL_CODE_2 (# 16)
Source Code Comments
Columns Comments for SARADAP_DEGC_CODE_2 (# 17)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_2 (# 18)
Source Code Comments
Columns Comments for SARADAP_RESD_CODE (# 19)
Source Code Comments
Columns Comments for SARADAP_FULL_PART_IND (# 20)
Source Code Comments
Columns Comments for SARADAP_SESS_CODE (# 21)
Source Code Comments
Columns Comments for SARADAP_WRSN_CODE (# 22)
Source Code Comments
Columns Comments for SARADAP_INTV_CODE (# 23)
Source Code Comments
Columns Comments for SARADAP_FEE_IND (# 24)
Source Code Comments
Columns Comments for SARADAP_FEE_DATE (# 25)
Source Code Comments
Columns Comments for SARADAP_ACTIVITY_DATE (# 26)
Source Code Comments
Columns Comments for SARADAP_RATE_CODE (# 27)
Source Code Comments
Columns Comments for SARADAP_EGOL_CODE (# 28)
Source Code Comments
Columns Comments for SARADAP_EDLV_CODE (# 29)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_CONC_1 (# 30)
Source Code Comments
Columns Comments for SARADAP_DEPT_CODE (# 31)
Source Code Comments
Columns Comments for SARADAP_SBGI_CODE (# 32)
Source Code Comments
Columns Comments for SARADAP_RECR_CODE (# 33)
Source Code Comments
Columns Comments for SARADAP_RTYP_CODE (# 34)
Source Code Comments
Columns Comments for SARADAP_DEPT_CODE_2 (# 35)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_CONC_2 (# 36)
Source Code Comments
Columns Comments for SARADAP_PROGRAM_1 (# 37)
Source Code Comments
Columns Comments for SARADAP_TERM_CODE_CTLG_1 (# 38)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_1_2 (# 39)
Source Code Comments
Columns Comments for SARADAP_DEPT_CODE_1_2 (# 40)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_CONC_1_2 (# 41)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_CONC_1_3 (# 42)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_CONC_121 (# 43)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_CONC_122 (# 44)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_CONC_123 (# 45)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_MINR_1_1 (# 46)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_MINR_1_2 (# 47)
Source Code Comments
Columns Comments for SARADAP_PROGRAM_2 (# 48)
Source Code Comments
Columns Comments for SARADAP_TERM_CODE_CTLG_2 (# 49)
Source Code Comments
Columns Comments for SARADAP_LEVL_CODE_2 (# 50)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_2_2 (# 52)
Source Code Comments
Columns Comments for SARADAP_DEPT_CODE_2_2 (# 53)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_CONC_211 (# 54)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_CONC_212 (# 55)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_CONC_213 (# 56)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_CONC_221 (# 57)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_CONC_222 (# 58)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_CONC_223 (# 59)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_MINR_2_1 (# 60)
Source Code Comments
Columns Comments for SARADAP_MAJR_CODE_MINR_2_2 (# 61)
Source Code Comments
Columns Comments for SARADAP_CURR_RULE_1 (# 62)
Source Code Comments
Columns Comments for SARADAP_CMJR_RULE_1_1 (# 63)
Source Code Comments
Columns Comments for SARADAP_CCON_RULE_11_1 (# 64)
Source Code Comments
Columns Comments for SARADAP_CCON_RULE_11_2 (# 65)
Source Code Comments
Columns Comments for SARADAP_CCON_RULE_11_3 (# 66)
Source Code Comments
Columns Comments for SARADAP_CMJR_RULE_1_2 (# 67)
Source Code Comments
Columns Comments for SARADAP_CCON_RULE_12_1 (# 68)
Source Code Comments
Columns Comments for SARADAP_CCON_RULE_12_2 (# 69)
Source Code Comments
Columns Comments for SARADAP_CCON_RULE_12_3 (# 70)
Source Code Comments
Columns Comments for SARADAP_CMNR_RULE_1_1 (# 71)
Source Code Comments
Columns Comments for SARADAP_CMNR_RULE_1_2 (# 72)
Source Code Comments
Columns Comments for SARADAP_CURR_RULE_2 (# 73)
Source Code Comments
Columns Comments for SARADAP_CMJR_RULE_2_1 (# 74)
Source Code Comments
Columns Comments for SARADAP_CCON_RULE_21_1 (# 75)
Source Code Comments
Columns Comments for SARADAP_CCON_RULE_21_2 (# 76)
Source Code Comments
Columns Comments for SARADAP_CCON_RULE_21_3 (# 77)
Source Code Comments
Columns Comments for SARADAP_CMJR_RULE_2_2 (# 78)
Source Code Comments
Columns Comments for SARADAP_CCON_RULE_22_1 (# 79)
Source Code Comments
Columns Comments for SARADAP_CCON_RULE_22_2 (# 80)
Source Code Comments
Columns Comments for SARADAP_CCON_RULE_22_3 (# 81)
Source Code Comments
Columns Comments for SARADAP_CMNR_RULE_2_1 (# 82)
Source Code Comments
Columns Comments for SARADAP_CMNR_RULE_2_2 (# 83)
Source Code Comments
Columns Comments for SARADAP_WEB_ACCT_MISC_IND (# 84)
Source Code Comments
Columns Comments for SARADAP_WEB_CASHIER_USER (# 85)
Source Code Comments
Columns Comments for SARADAP_WEB_TRANS_NO (# 86)
Source Code Comments
Columns Comments for SARADAP_WEB_AMOUNT (# 87)
Source Code Comments
Columns Comments for SARADAP_WEB_RECEIPT_NUMBER (# 88)
Source Code Comments
Columns Comments for SARADAP_WAIV_CODE (# 89)
Source Code Comments
Columns Comments for SARADAP_DATA_ORIGIN (# 90)
Source Code Comments
Columns Comments for SARADAP_USER_ID (# 91)
Source Code Comments
Columns Comments for SARADAP_APPL_PREFERENCE (# 92)
Source Code Comments
Table SARCHKL
Object Full Name
Source Code Comments
Lock
Columns Comments for SARCHKL_PIDM (# 1)
Source Code Comments
Columns Comments for SARCHKL_TERM_CODE_ENTRY (# 2)
Source Code Comments
Columns Comments for SARCHKL_APPL_NO (# 3)
Source Code Comments
Columns Comments for SARCHKL_ADMR_CODE (# 4)
Source Code Comments
Columns Comments for SARCHKL_MANDATORY_IND (# 5)
Source Code Comments
Columns Comments for SARCHKL_REQ_DATE1 (# 6)
Source Code Comments
Columns Comments for SARCHKL_REQ_DATE2 (# 7)
Source Code Comments
Columns Comments for SARCHKL_REQ_COUNT (# 8)
Source Code Comments
Columns Comments for SARCHKL_DEADLINE_DATE (# 9)
Source Code Comments
Columns Comments for SARCHKL_RECEIVE_DATE (# 10)
Source Code Comments
Columns Comments for SARCHKL_COMMENT (# 11)
Source Code Comments
Columns Comments for SARCHKL_CODE_VALUE (# 12)
Source Code Comments
Columns Comments for SARCHKL_SOURCE (# 13)
Source Code Comments
Columns Comments for SARCHKL_SOURCE_DATE (# 14)
Source Code Comments
Columns Comments for SARCHKL_ACTIVITY_DATE (# 15)
Source Code Comments
Columns Comments for SARCHKL_PRINT_IND (# 16)
Source Code Comments
Columns Comments for SARCHKL_CKSR_CODE (# 17)
Source Code Comments
Columns Comments for SARCHKL_CKST_CODE (# 18)
Source Code Comments
Table SPRIDEN
Object Full Name
Source Code Comments
Columns Comments for SPRIDEN_PIDM (# 1)
Source Code Comments
Columns Comments for SPRIDEN_ID (# 2)
Source Code Comments
Columns Comments for SPRIDEN_LAST_NAME (# 3)
Source Code Comments
Columns Comments for SPRIDEN_FIRST_NAME (# 4)
Source Code Comments
Columns Comments for SPRIDEN_MI (# 5)
Source Code Comments
Columns Comments for SPRIDEN_CHANGE_IND (# 6)
Source Code Comments
Columns Comments for SPRIDEN_ENTITY_IND (# 7)
Source Code Comments
Columns Comments for SPRIDEN_ACTIVITY_DATE (# 8)
Source Code Comments
Columns Comments for SPRIDEN_USER (# 9)
Source Code Comments
Columns Comments for SPRIDEN_ORIGIN (# 10)
Source Code Comments
Columns Comments for SPRIDEN_SEARCH_LAST_NAME (# 11)
Source Code Comments
Columns Comments for SPRIDEN_SEARCH_FIRST_NAME (# 12)
Source Code Comments
Columns Comments for SPRIDEN_SEARCH_MI (# 13)
Source Code Comments
Columns Comments for SPRIDEN_SOUNDEX_LAST_NAME (# 14)
Source Code Comments
Columns Comments for SPRIDEN_SOUNDEX_FIRST_NAME (# 15)
Source Code Comments
Columns Comments for SPRIDEN_NTYP_CODE (# 16)
Source Code Comments
Columns Comments for SPRIDEN_CREATE_USER (# 17)
Source Code Comments
Columns Comments for SPRIDEN_CREATE_DATE (# 18)
Source Code Comments
Columns Comments for SPRIDEN_DATA_ORIGIN (# 19)
Source Code Comments
Columns Comments for SPRIDEN_CREATE_FDMN_CODE (# 20)
Source Code Comments
Columns Comments for SPRIDEN_SURNAME_PREFIX (# 21)
Source Code Comments
Table STVADMR
Object Full Name
Source Code Comments
Columns Comments for STVADMR_CODE (# 1)
Source Code Comments
Columns Comments for STVADMR_DESC (# 2)
Source Code Comments
Columns Comments for STVADMR_TABLE_NAME (# 3)
Source Code Comments
Columns Comments for STVADMR_ACTIVITY_DATE (# 4)
Source Code Comments
Columns Comments for STVADMR_VR_MSG_NO (# 5)
Source Code Comments
Columns Comments for STVADMR_VR_ELIG_IND (# 6)
Source Code Comments
Columns Comments for STVADMR_DISP_WEB_IND (# 7)
Source Code Comments
Table STVEMPT
Object Full Name
Source Code Comments
Columns Comments for STVEMPT_CODE (# 1)
Source Code Comments
Columns Comments for STVEMPT_DESC (# 2)
Source Code Comments
Columns Comments for STVEMPT_ACTIVITY_DATE (# 3)
Source Code Comments
Table STVLANG
Object Full Name
Source Code Comments
Columns Comments for STVLANG_CODE (# 1)
Source Code Comments
Columns Comments for STVLANG_DESC (# 2)
Source Code Comments
Columns Comments for STVLANG_ACTIVITY_DATE (# 3)
Source Code Comments
Table STVNATN
Object Full Name
Source Code Comments
Columns Comments for STVNATN_CODE (# 1)
Source Code Comments
Columns Comments for STVNATN_NATION (# 2)
Source Code Comments
Columns Comments for STVNATN_CAPITAL (# 3)
Source Code Comments
Columns Comments for STVNATN_AREA (# 4)
Source Code Comments
Columns Comments for STVNATN_POPULATION (# 5)
Source Code Comments
Columns Comments for STVNATN_ACTIVITY_DATE (# 6)
Source Code Comments
Columns Comments for STVNATN_EDI_EQUIV (# 7)
Source Code Comments
Columns Comments for STVNATN_LMS_EQUIV (# 8)
Source Code Comments
Columns Comments for STVNATN_STATSCAN_CDE (# 11)
Source Code Comments
Columns Comments for STVNATN_SCOD_CODE_ISO (# 12)
Source Code Comments
Columns Comments for STVNATN_SSA_REPORTING_EQUIV (# 13)
Source Code Comments
Columns Comments for STVNATN_SEVIS_EQUIV (# 14)
Source Code Comments
Table STVPENT
Object Full Name
Source Code Comments
Columns Comments for STVPENT_CODE (# 1)
Source Code Comments
Columns Comments for STVPENT_DESC (# 2)
Source Code Comments
Columns Comments for STVPENT_ACTIVITY_DATE (# 3)
Source Code Comments
Columns Comments for STVPENT_SEVIS_EQUIV (# 4)
Source Code Comments
Table STVSPON
Object Full Name
Source Code Comments
Columns Comments for STVSPON_CODE (# 1)
Source Code Comments
Columns Comments for STVSPON_DESC (# 2)
Source Code Comments
Columns Comments for STVSPON_ACTIVITY_DATE (# 3)
Source Code Comments
Table STVVTYP
Object Full Name
Source Code Comments
Columns Comments for STVVTYP_CODE (# 1)
Source Code Comments
Columns Comments for STVVTYP_DESC (# 2)
Source Code Comments
Columns Comments for STVVTYP_ACTIVITY_DATE (# 3)
Source Code Comments
Columns Comments for STVVTYP_ADMR_CODE (# 4)
Source Code Comments
Columns Comments for STVVTYP_NON_RES_IND (# 5)
Source Code Comments
Columns Comments for STVVTYP_VR_MSG_NO (# 6)
Source Code Comments
Columns Comments for STVVTYP_DISP_WEB_IND (# 7)
Source Code Comments
Columns Comments for STVVTYP_STATSCAN_CDE2 (# 8)
Source Code Comments
Columns Comments for STVVTYP_SEVIS_EQUIV (# 9)
Source Code Comments
Link between SPRIDEN and SARADAP
Join Information
Link between GORVISA and SARADAP
Join Information
Link between GOBINTL and GORVISA
Join Information
Link between SPRIDEN and GORVISA
Join Information
Link between GOBINTL and SARCHKL
Join Information
Link between GORVISA and STVNATN
Link between GOBINTL and STVNATN
Link between GORVISA and GTVVISS
Link between GOBINTL and GTVCELG
Link between GORDOCM and GORVISA
Link between GORDOCM and GTVDOCM
Link between GORDOCM and GTVSRCE
Link between GOBINTL and STVEMPT
Link between GOBINTL and STVLANG
Link between GORVISA and STVPENT
Link between SARCHKL and STVADMR
Link between GOBINTL and STVADMR
Link between GORDOCM and STVVTYP
Link between GORVISA and STVVTYP
Link between STVVTYP and STVADMR
Link between GOBINTL and STVSPON
Link between SARCHKL and SARADAP