Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
NOT_RETAINED_COLLEGE_IND
|
Indicates whether the student was not retained within college for the next like or sequential academic period.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
NOT_RETAINED_COLLEGE_IND_LD
|
Long description for the not retention within college indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
NOT_RETAINED_COLLEGE_IND_SD
|
Short description for the not retention within college indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
NOT_RETAINED_OVERALL_IND
|
Indicates whether the student was not retained by the institution for the next like or sequential academic period.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
NOT_RETAINED_OVERALL_IND_LD
|
Long description for the not retention indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
NOT_RETAINED_OVERALL_IND_SD
|
Short description for the not retention indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
NOT_RETAINED_PROGRAM_IND
|
Indicates whether the student was not retained within program for the next like or sequential academic period.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
NOT_RETAINED_PROGRAM_IND_LD
|
Long description for the not retention within program indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
NOT_RETAINED_PROGRAM_IND_SD
|
Short description for the not retention within program indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
NOT_RETAINED_STDLEVL_IND
|
Indicates whether the student was not retained within student level for the next like or sequential academic period.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
NOT_RETAINED_STDLEVL_IND_LD
|
Long description for the not retention within student level indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
NOT_RETAINED_STDLEVL_IND_SD
|
Short description for the not retention within student level indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
RETAINED_COLLEGE_IND
|
Indicates whether the student was retained within the same college for the next like or sequential academic period.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
RETAINED_COLLEGE_IND_LD
|
Long description for the retention within college indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
RETAINED_COLLEGE_IND_SD
|
Short description for the retention within college indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
RETAINED_EXCLUDE_IND
|
Indicates the student should not be included in any of the retention counts. Persons are excluded as legitimate exceptions either by a student status or enrollment status, by graduation or death.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
RETAINED_EXCLUDE_IND_LD
|
Long description for the excluded retention indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
RETAINED_EXCLUDE_IND_SD
|
Short description for the excluded retention indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
RETAINED_OVERALL_IND
|
Indicates whether the student was retained by the institution for the next like or sequential academic period.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
RETAINED_OVERALL_IND_LD
|
Long description for the retention indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
RETAINED_OVERALL_IND_SD
|
Short description for the retention indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
RETAINED_PROGRAM_IND
|
Indicates whether the student was retained within the same program for the next like or sequential academic period.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
RETAINED_PROGRAM_IND_LD
|
Long description for the retention within program indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
RETAINED_PROGRAM_IND_SD
|
Short description for the retention within program indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
RETAINED_STDLEVL_IND
|
Indicates whether the student was retained within the same student level for the next like or sequential academic period.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
RETAINED_STDLEVL_IND_LD
|
Long description for the retention within student level indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
RETAINED_STDLEVL_IND_SD
|
Short description for the retention within student level indicator.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
RETENTION_KEY
|
Key for the retention dimension.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
STUDENT PROGRESS
|
RETENTION_STATUS_COLLEGE
|
Retention status that determined from the retained, not retained and excluded indicators within the college. The values may be R = Retained, NR = Not Retained or E = Excluded. For each academic period like or sequential the student will be only one of these values.
|
VARCHAR2(63)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
RETENTION_STATUS_COLLEGE_LD
|
Long description for the retention status within the college.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
RETENTION_STATUS_COLLEGE_SD
|
Short description for the retention status within the college.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
RETENTION_STATUS_OVERALL
|
Retention status that determined from the retained, not retained and excluded indicators. The values may be R = Retained, NR = Not Retained or E = Excluded. For each academic period like or sequential the student will be only one of these values.
|
VARCHAR2(63)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
RETENTION_STATUS_OVERALL_LD
|
Long description for the retention status.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
RETENTION_STATUS_OVERALL_SD
|
Short description for the retention status.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
RETENTION_STATUS_PROGRAM
|
Retention status that determined from the retained, not retained and excluded indicators within the program. The values may be R = Retained, NR = Not Retained or E = Excluded. For each academic period like or sequential the student will be only one of these values.
|
VARCHAR2(63)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
RETENTION_STATUS_PROGRAM_LD
|
Long description for the retention status within the program.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
RETENTION_STATUS_PROGRAM_SD
|
Short description for the retention status within the program.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
RETENTION_STATUS_STDLEVL
|
Retention status that determined from the retained, not retained and excluded indicators within the student level. The values may be R = Retained, NR = Not Retained or E = Excluded. For each academic period like or sequential the student will be only one of these values.
|
VARCHAR2(63)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
RETENTION_STATUS_STDLEVL_LD
|
Long description for the retention status within the student level.
|
VARCHAR2(255)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
STUDENT, STUDENT PROGRESS
|
RETENTION_STATUS_STDLEVL_SD
|
Short description for the retention status within the student level.
|
VARCHAR2(255)
|
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
|
STUDENT, STUDENT PROGRESS STUDENT PROGRESS
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL GENERATED ETL_GENERATED
|
NA NA
|
NO NO
|
NO
|
STUDENT, STUDENT PROGRESS STUDENT PROGRESS
|