Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
AWARD_ACCEPTED_IND
|
Indicates the current award accepted amount has a value greater than zero.
|
VARCHAR2(63)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
AWARD_CANCELED_IND
|
Indicates the current award canceled amount has a value greater than zero.
|
VARCHAR2(63)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
AWARD_DECLINED_IND
|
Indicates the current award declined amount has a value greater than zero.
|
VARCHAR2(63)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
AWARD_OFFERED_IND
|
Indicates the current award offered amount has a value greater than zero.
|
VARCHAR2(63)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
AWARD_PAID_IND
|
Indicates the current award paid amount has a value greater than zero.
|
VARCHAR2(63)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
DEPENDENT_IND
|
Indicates whether the applicant is a dependent.
|
VARCHAR2(63)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
FINANCIAL_AID_APPLICANT_IND
|
Indicates whether this person has a financial aid status record in this aid year.
|
VARCHAR2(63)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
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
|
STUDENT, STUDENT PROGRESS
|
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, STUDENT, STUDENT PROGRESS FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, STUDENT PROGRESS
|
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
|
STUDENT, STUDENT PROGRESS
|
FM_FULLY_MET_NEED_IND
|
Indicates the applicants FM need has been fully met.
|
VARCHAR2(63)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
FM_NEED_ELIGIBLE_IND
|
Indicates the applicant is FM need eligible.
|
VARCHAR2(63)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
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
|
STUDENT, STUDENT PROGRESS
|
IM_FULLY_MET_NEED_IND
|
Indicates the applicants IM need has been fully met.
|
VARCHAR2(63)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
IM_NEED_ELIGIBLE_IND
|
Indicates the applicant is IM need eligible.
|
VARCHAR2(63)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
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
|
ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS 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
|
ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, FINANCIAL AID PRE STUDENT, RECRUITING AND ADMISSION, STUDENT, STUDENT PROGRESS FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, STUDENT PROGRESS
|