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(63)	SARADAP	SARADAP_TERM_CODE_ENTRY
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(63)	STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
AGE	Calculated Age (subtract the birth date from the current system date).	NUMBER	FUNCTION	F_CALCULATE_AGE
APPLICATION_NUMBER	Application number for the admission application record for a specific academic period.	NUMBER	SABSUPL	SABSUPL_APPL_NO
AWARD_CATEGORY	Award category associated with the outcome, degree or award. Category used to group outcomes for reporting similar awards together. For example, less than two year, two year and four year awards.	VARCHAR2(63)	STVDEGC	STVDEGC_ACAT_CODE
AWARD_CATEGORY_DESC	Award category description.	VARCHAR2(255)	STVACAT	STVACAT_DESC
BIRTH_DATE	Date of birth for the person.	DATE	SPBPERS	SPBPERS_BIRTH_DATE
CAMPUS	Campus to which applicant is applying.	VARCHAR2(63)	SORLCUR	SORLCUR_CAMP_CODE
CAMPUS_DESC	Institution campus name.	VARCHAR2(255)	STVCAMP	STVCAMP_DESC
CITIZENSHIP_IND	Indicates whether the person has been identified as a citizen of the institution's home country.	VARCHAR2(1)	SPBPERS	SPBPERS_CITZ_IND
COHORT	Cohort tracking group assigned to the application through the Administrative UI display rules.	VARCHAR2(63)	SARCHRT	SARCHRT_CHRT_CODE
COHORT_DESC	Cohort code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
COLLEGE	College, faculty or school to which the academic study for the student is associated.	VARCHAR2(63)	SORLCUR	SORLCUR_COLL_CODE
COLLEGE_DESC	College, faculty or school name.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC
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(63)	SABSUPL	SABSUPL_CNTY_CODE_ADMIT
COUNTY_DESC_ADMIT	County associated with the county code at the time of admission.	VARCHAR2(255)	STVCNTY	STVCNTY_DESC
CURRICULUM_ORDER	Unique sequence number that identifies this academic study or program for the student.	NUMBER	CALCULATION	ROW_NUMBER
DEGREE	Degree or award code associated with the academic study.	VARCHAR2(63)	SORLCUR	SORLCUR_DEGC_CODE
DEGREE_DESC	Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.	VARCHAR2(255)	STVDEGC	STVDEGC_DESC
DEPARTMENT	Department associated with the academic study on the admission application.	VARCHAR2(63)	SORLFOS	SORLFOS_DEPT_CODE
DEPARTMENT_DESC	Department name.	VARCHAR2(255)	STVDEPT	STVDEPT_DESC
EDUCATION_GOAL	Applicant's educational goal at the time of application.	VARCHAR2(63)	SARADAP	SARADAP_EGOL_CODE
EDUCATION_GOAL_DESC	Educational goal description.	VARCHAR2(255)	STVEGOL	STVEGOL_DESC
EDUCATION_LEVEL	Highest level of education completed by the person.	VARCHAR2(63)	SARADAP	SARADAP_EDLV_CODE
EDUCATION_LEVEL_DESC	Description of the highest level of education recorded for the person.	VARCHAR2(255)	STVEDLV	STVEDLV_DESC
FIRST_NAME	Person's first or given name.	VARCHAR2(63)	SPRIDEN	SPRIDEN_FIRST_NAME
GENDER	Person's gender. Values are Male, Female or Not reported to the institution.	VARCHAR2(63)	SPBPERS	SPBPERS_SEX
GENDER_DESC	Identify as Male, Female or Not reported.	VARCHAR2(63)	CALCULATION	DECODE(SPBPERS_SEX,'M','MALE','F','FEMALE','N','NOT REPORTED')
HISPANIC_LATINO_ETHNICITY_IND	Indicates if person's ethnicity is Latino or Hispanic. Due to mandated changes to the collection of race and ethnicity, these classifications were changed to separate Race and Ethnicity. Ethnicity can now be defined as either Hispanic or Latino, or Not Hispanic or Latino.	VARCHAR2(1)	SPBPERS	SPBPERS_ETHN_CODE
ID	ID number given to the student to track their records at the institution.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID
INTENDED_TIME_STATUS_DESC	Indicates whether the student plans to attend with a full time or part time load.	VARCHAR2(9)	CALCULATION	DECODE(SARADAP_FULL_PART_IND,'F', 'FULL TIME', 'P', 'PART TIME')
INTENDED_TIME_STATUS_IND	Flag indicating whether the change in time status was calculated by the system or overridden and updated by a user.	VARCHAR2(1)	SARADAP	SARADAP_FULL_PART_IND
LAST_NAME	Last name.	VARCHAR2(63)	SPRIDEN	SPRIDEN_LAST_NAME
LATEST_POST_SECONDARY_DESC	Name of the post secondary institution attended.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
LATEST_POST_SECONDARY_SCHOOL	Post secondary institution attended.	VARCHAR2(63)	SORPCOL	SORPCOL_SBGI_CODE
LATEST_SECONDARY_SCHOOL	Secondary institution attended.	VARCHAR2(63)	SORHSCH	SORHSCH_SBGI_CODE
LATEST_SECONDARY_SCHOOL_DESC	Name of the secondary institution attended.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
MAJOR	Major subject area of the person's academic study.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE
MAJOR_DESC	Name of the student's major subject area.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
MIDDLE_NAME	Middle name.	VARCHAR2(63)	SPRIDEN	SPRIDEN_MI
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NATION_ADMIT	Student's nation when they were admitted. The code is either stored in the Administrative UI, or determined via a rule to look at a specific address and take the value.	VARCHAR2(63)	SABSUPL	SABSUPL_NATN_CODE_ADMIT
NATION_DESC_ADMIT	Name of the nation of residence when the person was admitted.	VARCHAR2(255)	STVNATN	STVNATN_NATION
PERSON_UID	Internally generated by the system to uniquely identify the person or entity.	NUMBER	SARADAP	SARADAP_PIDM
POST_SECONDARY_DEGREE	Identifies the degree or award completed. This always shows the latest degree earned.	VARCHAR2(63)	SORDEGR	SORDEGR_DEGR_SEQ_NO
POST_SECONDARY_DEGREE_DESC	Post secondary degree or award description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
POST_SECONDARY_HONORS	Identifies if an honor recognition is associated with the previous education degree or award.	VARCHAR2(63)	SORDEGR	SORDEGR_HONR_CODE
POST_SECONDARY_HONORS_DESC	Post secondary degree honor description associated with the degree or award.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PRIMARY_ETHNICITY	Person's ethnicity.	VARCHAR2(63)	SPBPERS	SPBPERS_ETHN_CODE
PRIMARY_ETHNICITY_DESC	Ethnic code description.	VARCHAR2(255)	STVETHN	STVETHN_DESC
PRIM_ETHNICITY_CATEGORY	Ethnic group used for governmental reporting.	VARCHAR2(63)	STVETHN	STVETHN_ETCT_CODE
PRIM_ETHNICITY_CATEGORY_DESC	Ethnic category description as defined by the government reporting.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROGRAM	Program or course of study for the student. This may be blank when programs are not being used to manage a set of completion requirements.	VARCHAR2(63)	SORLCUR	SORLCUR_PROGRAM
PROGRAM_CLASSIFICATION	Program classification associated with the major subject area of study for this outcome. Thsi may be the Classification of Institutional Program (CIP) codes used for reporting to the federal government.	VARCHAR2(63)	STVMAJR	STVMAJR_CIPC_CODE
PROGRAM_CLASSIFICATION_DESC	Program classification description.	VARCHAR2(255)	STVCIPC	STVCIPC_DESC
PROGRAM_DESC	Program or course of study description.	VARCHAR2(255)	SMRPRLE	SMRPRLE_PROGRAM_DESC
PS_EDUCATION_GOAL	NA	VARCHAR2(63)	NA	NA
PS_EDUCATION_GOAL_DESC	NA	VARCHAR2(255)	NA	NA
PS_GPA_TRANSFERRED	Transferred GPA from the person's previous post-secondary experience.	VARCHAR2(63)	SORDEGR	SORDEGR_GPA_TRANSFERRED
PS_SCHOOL_PERCENTILE	Person's class percentile as related to class rank and size.	NUMBER	NA	NA
PS_SCHOOL_RANK	Identifies the person's class rank.	NUMBER	NA	NA
PS_SCHOOL_SIZE	Person's class size.	NUMBER	NA	NA
RACE_CATEGORY_COUNT	Number of unique regulatory races selected by this person.	NUMBER	FUNCTION	MGKFUNC.F_COUNT_RACE_CATEGORY
RACE_COUNT	Number of races selected by this person.	NUMBER	FUNCTION	MGKFUNC.F_COUNT_RACE
RACE_ETHNICITY_CONFIRM_DATE	Race and ethnicity self confirmed date.	DATE	SPBPERS	SPBPERS_CONFIRMED_RE_DATE
RACE_ETHNICITY_CONFIRM_IND	Indicates if the person's race and ethnicity have been self-identified.	VARCHAR2(1)	SPBPERS	SPBPERS_CONFIRMED_RE_CDE
SECONDARY_SCHOOL_DIPLOMA	Diploma type earned at the secondary school attended.	VARCHAR2(63)	SORHSCH	SORHSCH_DPLM_CODE
SECONDARY_SCHOOL_DIPLOMA_DESC	Secondary school diploma type name. For example, College Prep, Vocational, etc.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
SECONDARY_SCHOOL_GRAD_DATE	Date the person graduated.	DATE	SORHSCH	SORHSCH_GRADUATION_DATE
SECONDARY_SCHOOL_PERCENTILE	Person's class percentile as related to class rank and size.	NUMBER	SORHSCH	SORHSCH_PERCENTILE
SECONDARY_SCHOOL_RANK	Person's class rank.	NUMBER	SORHSCH	SORHSCH_CLASS_RANK
SECONDARY_SCHOOL_REPORTED_GPA	Person's secondary school GPA or Average.	VARCHAR2(63)	SORHSCH	SORHSCH_GPA
SECONDARY_SCHOOL_SIZE	Person's class size.	NUMBER	SORHSCH	SORHSCH_CLASS_SIZE
STATE_PROVINCE_ADMIT	State/province code of the student when they were admitted. The value is either stored in the Administrative UI, or determined via a rule to look at a specific address and take the value.	VARCHAR2(63)	SABSUPL	SABSUPL_STAT_CODE_ADMIT
STATE_PROVINCE_DESC_ADMIT	State or province name where the person resided when they were admitted.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
STUDENT_LEVEL	Student level associated with the coursework in the academic outcome. Examples, include undergraduate and graduate, etc.	VARCHAR2(63)	SORLCUR	SORLCUR_LEVL_CODE
STUDENT_LEVEL_DESC	Student level description.	VARCHAR2(255)	STVLEVL	STVLEVL_DESC
STUDENT_POPULATION	Student population or type for reporting. May include populations like new freshman, transfer, continuing, etc.	VARCHAR2(63)	SARADAP	SARADAP_STYP_CODE
STUDENT_POPULATION_DESC	Student population or type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
STUDENT_RESIDENCY	Residency of the student typically used to calculate tuition and fees to be charged.	VARCHAR2(63)	SARADAP	SARADAP_RESD_CODE
STUDENT_RESIDENCY_DESC	Student residency code description.	VARCHAR2(255)	STVRESD	STVRESD_DESC
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.	VARCHAR2(63)	NA	NA
SUB_ACADEMIC_PERIOD_DESC	Sub academic period description.	VARCHAR2(255)	NA	NA
TEST1	Test score code associated with various tests, i.e., SAT, ACT, placement scores.	VARCHAR2(63)	SORTEST	SORTEST_TESC_CODE
TEST2	Test score code associated with various tests, i.e., SAT, ACT, placement scores.	VARCHAR2(63)	SORTEST	SORTEST_TESC_CODE
TEST3	Test score code associated with various tests, i.e., SAT, ACT, placement scores.	VARCHAR2(63)	SORTEST	SORTEST_TESC_CODE
TEST4	Test score code associated with various tests, i.e., SAT, ACT, placement scores.	VARCHAR2(63)	SORTEST	SORTEST_TESC_CODE
TEST5	Test score code associated with various tests, i.e., SAT, ACT, placement scores.	VARCHAR2(63)	SORTEST	SORTEST_TESC_CODE
TEST6	Test score code associated with various tests, i.e., SAT, ACT, placement scores.	VARCHAR2(63)	SORTEST	SORTEST_TESC_CODE
TEST7	Test score code associated with various tests, i.e., SAT, ACT, placement scores.	VARCHAR2(63)	SORTEST	SORTEST_TESC_CODE
TEST_DESC1	Test description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
TEST_DESC2	Test description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
TEST_DESC3	Test description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
TEST_DESC4	Test description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
TEST_DESC5	Test description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
TEST_DESC6	Test description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
TEST_DESC7	Test description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
TEST_RULE	Institution defined display rule set up in MGRSDAX that determines which test scores are displayed for this person.	VARCHAR2(63)	MGRSDAX	MGRSDAX_INTERNAL_CODE
TEST_SCORE1	Test score value for this test code, date and person.	VARCHAR2(63)	SORTEST	SORTEST_TEST_SCORE
TEST_SCORE2	Test score value for this test code, date and person.	VARCHAR2(63)	SORTEST	SORTEST_TEST_SCORE
TEST_SCORE3	Test score value for this test code, date and person.	VARCHAR2(63)	SORTEST	SORTEST_TEST_SCORE
TEST_SCORE4	Test score value for this test code, date and person.	VARCHAR2(63)	SORTEST	SORTEST_TEST_SCORE
TEST_SCORE5	Test score value for this test code, date and person.	VARCHAR2(63)	SORTEST	SORTEST_TEST_SCORE
TEST_SCORE6	Test score value for this test code, date and person.	VARCHAR2(63)	SORTEST	SORTEST_TEST_SCORE
TEST_SCORE7	Test score value for this test code, date and person.	VARCHAR2(63)	SORTEST	SORTEST_TEST_SCORE
TRANSFER_CREDIT_ATTEMPTED	Transferred credits attempted.	NUMBER	SHRLGPA	SHRLGPA_HOURS_ATTEMPTED
TRANSFER_CREDIT_EARNED	Transferred credits earned.	NUMBER	SHRLGPA	SHRLGPA_HOURS_EARNED
TRANSFER_CREDIT_GPA	Average or Grade Point Average for the credits and grades transferred to this institution.	NUMBER	SHRLGPA	SHRLGPA_GPA
TRANSFER_CREDIT_GPA_CREDIT	Transferred credits used in the transfer average or grade point average calculation.	NUMBER	SHRLGPA	SHRLGPA_GPA_HOURS
TRANSFER_CREDIT_QUALITY_POINTS	Transferred quality points.	NUMBER	SHRLGPA	SHRLGPA_QUALITY_POINTS

Ver: 8.1