Student_Param_Text

Student_Param_Type

Source

Value Type

Definition

Information Release Consent (click for definition)

YESNO

Set manually by student

Yes/No

Indicates student's consent for us to use their information for study abroad

Local Phone Number

FIELD

Set manually by student

Text

Student's local phone number

Local Address

FIELD

Set manually by student

Text

Student's local address

Local Email

FIELD

Set manually by student

Text

Student's local email

Legacy Student ID

FIELD

OGE Legacy Database

Integer

Student ID number from OGE Legacy Database

Create profile (temp)

YESNO

Terra Dotta

Yes/No

Older_Than_18

YESNO

SIS

Yes/No

Is the student over 18

Age

FIELD

SIS

Integer

Student's age.

Ethnicity_Hispanic

YESNO

SIS

Yes/No

Indicates if student is of Hispanic ethnicity

Race_White

YESNO

SIS

Yes/No

Is the student's identifying race white

Race_Black

YESNO

SIS

Yes/No

Is the student's identifying race black

Race_Asian

YESNO

SIS

Yes/No

Is the student's identifying race Asian

Race_American_Indian

YESNO

SIS

Yes/No

Is the student's identifying race American Indian

Race_Pacific_Islander

YESNO

SIS

Yes/No

Is the student's identifying race pacific islander

Race_Other

YESNO

SIS

Yes/No

Is the student's identifying race other

Other_Email

FIELD

SIS

Text

Student's alternate email address

GA_Resident

YESNO

SIS

Yes/No

Is the student a Georgia state resident

US_Citizen

YESNO

SIS

Yes/No

Is the student a US citizen

Citizenship_Code

FIELD

SIS

Text

Name of country of citizenship. i.e. "United States"

Visa_Type

FIELD

SIS

Text

Type of visa if applicable. i.e. "F1 - Student"

Hold_Flag

YESNO

SIS

Yes/No

Does the student have a hold on their account.

VLP_Flag

YESNO

SIS

Yes/No

Verification of Lawful Presence flag. If they haven't submitted this documentation to admissions or there is a problem, it will say Yes.

Degree_1

SELCT

SIS

Text

First degree type. i.e. "Bach Sci Family and Cons Sci"

Degree_2

SELCT

SIS

Text

Second degree type. i.e. "Bach Sci Family and Cons Sci"

Major_1

SELCT

SIS

Text

First major. i.e. "Nutritional Sciences"

Major_1_CIP

FIELD

SIS

Integer

First major CIP code. i.e. "301901". This is an inter-institutional reference code for the major.

Major_1_College

SELCT

SIS

Text

First major owning College. i.e. "College of Fam and Consumr Sci"

Major_1_Department

SELCT

SIS

Text

First major owning Department. i.e. "Foods and Nutrition"

Major_2

SELCT

SIS

Text

Second major. i.e. "Nutritional Sciences"

Major_2_CIP

FIELD

SIS

Integer

Second major CIP code. i.e. "301901". This is an inter-institutional reference code for the major.

Major_2_College

SELCT

SIS

Text

Second major owning College. i.e. "College of Fam and Consumr Sci"

Major_2_Department

SELCT

SIS

Text

Second major owning Department. i.e. "Foods and Nutrition"

Major_3

SELCT

SIS

Text

Third major. i.e. "Nutritional Sciences"

Major_3_CIP

FIELD

SIS

Integer

Third major CIP code. i.e. "301901". This is an inter-institutional reference code for the major.

Major_3_College

SELCT

SIS

Text

Third major owning College. i.e. "College of Fam and Consumr Sci"

Major_3_Department

SELCT

SIS

Text

Third major owning Department. i.e. "Foods and Nutrition"

Minor_1

SELCT

SIS

Text

First minor. i.e. "French"

Minor_1_Department

SELCT

SIS

Text

First minor department. i.e. "Romance Languages"

Minor_2

SELCT

SIS

Text

Second minor. i.e. "French"

Minor_2_Department

SELCT

SIS

Text

Second minor department. i.e. "Romance Languages"

Minor_3

SELCT

SIS

Text

Third minor. i.e."French"

Minor_3_Department

SELCT

SIS

Text

Third minor department. i.e. "Romance Languages"

Certificate_1

SELCT

SIS

Text

First certificate. i.e. "Cert Actuarial Science"

Certificate_1_CIP

FIELD

SIS

Integer

First certificate CIP code. i.e. "301901". This is an inter-institutional reference code for the certificate.

Certificate_1_College

SELCT

SIS

Text

First certificate college. i.e. "Family and Consumer Sciences"

Certificate_1_Department

SELCT

SIS

Text

First certificate department. i.e. "Foods and Nutrition"

Certificate_2

SELCT

SIS

Text

Second certificate. i.e. "Cert Actuarial Science"

Certificate_2_CIP

FIELD

SIS

Integer

Second certificate CIP code. i.e. "301901". This is an inter-institutional reference code for the certificate.

Certificate_2_College

SELCT

SIS

Text

Second certificate college. i.e. "Family and Consumer Sciences"

Certificate_2_Department

SELCT

SIS

Text

Second certificate department. i.e. "Foods and Nutrition"

Certificate_3

SELCT

SIS

Text

Third certificate. i.e. "Cert Actuarial Science"

Certificate_3_CIP

FIELD

SIS

Integer

Third certificate CIP code. i.e. "301901". This is an inter-institutional reference code for the certificate.

Certificate_3_College

SELCT

SIS

Text

Third certificate college. i.e. "Family and Consumer Sciences"

Certificate_3_Department

SELCT

SIS

Text

Third certificate department. i.e. "Foods and Nutrition"

Area_1

SELCT

SIS

Text

First academic area. i.e. "Animal Biology"

Area_2

SELCT

SIS

Text

Second academic area. i.e. "Animal Biology"

Area_3

SELCT

SIS

Text

Third academic area. i.e. "Animal Biology"

Greek Life Association

YESNO

SIS

Yes/No

Is the student registered as part of the Greek Life Association.

Honors_Program

YESNO

SIS

Yes/No

Is the student in the Honors program

Expected_Graduation_Date_1

DATE

SIS

Date

Expected graduation date for Degree_1

Expected_Graduation_Date_2

DATE

SIS

Date

Expected graduation date for Degree_2

Institutional_GPA

NUMBR

SIS

Decimal

Student's GPA only including coursework from UGA

Overall_GPA

NUMBR

SIS

Decimal

Student's GPA including both UGA coursework and Transfer coursework.

Current_Academic_Level

SELCT

SIS

Text

Student's current academic level. i.e. "Undergraduate"

Transient_App_Submitted¹

YESNO

SIS

Yes/No

Has the transient student submitted an application to UGA

Transient_Home_Institution¹

FIELD

SIS

Text

Transient student's home institution

Transient_App_Fee_Paid¹

YESNO

SIS

Yes/No

Has the transient student paid the UGA application fee

Transient_Decision_Code¹

FIELD

SIS

Text

Status of transient student's application. i.e "Applicant Accepted Offer"

Transient_Transcript_Recieved¹

SELCT

SIS

Yes/No

Has the transient student submitted their transcript to UGA admissions

Transient_Campus_Code¹

FIELD

SIS

Text

What UGA campus will the student be studying on. i.e. "Study Abroad Cortona, Italy"

Transient_Application_Term¹

FIELD

SIS

Integer

UGA term that the student has applied for, in the Banner term format. i.e. "201508"

Student_Athlete

YESNO

SIS

Yes/No

Is the student registered as a student athlete

Student_Disability

FIELD

SIS

Unknown

Probably contains information on student disability, if reported.

Last_Term_Enrolled

FIELD

SIS

Integer

UGA term that the student was last enrolled for, in the Banner term format. i.e. "201508"

custom_01

FIELD

SIS

Text

Student's class. i.e. "Freshman", "Sophomore", etc.

custom_02

FIELD

SIS

Text

Total institutional credits earned

custom_03

FIELD

SIS

Text

Total overall credits earned

custom_04

FIELD

SIS

Text

Preferred Name

custom_05

FIELD

SIS

Text

Military Flag

custom_06

FIELD

SIS

Text

Georgia Rural Status

custom_07

FIELD

SIS

Text

First Generation Flag

custom_08

FIELD

SIS

Text

Placeholders for new parameters in the future.

custom_09

FIELD

SIS

Text

Placeholders for new parameters in the future.

custom_10

FIELD

SIS

Text

Placeholders for new parameters in the future.

UGA ID

FIELD

SIS

Integer

UGA student ID number. i.e. "810123123"

CISI Phone Number

FIELD

SIS

Text

Student's phone number. This is identical to the phone number they have on file with the university and is used for the CISI enrollment module.

UGACR Legacy ID

FIELD

UGACR Legacy Database

Integer

Applicant ID number from the UGACR Terra Dotta

Foundation Fellow

YESNO

Set manually by staff

Yes/No

Indicates if a student is part of the Foundation Fellows. This is updated manually each year with a list sent by Honors.

Ramsey Scholar

YESNO

Set manually by staff

Yes/No

Indicates if a student is part of the Ramsey Scholars. This is updated manually each year with a list sent by Honors.

EA Approved

SELCT

Set manually by staff

Multiple Selection

Indicates Education Abroad approval of student travel registrations. i.e. "Pending"

OGE Internal Flag

YESNO

Set manually by staff

Yes/No

Used internally for testing purposes. It's an easy way to flag certain applications so you can bring them up with one query.