Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACADEMIC_PERIOD	Academic period representing the accounts receivable term for disbursement from the applicant award schedule table.	VARCHAR2(63)	RPRATRM	RPRATRM_TERM_CODE	NO	NO
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC	NO	NO
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(63)	STVTERM	STVTERM_ACYR_CODE	NO	NO
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ACCEPT_AMOUNT	Amount accepted by the student for the indicated financial aid fund for this aid year.	NUMBER	RPRAWRD	RPRAWRD_ACCEPT_AMT	NO	NO
ACTIVITY1	Activity code that represents official participation in a sport that was defined per the display rules for sport activities. Institution defined.	VARCHAR2(63)	SGRSPRT	SGRSPRT_ACTC_CODE	NO	NO
ACTIVITY2	Activity code that represents official participation in a sport that was defined per the display rules for sport activities. Institution defined.	VARCHAR2(63)	SGRSPRT	SGRSPRT_ACTC_CODE	NO	NO
ACTIVITY3	Activity code that represents official participation in a sport that was defined per the display rules for sport activities. Institution defined.	VARCHAR2(63)	SGRSPRT	SGRSPRT_ACTC_CODE	NO	NO
ACTIVITY4	Activity code that represents official participation in a sport that was defined per the display rules for sport activities. Institution defined.	VARCHAR2(63)	SGRSPRT	SGRSPRT_ACTC_CODE	NO	NO
ACTIVITY5	Activity code that represents official participation in a sport that was defined per the display rules for sport activities. Institution defined.	VARCHAR2(63)	SGRSPRT	SGRSPRT_ACTC_CODE	NO	NO
ACTIVITY_DESC1	Activity code that represents the sport participation.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ACTIVITY_DESC2	Activity code that represents the sport participation.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ACTIVITY_DESC3	Activity code that represents the sport participation.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ACTIVITY_DESC4	Activity code that represents the sport participation.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ACTIVITY_DESC5	Activity code that represents the sport participation.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
AGE	Calculated age (subtract the birth date from the current system date).	NUMBER	FUNCTION	F_CALCULATE_AGE	NO	NO
AID_ENROLLMENT_PERIOD	Aid enrollment period associated with the award schedule. This period can span multiple student terms.	VARCHAR2(63)	RPRATRM	RPRATRM_PERIOD	NO	NO
AID_ENROLLMENT_PERIOD_DESC	Aid enrollment period description.	VARCHAR2(255)	ROBPRDS	ROBPRDS_DESC	NO	NO
AID_PERIOD	Represents a financial aid period or portion of an aid year associated. Aid periods can be a single academic period or set of them as appropriate for tracking the aid awarded, accepted, paid, etc.	VARCHAR2(63)	RPRATRM	RPRATRM_AIDY_CODE	NO	NO
AID_PERIOD_DESC	Financial Aid period description.	VARCHAR2(255)	RTVAPRD	RTVAPRD_DESC	NO	NO
AID_YEAR	Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation.	VARCHAR2(63)	RPRAWRD	RPRAWRD_AIDY_CODE	NO	NO
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(255)	ROBINST	ROBINST_AIDY_DESC	NO	NO
ATHLETIC_AID_IND1	Indicates whether the person is receiving sport athletic scholarship or aid for this sport activity.	VARCHAR2(1)	SGRSPRT	SGRSPRT_ATHL_AID_IND	NO	NO
ATHLETIC_AID_IND2	Indicates whether the person is receiving sport athletic scholarship or aid for this sport activity.	VARCHAR2(1)	SGRSPRT	SGRSPRT_ATHL_AID_IND	NO	NO
ATHLETIC_AID_IND3	Indicates whether the person is receiving sport athletic scholarship or aid for this sport activity.	VARCHAR2(1)	SGRSPRT	SGRSPRT_ATHL_AID_IND	NO	NO
ATHLETIC_AID_IND4	Indicates whether the person is receiving sport athletic scholarship or aid for this sport activity.	VARCHAR2(1)	SGRSPRT	SGRSPRT_ATHL_AID_IND	NO	NO
ATHLETIC_AID_IND5	Indicates whether the person is receiving sport athletic scholarship or aid for this sport activity.	VARCHAR2(1)	SGRSPRT	SGRSPRT_ATHL_AID_IND	NO	NO
BIRTH_DATE	Date of birth for the person.	DATE	SPBPERS	SPBPERS_BIRTH_DATE	NO	NO
COHORT1	Cohort tracking group assigned to the person through the Administrative UI display rules.	VARCHAR2(63)	SGRCHRT	SGRCHRT_CHRT_CODE	NO	NO
COHORT2	Cohort tracking group assigned to the person through the Administrative UI display rules.	VARCHAR2(63)	SGRCHRT	SGRCHRT_CHRT_CODE	NO	NO
COHORT3	Cohort tracking group assigned to the person through the Administrative UI display rules.	VARCHAR2(63)	SGRCHRT	SGRCHRT_CHRT_CODE	NO	NO
COHORT_DESC1	Cohort tracking group description assigned to the person.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
COHORT_DESC2	Cohort tracking group description assigned to the person.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
COHORT_DESC3	Cohort tracking group description assigned to the person.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
COHORT_RULE	Display rule set up in MGRSDAX that determines which cohort values are displayed for this person. Institution defined.	VARCHAR2(63)	MGRSDAX	MGRSDAX_INTERNAL_CODE	NO	NO
DECLINE_AMOUNT	Total amount of this fund declined by the student's for this aid year.	NUMBER	RPRAWRD	RPRAWRD_DECLINE_AMT	NO	NO
DISBURSED_AMT	Financial aid award sum disbursed for the time frame with a fund source type indicator equal to federal, and a fund type indicator equal to grant.	NUMBER	FUNCTION	ROKODSF.F_GET_TOTAL_DISBURSED	NO	NO
ELIGIBILITY1	Indicates eligibility to officially participate in this sport as identified in the display rules.	VARCHAR2(63)	SGRSPRT	SGRSPRT_ELIG_CODE	NO	NO
ELIGIBILITY2	Indicates eligibility to officially participate in this sport as identified in the display rules.	VARCHAR2(63)	SGRSPRT	SGRSPRT_ELIG_CODE	NO	NO
ELIGIBILITY3	Indicates eligibility to officially participate in this sport as identified in the display rules.	VARCHAR2(63)	SGRSPRT	SGRSPRT_ELIG_CODE	NO	NO
ELIGIBILITY4	Indicates eligibility to officially participate in this sport as identified in the display rules.	VARCHAR2(63)	SGRSPRT	SGRSPRT_ELIG_CODE	NO	NO
ELIGIBILITY5	Indicates eligibility to officially participate in this sport as identified in the display rules.	VARCHAR2(63)	SGRSPRT	SGRSPRT_ELIG_CODE	NO	NO
FINANCIAL_AID_TYPE	Aid fund type code defined as one of the following grant, loan, scholarship or grant for the aid fund.	VARCHAR2(63)	RTVFTYP	RTVFTYP_ATYP_IND	NO	NO
FINANCIAL_AID_TYPE_DESC	Financial aid type description.	VARCHAR2(255)	RTVFTYP	RTVFTYP_DESC	NO	NO
FIRST_NAME	Person's first or given name.	VARCHAR2(63)	SPRIDEN	SPRIDEN_FIRST_NAME	NO	NO
FUND	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(63)	RPRADSB	RPRADSB_FUND_CODE	NO	NO
FUND_SOURCE_TYPE	Identifies the source of the financial assistance.	VARCHAR2(63)	RFRBASE	RFRBASE_FSRC_CODE	NO	NO
FUND_SOURCE_TYPE_DESC	Financial assistance sources descriptions. For example, External, Federal, Institutional, State or Other.	VARCHAR2(255)	RTVFSRC	RTVFSRC_DESC	NO	NO
FUND_TITLE	Descriptive title for the fund.	VARCHAR2(255)	RFRBASE	RFRBASE_FUND_TITLE	NO	NO
GENDER	Identifies the gender of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_SEX	NO	NO
GENDER_DESC	Identify as Male, Female or Not reported.	VARCHAR2(63)	CALCULATION	DECODE(SPBPERS_SEX,'M','MALE','F','FEMALE','N','NOT REPORTED')	NO	NO
GENDER_DESIGNATION	This gender identity of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_GNDR_CODE	NO	NO
GENDER_DESIGNATION_DESC	The description of the gender identity.	VARCHAR2(255)	GTVGNDR	GTVGNDR_GNDR_DESC	NO	NO
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_CODE	NO	NO
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID	NO	NO
LAST_ACADEMIC_PERIOD	Last academic period the student attended the institution.	VARCHAR2(63)	FUNCTION	MSKFUNC.F_GET_LAST_ACADEMIC_PERIOD	NO	NO
LAST_NAME	Last name.	VARCHAR2(63)	SPRIDEN	SPRIDEN_LAST_NAME	NO	NO
MIDDLE_NAME	Middle name.	VARCHAR2(63)	SPRIDEN	SPRIDEN_MI	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
OFFER_AMOUNT	Maintains the current amount of the award fund offered.	NUMBER	RPRAWRD	RPRAWRD_OFFER_AMT	NO	NO
PAID_AMOUNT	Total amount offered and then paid from this fund.	NUMBER	RPRAWRD	RPRAWRD_PAID_AMT	NO	NO
PERSONAL_PRONOUN	The personal pronoun of the person.	VARCHAR2(63)	SPBPERS	SPBPERS_PPRN_CODE	NO	NO
PERSONAL_PRONOUN_DESC	The description of the personal pronoun.	VARCHAR2(255)	GTVPPRN	GTVPPRN_PPRN_DESC	NO	NO
PERSON_UID	Internally generated by the system to uniquely identify the person or entity.	NUMBER	SGBSTDN	SGBSTDN_PIDM	NO	NO
PRIMARY_ETHNICITY	Person's reported ethnicity.	VARCHAR2(63)	SPBPERS	SPBPERS_ETHN_CODE	NO	NO
PRIMARY_ETHNICITY_DESC	Ethnic code description.	VARCHAR2(255)	STVETHN	STVETHN_DESC	NO	NO
PRIM_ETHNICITY_CATEGORY	Person's reported ethnicity.	VARCHAR2(63)	SPBPERS	SPBPERS_ETHN_CODE	NO	NO
PRIM_ETHNICITY_CATEGORY_DESC	Ethnic Code Description.	VARCHAR2(255)	STVETHN	STVETHN_DESC	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
RACE_CATEGORY_COUNT	Number of unique regulatory races selected by this person.	NUMBER	FUNCTION	MGKFUNC.F_COUNT_RACE_CATEGORY	NO	NO
RACE_COUNT	Number of races selected by this person.	NUMBER	FUNCTION	MGKFUNC.F_COUNT_RACE	NO	NO
RACE_ETHNICITY_CONFIRM_DATE	Race and ethnicity self confirmed date.	DATE	SPBPERS	SPBPERS_CONFIRMED_RE_DATE	NO	NO
RACE_ETHNICITY_CONFIRM_IND	Indicates if the person's race and ethnicity have been self-identified.	VARCHAR2(1)	SPBPERS	SPBPERS_CONFIRMED_RE_CDE	NO	NO
SPORT_STATUS1	Current status for the sport participation for the sport selected in the display rules.	VARCHAR2(63)	SGRSPRT	SGRSPRT_SPST_CODE	NO	NO
SPORT_STATUS2	Current status for the sport participation for the sport selected in the display rules.	VARCHAR2(63)	SGRSPRT	SGRSPRT_SPST_CODE	NO	NO
SPORT_STATUS3	Current status for the sport participation for the sport selected in the display rules.	VARCHAR2(63)	SGRSPRT	SGRSPRT_SPST_CODE	NO	NO
SPORT_STATUS4	Current status for the sport participation for the sport selected in the display rules.	VARCHAR2(63)	SGRSPRT	SGRSPRT_SPST_CODE	NO	NO
SPORT_STATUS5	Current status for the sport participation for the sport selected in the display rules.	VARCHAR2(63)	SGRSPRT	SGRSPRT_SPST_CODE	NO	NO
SPORT_STATUS_DESC1	Student participation status description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
SPORT_STATUS_DESC2	Student participation status description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
SPORT_STATUS_DESC3	Student participation status description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
SPORT_STATUS_DESC4	Student participation status description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
SPORT_STATUS_DESC5	Student participation status description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
STUDENT_ACADEMIC_PERIOD	Academic period representing the term to pull the student data used for the aid enrollment period. As an example, student classification, or student.	VARCHAR2(63)	RORPRDS	RORPRDS_TERM_CODE	NO	NO
STUDENT_ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC	NO	NO
STUDENT_LEVEL	Level of study for the students program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, etc.	VARCHAR2(63)	SGBSTDN SORLCUR	SGBSTDN_LEVL_CODE SORLCUR_LEVL_CODE	NO NO	NO
STUDENT_LEVEL_DESC	Level name associated with the academic study for which the student applied. For example, undergraduate, graduate, etc.	VARCHAR2(255)	STVLEVL	STVLEVL_DESC	NO	NO
TAX_ID	Person's tax identification number assigned by their home federal government.	VARCHAR2(63)	SPBPERS	SPBPERS_SSN	NO	NO
TOTAL_CREDITS	Total credits for the student for this academic period.	NUMBER	FUNCTION	F_GET_SUM_TOTAL_CREDITS_BY_AEP	NO	NO

Ver: 9.2