| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
RETENTION_MULTI_YEAR_KEY
|
Key of the retention 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
|
|
YEAR2_EXCLUDE_IND
|
Indicates the student has either a student status or an enrollment status that identified the student to be excluded for year 2.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR2_EXCLUDE_IND_LD
|
Long description for the 2 year excluded indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR2_EXCLUDE_IND_SD
|
Short description for the 2 year excluded indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR2_NOT_RETAINED_IND
|
Indicates the student did not registered and was not retained to year 2.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR2_NOT_RETAINED_IND_LD
|
Long description for the 2 year not retained indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR2_NOT_RETAINED_IND_SD
|
Short description for the 2 year not retained indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR2_RETAINED_IND
|
Indicates the student registered and was retained to year 2.
|
NUMBER
|
ENROLLMENT
|
ENROLLED_IND
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR2_RETAINED_IND_LD
|
Long description for the 2 year retained indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR2_RETAINED_IND_SD
|
Short description for the 2 year retained indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR3_EXCLUDE_IND
|
Indicates the student has either a student status or an enrollment status that identified the student to be excluded for year 3.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR3_EXCLUDE_IND_LD
|
Long description for the 3 year excluded indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR3_EXCLUDE_IND_SD
|
Short description for the 3 year excluded indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR3_NOT_RETAINED_IND
|
Indicates the student did not registered and was not retained to year 3.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR3_NOT_RETAINED_IND_LD
|
Long description for the 3 year not retained indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR3_NOT_RETAINED_IND_SD
|
Short description for the 3 year not retained indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR3_RETAINED_IND
|
Indicates the student registered and was retained to year 3.
|
NUMBER
|
ENROLLMENT
|
ENROLLED_IND
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR3_RETAINED_IND_LD
|
Long description for the 3 year retained indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR3_RETAINED_IND_SD
|
Short description for the 3 year retained indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR4_EXCLUDE_IND
|
Indicates the student has either a student status or an enrollment status that identified the student to be excluded for year 4.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR4_EXCLUDE_IND_LD
|
Long description for the 4 year excluded indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR4_EXCLUDE_IND_SD
|
Short description for the 4 year excluded indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR4_NOT_RETAINED_IND
|
Indicates the student did not registered and was not retained to year 4.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR4_NOT_RETAINED_IND_LD
|
Long description for the 4 year not retained indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR4_NOT_RETAINED_IND_SD
|
Short description for the 4 year not retained indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR4_RETAINED_IND
|
Indicates the student registered and was retained to year 4.
|
NUMBER
|
ENROLLMENT
|
ENROLLED_IND
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR4_RETAINED_IND_LD
|
Long description for the 4 year retained indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR4_RETAINED_IND_SD
|
Short description for the 4 year retained indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR5_EXCLUDE_IND
|
Indicates the student has either a student status or an enrollment status that identified the student to be excluded for year 5.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR5_EXCLUDE_IND_LD
|
Long description for the 5 year excluded indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR5_EXCLUDE_IND_SD
|
Short description for the 5 year excluded indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR5_NOT_RETAINED_IND
|
Indicates the student did not registered and was not retained to year 5.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR5_NOT_RETAINED_IND_LD
|
Long description for the 5 year not retained indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR5_NOT_RETAINED_IND_SD
|
Short description for the 5 year not retained indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR5_RETAINED_IND
|
Indicates the student registered and was retained to year 5.
|
NUMBER
|
ENROLLMENT
|
ENROLLED_IND
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR5_RETAINED_IND_LD
|
Long description for the 5 year retained indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR5_RETAINED_IND_SD
|
Short description for the 5 year retained indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR6_EXCLUDE_IND
|
Indicates the student has either a student status or an enrollment status that identified the student to be excluded for year 6.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR6_EXCLUDE_IND_LD
|
Long description for the 6 year excluded indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR6_EXCLUDE_IND_SD
|
Short description for the 6 year excluded indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR6_NOT_RETAINED_IND
|
Indicates the student did not registered and was not retained to year 6.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR6_NOT_RETAINED_IND_LD
|
Long description for the 6 year not retained indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR6_NOT_RETAINED_IND_SD
|
Short description for the 6 year not retained indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR6_RETAINED_IND
|
Indicates the student registered and was retained to year 6.
|
NUMBER
|
ENROLLMENT
|
ENROLLED_IND
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR6_RETAINED_IND_LD
|
Long description for the 6 year retained indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR6_RETAINED_IND_SD
|
Short description for the 6 year retained indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR7_EXCLUDE_IND
|
Indicates the student has either a student status or an enrollment status that identified the student to be excluded for year 7.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR7_EXCLUDE_IND_LD
|
Long description for the 7 year excluded indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR7_EXCLUDE_IND_SD
|
Short description for the 7 year excluded indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR7_NOT_RETAINED_IND
|
Indicates the student did not registered and was not retained to year 7.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR7_NOT_RETAINED_IND_LD
|
Long description for the 7 year not retained indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR7_NOT_RETAINED_IND_SD
|
Short description for the 7 year not retained indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR7_RETAINED_IND
|
Indicates the student registered and was retained to year 7.
|
NUMBER
|
ENROLLMENT
|
ENROLLED_IND
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR7_RETAINED_IND_LD
|
Long description for the 7 year retained indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR7_RETAINED_IND_SD
|
Short description for the 7 year retained indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR8_EXCLUDE_IND
|
Indicates the student has either a student status or an enrollment status that identified the student to be excluded for year 8.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR8_EXCLUDE_IND_LD
|
Long description for the 8 year excluded indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR8_EXCLUDE_IND_SD
|
Short description for the 8 year excluded indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR8_NOT_RETAINED_IND
|
Indicates the student did not registered and was not retained to year 8.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR8_NOT_RETAINED_IND_LD
|
Long description for the 8 year not retained indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR8_NOT_RETAINED_IND_SD
|
Short description for the 8 year not retained indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR8_RETAINED_IND
|
Indicates the student registered and was retained to year 8.
|
NUMBER
|
ENROLLMENT
|
ENROLLED_IND
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR8_RETAINED_IND_LD
|
Long description for the 8 year retained indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|
|
YEAR8_RETAINED_IND_SD
|
Short description for the 8 year retained indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
RETENTION MULTI YEAR, STUDENT PROGRESS
|