RETURN TO COMPOSITE VIEW REPORTS LIST
Student Composite View Reports

SGHE 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 Definition Database Data Type 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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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_INFO1 This is a generic text fields for whatever extra application information is needed. VARCHAR2(60)

NA

NA

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

NA

NA

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_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

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

F_ADMS_CHECK_STATUS

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)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

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

F_ADMS_CHECK_STATUS

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

FUNCTION

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

F_CONCAT_SARAPPD

LATEST_DECISION_DATE Date most recent application decision was effective. DATE

FUNCTION

F_CONCAT_SARAPPD

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

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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)

FUNCTION

GOKODSF.F_GET_DESC

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

SARADAP

SARADAP_RATE_CODE

RATE_DESC Fee assessment rate code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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 City, town or municipality associated with the site address. VARCHAR2(20)

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)

FUNCTION

GOKODSF.F_GET_DESC

SITE_POSTAL_CODE Postal code associated with the site address. VARCHAR2(10)

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)

FUNCTION

GOKODSF.F_GET_DESC

SITE_STREET_LINE1 First line of the site address. VARCHAR2(30)

STVSITE

STVSITE_STREET_ADDR1

SITE_STREET_LINE2 Second line of the site address. VARCHAR2(30)

STVSITE

STVSITE_STREET_ADDR2

SITE_STREET_LINE3 Third line of the site address. VARCHAR2(30)

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)

FUNCTION

GOKODSF.F_GET_DESC

STATE_DESC_BIRTH_APPL State/province name. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA



Ver: 3.1