Model E-mail View and Update

Model Label : Web General E-mail View and Update
Path : BANNER DEV/Web General/E-mail View and Update/E-mail View and Update

List of Objects

Object Name	Object Type	Layer Name
APBWIDN	TABLE	Default
GOREMAL	TABLE	Default
GTVEMAL	TABLE	Default
ROTEMAL	TABLE	Default
SARADAP	TABLE	Default
SARADAP Reference	User Object	Default
SARWAPP	TABLE	Default
SPBPERS	TABLE	Default
SPBPERS reference	User Object	Default
SRBWPRO	TABLE	Default
SRTEMAL	TABLE	Default

Comments

Model View

Table APBWIDN

Schema Name ALUMNI
Label APBWIDN
Server name MALDEV8_B60
Creation Date 05/08/2003 12:46:02:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
APBWIDN_ID	APBWIDN_ID	VARCHAR2(9)	No	*
APBWIDN_PIN	APBWIDN_PIN	VARCHAR2(6)	No
APBWIDN_ACTIVITY_DATE	APBWIDN_ACTIVITY_DATE	DATE	No
APBWIDN_USER	APBWIDN_USER	VARCHAR2(30)	No
APBWIDN_ACCEPTED_IND	APBWIDN_ACCEPTED_IND	VARCHAR2(1)	No
APBWIDN_QUESTION	APBWIDN_QUESTION	VARCHAR2(90)	Yes
APBWIDN_ANSWER	APBWIDN_ANSWER	VARCHAR2(30)	Yes
APBWIDN_PIDM	APBWIDN_PIDM	NUMBER(8,0)	Yes
APBWIDN_LAST_NAME	APBWIDN_LAST_NAME	VARCHAR2(60)	Yes
APBWIDN_FIRST_NAME	APBWIDN_FIRST_NAME	VARCHAR2(15)	Yes
APBWIDN_MI	APBWIDN_MI	VARCHAR2(15)	Yes
APBWIDN_MAIDEN_NAME	APBWIDN_MAIDEN_NAME	VARCHAR2(60)	Yes
APBWIDN_NAME_PREFIX	APBWIDN_NAME_PREFIX	VARCHAR2(20)	Yes
APBWIDN_NAME_SUFFIX	APBWIDN_NAME_SUFFIX	VARCHAR2(20)	Yes
APBWIDN_BIRTH_DATE	APBWIDN_BIRTH_DATE	DATE	Yes
APBWIDN_SEX	APBWIDN_SEX	VARCHAR2(1)	Yes
APBWIDN_ATYP_CODE	APBWIDN_ATYP_CODE	VARCHAR2(2)	Yes		*
APBWIDN_STREET_LINE1	APBWIDN_STREET_LINE1	VARCHAR2(30)	Yes
APBWIDN_STREET_LINE2	APBWIDN_STREET_LINE2	VARCHAR2(30)	Yes
APBWIDN_STREET_LINE3	APBWIDN_STREET_LINE3	VARCHAR2(30)	Yes
APBWIDN_CITY	APBWIDN_CITY	VARCHAR2(20)	Yes
APBWIDN_STAT_CODE	APBWIDN_STAT_CODE	VARCHAR2(3)	Yes		*
APBWIDN_ZIP	APBWIDN_ZIP	VARCHAR2(10)	Yes
APBWIDN_CNTY_CODE	APBWIDN_CNTY_CODE	VARCHAR2(5)	Yes		*
APBWIDN_NATN_CODE	APBWIDN_NATN_CODE	VARCHAR2(5)	Yes		*
APBWIDN_TELE_CODE	APBWIDN_TELE_CODE	VARCHAR2(4)	Yes		*
APBWIDN_PHONE_AREA	APBWIDN_PHONE_AREA	VARCHAR2(3)	Yes
APBWIDN_PHONE_NUMBER	APBWIDN_PHONE_NUMBER	VARCHAR2(7)	Yes
APBWIDN_PHONE_EXT	APBWIDN_PHONE_EXT	VARCHAR2(4)	Yes
APBWIDN_INTL_ACCESS	APBWIDN_INTL_ACCESS	VARCHAR2(16)	Yes
APBWIDN_UNLIST_IND	APBWIDN_UNLIST_IND	VARCHAR2(1)	Yes
APBWIDN_FAX_TELE_CODE	APBWIDN_FAX_TELE_CODE	VARCHAR2(4)	Yes		*
APBWIDN_FAX_AREA	APBWIDN_FAX_AREA	VARCHAR2(3)	Yes
APBWIDN_FAX_NUMBER	APBWIDN_FAX_NUMBER	VARCHAR2(7)	Yes
APBWIDN_FAX_INTL_ACCESS	APBWIDN_FAX_INTL_ACCESS	VARCHAR2(16)	Yes
APBWIDN_FAX_UNLIST_IND	APBWIDN_FAX_UNLIST_IND	VARCHAR2(1)	Yes
APBWIDN_EMAIL_ADDRESS	APBWIDN_EMAIL_ADDRESS	VARCHAR2(90)	Yes
APBWIDN_EMAL_CODE	APBWIDN_EMAL_CODE	VARCHAR2(4)	Yes		*
APBWIDN_SPS_LAST_NAME	APBWIDN_SPS_LAST_NAME	VARCHAR2(60)	Yes
APBWIDN_SPS_FIRST_NAME	APBWIDN_SPS_FIRST_NAME	VARCHAR2(15)	Yes
APBWIDN_SPS_MI	APBWIDN_SPS_MI	VARCHAR2(15)	Yes
APBWIDN_PREF_CLAS	APBWIDN_PREF_CLAS	VARCHAR2(4)	Yes
APBWIDN_PREF_COLL	APBWIDN_PREF_COLL	VARCHAR2(2)	Yes
APBWIDN_DONR_CODE	APBWIDN_DONR_CODE	VARCHAR2(4)	Yes		*
APBWIDN_LAST_LOGIN_DATE	APBWIDN_LAST_LOGIN_DATE	DATE	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
APBWIDN_DONR_CODE	ATVDONR_CODE	ATVDONR
APBWIDN_EMAL_CODE	GTVEMAL_CODE	GTVEMAL
APBWIDN_STAT_CODE	STVSTAT_CODE	STVSTAT
APBWIDN_CNTY_CODE	STVCNTY_CODE	STVCNTY
APBWIDN_ATYP_CODE	STVATYP_CODE	STVATYP
APBWIDN_NATN_CODE	STVNATN_CODE	STVNATN

Index

Index Name	Index Type	Column Name
PK_APBWIDN	Unique	APBWIDN_ID

Comments

Source Code Comments

Web Access Base Record Hold Table.

Columns Comments for APBWIDN_ID (1)

Source Code Comments

Web ID created by a user not found in Banner.

Columns Comments for APBWIDN_PIN (2)

Source Code Comments

Personal Identification Number selected by the Web user.

Columns Comments for APBWIDN_ACTIVITY_DATE (3)

Source Code Comments

Date record created or updated.

Columns Comments for APBWIDN_USER (4)

Source Code Comments

User who created or changed the record.

Columns Comments for APBWIDN_ACCEPTED_IND (5)

Source Code Comments

Accepted Indicator, Y = Accepted, N = not Accepted.

Columns Comments for APBWIDN_QUESTION (6)

Source Code Comments

Security Question created by user with no Banner PIDM.

Columns Comments for APBWIDN_ANSWER (7)

Source Code Comments

Answer to Security Question created by user with no Banner PIDM.

Columns Comments for APBWIDN_PIDM (8)

Source Code Comments

Internal ID of person in Banner.

Columns Comments for APBWIDN_LAST_NAME (9)

Source Code Comments

Last Name of user with no Banner PIDM.

Columns Comments for APBWIDN_FIRST_NAME (10)

Source Code Comments

First Name of user with no Banner PIDM.

Columns Comments for APBWIDN_MI (11)

Source Code Comments

Middle Name of user with no Banner PIDM.

Columns Comments for APBWIDN_MAIDEN_NAME (12)

Source Code Comments

Maiden Name of user with no Banner PIDM.

Columns Comments for APBWIDN_NAME_PREFIX (13)

Source Code Comments

Name prefix of user with no Banner PIDM.

Columns Comments for APBWIDN_NAME_SUFFIX (14)

Source Code Comments

Name suffix of user with no Banner PIDM.

Columns Comments for APBWIDN_BIRTH_DATE (15)

Source Code Comments

Birth Date of user with no Banner PIDM.

Columns Comments for APBWIDN_SEX (16)

Source Code Comments

Gender of user with no Banner PIDM.

Columns Comments for APBWIDN_ATYP_CODE (17)

Source Code Comments

Address Type of user with no Banner PIDM.

Columns Comments for APBWIDN_STREET_LINE1 (18)

Source Code Comments

Street Line 1 of user with no Banner PIDM.

Columns Comments for APBWIDN_STREET_LINE2 (19)

Source Code Comments

Street Line 2 of user with no Banner PIDM.

Columns Comments for APBWIDN_STREET_LINE3 (20)

Source Code Comments

Street Line 3 of user with no Banner PIDM.

Columns Comments for APBWIDN_CITY (21)

Source Code Comments

Address City of user with no Banner PIDM.

Columns Comments for APBWIDN_STAT_CODE (22)

Source Code Comments

Address State of user with no Banner PIDM.

Columns Comments for APBWIDN_ZIP (23)

Source Code Comments

Address Zip/Postal Code of user with no Banner PIDM.

Columns Comments for APBWIDN_CNTY_CODE (24)

Source Code Comments

Address County of user with no Banner PIDM.

Columns Comments for APBWIDN_NATN_CODE (25)

Source Code Comments

Address Nation of user with no Banner PIDM.

Columns Comments for APBWIDN_TELE_CODE (26)

Source Code Comments

Telephone Type of user with no Banner PIDM.

Columns Comments for APBWIDN_PHONE_AREA (27)

Source Code Comments

Phone Number Area Code of user with no Banner PIDM.

Columns Comments for APBWIDN_PHONE_NUMBER (28)

Source Code Comments

Phone Number of user with no Banner PIDM.

Columns Comments for APBWIDN_PHONE_EXT (29)

Source Code Comments

Phone Number Extension of user with no Banner PIDM.

Columns Comments for APBWIDN_INTL_ACCESS (30)

Source Code Comments

Internation Access Code of Phone Number of user with no Banner PIDM.

Columns Comments for APBWIDN_UNLIST_IND (31)

Source Code Comments

Unlisted Indicator of Phone Number of user with no Banner PIDM.

Columns Comments for APBWIDN_FAX_TELE_CODE (32)

Source Code Comments

FAX Telephone Type of user with no Banner PIDM.

Columns Comments for APBWIDN_FAX_AREA (33)

Source Code Comments

FAX Area Code of user with no Banner PIDM.

Columns Comments for APBWIDN_FAX_NUMBER (34)

Source Code Comments

FAX Phone Number of user with no Banner PIDM.

Columns Comments for APBWIDN_FAX_INTL_ACCESS (35)

Source Code Comments

Internation Access Code of Fax Number of user with no Banner PIDM.

Columns Comments for APBWIDN_FAX_UNLIST_IND (36)

Source Code Comments

Unlisted Indicator of Fax Number of user with no Banner PIDM.

Columns Comments for APBWIDN_EMAIL_ADDRESS (37)

Source Code Comments

Email Address of user with no Banner PIDM.

Columns Comments for APBWIDN_EMAL_CODE (38)

Source Code Comments

Email Code of user with no Banner PIDM.

Columns Comments for APBWIDN_SPS_LAST_NAME (39)

Source Code Comments

Spouse Last Name of user with no Banner PIDM.

Columns Comments for APBWIDN_SPS_FIRST_NAME (40)

Source Code Comments

Spouse First Name of user with no Banner PIDM.

Columns Comments for APBWIDN_SPS_MI (41)

Source Code Comments

Spouse Middle Name of user with no Banner PIDM.

Columns Comments for APBWIDN_PREF_CLAS (42)

Source Code Comments

Preferred class of user with no Banner PIDM.

Columns Comments for APBWIDN_DONR_CODE (44)

Source Code Comments

Donor Code of user with no Banner PIDM.

Columns Comments for APBWIDN_LAST_LOGIN_DATE (45)

Source Code Comments

Date user with no Banner PIDM last logged into the web.

Table GOREMAL

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
GOREMAL_PIDM	GOREMAL_PIDM	NUMBER(8,0)	No	*
GOREMAL_PIDM	GOREMAL_PIDM	NUMBER(8,0)	No	*
GOREMAL_EMAL_CODE	GOREMAL_EMAL_CODE	VARCHAR2(4)	No	*
GOREMAL_EMAIL_ADDRESS	GOREMAL_EMAIL_ADDRESS	VARCHAR2(90)	No
GOREMAL_STATUS_IND	GOREMAL_STATUS_IND	VARCHAR2(1)	No
GOREMAL_PREFERRED_IND	GOREMAL_PREFERRED_IND	VARCHAR2(1)	No
GOREMAL_ACTIVITY_DATE	GOREMAL_ACTIVITY_DATE	DATE	No
GOREMAL_USER_ID	GOREMAL_USER_ID	VARCHAR2(30)	No
GOREMAL_COMMENT	GOREMAL_COMMENT	VARCHAR2(60)	Yes
GOREMAL_DISP_WEB_IND	GOREMAL_DISP_WEB_IND	VARCHAR2(1)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GOREMAL_EMAL_CODE	GTVEMAL_CODE	GTVEMAL
GOREMAL_PIDM	SPBPERS_PIDM	SPBPERS
GOREMAL_PIDM	SARADAP_PIDM	SARADAP

Index

Index Name	Index Type	Column Name
GOREMAL_EMAL_INDEX		GOREMAL_PIDM
GOREMAL_EMAL_INDEX		GOREMAL_EMAL_CODE

Comments

Source Code Comments

Person E-mail repeating table.

Columns Comments for GOREMAL_PIDM (1)

Source Code Comments

The pidm of the entity who owns this e-mail information.

Columns Comments for GOREMAL_EMAL_CODE (2)

Source Code Comments

The type of e-mail address.

Columns Comments for GOREMAL_EMAIL_ADDRESS (3)

Source Code Comments

The e-mail address.

Columns Comments for GOREMAL_STATUS_IND (4)

Source Code Comments

The status of the e-mail address: (A)ctive, (I)nactive

Columns Comments for GOREMAL_PREFERRED_IND (5)

Source Code Comments

This column indicates if the e-mail address is the preferred contact address.

Columns Comments for GOREMAL_ACTIVITY_DATE (6)

Source Code Comments

The date on which the row was added or modified.

Columns Comments for GOREMAL_USER_ID (7)

Source Code Comments

The user id when the row was added or modified.

Columns Comments for GOREMAL_COMMENT (8)

Source Code Comments

This is a free format comment regarding the e-mail information.

Columns Comments for GOREMAL_DISP_WEB_IND (9)

Source Code Comments

Indicate whether a e-mail address should appear on Web.

Table GTVEMAL

Schema Name GENERAL
Label GTVEMAL
Server name MALDEV8_B60
Creation Date 05/08/2003 12:42:16:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
GTVEMAL_CODE	GTVEMAL_CODE	VARCHAR2(4)	No	*
GTVEMAL_DESC	GTVEMAL_DESC	VARCHAR2(60)	Yes
GTVEMAL_ACTIVITY_DATE	GTVEMAL_ACTIVITY_DATE	DATE	No
GTVEMAL_DISP_WEB_IND	GTVEMAL_DISP_WEB_IND	VARCHAR2(1)	No
GTVEMAL_URL_IND	GTVEMAL_URL_IND	VARCHAR2(1)	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVEMAL	Unique	GTVEMAL_CODE

Comments

Source Code Comments

The GTVEMAL table contains the valid e-mail type codes.

Columns Comments for GTVEMAL_CODE (1)

Source Code Comments

A code identifying the type of e-mail address.

Columns Comments for GTVEMAL_DESC (2)

Source Code Comments

The description of the e-mail address.

Columns Comments for GTVEMAL_ACTIVITY_DATE (3)

Source Code Comments

The date on which the row was added or modified.

Columns Comments for GTVEMAL_DISP_WEB_IND (4)

Source Code Comments

Display on Web Indicator, Y indicates this type of email should display

Columns Comments for GTVEMAL_URL_IND (5)

Source Code Comments

URL Indicator, Y indicates that this email record is actually a URL.

Table ROTEMAL

Schema Name FAISMGR
Label ROTEMAL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:17:22:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
ROTEMAL_PIDM	ROTEMAL_PIDM	NUMBER(8,0)	No
ROTEMAL_EMAL_CODE	ROTEMAL_EMAL_CODE	VARCHAR2(4)	No	*
ROTEMAL_EMAIL_ADDRESS	ROTEMAL_EMAIL_ADDRESS	VARCHAR2(90)	No
ROTEMAL_STATUS_IND	ROTEMAL_STATUS_IND	VARCHAR2(1)	No
ROTEMAL_PREFERRED_IND	ROTEMAL_PREFERRED_IND	VARCHAR2(1)	No
ROTEMAL_ACTIVITY_DATE	ROTEMAL_ACTIVITY_DATE	DATE	No
ROTEMAL_USER_ID	ROTEMAL_USER_ID	VARCHAR2(30)	No
ROTEMAL_COMMENT	ROTEMAL_COMMENT	VARCHAR2(60)	Yes
ROTEMAL_DISP_WEB_IND	ROTEMAL_DISP_WEB_IND	VARCHAR2(1)	No
ROTEMAL_INFC_CODE	ROTEMAL_INFC_CODE	VARCHAR2(7)	No
ROTEMAL_AIDY_CODE	ROTEMAL_AIDY_CODE	VARCHAR2(4)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
ROTEMAL_EMAL_CODE	GTVEMAL_CODE	GTVEMAL

Index

Index Name	Index Type	Column Name
ROTEMAL_EMAL_INDEX		ROTEMAL_PIDM
ROTEMAL_EMAL_INDEX		ROTEMAL_EMAL_CODE

Comments

Source Code Comments

Temporary E-Mail Address Table

Columns Comments for ROTEMAL_PIDM (1)

Source Code Comments

PIDM: Internal identification number of the entity who owns this e-mail address information.

Columns Comments for ROTEMAL_EMAL_CODE (2)

Source Code Comments

E-MAIL CODE: The code for identifying the type of e-mail address.

Columns Comments for ROTEMAL_EMAIL_ADDRESS (3)

Source Code Comments

E-MAIL ADDRESS: The e-mail address for this entity.

Columns Comments for ROTEMAL_STATUS_IND (4)

Source Code Comments

E-MAIL STATUS INDICATOR: The current status of the e-mail address.

Columns Comments for ROTEMAL_PREFERRED_IND (5)

Source Code Comments

E-MAIL PREFERRED INDICATOR: This column indicates if the e-mail address is the preferred contact address.

Columns Comments for ROTEMAL_ACTIVITY_DATE (6)

Source Code Comments

ACTIVITY DATE: The date this record was created or last updated.

Columns Comments for ROTEMAL_USER_ID (7)

Source Code Comments

USER ID: The user ID who created or last updated this record.

Columns Comments for ROTEMAL_COMMENT (8)

Source Code Comments

E-MAIL COMMENT: This is a free format comment field regarding the e-mail information.

Columns Comments for ROTEMAL_DISP_WEB_IND (9)

Source Code Comments

DISPLAY ON WEB INDICATOR: A 'Y' in this field indicates that the e-mail information for this entity may be accessed via Banner Web.

Columns Comments for ROTEMAL_INFC_CODE (10)

Source Code Comments

INTERFACE DATA CODE: A code from the Interface Tape Table indicating the source and format of the application record.

Columns Comments for ROTEMAL_AIDY_CODE (11)

Source Code Comments

AID YEAR CODE: The aid year to be associated with information in this record.

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_RESD_CODE	STVRESD_CODE	STVRESD
SARADAP_RTYP_CODE	STVRTYP_CODE	STVRTYP
SARADAP_TERM_CODE_ENTRY	SABVWID_TERM_CODE	SABVWID
SARADAP_APPL_NO	SABVWID_APPL_NO	SABVWID
SARADAP_PIDM	SABVWID_PIDM	SABVWID
SARADAP_EGOL_CODE	STVEGOL_CODE	STVEGOL
SARADAP_ADMT_CODE	STVADMT_CODE	STVADMT
SARADAP_WAIV_CODE	STVWAIV_CODE	STVWAIV
SARADAP_SESS_CODE	STVSESS_CODE	STVSESS
SARADAP_STYP_CODE	STVSTYP_CODE	STVSTYP
SARADAP_RATE_CODE	STVRATE_CODE	STVRATE
SARADAP_PIDM	SORHSCH_PIDM	SORHSCH
SARADAP_PIDM	SRBRECR_PIDM	SRBRECR
SARADAP_TERM_CODE_ENTRY	SRBRECR_TERM_CODE	SRBRECR
SARADAP_WRSN_CODE	STVWRSN_CODE	STVWRSN
SARADAP_INTV_CODE	STVINTV_CODE	STVINTV
SARADAP_EDLV_CODE	STVEDLV_CODE	STVEDLV
SARADAP_APST_CODE	STVAPST_CODE	STVAPST
SARADAP_SITE_CODE	STVSITE_CODE	STVSITE
SARADAP_RECR_CODE	STVRECR_CODE	STVRECR
SARADAP_SBGI_CODE	STVSBGI_CODE	STVSBGI

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.

Columns Comments for SARADAP_CAMP_CODE (11)

Source Code Comments

This field identifies the campus to which applicant is applying.

Columns Comments for SARADAP_SITE_CODE (12)

Source Code Comments

This field identifies the site to which applicant is applying.

Columns Comments for SARADAP_COLL_CODE_1 (13)

Source Code Comments

This field identifies the primary college to which applicant is applying.

Columns Comments for SARADAP_DEGC_CODE_1 (14)

Source Code Comments

This field identifies the primary degree to which applicant is applying.

Columns Comments for SARADAP_MAJR_CODE_1 (15)

Source Code Comments

This field identifies the primary major to which applicant is applying.

Columns Comments for SARADAP_COLL_CODE_2 (16)

Source Code Comments

Curriculum 2 College Code

Columns Comments for SARADAP_DEGC_CODE_2 (17)

Source Code Comments

This field identifies the secondary degree to which applicant is applying.

Columns Comments for SARADAP_MAJR_CODE_2 (18)

Source Code Comments

This field identifies the secondary major to which applicant is applying.

Columns Comments for SARADAP_RESD_CODE (19)

Source Code Comments

This field identifies the residency classification of the applicant.

Columns Comments for SARADAP_FULL_PART_IND (20)

Source Code Comments

This field identifies if applicant intention is for full or part time enrollment.

Columns Comments for SARADAP_SESS_CODE (21)

Source Code Comments

This field identifies which session applicant is applying for.

Columns Comments for SARADAP_WRSN_CODE (22)

Source Code Comments

This field identifies the reason why an application has been withdrawn.

Columns Comments for SARADAP_INTV_CODE (23)

Source Code Comments

This field identifies the status of the interview associated with the applicant.

Columns Comments for SARADAP_FEE_IND (24)

Source Code Comments

This field identifies whether an application fee has been assessed.

Columns Comments for SARADAP_FEE_DATE (25)

Source Code Comments

This field identifies the date application fee has been assessed.

Columns Comments for SARADAP_ACTIVITY_DATE (26)

Source Code Comments

This field identifies the most current date record was created or changed.

Columns Comments for SARADAP_RATE_CODE (27)

Source Code Comments

This field identifies a specific assessment rate assigned to the student.

Columns Comments for SARADAP_EGOL_CODE (28)

Source Code Comments

Educational Goal Code

Columns Comments for SARADAP_EDLV_CODE (29)

Source Code Comments

Education Level Code

Columns Comments for SARADAP_MAJR_CODE_CONC_1 (30)

Source Code Comments

Area of Concentration code.

Columns Comments for SARADAP_DEPT_CODE (31)

Source Code Comments

Department Code.

Columns Comments for SARADAP_SBGI_CODE (32)

Source Code Comments

Institution Attending code. Thisfield represents the institution the student decided to attend rather than the home institution.