SPBPERS SPRADDR SPRAPIN SPRCMNT SPRCOLR SPREMRG SPRHOLD SPRIDEN SPRINTL SPRMEDI SPRTELE SPTADDR SPTIDEN SPTPERS

Model General Person


Model Label : ERD For Banner Student General Person Module ( SP% Tables)
Path : BANNER DEV/Student/General_Person/General Person

List of Objects

Object Name Object Type Layer Name
SPBPERS TABLE Tables
SPRADDR TABLE Tables
SPRAPIN TABLE Tables
SPRCMNT TABLE Tables
SPRCOLR TABLE Tables
SPREMRG TABLE Tables
SPRHOLD TABLE Tables
SPRIDEN TABLE Tables
SPRINTL TABLE Tables
SPRMEDI TABLE Tables
SPRTELE TABLE Tables
SPTADDR TABLE Tables
SPTIDEN TABLE Tables
SPTPERS TABLE Tables

Comments

Model View

''

Table SPBPERS

Schema Name SATURN
Label SPBPERS
Server name MALDEV8_B60
Creation Date 07/09/2003 16:26:02:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SPBPERS_PIDM SPBPERS_PIDM NUMBER(8,0) No * *
SPBPERS_PIDM SPBPERS_PIDM NUMBER(8,0) No * *
SPBPERS_PIDM SPBPERS_PIDM NUMBER(8,0) No * *
SPBPERS_PIDM SPBPERS_PIDM NUMBER(8,0) No * *
SPBPERS_PIDM SPBPERS_PIDM NUMBER(8,0) No * *
SPBPERS_PIDM SPBPERS_PIDM NUMBER(8,0) No * *
SPBPERS_PIDM SPBPERS_PIDM NUMBER(8,0) No * *
SPBPERS_PIDM SPBPERS_PIDM NUMBER(8,0) No * *
SPBPERS_PIDM SPBPERS_PIDM NUMBER(8,0) No * *
SPBPERS_PIDM SPBPERS_PIDM NUMBER(8,0) No * *
SPBPERS_PIDM SPBPERS_PIDM NUMBER(8,0) No * *
SPBPERS_PIDM SPBPERS_PIDM NUMBER(8,0) No * *
SPBPERS_PIDM SPBPERS_PIDM NUMBER(8,0) No * *
SPBPERS_PIDM SPBPERS_PIDM NUMBER(8,0) No * *
SPBPERS_PIDM SPBPERS_PIDM NUMBER(8,0) No * *
SPBPERS_PIDM SPBPERS_PIDM NUMBER(8,0) No * *
SPBPERS_PIDM SPBPERS_PIDM NUMBER(8,0) No * *
SPBPERS_PIDM SPBPERS_PIDM NUMBER(8,0) No * *
SPBPERS_PIDM SPBPERS_PIDM NUMBER(8,0) No * *
SPBPERS_PIDM SPBPERS_PIDM NUMBER(8,0) No * *
SPBPERS_PIDM SPBPERS_PIDM NUMBER(8,0) No * *
SPBPERS_PIDM SPBPERS_PIDM NUMBER(8,0) No * *
SPBPERS_PIDM SPBPERS_PIDM NUMBER(8,0) No * *
SPBPERS_SSN SPBPERS_SSN VARCHAR2(9) Yes
SPBPERS_BIRTH_DATE SPBPERS_BIRTH_DATE DATE Yes
SPBPERS_LGCY_CODE SPBPERS_LGCY_CODE VARCHAR2(1) Yes *
SPBPERS_ETHN_CODE SPBPERS_ETHN_CODE VARCHAR2(2) Yes *
SPBPERS_MRTL_CODE SPBPERS_MRTL_CODE VARCHAR2(1) Yes *
SPBPERS_RELG_CODE SPBPERS_RELG_CODE VARCHAR2(2) Yes *
SPBPERS_SEX SPBPERS_SEX VARCHAR2(1) Yes
SPBPERS_CONFID_IND SPBPERS_CONFID_IND VARCHAR2(1) Yes
SPBPERS_DEAD_IND SPBPERS_DEAD_IND VARCHAR2(1) Yes
SPBPERS_VETC_FILE_NUMBER SPBPERS_VETC_FILE_NUMBER VARCHAR2(10) Yes
SPBPERS_LEGAL_NAME SPBPERS_LEGAL_NAME VARCHAR2(60) Yes
SPBPERS_PREF_FIRST_NAME SPBPERS_PREF_FIRST_NAME VARCHAR2(15) Yes
SPBPERS_NAME_PREFIX SPBPERS_NAME_PREFIX VARCHAR2(20) Yes
SPBPERS_NAME_SUFFIX SPBPERS_NAME_SUFFIX VARCHAR2(20) Yes
SPBPERS_ACTIVITY_DATE SPBPERS_ACTIVITY_DATE DATE No
SPBPERS_VERA_IND SPBPERS_VERA_IND VARCHAR2(1) Yes
SPBPERS_CITZ_IND SPBPERS_CITZ_IND VARCHAR2(1) Yes
SPBPERS_DEAD_DATE SPBPERS_DEAD_DATE DATE Yes
SPBPERS_PIN SPBPERS_PIN RAW(1) Yes
SPBPERS_CITZ_CODE SPBPERS_CITZ_CODE VARCHAR2(2) Yes *
SPBPERS_CITZ_CODE SPBPERS_CITZ_CODE VARCHAR2(2) Yes *
SPBPERS_HAIR_CODE SPBPERS_HAIR_CODE VARCHAR2(2) Yes
SPBPERS_EYES_CODE SPBPERS_EYES_CODE VARCHAR2(2) Yes
SPBPERS_CITY_BIRTH SPBPERS_CITY_BIRTH VARCHAR2(20) Yes
SPBPERS_STAT_CODE_BIRTH SPBPERS_STAT_CODE_BIRTH VARCHAR2(3) Yes *
SPBPERS_DRIVER_LICENSE SPBPERS_DRIVER_LICENSE VARCHAR2(20) Yes
SPBPERS_STAT_CODE_DRIVER SPBPERS_STAT_CODE_DRIVER VARCHAR2(3) Yes *
SPBPERS_NATN_CODE_DRIVER SPBPERS_NATN_CODE_DRIVER VARCHAR2(5) Yes *
SPBPERS_UOMS_CODE_HEIGHT SPBPERS_UOMS_CODE_HEIGHT VARCHAR2(4) Yes *
SPBPERS_HEIGHT SPBPERS_HEIGHT NUMBER(2,0) Yes
SPBPERS_UOMS_CODE_WEIGHT SPBPERS_UOMS_CODE_WEIGHT VARCHAR2(4) Yes *
SPBPERS_WEIGHT SPBPERS_WEIGHT NUMBER(4,0) Yes
SPBPERS_SDVET_IND SPBPERS_SDVET_IND VARCHAR2(1) Yes
SPBPERS_LICENSE_ISSUED_DATE SPBPERS_LICENSE_ISSUED_DATE DATE Yes
SPBPERS_LICENSE_EXPIRES_DATE SPBPERS_LICENSE_EXPIRES_DATE DATE Yes
SPBPERS_INCAR_IND SPBPERS_INCAR_IND VARCHAR2(1) Yes
SPBPERS_WEBID SPBPERS_WEBID RAW(1) Yes
SPBPERS_WEB_LAST_ACCESS SPBPERS_WEB_LAST_ACCESS RAW(1) Yes
SPBPERS_PIN_DISABLED_IND SPBPERS_PIN_DISABLED_IND RAW(1) Yes
SPBPERS_ITIN SPBPERS_ITIN NUMBER(9,0) Yes
SPBPERS_ACTIVE_DUTY_SEPR_DATE SPBPERS_ACTIVE_DUTY_SEPR_DATE DATE Yes

Foreign Key information

Column name is Foreign Key For Column on Table
SPBPERS_RELG_CODE STVRELG_CODE STVRELG
SPBPERS_CITZ_CODE STVCITZ_CODE STVCITZ
SPBPERS_MRTL_CODE STVMRTL_CODE STVMRTL
SPBPERS_LGCY_CODE STVLGCY_CODE STVLGCY
SPBPERS_ETHN_CODE STVETHN_CODE STVETHN
SPBPERS_NATN_CODE_DRIVER STVNATN_CODE STVNATN
SPBPERS_PIDM SGBSTDN_PIDM SGBSTDN
SPBPERS_PIDM TBRISTL_PIDM TBRISTL
SPBPERS_PIDM RPRATRM_PIDM RPRATRM
SPBPERS_PIDM SHRTTRM_PIDM SHRTTRM
SPBPERS_PIDM TBRACCD_PIDM TBRACCD
SPBPERS_PIDM TBRDEPO_PIDM TBRDEPO
SPBPERS_PIDM GORSEVD_DEP_PIDM GORSEVD
SPBPERS_PIDM GOBSEVS_PIDM GOBSEVS
SPBPERS_PIDM APRCHIS_PIDM APRCHIS
SPBPERS_PIDM PEBEMPL_PIDM PEBEMPL
SPBPERS_PIDM NBRBJOB_PIDM NBRBJOB
SPBPERS_PIDM APRXREF_XREF_PIDM APRXREF
SPBPERS_PIDM SPRMEDI_PIDM SPRMEDI
SPBPERS_PIDM APRACYR_PIDM APRACYR
SPBPERS_PIDM SHRLGPA_PIDM SHRLGPA
SPBPERS_PIDM SARADAP_PIDM SARADAP
SPBPERS_PIDM RORSTAT_PIDM RORSTAT
SPBPERS_PIDM SFBETRM_PIDM SFBETRM
SPBPERS_PIDM SRBRECR_PIDM SRBRECR
SPBPERS_CITZ_CODE SARDCSN_CITZ_CODE SARDCSN
SPBPERS_PIDM SIBINST_PIDM SIBINST
SPBPERS_PIDM SRRRSRC_PIDM SRRRSRC
SPBPERS_PIDM APRDHIS_PIDM APRDHIS
SPBPERS_PIDM SLRRMAT_PIDM SLRRMAT

Index

Index Name Index Type Column Name
PK_SPBPERS Unique SPBPERS_PIDM
SPBPERS_SSN_INDEX SPBPERS_SSN

Comments

Source Code Comments

Basic Person Base Table

Impact job : SPBPERS_COLUMN SPBPERS_column2

Columns Comments for SPBPERS_PIDM (1)

Source Code Comments

Internal Identification Number of Person.

Columns Comments for SPBPERS_SSN (2)

Source Code Comments

This field maintains person social security number.

Columns Comments for SPBPERS_BIRTH_DATE (3)

Source Code Comments

This field maintains person birth date.

Columns Comments for SPBPERS_LGCY_CODE (4)

Source Code Comments

This field maintains legacy code associated with person.

Columns Comments for SPBPERS_ETHN_CODE (5)

Source Code Comments

This field maintains ethnicity code associated with person.

Columns Comments for SPBPERS_MRTL_CODE (6)

Source Code Comments

This field maintains martial status associated with person.

Columns Comments for SPBPERS_RELG_CODE (7)

Source Code Comments

This field maintains religious affiliation associated with person.

Columns Comments for SPBPERS_SEX (8)

Source Code Comments

This field maintains the sex of person. Valid values are: M - Male, F - Female, N - Unknown.

Columns Comments for SPBPERS_CONFID_IND (9)

Source Code Comments

This field identifies if a person record is confidential Valid value is: Y - confidential.

Columns Comments for SPBPERS_DEAD_IND (10)

Source Code Comments

This field indicates if a person is deceased. Valid value is: Y - deceased.

Columns Comments for SPBPERS_VETC_FILE_NUMBER (11)

Source Code Comments

This field maintains veteran identification number associated with person.

Columns Comments for SPBPERS_LEGAL_NAME (12)

Source Code Comments

This field maintains legal name associated with person.

Columns Comments for SPBPERS_PREF_FIRST_NAME (13)

Source Code Comments

This field maintains the preferred first name associated with person.

Columns Comments for SPBPERS_NAME_PREFIX (14)

Source Code Comments

This field maintains the prefix (Mr, Mrs, etc) used before person name.

Columns Comments for SPBPERS_NAME_SUFFIX (15)

Source Code Comments

This field maintains the suffix (Jr, Sr, etc) used after person name.

Columns Comments for SPBPERS_ACTIVITY_DATE (16)

Source Code Comments

This field defines the most current date a record is added or changed.

Columns Comments for SPBPERS_VERA_IND (17)

Source Code Comments

Veteran Category. None, (O)ther Protected Veteran Only, (V)ietnam Veteran only, (B)oth Vietnam and Other Eligible Veteran.

Columns Comments for SPBPERS_CITZ_IND (18)

Source Code Comments

Citizen Indicator.

Columns Comments for SPBPERS_DEAD_DATE (19)

Source Code Comments

Person Deceased Date.

Columns Comments for SPBPERS_PIN (20)

Source Code Comments

Person Identification Number. This column is obsolete, now gobtpac_pin

Columns Comments for SPBPERS_CITZ_CODE (21)

Source Code Comments

Person Citizen Type

Columns Comments for SPBPERS_HAIR_CODE (22)

Source Code Comments

The hair color of the person being defined.

Columns Comments for SPBPERS_EYES_CODE (23)

Source Code Comments

The eye color of the person being defined.

Columns Comments for SPBPERS_CITY_BIRTH (24)

Source Code Comments

The city where the person was born.

Columns Comments for SPBPERS_STAT_CODE_BIRTH (25)

Source Code Comments

The state in which the person was born.

Columns Comments for SPBPERS_DRIVER_LICENSE (26)

Source Code Comments

The Driver License Number as it appears on the actual license.

Columns Comments for SPBPERS_STAT_CODE_DRIVER (27)

Source Code Comments

The State code describing the state the driver license was issued.

Columns Comments for SPBPERS_NATN_CODE_DRIVER (28)

Source Code Comments

The Nation code associated with the Nation the Driver license was issued.

Columns Comments for SPBPERS_UOMS_CODE_HEIGHT (29)

Source Code Comments

The Unit of Measure describing the height value.

Columns Comments for SPBPERS_HEIGHT (30)

Source Code Comments

The number value describing the height of the person.

Columns Comments for SPBPERS_UOMS_CODE_WEIGHT (31)

Source Code Comments

The Unit of Measure describing the weight value.

Columns Comments for SPBPERS_WEIGHT (32)

Source Code Comments

The number value describing the weight of the person.

Columns Comments for SPBPERS_SDVET_IND (33)

Source Code Comments

Indicator to identify an individual as a special disabled veteran.

Columns Comments for SPBPERS_LICENSE_ISSUED_DATE (34)

Source Code Comments

The issue date of the individuals driver license.

Columns Comments for SPBPERS_LICENSE_EXPIRES_DATE (35)

Source Code Comments

The expiration date of the individuals driver license.

Columns Comments for SPBPERS_INCAR_IND (36)

Source Code Comments

The indication of the individuals incarceration.

Columns Comments for SPBPERS_WEBID (37)

Source Code Comments

Web identification session token is now obsolete.

Columns Comments for SPBPERS_WEB_LAST_ACCESS (38)

Source Code Comments

Web last access time stamp is now obsolete.

Columns Comments for SPBPERS_PIN_DISABLED_IND (39)

Source Code Comments

Indicates whether or not the PIN number is disabled. This column is obsolete, now gobtpac_pin_disabled_ind

Columns Comments for SPBPERS_ITIN (40)

Source Code Comments

The international tax id number.

Columns Comments for SPBPERS_ACTIVE_DUTY_SEPR_DATE (41)

Source Code Comments

Active Duty Separation Date: The Date that the person was separated from active duty.

Table SPRADDR

Schema Name SATURN
Label SPRADDR
Server name MALDEV8_B60
Creation Date 04/28/2003 16:18:14:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SPRADDR_PIDM SPRADDR_PIDM NUMBER(8,0) No *
SPRADDR_PIDM SPRADDR_PIDM NUMBER(8,0) No *
SPRADDR_PIDM SPRADDR_PIDM NUMBER(8,0) No *
SPRADDR_PIDM SPRADDR_PIDM NUMBER(8,0) No *
SPRADDR_PIDM SPRADDR_PIDM NUMBER(8,0) No *
SPRADDR_PIDM SPRADDR_PIDM NUMBER(8,0) No *
SPRADDR_PIDM SPRADDR_PIDM NUMBER(8,0) No *
SPRADDR_PIDM SPRADDR_PIDM NUMBER(8,0) No *
SPRADDR_PIDM SPRADDR_PIDM NUMBER(8,0) No *
SPRADDR_PIDM SPRADDR_PIDM NUMBER(8,0) No *
SPRADDR_ATYP_CODE SPRADDR_ATYP_CODE VARCHAR2(2) No *
SPRADDR_ATYP_CODE SPRADDR_ATYP_CODE VARCHAR2(2) No *
SPRADDR_ATYP_CODE SPRADDR_ATYP_CODE VARCHAR2(2) No *
SPRADDR_ATYP_CODE SPRADDR_ATYP_CODE VARCHAR2(2) No *
SPRADDR_ATYP_CODE SPRADDR_ATYP_CODE VARCHAR2(2) No *
SPRADDR_ATYP_CODE SPRADDR_ATYP_CODE VARCHAR2(2) No *
SPRADDR_ATYP_CODE SPRADDR_ATYP_CODE VARCHAR2(2) No *
SPRADDR_ATYP_CODE SPRADDR_ATYP_CODE VARCHAR2(2) No *
SPRADDR_ATYP_CODE SPRADDR_ATYP_CODE VARCHAR2(2) No *
SPRADDR_ATYP_CODE SPRADDR_ATYP_CODE VARCHAR2(2) No *
SPRADDR_ATYP_CODE SPRADDR_ATYP_CODE VARCHAR2(2) No *
SPRADDR_SEQNO SPRADDR_SEQNO NUMBER(2,0) No *
SPRADDR_SEQNO SPRADDR_SEQNO NUMBER(2,0) No *
SPRADDR_SEQNO SPRADDR_SEQNO NUMBER(2,0) No *
SPRADDR_FROM_DATE SPRADDR_FROM_DATE DATE Yes
SPRADDR_TO_DATE SPRADDR_TO_DATE DATE Yes
SPRADDR_STREET_LINE1 SPRADDR_STREET_LINE1 VARCHAR2(30) Yes
SPRADDR_STREET_LINE2 SPRADDR_STREET_LINE2 VARCHAR2(30) Yes
SPRADDR_STREET_LINE3 SPRADDR_STREET_LINE3 VARCHAR2(30) Yes
SPRADDR_CITY SPRADDR_CITY VARCHAR2(20) No *
SPRADDR_STAT_CODE SPRADDR_STAT_CODE VARCHAR2(3) Yes *
SPRADDR_STAT_CODE SPRADDR_STAT_CODE VARCHAR2(3) Yes *
SPRADDR_STAT_CODE SPRADDR_STAT_CODE VARCHAR2(3) Yes *
SPRADDR_STAT_CODE SPRADDR_STAT_CODE VARCHAR2(3) Yes *
SPRADDR_ZIP SPRADDR_ZIP VARCHAR2(10) Yes
SPRADDR_CNTY_CODE SPRADDR_CNTY_CODE VARCHAR2(5) Yes *
SPRADDR_CNTY_CODE SPRADDR_CNTY_CODE VARCHAR2(5) Yes *
SPRADDR_NATN_CODE SPRADDR_NATN_CODE VARCHAR2(5) Yes *
SPRADDR_NATN_CODE SPRADDR_NATN_CODE VARCHAR2(5) Yes *
SPRADDR_PHONE_AREA SPRADDR_PHONE_AREA VARCHAR2(3) Yes
SPRADDR_PHONE_NUMBER SPRADDR_PHONE_NUMBER VARCHAR2(7) Yes
SPRADDR_PHONE_EXT SPRADDR_PHONE_EXT VARCHAR2(4) Yes
SPRADDR_STATUS_IND SPRADDR_STATUS_IND VARCHAR2(1) Yes
SPRADDR_ACTIVITY_DATE SPRADDR_ACTIVITY_DATE DATE No
SPRADDR_USER SPRADDR_USER VARCHAR2(30) Yes
SPRADDR_ASRC_CODE SPRADDR_ASRC_CODE VARCHAR2(4) Yes *
SPRADDR_DELIVERY_POINT SPRADDR_DELIVERY_POINT NUMBER(2,0) Yes
SPRADDR_CORRECTION_DIGIT SPRADDR_CORRECTION_DIGIT NUMBER(1,0) Yes
SPRADDR_CARRIER_ROUTE SPRADDR_CARRIER_ROUTE VARCHAR2(4) Yes
SPRADDR_GST_TAX_ID SPRADDR_GST_TAX_ID VARCHAR2(15) Yes
SPRADDR_REVIEWED_IND SPRADDR_REVIEWED_IND VARCHAR2(1) Yes
SPRADDR_REVIEWED_USER SPRADDR_REVIEWED_USER VARCHAR2(30) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
SPRADDR_ASRC_CODE STVASRC_CODE STVASRC
SPRADDR_ATYP_CODE STVATYP_CODE STVATYP
SPRADDR_CNTY_CODE STVCNTY_CODE STVCNTY
SPRADDR_STAT_CODE STVSTAT_CODE STVSTAT
SPRADDR_NATN_CODE STVNATN_CODE STVNATN
SPRADDR_PIDM SPRIDEN_PIDM SPRIDEN
SPRADDR_ATYP_CODE APBCONS_ATYP_CODE_PREF APBCONS
SPRADDR_PIDM SRBRECR_PIDM SRBRECR
SPRADDR_ATYP_CODE FTVVEND_ATYP_CODE FTVVEND
SPRADDR_SEQNO FTVVEND_ADDR_SEQNO FTVVEND
SPRADDR_PIDM FTVVEND_PIDM FTVVEND
SPRADDR_ATYP_CODE AOBORGN_ATYP_CODE AOBORGN
SPRADDR_PIDM SPRTELE_PIDM SPRTELE
SPRADDR_ATYP_CODE SPRTELE_ATYP_CODE SPRTELE
SPRADDR_SEQNO SPRTELE_SEQNO SPRTELE
SPRADDR_SEQNO SPRTELE_ADDR_SEQNO SPRTELE
SPRADDR_PIDM GORSVAS_ACT_SITE_PIDM GORSVAS
SPRADDR_ATYP_CODE GORSVAS_ATYP_CODE GORSVAS
SPRADDR_PIDM GORSVEI_EMPLOYER_PIDM GORSVEI
SPRADDR_ATYP_CODE GORSVEI_ATYP_CODE GORSVEI
SPRADDR_ATYP_CODE GOBSEVS_ATYP_CODE_ACT_SITE GOBSEVS
SPRADDR_PIDM GOBSEVS_PIDM GOBSEVS
SPRADDR_ATYP_CODE SARERUL_VALUE SARERUL
SPRADDR_ATYP_CODE GORADRL_ATYP_CODE GORADRL
SPRADDR_ATYP_CODE SORMSTA_ATYP_CODE SORMSTA
SPRADDR_STAT_CODE SORMSTA_STAT_CODE SORMSTA
SPRADDR_PIDM SARADAP_PIDM SARADAP
SPRADDR_PIDM AMRINFO_PIDM AMRINFO
SPRADDR_CITY SORGEOR_START_RANGE SORGEOR
SPRADDR_STAT_CODE SORGEOR_END_RANGE SORGEOR
SPRADDR_STAT_CODE SORGEOR_START_RANGE SORGEOR
SPRADDR_CNTY_CODE SORGEOR_START_RANGE SORGEOR
SPRADDR_NATN_CODE SORGEOR_START_RANGE SORGEOR
SPRADDR_PIDM SFBETRM_PIDM SFBETRM

Index

Index Name Index Type Column Name
SPRADDR_KEY_INDEX Unique SPRADDR_PIDM
SPRADDR_KEY_INDEX Unique SPRADDR_ATYP_CODE
SPRADDR_KEY_INDEX Unique SPRADDR_SEQNO
SPRADDR_KEY_INDEX Unique SPRADDR_STATUS_IND
SPRADDR_KEY_INDEX2 SPRADDR_PIDM
SPRADDR_KEY_INDEX2 SPRADDR_ATYP_CODE
SPRADDR_KEY_INDEX2 SPRADDR_SEQNO
SPRADDR_KEY_INDEX2 SPRADDR_STATUS_IND
SPRADDR_KEY_INDEX2 SPRADDR_FROM_DATE
SPRADDR_KEY_INDEX2 SPRADDR_TO_DATE

Comments

Source Code Comments

Address Repeating Table

Impact job : New Impact3 New Job

Impact job : New Impact4 New Job

Impacted objects

Object Name Object Type
F_SECONDARY_CONTACT_ADDRESS FUNCTION
AA_CONSTITUENT_IDENTIFICATION VIEW
AA_ORGANIZATION VIEW
AF_VENDOR_PERFORMANCE VIEW
AF_VENDOR_VOLUME VIEW
AG_ENTITY_DATA VIEW
AG_EVENTS_AND_FUNCTIONS VIEW
ALVADDS VIEW
AMVGEOR VIEW
AOVCOMP VIEW
AOVIDEN VIEW
AOVORG1 VIEW
APVADRS VIEW
APVCNI1 VIEW
AP_DEDUCTIONS_BENEFITS VIEW
AP_EMPLOYEE_PROFILE VIEW
AP_EMPLOYMENT_VERIFICATION VIEW
AP_EMPLOY_RECRUITMENT_ACTIVITY VIEW
AP_JOB_SUMMARY VIEW
AR_AWARD_DETAIL_BY_TERM VIEW
AR_AWARD_DETAIL_BY_YEAR VIEW
AR_FINAID_APPLICANT VIEW
AR_FINAID_STUDENT_SUMMARY VIEW
AS_ACADEMIC_HISTORY_DETAIL VIEW
AS_ACADEMIC_HISTORY_SUMMARY VIEW
AS_ADMISSIONS_APPLICANT VIEW
AS_AGING_ANALYSIS VIEW
AS_CLEARED_TO_ATTEND VIEW
AS_FACULTY_DATA VIEW
AS_RECRUITING_DATA VIEW
AS_RECRUITING_SOURCE_ANALYSIS VIEW
AS_RESIDENTIAL_LIFE VIEW
AS_RESIDENTIAL_LIFE_CHANGES VIEW
AS_STUDENT_DATA VIEW
AS_STUDENT_ENROLLMENT_SUMMARY VIEW
AS_STUDENT_REGISTRATION_DETAIL VIEW
AS_THIRD_PARTY_CONTRACTS VIEW
GEVEVN1 VIEW
GEVEVN2 VIEW
GOVSVEV VIEW
GOVSVSD VIEW
GPVENT1 VIEW
PAVREQ1 VIEW
PDVDED1 VIEW
PEVJOB1 VIEW
PEVPRF1 VIEW
PEVREC0 VIEW
PEVVER1 VIEW
PEVVER2 VIEW
PPVADRS VIEW
RCVAPL1 VIEW
RCVAPL2 VIEW
ROVSTU1 VIEW
ROVSTU2 VIEW
ROVSTU3 VIEW
RPVADDR VIEW
RPVADRS VIEW
RPVAWT1 VIEW
RPVAWT2 VIEW
RPVAWY1 VIEW
RPVAWY2 VIEW
RPVFDRS VIEW
SAVADM1 VIEW
SAVADM2 VIEW
SAVADRS VIEW
SAVAMCD VIEW
SFVETR1 VIEW
SFVETR2 VIEW
SFVSTC1 VIEW
SFVSTC2 VIEW
SGVADRS VIEW
SGVSTD1 VIEW
SGVSTD2 VIEW
SHVDTL1 VIEW
SHVDTL2 VIEW
SHVSUM1 VIEW
SHVSUM2 VIEW
SIVFAC1 VIEW
SIVFAC2 VIEW
SLVRES1 VIEW
SLVRES2 VIEW
SLVRSM2 VIEW
SOVAGI1 VIEW
SOVCTA1 VIEW
SOVCTA2 VIEW
SOVGEOR VIEW
SOVTPC1 VIEW
SPVADDF VIEW
SPVADDI VIEW
SPVADDR VIEW
SPVADDS VIEW
SPVADRS VIEW
SPVPERS VIEW
SRVADRS VIEW
SRVRCR1 VIEW
SRVRSR1 VIEW
ADDRESS_LINK_TYPE Package Type
ADDRESS_TYPE Package Type
ADDRESS_TYPE Package Type
R_RESULTSET Package Type
P_COMPARE_CURRENT_EV Package procedure
P_COMPARE_CURRENT_STU Package procedure
P_CREATE_EV_ROW Package procedure
P_CREATE_STU_ROW Package procedure
P_DISP_CONFIRM Package procedure
P_DISP_PAYMENT_TYPE Package procedure
P_DISP_TRANSCRIPT_REQUEST_DATA Package procedure
P_DISP_TRANS_REQUEST_CHARGES Package procedure
P_LOAD_ADDRESS Package procedure
P_SELECT_GOVSVEV Package procedure
P_SELECT_GOVSVSD Package procedure
P_VALIDATE_EV_REQ_FIELDS Package procedure
P_VALIDATE_STU_REQ_FIELDS Package procedure
ADDRESS_LINK_REC Package variable
ADDRESS_REC Package variable
ADDRESS_REC Package variable
AMVGEOR_REC Package variable
AMVGEOR_REC Package variable
AS_ADMISSIONS_APPLICANT_REC Package variable
AS_RECRUITING_DATA_REC Package variable
AS_STUDENT_DATA_REC Package variable
CONIDEN_REC Package variable
SPRADDR_REC Package variable
SPRADDR_REC Package variable
SPRADDR_REC Package variable
SPRADDR_REC Package variable
SPRADDR_REC Package variable
V_RESSET Package variable
CREATE_CONSTITUENT Forms Procedure
UPDATE_CONSTITUENT Forms Procedure
AOVCOMP Forms DataBlock
AS_STUDENT_DATA Forms DataBlock
SOVGEOR Forms DataBlock
SPVADDS Forms DataBlock
SPVPERS Forms DataBlock
SPVPERS Forms DataBlock
SPVPERS Forms DataBlock
SPVPERS Forms DataBlock
ON-CHECK-DELETE-MASTER Forms Trigger
POST-QUERY Forms Trigger
D00-PROCESS-GLRVFRM Cobol Section
D00A-FETCH-GLRVFRM Cobol Section
D00B-PROCESS-GLRSFRM Cobol Section
D00C-FETCH-GLRSFRM Cobol Section
D03-PROCESS-PARMS Cobol Section
D04F-STORE-ON-CHAIN Cobol Section
D05-PROCESS-SPVADDS-RTN Cobol Section
D06A-PROCESS-SPVADDS-DATA Cobol Section
E01-PROCESS-ORDER Cobol Section
E03-GET-GLRCMPL Cobol Section
E04-FETCH-STATEMENT Cobol Section
E05-PROCESS-SPVADDS-STATEMENT Cobol Section
E05A-PROCESS-SPVADDS Cobol Section
P17-STRING-GURMAIL Cobol Section
S01-BUILD-SPVADDS Cobol Section
S02-PROCESS-SPVADDS Cobol Section
S03-PROCESS-CONT Cobol Section
S03A-BUILD-SPVADDS-STRING Cobol Section
S05-SPVADDS-APPL-RULES Cobol Section
Y00-GET-CREATOR Cobol Section

Impact job : WALKER_TEST_SPRADDR_CITY New Job

Impact job : SPRIDEN_LAST_NAME2 New Job

Impacted objects

Object Name Object Type
F_SECONDARY_CONTACT_ADDRESS FUNCTION
AA_CONSTITUENT_IDENTIFICATION VIEW
AA_ORGANIZATION VIEW
AF_VENDOR_PERFORMANCE VIEW
AF_VENDOR_VOLUME VIEW
AG_ENTITY_DATA VIEW
AG_EVENTS_AND_FUNCTIONS VIEW
ALVADDS VIEW
AMVGEOR VIEW
AOVCOMP VIEW
AOVIDEN VIEW
AOVORG1 VIEW
APVADRS VIEW
APVCNI1 VIEW
AP_DEDUCTIONS_BENEFITS VIEW
AP_EMPLOYEE_PROFILE VIEW
AP_EMPLOYMENT_VERIFICATION VIEW
AP_EMPLOY_RECRUITMENT_ACTIVITY VIEW
AP_JOB_SUMMARY VIEW
AR_AWARD_DETAIL_BY_TERM VIEW
AR_AWARD_DETAIL_BY_YEAR VIEW
AR_FINAID_APPLICANT VIEW
AR_FINAID_STUDENT_SUMMARY VIEW
AS_ACADEMIC_HISTORY_DETAIL VIEW
AS_ACADEMIC_HISTORY_SUMMARY VIEW
AS_ADMISSIONS_APPLICANT VIEW
AS_AGING_ANALYSIS VIEW
AS_CLEARED_TO_ATTEND VIEW
AS_FACULTY_DATA VIEW
AS_RECRUITING_DATA VIEW
AS_RECRUITING_SOURCE_ANALYSIS VIEW
AS_RESIDENTIAL_LIFE VIEW
AS_RESIDENTIAL_LIFE_CHANGES VIEW
AS_STUDENT_DATA VIEW
AS_STUDENT_ENROLLMENT_SUMMARY VIEW
AS_STUDENT_REGISTRATION_DETAIL VIEW
AS_THIRD_PARTY_CONTRACTS VIEW
GEVEVN1 VIEW
GEVEVN2 VIEW
GOVSVAS VIEW
GOVSVEI VIEW
GOVSVEV VIEW
GOVSVSD VIEW
GPVENT1 VIEW
PAVREQ1 VIEW
PDVDED1 VIEW
PEVJOB1 VIEW
PEVPRF1 VIEW
PEVREC0 VIEW
PEVVER1 VIEW
PEVVER2 VIEW
PPVADRS VIEW
RCVAPL1 VIEW
RCVAPL2 VIEW
ROVSTU1 VIEW
ROVSTU2 VIEW
ROVSTU3 VIEW
RPVADDR VIEW
RPVADRS VIEW
RPVAWT1 VIEW
RPVAWT2 VIEW
RPVAWY1 VIEW
RPVAWY2 VIEW
RPVFDRS VIEW
SAVADM1 VIEW
SAVADM2 VIEW
SAVADRS VIEW
SAVAMCD VIEW
SFVETR1 VIEW
SFVETR2 VIEW
SFVSTC1 VIEW
SFVSTC2 VIEW
SGVADRS VIEW
SGVSTD1 VIEW
SGVSTD2 VIEW
SHVDTL1 VIEW
SHVDTL2 VIEW
SHVSUM1 VIEW
SHVSUM2