GOBINTL GORDOCM GORVISA GTVCELG GTVDOCM GTVSRCE GTVVISS SARADAP SARCHKL SPRIDEN STVADMR STVEMPT STVLANG STVNATN STVPENT STVSPON STVVTYP SARADAP links SPRIDEN link

Model Multi-Visa


Model Label : Banner General Multi-Visa
Path : Default Folder/B70/General/Multi-Visa

List of Objects

Object Name Object Type Layer Name
GOBINTL TABLE Default
GORDOCM TABLE Default
GORVISA TABLE Default
GTVCELG TABLE Default
GTVDOCM TABLE Default
GTVSRCE TABLE Default
GTVVISS TABLE Default
SARADAP TABLE Default
SARADAP links User Object Default
SARCHKL TABLE Default
SPRIDEN TABLE Default
SPRIDEN link User Object Default
STVADMR TABLE Default
STVEMPT TABLE Default
STVLANG TABLE Default
STVNATN TABLE Default
STVPENT TABLE Default
STVSPON TABLE Default
STVVTYP TABLE Default

Comments

Model View

''

Table GOBINTL

Schema Name GENERAL
Label GOBINTL
Server name S4B70
Creation Date 09/29/2003 12:04:33:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GOBINTL_PIDM GOBINTL_PIDM NUMBER(8,0) No *
GOBINTL_SPOUSE_IND GOBINTL_SPOUSE_IND VARCHAR2(1) No
GOBINTL_SIGNATURE_IND GOBINTL_SIGNATURE_IND VARCHAR2(1) No
GOBINTL_USER_ID GOBINTL_USER_ID VARCHAR2(30) No
GOBINTL_ACTIVITY_DATE GOBINTL_ACTIVITY_DATE DATE No
GOBINTL_PASSPORT_ID GOBINTL_PASSPORT_ID VARCHAR2(15) Yes
GOBINTL_NATN_CODE_ISSUE GOBINTL_NATN_CODE_ISSUE VARCHAR2(5) Yes *
GOBINTL_PASSPORT_EXP_DATE GOBINTL_PASSPORT_EXP_DATE DATE Yes
GOBINTL_I94_STATUS GOBINTL_I94_STATUS VARCHAR2(3) Yes
GOBINTL_I94_DATE GOBINTL_I94_DATE DATE Yes
GOBINTL_REG_NUMBER GOBINTL_REG_NUMBER VARCHAR2(11) Yes
GOBINTL_DURATION GOBINTL_DURATION VARCHAR2(1) Yes
GOBINTL_CELG_CODE GOBINTL_CELG_CODE VARCHAR2(6) Yes *
GOBINTL_CERT_NUMBER GOBINTL_CERT_NUMBER VARCHAR2(11) Yes
GOBINTL_CERT_DATE_ISSUE GOBINTL_CERT_DATE_ISSUE DATE Yes
GOBINTL_CERT_DATE_RECEIPT GOBINTL_CERT_DATE_RECEIPT DATE Yes
GOBINTL_ADMR_CODE GOBINTL_ADMR_CODE VARCHAR2(4) Yes *
GOBINTL_NATN_CODE_BIRTH GOBINTL_NATN_CODE_BIRTH VARCHAR2(5) Yes *
GOBINTL_NATN_CODE_LEGAL GOBINTL_NATN_CODE_LEGAL VARCHAR2(5) Yes *
GOBINTL_LANG_CODE GOBINTL_LANG_CODE VARCHAR2(3) Yes *
GOBINTL_SPON_CODE GOBINTL_SPON_CODE VARCHAR2(3) Yes *
GOBINTL_EMPT_CODE GOBINTL_EMPT_CODE VARCHAR2(3) Yes *
GOBINTL_FOREIGN_SSN GOBINTL_FOREIGN_SSN VARCHAR2(9) Yes
GOBINTL_CHILD_NUMBER GOBINTL_CHILD_NUMBER NUMBER(2,0) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
GOBINTL_CELG_CODE GTVCELG_CODE GTVCELG
GOBINTL_ADMR_CODE STVADMR_CODE STVADMR
GOBINTL_EMPT_CODE STVEMPT_CODE STVEMPT
GOBINTL_LANG_CODE STVLANG_CODE STVLANG
GOBINTL_NATN_CODE_ISSUE STVNATN_CODE STVNATN
GOBINTL_SPON_CODE STVSPON_CODE STVSPON
GOBINTL_NATN_CODE_BIRTH STVNATN_CODE STVNATN
GOBINTL_NATN_CODE_LEGAL STVNATN_CODE STVNATN

Index

Index Name Index Type Column Name
PK_GOBINTL Unique GOBINTL_PIDM

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
select_international_info C/C++ Function [F:\BANNER\C\SHREDIY.PC] Use(select )
MAA3 Cobol Paragraph [F:\banner\cobol].SERSBREC.MAA-MAINLINE-SECT Use(select )
check_gobintl C/C++ Function [F:\BANNER\C\SAPAMAL.PC] Use(select )
get_citizen_country C/C++ Function [F:\BANNER\C\PXRASCD.PC] Use(select )
hld_gobintl C/C++ Function [F:\BANNER\C\SAPAMAL.PC] Use(select )
sel_5_mem C/C++ Function [F:\BANNER\C\PEREO61.PC] Use(select )
sel_alien_reg_no C/C++ Function [F:\BANNER\C\RSRDSCP.PC] Use(select )
sel_alien_reg_num C/C++ Function [F:\BANNER\C\PEREO6D.PC] Use(select )
sel_citz_cc C/C++ Function [F:\BANNER\C\PEP1042.PC] Use(select )
sel_empl C/C++ Function [F:\BANNER\C\PEREO6D.PC] Use(select )
sel_eskl_cnt C/C++ Function [F:\BANNER\C\PEREO61.PC] Use(select )
sel_ethn_cnt C/C++ Function [F:\BANNER\C\PEREO61.PC] Use(select )
sel_foreign_ssn C/C++ Function [F:\BANNER\C\PXPMTTN.PC] Use(select )
sel_gobintl_foreign_ssn C/C++ Function [F:\BANNER\C\PXRT4AN.PC] Use(select )
sel_hire_fac_mem C/C++ Function [F:\BANNER\C\PEREO61.PC] Use(select )
sel_hire_mem C/C++ Function [F:\BANNER\C\PEREO61.PC] Use(select )
sel_hire_other_mem C/C++ Function [F:\BANNER\C\PEREO61.PC] Use(select )
sel_part_mem C/C++ Function [F:\BANNER\C\PEREO61.PC] Use(select )
sel_rank_mem C/C++ Function [F:\BANNER\C\PEREO61.PC] Use(select )
sel_ten_other C/C++ Function [F:\BANNER\C\PEREO61.PC] Use(select )
selmacro_i C/C++ Function [F:\BANNER\C\RSRDSCP.PC] Use(select )
selmacro_n C/C++ Function [F:\BANNER\C\RSRDSCP.PC] Use(select )
tape_body C/C++ Function [F:\BANNER\C\SAPAMAL.PC] Use()
GOBINTL SYNONYM S4B70.PUBLIC Rely on ()
AS_PERSON VIEW S4B70.BANINST1 Use(select )
PEVPRF1 VIEW S4B70.BANINST1 Use(select )
SAVADM2 VIEW S4B70.BANINST1 Use(select )
SPVINTL VIEW S4B70.BANINST1 Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.GOAINTL.GOBINTL.GOBINTL_ADMR_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.GOAINTL.GOBINTL.GOBINTL_ADMR_CODE Use(select )
CHECK_GOBINTL Forms Trigger BANNER7_FORMS.GOAINTL Use(select )
CHECK_GOBINTL Forms Trigger BANNER7_FORMS_10G.GOAINTL Use(select )
GET_VISA_DATE Forms Trigger BANNER7_FORMS.SAAADMS.SARCHKL Use(select )
GET_VISA_DATE Forms Trigger BANNER7_FORMS.SAAACKL.SARCHKL Use(select )
GET_VISA_DATE Forms Trigger BANNER7_FORMS_10G.SAAACKL.SARCHKL Use(select )
GET_VISA_DATE Forms Trigger BANNER7_FORMS_10G.SAAADMS.SARCHKL Use(select )
GET_VISA_VALUE Forms Trigger BANNER7_FORMS.SAAADMS.SARCHKL Use(select )
GET_VISA_VALUE Forms Trigger BANNER7_FORMS_10G.SAAACKL.SARCHKL Use(select )
GET_VISA_VALUE Forms Trigger BANNER7_FORMS_10G.SAAADMS.SARCHKL Use(select )
GET_VISA_VALUE Forms Trigger BANNER7_FORMS.SAAACKL.SARCHKL Use(select )
KEY-CREREC Forms Trigger BANNER7_FORMS.GOAINTL.GOBINTL Use(select )
KEY-CREREC Forms Trigger BANNER7_FORMS_10G.GOAINTL.GOBINTL Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.GTVCELG.GTVCELG Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.GTVCELG.GTVCELG Use(select )
P_GOBINTL_DELETE_ROW Package procedure S4B70.BANINST1.GOKINTL Rely on ()
P_GOBINTL_DELETE_ROW Package procedure S4B70.BANINST1.GOKINTL Use(delete )
P_GOBINTL_INSERT Package procedure S4B70.BANINST1.GOKINTL Rely on ()
P_GOBINTL_INSERT Package procedure S4B70.BANINST1.GOKINTL Use(insert )
P_GOBINTL_UPDATE_ROW Package procedure S4B70.BANINST1.GOKINTL Rely on ()
P_GOBINTL_UPDATE_ROW Package procedure S4B70.BANINST1.GOKINTL Use(update )
P_INSERT_INTL Package procedure S4B70.BANINST1.SRKPREL Rely on ()
P_INSERT_INTL Package procedure S4B70.BANINST1.SRKPREL Rely on () Use(select )
P_INTL_INSCHECKLIST Package procedure S4B70.BANINST1.SAKCHKB Use(select )
P_INTL_UPDCHECKLIST Package procedure S4B70.BANINST1.SAKCHKB Use(select )
P_INTL_UPDCOMMENT Package procedure S4B70.BANINST1.SAKCHKB Use(select )
P_LOAD_INTL Package procedure S4B70.BANINST1.SAKL030 Rely on ()
P_LOAD_INTL Package procedure S4B70.BANINST1.SAKL030 Rely on ()
P_MIGRATE_PROSPECT Package procedure S4B70.BANINST1.SRKPREL Use(select )
F_CHECK_GOBINTL_EXISTS Package function S4B70.BANINST1.GOKINTL Rely on ()
F_CHECK_GOBINTL_EXISTS Package function S4B70.BANINST1.GOKINTL Use(select )
F_GET_GOBINTL_ROWID Package function S4B70.BANINST1.GOKINTL Rely on ()
F_GET_GOBINTL_ROWID Package function S4B70.BANINST1.GOKINTL Use(select )
F_GOBINTL_SELECT Package function S4B70.BANINST1.GOKINTL Rely on ()
F_GOBINTL_SELECT Package function S4B70.BANINST1.GOKINTL Rely on () Use(select )
GOBINTL Forms DataBlock BANNER7_FORMS.GOAINTL Rely on () Use(insert,update,delete,select )
GOBINTL Forms DataBlock BANNER7_FORMS_10G.GOAINTL Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_GOBINTL INDEX S4B70."GENERAL" Rely on ()
GTVCELG TABLE S4B70."GENERAL" Refer( No Action )
STVADMR TABLE S4B70.SATURN Refer( No Action )
STVEMPT TABLE S4B70.SATURN Refer( No Action )
STVLANG TABLE S4B70.SATURN Refer( No Action )
STVNATN TABLE S4B70.SATURN Refer( No Action )
STVSPON TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Visa International Information Table

Columns Comments for GOBINTL_PIDM (1)

Source Code Comments

PERSONAL ID NUMBER: This field indicates Personal Identification Number.

Columns Comments for GOBINTL_SPOUSE_IND (2)

Source Code Comments

SPOUSE INDICATOR: This field indicates whether the Spouse Accompanied the person to the Country.

Columns Comments for GOBINTL_SIGNATURE_IND (3)

Source Code Comments

SIGNATURE INDICATOR: This field indicates Signature Available for Funds.

Columns Comments for GOBINTL_USER_ID (4)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user who changed the record.

Columns Comments for GOBINTL_ACTIVITY_DATE (5)

Source Code Comments

ACTIVITY DATE: The date that the information for the row was inserted or updated in the GOBINTL table.

Columns Comments for GOBINTL_PASSPORT_ID (6)

Source Code Comments

PASSPORT NUMBER: This field indicates Passport Identification Number.

Columns Comments for GOBINTL_NATN_CODE_ISSUE (7)

Source Code Comments

ISSUING NATION CODE: This field indicates the Country Code of the nation issuing the passport.

Columns Comments for GOBINTL_PASSPORT_EXP_DATE (8)

Source Code Comments

PASSPORT EXPIRATION DATE: This field indicates the date the passport expires.

Columns Comments for GOBINTL_I94_STATUS (9)

Source Code Comments

I94 STATUS: This field indicates whether the passport status is for Admission or Departure.

Columns Comments for GOBINTL_I94_DATE (10)

Source Code Comments

I94 EXPIRATION DATE: This field indicates the date the Admission or Departure expires.

Columns Comments for GOBINTL_REG_NUMBER (11)

Source Code Comments

REGISTRATION NUMBER: This field indicates a unique Passport Registration Number.

Columns Comments for GOBINTL_DURATION (12)

Source Code Comments

DURATION: This field indicates whether the Admission or Departure is for the Duration of the Stay.

Columns Comments for GOBINTL_CELG_CODE (13)

Source Code Comments

CERTIFICATION CODE: This field indicates Passport Certification Eligibility Code.

Columns Comments for GOBINTL_CERT_NUMBER (14)

Source Code Comments

CERTIFICATION NUMBER: This field indicates the Passport Certification Number.

Columns Comments for GOBINTL_CERT_DATE_ISSUE (15)

Source Code Comments

CERTIFICATION ISSUE DATE: This field indicates the date the Passport Certification was issued.

Columns Comments for GOBINTL_CERT_DATE_RECEIPT (16)

Source Code Comments

CERTIFICATION RECEIPT DATE: This field indicates the date the Passport Certification was received.

Columns Comments for GOBINTL_ADMR_CODE (17)

Source Code Comments

ADMISSION REQUEST CODE: This field indicates Admission Request Code.

Columns Comments for GOBINTL_NATN_CODE_BIRTH (18)

Source Code Comments

BIRTH NATION CODE: This field indicates the Country Code of the nation of the person's Birth.

Columns Comments for GOBINTL_NATN_CODE_LEGAL (19)

Source Code Comments

LEGAL NATION CODE: This field indicates the Country Code of the nation of the person's Citizenship.

Columns Comments for GOBINTL_LANG_CODE (20)

Source Code Comments

LANGUAGE CODE: This field indicates the person's native Language Code.

Columns Comments for GOBINTL_SPON_CODE (21)

Source Code Comments

SPONSOR CODE: This field indicates the Sponsor Code.

Columns Comments for GOBINTL_EMPT_CODE (22)

Source Code Comments

EMPLOYMENT TYPE CODE: This field indicates the person's type of Employment.

Columns Comments for GOBINTL_FOREIGN_SSN (23)

Source Code Comments

FOREIGN TAX ID: This field indicates a unique identification number for tax purposes: such as SSN.

Columns Comments for GOBINTL_CHILD_NUMBER (24)

Source Code Comments

CHILD NUMBER: This field indicates the Number of Children Accompaning the person to the Country.

Table GORDOCM

Schema Name GENERAL
Label GORDOCM
Server name S4B70
Creation Date 09/29/2003 12:04:33:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GORDOCM_PIDM GORDOCM_PIDM NUMBER(8,0) No * *
GORDOCM_SEQ_NO GORDOCM_SEQ_NO NUMBER(3,0) No * *
GORDOCM_VTYP_CODE GORDOCM_VTYP_CODE VARCHAR2(2) No * *
GORDOCM_VISA_NUMBER GORDOCM_VISA_NUMBER VARCHAR2(18) No * *
GORDOCM_DOCM_CODE GORDOCM_DOCM_CODE VARCHAR2(6) No * *
GORDOCM_DISPOSITION GORDOCM_DISPOSITION VARCHAR2(1) No
GORDOCM_USER_ID GORDOCM_USER_ID VARCHAR2(30) No
GORDOCM_ACTIVITY_DATE GORDOCM_ACTIVITY_DATE DATE No
GORDOCM_SRCE_CODE GORDOCM_SRCE_CODE VARCHAR2(6) Yes *
GORDOCM_REQUEST_DATE GORDOCM_REQUEST_DATE DATE Yes
GORDOCM_RECEIVED_DATE GORDOCM_RECEIVED_DATE DATE Yes

Foreign Key information

Column name is Foreign Key For Column on Table
GORDOCM_PIDM GORVISA_PIDM GORVISA
GORDOCM_SEQ_NO GORVISA_SEQ_NO GORVISA
GORDOCM_VTYP_CODE GORVISA_VTYP_CODE GORVISA
GORDOCM_VISA_NUMBER GORVISA_VISA_NUMBER GORVISA
GORDOCM_DOCM_CODE GTVDOCM_CODE GTVDOCM
GORDOCM_SRCE_CODE GTVSRCE_CODE GTVSRCE
GORDOCM_VTYP_CODE STVVTYP_CODE STVVTYP

Index

Index Name Index Type Column Name
PK_GORDOCM Unique GORDOCM_PIDM
PK_GORDOCM Unique GORDOCM_SEQ_NO
PK_GORDOCM Unique GORDOCM_VTYP_CODE
PK_GORDOCM Unique GORDOCM_VISA_NUMBER
PK_GORDOCM Unique GORDOCM_DOCM_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GORDOCM SYNONYM S4B70.PUBLIC Rely on ()
POST-CHANGE Forms Trigger BANNER7_FORMS.GOAINTL.GORDOCM.GORDOCM_DOCM_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.GOAINTL.GORDOCM.GORDOCM_DOCM_CODE Use(select )
CHECK_GORDOCM Forms Trigger BANNER7_FORMS.GOAINTL Use(select )
CHECK_GORDOCM Forms Trigger BANNER7_FORMS_10G.GOAINTL Use(select )
COMMIT_GORVISA Forms Trigger BANNER7_FORMS.GOAINTL Rely on () Use(insert,delete )
COMMIT_GORVISA Forms Trigger BANNER7_FORMS_10G.GOAINTL Rely on () Use(insert,delete )
KEY-DELREC Forms Trigger BANNER7_FORMS.GTVSRCE.GTVSRCE Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.GTVDOCM.GTVDOCM Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.GTVDOCM.GTVDOCM Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.GTVSRCE.GTVSRCE Use(select )
CHECK_GORVISA_DELETE Forms Function BANNER7_FORMS.GOAINTL Use(select )
CHECK_GORVISA_DELETE Forms Function BANNER7_FORMS_10G.GOAINTL Use(select )
P_GORDOCM_DELETE_ROW Package procedure S4B70.BANINST1.GOKINTL Rely on ()
P_GORDOCM_DELETE_ROW Package procedure S4B70.BANINST1.GOKINTL Use(delete )
P_GORDOCM_INSERT Package procedure S4B70.BANINST1.GOKINTL Rely on ()
P_GORDOCM_INSERT Package procedure S4B70.BANINST1.GOKINTL Use(insert )
P_GORDOCM_UPDATE_ROW Package procedure S4B70.BANINST1.GOKINTL Rely on ()
P_GORDOCM_UPDATE_ROW Package procedure S4B70.BANINST1.GOKINTL Use(update )
F_GORDOCM_SELECT Package function S4B70.BANINST1.GOKINTL Rely on ()
F_GORDOCM_SELECT Package function S4B70.BANINST1.GOKINTL Rely on () Use(select )
GORDOCM Forms DataBlock BANNER7_FORMS.GOAINTL Rely on () Use(insert,update,delete,select )
GORDOCM Forms DataBlock BANNER7_FORMS_10G.GOAINTL Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_GORDOCM INDEX S4B70."GENERAL" Rely on ()
GORVISA TABLE S4B70."GENERAL" Refer( No Action )
GTVDOCM TABLE S4B70."GENERAL" Refer( No Action )
GTVSRCE TABLE S4B70."GENERAL" Refer( No Action )
STVVTYP TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Document Information Table

Columns Comments for GORDOCM_PIDM (1)

Source Code Comments

PERSONAL ID NUMBER: This field indicates Personal Identification Number.

Columns Comments for GORDOCM_SEQ_NO (2)

Source Code Comments

SEQUENCE NUMBER: This field indicates a Record Sequence Number.

Columns Comments for GORDOCM_VTYP_CODE (3)

Source Code Comments

VISA TYPE CODE: This field indicates the Type of Visa Issued.

Columns Comments for GORDOCM_VISA_NUMBER (4)

Source Code Comments

VISA NUMBER: This field indicates a unique identification number assigned to a Visa.

Columns Comments for GORDOCM_DOCM_CODE (5)

Source Code Comments

DOCUMENT CODE: This field indicates the type of Document supporting the Visa.

Columns Comments for GORDOCM_DISPOSITION (6)

Source Code Comments

DOCUMENT DISPOSITION: This field indicates the status of the Document.

Columns Comments for GORDOCM_USER_ID (7)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user who changed the record.

Columns Comments for GORDOCM_ACTIVITY_DATE (8)

Source Code Comments

ACTIVITY DATE: The date that the information for the row was inserted or updated in the GORDOCM table.

Columns Comments for GORDOCM_SRCE_CODE (9)

Source Code Comments

SOURCE CODE: This field indicates the Source of the supporting document.

Columns Comments for GORDOCM_REQUEST_DATE (10)

Source Code Comments

REQUEST DATE: This field indicates the date the Document was requested.

Columns Comments for GORDOCM_RECEIVED_DATE (11)

Source Code Comments

RECEIVED DATE: This field indicates the date the Document was received.

Table GORVISA

Schema Name GENERAL
Label GORVISA
Server name S4B70
Creation Date 09/29/2003 12:04:34:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GORVISA_PIDM GORVISA_PIDM NUMBER(8,0) No *
GORVISA_SEQ_NO GORVISA_SEQ_NO NUMBER(3,0) No *
GORVISA_VTYP_CODE GORVISA_VTYP_CODE VARCHAR2(2) No * *
GORVISA_VISA_NUMBER GORVISA_VISA_NUMBER VARCHAR2(18) No *
GORVISA_NATN_CODE_ISSUE GORVISA_NATN_CODE_ISSUE VARCHAR2(5) No *
GORVISA_VISS_CODE GORVISA_VISS_CODE VARCHAR2(6) No *
GORVISA_VISA_START_DATE GORVISA_VISA_START_DATE DATE No
GORVISA_VISA_EXPIRE_DATE GORVISA_VISA_EXPIRE_DATE DATE No
GORVISA_ENTRY_IND GORVISA_ENTRY_IND VARCHAR2(1) No
GORVISA_USER_ID GORVISA_USER_ID VARCHAR2(30) No
GORVISA_ACTIVITY_DATE GORVISA_ACTIVITY_DATE DATE No
GORVISA_VISA_REQ_DATE GORVISA_VISA_REQ_DATE DATE Yes
GORVISA_VISA_ISSUE_DATE GORVISA_VISA_ISSUE_DATE DATE Yes
GORVISA_PENT_CODE GORVISA_PENT_CODE VARCHAR2(3) Yes *
GORVISA_NO_ENTRIES GORVISA_NO_ENTRIES VARCHAR2(2) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
GORVISA_VISS_CODE GTVVISS_CODE GTVVISS
GORVISA_NATN_CODE_ISSUE STVNATN_CODE STVNATN
GORVISA_PENT_CODE STVPENT_CODE STVPENT
GORVISA_VTYP_CODE STVVTYP_CODE STVVTYP

Index

Index Name Index Type Column Name
PK_GORVISA Unique GORVISA_PIDM
PK_GORVISA Unique GORVISA_SEQ_NO
PK_GORVISA Unique GORVISA_VTYP_CODE
PK_GORVISA Unique GORVISA_VISA_NUMBER

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
get_citizen_country C/C++ Function [F:\BANNER\C\PXRASCD.PC] Use(select )
sel_citz_code C/C++ Function [F:\BANNER\C\RSRDSCP.PC] Use(select )
selmacro_i C/C++ Function [F:\BANNER\C\RSRDSCP.PC] Use(select )
selmacro_n C/C++ Function [F:\BANNER\C\RSRDSCP.PC] Use(select )
GORVISA SYNONYM S4B70.PUBLIC Rely on ()
GORDOCM TABLE S4B70."GENERAL" Refer( No Action )
AS_PERSON VIEW S4B70.BANINST1 Use(select )
PEVPRF1 VIEW S4B70.BANINST1 Use(select )
SAVADM2 VIEW S4B70.BANINST1 Use(select )
SAVAMCD VIEW S4B70.BANINST1 Use(select )
SPVINTL VIEW S4B70.BANINST1 Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.GOAINTL.GORVISA.GORVISA_VISA_EXPIRE_DATE_DISP Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.GOAINTL.GORVISA.GORVISA_VISA_START_DATE_DISP Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.GOAINTL.GORVISA.GORVISA_VISA_EXPIRE_DATE_DISP Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.GOAINTL.GORVISA.GORVISA_VISA_START_DATE_DISP Use(select )
GET_MAX_SEQNO Forms Trigger BANNER7_FORMS.GOAINTL Use(select )
GET_MAX_SEQNO Forms Trigger BANNER7_FORMS_10G.GOAINTL Use(select )
GET_RECORD_NUMBER Forms Trigger BANNER7_FORMS.GOAINTL Use(select )
GET_RECORD_NUMBER Forms Trigger BANNER7_FORMS_10G.GOAINTL Use(select )
MISC_CODES Forms Trigger BANNER7_FORMS.RJASERF Use(select )
MISC_CODES Forms Trigger BANNER7_FORMS_10G.RJASERF Use(select )
GET_VISA_DATE Forms Trigger BANNER7_FORMS.SAAADMS.SARCHKL Use(select )
GET_VISA_DATE Forms Trigger BANNER7_FORMS.SAAACKL.SARCHKL Use(select )
GET_VISA_DATE Forms Trigger BANNER7_FORMS_10G.SAAADMS.SARCHKL Use(select )
GET_VISA_DATE Forms Trigger BANNER7_FORMS_10G.SAAACKL.SARCHKL Use(select )
GET_VISA_VALUE Forms Trigger BANNER7_FORMS.SAAADMS.SARCHKL Use(select )
GET_VISA_VALUE Forms Trigger BANNER7_FORMS.SAAACKL.SARCHKL Use(select )
GET_VISA_VALUE Forms Trigger BANNER7_FORMS_10G.SAAACKL.SARCHKL Use(select )
GET_VISA_VALUE Forms Trigger BANNER7_FORMS_10G.SAAADMS.SARCHKL Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS.GTVVISS.GTVVISS Use(select )
KEY-DELREC Forms Trigger BANNER7_FORMS_10G.GTVVISS.GTVVISS Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS.GOAINTL.GORDOCM Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.GOAINTL.GORDOCM Use(select )
CHECK_EXPIRE_DATES Forms Function BANNER7_FORMS.GOAINTL Use(select )
CHECK_EXPIRE_DATES Forms Function BANNER7_FORMS_10G.GOAINTL Use(select )
CHECK_NULL_DATES Forms Function BANNER7_FORMS.GOAINTL Use(select )
CHECK_NULL_DATES Forms Function BANNER7_FORMS_10G.GOAINTL Use(select )
F_MATCH_VTYP Package function S4B70.BANINST1.SOKAINF Use(select )
P_GET_VISA_CODE Package procedure S4B70.BANINST1.POKWLIB Rely on ()
P_GORVISA_DELETE_ROW Package procedure S4B70.BANINST1.GOKINTL Rely on ()
P_GORVISA_DELETE_ROW Package procedure S4B70.BANINST1.GOKINTL Use(delete )
P_GORVISA_INSERT Package procedure S4B70.BANINST1.GOKINTL Rely on ()
P_GORVISA_INSERT Package procedure S4B70.BANINST1.GOKINTL Use(insert )
P_GORVISA_UPDATE_ROW Package procedure S4B70.BANINST1.GOKINTL Rely on ()
P_GORVISA_UPDATE_ROW Package procedure S4B70.BANINST1.GOKINTL Use(update )
P_INSERT_INTL Package procedure S4B70.BANINST1.SRKPREL Rely on ()
P_INSERT_INTL Package procedure S4B70.BANINST1.SRKPREL Use(select )
P_INTL_INSCHECKLIST Package procedure S4B70.BANINST1.SAKCHKB Use(select )
P_INTL_UPDCHECKLIST Package procedure S4B70.BANINST1.SAKCHKB Rely on ()
P_INTL_UPDCHECKLIST Package procedure S4B70.BANINST1.SAKCHKB Use(select )
P_INTL_UPDCOMMENT Package procedure S4B70.BANINST1.SAKCHKB Use(select )
P_LOAD_INTL Package procedure S4B70.BANINST1.SAKL030 Rely on ()
P_LOAD_INTL Package procedure S4B70.BANINST1.SAKL030 Rely on () Use(select )
P_MIGRATE_PROSPECT Package procedure S4B70.BANINST1.SRKPREL Use(select )
F_CHECK_GORVISA_EXISTS Package function S4B70.BANINST1.GOKINTL Rely on ()
F_CHECK_GORVISA_EXISTS Package function S4B70.BANINST1.GOKINTL Use(select )
F_CHECK_NONRESIDENT_STATUS Package function S4B70.BANINST1.GOKINTL Rely on ()
F_CHECK_NONRESIDENT_STATUS Package function S4B70.BANINST1.GOKINTL Use(select )
F_CHECK_VISA Package function S4B70.BANINST1.GOKVISA Rely on ()
F_CHECK_VISA Package function S4B70.BANINST1.GOKVISA Use(select )
F_GET_GORVISA_ROWID Package function S4B70.BANINST1.GOKINTL Rely on ()
F_GET_GORVISA_ROWID Package function S4B70.BANINST1.GOKINTL Use(select )
F_GORVISA_SELECT Package function S4B70.BANINST1.GOKINTL Rely on ()
F_GORVISA_SELECT Package function S4B70.BANINST1.GOKINTL Rely on () Use(select )
F_MOST_RECENT_VISA_ROWID Package function S4B70.BANINST1.GOKODSF Use(select )
F_VALID_VISA Package function S4B70.BANINST1.GOKINTL Rely on ()
F_VALID_VISA Package function S4B70.BANINST1.GOKINTL Use(select )
GORVISA Forms DataBlock BANNER7_FORMS.GOAINTL Rely on () Use(insert,update,delete,select )
GORVISA Forms DataBlock BANNER7_FORMS_10G.GOAINTL Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_GORVISA INDEX S4B70."GENERAL" Rely on ()
GTVVISS TABLE S4B70."GENERAL" Refer( No Action )
STVNATN TABLE S4B70.SATURN Refer( No Action )
STVPENT TABLE S4B70.SATURN Refer( No Action )
STVVTYP TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

Visa Information Table

Columns Comments for GORVISA_PIDM (1)

Source Code Comments

PERSONAL ID NUMBER: This field indicates Personal Identification Number.

Columns Comments for GORVISA_SEQ_NO (2)

Source Code Comments

SEQUENCE NUMBER: This field indicates a Record Sequence Number.

Columns Comments for GORVISA_VTYP_CODE (3)

Source Code Comments

VISA TYPE CODE: This field indicates the Type of Visa Issued.

Columns Comments for GORVISA_VISA_NUMBER (4)

Source Code Comments

VISA NUMBER: This field indicates a unique identification number assigned to a Visa.

Columns Comments for GORVISA_NATN_CODE_ISSUE (5)

Source Code Comments

ISSUING NATION CODE: This field indicates the Country Code of the nation issuing the visa.

Columns Comments for GORVISA_VISS_CODE (6)

Source Code Comments

ISSUE AUTHORITY: This field indicates the Agency authorizing the visa.

Columns Comments for GORVISA_VISA_START_DATE (7)

Source Code Comments

VISA START DATE: This field indicates the date the visa begins.

Columns Comments for GORVISA_VISA_EXPIRE_DATE (8)

Source Code Comments

VISA EXPIRE DATE: This field indicates the date the visa expires.

Columns Comments for GORVISA_ENTRY_IND (9)

Source Code Comments

ENTRY INDICATOR: This field indicates whether the visa is for entry into the country.

Columns Comments for GORVISA_USER_ID (10)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user who changed the record.

Columns Comments for GORVISA_ACTIVITY_DATE (11)

Source Code Comments

ACTIVITY DATE: The date that the information for the row was inserted or updated in the GORVISA table.

Columns Comments for GORVISA_VISA_REQ_DATE (12)

Source Code Comments

VISA REQUEST DATE: This field indicates the date the Visa was requested.

Columns Comments for GORVISA_VISA_ISSUE_DATE (13)

Source Code Comments

VISA ISSUE DATE: This field indicates the date the Visa was Issued.

Columns Comments for GORVISA_PENT_CODE (14)

Source Code Comments

PORT OF ENTRY: This field indicates the Port of Entry into the country.

Columns Comments for GORVISA_NO_ENTRIES (15)

Source Code Comments

NUMBER OF ENTRIES: This field indicates the Number of Entries into the country.

Table GTVCELG

Schema Name GENERAL
Label GTVCELG
Server name S4B70
Creation Date 09/29/2003 12:04:34:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVCELG_CODE GTVCELG_CODE VARCHAR2(6) No *
GTVCELG_DESC GTVCELG_DESC VARCHAR2(30) No
GTVCELG_USER_ID GTVCELG_USER_ID VARCHAR2(30) No
GTVCELG_ACTIVITY_DATE GTVCELG_ACTIVITY_DATE DATE No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVCELG Unique GTVCELG_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
GTVCELG SYNONYM S4B70.PUBLIC Rely on ()
GOBINTL TABLE S4B70."GENERAL" Refer( No Action )
POST-CHANGE Forms Trigger BANNER7_FORMS.GOAINTL.GOBINTL.GOBINTL_CELG_CODE Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.GOAINTL.GOBINTL.GOBINTL_CELG_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.GTVCELG.GTVCELG.GTVCELG_CODE Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.GTVCELG.GTVCELG.GTVCELG_CODE Use(select )
GTVCELG_RG Forms Record Group BANNER7_FORMS.GOQOLIB Use(select )
GTVCELG_RG Forms Record Group BANNER7_FORMS.GOAINTL Use(select )
GTVCELG_RG Forms Record Group BANNER7_FORMS_10G.GOAINTL Use(select )
GTVCELG_RG Forms Record Group BANNER7_FORMS_10G.GOQOLIB Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS.GTVCELG.GTVCELG Use(select )
PRE-INSERT Forms Trigger BANNER7_FORMS_10G.GTVCELG.GTVCELG Use(select )
GTVCELG_C Package cursor S4B70.BANINST1.GB_GTVCELG Rely on ()
GTVCELG_C Package cursor S4B70.BANINST1.GB_GTVCELG Rely on () Use(select )
F_CODE_EXISTS Package function S4B70.BANINST1.GB_GTVCELG Rely on ()
F_CODE_EXISTS Package function S4B70.BANINST1.GB_GTVCELG Rely on ()
F_GET_DESCRIPTION Package function S4B70.BANINST1.GB_GTVCELG Rely on ()
F_GET_DESCRIPTION Package function S4B70.BANINST1.GB_GTVCELG Rely on ()
GTVCELG Forms DataBlock BANNER7_FORMS.GTVCELG Rely on () Use(insert,update,delete,select )
GTVCELG Forms DataBlock BANNER7_FORMS_10G.GTVCELG Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name