Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ADDITIONAL_PELL_AWARDS	Additional Pell Awards		VARCHAR2(1)
ADDITIONAL_PELL_AWARDS_DESC	Additional Pell Awards Description		VARCHAR2(30)
ADDITIONAL_STAFFORD_AWARDS	Additional Stafford Awards		VARCHAR2(1)
ADDITIONAL_STAFFORD_AWRDS_DESC	Additional Stafford Awrds Description		VARCHAR2(30)
AID_PERIOD		Identifies parts of a year that students may be enrolled and receive financial assistance. For example, full year, academic period, etc.	VARCHAR2(6)		RORSTAT	RORSTAT_APRD_CODE
AID_PERIOD_DESC		Financial Aid period description.	VARCHAR2(30)		RTVAPRD	RTVAPRD_DESC
AID_YEAR		Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005).	VARCHAR2(4)		RORSTAT	RORSTAT_AIDY_CODE
AID_YEAR_DESC		Financial aid year name.	VARCHAR2(30)		ROBINST	ROBINST_AIDY_DESC
ALL_REQUIRE_COMPLETE_DATE		Date on which all tracking requirements for this applicant were satisfied.	DATE		RORSTAT	RORSTAT_ALL_REQ_COMP_DATE
APPLICATION_LOCKED_IND		Indicates whether the student's financial aid application record is locked.	VARCHAR2(1)		RORSTAT	RORSTAT_LOCK_IND
APPLICATION_RECEIVED_DATE	Application Received Date		DATE
BUDGET_GROUP		Student's assigned budget group.	VARCHAR2(6)		RORSTAT	RORSTAT_BGRP_CODE
BUDGET_GROUP_DESC		Budget group code description. Identifies what it represents.	VARCHAR2(30)		RTVBGRP	RTVBGRP_DESC
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DEPENDENT_NO_PARENT_DATA	Dependent Number Parent Data		VARCHAR2(1)
DEPENDENT_NO_PARENT_DATA_DESC	Dependent Number Parent Data Description		VARCHAR2(30)
DISBURSE_REQUIRE_COMPLETE_DATE		Date that all tracking requirements mandatory for disbursement were satisfied for the particular student.	DATE		RORSTAT	RORSTAT_DISB_REQ_COMP_DATE
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
FINAID_APPLICANT_IND		Indicates if this person has a financial aid status or RORSTAT record identifying them as a financial aid applicant for the aid year.	VARCHAR2(1)		FUNCTION	F_FINAID_APPLICANT_IND
FINANCIAL_AID_APPLICATION_IND	Financial Financial Aid Application Indicator		VARCHAR2(1)
FM_APPLICATION_IND	Federal Method Application Indicator		CHAR(1)
FM_BATCH_LOCK_IND		Determines if the FM data for this person is locked from any updating by the batch tape load process. (Y)es, it is locked, (N)o it is not locked.	VARCHAR2(1)		RORSTAT	RORSTAT_FM_BATCH_LOCK
IM_APPLICATION_IND	Institution Method Application Indicator		CHAR(1)
IM_BATCH_LOCK_IND		Determines if the IM data for this person is locked from any updating by the batch tape load process. (Y)es it is locked for update, (N)o it is not locked for update.	VARCHAR2(1)		RORSTAT	RORSTAT_IM_BATCH_LOCK
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
PACKAGE_COMPLETE_DATE		Date the student's financial aid package was complete.	DATE		RORSTAT	RORSTAT_PCKG_COMP_DATE
PACKAGE_REQUIRE_COMPLETE_DATE		Date that tracking requirements were satisfied for packaging.	DATE		RORSTAT	RORSTAT_PCKG_REQ_COMP_DATE
PACKAGING_GROUP		Assigned packaging group for this financial aid applicant.	VARCHAR2(6)		RORSTAT	RORSTAT_PGRP_CODE
PACKAGING_GROUP_DESC		Code description assigned to the packaging group.	VARCHAR2(30)		RTVPGRP	RTVPGRP_DESC
PERSON_UID		System generated, unique, internal identification number assigned to this person.	NUMBER(8)		RORSTAT	RORSTAT_PIDM
TRACKING_GROUP		Assigned tracking group for this financial aid applicant.	VARCHAR2(6)		RORSTAT	RORSTAT_TGRP_CODE
TRACKING_GROUP_DESC		Tracking group code description.	VARCHAR2(30)		RTVTGRP	RTVTGRP_DESC
VERIFICATION_COMPLETE_DATE		Date the verification has been completed.	DATE		NA	NA
VERIFICATION_COMPLETE_IND		Specifies whether the verification has been completed.	VARCHAR2(1)		RORSTAT	RORSTAT_VER_COMPLETE
VERIFICATION_REQUIRED_IND		Specifies whether verification is required.	VARCHAR2(1)		RCRAPP1	RCRAPP1_VERIFICATION_MSG
VERIFICATION_TRANSACTION_NO		Transaction number of the verification.	VARCHAR2(2)		RORSTAT	RORSTAT_SAR_TRAN_NO
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: