Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Student Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AS_ADMISSIONS_APPLICATION

Description Source composite view contains information specific to each different application submitted by the applicant.

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ACADEMIC_PERIOD   Academic period or time frame this person applied to study at this institution. VARCHAR2(6)  

SARADAP

SARADAP_TERM_CODE_ENTRY

ACADEMIC_PERIOD_DESC   Academic period description. VARCHAR2(30)  

STVTERM

STVTERM_DESC

ACADEMIC_YEAR   Academic year associated with the academic period on this record. VARCHAR2(4)  

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_YEAR_DESC   Academic year description. VARCHAR2(30)  

FUNCTION

GOKODSF.F_GET_DESC

ADMISSIONS_POPULATION   Identifies an admission population such as early admit, mature, adult and continuing education, etc., associated with the person and application. VARCHAR2(2)  

SARADAP

SARADAP_ADMT_CODE

ADMISSIONS_POPULATION_DESC   Admission population description. VARCHAR2(30)  

STVADMT

STVADMT_DESC

APPLICANT_DECLINED_IND   This indicates whether the applicant has declined offer of admission. VARCHAR2(1)  

NA

NA

APPLICANT_WITHDRAWN_IND   Indicates whether the applicant has informed the institution they no longer wish to attend and withdraw their application. VARCHAR2(1)  

FUNCTION

F_ADMS_APPLICANT_WITHDRAWN

APPLICATION_DATE   Application submission date. DATE  

SARADAP

SARADAP_APPL_DATE

APPLICATION_FEE_RECEIVED_DATE   The date application fee has been assessed. DATE  

SARADAP

SARADAP_FEE_DATE

APPLICATION_FEE_REQUIRED_IND   Inidicates whether an application fee has been assessed. VARCHAR2(1)  

CALCULATION

NVL(SARADAP_FEE_IND,'N')

APPLICATION_IND1 Application Indicator 1   VARCHAR2(1)      
APPLICATION_IND10 Application Indicator 10   VARCHAR2(1)      
APPLICATION_IND2 Application Indicator 2   VARCHAR2(1)      
APPLICATION_IND3 Application Indicator 3   VARCHAR2(1)      
APPLICATION_IND4 Application Indicator 4   VARCHAR2(1)      
APPLICATION_IND5 Application Indicator 5   VARCHAR2(1)      
APPLICATION_IND6 Application Indicator 6   VARCHAR2(1)      
APPLICATION_IND7 Application Indicator 7   VARCHAR2(1)      
APPLICATION_IND8 Application Indicator 8   VARCHAR2(1)      
APPLICATION_IND9 Application Indicator 9   VARCHAR2(1)      
APPLICATION_IND_TYPE1 Application Indicator Type 1   VARCHAR2(20)      
APPLICATION_IND_TYPE10 Application Indicator Type 10   VARCHAR2(20)      
APPLICATION_IND_TYPE2 Application Indicator Type 2   VARCHAR2(20)      
APPLICATION_IND_TYPE3 Application Indicator Type 3   VARCHAR2(20)      
APPLICATION_IND_TYPE4 Application Indicator Type 4   VARCHAR2(20)      
APPLICATION_IND_TYPE5 Application Indicator Type 5   VARCHAR2(20)      
APPLICATION_IND_TYPE6 Application Indicator Type 6   VARCHAR2(20)      
APPLICATION_IND_TYPE7 Application Indicator Type 7   VARCHAR2(20)      
APPLICATION_IND_TYPE8 Application Indicator Type 8   VARCHAR2(20)      
APPLICATION_IND_TYPE9 Application Indicator Type 9   VARCHAR2(20)      
APPLICATION_INFO1   This is a generic text fields for whatever extra application information is needed. VARCHAR2(60)  

NA

NA

APPLICATION_INFO10 Application Information 10   VARCHAR2(60)      
APPLICATION_INFO11 Application Information 11   VARCHAR2(60)      
APPLICATION_INFO12 Application Information 12   VARCHAR2(60)      
APPLICATION_INFO13 Application Information 13   VARCHAR2(60)      
APPLICATION_INFO14 Application Information 14   VARCHAR2(60)      
APPLICATION_INFO15 Application Information 15   VARCHAR2(60)      
APPLICATION_INFO16 Application Information 16   VARCHAR2(60)      
APPLICATION_INFO17 Application Information 17   VARCHAR2(60)      
APPLICATION_INFO18 Application Information 18   VARCHAR2(60)      
APPLICATION_INFO19 Application Information 19   VARCHAR2(60)      
APPLICATION_INFO2   This is a generic text fields for whatever extra application information is needed. VARCHAR2(60)  

NA

NA

APPLICATION_INFO20 Application Information 20   VARCHAR2(60)      
APPLICATION_INFO3   This is a generic text fields for whatever extra application information is needed. VARCHAR2(60)  

NA

NA

APPLICATION_INFO4   This is a generic text fields for whatever extra application information is needed. VARCHAR2(60)  

NA

NA

APPLICATION_INFO5   This is a generic text fields for whatever extra application information is needed. VARCHAR2(60)  

NA

NA

APPLICATION_INFO6 Application Information 6   VARCHAR2(60)      
APPLICATION_INFO7 Application Information 7   VARCHAR2(60)      
APPLICATION_INFO8 Application Information 8   VARCHAR2(60)      
APPLICATION_INFO9 Application Information 9   VARCHAR2(60)      
APPLICATION_INFO_TYPE1 Application Information Type 1   VARCHAR2(20)      
APPLICATION_INFO_TYPE10 Application Information Type 10   VARCHAR2(20)      
APPLICATION_INFO_TYPE11 Application Information Type 11   VARCHAR2(20)      
APPLICATION_INFO_TYPE12 Application Information Type 12   VARCHAR2(20)      
APPLICATION_INFO_TYPE13 Application Information Type 13   VARCHAR2(20)      
APPLICATION_INFO_TYPE14 Application Information Type 14   VARCHAR2(20)      
APPLICATION_INFO_TYPE15 Application Information Type 15   VARCHAR2(20)      
APPLICATION_INFO_TYPE16 Application Information Type 16   VARCHAR2(20)      
APPLICATION_INFO_TYPE17 Application Information Type 17   VARCHAR2(20)      
APPLICATION_INFO_TYPE18 Application Information Type 18   VARCHAR2(20)      
APPLICATION_INFO_TYPE19 Application Information Type 19   VARCHAR2(20)      
APPLICATION_INFO_TYPE2 Application Information Type 2   VARCHAR2(20)      
APPLICATION_INFO_TYPE20 Application Information Type 20   VARCHAR2(20)      
APPLICATION_INFO_TYPE3 Application Information Type 3   VARCHAR2(20)      
APPLICATION_INFO_TYPE4 Application Information Type 4   VARCHAR2(20)      
APPLICATION_INFO_TYPE5 Application Information Type 5   VARCHAR2(20)      
APPLICATION_INFO_TYPE6 Application Information Type 6   VARCHAR2(20)      
APPLICATION_INFO_TYPE7 Application Information Type 7   VARCHAR2(20)      
APPLICATION_INFO_TYPE8 Application Information Type 8   VARCHAR2(20)      
APPLICATION_INFO_TYPE9 Application Information Type 9   VARCHAR2(20)      
APPLICATION_NUMBER   Application number for the admission application record for a specific academic period. NUMBER(2)  

SARADAP

SARADAP_APPL_NO

APPLICATION_RANKING_ORDER   Number dictating the hierarchical order preference among submitted applications. NUMBER(2)  

SARADAP

SARADAP_APPL_PREFERENCE

APPLICATION_STATUS   Most current status of the application, whether the status is determined by institution or student. VARCHAR2(1)  

SARADAP

SARADAP_APST_CODE

APPLICATION_STATUS_DATE   Date associated with the most current status of the application. DATE  

SARADAP

SARADAP_APST_DATE

APPLICATION_STATUS_DESC   Application status description. VARCHAR2(30)  

FUNCTION

GOKODSF.F_GET_DESC

APPL_ACCEPT_ANY_TIME_IND   Admission population description. Indicates whether the applicant has ever replied to accept the institution's offer of admission. VARCHAR2(1)  

FUNCTION

SOKODSF.F_ADMS_CHECK_STATUS

APPL_ACCEPT_CURRENT_IND   Indicates whether the applicant's most recent decision is to accept the institution's offer of admission. VARCHAR2(1)  

FUNCTION

SOKODSF.F_ADMS_CHECK_STATUS

APPL_FEE_WAIVER_REASON Applicant Fee Waiver Reason   VARCHAR2(4)      
APPL_FEE_WAIVER_REASON_DESC Applicant Fee Waiver Reason Description   VARCHAR2(30)      
CITY_BIRTH_APPL   Applicant's city of birth as reported on the admissions application. VARCHAR2(20)  

SABSUPL

SABSUPL_CITY_BIRTH

COMPLETE_IND   Indicates if the admissions application is complete and ready for review. VARCHAR2(1)  

FUNCTION

F_ADMS_APPLICATION_STATUS

CONFIRMED_IND   This indicates whether the application has been accepted by both the student and the institution by receipt of a deposit. VARCHAR2(1)  

NA

NA

COUNTY_ADMIT   Indicates the county code of the student when they were admitted. The value is either stored in the administrative system or determined via a rule to look at a specific address and take the value. VARCHAR2(5)  

SABSUPL

SABSUPL_CNTY_CODE_ADMIT

COUNTY_BIRTH_APPL   County associated with the person at the time of birth as reported on the admissions application. VARCHAR2(5)  

SABSUPL

SABSUPL_CNTY_CODE_BIRTH

COUNTY_DESC_ADMIT   County associated with the county code at the time of admission. VARCHAR2(30)  

STVCNTY

STVCNTY_DESC

COUNTY_DESC_BIRTH_APPL   County associated with the county code at the time of birth. VARCHAR2(30)  

STVCNTY

STVCNTY_DESC

CURRENT_DATE   System current date (sysdate) or date the data was extracted. DATE  

NA

SYSDATE

DEFERRED_IND   This indicates whether the application has been deferred, I.e. when an accepted applicant chooses to not attend in this academic period but attend in a future academic period. VARCHAR2(1)  

NA

NA

DOMAIN_VALUE   Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)  

NA

NA

EDUCATION_GOAL   Applicant's educational goal at the time of application. VARCHAR2(2)  

SARADAP

SARADAP_EGOL_CODE

EDUCATION_GOAL_DESC   Educational goal description. VARCHAR2(30)  

STVEGOL

STVEGOL_DESC

EDUCATION_LEVEL   Highest level of education completed by the applicant. VARCHAR2(3)  

SARADAP

SARADAP_EDLV_CODE

EDUCATION_LEVEL_DESC   Description of the applicant's current education level. VARCHAR2(30)  

STVEDLV

STVEDLV_DESC

FULL_PART_TIME_IND   Indicates whether the person intends to enroll full or part time. VARCHAR2(1)  

SARADAP

SARADAP_FULL_PART_IND

INCOMPLETE_IND   Indicates whether the application is incomplete. VARCHAR2(1)  

FUNCTION

F_ADMS_APPLICATION_STATUS

INSTITUTION_ATTENDING   Institution the student decided to attend rather than the home institution. VARCHAR2(6)  

SARADAP

SARADAP_SBGI_CODE

INSTITUTION_ATTENDING_DESC   Source/background institution name. VARCHAR2(30)  

STVSBGI

STVSBGI_DESC

INST_ACCEPTED_CURRENT_IND   Indicates that the applicants most recent decision is that they were accepted by the institution. VARCHAR2(1)  

FUNCTION

SOKODSF.F_ADMS_CHECK_STATUS

INST_ADMIT_ANY_TIME_IND   Indicates whether the applicant has ever been accepted by the institution, regardless of the date of the acceptance. VARCHAR2(1)  

FUNCTION

SOKODSF.F_ADMS_CHECK_STATUS

INST_DENIED_IND   Indicates whether the institution has denied the applicant. VARCHAR2(1)  

FUNCTION

SOKODSF.F_ADMS_CHECK_STATUS

IN_OUT_STATE_IND   Indicates whether residency is in or out of state. Required values: I - In-state residency, O - Out-of-state residency. VARCHAR2(1)  

STVRESD

STVRESD_IN_STATE_IND

LATEST_DECISION   Most recent application decision value associated with the application. VARCHAR2(2)  

FUNCTION

SOKODSF.F_SARAPPD_INFO

LATEST_DECISION_DATE   Date most recent application decision was effective. DATE  

FUNCTION

SOKODSF.F_SARAPPD_INFO

LATEST_DECISION_DESC   Application decision (for example, applicant accepted, pending decision, quick admit) associated with the most recent decision code. VARCHAR2(30)  

STVAPDC

STVAPDC_DESC

MIF_DESC   Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)  

NA

NA

MIF_VALUE   Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)  

NA

NA

NATION_ADMIT   Nation/country associated with the person at the time of admission. VARCHAR2(5)  

SABSUPL

SABSUPL_NATN_CODE_ADMIT

NATION_BIRTH_APPL   Nation/country associated with the person at the time of birth as reported on the admissions application. VARCHAR2(5)  

SABSUPL

SABSUPL_NATN_CODE_BIRTH

NATION_BIRTH_DESC_APPL   Nation/country description associated with the person at the time of birth as reported on the admissions application. VARCHAR2(30)  

STVNATN

STVNATN_NATION

NATION_DESC_ADMIT   Nation/country associated with the nation code at the time of admission. VARCHAR2(30)  

STVNATN

STVNATN_NATION

PERSON_UID   System generated, unique, internal identification number assigned to this person. NUMBER(8)  

SARADAP

SARADAP_PIDM

POST_CODE_ADMIT   Postcode or postal code associated with the person at time of admission. VARCHAR2(10)  

NA

NA

PRIMARY_SOURCE   Primary source for the application. VARCHAR2(6)  

SARRSRC

SARRSRC_SBGI_CODE

PRIMARY_SOURCE_DESC   Source/background institution name. VARCHAR2(30)  

STVSBGI

STVSBGI_DESC

RATE   Specific assessment rate assigned to the student. VARCHAR2(5)  

SARADAP

SARADAP_RATE_CODE

RATE_DESC   Fee assessment rate code description. VARCHAR2(30)  

STVRATE

STVRATE_DESC

RECRUITER   Recruiter assigned to the person's admission application record. VARCHAR2(3)  

SARADAP

SARADAP_RECR_CODE

RECRUITER_DESC   Assigned recruiter's name. VARCHAR2(30)  

STVRECR

STVRECR_DESC

RECRUIT_TYPE   Identifies the type of recruit used to classify this prospect. VARCHAR2(2)  

SARADAP

SARADAP_RTYP_CODE

RECRUIT_TYPE_DESC   Recruit type description. VARCHAR2(30)  

STVRTYP

STVRTYP_DESC

REQUIRED_INTERVIEW_STATUS   Indicates the status of the interview associated with the applicant. VARCHAR2(1)  

SARADAP

SARADAP_INTV_CODE

REQUIRED_INTERVIEW_STATUS_DESC   Interview status description. VARCHAR2(30)  

STVINTV

STVINTV_DESC

RESIDENCY   Identifies the residency classification of the applicant and may have been used to determine enrollment charges. VARCHAR2(1)  

SARADAP

SARADAP_RESD_CODE

RESIDENCY_DESC   Residency code description. VARCHAR2(30)  

FUNCTION

GOKODSF.F_GET_DESC

SITE   Site or location to which applicant is applying. VARCHAR2(3)  

SARADAP

SARADAP_SITE_CODE

SITE_CARRIER_ROUTE   Carrier route associated with the site address for barcode mailings. VARCHAR2(4)  

NA

NA

SITE_CITY Site City City, town or municipality associated with the site address. VARCHAR2(50)  

STVSITE

STVSITE_CITY

SITE_CORRECTION_DIGIT   Correction digit associated with the site address for barcode mailings. VARCHAR2(1)  

NA

NA

SITE_COUNTY_CODE   County associated with the site address. VARCHAR2(5)  

NA

NA

SITE_COUNTY_CODE_DESC   Descriptions of the county associated with the site address. VARCHAR2(30)  

NA

NA

SITE_DELIVERY_POINT   Delivery point associated with the site address for barcode mailings. VARCHAR2(2)  

NA

NA

SITE_DESC   Site or location name. VARCHAR2(30)  

FUNCTION

GOKODSF.F_GET_DESC

SITE_NATION   Nation/country code associated with the site address. VARCHAR2(5)  

STVSITE

STVSITE_NATION_CODE

SITE_NATION_DESC   Description for the nation/country associated with the site address. VARCHAR2(30)  

STVNATN

STVNATN_NATION

SITE_POSTAL_CODE Site Postal Code Postal code associated with the site address. VARCHAR2(30)  

STVSITE

STVSITE_ZIPC

SITE_STATE_PROVINCE   Identifies the state or province associated with this address. VARCHAR2(3)  

STVSITE

STVSITE_STATE

SITE_STATE_PROVINCE_DESC   Name of the state/province. VARCHAR2(30)  

STVSTAT

STVSTAT_DESC

SITE_STREET_LINE1 Site Street Line 1 First line of the site address. VARCHAR2(75)  

STVSITE

STVSITE_STREET_ADDR1

SITE_STREET_LINE2 Site Street Line 2 Second line of the site address. VARCHAR2(75)  

STVSITE

STVSITE_STREET_ADDR2

SITE_STREET_LINE3 Site Street Line 3 Third line of the site address. VARCHAR2(75)  

STVSITE

STVSITE_STREET_ADDR3

SITE_STREET_LINE4   Fourth line of the site address. VARCHAR2(30)  

NA

NA

START_DATE   Non term based admissions field. Date you want to start studying. DATE  

NA

NA

STATE_ADMIT   State/Province associated with the person at the time of admission. VARCHAR2(3)  

SABSUPL

SABSUPL_STAT_CODE_ADMIT

STATE_BIRTH_APPL   State/Province associated with the person at the time of birth and reported on the admissions application. VARCHAR2(3)  

SABSUPL

SABSUPL_STAT_CODE_BIRTH

STATE_DESC_ADMIT   State/province name. VARCHAR2(30)  

STVSTAT

STVSTAT_DESC

STATE_DESC_BIRTH_APPL   State/province name. VARCHAR2(30)  

STVSTAT

STVSTAT_DESC

STUDENT_MEETING_TIME   Student's normal attendance time. May be either day, evening, weekend, etc. VARCHAR2(1)  

SARADAP

SARADAP_SESS_CODE

STUDENT_MEETING_TIME_DESC   Student's meeting session description. VARCHAR2(30)  

STVSESS

STVSESS_DESC

STUDENT_POPULATION   Student population or type for reporting. May include populations like new freshman, transfer, continuing, etc. VARCHAR2(1)  

SARADAP

SARADAP_STYP_CODE

STUDENT_POPULATION_DESC   Student population or type description. VARCHAR2(30)  

FUNCTION

GOKODSF.F_GET_DESC

SUB_ACADEMIC_PERIOD   This field identifies the session or part of the academic period associated with the information on the application record. VARCHAR2(6)  

NA

NA

SUB_ACADEMIC_PERIOD_DESC   This field specifies the session or part of the academic period associated with the session code. VARCHAR2(30)  

NA

NA

WITHDRAWAL_REASON   Reason the applicant withdraws an application or chooses not to attend this institution. VARCHAR2(2)  

SARADAP

SARADAP_WRSN_CODE

WITHDRAWAL_REASON_DESC   Reason for withdrawal description. VARCHAR2(30)  

STVWRSN

STVWRSN_DESC

ZONE_VALUE   Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)  

NA

NA



Ver: