Model SPBPERS

Model Label : SPBPERS links
Path : Default Folder/B70/Common/SPBPERS

List of Objects

Object Name	Object Type	Layer Name
APRCSPS	TABLE	Default
GOBSEVS	TABLE	Default
GORSEVD	TABLE	Default
GTVUOMS	TABLE	Default
PDRBENE	TABLE	Default
SARADAP	TABLE	Default
SARDCSN	TABLE	Default
SGBSTDN	TABLE	Default
SHRDGMR	TABLE	Default
SLRRASG	TABLE	Default
SLRRMAT	TABLE	Default
SPBPERS	TABLE	Default
SPRIDEN	TABLE	Default
STVCITZ	TABLE	Default
STVETHN	TABLE	Default
STVLGCY	TABLE	Default
STVMRTL	TABLE	Default
STVNATN	TABLE	Default
STVRELG	TABLE	Default
STVSTAT	TABLE	Default

Comments

Model View

Table APRCSPS

Schema Name ALUMNI
Label APRCSPS
Server name S4B70
Creation Date 09/29/2003 12:12:54:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
APRCSPS_PIDM	APRCSPS_PIDM	NUMBER(8,0)	No	*
APRCSPS_MARS_IND	APRCSPS_MARS_IND	VARCHAR2(1)	No
APRCSPS_ACTIVITY_DATE	APRCSPS_ACTIVITY_DATE	DATE	No
APRCSPS_SPS_PIDM	APRCSPS_SPS_PIDM	NUMBER(8,0)	Yes	*
APRCSPS_LAST_NAME	APRCSPS_LAST_NAME	VARCHAR2(60)	Yes
APRCSPS_FIRST_NAME	APRCSPS_FIRST_NAME	VARCHAR2(15)	Yes
APRCSPS_MAIDEN_NAME	APRCSPS_MAIDEN_NAME	VARCHAR2(60)	Yes
APRCSPS_NAME_PREFIX	APRCSPS_NAME_PREFIX	VARCHAR2(20)	Yes
APRCSPS_NAME_SUFFIX	APRCSPS_NAME_SUFFIX	VARCHAR2(20)	Yes
APRCSPS_BIRTH_DATE	APRCSPS_BIRTH_DATE	DATE	Yes
APRCSPS_SPS_COMMENT	APRCSPS_SPS_COMMENT	VARCHAR2(60)	Yes
APRCSPS_MRTL_CODE	APRCSPS_MRTL_CODE	VARCHAR2(1)	Yes	*
APRCSPS_MRTL_START_DATE	APRCSPS_MRTL_START_DATE	DATE	Yes
APRCSPS_MRTL_END_DATE	APRCSPS_MRTL_END_DATE	DATE	Yes
APRCSPS_DEAD_IND	APRCSPS_DEAD_IND	VARCHAR2(1)	Yes
APRCSPS_DEAD_DATE	APRCSPS_DEAD_DATE	DATE	Yes
APRCSPS_XREF_CODE	APRCSPS_XREF_CODE	VARCHAR2(3)	Yes	*
APRCSPS_MI	APRCSPS_MI	VARCHAR2(15)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
APRCSPS_PIDM	APBCONS_PIDM	APBCONS
APRCSPS_MRTL_CODE	STVMRTL_CODE	STVMRTL
APRCSPS_XREF_CODE	ATVXREF_CODE	ATVXREF
APRCSPS_SPS_PIDM	SPRIDEN_PIDM	SPRIDEN
APRCSPS_SPS_PIDM	SPBPERS_PIDM	SPBPERS

Index

Index Name	Index Type	Column Name
APRCSPS_KEY_INDEX		APRCSPS_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
get_spouse_name	C/C++ Function	[F:\BANNER\C\APPDEXT.PC]	Use(select )
selalum_chld_sps	C/C++ Function	[F:\BANNER\C\AGPMATG.PC]	Use(select )
selsps	C/C++ Function	[F:\BANNER\C\AGPACCT.PC]	Use(select )
selsps	C/C++ Function	[F:\BANNER\C\APPCONS.PC]	Use(select )
selsps	C/C++ Function	[F:\BANNER\C\APPCLST.PC]	Use(select )
APRCSPS	SYNONYM	S4B70.PUBLIC	Rely on ()
ADVDSG1	VIEW	S4B70.BANINST1	Use(select )
AFVCMP1	VIEW	S4B70.BANINST1	Use(select )
APVCSPS	VIEW	S4B70.BANINST1	Use(select )
SOL_CONTACT_RG	Forms Record Group	BANNER7_FORMS.AGAPMAS	Use(select )
SOL_CONTACT_RG	Forms Record Group	BANNER7_FORMS_10G.AGAPMAS	Use(select )
ACTIVE_SPS	Forms Trigger	BANNER7_FORMS.APASRVW.APRSRVW	Use(select )
ACTIVE_SPS	Forms Trigger	BANNER7_FORMS_10G.APACONS.APRCSPS	Use(select )
ACTIVE_SPS	Forms Trigger	BANNER7_FORMS_10G.APASRVW.APRSRVW	Use(select )
ACTIVE_SPS	Forms Trigger	BANNER7_FORMS.APACONS.APRCSPS	Use(select )
DELETE_ALL	Forms Trigger	BANNER7_FORMS.APACONS.APRCSPS	Use(update,delete )
DELETE_ALL	Forms Trigger	BANNER7_FORMS_10G.APACONS.APRCSPS	Use(update,delete )
INSERT_SPS	Forms Trigger	BANNER7_FORMS.APAXREF.APRXREF	Use(insert,select )
INSERT_SPS	Forms Trigger	BANNER7_FORMS_10G.APACONS.APRCSPS	Use(insert,select )
INSERT_SPS	Forms Trigger	BANNER7_FORMS.APACONS.APRCSPS	Use(insert,select )
INSERT_SPS	Forms Trigger	BANNER7_FORMS_10G.APAXREF.APRXREF	Use(insert,select )
PRE-DELETE	Forms Trigger	BANNER7_FORMS.APACONS.APBCONS	Use(select )
PRE-DELETE	Forms Trigger	BANNER7_FORMS_10G.APACONS.APBCONS	Use(select )
QUERY_IDEN_PERS	Forms Trigger	BANNER7_FORMS.APACONS.APRCSPS	Use(select )
QUERY_IDEN_PERS	Forms Trigger	BANNER7_FORMS_10G.APACONS.APRCSPS	Use(select )
SPS_ACTIVE	Forms Trigger	BANNER7_FORMS.APACONS.APRCSPS	Use(select )
SPS_ACTIVE	Forms Trigger	BANNER7_FORMS_10G.APACONS.APRCSPS	Use(select )
UPDATE_SPS	Forms Trigger	BANNER7_FORMS.APACONS.APRCSPS	Use(update )
UPDATE_SPS	Forms Trigger	BANNER7_FORMS_10G.APACONS.APRCSPS	Use(update )
A$_SEL_ID_INFO	Forms Procedure	BANNER7_FORMS_10G.AOQOLIB	Use(select )
A$_SEL_ID_INFO	Forms Procedure	BANNER7_FORMS.AOQOLIB	Use(select )
A$_SEL_ID_INFO	Forms Procedure	BANNER7_FORMS.AMACONT	Use(select )
A$_SEL_ID_PERS_INFO	Forms Procedure	BANNER7_FORMS_10G.AOQOLIB	Use(select )
A$_SEL_ID_PERS_INFO	Forms Procedure	BANNER7_FORMS.AOQOLIB	Use(select )
CREATE_CONSTITUENT	Forms Procedure	BANNER7_FORMS.APAWPRS	Use(insert )
CREATE_CONSTITUENT	Forms Procedure	BANNER7_FORMS_10G.APAWPRS	Use(insert )
SEL_ID_INFO_CUSTOM	Forms Procedure	BANNER7_FORMS.APAIDEN	Rely on ()
SEL_ID_INFO_CUSTOM	Forms Procedure	BANNER7_FORMS_10G.APAIDEN	Rely on ()
SEL_ID_INFO_CUSTOM	Forms Procedure	BANNER7_FORMS_10G.APAIDEN	Use(select )
SEL_ID_INFO_CUSTOM	Forms Procedure	BANNER7_FORMS.APAIDEN	Use(select )
SEL_NON_CONS_ID_INFO	Forms Procedure	BANNER7_FORMS.ASICONT	Use(select )
SEL_NON_CONS_ID_INFO	Forms Procedure	BANNER7_FORMS_10G.ASICONT	Rely on ()
SEL_NON_CONS_ID_INFO	Forms Procedure	BANNER7_FORMS_10G.ASICONT	Use(select )
UPDATE_APRCSPS_10	Forms Procedure	BANNER7_FORMS_10G.APAXREF	Use(update )
UPDATE_APRCSPS_10	Forms Procedure	BANNER7_FORMS.APAXREF	Use(update )
UPDATE_APRCSPS_3	Forms Procedure	BANNER7_FORMS_10G.APAXREF	Use(update,select )
UPDATE_APRCSPS_3	Forms Procedure	BANNER7_FORMS.APAXREF	Use(update,select )
UPDATE_APRCSPS_5	Forms Procedure	BANNER7_FORMS_10G.APAXREF	Use(update )
UPDATE_APRCSPS_5	Forms Procedure	BANNER7_FORMS.APAXREF	Use(update )
UPDATE_CONSTITUENT	Forms Procedure	BANNER7_FORMS.APAWPRS	Rely on ()
UPDATE_CONSTITUENT	Forms Procedure	BANNER7_FORMS.APAWPRS	Rely on () Use(insert,update,select )
UPDATE_CONSTITUENT	Forms Procedure	BANNER7_FORMS_10G.APAWPRS	Rely on () Use(insert,update,select )
UPDATE_CONSTITUENT	Forms Procedure	BANNER7_FORMS_10G.APAWPRS	Rely on ()
A$_SEL_ID_INFO	Forms Procedure	BANNER7_FORMS.AOQRPLS	Use(select )
A$_SEL_ID_INFO	Forms Procedure	BANNER7_FORMS_10G.AOQRPLS	Use(select )
A$_SEL_ID_PERS_INFO	Forms Procedure	BANNER7_FORMS.AOQRPLS	Use(select )
A$_SEL_ID_PERS_INFO	Forms Procedure	BANNER7_FORMS_10G.AOQRPLS	Use(select )
F_SPOUSE_INFO	FUNCTION	S4B70.BANINST1	Use(select )
SELECT_APRCSPS_7	Forms Function	BANNER7_FORMS_10G.APAXREF	Use(select )
SELECT_APRCSPS_7	Forms Function	BANNER7_FORMS.APAXREF	Use(select )
SELECT_DUAL_2	Forms Function	BANNER7_FORMS_10G.APAXREF	Use(select )
SELECT_DUAL_2	Forms Function	BANNER7_FORMS.APAXREF	Use(select )
SPOUSE_TYPE	Package Type	S4B70.BANINST1.BWAKPLDG	Rely on ()
APRCSPS_REC	Package variable	S4B70.BANINST1.BWAKCHIS	Rely on ()
APRCSPS_REC	Package variable	S4B70.BANINST1.BWDKPSRC	Rely on ()
APRCSPS_REC	Package variable	S4B70.BANINST1.BWDKGHIS	Rely on ()
APRCSPS_REC	Package variable	S4B70.BANINST1.BWDKPSRC	Rely on ()
APRCSPS_REC	Package variable	S4B70.BANINST1.BWDKCPRF	Rely on ()
APRCSPS_REC	Package variable	S4B70.BANINST1.BWAKCHIS	Rely on ()
APRCSPS_REC	Package variable	S4B70.BANINST1.BWDKCPRF	Rely on ()
APRCSPS_REC	Package variable	S4B70.BANINST1.BWDKGHIS	Rely on ()
APRCSPSVIEWC	Package cursor	S4B70.BANINST1.BWDKPSRC	Rely on () Use(select )
APRCSPSVIEWC	Package cursor	S4B70.BANINST1.BWDKCPRF	Rely on () Use(select )
SPOUSEVIEWC	Package cursor	S4B70.BANINST1.BWAKPLDG	Use(select )
P_LOAD_SPOUSE	Package procedure	S4B70.BANINST1.APKLDRD	Rely on ()
P_LOAD_SPOUSE	Package procedure	S4B70.BANINST1.APKLDRD	Rely on () Use(insert,update,select )
APRCSPS	Forms DataBlock	BANNER7_FORMS.APACONS	Rely on () Use(insert,update,delete,select )
APRCSPS	Forms DataBlock	BANNER7_FORMS_10G.APACONS	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
APRCSPS_KEY_INDEX	INDEX	S4B70.ALUMNI	Rely on ()
APBCONS	TABLE	S4B70.ALUMNI	Refer( No Action )
ATVXREF	TABLE	S4B70.ALUMNI	Refer( No Action )
SPBPERS	TABLE	S4B70.SATURN	Join
SPRIDEN	TABLE	S4B70.SATURN	Join
STVMRTL	TABLE	S4B70.SATURN	Refer( No Action )

Comments

Source Code Comments

Constituent Spouse Table

Columns Comments for APRCSPS_PIDM (1)

Source Code Comments

This is the internal identification number of the constituent who is associated with the spouse.

Columns Comments for APRCSPS_MARS_IND (2)

Source Code Comments

This field is the marriage status indicator. Valid values are A for active and I for inactive. Each constituent is allowed only one spouse record with a marriage status of A.

Columns Comments for APRCSPS_ACTIVITY_DATE (3)

Source Code Comments

This system maintained field specifies the date this record was created or updated.

Columns Comments for APRCSPS_SPS_PIDM (4)

Source Code Comments

This field is the internal identification number of the spouse of the constituent. This field is optional and is populated only if the spouse has an id in BANNER.

Columns Comments for APRCSPS_LAST_NAME (5)

Source Code Comments

This field is the last name of the spouse. It will be stored only if the spouse does not have a BANNER id number. If the spouse does have an id, the name will display from the identification form, SPAIDEN or APAIDEN.

Columns Comments for APRCSPS_FIRST_NAME (6)

Source Code Comments

This field is the first name of the spouse. It will be stored only if the spouse does not have a BANNER id number. If the spouse does have an id, the name will display from the identification form, SPAIDEN or APAIDEN.

Columns Comments for APRCSPS_MAIDEN_NAME (7)

Source Code Comments

This field is the maiden name of the spouse. It will be stored only if the spouse does not have a BANNER id number. If the spouse does have an id, the name will display from the person form, SPAPERS or APAPERS.

Columns Comments for APRCSPS_NAME_PREFIX (8)

Source Code Comments

This field is the spouses prefix. It will be stored only if the spouse does not have a BANNER id number. If the spouse does have an id, the data will display from the person form, SPAPERS or APAPERS.

Columns Comments for APRCSPS_NAME_SUFFIX (9)

Source Code Comments

This field is the spouses suffix. It will be stored only if the spouse does not have a BANNER id number. If the spouse does have an id, the data will display from the person form, SPAPERS or APAPERS.

Columns Comments for APRCSPS_BIRTH_DATE (10)

Source Code Comments

This field is the spouses birth date. It will be stored only if the spouse does not have a BANNER id number. If the spouse does have an id, the data will display from the person form, SPAPERS or APAPERS.

Columns Comments for APRCSPS_SPS_COMMENT (11)

Source Code Comments

This field contains comments about the spouse.

Columns Comments for APRCSPS_MRTL_CODE (12)

Source Code Comments

This field is the spouses marital status. It will be stored only if the spouse does not have a BANNER id number. If the spouse does have an id, the data will display from the person form, SPAPERS or APAPERS.

Columns Comments for APRCSPS_MRTL_START_DATE (13)

Source Code Comments

This field is the start date of the marriage.

Columns Comments for APRCSPS_MRTL_END_DATE (14)

Source Code Comments

This field is the end date of the marriage. It will default to the current date when an inactive status is entered. It is blank for active marriages.

Columns Comments for APRCSPS_DEAD_IND (15)

Source Code Comments

This field is the deceased indicator of the spouse. It will be stored only if the spouse does not have a BANNER id number. If the spouse does have an id, the data will display from the person form, SPAPERS or APAPERS.

Columns Comments for APRCSPS_DEAD_DATE (16)

Source Code Comments

This field is the deceased date of the spouse. It will be stored only if the spouse does not have a BANNER id number. If the spouse does have an id, the data will display from the person form, SPAPERS or APAPERS.

Columns Comments for APRCSPS_XREF_CODE (17)

Source Code Comments

Code used to create cross reference for the spouse on the APAXREF form. Spouse indiciator on ATVXREF table must by Y for marriage status of A, and N for marriage status of I.

Columns Comments for APRCSPS_MI (18)

Source Code Comments

Spouse middle name. It will be stored on aprcsps if the spouse does not have a BANNER Id. If the spouse does have an Id, the name be stored on spriden.

Table GOBSEVS

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GOBSEVS_PIDM	GOBSEVS_PIDM	NUMBER(8,0)	No	*	*
GOBSEVS_ENG_PROF_REQ_IND	GOBSEVS_ENG_PROF_REQ_IND	VARCHAR2(1)	No
GOBSEVS_ENG_PROF_MET_IND	GOBSEVS_ENG_PROF_MET_IND	VARCHAR2(1)	No
GOBSEVS_CRIMINAL_CONVICT_IND	GOBSEVS_CRIMINAL_CONVICT_IND	VARCHAR2(1)	No
GOBSEVS_TERMINATE_STUDENT_IND	GOBSEVS_TERMINATE_STUDENT_IND	VARCHAR2(1)	No
GOBSEVS_EXTEND_FAILURE_IND	GOBSEVS_EXTEND_FAILURE_IND	VARCHAR2(1)	No
GOBSEVS_TRANSFER_FAIL_IND	GOBSEVS_TRANSFER_FAIL_IND	VARCHAR2(1)	No
GOBSEVS_APPROVAL_FAIL_IND	GOBSEVS_APPROVAL_FAIL_IND	VARCHAR2(1)	No
GOBSEVS_OTHER_INFRACT_IND	GOBSEVS_OTHER_INFRACT_IND	VARCHAR2(1)	No
GOBSEVS_ACTIVITY_DATE	GOBSEVS_ACTIVITY_DATE	DATE	No
GOBSEVS_USER_ID	GOBSEVS_USER_ID	VARCHAR2(30)	No
GOBSEVS_BIRTH_NATN_CODE	GOBSEVS_BIRTH_NATN_CODE	VARCHAR2(5)	Yes		*
GOBSEVS_LEGAL_NATN_CODE	GOBSEVS_LEGAL_NATN_CODE	VARCHAR2(5)	Yes		*
GOBSEVS_PROGRAM_BEGIN_DATE	GOBSEVS_PROGRAM_BEGIN_DATE	DATE	Yes
GOBSEVS_PROGRAM_END_DATE	GOBSEVS_PROGRAM_END_DATE	DATE	Yes
GOBSEVS_PROGRAM_ENROLL_DATE	GOBSEVS_PROGRAM_ENROLL_DATE	DATE	Yes
GOBSEVS_ENG_PROF_REASON	GOBSEVS_ENG_PROF_REASON	VARCHAR2(500)	Yes
GOBSEVS_ACADEMIC_TERM_MONTHS	GOBSEVS_ACADEMIC_TERM_MONTHS	NUMBER(3,0)	Yes
GOBSEVS_TUITION_EXPENSE	GOBSEVS_TUITION_EXPENSE	NUMBER(12,2)	Yes
GOBSEVS_PERSONAL_FUNDS	GOBSEVS_PERSONAL_FUNDS	NUMBER(12,2)	Yes
GOBSEVS_TRANS_CDE	GOBSEVS_TRANS_CDE	VARCHAR2(10)	Yes
GOBSEVS_SEVIS_ID	GOBSEVS_SEVIS_ID	VARCHAR2(11)	Yes
GOBSEVS_VTYP_CODE	GOBSEVS_VTYP_CODE	VARCHAR2(2)	Yes		*
GOBSEVS_SVCR_CODE	GOBSEVS_SVCR_CODE	VARCHAR2(4)	Yes		*
GOBSEVS_SESSION_START_DATE	GOBSEVS_SESSION_START_DATE	DATE	Yes
GOBSEVS_SESSION_END_DATE	GOBSEVS_SESSION_END_DATE	DATE	Yes
GOBSEVS_TRANSFER_COMMENT	GOBSEVS_TRANSFER_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_ISSUE_COMMENT	GOBSEVS_ISSUE_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_SVEL_CODE	GOBSEVS_SVEL_CODE	VARCHAR2(2)	Yes		*
GOBSEVS_MAJR_CODE	GOBSEVS_MAJR_CODE	VARCHAR2(4)	Yes		*
GOBSEVS_STUDY_LENGTH	GOBSEVS_STUDY_LENGTH	NUMBER(3,0)	Yes
GOBSEVS_LIVING_EXPENSES	GOBSEVS_LIVING_EXPENSES	NUMBER(12,2)	Yes
GOBSEVS_SVFT_CODE	GOBSEVS_SVFT_CODE	VARCHAR2(2)	Yes		*
GOBSEVS_AUTH_START_DATE	GOBSEVS_AUTH_START_DATE	DATE	Yes
GOBSEVS_COMPLETION_REMARKS	GOBSEVS_COMPLETION_REMARKS	VARCHAR2(500)	Yes
GOBSEVS_NEW_PROGRAM_END_DATE	GOBSEVS_NEW_PROGRAM_END_DATE	DATE	Yes
GOBSEVS_DA_PROGRAM_START_DATE	GOBSEVS_DA_PROGRAM_START_DATE	DATE	Yes
GOBSEVS_DA_PROGRAM_END_DATE	GOBSEVS_DA_PROGRAM_END_DATE	DATE	Yes
GOBSEVS_DISC_ACTION_TEXT	GOBSEVS_DISC_ACTION_TEXT	VARCHAR2(500)	Yes
GOBSEVS_EMPLOYMENT_CDE	GOBSEVS_EMPLOYMENT_CDE	VARCHAR2(2)	Yes
GOBSEVS_EMPLOYMENT_COMMENT	GOBSEVS_EMPLOYMENT_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_EMPLOYMENT_START_DATE	GOBSEVS_EMPLOYMENT_START_DATE	DATE	Yes
GOBSEVS_EMPLOYMENT_END_DATE	GOBSEVS_EMPLOYMENT_END_DATE	DATE	Yes
GOBSEVS_EMPLOYMENT_TYPE_CDE	GOBSEVS_EMPLOYMENT_TYPE_CDE	VARCHAR2(2)	Yes
GOBSEVS_EMPLOYER_LAST_NAME	GOBSEVS_EMPLOYER_LAST_NAME	VARCHAR2(500)	Yes
GOBSEVS_EMPLOYER_FIRST_NAME	GOBSEVS_EMPLOYER_FIRST_NAME	VARCHAR2(40)	Yes
GOBSEVS_EMP_ADDRESS_LINE1	GOBSEVS_EMP_ADDRESS_LINE1	VARCHAR2(60)	Yes
GOBSEVS_EMP_ADDRESS_LINE2	GOBSEVS_EMP_ADDRESS_LINE2	VARCHAR2(60)	Yes
GOBSEVS_EMPLOYER_CITY	GOBSEVS_EMPLOYER_CITY	VARCHAR2(60)	Yes
GOBSEVS_EMPLOYER_STATE	GOBSEVS_EMPLOYER_STATE	VARCHAR2(2)	Yes
GOBSEVS_EMPLOYER_ZIP	GOBSEVS_EMPLOYER_ZIP	VARCHAR2(9)	Yes
GOBSEVS_COURSE_RELEVANCE	GOBSEVS_COURSE_RELEVANCE	VARCHAR2(500)	Yes
GOBSEVS_EXTEND_END_DATE	GOBSEVS_EXTEND_END_DATE	DATE	Yes
GOBSEVS_SVTR_CODE	GOBSEVS_SVTR_CODE	VARCHAR2(6)	Yes		*
GOBSEVS_TERMINATE_DATE	GOBSEVS_TERMINATE_DATE	DATE	Yes
GOBSEVS_APPROVAL_FAIL_COMMENT	GOBSEVS_APPROVAL_FAIL_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_OTHER_INFRACT_COMMENT	GOBSEVS_OTHER_INFRACT_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_SVEP_CODE	GOBSEVS_SVEP_CODE	VARCHAR2(4)	Yes		*
GOBSEVS_END_PROGRAM_EFF_DATE	GOBSEVS_END_PROGRAM_EFF_DATE	DATE	Yes
GOBSEVS_EV_FORM_NUMBER	GOBSEVS_EV_FORM_NUMBER	VARCHAR2(40)	Yes
GOBSEVS_SVRP_CODE	GOBSEVS_SVRP_CODE	VARCHAR2(2)	Yes		*
GOBSEVS_REPRINT_REASON_COMMENT	GOBSEVS_REPRINT_REASON_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_SVCR_COMMENT	GOBSEVS_SVCR_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_PRINT_REQUEST_IND	GOBSEVS_PRINT_REQUEST_IND	VARCHAR2(1)	No
GOBSEVS_DEPENDENT_EXPENSES	GOBSEVS_DEPENDENT_EXPENSES	NUMBER(12,2)	Yes
GOBSEVS_OTHER_FUNDS	GOBSEVS_OTHER_FUNDS	NUMBER(12,2)	Yes
GOBSEVS_OTHER_FUNDS_COMMENT	GOBSEVS_OTHER_FUNDS_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_OTHER_EXPENSES	GOBSEVS_OTHER_EXPENSES	NUMBER(12,2)	Yes
GOBSEVS_OTHER_EXP_COMMENT	GOBSEVS_OTHER_EXP_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_AUTH_END_DATE	GOBSEVS_AUTH_END_DATE	DATE	Yes
GOBSEVS_NEW_PROGRAM_START_DATE	GOBSEVS_NEW_PROGRAM_START_DATE	DATE	Yes
GOBSEVS_SVPC_CODE	GOBSEVS_SVPC_CODE	VARCHAR2(3)	Yes		*
GOBSEVS_SVSC_CODE	GOBSEVS_SVSC_CODE	VARCHAR2(7)	Yes
GOBSEVS_SVSC_COMMENT	GOBSEVS_SVSC_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_COMMUTER_IND	GOBSEVS_COMMUTER_IND	VARCHAR2(1)	No
GOBSEVS_ADMISSION_NUMBER	GOBSEVS_ADMISSION_NUMBER	VARCHAR2(11)	Yes
GOBSEVS_DRIVERS_LIC_NUMBER	GOBSEVS_DRIVERS_LIC_NUMBER	VARCHAR2(30)	Yes
GOBSEVS_STAT_CODE_DRIVERS_LIC	GOBSEVS_STAT_CODE_DRIVERS_LIC	VARCHAR2(2)	Yes		*
GOBSEVS_TIN	GOBSEVS_TIN	VARCHAR2(9)	Yes
GOBSEVS_MAJR_CODE_2	GOBSEVS_MAJR_CODE_2	VARCHAR2(4)	Yes		*
GOBSEVS_MAJR_CODE_MINR	GOBSEVS_MAJR_CODE_MINR	VARCHAR2(4)	Yes		*
GOBSEVS_SCHOOL_FUNDS	GOBSEVS_SCHOOL_FUNDS	NUMBER(12,2)	Yes
GOBSEVS_SCHOOL_FUNDS_COMMENT	GOBSEVS_SCHOOL_FUNDS_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_EMPLOYMENT_FUNDS	GOBSEVS_EMPLOYMENT_FUNDS	NUMBER(12,2)	Yes
GOBSEVS_FUNDING_COMMENT	GOBSEVS_FUNDING_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_SVFT_COMMENT	GOBSEVS_SVFT_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_SVEP_COMMENT	GOBSEVS_SVEP_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_DA_COMMENT	GOBSEVS_DA_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_SVTR_COMMENT	GOBSEVS_SVTR_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_PASSPORT_NUMBER	GOBSEVS_PASSPORT_NUMBER	VARCHAR2(25)	Yes
GOBSEVS_NATN_CODE_PASSPORT	GOBSEVS_NATN_CODE_PASSPORT	VARCHAR2(5)	Yes		*
GOBSEVS_PASSPORT_EXPIRE_DATE	GOBSEVS_PASSPORT_EXPIRE_DATE	DATE	Yes
GOBSEVS_VISA_NUMBER	GOBSEVS_VISA_NUMBER	VARCHAR2(25)	Yes
GOBSEVS_SVCP_CODE	GOBSEVS_SVCP_CODE	VARCHAR2(3)	Yes		*
GOBSEVS_VISA_EXPIRE_DATE	GOBSEVS_VISA_EXPIRE_DATE	DATE	Yes
GOBSEVS_PENT_CODE	GOBSEVS_PENT_CODE	VARCHAR2(3)	Yes		*
GOBSEVS_PENT_COMMENT	GOBSEVS_PENT_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_ENTRY_DATE	GOBSEVS_ENTRY_DATE	DATE	Yes
GOBSEVS_EMPL_AUTH_IND	GOBSEVS_EMPL_AUTH_IND	VARCHAR2(1)	No
GOBSEVS_RFC_COMMENT	GOBSEVS_RFC_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_EDIT_PROGRAM_COMMENT	GOBSEVS_EDIT_PROGRAM_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_EMPLOYMENT_TIME_CDE	GOBSEVS_EMPLOYMENT_TIME_CDE	VARCHAR2(2)	Yes
GOBSEVS_PROGRAM_SPONSOR_FUNDS	GOBSEVS_PROGRAM_SPONSOR_FUNDS	NUMBER(12,2)	Yes
GOBSEVS_GOVT_ORG_FUNDS	GOBSEVS_GOVT_ORG_FUNDS	NUMBER(12,2)	Yes
GOBSEVS_SVGO_CODE	GOBSEVS_SVGO_CODE	VARCHAR2(6)	Yes		*
GOBSEVS_GOVT_ORG_FUNDS_2	GOBSEVS_GOVT_ORG_FUNDS_2	NUMBER(12,2)	Yes
GOBSEVS_SVGO_CODE_2	GOBSEVS_SVGO_CODE_2	VARCHAR2(6)	Yes		*
GOBSEVS_INTL_ORG_FUNDS	GOBSEVS_INTL_ORG_FUNDS	NUMBER(12,2)	Yes
GOBSEVS_SVIO_CODE	GOBSEVS_SVIO_CODE	VARCHAR2(6)	Yes		*
GOBSEVS_INTL_ORG_FUNDS_2	GOBSEVS_INTL_ORG_FUNDS_2	NUMBER(12,2)	Yes
GOBSEVS_SVIO_CODE_2	GOBSEVS_SVIO_CODE_2	VARCHAR2(6)	Yes		*
GOBSEVS_EV_GOVT_FUNDS	GOBSEVS_EV_GOVT_FUNDS	NUMBER(12,2)	Yes
GOBSEVS_BINATION_FUNDS	GOBSEVS_BINATION_FUNDS	NUMBER(12,2)	Yes
GOBSEVS_OTHER_ORG_FUNDS	GOBSEVS_OTHER_ORG_FUNDS	NUMBER(12,2)	Yes
GOBSEVS_PROGRAM_START_IND	GOBSEVS_PROGRAM_START_IND	VARCHAR2(1)	No
GOBSEVS_EXTEND_PROGRAM_COMMENT	GOBSEVS_EXTEND_PROGRAM_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_AMEND_PROGRAM_COMMENT	GOBSEVS_AMEND_PROGRAM_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_MATRICULATION_CDE	GOBSEVS_MATRICULATION_CDE	VARCHAR2(2)	Yes
GOBSEVS_EXTEND_FAILURE_COMMENT	GOBSEVS_EXTEND_FAILURE_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_CONCLUDE_TRANS_COMMENT	GOBSEVS_CONCLUDE_TRANS_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_BIRTH_CITY	GOBSEVS_BIRTH_CITY	VARCHAR2(200)	Yes
GOBSEVS_EDIT_BIO_COMMENT	GOBSEVS_EDIT_BIO_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_ATYP_CODE_ACT_SITE	GOBSEVS_ATYP_CODE_ACT_SITE	VARCHAR2(2)	Yes		*
GOBSEVS_NATN_CODE_PERM_RES	GOBSEVS_NATN_CODE_PERM_RES	VARCHAR2(5)	Yes
GOBSEVS_FIN_SUPPORT_COMMENT	GOBSEVS_FIN_SUPPORT_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_SVIT_CODE	GOBSEVS_SVIT_CODE	VARCHAR2(3)	Yes		*
GOBSEVS_ACT_SITE_NAME	GOBSEVS_ACT_SITE_NAME	VARCHAR2(60)	Yes
GOBSEVS_ACT_SITE_COMMENT	GOBSEVS_ACT_SITE_COMMENT	VARCHAR2(500)	Yes
GOBSEVS_SVCC_CODE	GOBSEVS_SVCC_CODE	VARCHAR2(3)	Yes		*
GOBSEVS_SCHOOL_CDE	GOBSEVS_SCHOOL_CDE	VARCHAR2(15)	Yes
GOBSEVS_PROGRAM_CDE	GOBSEVS_PROGRAM_CDE	VARCHAR2(9)	Yes
GOBSEVS_OFFICER_ID	GOBSEVS_OFFICER_ID	VARCHAR2(10)	Yes
GOBSEVS_SVEL_COMMENT	GOBSEVS_SVEL_COMMENT	VARCHAR2(500)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GOBSEVS_ATYP_CODE_ACT_SITE	STVATYP_CODE	STVATYP
GOBSEVS_MAJR_CODE	STVMAJR_CODE	STVMAJR
GOBSEVS_BIRTH_NATN_CODE	STVNATN_CODE	STVNATN
GOBSEVS_PENT_CODE	STVPENT_CODE	STVPENT
GOBSEVS_STAT_CODE_DRIVERS_LIC	STVSTAT_CODE	STVSTAT
GOBSEVS_VTYP_CODE	STVVTYP_CODE	STVVTYP
GOBSEVS_MAJR_CODE_2	STVMAJR_CODE	STVMAJR
GOBSEVS_LEGAL_NATN_CODE	STVNATN_CODE	STVNATN
GOBSEVS_MAJR_CODE_MINR	STVMAJR_CODE	STVMAJR
GOBSEVS_NATN_CODE_PASSPORT	STVNATN_CODE	STVNATN
GOBSEVS_SVCC_CODE	GTVSVCC_CODE	GTVSVCC
GOBSEVS_SVCP_CODE	GTVSVCP_CODE	GTVSVCP
GOBSEVS_SVCR_CODE	GTVSVCR_CODE	GTVSVCR
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_PIDM	GORSEVS_PIDM	GORSEVS

Index

Index Name	Index Type	Column Name
PK_GOBSEVS	Unique	GOBSEVS_PIDM

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
gorseve.pc	C/C++ File	N/A	Use(select )
GOBSEVS	SYNONYM	S4B70.PUBLIC	Rely on ()
GORSVAS	TABLE	S4B70."GENERAL"	Join
GORSVEI	TABLE	S4B70."GENERAL"	Join
SPBPERS	TABLE	S4B70.SATURN	Join
SPRIDEN	TABLE	S4B70.SATURN	Join
GOVSVAS	VIEW	S4B70.BANINST1	Use(select )
GOVSVEI	VIEW	S4B70.BANINST1	Use(select )
GOVSVEV	VIEW	S4B70.BANINST1	Use(select )
GOVSVSD	VIEW	S4B70.BANINST1	Use(select )
GOVSVTS	VIEW	S4B70.BANINST1	Use(select )
P_CREATE_EV	Package procedure	S4B70.BANINST1.GOKSVSQ	Use(insert )
P_CREATE_STUDENT	Package procedure	S4B70.BANINST1.GOKSVSQ	Use(insert )
P_PROCESS_IMPORT_DATA	Package procedure	S4B70.BANINST1.GOKSVEX	Use(update )
P_PROCESS_SQL_RULES	Package procedure	S4B70.BANINST1.GOKSVSQ	Use(select )
GOBSEVS	Forms DataBlock	BANNER7_FORMS.GOASEVS	Rely on () Use(insert,update,delete,select )
GOBSEVS	Forms DataBlock	BANNER7_FORMS_10G.GOASEVS	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GOBSEVS	INDEX	S4B70."GENERAL"	Rely on ()
GORSEVS	TABLE	S4B70."GENERAL"	Join
GTVSVCC	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVSVCP	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVSVCR	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVSVEL	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVSVEP	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVSVFT	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVSVGO	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVSVIO	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVSVIT	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVSVPC	TABLE	S4B70."GENERAL"	Refer( No Action )
GTVSVRP	TABLE