Model Multi-Visa

Model Label : Banner General Multi-Visa
Path : BANNER DEV/General/ERD/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 Reference	User Object	Default
SARCHKL	TABLE	Default
SPRIDEN	TABLE	Default
SPRIDEN reference	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 MALDEV8_B60
Creation Date 06/11/2003 11:13:13:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GOBINTL_PIDM	GOBINTL_PIDM	NUMBER(8,0)	No	*	*
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_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_PIDM	GORVISA_PIDM	GORVISA
GOBINTL_ADMR_CODE	SARCHKL_ADMR_CODE	SARCHKL
GOBINTL_PIDM	SARCHKL_PIDM	SARCHKL
GOBINTL_ADMR_CODE	STVADMR_CODE	STVADMR
GOBINTL_EMPT_CODE	STVEMPT_CODE	STVEMPT
GOBINTL_LANG_CODE	STVLANG_CODE	STVLANG
GOBINTL_SPON_CODE	STVSPON_CODE	STVSPON

Index

Index Name	Index Type	Column Name
PK_GOBINTL	Unique	GOBINTL_PIDM

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 MALDEV8_B60
Creation Date 06/11/2003 11:12:56: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_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

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 MALDEV8_B60
Creation Date 06/11/2003 10:20:47: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
GORVISA_PIDM	SARADAP_PIDM	SARADAP

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

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 MALDEV8_B60
Creation Date 04/15/2002 18:04:32:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
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

Comments

Source Code Comments

Certification of Eligibility Table

Columns Comments for GTVCELG_CODE (1)

Source Code Comments

ELIGIBILITY CODE: This field indicates Certification of Eligibility Validation code.

Columns Comments for GTVCELG_DESC (2)

Source Code Comments

DESCRIPTION: This field indicates Certification of Eligibility Description.

Columns Comments for GTVCELG_USER_ID (3)

Source Code Comments

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

Columns Comments for GTVCELG_ACTIVITY_DATE (4)

Source Code Comments

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

Table GTVDOCM

Schema Name GENERAL
Label GTVDOCM
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:32:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
GTVDOCM_CODE	GTVDOCM_CODE	VARCHAR2(6)	No	*
GTVDOCM_DESC	GTVDOCM_DESC	VARCHAR2(30)	No
GTVDOCM_USER_ID	GTVDOCM_USER_ID	VARCHAR2(30)	No
GTVDOCM_ACTIVITY_DATE	GTVDOCM_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVDOCM	Unique	GTVDOCM_CODE

Comments

Source Code Comments

Document Code Validation Table

Columns Comments for GTVDOCM_CODE (1)

Source Code Comments

DOCUMENT CODE: This field indicates Document Code.

Columns Comments for GTVDOCM_DESC (2)

Source Code Comments

DESCRIPTION: This field indicates Document Description.

Columns Comments for GTVDOCM_USER_ID (3)

Source Code Comments

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

Columns Comments for GTVDOCM_ACTIVITY_DATE (4)

Source Code Comments

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

Table GTVSRCE

Schema Name GENERAL
Label GTVSRCE
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:35:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
GTVSRCE_CODE	GTVSRCE_CODE	VARCHAR2(6)	No	*
GTVSRCE_DESC	GTVSRCE_DESC	VARCHAR2(30)	No
GTVSRCE_USER_ID	GTVSRCE_USER_ID	VARCHAR2(30)	No
GTVSRCE_ACTIVITY_DATE	GTVSRCE_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVSRCE	Unique	GTVSRCE_CODE

Comments

Source Code Comments

Visa Source Code Validation Table

Columns Comments for GTVSRCE_CODE (1)

Source Code Comments

SOURCE CODE: This field indicates Source Code Validation code.

Columns Comments for GTVSRCE_DESC (2)

Source Code Comments

DESCRIPTION: This field indicates Source Description.

Columns Comments for GTVSRCE_USER_ID (3)

Source Code Comments

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

Columns Comments for GTVSRCE_ACTIVITY_DATE (4)

Source Code Comments

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

Table GTVVISS

Schema Name GENERAL
Label GTVVISS
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:36:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
GTVVISS_CODE	GTVVISS_CODE	VARCHAR2(6)	No	*
GTVVISS_DESC	GTVVISS_DESC	VARCHAR2(30)	No
GTVVISS_USER_ID	GTVVISS_USER_ID	VARCHAR2(30)	No
GTVVISS_ACTIVITY_DATE	GTVVISS_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVVISS	Unique	GTVVISS_CODE

Comments

Source Code Comments

Visa Issuing Authority Validation Table

Columns Comments for GTVVISS_CODE (1)

Source Code Comments

AUTHORITY CODE: This field indicates Visa Issuing Authority Validation code.

Columns Comments for GTVVISS_DESC (2)

Source Code Comments

DESCRIPTION: This field indicates Visa Issuing Authority Description.

Columns Comments for GTVVISS_USER_ID (3)

Source Code Comments

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

Columns Comments for GTVVISS_ACTIVITY_DATE (4)

Source Code Comments

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

Table SARADAP

Schema Name SATURN
Label SARADAP
Server name MALDEV8_B60
Creation Date 04/28/2003 16:17:53:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SARADAP_PIDM	SARADAP_PIDM	NUMBER(8,0)	No	*	*
SARADAP_PIDM	SARADAP_PIDM	NUMBER(8,0)	No	*	*
SARADAP_PIDM	SARADAP_PIDM	NUMBER(8,0)	No	*	*
SARADAP_TERM_CODE_ENTRY	SARADAP_TERM_CODE_ENTRY	VARCHAR2(6)	No	*	*
SARADAP_TERM_CODE_ENTRY	SARADAP_TERM_CODE_ENTRY	VARCHAR2(6)	No	*	*
SARADAP_TERM_CODE_ENTRY	SARADAP_TERM_CODE_ENTRY	VARCHAR2(6)	No	*	*
SARADAP_APPL_NO	SARADAP_APPL_NO	NUMBER(2,0)	No	*	*
SARADAP_LEVL_CODE	SARADAP_LEVL_CODE	VARCHAR2(2)	No		*
SARADAP_APPL_DATE	SARADAP_APPL_DATE	DATE	No
SARADAP_APST_CODE	SARADAP_APST_CODE	VARCHAR2(1)	No		*
SARADAP_APST_DATE	SARADAP_APST_DATE	DATE	No
SARADAP_MAINT_IND	SARADAP_MAINT_IND	VARCHAR2(1)	No
SARADAP_ADMT_CODE	SARADAP_ADMT_CODE	VARCHAR2(2)	Yes		*
SARADAP_STYP_CODE	SARADAP_STYP_CODE	VARCHAR2(1)	No		*
SARADAP_CAMP_CODE	SARADAP_CAMP_CODE	VARCHAR2(3)	Yes		*
SARADAP_SITE_CODE	SARADAP_SITE_CODE	VARCHAR2(3)	Yes		*
SARADAP_COLL_CODE_1	SARADAP_COLL_CODE_1	VARCHAR2(2)	No		*
SARADAP_DEGC_CODE_1	SARADAP_DEGC_CODE_1	VARCHAR2(6)	No		*
SARADAP_MAJR_CODE_1	SARADAP_MAJR_CODE_1	VARCHAR2(4)	No		*
SARADAP_COLL_CODE_2	SARADAP_COLL_CODE_2	VARCHAR2(2)	Yes		*
SARADAP_DEGC_CODE_2	SARADAP_DEGC_CODE_2	VARCHAR2(6)	Yes		*
SARADAP_MAJR_CODE_2	SARADAP_MAJR_CODE_2	VARCHAR2(4)	Yes		*
SARADAP_RESD_CODE	SARADAP_RESD_CODE	VARCHAR2(1)	No		*
SARADAP_FULL_PART_IND	SARADAP_FULL_PART_IND	VARCHAR2(1)	Yes
SARADAP_SESS_CODE	SARADAP_SESS_CODE	VARCHAR2(1)	Yes		*
SARADAP_WRSN_CODE	SARADAP_WRSN_CODE	VARCHAR2(2)	Yes		*
SARADAP_INTV_CODE	SARADAP_INTV_CODE	VARCHAR2(1)	Yes		*
SARADAP_FEE_IND	SARADAP_FEE_IND	VARCHAR2(1)	Yes
SARADAP_FEE_DATE	SARADAP_FEE_DATE	DATE	Yes
SARADAP_ACTIVITY_DATE	SARADAP_ACTIVITY_DATE	DATE	No
SARADAP_RATE_CODE	SARADAP_RATE_CODE	VARCHAR2(5)	Yes		*
SARADAP_EGOL_CODE	SARADAP_EGOL_CODE	VARCHAR2(2)	Yes		*
SARADAP_EDLV_CODE	SARADAP_EDLV_CODE	VARCHAR2(3)	Yes		*
SARADAP_MAJR_CODE_CONC_1	SARADAP_MAJR_CODE_CONC_1	VARCHAR2(4)	Yes		*
SARADAP_DEPT_CODE	SARADAP_DEPT_CODE	VARCHAR2(4)	Yes		*
SARADAP_SBGI_CODE	SARADAP_SBGI_CODE	VARCHAR2(6)	Yes		*
SARADAP_RECR_CODE	SARADAP_RECR_CODE	VARCHAR2(3)	Yes		*
SARADAP_RTYP_CODE	SARADAP_RTYP_CODE	VARCHAR2(2)	Yes		*
SARADAP_DEPT_CODE_2	SARADAP_DEPT_CODE_2	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_CONC_2	SARADAP_MAJR_CODE_CONC_2	VARCHAR2(4)	Yes		*
SARADAP_PROGRAM_1	SARADAP_PROGRAM_1	VARCHAR2(12)	Yes		*
SARADAP_TERM_CODE_CTLG_1	SARADAP_TERM_CODE_CTLG_1	VARCHAR2(6)	Yes		*
SARADAP_MAJR_CODE_1_2	SARADAP_MAJR_CODE_1_2	VARCHAR2(4)	Yes		*
SARADAP_DEPT_CODE_1_2	SARADAP_DEPT_CODE_1_2	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_CONC_1_2	SARADAP_MAJR_CODE_CONC_1_2	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_CONC_1_3	SARADAP_MAJR_CODE_CONC_1_3	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_CONC_121	SARADAP_MAJR_CODE_CONC_121	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_CONC_122	SARADAP_MAJR_CODE_CONC_122	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_CONC_123	SARADAP_MAJR_CODE_CONC_123	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_MINR_1_1	SARADAP_MAJR_CODE_MINR_1_1	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_MINR_1_2	SARADAP_MAJR_CODE_MINR_1_2	VARCHAR2(4)	Yes		*
SARADAP_PROGRAM_2	SARADAP_PROGRAM_2	VARCHAR2(12)	Yes		*
SARADAP_TERM_CODE_CTLG_2	SARADAP_TERM_CODE_CTLG_2	VARCHAR2(6)	Yes		*
SARADAP_LEVL_CODE_2	SARADAP_LEVL_CODE_2	VARCHAR2(2)	Yes		*
SARADAP_CAMP_CODE_2	SARADAP_CAMP_CODE_2	VARCHAR2(3)	Yes		*
SARADAP_MAJR_CODE_2_2	SARADAP_MAJR_CODE_2_2	VARCHAR2(4)	Yes		*
SARADAP_DEPT_CODE_2_2	SARADAP_DEPT_CODE_2_2	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_CONC_211	SARADAP_MAJR_CODE_CONC_211	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_CONC_212	SARADAP_MAJR_CODE_CONC_212	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_CONC_213	SARADAP_MAJR_CODE_CONC_213	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_CONC_221	SARADAP_MAJR_CODE_CONC_221	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_CONC_222	SARADAP_MAJR_CODE_CONC_222	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_CONC_223	SARADAP_MAJR_CODE_CONC_223	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_MINR_2_1	SARADAP_MAJR_CODE_MINR_2_1	VARCHAR2(4)	Yes		*
SARADAP_MAJR_CODE_MINR_2_2	SARADAP_MAJR_CODE_MINR_2_2	VARCHAR2(4)	Yes		*
SARADAP_CURR_RULE_1	SARADAP_CURR_RULE_1	NUMBER(8,0)	Yes		*
SARADAP_CMJR_RULE_1_1	SARADAP_CMJR_RULE_1_1	NUMBER(8,0)	Yes		*
SARADAP_CCON_RULE_11_1	SARADAP_CCON_RULE_11_1	NUMBER(8,0)	Yes		*
SARADAP_CCON_RULE_11_2	SARADAP_CCON_RULE_11_2	NUMBER(8,0)	Yes		*
SARADAP_CCON_RULE_11_3	SARADAP_CCON_RULE_11_3	NUMBER(8,0)	Yes		*
SARADAP_CMJR_RULE_1_2	SARADAP_CMJR_RULE_1_2	NUMBER(8,0)	Yes		*
SARADAP_CCON_RULE_12_1	SARADAP_CCON_RULE_12_1	NUMBER(8,0)	Yes		*
SARADAP_CCON_RULE_12_2	SARADAP_CCON_RULE_12_2	NUMBER(8,0)	Yes		*
SARADAP_CCON_RULE_12_3	SARADAP_CCON_RULE_12_3	NUMBER(8,0)	Yes		*
SARADAP_CMNR_RULE_1_1	SARADAP_CMNR_RULE_1_1	NUMBER(8,0)	Yes		*
SARADAP_CMNR_RULE_1_2	SARADAP_CMNR_RULE_1_2	NUMBER(8,0)	Yes		*
SARADAP_CURR_RULE_2	SARADAP_CURR_RULE_2	NUMBER(8,0)	Yes		*
SARADAP_CMJR_RULE_2_1	SARADAP_CMJR_RULE_2_1	NUMBER(8,0)	Yes		*
SARADAP_CCON_RULE_21_1	SARADAP_CCON_RULE_21_1	NUMBER(8,0)	Yes		*
SARADAP_CCON_RULE_21_2	SARADAP_CCON_RULE_21_2	NUMBER(8,0)	Yes		*
SARADAP_CCON_RULE_21_3	SARADAP_CCON_RULE_21_3	NUMBER(8,0)	Yes		*
SARADAP_CMJR_RULE_2_2	SARADAP_CMJR_RULE_2_2	NUMBER(8,0)	Yes		*
SARADAP_CCON_RULE_22_1	SARADAP_CCON_RULE_22_1	NUMBER(8,0)	Yes		*
SARADAP_CCON_RULE_22_2	SARADAP_CCON_RULE_22_2	NUMBER(8,0)	Yes		*
SARADAP_CCON_RULE_22_3	SARADAP_CCON_RULE_22_3	NUMBER(8,0)	Yes		*
SARADAP_CMNR_RULE_2_1	SARADAP_CMNR_RULE_2_1	NUMBER(8,0)	Yes		*
SARADAP_CMNR_RULE_2_2	SARADAP_CMNR_RULE_2_2	NUMBER(8,0)	Yes		*
SARADAP_WEB_ACCT_MISC_IND	SARADAP_WEB_ACCT_MISC_IND	VARCHAR2(1)	Yes
SARADAP_WEB_CASHIER_USER	SARADAP_WEB_CASHIER_USER	VARCHAR2(30)	Yes
SARADAP_WEB_TRANS_NO	SARADAP_WEB_TRANS_NO	NUMBER(8,0)	Yes
SARADAP_WEB_AMOUNT	SARADAP_WEB_AMOUNT	NUMBER(12,2)	Yes
SARADAP_WEB_RECEIPT_NUMBER	SARADAP_WEB_RECEIPT_NUMBER	NUMBER(8,0)	Yes
SARADAP_WAIV_CODE	SARADAP_WAIV_CODE	VARCHAR2(4)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SARADAP_ADMT_CODE	STVADMT_CODE	STVADMT
SARADAP_APST_CODE	STVAPST_CODE	STVAPST
SARADAP_EDLV_CODE	STVEDLV_CODE	STVEDLV
SARADAP_EGOL_CODE	STVEGOL_CODE	STVEGOL
SARADAP_INTV_CODE	STVINTV_CODE	STVINTV
SARADAP_RATE_CODE	STVRATE_CODE	STVRATE
SARADAP_RESD_CODE	STVRESD_CODE	STVRESD
SARADAP_RTYP_CODE	STVRTYP_CODE	STVRTYP
SARADAP_SESS_CODE	STVSESS_CODE	STVSESS
SARADAP_STYP_CODE	STVSTYP_CODE	STVSTYP
SARADAP_WAIV_CODE	STVWAIV_CODE	STVWAIV
SARADAP_WRSN_CODE	STVWRSN_CODE	STVWRSN
SARADAP_SITE_CODE	STVSITE_CODE	STVSITE
SARADAP_RECR_CODE	STVRECR_CODE	STVRECR
SARADAP_SBGI_CODE	STVSBGI_CODE	STVSBGI
SARADAP_PIDM	SRBRECR_PIDM	SRBRECR
SARADAP_TERM_CODE_ENTRY	SRBRECR_TERM_CODE	SRBRECR
SARADAP_TERM_CODE_ENTRY	SABVWID_TERM_CODE	SABVWID
SARADAP_APPL_NO	SABVWID_APPL_NO	SABVWID
SARADAP_PIDM	SABVWID_PIDM	SABVWID
SARADAP_PIDM	SORHSCH_PIDM	SORHSCH

Index

Index Name	Index Type	Column Name
PK_SARADAP	Unique	SARADAP_PIDM
PK_SARADAP	Unique	SARADAP_TERM_CODE_ENTRY
PK_SARADAP	Unique	SARADAP_APPL_NO

Comments

Source Code Comments

Admissions Application Repeating Table

Columns Comments for SARADAP_PIDM (1)

Source Code Comments

This field identifies the applicant internal identification number.

Columns Comments for SARADAP_TERM_CODE_ENTRY (2)

Source Code Comments

This field identifies the term associated with the information on applicant record.

Columns Comments for SARADAP_APPL_NO (3)

Source Code Comments

This field identifies the application number of the admissions record for a specific term.

Columns Comments for SARADAP_LEVL_CODE (4)

Source Code Comments

This field identifies the level to which the applicant is applying.

Columns Comments for SARADAP_APPL_DATE (5)

Source Code Comments

This field identifies the date of the application record.

Columns Comments for SARADAP_APST_CODE (6)

Source Code Comments

This field identifies the status of the application.

Columns Comments for SARADAP_APST_DATE (7)

Source Code Comments

This field identifies the date associated with the most current status of the application.

Columns Comments for SARADAP_MAINT_IND (8)

Source Code Comments

This field identifies whether the status of the application is being maintained by the system or the user.

Columns Comments for SARADAP_ADMT_CODE (9)

Source Code Comments

This field identifies the admission type of the applicant.

Columns Comments for SARADAP_STYP_CODE (10)

Source Code Comments

This field identifies the type of student the applicant will become if admitted.