Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
AWARD_ACCEPTED_IND	Indicator specifies whether or not an award has been accepted by student applicant. The VALUES or 'Y' - has been and 'N' - has not been.	VARCHAR2(63)	AWARD_BY_PERSON ETL_GENERATED	AWARD_ACCEPT_IND NA	NO NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION  FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR
AWARD_CANCELED_IND	Indicator specifies whether or not an award has been canceled for the student applicant. The VALUES or 'Y' - has been and 'N' - has not been.	VARCHAR2(63)	AWARD_BY_PERSON ETL_GENERATED	AWARD_CANCEL_IND NA	NO NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION  FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR
AWARD_DECLINED_IND	Indicator specifies whether or not an award has been declined by the student applicant. The VALUES or 'Y' - has been and 'N' - has not been.	VARCHAR2(63)	AWARD_BY_PERSON ETL_GENERATED	AWARD_DECLINE_IND NA	NO NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION  FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR
AWARD_OFFERED_IND	Indicator specifies whether or not an award has been offered to the student applicant. The VALUES or 'Y' - has been and 'N' - has not been.	VARCHAR2(63)	AWARD_BY_PERSON ETL_GENERATED	AWARD_OFFER_IND NA	NO NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION  FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR
AWARD_PAID_IND	Indicator specifies whether or not an award has been paid to the student applicant. The VALUES or 'Y' - has been and 'N' - has not been.	VARCHAR2(63)	AWARD_BY_PERSON ETL_GENERATED	FUNCTION NA	NO NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION  FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR
DEPENDENT_IND	Indicates whether the applicant is a dependent.	VARCHAR2(63)	ETL_GENERATED	NA	NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COMBINED ADMISSIONS RECORD, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION
FINANCIAL_AID_APPLICANT_IND	Indicates that the person applied for financial aid.	VARCHAR2(63)	ADMISSIONS_APPLICATION ETL_GENERATED RECRUITMENT_INFORMATION	FUNCTION NA FUNCTION	NO NO NO	NO	ADMISSIONS APPLICATION, RECRUITING AND ADMISSION  FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR  ADMISSIONS RECRUITMENT
FINANCIAL_AID_APPLICATION_IND	Indicates whether this person is an applicant for financial aid in this aid year.	VARCHAR2(63)	ETL_GENERATED	NA	NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COMBINED ADMISSIONS RECORD, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION
FINANCIAL_AID_STATUS_KEY	Key for the financial aid status dimension.	NUMBER	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION  FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR
FM_APPLICATION_IND	Indicates whether this person is a FM applicant for financial aid in this aid year.	VARCHAR2(63)	ETL_GENERATED	NA	NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COMBINED ADMISSIONS RECORD, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION
FM_FULLY_MET_NEED_IND	Indicates the applicants FM need has been fully met.	VARCHAR2(63)	ETL_GENERATED	NA	NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COMBINED ADMISSIONS RECORD, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION
FM_NEED_ELIGIBLE_IND	Indicates the applicant is FM need eligible.	VARCHAR2(63)	ETL_GENERATED	NA	NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COMBINED ADMISSIONS RECORD, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION
IM_APPLICATION_IND	Indicates whether this person is an IM applicant for financial aid in this aid year.	VARCHAR2(63)	ETL_GENERATED	NA	NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COMBINED ADMISSIONS RECORD, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION
IM_FULLY_MET_NEED_IND	Indicates the applicants IM need has been fully met.	VARCHAR2(63)	ETL_GENERATED	NA	NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COMBINED ADMISSIONS RECORD, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION
IM_NEED_ELIGIBLE_IND	Indicates the applicant is IM need eligible.	VARCHAR2(63)	ETL_GENERATED	NA	NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, COMBINED ADMISSIONS RECORD, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION  FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION  FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR

Ver: 8.1