GOBINTL GTVSDAX SABSUPL SABVWID SARADAP SARADHS SARADRT SARADTS SARAPPD SARCHKL SARCHRT SARDCSN SARDSCL SAREFOS SARETRY SARHCRS SARHSCH SARHSES SARHSUM SARQUAN SARRSRC SORCMJR SORMAPD SORMSRC SORXREF SPBPERS STVADMR STVADMT STVAPDC STVCHRT STVCITZ STVDPLM STVESEL STVETHN STVLEVL STVRATP STVRESD STVSBGI STVSBJC STVSESS STVSTYP STVTADM STVTESC

Model Admissions Group #2


Model Label : ERD For Portions of Banner Student Admissions Module.
Path : BANNER DEV/Student/Admissions/Admissions Group #2

List of Objects

Object Name Object Type Layer Name
GOBINTL TABLE Links_2
GTVSDAX TABLE Links_2
SABSUPL TABLE Table_Layer_2
SABVWID TABLE Table_Layer_2
SARADAP TABLE Table_Layer_2
SARADHS TABLE Table_Layer_2
SARADRT TABLE Table_Layer_2
SARADTS TABLE Table_Layer_2
SARAPPD TABLE Table_Layer_2
SARCHKL TABLE Table_Layer_2
SARCHRT TABLE Table_Layer_2
SARDCSN TABLE Table_Layer_2
SARDSCL TABLE Table_Layer_2
SAREFOS TABLE Table_Layer_2
SARETRY TABLE Table_Layer_2
SARHCRS TABLE Table_Layer_2
SARHSCH TABLE Table_Layer_2
SARHSES TABLE Table_Layer_2
SARHSUM TABLE Table_Layer_2
SARQUAN TABLE Table_Layer_2
SARRSRC TABLE Table_Layer_2
SORCMJR TABLE Links_1
SORMAPD TABLE Links_2
SORMSRC TABLE Links_2
SORXREF TABLE Links_2
SPBPERS TABLE Links_2
STVADMR TABLE Links_1
STVADMT TABLE Links_2
STVAPDC TABLE Links_1
STVCHRT TABLE Links_2
STVCITZ TABLE Links_2
STVDPLM TABLE Links_2
STVESEL TABLE Links_2
STVETHN TABLE Links_2
STVLEVL TABLE Links_2
STVRATP TABLE Links_2
STVRESD TABLE Links_2
STVSBGI TABLE Links_1
STVSBJC TABLE Links_2
STVSESS TABLE Links_2
STVSTYP TABLE Links_2
STVTADM TABLE Links_2
STVTESC TABLE Links_2

Comments

Model View

''

Table GOBINTL

Schema Name GENERAL
Label GOBINTL
Server name MALDEV8_B60
Creation Date 06/11/2003 11:13:13:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GOBINTL_PIDM GOBINTL_PIDM NUMBER(8,0) No * *
GOBINTL_PIDM GOBINTL_PIDM NUMBER(8,0) No * *
GOBINTL_SPOUSE_IND GOBINTL_SPOUSE_IND VARCHAR2(1) No
GOBINTL_SIGNATURE_IND GOBINTL_SIGNATURE_IND VARCHAR2(1) No
GOBINTL_USER_ID GOBINTL_USER_ID VARCHAR2(30) No
GOBINTL_ACTIVITY_DATE GOBINTL_ACTIVITY_DATE DATE No
GOBINTL_PASSPORT_ID GOBINTL_PASSPORT_ID VARCHAR2(15) Yes
GOBINTL_NATN_CODE_ISSUE GOBINTL_NATN_CODE_ISSUE VARCHAR2(5) Yes *
GOBINTL_PASSPORT_EXP_DATE GOBINTL_PASSPORT_EXP_DATE DATE Yes
GOBINTL_I94_STATUS GOBINTL_I94_STATUS VARCHAR2(3) Yes
GOBINTL_I94_DATE GOBINTL_I94_DATE DATE Yes
GOBINTL_REG_NUMBER GOBINTL_REG_NUMBER VARCHAR2(11) Yes
GOBINTL_DURATION GOBINTL_DURATION VARCHAR2(1) Yes
GOBINTL_CELG_CODE GOBINTL_CELG_CODE VARCHAR2(6) Yes *
GOBINTL_CERT_NUMBER GOBINTL_CERT_NUMBER VARCHAR2(11) Yes
GOBINTL_CERT_DATE_ISSUE GOBINTL_CERT_DATE_ISSUE DATE Yes
GOBINTL_CERT_DATE_RECEIPT GOBINTL_CERT_DATE_RECEIPT DATE Yes
GOBINTL_ADMR_CODE GOBINTL_ADMR_CODE VARCHAR2(4) Yes *
GOBINTL_ADMR_CODE GOBINTL_ADMR_CODE VARCHAR2(4) Yes *
GOBINTL_NATN_CODE_BIRTH GOBINTL_NATN_CODE_BIRTH VARCHAR2(5) Yes *
GOBINTL_NATN_CODE_LEGAL GOBINTL_NATN_CODE_LEGAL VARCHAR2(5) Yes *
GOBINTL_LANG_CODE GOBINTL_LANG_CODE VARCHAR2(3) Yes *
GOBINTL_SPON_CODE GOBINTL_SPON_CODE VARCHAR2(3) Yes *
GOBINTL_EMPT_CODE GOBINTL_EMPT_CODE VARCHAR2(3) Yes *
GOBINTL_FOREIGN_SSN GOBINTL_FOREIGN_SSN VARCHAR2(9) Yes
GOBINTL_CHILD_NUMBER GOBINTL_CHILD_NUMBER NUMBER(2,0) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
GOBINTL_CELG_CODE GTVCELG_CODE GTVCELG
GOBINTL_PIDM GORVISA_PIDM GORVISA
GOBINTL_ADMR_CODE SARCHKL_ADMR_CODE SARCHKL
GOBINTL_PIDM SARCHKL_PIDM SARCHKL
GOBINTL_ADMR_CODE STVADMR_CODE STVADMR
GOBINTL_EMPT_CODE STVEMPT_CODE STVEMPT
GOBINTL_LANG_CODE STVLANG_CODE STVLANG
GOBINTL_SPON_CODE STVSPON_CODE STVSPON

Index

Index Name Index Type Column Name
PK_GOBINTL Unique GOBINTL_PIDM

Comments

Source Code Comments

Visa International Information Table

Columns Comments for GOBINTL_PIDM (1)

Source Code Comments

PERSONAL ID NUMBER: This field indicates Personal Identification Number.

Columns Comments for GOBINTL_SPOUSE_IND (2)

Source Code Comments

SPOUSE INDICATOR: This field indicates whether the Spouse Accompanied the person to the Country.

Columns Comments for GOBINTL_SIGNATURE_IND (3)

Source Code Comments

SIGNATURE INDICATOR: This field indicates Signature Available for Funds.

Columns Comments for GOBINTL_USER_ID (4)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user who changed the record.

Columns Comments for GOBINTL_ACTIVITY_DATE (5)

Source Code Comments

ACTIVITY DATE: The date that the information for the row was inserted or updated in the GOBINTL table.

Columns Comments for GOBINTL_PASSPORT_ID (6)

Source Code Comments

PASSPORT NUMBER: This field indicates Passport Identification Number.

Columns Comments for GOBINTL_NATN_CODE_ISSUE (7)

Source Code Comments

ISSUING NATION CODE: This field indicates the Country Code of the nation issuing the passport.

Columns Comments for GOBINTL_PASSPORT_EXP_DATE (8)

Source Code Comments

PASSPORT EXPIRATION DATE: This field indicates the date the passport expires.

Columns Comments for GOBINTL_I94_STATUS (9)

Source Code Comments

I94 STATUS: This field indicates whether the passport status is for Admission or Departure.

Columns Comments for GOBINTL_I94_DATE (10)

Source Code Comments

I94 EXPIRATION DATE: This field indicates the date the Admission or Departure expires.

Columns Comments for GOBINTL_REG_NUMBER (11)

Source Code Comments

REGISTRATION NUMBER: This field indicates a unique Passport Registration Number.

Columns Comments for GOBINTL_DURATION (12)

Source Code Comments

DURATION: This field indicates whether the Admission or Departure is for the Duration of the Stay.

Columns Comments for GOBINTL_CELG_CODE (13)

Source Code Comments

CERTIFICATION CODE: This field indicates Passport Certification Eligibility Code.

Columns Comments for GOBINTL_CERT_NUMBER (14)

Source Code Comments

CERTIFICATION NUMBER: This field indicates the Passport Certification Number.

Columns Comments for GOBINTL_CERT_DATE_ISSUE (15)

Source Code Comments

CERTIFICATION ISSUE DATE: This field indicates the date the Passport Certification was issued.

Columns Comments for GOBINTL_CERT_DATE_RECEIPT (16)

Source Code Comments

CERTIFICATION RECEIPT DATE: This field indicates the date the Passport Certification was received.

Columns Comments for GOBINTL_ADMR_CODE (17)

Source Code Comments

ADMISSION REQUEST CODE: This field indicates Admission Request Code.

Columns Comments for GOBINTL_NATN_CODE_BIRTH (18)

Source Code Comments

BIRTH NATION CODE: This field indicates the Country Code of the nation of the person's Birth.

Columns Comments for GOBINTL_NATN_CODE_LEGAL (19)

Source Code Comments

LEGAL NATION CODE: This field indicates the Country Code of the nation of the person's Citizenship.

Columns Comments for GOBINTL_LANG_CODE (20)

Source Code Comments

LANGUAGE CODE: This field indicates the person's native Language Code.

Columns Comments for GOBINTL_SPON_CODE (21)

Source Code Comments

SPONSOR CODE: This field indicates the Sponsor Code.

Columns Comments for GOBINTL_EMPT_CODE (22)

Source Code Comments

EMPLOYMENT TYPE CODE: This field indicates the person's type of Employment.

Columns Comments for GOBINTL_FOREIGN_SSN (23)

Source Code Comments

FOREIGN TAX ID: This field indicates a unique identification number for tax purposes: such as SSN.

Columns Comments for GOBINTL_CHILD_NUMBER (24)

Source Code Comments

CHILD NUMBER: This field indicates the Number of Children Accompaning the person to the Country.

Table GTVSDAX

Schema Name GENERAL
Label GTVSDAX
Server name MALDEV8_B60
Creation Date 04/28/2003 16:18:08:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVSDAX_EXTERNAL_CODE GTVSDAX_EXTERNAL_CODE VARCHAR2(15) No *
GTVSDAX_EXTERNAL_CODE GTVSDAX_EXTERNAL_CODE VARCHAR2(15) No *
GTVSDAX_EXTERNAL_CODE GTVSDAX_EXTERNAL_CODE VARCHAR2(15) No *
GTVSDAX_EXTERNAL_CODE GTVSDAX_EXTERNAL_CODE VARCHAR2(15) No *
GTVSDAX_EXTERNAL_CODE GTVSDAX_EXTERNAL_CODE VARCHAR2(15) No *
GTVSDAX_EXTERNAL_CODE GTVSDAX_EXTERNAL_CODE VARCHAR2(15) No *
GTVSDAX_EXTERNAL_CODE GTVSDAX_EXTERNAL_CODE VARCHAR2(15) No *
GTVSDAX_EXTERNAL_CODE GTVSDAX_EXTERNAL_CODE VARCHAR2(15) No *
GTVSDAX_INTERNAL_CODE GTVSDAX_INTERNAL_CODE VARCHAR2(10) No *
GTVSDAX_INTERNAL_CODE GTVSDAX_INTERNAL_CODE VARCHAR2(10) No *
GTVSDAX_REPORTING_DATE GTVSDAX_REPORTING_DATE DATE Yes
GTVSDAX_TRANSLATION_CODE GTVSDAX_TRANSLATION_CODE VARCHAR2(15) Yes
GTVSDAX_INTERNAL_CODE_SEQNO GTVSDAX_INTERNAL_CODE_SEQNO NUMBER(2,0) Yes
GTVSDAX_INTERNAL_CODE_GROUP GTVSDAX_INTERNAL_CODE_GROUP VARCHAR2(20) No
GTVSDAX_DESC GTVSDAX_DESC VARCHAR2(30) No
GTVSDAX_SYSREQ_IND GTVSDAX_SYSREQ_IND VARCHAR2(1) Yes
GTVSDAX_ACTIVITY_DATE GTVSDAX_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
GTVSDAX_EXTERNAL_CODE SSBSECT_SSTS_CODE SSBSECT
GTVSDAX_INTERNAL_CODE SORPCOL_SBGI_CODE SORPCOL
GTVSDAX_INTERNAL_CODE SPRMEDI_MEDI_CODE SPRMEDI
GTVSDAX_EXTERNAL_CODE PERJTOT_EARN_CODE PERJTOT
GTVSDAX_EXTERNAL_CODE SRBRECR_LEVL_CODE SRBRECR
GTVSDAX_EXTERNAL_CODE SARADAP_LEVL_CODE SARADAP
GTVSDAX_EXTERNAL_CODE SFRRSTS_RSTS_CODE SFRRSTS
GTVSDAX_EXTERNAL_CODE SARAPPD_APDC_CODE SARAPPD
GTVSDAX_EXTERNAL_CODE SORBCHR_BCHR_CODE SORBCHR
GTVSDAX_EXTERNAL_CODE SORTEST_TESC_CODE SORTEST

Index

Index Name Index Type Column Name
GTVSDAX_KEY_INDEX Unique GTVSDAX_INTERNAL_CODE_GROUP
GTVSDAX_KEY_INDEX Unique GTVSDAX_INTERNAL_CODE
GTVSDAX_KEY_INDEX Unique GTVSDAX_EXTERNAL_CODE
GTVSDAX_KEY_INDEX Unique GTVSDAX_INTERNAL_CODE_SEQNO

Comments

Source Code Comments

SDA crosswalk/conversion table

Columns Comments for GTVSDAX_EXTERNAL_CODE (1)

Source Code Comments

Banner/concept code for to be retrieved

Columns Comments for GTVSDAX_INTERNAL_CODE (2)

Source Code Comments

The pre-determined SDA retrieval code

Columns Comments for GTVSDAX_REPORTING_DATE (3)

Source Code Comments

The date column used for various reporting needs

Columns Comments for GTVSDAX_TRANSLATION_CODE (4)

Source Code Comments

The hard-coded translation of the user defined external code, eg. Freshman, PUB for Public School, etc

Columns Comments for GTVSDAX_INTERNAL_CODE_SEQNO (5)

Source Code Comments

The sequence number for internal codes requiring multiple values

Columns Comments for GTVSDAX_INTERNAL_CODE_GROUP (6)

Source Code Comments

The group typing for translated or crosswalked values to specifically identify which grouping each series of codes belongs too

Columns Comments for GTVSDAX_DESC (7)

Source Code Comments

The description of the SDA code/concept

Columns Comments for GTVSDAX_SYSREQ_IND (8)

Source Code Comments

A Y in this field indicates that this row is required for production processing

Columns Comments for GTVSDAX_ACTIVITY_DATE (9)

Source Code Comments

The last activity date for this row of data

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 PK 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)

Source Code Comments

Race code reported by AMCAS.

Columns Comments for SABSUPL_ETHNIC1 (73)

Source Code Comments

Ethnic code reported by AMCAS.

Columns Comments for SABSUPL_ETHNIC2 (74)

Source Code Comments

Ethnic code reported by AMCAS.

Columns Comments for SABSUPL_ETHNIC3 (75)

Source Code Comments

Ethnic code reported by AMCAS.

Columns Comments for SABSUPL_ETHNIC4 (76)

Source Code Comments

Ethnic code reported by AMCAS.

Columns Comments for SABSUPL_ETHNIC5 (77)

Source Code Comments

Ethnic code reported by AMCAS.

Columns Comments for SABSUPL_ETHNIC6 (78)

Source Code Comments

Ethnic code reported by AMCAS.

Columns Comments for SABSUPL_ETHNIC7 (79)

Source Code Comments

Ethnic code reported by AMCAS.

Columns Comments for SABSUPL_ETHNIC8 (80)

Source Code Comments

Ethnic code reported by AMCAS.

Columns Comments for SABSUPL_ETHNIC9 (81)

Source Code Comments

Ethnic code reported by AMCAS.

Columns Comments for SABSUPL_ETHNIC10 (82)

Source Code Comments

Ethnic code reported by AMCAS.

Table SABVWID

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SABVWID_SID SABVWID_SID VARCHAR2(30) No *
SABVWID_PIDM SABVWID_PIDM NUMBER(8,0) No
SABVWID_TERM_CODE SABVWID_TERM_CODE VARCHAR2(6) No *
SABVWID_APPL_NO SABVWID_APPL_NO NUMBER(4,0) No
SABVWID_JOB_NAME SABVWID_JOB_NAME VARCHAR2(7) Yes
SABVWID_ACTIVITY_DATE SABVWID_ACTIVITY_DATE DATE No

Foreign Key information

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

Index

Index Name Index Type Column Name
PK_SABVWID Unique SABVWID_SID

Comments

Source Code Comments

Admission Decision View Selection Table

Columns Comments for SABVWID_SID (1)

Source Code Comments

This field identifies the system assigned unique session identification number.

Columns Comments for SABVWID_PIDM (2)

Source Code Comments

This field identifies the internal student identification number.

Columns Comments for SABVWID_TERM_CODE (3)

Source Code Comments

This field identifies the term code.

Columns Comments for SABVWID_APPL_NO (4)

Source Code Comments

This field identifies the application number.

Columns Comments for SABVWID_ACTIVITY_DATE (6)

Source Code Comments

This field identifies the last date the SABVWID record was updated.

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 *