Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD		VARCHAR2(6)
AID_ENROLLMENT_PERIOD		VARCHAR2(15)
AID_YEAR	Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation.	VARCHAR2(4)	RRRAREQ	RRRAREQ_AIDY_CODE
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DISBURSEMENT_REQ_IND	Defines whether a tracking code is required and must be satisfied for disbursement.	VARCHAR2(1)	RRRAREQ	RRRAREQ_DISB_IND
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
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(6)	RRRAREQ	RRRAREQ_FUND_CODE
FUND_TITLE	Full title of the financial aid fund code.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
INSTITUTION	Designates the institution from which a financial aid transcript is required.	VARCHAR2(6)	RRRAREQ	RRRAREQ_SBGI_CODE
INSTITUTION_DESC	Source/background institution name.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
INSTITUTION_TYPE		VARCHAR2(1)
INSTITUTION_TYPE_DESC		VARCHAR2(30)
MEMO_IND	Defines whether the specific tracking requirement code should be satisfied in order for any fund to be credit memo'd.	VARCHAR2(1)	RRRAREQ	RRRAREQ_MEMO_IND
MESSAGE	Code associated with the particular message.	VARCHAR2(4)	RRRTMSG	RRRTMSG_MESG_CODE
MESSAGE_DESC	Description of the particular message codes.	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
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
MORE_SPECIFIC_REQ_IND	Indicates whether additional requirements of the same type exist for the student.	VARCHAR2(1)	FUNCTION	F_MORE_SPECIFIC_REQUIREMENTS
PACKAGING_REQ_IND	Used to define whether the tracking requirement code must be satisfied in order for any fund to be packaged.	VARCHAR2(1)	RRRAREQ	RRRAREQ_PCKG_IND
PERKINS_EXPIRATION_DATE		DATE
PERKINS_FIRST_DISBURSE_DATE		DATE
PERKINS_SATISFIED_DATE		DATE
PERKINS_SIGNED_DATE		DATE
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RRRAREQ	RRRAREQ_PIDM
REQUIREMENT	Code associated with the tracking requirement.	VARCHAR2(6)	RRRAREQ	RRRAREQ_TREQ_CODE
REQUIREMENT_ACTIVITY_DATE		DATE
REQUIREMENT_DATA_ORIGIN		VARCHAR2(30)
REQUIREMENT_DESC	Requirement description.	VARCHAR2(60)	FUNCTION RRRAREQ	GOKODSF.F_GET_DESC RRRAREQ_TREQ_DESC
REQUIREMENT_SOURCE		VARCHAR2(1)
REQUIREMENT_SOURCE_DESC		VARCHAR2(32)
REQUIREMENT_USER_ID		VARCHAR2(30)
SATISFIED_IND	Indicates whether the tracking requirement code has been satisfied.	VARCHAR2(1)	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(1)	RRRAREQ	RRRAREQ_TRST_CODE
STATUS_DATE	Last date on which the status of this requirement was updated.	DATE	RRRAREQ	RRRAREQ_STAT_DATE
STATUS_DESC	Description of the most recent change to this tracking requirement.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
TRACKING_LETTER_IND		VARCHAR2(1)
UNSATISFIED_PROM_NOTE_IND	Indicates whether any unsatisfied promissory notes exist for any academic period/ fund.	VARCHAR2(1)	FUNCTION	F_UNSATISFIED_PROM_NOTE
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: