Model Admissions All SA% Tables.

Model Label : Banner Student Admissions Module. All SA% Tables without reference to validation tables or other products.
Path : BANNER DEV/Student/Admissions/Admissions All SA% Tables.

List of Objects

Object Name	Object Type	Layer Name
SABAUDF	TABLE	Table_Layer_3
SABBTCH	TABLE	Table_Layer_3
SABECRL	TABLE	Table_Layer_3
SABECTM	TABLE	Table_Layer_3
SABIDEN	TABLE	Table_Layer_1
SABNSTU	TABLE	Table_Layer_1
SABSTUD	TABLE	Table_Layer_1
SABSUPL	TABLE	Table_Layer_2
SABVWID	TABLE	Table_Layer_2
SABXMIT	TABLE	Table_Layer_3
SARAATT	TABLE	Table_Layer_3
SARACMT	TABLE	Table_Layer_3
SARACTV	TABLE	Table_Layer_3
SARADAP	TABLE	Table_Layer_2
SARADDR	TABLE	Table_Layer_1
SARADHS	TABLE	Table_Layer_2
SARADRT	TABLE	Table_Layer_2
SARADTS	TABLE	Table_Layer_2
SARAMCC	TABLE	Table_Layer_3
SARAPPD	TABLE	Table_Layer_2
SARASTA	TABLE	Table_Layer_3
SARCHKB	TABLE	Table_Layer_3
SARCHKL	TABLE	Table_Layer_2
SARCHRT	TABLE	Table_Layer_2
SARCTRL	TABLE	Table_Layer_3
SARDCSN	TABLE	Table_Layer_2
SARDFOS	TABLE	Table_Layer_1
SARDNTE	TABLE	Table_Layer_3
SARDSCL	TABLE	Table_Layer_2
SAREFOS	TABLE	Table_Layer_2
SAREMPL	TABLE	Table_Layer_1
SARERUL	TABLE	Table_Layer_3
SARETRY	TABLE	Table_Layer_2
SAREVAL	TABLE	Table_Layer_3
SARHCRS	TABLE	Table_Layer_2
SARHEAD	TABLE	Table_Layer_1
SARHLTH	TABLE	Table_Layer_1
SARHSCH	TABLE	Table_Layer_2
SARHSES	TABLE	Table_Layer_2
SARHSUM	TABLE	Table_Layer_2
SARIMMZ	TABLE	Table_Layer_3
SARLANG	TABLE	Table_Layer_3
SARLCOM	TABLE	Table_Layer_3
SARLMSG	TABLE	Table_Layer_3
SARLREC	TABLE	Table_Layer_3
SARLXMS	TABLE	Table_Layer_3
SARLXNO	TABLE	Table_Layer_3
SARMATL	TABLE	Table_Layer_3
SARMONY	TABLE	Table_Layer_3
SARORTN	TABLE	Table_Layer_3
SARPCOL	TABLE	Table_Layer_1
SARPCRS	TABLE	Table_Layer_3
SARPDEG	TABLE	Table_Layer_1
SARPERR	TABLE	Table_Layer_3
SARPERS	TABLE	Table_Layer_1
SARPHON	TABLE	Table_Layer_1
SARPRFN	TABLE	Table_Layer_1
SARPRTN	TABLE	Table_Layer_3
SARPSES	TABLE	Table_Layer_1
SARPSTA	TABLE	Table_Layer_3
SARQKER	TABLE	Table_Layer_3
SARQUAN	TABLE	Table_Layer_2
SARRESD	TABLE	Table_Layer_3
SARRFNO	TABLE	Table_Layer_3
SARRLGN	TABLE	Table_Layer_1
SARRLST	TABLE	Table_Layer_3
SARRQST	TABLE	Table_Layer_1
SARRRAT	TABLE	Table_Layer_3
SARRRCT	TABLE	Table_Layer_3
SARRRDF	TABLE	Table_Layer_3
SARRRFT	TABLE	Table_Layer_3
SARRRRT	TABLE	Table_Layer_3
SARRSRC	TABLE	Table_Layer_2
SARTERM	TABLE	Table_Layer_3
SARTEST	TABLE	Table_Layer_3
SARWAAD	TABLE	Table_Layer_3
SARWADF	TABLE	Table_Layer_1
SARWADP	TABLE	Table_Layer_1
SARWALT	TABLE	Table_Layer_1
SARWAPC	TABLE	Table_Layer_1
SARWAPF	TABLE	Table_Layer_1
SARWAPP	TABLE	Table_Layer_1
SARWATD	TABLE	Table_Layer_3
SARWATR	TABLE	Table_Layer_3
SARWSCT	TABLE	Table_Layer_3
SARWUDQ	TABLE	Table_Layer_1
SATAHLD	TABLE	Table_Layer_3
SATAMAL	TABLE	Table_Layer_3
SATARPT	TABLE	Table_Layer_3

Comments

Model View

Table SABAUDF

Schema Name SATURN
Label SABAUDF
Server name MALDEV8_B60
Creation Date 04/15/2002 18:11:41:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SABAUDF_TERM_CODE_EFF	SABAUDF_TERM_CODE_EFF	VARCHAR2(6)	No	*	*
SABAUDF_FLAG1_DESC	SABAUDF_FLAG1_DESC	VARCHAR2(20)	Yes
SABAUDF_FLAG2_DESC	SABAUDF_FLAG2_DESC	VARCHAR2(20)	Yes
SABAUDF_FLAG3_DESC	SABAUDF_FLAG3_DESC	VARCHAR2(20)	Yes
SABAUDF_FLAG4_DESC	SABAUDF_FLAG4_DESC	VARCHAR2(20)	Yes
SABAUDF_FLAG5_DESC	SABAUDF_FLAG5_DESC	VARCHAR2(20)	Yes
SABAUDF_FLAG6_DESC	SABAUDF_FLAG6_DESC	VARCHAR2(20)	Yes
SABAUDF_FLAG7_DESC	SABAUDF_FLAG7_DESC	VARCHAR2(20)	Yes
SABAUDF_FLAG8_DESC	SABAUDF_FLAG8_DESC	VARCHAR2(20)	Yes
SABAUDF_FLAG9_DESC	SABAUDF_FLAG9_DESC	VARCHAR2(20)	Yes
SABAUDF_FLAG10_DESC	SABAUDF_FLAG10_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA1_DESC	SABAUDF_DATA1_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA2_DESC	SABAUDF_DATA2_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA3_DESC	SABAUDF_DATA3_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA4_DESC	SABAUDF_DATA4_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA5_DESC	SABAUDF_DATA5_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA6_DESC	SABAUDF_DATA6_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA7_DESC	SABAUDF_DATA7_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA8_DESC	SABAUDF_DATA8_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA9_DESC	SABAUDF_DATA9_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA10_DESC	SABAUDF_DATA10_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA11_DESC	SABAUDF_DATA11_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA12_DESC	SABAUDF_DATA12_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA13_DESC	SABAUDF_DATA13_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA14_DESC	SABAUDF_DATA14_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA15_DESC	SABAUDF_DATA15_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA16_DESC	SABAUDF_DATA16_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA17_DESC	SABAUDF_DATA17_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA18_DESC	SABAUDF_DATA18_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA19_DESC	SABAUDF_DATA19_DESC	VARCHAR2(20)	Yes
SABAUDF_DATA20_DESC	SABAUDF_DATA20_DESC	VARCHAR2(20)	Yes
SABAUDF_ACTIVITY_DATE	SABAUDF_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SABAUDF_TERM_CODE_EFF	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_SABAUDF	Unique	SABAUDF_TERM_CODE_EFF

Comments

Source Code Comments

Application User Defined Fields Table

Columns Comments for SABAUDF_TERM_CODE_EFF (1)

Source Code Comments

This is the effective term.

Columns Comments for SABAUDF_ACTIVITY_DATE (32)

Source Code Comments

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

Table SABBTCH

Schema Name SATURN
Label SABBTCH
Server name MALDEV8_B60
Creation Date 04/15/2002 18:11:41:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SABBTCH_PIDM	SABBTCH_PIDM	NUMBER(8,0)	No	*
SABBTCH_TERM_CODE	SABBTCH_TERM_CODE	VARCHAR2(6)	No	*	*
SABBTCH_APPL_NO	SABBTCH_APPL_NO	NUMBER(4,0)	No	*
SABBTCH_JOB_NAME	SABBTCH_JOB_NAME	VARCHAR2(7)	No	*
SABBTCH_ACTIVITY_DATE	SABBTCH_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SABBTCH_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_SABBTCH	Unique	SABBTCH_PIDM
PK_SABBTCH	Unique	SABBTCH_TERM_CODE
PK_SABBTCH	Unique	SABBTCH_APPL_NO
PK_SABBTCH	Unique	SABBTCH_JOB_NAME

Comments

Source Code Comments

Admission Report Id Selection Table

Columns Comments for SABBTCH_PIDM (1)

Source Code Comments

Internal identification number of student.

Columns Comments for SABBTCH_TERM_CODE (2)

Source Code Comments

This field identifies the term for which information is to be generated.

Columns Comments for SABBTCH_APPL_NO (3)

Source Code Comments

This field identifies the application number associated with the student record.

Columns Comments for SABBTCH_JOB_NAME (4)

Source Code Comments

This field identifies the name of the job to be generated.

Columns Comments for SABBTCH_ACTIVITY_DATE (5)

Source Code Comments

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

Table SABECRL

Schema Name SATURN
Label SABECRL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:11:41:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
SABECRL_WAPP_CODE	SABECRL_WAPP_CODE	VARCHAR2(2)	No	*
SABECRL_PROC_LABEL	SABECRL_PROC_LABEL	VARCHAR2(5)	No	*
SABECRL_PROC_LABEL_DESC	SABECRL_PROC_LABEL_DESC	VARCHAR2(30)	No
SABECRL_REQUIRED_IND	SABECRL_REQUIRED_IND	VARCHAR2(1)	No
SABECRL_OVERRIDE_IND	SABECRL_OVERRIDE_IND	VARCHAR2(1)	No
SABECRL_SYSTEM_REQ_IND	SABECRL_SYSTEM_REQ_IND	VARCHAR2(1)	No
SABECRL_ACTIVITY_DATE	SABECRL_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_SABECRL	Unique	SABECRL_WAPP_CODE
PK_SABECRL	Unique	SABECRL_PROC_LABEL

Comments

Source Code Comments

Electronic Admissions Control Table

Columns Comments for SABECRL_WAPP_CODE (1)

Source Code Comments

Web Application Code

Columns Comments for SABECRL_PROC_LABEL (2)

Source Code Comments

Procedure Label

Columns Comments for SABECRL_PROC_LABEL_DESC (3)

Source Code Comments

Procedure Label Description

Columns Comments for SABECRL_REQUIRED_IND (4)

Source Code Comments

Procedure Required Indicator

Columns Comments for SABECRL_OVERRIDE_IND (5)

Source Code Comments

Procedure Over-Ride Indicator

Columns Comments for SABECRL_SYSTEM_REQ_IND (6)

Source Code Comments

System Requirement Indicator

Columns Comments for SABECRL_ACTIVITY_DATE (7)

Source Code Comments

Date of Insert or Last Update

Table SABECTM

Schema Name SATURN
Label SABECTM
Server name MALDEV8_B60
Creation Date 04/15/2002 18:11:41:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
SABECTM_START_DATE	SABECTM_START_DATE	DATE	No	*
SABECTM_END_DATE	SABECTM_END_DATE	DATE	No
SABECTM_TERM_CODE	SABECTM_TERM_CODE	VARCHAR2(6)	No
SABECTM_ACTIVITY_DATE	SABECTM_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_SABECTM	Unique	SABECTM_START_DATE

Comments

Source Code Comments

EDI Cross-Reference Term Code Rules

Columns Comments for SABECTM_START_DATE (1)

Source Code Comments

Starting Date of Date Range for associated Term

Columns Comments for SABECTM_END_DATE (2)

Source Code Comments

End Date of Date Range for associated Term

Columns Comments for SABECTM_TERM_CODE (3)

Source Code Comments

Term associated with the Date Range

Columns Comments for SABECTM_ACTIVITY_DATE (4)

Source Code Comments

Date of Insert or Last Update

Table SABIDEN

Schema Name SATURN
Label SABIDEN
Server name MALDEV8_B60
Creation Date 04/15/2002 18:11:41:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SABIDEN_AIDM	SABIDEN_AIDM	NUMBER(8,0)	No	*	*
SABIDEN_PIDM	SABIDEN_PIDM	NUMBER(8,0)	No
SABIDEN_SRCE_IND	SABIDEN_SRCE_IND	VARCHAR2(1)	No
SABIDEN_ACTIVITY_DATE	SABIDEN_ACTIVITY_DATE	DATE	No
SABIDEN_ID_EDI	SABIDEN_ID_EDI	VARCHAR2(9)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SABIDEN_AIDM	SARHEAD_AIDM	SARHEAD

Index

Index Name	Index Type	Column Name
PK_SABIDEN	Unique	SABIDEN_AIDM

Comments

Source Code Comments

Person ID Control Table

Columns Comments for SABIDEN_AIDM (1)

Source Code Comments

Person Reference Number

Columns Comments for SABIDEN_PIDM (2)

Source Code Comments

Person PIDM Reference

Columns Comments for SABIDEN_SRCE_IND (3)

Source Code Comments

Source of Record

Columns Comments for SABIDEN_ACTIVITY_DATE (4)

Source Code Comments

Date of Insert or Last Update

Columns Comments for SABIDEN_ID_EDI (5)

Source Code Comments

EDI ID

Table SABNSTU

Schema Name SATURN
Label SABNSTU
Server name MALDEV8_B60
Creation Date 04/15/2002 18:11:41:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SABNSTU_ID	SABNSTU_ID	VARCHAR2(9)	No	*
SABNSTU_AIDM	SABNSTU_AIDM	NUMBER(8,0)	No		*
SABNSTU_AIDM	SABNSTU_AIDM	NUMBER(8,0)	No		*
SABNSTU_LOCKED_IND	SABNSTU_LOCKED_IND	VARCHAR2(1)	No
SABNSTU_ACTIVITY_DATE	SABNSTU_ACTIVITY_DATE	DATE	No
SABNSTU_XMIT_SEQNO	SABNSTU_XMIT_SEQNO	NUMBER(8,0)	Yes
SABNSTU_PIN	SABNSTU_PIN	VARCHAR2(6)	Yes
SABNSTU_APPID	SABNSTU_APPID	VARCHAR2(6)	Yes
SABNSTU_WEB_LAST_ACCESS	SABNSTU_WEB_LAST_ACCESS	DATE	Yes
SABNSTU_LAST_LOGIN_DATE	SABNSTU_LAST_LOGIN_DATE	DATE	Yes
SABNSTU_LOGIN_ATTEMPTS	SABNSTU_LOGIN_ATTEMPTS	NUMBER(2,0)	Yes
SABNSTU_PREV_APPID	SABNSTU_PREV_APPID	VARCHAR2(6)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SABNSTU_AIDM	SARPERS_AIDM	SARPERS
SABNSTU_AIDM	SARHEAD_AIDM	SARHEAD

Index

Index Name	Index Type	Column Name
PK_SABNSTU	Unique	SABNSTU_ID
SABNSTU_KEY_INDEX	Unique	SABNSTU_AIDM

Comments

Source Code Comments

Electronic Admissions Non-Student Table

Columns Comments for SABNSTU_ID (1)

Source Code Comments

ID NUmber

Columns Comments for SABNSTU_AIDM (2)

Source Code Comments

Person Reference Number

Columns Comments for SABNSTU_LOCKED_IND (3)

Source Code Comments

Web Access Lock Indicator

Columns Comments for SABNSTU_ACTIVITY_DATE (4)

Source Code Comments

Date of Insert or Last Update

Columns Comments for SABNSTU_XMIT_SEQNO (5)

Source Code Comments

EDI Transmission Packet Reference

Columns Comments for SABNSTU_PIN (6)

Source Code Comments

Individuals Selected PIN Number

Columns Comments for SABNSTU_APPID (7)

Source Code Comments

WWW Update Control String

Columns Comments for SABNSTU_WEB_LAST_ACCESS (8)

Source Code Comments

Date and Time of Last Web Access

Columns Comments for SABNSTU_LAST_LOGIN_DATE (9)

Source Code Comments

Last Date and Time of Web Login

Columns Comments for SABNSTU_LOGIN_ATTEMPTS (10)

Source Code Comments

Number of Web Login Attempts

Columns Comments for SABNSTU_PREV_APPID (11)

Source Code Comments

Previous Application ID

Table SABSTUD

Schema Name SATURN
Label SABSTUD
Server name MALDEV8_B60
Creation Date 04/15/2002 18:11:41:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SABSTUD_PIDM	SABSTUD_PIDM	NUMBER(8,0)	No	*
SABSTUD_AIDM	SABSTUD_AIDM	NUMBER(8,0)	No		*
SABSTUD_ACTIVITY_DATE	SABSTUD_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SABSTUD_AIDM	SARHEAD_AIDM	SARHEAD

Index

Index Name	Index Type	Column Name
PK_SABSTUD	Unique	SABSTUD_PIDM
SABSTUD_KEY_INDEX	Unique	SABSTUD_AIDM

Comments

Source Code Comments

Electronic Admissions Student Record Table

Columns Comments for SABSTUD_PIDM (1)

Source Code Comments

Student PIDM Reference

Columns Comments for SABSTUD_AIDM (2)

Source Code Comments

Person Reference Number

Columns Comments for SABSTUD_ACTIVITY_DATE (3)

Source Code Comments

Date of Insert or Last Update

Table SABSUPL

Schema Name SATURN
Label SABSUPL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:11:41:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SABSUPL_PIDM	SABSUPL_PIDM	NUMBER(8,0)	No	*
SABSUPL_TERM_CODE_ENTRY	SABSUPL_TERM_CODE_ENTRY	VARCHAR2(6)	No	*
SABSUPL_APPL_NO	SABSUPL_APPL_NO	NUMBER(2,0)	No	*
SABSUPL_CNTY_CODE_ADMIT	SABSUPL_CNTY_CODE_ADMIT	VARCHAR2(5)	Yes	*
SABSUPL_CNTY_ADMIT_RURAL	SABSUPL_CNTY_ADMIT_RURAL	VARCHAR2(1)	Yes
SABSUPL_STAT_CODE_ADMIT	SABSUPL_STAT_CODE_ADMIT	VARCHAR2(3)	Yes	*
SABSUPL_NATN_CODE_ADMIT	SABSUPL_NATN_CODE_ADMIT	VARCHAR2(5)	Yes	*
SABSUPL_CITY_BIRTH	SABSUPL_CITY_BIRTH	VARCHAR2(20)	Yes
SABSUPL_CNTY_CODE_BIRTH	SABSUPL_CNTY_CODE_BIRTH	VARCHAR2(5)	Yes	*
SABSUPL_CNTY_BIRTH_RURAL	SABSUPL_CNTY_BIRTH_RURAL	VARCHAR2(1)	Yes
SABSUPL_STAT_CODE_BIRTH	SABSUPL_STAT_CODE_BIRTH	VARCHAR2(3)	Yes	*
SABSUPL_NATN_CODE_BIRTH	SABSUPL_NATN_CODE_BIRTH	VARCHAR2(5)	Yes	*
SABSUPL_SBGI_CODE_ADMIT	SABSUPL_SBGI_CODE_ADMIT	VARCHAR2(6)	Yes	*
SABSUPL_ETHN_CODE_SELF	SABSUPL_ETHN_CODE_SELF	VARCHAR2(2)	Yes	*
SABSUPL_ESEL_CODE	SABSUPL_ESEL_CODE	VARCHAR2(2)	Yes	*
SABSUPL_NUMBER_DEPS	SABSUPL_NUMBER_DEPS	NUMBER(2,0)	Yes
SABSUPL_AGENCY_FILE_NO	SABSUPL_AGENCY_FILE_NO	VARCHAR2(10)	Yes
SABSUPL_APP_YEAR_AGENCY	SABSUPL_APP_YEAR_AGENCY	NUMBER(4,0)	Yes
SABSUPL_PREV_APP_1	SABSUPL_PREV_APP_1	NUMBER(4,0)	Yes
SABSUPL_PREV_APP_2	SABSUPL_PREV_APP_2	NUMBER(4,0)	Yes
SABSUPL_PREV_APP_3	SABSUPL_PREV_APP_3	NUMBER(4,0)	Yes
SABSUPL_PREV_APP_4	SABSUPL_PREV_APP_4	NUMBER(4,0)	Yes
SABSUPL_AGENCY_FEE_WAIVED	SABSUPL_AGENCY_FEE_WAIVED	VARCHAR2(1)	Yes
SABSUPL_CYCLE_ADDED	SABSUPL_CYCLE_ADDED	NUMBER(3,0)	Yes
SABSUPL_CYCLE_CHANGED	SABSUPL_CYCLE_CHANGED	NUMBER(3,0)	Yes
SABSUPL_AGENCY_REPORT_DATE	SABSUPL_AGENCY_REPORT_DATE	DATE	Yes
SABSUPL_FLAG1	SABSUPL_FLAG1	VARCHAR2(1)	Yes
SABSUPL_FLAG2	SABSUPL_FLAG2	VARCHAR2(1)	Yes
SABSUPL_FLAG3	SABSUPL_FLAG3	VARCHAR2(1)	Yes
SABSUPL_FLAG4	SABSUPL_FLAG4	VARCHAR2(1)	Yes
SABSUPL_FLAG5	SABSUPL_FLAG5	VARCHAR2(1)	Yes
SABSUPL_FLAG6	SABSUPL_FLAG6	VARCHAR2(1)	Yes
SABSUPL_FLAG7	SABSUPL_FLAG7	VARCHAR2(1)	Yes
SABSUPL_FLAG8	SABSUPL_FLAG8	VARCHAR2(1)	Yes
SABSUPL_FLAG9	SABSUPL_FLAG9	VARCHAR2(1)	Yes
SABSUPL_FLAG10	SABSUPL_FLAG10	VARCHAR2(1)	Yes
SABSUPL_INST_DATA1	SABSUPL_INST_DATA1	VARCHAR2(60)	Yes
SABSUPL_INST_DATA2	SABSUPL_INST_DATA2	VARCHAR2(60)	Yes
SABSUPL_INST_DATA3	SABSUPL_INST_DATA3	VARCHAR2(60)	Yes
SABSUPL_INST_DATA4	SABSUPL_INST_DATA4	VARCHAR2(60)	Yes
SABSUPL_INST_DATA5	SABSUPL_INST_DATA5	VARCHAR2(60)	Yes
SABSUPL_INST_DATA6	SABSUPL_INST_DATA6	VARCHAR2(60)	Yes
SABSUPL_INST_DATA7	SABSUPL_INST_DATA7	VARCHAR2(60)	Yes
SABSUPL_INST_DATA8	SABSUPL_INST_DATA8	VARCHAR2(60)	Yes
SABSUPL_INST_DATA9	SABSUPL_INST_DATA9	VARCHAR2(60)	Yes
SABSUPL_INST_DATA10	SABSUPL_INST_DATA10	VARCHAR2(60)	Yes
SABSUPL_INST_DATA11	SABSUPL_INST_DATA11	VARCHAR2(60)	Yes
SABSUPL_INST_DATA12	SABSUPL_INST_DATA12	VARCHAR2(60)	Yes
SABSUPL_INST_DATA13	SABSUPL_INST_DATA13	VARCHAR2(60)	Yes
SABSUPL_INST_DATA14	SABSUPL_INST_DATA14	VARCHAR2(60)	Yes
SABSUPL_INST_DATA15	SABSUPL_INST_DATA15	VARCHAR2(60)	Yes
SABSUPL_INST_DATA16	SABSUPL_INST_DATA16	VARCHAR2(60)	Yes
SABSUPL_INST_DATA17	SABSUPL_INST_DATA17	VARCHAR2(60)	Yes
SABSUPL_INST_DATA18	SABSUPL_INST_DATA18	VARCHAR2(60)	Yes
SABSUPL_INST_DATA19	SABSUPL_INST_DATA19	VARCHAR2(60)	Yes
SABSUPL_INST_DATA20	SABSUPL_INST_DATA20	VARCHAR2(60)	Yes
SABSUPL_ACTIVITY_DATE	SABSUPL_ACTIVITY_DATE	DATE	Yes
SABSUPL_EFFEC_DATE	SABSUPL_EFFEC_DATE	DATE	Yes
SABSUPL_APPL_TYPE	SABSUPL_APPL_TYPE	VARCHAR2(1)	Yes
SABSUPL_BIO_NUMBER	SABSUPL_BIO_NUMBER	VARCHAR2(22)	Yes
SABSUPL_HISP_IND	SABSUPL_HISP_IND	VARCHAR2(1)	Yes
SABSUPL_URM_IND	SABSUPL_URM_IND	VARCHAR2(1)	Yes
SABSUPL_RACE1	SABSUPL_RACE1	VARCHAR2(2)	Yes
SABSUPL_RACE2	SABSUPL_RACE2	VARCHAR2(2)	Yes
SABSUPL_RACE3	SABSUPL_RACE3	VARCHAR2(2)	Yes
SABSUPL_RACE4	SABSUPL_RACE4	VARCHAR2(2)	Yes
SABSUPL_RACE5	SABSUPL_RACE5	VARCHAR2(2)	Yes
SABSUPL_RACE6	SABSUPL_RACE6	VARCHAR2(2)	Yes
SABSUPL_RACE7	SABSUPL_RACE7	VARCHAR2(2)	Yes
SABSUPL_RACE8	SABSUPL_RACE8	VARCHAR2(2)	Yes
SABSUPL_RACE9	SABSUPL_RACE9	VARCHAR2(2)	Yes
SABSUPL_RACE10	SABSUPL_RACE10	VARCHAR2(2)	Yes
SABSUPL_ETHNIC1	SABSUPL_ETHNIC1	VARCHAR2(2)	Yes
SABSUPL_ETHNIC2	SABSUPL_ETHNIC2	VARCHAR2(2)	Yes
SABSUPL_ETHNIC3	SABSUPL_ETHNIC3	VARCHAR2(2)	Yes
SABSUPL_ETHNIC4	SABSUPL_ETHNIC4	VARCHAR2(2)	Yes
SABSUPL_ETHNIC5	SABSUPL_ETHNIC5	VARCHAR2(2)	Yes
SABSUPL_ETHNIC6	SABSUPL_ETHNIC6	VARCHAR2(2)	Yes
SABSUPL_ETHNIC7	SABSUPL_ETHNIC7	VARCHAR2(2)	Yes
SABSUPL_ETHNIC8	SABSUPL_ETHNIC8	VARCHAR2(2)	Yes
SABSUPL_ETHNIC9	SABSUPL_ETHNIC9	VARCHAR2(2)	Yes
SABSUPL_ETHNIC10	SABSUPL_ETHNIC10	VARCHAR2(2)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SABSUPL_ESEL_CODE	STVESEL_CODE	STVESEL
SABSUPL_TERM_CODE_ENTRY	STVTERM_CODE	STVTERM
SABSUPL_ETHN_CODE_SELF	STVETHN_CODE	STVETHN
SABSUPL_SBGI_CODE_ADMIT	STVSBGI_CODE	STVSBGI
SABSUPL_PIDM	SARADAP_PIDM	SARADAP
SABSUPL_APPL_NO	SARADAP_APPL_NO	SARADAP

Index

Index Name	Index Type	Column Name
SABSUPL_KEY_INDEX	Unique	SABSUPL_PIDM
SABSUPL_KEY_INDEX	Unique	SABSUPL_TERM_CODE_ENTRY
SABSUPL_KEY_INDEX	Unique	SABSUPL_APPL_NO

Comments

Source Code Comments

Application Supplemental Information Base Table

Columns Comments for SABSUPL_EFFEC_DATE (58)

Source Code Comments

Date when the application data was last updated by AMCAS.

Columns Comments for SABSUPL_APPL_TYPE (59)

Source Code Comments

AMCAS application type code.

Columns Comments for SABSUPL_BIO_NUMBER (60)

Source Code Comments

Bio number assigned by AMCAS.

Columns Comments for SABSUPL_HISP_IND (61)

Source Code Comments

AMCAS Hispanic ethnicity indicator.

Columns Comments for SABSUPL_URM_IND (62)

Source Code Comments

AMCAS Under-represented Minority indicator.

Columns Comments for SABSUPL_RACE1 (63)

Source Code Comments

Race code reported by AMCAS.

Columns Comments for SABSUPL_RACE2 (64)

Source Code Comments

Race code reported by AMCAS.

Columns Comments for SABSUPL_RACE3 (65)

Source Code Comments

Race code reported by AMCAS.

Columns Comments for SABSUPL_RACE4 (66)

Source Code Comments

Race code reported by AMCAS.

Columns Comments for SABSUPL_RACE5 (67)

Source Code Comments

Race code reported by AMCAS.

Columns Comments for SABSUPL_RACE6 (68)

Source Code Comments

Race code reported by AMCAS.

Columns Comments for SABSUPL_RACE7 (69)

Source Code Comments

Race code reported by AMCAS.

Columns Comments for SABSUPL_RACE8 (70)

Source Code Comments

Race code reported by AMCAS.

Columns Comments for SABSUPL_RACE9 (71)

Source Code Comments

Race code reported by AMCAS.

Columns Comments for SABSUPL_RACE10 (72)