Model Emergency Contact View and Upd

Model Label : Web General Emergency Contact View and Update
Path : BANNER DEV/Web General/Emergency Contact View and Update/Emergency Contact View and Upd

List of Objects

Object Name	Object Type	Layer Name
SPREMRG	TABLE	Default
STVATYP	TABLE	Default
STVNATN	TABLE	Default
STVRELT	TABLE	Default
STVSTAT	TABLE	Default

Comments

Model View

Table SPREMRG

Schema Name SATURN
Label SPREMRG
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:36:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SPREMRG_PIDM	SPREMRG_PIDM	NUMBER(8,0)	No	*
SPREMRG_PRIORITY	SPREMRG_PRIORITY	VARCHAR2(1)	No	*
SPREMRG_LAST_NAME	SPREMRG_LAST_NAME	VARCHAR2(25)	No
SPREMRG_FIRST_NAME	SPREMRG_FIRST_NAME	VARCHAR2(15)	No
SPREMRG_MI	SPREMRG_MI	VARCHAR2(1)	Yes
SPREMRG_STREET_LINE1	SPREMRG_STREET_LINE1	VARCHAR2(30)	Yes
SPREMRG_STREET_LINE2	SPREMRG_STREET_LINE2	VARCHAR2(30)	Yes
SPREMRG_STREET_LINE3	SPREMRG_STREET_LINE3	VARCHAR2(30)	Yes
SPREMRG_CITY	SPREMRG_CITY	VARCHAR2(20)	Yes
SPREMRG_STAT_CODE	SPREMRG_STAT_CODE	VARCHAR2(3)	Yes		*
SPREMRG_NATN_CODE	SPREMRG_NATN_CODE	VARCHAR2(5)	Yes		*
SPREMRG_ZIP	SPREMRG_ZIP	VARCHAR2(10)	Yes
SPREMRG_PHONE_AREA	SPREMRG_PHONE_AREA	VARCHAR2(3)	Yes
SPREMRG_PHONE_NUMBER	SPREMRG_PHONE_NUMBER	VARCHAR2(7)	Yes
SPREMRG_PHONE_EXT	SPREMRG_PHONE_EXT	VARCHAR2(4)	Yes
SPREMRG_RELT_CODE	SPREMRG_RELT_CODE	VARCHAR2(1)	Yes		*
SPREMRG_ACTIVITY_DATE	SPREMRG_ACTIVITY_DATE	DATE	No
SPREMRG_ATYP_CODE	SPREMRG_ATYP_CODE	VARCHAR2(2)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SPREMRG_RELT_CODE	STVRELT_CODE	STVRELT
SPREMRG_STAT_CODE	STVSTAT_CODE	STVSTAT
SPREMRG_ATYP_CODE	STVATYP_CODE	STVATYP
SPREMRG_NATN_CODE	STVNATN_CODE	STVNATN

Index

Index Name	Index Type	Column Name
PK_SPREMRG	Unique	SPREMRG_PIDM
PK_SPREMRG	Unique	SPREMRG_PRIORITY

Comments

Source Code Comments

Emergency Contact Repeating Table

Columns Comments for SPREMRG_PIDM (1)

Source Code Comments

Internal identification number of person.

Columns Comments for SPREMRG_PRIORITY (2)

Source Code Comments

Priority indicator associated with emergency address of person record.

Columns Comments for SPREMRG_LAST_NAME (3)

Source Code Comments

Last name of person associated with emergency address information.

Columns Comments for SPREMRG_FIRST_NAME (4)

Source Code Comments

First name of person associated with emergency address information.

Columns Comments for SPREMRG_MI (5)

Source Code Comments

Middle name of person associated with emergency address information.

Columns Comments for SPREMRG_STREET_LINE1 (6)

Source Code Comments

Line one of emergency adddress.

Columns Comments for SPREMRG_STREET_LINE2 (7)

Source Code Comments

Line two of emergency address.

Columns Comments for SPREMRG_STREET_LINE3 (8)

Source Code Comments

Line three of emergency address.

Columns Comments for SPREMRG_CITY (9)

Source Code Comments

City associated with emergency address.

Columns Comments for SPREMRG_STAT_CODE (10)

Source Code Comments

State associated with emergency address.

Columns Comments for SPREMRG_NATN_CODE (11)

Source Code Comments

Nation/country associated with emergency address.

Columns Comments for SPREMRG_ZIP (12)

Source Code Comments

Zip code associated with emergency address.

Columns Comments for SPREMRG_PHONE_AREA (13)

Source Code Comments

Area code of phone number associated with emergency address.

Columns Comments for SPREMRG_PHONE_NUMBER (14)

Source Code Comments

Phone number associated with emergency address.

Columns Comments for SPREMRG_PHONE_EXT (15)

Source Code Comments

Extension of phone number associated with emergency address.

Columns Comments for SPREMRG_RELT_CODE (16)

Source Code Comments

This field identifies the relationship between emergency contact person and and the person record.

Columns Comments for SPREMRG_ACTIVITY_DATE (17)

Source Code Comments

Most current date that the record was created or changed. This field does not display on screen.

Columns Comments for SPREMRG_ATYP_CODE (18)

Source Code Comments

The address type associated with the emergency address.

Table STVATYP

Schema Name SATURN
Label STVATYP
Server name MALDEV8_B60
Creation Date 05/08/2003 12:41:33:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
STVATYP_CODE	STVATYP_CODE	VARCHAR2(2)	No	*
STVATYP_DESC	STVATYP_DESC	VARCHAR2(30)	Yes
STVATYP_ACTIVITY_DATE	STVATYP_ACTIVITY_DATE	DATE	No
STVATYP_SYSTEM_REQ_IND	STVATYP_SYSTEM_REQ_IND	VARCHAR2(1)	Yes
STVATYP_TELE_CODE	STVATYP_TELE_CODE	VARCHAR2(4)	Yes		*
STVATYP_UPDATE_WEB_IND	STVATYP_UPDATE_WEB_IND	RAW(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
STVATYP_TELE_CODE	STVTELE_CODE	STVTELE

Index

Index Name	Index Type	Column Name
PK_STVATYP	Unique	STVATYP_CODE

Comments

Source Code Comments

Address Type Validation Table

Columns Comments for STVATYP_CODE (1)

Source Code Comments

A code used throughout all BANNER systems to identify the type of address for which information is maintained (for example; Mailing, Permanent, or Billing).

Columns Comments for STVATYP_DESC (2)

Source Code Comments

This field identifies the address type associated with the type code.

Columns Comments for STVATYP_ACTIVITY_DATE (3)

Source Code Comments

This field identifies the most recent date a record was created or updated.

Columns Comments for STVATYP_SYSTEM_REQ_IND (4)

Source Code Comments

System Required Indicator

Columns Comments for STVATYP_TELE_CODE (5)

Source Code Comments

Default Telephone type code for telephone number.

Columns Comments for STVATYP_UPDATE_WEB_IND (6)

Source Code Comments

Web update indicator. This column is now obsolete. Refer to table goradrl

Table STVNATN

Schema Name SATURN
Label STVNATN
Server name MALDEV8_B60
Creation Date 05/08/2003 12:41:34:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
STVNATN_CODE	STVNATN_CODE	VARCHAR2(5)	No	*	*
STVNATN_CODE	STVNATN_CODE	VARCHAR2(5)	No	*	*
STVNATN_NATION	STVNATN_NATION	VARCHAR2(30)	No
STVNATN_CAPITAL	STVNATN_CAPITAL	VARCHAR2(20)	Yes
STVNATN_AREA	STVNATN_AREA	NUMBER(22,0)	Yes
STVNATN_POPULATION	STVNATN_POPULATION	NUMBER(22,0)	Yes
STVNATN_ACTIVITY_DATE	STVNATN_ACTIVITY_DATE	DATE	No
STVNATN_EDI_EQUIV	STVNATN_EDI_EQUIV	VARCHAR2(2)	Yes
STVNATN_LMS_EQUIV	STVNATN_LMS_EQUIV	VARCHAR2(2)	Yes
STVNATN_POSTAL_MASK	STVNATN_POSTAL_MASK	VARCHAR2(15)	Yes
STVNATN_TELE_MASK	STVNATN_TELE_MASK	VARCHAR2(15)	Yes
STVNATN_STATSCAN_CDE	STVNATN_STATSCAN_CDE	VARCHAR2(5)	Yes
STVNATN_SCOD_CODE_ISO	STVNATN_SCOD_CODE_ISO	VARCHAR2(3)	Yes
STVNATN_SSA_REPORTING_EQUIV	STVNATN_SSA_REPORTING_EQUIV	VARCHAR2(2)	Yes
STVNATN_SEVIS_EQUIV	STVNATN_SEVIS_EQUIV	VARCHAR2(2)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
STVNATN_CODE	GOBINTL_NATN_CODE_BIRTH	GOBINTL
STVNATN_CODE	GOBINTL_NATN_CODE_LEGAL	GOBINTL

Index

Index Name	Index Type	Column Name
PK_STVNATN	Unique	STVNATN_CODE

Comments

Source Code Comments

Nation Validation Table

Columns Comments for STVNATN_CODE (1)

Source Code Comments

This field identifies the nation code referenced in the Gen. Person, Admissions, Gen. Student, and Student Billing Modules.

Columns Comments for STVNATN_NATION (2)

Source Code Comments

This field specifies the nation/country associated with the nation code.

Columns Comments for STVNATN_CAPITAL (3)

Source Code Comments

This field is not currently in use.

Columns Comments for STVNATN_AREA (4)

Source Code Comments

This field is not currently in use.

Columns Comments for STVNATN_POPULATION (5)

Source Code Comments

This field is not currently in use.

Columns Comments for STVNATN_ACTIVITY_DATE (6)

Source Code Comments

This field identifies the most recent date a record was created or updated.

Columns Comments for STVNATN_EDI_EQUIV (7)

Source Code Comments

EDI/SPEEDE country code that equates to the nation code. Refer to the SPEEDE Implementation Guide, Appendix B, data element 26 for valid values.

Columns Comments for STVNATN_LMS_EQUIV (8)

Source Code Comments

LMS (IA Plus) nation (country) code that equates to this Banner nation code. Translation to this LMS code occurs during the LMS transaction feed from Banner FA.

Columns Comments for STVNATN_STATSCAN_CDE (11)

Source Code Comments

Statistics Canadian specific code.

Columns Comments for STVNATN_SCOD_CODE_ISO (12)

Source Code Comments

ISO CODE: The three character International Standards Organization (ISO) Code associated with the user defined nation code.

Columns Comments for STVNATN_SSA_REPORTING_EQUIV (13)

Source Code Comments

Social Security Administration country code that equates to the nation code. Refer to the Magnetic Media Reporting and Electronic Filing (MMREF-1) Guide, Appendix C, for valid values.

Columns Comments for STVNATN_SEVIS_EQUIV (14)

Source Code Comments

SEVIS EQUIVALENCY: SEVIS code for nation

Table STVRELT

Schema Name SATURN
Label STVRELT
Server name MALDEV8_B60
Creation Date 09/30/2002 13:59:42:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
STVRELT_CODE	STVRELT_CODE	VARCHAR2(1)	No	*
STVRELT_DESC	STVRELT_DESC	VARCHAR2(30)	Yes
STVRELT_ACTIVITY_DATE	STVRELT_ACTIVITY_DATE	DATE	No
STVRELT_SEVIS_EQUIV	STVRELT_SEVIS_EQUIV	VARCHAR2(3)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_STVRELT	Unique	STVRELT_CODE

Comments

Source Code Comments

Relationship Validation Table

Columns Comments for STVRELT_CODE (1)

Source Code Comments

This field identifies the relationship code referenced on the Emergency Contact Form (SPAEMER) and the Guardian Information Form (SOAFOLK).

Columns Comments for STVRELT_DESC (2)

Source Code Comments

This field specifies the relationship of contact person to person associated with record.

Columns Comments for STVRELT_ACTIVITY_DATE (3)

Source Code Comments

This field identifies the most recent date a record was created or updated.

Columns Comments for STVRELT_SEVIS_EQUIV (4)

Source Code Comments

SEVIS EQUIVALENCY: SEVIS code for relationship

Table STVSTAT

Schema Name SATURN
Label STVSTAT
Server name MALDEV8_B60
Creation Date 05/08/2003 12:41:34:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
STVSTAT_CODE	STVSTAT_CODE	VARCHAR2(3)	No	*	*
STVSTAT_DESC	STVSTAT_DESC	VARCHAR2(30)	No
STVSTAT_ACTIVITY_DATE	STVSTAT_ACTIVITY_DATE	DATE	No
STVSTAT_EDI_EQUIV	STVSTAT_EDI_EQUIV	VARCHAR2(2)	Yes
STVSTAT_STATSCAN_CDE	STVSTAT_STATSCAN_CDE	VARCHAR2(5)	Yes
STVSTAT_IPEDS_CDE	STVSTAT_IPEDS_CDE	VARCHAR2(5)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
STVSTAT_CODE	SIBFACD_BIRTH_STATE	SIBFACD

Index

Index Name	Index Type	Column Name
PK_STVSTAT	Unique	STVSTAT_CODE

Comments

Source Code Comments

State Code Validation Table

Columns Comments for STVSTAT_CODE (1)

Source Code Comments

This field identifies the state code referenced in the Gen. Person, Admissions, Gen. Student, Student Billing, and Academic History Modules.

Columns Comments for STVSTAT_DESC (2)

Source Code Comments

This field specifies the state associated with the state code.

Columns Comments for STVSTAT_ACTIVITY_DATE (3)

Source Code Comments

This field identifies the most recent date a record was created or deleted.

Columns Comments for STVSTAT_EDI_EQUIV (4)

Source Code Comments

This is the state equivalent code EDI will use for electronic transcripts for the BANNER2 state code matched on column STVSTAT_CODE.

Columns Comments for STVSTAT_STATSCAN_CDE (5)

Source Code Comments

Statistics Canadian specific code.

Columns Comments for STVSTAT_IPEDS_CDE (6)

Source Code Comments

Free format code for Student IPEDS reporting.

Link between SPREMRG and STVNATN

Caller : SPREMRG
Called : STVNATN

Link List

Link Type	Link	Project
Refer(No Action )	Link Foreign Key Between SPREMRG and STVNATN	SATURN

Link Foreign Key Between SPREMRG and STVNATN

Caller : SPREMRG
Called : STVNATN
Link Type : Refer(No Action )
Link : Link Foreign Key Between SPREMRG and STVNATN

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SPREMRG	SPREMRG_NATN_CODE	STVNATN_CODE	STVNATN	(0,1)-(0,n)

Comments

Link between SPREMRG and STVATYP

Caller : SPREMRG
Called : STVATYP

Link List

Link Type	Link	Project
Refer(No Action )	Link Foreign Key Between SPREMRG and STVATYP	SATURN

Link Foreign Key Between SPREMRG and STVATYP

Caller : SPREMRG
Called : STVATYP
Link Type : Refer(No Action )
Link : Link Foreign Key Between SPREMRG and STVATYP

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SPREMRG	SPREMRG_ATYP_CODE	STVATYP_CODE	STVATYP	(0,1)-(0,n)

Comments

Link between SPREMRG and STVRELT

Caller : SPREMRG
Called : STVRELT

Link List

Link Type	Link	Project
Refer(No Action )	Link Foreign Key Between SPREMRG and STVRELT	SATURN

Link Foreign Key Between SPREMRG and STVRELT

Caller : SPREMRG
Called : STVRELT
Link Type : Refer(No Action )
Link : Link Foreign Key Between SPREMRG and STVRELT

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SPREMRG	SPREMRG_RELT_CODE	STVRELT_CODE	STVRELT	(0,1)-(0,n)

Comments

Link between SPREMRG and STVSTAT

Caller : SPREMRG
Called : STVSTAT

Link List

Link Type	Link	Project
Refer(No Action )	Link Foreign Key Between SPREMRG and STVSTAT	SATURN

Link Foreign Key Between SPREMRG and STVSTAT

Caller : SPREMRG
Called : STVSTAT
Link Type : Refer(No Action )
Link : Link Foreign Key Between SPREMRG and STVSTAT

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
SPREMRG	SPREMRG_STAT_CODE	STVSTAT_CODE	STVSTAT	(0,1)-(0,n)