Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year.	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	Administrative-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
APPLICANT_ACCEPT_IND	This decision code indicates the applicant has accepted the admissions offer.	VARCHAR2(1)	CALCULATION	DECODE(STVAPDC_STDN_ACC_IND)
APPLICATION_INACTIVE_IND	This decision code indicates an inactive application status.	VARCHAR2(1)	CALCULATION	DECODE(STVAPDC_APPL_INACT)
APPLICATION_NUMBER	Application number for the admission application record for a specific academic period.	NUMBER	SARADAP	SARADAP_APPL_NO
APPLICATION_SIGNIF_IND	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	Government reporting category that groups awards and degrees together to count students. For example, Less than 2 yr, 2 yr, Bachelor, etc.	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 associated with this record. Campus for the course section, student course, student, applied for on the admission application, etc.	VARCHAR2(63)	SORLCUR	SORLCUR_CAMP_CODE
CAMPUS_DESC	Institution campus name.	VARCHAR2(255)	STVCAMP	STVCAMP_DESC
CITIZENSHIP_IND	Indicates whether the person is 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	First level of the institution organization structure that owns the student or the academic instruction for a student course.	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
DECISION	Value associated with the application number and decision for this academic period.	VARCHAR2(63)	SARAPPD	SARAPPD_APDC_CODE
DECISION_DATE	Date application decision was applied.	DATE	SARAPPD	SARAPPD_APDC_DATE
DECISION_DESC	Decision code description such as applicant accepted, pending decision, quick admit.	VARCHAR2(255)	SARAPPD	SARAPPD_APDC_CODE
DECISION_NUMBER	Internal decision sequence number associated with this decision for this application number.	NUMBER	SARAPPD	SARAPPD_SEQ_NO
DECISION_SOURCE	Identifies whether this decision is an institution decision or applicant decision.	VARCHAR2(63)	FUNCTION	DECODE(GOKODSF.F_GET_DESC)
DEGREE	Award, degree, diploma, certification upon completion of all the requirements for a particular academic study. For example, Bachelor of Science, Associate of Arts, Vocational Certificate. This information will be taken from the ODS Academic Study or Academic Outcome or Admissions Application reporting view as appropriate for the star scheme.	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 responsible for the major subject area of a student course or associated with the major within the student academic study.	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	Identifies the gender of the person.	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')
GENDER_DESIGNATION	This gender identity of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_GNDR_CODE
GENDER_DESIGNATION_DESC	The description of the gender identity.	VARCHAR2(255)	GTVGNDR	GTVGNDR_GNDR_DESC
HISPANIC_LATINO_ETHNICITY_IND	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	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID
INSTITUTION_ADMIT_IND	This decision code indicates an institution admit status.	VARCHAR2(1)	CALCULATION	DECODE(STVAPDC_INST_ACC_IND)
INSTITUTION_DENIED_IND	This decision code indicates an institution denied status.	VARCHAR2(1)	CALCULATION	DECODE(STVAPDC_REJECT_IND)
INTENDED_TIME_STATUS_DESC	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	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
MAINTAINED_IND	Indicates whether the application decision was maintained by the system or the user.	VARCHAR2(1)	SARAPPD	SARAPPD_MAINT_IND
MAINTENANCE_USER_ID	Identification number of the most recent user to create or update a record.	VARCHAR2(63)	SARAPPD	SARAPPD_USER
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
PERSONAL_PRONOUN	The personal pronoun of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_PPRN_CODE
PERSONAL_PRONOUN_DESC	The description of the personal pronoun.	VARCHAR2(255)	GTVPPRN	GTVPPRN_PPRN_DESC
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	Student's program, curriculum or course of study. This may be Data Not Available when program codes have not been defined by the institution. The alternate curriculum identification is by a combination of college, degree and major codes.	VARCHAR2(63)	SORLCUR	SORLCUR_PROGRAM
PROGRAM_CLASSIFICATION	Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting.	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	Level of study for the students program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, etc.	VARCHAR2(63)	SORLCUR	SORLCUR_LEVL_CODE
STUDENT_LEVEL_DESC	Student level description.	VARCHAR2(255)	STVLEVL	STVLEVL_DESC
STUDENT_POPULATION	Identifies the category this student that will be used for governmental reporting. The typical VALUES are new first time, 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: 9.1