| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
GRADUATION_MULTI_YEAR_KEY
|
Key for graduation multi year dimension.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR1_EXCLUDE_IND
|
Identifies the student should be excluded from the graduation rate calculation for year 1.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR1_EXCLUDE_IND_LD
|
Long description for the indicator the student should be excluded in the year 1 graduation.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR1_EXCLUDE_IND_SD
|
Short description for the indicator the student should be excluded in the year 1 graduation.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR1_GRADUATION_IND
|
Identifies the student graduated within the first attended academic year.
|
NUMBER
|
ACADEMIC_OUTCOME
|
GRADUATED_IND
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR1_GRADUATION_IND_LD
|
Short description that identifies the student completed study and graduated year 1.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR1_GRADUATION_IND_SD
|
Short description that identifies the student completed study and graduated year 1.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR2_EXCLUDE_IND
|
Identifies the student should be excluded from the graduation rate calculation for year 2.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR2_EXCLUDE_IND_LD
|
Long description for the indicator the student should be excluded in the year 2 graduation.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR2_EXCLUDE_IND_SD
|
Short description for the indicator the student should be excluded in the year 2 graduation.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR2_GRADUATION_IND
|
Identifies the student graduated within their second academic year.
|
NUMBER
|
ACADEMIC_OUTCOME
|
GRADUATED_IND
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR2_GRADUATION_IND_LD
|
Short description that identifies the student completed study and graduated year 2.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR2_GRADUATION_IND_SD
|
Short description that identifies the student completed study and graduated year 2.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR3_EXCLUDE_IND
|
Identifies the student should be excluded from the graduation rate calculation for year 3.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR3_EXCLUDE_IND_LD
|
Long description for the indicator the student should be excluded in the year 3 graduation.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR3_EXCLUDE_IND_SD
|
Short description for the indicator the student should be excluded in the year 3 graduation.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR3_GRADUATION_IND
|
Identifies the student graduated within their third academic year.
|
NUMBER
|
ACADEMIC_OUTCOME
|
GRADUATED_IND
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR3_GRADUATION_IND_LD
|
Short description that identifies the student completed study and graduated year 3.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR3_GRADUATION_IND_SD
|
Short description that identifies the student completed study and graduated year 3.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR4_EXCLUDE_IND
|
Identifies the student should be excluded from the graduation rate calculation for year 4.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR4_EXCLUDE_IND_LD
|
Long description for the indicator the student should be excluded in the year 4 graduation.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR4_EXCLUDE_IND_SD
|
Short description for the indicator the student should be excluded in the year 4 graduation.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR4_GRADUATION_IND
|
Identifies the student graduated within their fourth academic year.
|
NUMBER
|
ACADEMIC_OUTCOME
|
GRADUATED_IND
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR4_GRADUATION_IND_LD
|
Short description that identifies the student completed study and graduated year 4.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR4_GRADUATION_IND_SD
|
Short description that identifies the student completed study and graduated year 4.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR5_EXCLUDE_IND
|
Identifies the student should be excluded from the graduation rate calculation for year 5.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR5_EXCLUDE_IND_LD
|
Long description for the indicator the student should be excluded in the year 5 graduation.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR5_EXCLUDE_IND_SD
|
Short description for the indicator the student should be excluded in the year 5 graduation.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR5_GRADUATION_IND
|
Identifies the student graduated within their fifth academic year.
|
NUMBER
|
ACADEMIC_OUTCOME
|
GRADUATED_IND
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR5_GRADUATION_IND_LD
|
Short description that identifies the student completed study and graduated year 5.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR5_GRADUATION_IND_SD
|
Short description that identifies the student completed study and graduated year 5.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR6_EXCLUDE_IND
|
Identifies the student should be excluded from the graduation rate calculation for year 6.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR6_EXCLUDE_IND_LD
|
Long description for the indicator the student should be excluded in the year 6 graduation.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR6_EXCLUDE_IND_SD
|
Short description for the indicator the student should be excluded in the year 6 graduation.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR6_GRADUATION_IND
|
Identifies the student graduated within their sixth academic year.
|
NUMBER
|
ACADEMIC_OUTCOME
|
GRADUATED_IND
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR6_GRADUATION_IND_LD
|
Short description that identifies the student completed study and graduated year 6.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR6_GRADUATION_IND_SD
|
Short description that identifies the student completed study and graduated year 6.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR7_EXCLUDE_IND
|
Identifies the student should be excluded from the graduation rate calculation for year 7.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR7_EXCLUDE_IND_LD
|
Long description for the indicator the student should be excluded in the year 7 graduation.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR7_EXCLUDE_IND_SD
|
Short description for the indicator the student should be excluded in the year 7 graduation.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR7_GRADUATION_IND
|
Identifies the student graduated within their seventh academic year.
|
NUMBER
|
ACADEMIC_OUTCOME
|
GRADUATED_IND
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR7_GRADUATION_IND_LD
|
Short description that identifies the student completed study and graduated year 7.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR7_GRADUATION_IND_SD
|
Short description that identifies the student completed study and graduated year 7.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR8_EXCLUDE_IND
|
Identifies the student should be excluded from the graduation rate calculation for year 8.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR8_EXCLUDE_IND_LD
|
Long description for the indicator the student should be excluded in the year 8 graduation.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR8_EXCLUDE_IND_SD
|
Short description for the indicator the student should be excluded in the year 8 graduation.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR8_GRADUATION_IND
|
Identifies the student graduated within their eighth academic year.
|
NUMBER
|
ACADEMIC_OUTCOME
|
GRADUATED_IND
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR8_GRADUATION_IND_LD
|
Short description that identifies the student completed study and graduated year 8.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR8_GRADUATION_IND_SD
|
Short description that identifies the student completed study and graduated year 8.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|