Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACADEMIC_PERIOD	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	Academic period description.	VARCHAR2(255)		STVTERM	STVTERM_DESC
ACADEMIC_YEAR	Academic Year	Academic year associated with the academic period on this record.	VARCHAR2(63)		STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC	Academic Year Description	Academic year description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
AGE	Age	Calculated Age (subtract the birth date from the current system date).	NUMBER		FUNCTION	F_CALCULATE_AGE
APPLICANT_ACCEPT_IND	Applicant Accept Indicator	This decision code indicates the applicant has accepted the admissions offer.	VARCHAR2(1)		CALCULATION	DECODE(STVAPDC_STDN_ACC_IND)
APPLICATION_INACTIVE_IND	Application Inactive Indicator	This decision code indicates an inactive application status.	VARCHAR2(1)		CALCULATION	DECODE(STVAPDC_APPL_INACT)
APPLICATION_NUMBER	Application Number	Application number for the admission application record for a specific academic period.	NUMBER		SARADAP	SARADAP_APPL_NO
APPLICATION_SIGNIF_IND	Application Signif Indicator	Identifies whether the decision affects the acceptance of the application. Y - Application acceptance is effected by decision.	VARCHAR2(1)		CALCULATION	DECODE(STVAPDC_SIGNF_IND)
AWARD_CATEGORY	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	Award category description.	VARCHAR2(255)		STVACAT	STVACAT_DESC
BIRTH_DATE	Birth Date	Date of birth for the person.	DATE		SPBPERS	SPBPERS_BIRTH_DATE
CAMPUS	Campus	Campus to which applicant is applying.	VARCHAR2(63)		SORLCUR	SORLCUR_CAMP_CODE
CAMPUS_DESC	Campus Description	Institution campus name.	VARCHAR2(255)		STVCAMP	STVCAMP_DESC
CITIZENSHIP_IND	Citizenship Indicator	Indicates whether the person has been identified as a citizen of the institution's home country.	VARCHAR2(1)		SPBPERS	SPBPERS_CITZ_IND
COHORT	Cohort	Cohort tracking group assigned to the application through the Administrative UI display rules.	VARCHAR2(63)		SARCHRT	SARCHRT_CHRT_CODE
COHORT_DESC	Cohort Description	Cohort code description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
COLLEGE	College	College, faculty or school to which the academic study for the student is associated.	VARCHAR2(63)		SORLCUR	SORLCUR_COLL_CODE
COLLEGE_DESC	College Description	College, faculty or school name.	VARCHAR2(255)		STVCOLL	STVCOLL_DESC
COUNTY_ADMIT	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 Description Admit	County associated with the county code at the time of admission.	VARCHAR2(255)		STVCNTY	STVCNTY_DESC
CURRICULUM_ORDER	Curriculum Order	Unique sequence number that identifies this academic study or program for the student.	NUMBER		CALCULATION	ROW_NUMBER
DECISION	Decision	Value associated with the application number and decision for this academic period.	VARCHAR2(63)		SARAPPD	SARAPPD_APDC_CODE
DECISION_DATE	Decision Date	Date application decision was applied.	DATE		SARAPPD	SARAPPD_APDC_DATE
DECISION_DESC	Decision Description	Decision code description such as applicant accepted, pending decision, quick admit.	VARCHAR2(255)		SARAPPD	SARAPPD_APDC_CODE
DECISION_NUMBER	Decision Number	Internal decision sequence number associated with this decision for this application number.	NUMBER		SARAPPD	SARAPPD_SEQ_NO
DECISION_SOURCE	Decision Source	Identifies whether this decision is an institution decision or applicant decision.	VARCHAR2(63)		FUNCTION	DECODE(GOKODSF.F_GET_DESC)
DEGREE	Degree	Degree or award code associated with the academic study.	VARCHAR2(63)		SORLCUR	SORLCUR_DEGC_CODE
DEGREE_DESC	Degree Description	Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.	VARCHAR2(255)		STVDEGC	STVDEGC_DESC
DEPARTMENT	Department	Department associated with the academic study on the admission application.	VARCHAR2(63)		SORLFOS	SORLFOS_DEPT_CODE
DEPARTMENT_DESC	Department Description	Department name.	VARCHAR2(255)		STVDEPT	STVDEPT_DESC
EDUCATION_GOAL	Education Goal	Applicant's educational goal at the time of application.	VARCHAR2(63)		SARADAP	SARADAP_EGOL_CODE
EDUCATION_GOAL_DESC	Education Goal Description	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	Education Level Description	Description of the highest level of education recorded for the person.	VARCHAR2(255)		STVEDLV	STVEDLV_DESC
FIRST_NAME	First Name	Person's first or given name.	VARCHAR2(63)		SPRIDEN	SPRIDEN_FIRST_NAME
GENDER	Gender	Person's gender. Values are Male, Female or Not reported to the institution.	VARCHAR2(63)		SPBPERS	SPBPERS_SEX
GENDER_DESC	Gender Description	Identify as Male, Female or Not reported.	VARCHAR2(63)		CALCULATION	DECODE(SPBPERS_SEX,'M','MALE','F','FEMALE','N','NOT REPORTED')
HISPANIC_LATINO_ETHNICITY_IND	Hispanic Latino Ethnicity Indicator	Indicates if person's ethnicity is Latino or Hispanic.This one ethnicity group was identified as a federal reporting group for ethnicity and race categories.	VARCHAR2(1)		SPBPERS	SPBPERS_ETHN_CDE
ID	ID	ID number given to the student to track their records at the institution.	VARCHAR2(63)		SPRIDEN	SPRIDEN_ID
INSTITUTION_ADMIT_IND	Institution Admitted Indicator	This decision code indicates an institution admit status.	VARCHAR2(1)		CALCULATION	DECODE(STVAPDC_INST_ACC_IND)
INSTITUTION_DENIED_IND	Institution Denied Indicator	This decision code indicates an institution denied status.	VARCHAR2(1)		CALCULATION	DECODE(STVAPDC_REJECT_IND)
INTENDED_TIME_STATUS_DESC	Intended Time Status Description	Indicates whether the student plans to attend with a full time or part time load.	VARCHAR2(4000)		CALCULATION	DECODE(SARADAP_FULL_PART_IND,'F', 'FULL TIME', 'P', 'PART TIME')
INTENDED_TIME_STATUS_IND	Intended Time Status Indicator	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	Last name.	VARCHAR2(63)		SPRIDEN	SPRIDEN_LAST_NAME
LATEST_POST_SECONDARY_DESC	Latest Post Secondary Description	Name of the post secondary institution attended.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
LATEST_POST_SECONDARY_SCHOOL	Latest Post Secondary School	Post secondary institution attended.	VARCHAR2(63)		SORPCOL	SORPCOL_SBGI_CODE
LATEST_SECONDARY_SCHOOL	Latest Secondary School	Secondary institution attended.	VARCHAR2(63)		SORHSCH	SORHSCH_SBGI_CODE
LATEST_SECONDARY_SCHOOL_DESC	Latest Secondary School Description	Name of the secondary institution attended.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
MAINTAINED_IND	Maintained Indicator	Indicates whether the application decision was maintained by the system or the user.	VARCHAR2(1)		SARAPPD	SARAPPD_MAINT_IND
MAINTENANCE_USER_ID	Maintenance User ID	Identification number of the most recent user to create or update a record.	VARCHAR2(63)		SARAPPD	SARAPPD_USER
MAJOR	Major	Major subject area of the person's academic study.	VARCHAR2(63)		SORLFOS	SORLFOS_MAJR_CODE
MAJOR_DESC	Major Description	Name of the student's major subject area.	VARCHAR2(255)		STVMAJR	STVMAJR_DESC
MIDDLE_NAME	Middle Name	Middle name.	VARCHAR2(63)		SPRIDEN	SPRIDEN_MI
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)		NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)		NA	NA
NATION_ADMIT	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	Nation Description Admit	Name of the nation of residence when the person was admitted.	VARCHAR2(255)		STVNATN	STVNATN_NATION
PERSON_UID	Person UID	Internally generated by the system to uniquely identify the person or entity.	NUMBER		SARADAP	SARADAP_PIDM
POST_SECONDARY_DEGREE	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 Description	Post secondary degree or award description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
POST_SECONDARY_HONORS	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 Honors Description	Post secondary degree honor description associated with the degree or award.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
PRIMARY_ETHNICITY	Primary Ethnicity	Person's ethnicity.	VARCHAR2(63)		SPBPERS	SPBPERS_ETHN_CODE
PRIMARY_ETHNICITY_DESC	Primary Ethnicity Description	Ethnic code description.	VARCHAR2(255)		STVETHN	STVETHN_DESC
PRIM_ETHNICITY_CATEGORY	Primary Ethnicity Category	Ethnic group used for governmental reporting.	VARCHAR2(63)		STVETHN	STVETHN_ETCT_CODE
PRIM_ETHNICITY_CATEGORY_DESC	Primary Ethnicity Category Description	Ethnic category description as defined by the government reporting.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
PROGRAM	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	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	Program classification description.	VARCHAR2(255)		STVCIPC	STVCIPC_DESC
PROGRAM_DESC	Program Description	Program or course of study description.	VARCHAR2(255)		SMRPRLE	SMRPRLE_PROGRAM_DESC
PS_EDUCATION_GOAL	Ps Education Goal	NA	VARCHAR2(63)		NA	NA
PS_EDUCATION_GOAL_DESC	Ps Education Goal Description	NA	VARCHAR2(255)		NA	NA
PS_GPA_TRANSFERRED	Post Secondary Grade Point Average or Average Transferred	Transferred GPA from the person's previous post-secondary experience.	VARCHAR2(63)		SORDEGR	SORDEGR_GPA_TRANSFERRED
PS_SCHOOL_PERCENTILE	Ps School Percentile	Person's class percentile as related to class rank and size.	NUMBER		NA	NA
PS_SCHOOL_RANK	Ps School Rank	Identifies the person's class rank.	NUMBER		NA	NA
PS_SCHOOL_SIZE	Ps School Size	Person's class size.	NUMBER		NA	NA
RACE_CATEGORY_COUNT	Race Category Count	Number of unique regulatory races selected by this person.	NUMBER		FUNCTION	MGKFUNC.F_COUNT_RACE_CATEGORY
RACE_COUNT	Race Count	Number of races selected by this person.	NUMBER		FUNCTION	MGKFUNC.F_COUNT_RACE
RACE_ETHNICITY_CONFIRM_DATE	Race Ethnicity Confirm Date	Race and ethnicity self confirmed date.	DATE		SPBPERS	SPBPERS_CONFIRMED_RE_DATE
RACE_ETHNICITY_CONFIRM_IND	Race Ethnicity Confirm Indicator	Indicates if the person's race and ethnicity have been self-identified.	VARCHAR2(1)		SPBPERS	SPBPERS_CONFIRMED_RE_CDE
SECONDARY_SCHOOL_DIPLOMA	Secondary School Diploma	Diploma type earned at the secondary school attended.	VARCHAR2(63)		SORHSCH	SORHSCH_DPLM_CODE
SECONDARY_SCHOOL_DIPLOMA_DESC	Secondary School Diploma Description	Secondary school diploma type name. For example, College Prep, Vocational, etc.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
SECONDARY_SCHOOL_GRAD_DATE	Secondary School Graduate Date	Date the person graduated.	DATE		SORHSCH	SORHSCH_GRADUATION_DATE
SECONDARY_SCHOOL_PERCENTILE	Secondary School Percentile	Person's class percentile as related to class rank and size.	NUMBER		SORHSCH	SORHSCH_PERCENTILE
SECONDARY_SCHOOL_RANK	Secondary School Rank	Person's class rank.	NUMBER		SORHSCH	SORHSCH_CLASS_RANK
SECONDARY_SCHOOL_REPORTED_GPA	Secondary School Reported Average or GPA	Person's secondary school GPA or Average.	VARCHAR2(63)		SORHSCH	SORHSCH_GPA
SECONDARY_SCHOOL_SIZE	Secondary School Size	Person's class size.	NUMBER		SORHSCH	SORHSCH_CLASS_SIZE
STATE_PROVINCE_ADMIT	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 Province Description Admit	State or province name where the person resided when they were admitted.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
STUDENT_LEVEL	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	Student level description.	VARCHAR2(255)		STVLEVL	STVLEVL_DESC
STUDENT_POPULATION	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 Description	Student population or type description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
STUDENT_RESIDENCY	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 Description	Student residency code description.	VARCHAR2(255)		STVRESD	STVRESD_DESC
SUB_ACADEMIC_PERIOD	Sub Academic Period	A session, portion or part of the academic period.	VARCHAR2(63)		NA	NA
SUB_ACADEMIC_PERIOD_DESC	Sub Academic Period Description	Sub academic period description.	VARCHAR2(255)		NA	NA
TEST1	Test 1	Test score code associated with various tests, i.e., SAT, ACT, placement scores.	VARCHAR2(63)		SORTEST	SORTEST_TESC_CODE
TEST2	Test 2	Test score code associated with various tests, i.e., SAT, ACT, placement scores.	VARCHAR2(63)		SORTEST	SORTEST_TESC_CODE
TEST3	Test 3	Test score code associated with various tests, i.e., SAT, ACT, placement scores.	VARCHAR2(63)		SORTEST	SORTEST_TESC_CODE
TEST4	Test 4	Test score code associated with various tests, i.e., SAT, ACT, placement scores.	VARCHAR2(63)		SORTEST	SORTEST_TESC_CODE
TEST5	Test 5	Test score code associated with various tests, i.e., SAT, ACT, placement scores.	VARCHAR2(63)		SORTEST	SORTEST_TESC_CODE
TEST6	Test 6	Test score code associated with various tests, i.e., SAT, ACT, placement scores.	VARCHAR2(63)		SORTEST	SORTEST_TESC_CODE
TEST7	Test 7	Test score code associated with various tests, i.e., SAT, ACT, placement scores.	VARCHAR2(63)		SORTEST	SORTEST_TESC_CODE
TEST_DESC1	Test Description 1	Test description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
TEST_DESC2	Test Description 2	Test description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
TEST_DESC3	Test Description 3	Test description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
TEST_DESC4	Test Description 4	Test description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
TEST_DESC5	Test Description 5	Test description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
TEST_DESC6	Test Description 6	Test description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
TEST_DESC7	Test Description 7	Test description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
TEST_RULE	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 1	Test score value for this test code, date and person.	VARCHAR2(63)		SORTEST	SORTEST_TEST_SCORE
TEST_SCORE2	Test Score 2	Test score value for this test code, date and person.	VARCHAR2(63)		SORTEST	SORTEST_TEST_SCORE
TEST_SCORE3	Test Score 3	Test score value for this test code, date and person.	VARCHAR2(63)		SORTEST	SORTEST_TEST_SCORE
TEST_SCORE4	Test Score 4	Test score value for this test code, date and person.	VARCHAR2(63)		SORTEST	SORTEST_TEST_SCORE
TEST_SCORE5	Test Score 5	Test score value for this test code, date and person.	VARCHAR2(63)		SORTEST	SORTEST_TEST_SCORE
TEST_SCORE6	Test Score 6	Test score value for this test code, date and person.	VARCHAR2(63)		SORTEST	SORTEST_TEST_SCORE
TEST_SCORE7	Test Score 7	Test score value for this test code, date and person.	VARCHAR2(63)		SORTEST	SORTEST_TEST_SCORE
TRANSFER_CREDIT_ATTEMPTED	Transfer Credit Attempted	Transferred credits attempted.	NUMBER		SHRLGPA	SHRLGPA_HOURS_ATTEMPTED
TRANSFER_CREDIT_EARNED	Transfer Credit Earned	Transferred credits earned.	NUMBER		SHRLGPA	SHRLGPA_HOURS_EARNED
TRANSFER_CREDIT_GPA	Transfer Grade Point Average or Average	Average or Grade Point Average for the credits and grades transferred to this institution.	NUMBER		SHRLGPA	SHRLGPA_GPA
TRANSFER_CREDIT_GPA_CREDIT	Transfer Credits for Grade Point Average or Average	Transferred credits used in the transfer average or grade point average calculation.	NUMBER		SHRLGPA	SHRLGPA_GPA_HOURS
TRANSFER_CREDIT_QUALITY_POINTS	Transfer Credit Quality Points	Transferred quality points.	NUMBER		SHRLGPA	SHRLGPA_QUALITY_POINTS

Ver: 9.0