Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
FINANCIAL_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)	FINAID_APPLICANT_STATUS	AID_YEAR	NO	NO	BANNER COMMUNICATION, FINANCIAL AID APPLICATION, STUDENT, STUDENT PROGRESS
FINANCIAL_AID_YEAR_KEY	Key for the financial aid year dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, STUDENT PROGRESS
FINANCIAL_AID_YEAR_LD	Long description for the financial aid year.	VARCHAR2(255)	FINAID_APPLICANT_STATUS	AID_YEAR_DESC	NO	NO	BANNER COMMUNICATION, FINANCIAL AID APPLICATION, STUDENT, STUDENT PROGRESS
FINANCIAL_AID_YEAR_SD	Short description for the financial aid year.	VARCHAR2(255)	FINAID_APPLICANT_STATUS	AID_YEAR_DESC	NO	NO	BANNER COMMUNICATION, FINANCIAL AID APPLICATION, STUDENT, STUDENT PROGRESS
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	BANNER COMMUNICATION, STUDENT, STUDENT PROGRESS  ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, STUDENT PROGRESS
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	BANNER COMMUNICATION, STUDENT, STUDENT PROGRESS  ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, STUDENT PROGRESS

Ver: 9.0