Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Academic period associated with this record.	VARCHAR2(63)	FUNCTION	MRKFUNC.F_GET_ACADEMIC_PERIOD
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	FUNCTION	MRKFUNC.F_GET_ACADEMIC_PERIOD
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
AID_PERIOD	Identifies parts of a year that students may be enrolled and receive financial assistance. For example, full year, academic period, etc.	VARCHAR2(63)	FUNCTION	MRKFUNC.F_GET_AID_PERIOD
AID_PERIOD_DESC	Financial Aid period description.	VARCHAR2(255)	FUNCTION	MRKFUNC.F_GET_AID_PERIOD
AID_YEAR	Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005).	VARCHAR2(63)	RRRAREQ	RRRAREQ_AIDY_CODE
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
DISBURSEMENT_REQ_IND	Defines whether a tracking code is required and must be satisfied for disbursement.	VARCHAR2(63)	RRRAREQ	RRRAREQ_DISB_IND
ESTABLISHED_DATE	Date the tracking requirement was established.	DATE	RRRAREQ	RRRAREQ_EST_DATE
FUND	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(63)	RRRAREQ	RRRAREQ_FUND_CODE
FUND_TITLE	Full title of the financial aid fund code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ID	Person's or organization's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
INSTITUTION	Institution from which a financial aid transcript is required.	VARCHAR2(63)	RRRAREQ	RRRAREQ_SBGI_CODE
INSTITUTION_DESC	Source/background institution name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
MEMO_IND	Defines whether the specific tracking requirement code should be satisfied in order for any fund to be credit memo'd.	VARCHAR2(63)	RRRAREQ	RRRAREQ_MEMO_IND
MESSAGE	Code associated with the particular message.	VARCHAR2(63)	RRRTMSG	RRRTMSG_MESG_CODE
MESSAGE_DESC	Message code's description.	VARCHAR2(2000)	RTVMESG	RTVMESG_MESG_DESC
MESSAGE_NUMBER	Maintains an internal one-up system generated sequence number which allows the codes to be displayed in the same order.	NUMBER	RTVMESG	RTVMESG_SEQNO
MORE_SPECIFIC_REQ_IND	Indicates whether additional requirements of the same type exist for the student.	VARCHAR2(1)	FUNCTION	F_MORE_SPECIFIC_REQUIREMENTS
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
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PACKAGING_REQ_IND	Define whether the tracking requirement code must be satisfied in order for any fund to be packaged.	VARCHAR2(63)	RRRAREQ	RRRAREQ_PCKG_IND
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RRRAREQ	RRRAREQ_PIDM
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
REQUIREMENT	Code associated with the tracking requirement.	VARCHAR2(63)	RRRAREQ	RRRAREQ_TREQ_CODE
REQUIREMENT_DESC	Requirement description.	VARCHAR2(255)	FUNCTION RRRAREQ	GOKODSF.F_GET_DESC RRRAREQ_TREQ_DESC
SATISFIED_IND	Indicates whether the tracking requirement code has been satisfied.	VARCHAR2(63)	RRRAREQ	RRRAREQ_SAT_IND
STATUS	Course status code of the most recent change to this tracking requirement. It is a required field. It can be used to prevent creation of sections of the course based on the active/inactive flag associated with the status code.	VARCHAR2(63)	RRRAREQ	RRRAREQ_TRST_CODE
STATUS_DATE	Last date the requirement status was updated.	DATE	RRRAREQ	RRRAREQ_STAT_DATE
STATUS_DESC	Description of the most recent change to this tracking requirement.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
UNSATISFIED_PROM_NOTE_IND	Indicates whether any unsatisfied promissory notes exist for any academic period/ fund.	VARCHAR2(1)	FUNCTION	F_UNSATISFIED_PROM_NOTE

Ver: 8.1