| RETURN TO BANNER EDW META DATA REPORTS LIST | |
| Student Star Student Progress Star |
Description
| Student Performance Dimension table provides information for the person that includes basic academic standing and achievement coded values assigned to the student. This information includes academic standing, overrides, dean's list, etc.. It uses the cleansing rules in the EDW for the short and long descriptions. | |
| Target Column | Business Definition | Database Data Type | Source Name | Source Column | Local Source | Local Target | Star Name |
|---|---|---|---|---|---|---|---|
| ACADEMIC_STANDING | Represents the beginning academic standing for the student as determined after the grades are processed for the academic period. Indicates the student may continue to enroll or must seek assistance prior to continuing to study at the institution. This value will be'good standing' when the student is new to the institution and no academic standing value exists either on the override academic standing on the student record or on the history record for an academic period. | VARCHAR2(63) |
NO | NO | STUDENT, STUDENT PROGRESS | ||
| ACADEMIC_STANDING_END | Represents the end academic standing for the student as determined by processing all final grades for the academic period. Indicates the student may continue to enroll or must seek assistance prior to continuing to study at the institution. This value will always be associated with the student on their history record for the reporting academic period. | VARCHAR2(63) |
NO | NO | STUDENT, STUDENT PROGRESS | ||
| ACADEMIC_STANDING_END_LD | Long description for the academic standing. | VARCHAR2(255) |
NO | NO | STUDENT, STUDENT PROGRESS | ||
| ACADEMIC_STANDING_END_SD | Short description for the academic standing. | VARCHAR2(255) |
NO | NO | STUDENT, STUDENT PROGRESS | ||
| ACADEMIC_STANDING_LD | Long description for the academic standing. | VARCHAR2(255) |
NO | NO | STUDENT, STUDENT PROGRESS | ||
| ACADEMIC_STANDING_SD | Short description for the academic standing. | VARCHAR2(255) |
NO | NO | STUDENT, STUDENT PROGRESS | ||
| ACAD_PERIOD_GPA_RANGE | Range of GPA used to group students by their academic period GPA. | VARCHAR2(63) |
NO | NO | STUDENT, STUDENT PROGRESS | ||
| ACAD_PERIOD_GPA_RANGE_LD | Long description for the GPA ranges for display on reports. | VARCHAR2(255) |
NO | NO | STUDENT, STUDENT PROGRESS | ||
| ACAD_PERIOD_GPA_RANGE_SD | Order assigned to the range of GPA to sort in ascending or descending order. | VARCHAR2(255) |
NO | NO | STUDENT, STUDENT PROGRESS | ||
| ACAD_STANDING_OVERRIDE_IND | Indicates the begin academic standing was not from the student's history record but from the override recorded on the student record. | NUMBER |
NO | NO | STUDENT, STUDENT PROGRESS | ||
| ACAD_STANDING_OVERRIDE_IND_LD | Long description for the academic standing override indicator. | VARCHAR2(255) |
NO | NO | STUDENT, STUDENT PROGRESS | ||
| ACAD_STANDING_OVERRIDE_IND_SD | Short description for the academic standing override indicator. | VARCHAR2(255) |
NO | NO | STUDENT, STUDENT PROGRESS | ||
| COMBINED_ACADEMIC_STANDING | Represents the combined academic standing for the student. This value will be either the override academic standing on the student record or the one from history record for an academic period. | VARCHAR2(63) |
MSKFUNC.F_ACADEMIC_STAND_DATA(PERSON_IN, Y.ACADEMIC_PERIOD, LEVEL_IN,'COMBINED_ACAD_STANDING') |
NO | NO | ||
| COMBINED_ACADEMIC_STANDING_LD | Long description for the combined academic standing. | VARCHAR2(255) |
NO | NO | STUDENT, STUDENT PROGRESS | ||
| COMBINED_ACADEMIC_STANDING_SD | Short description for the combined academic standing. | VARCHAR2(255) |
NO | NO | STUDENT, STUDENT PROGRESS | ||
| CUMULATIVE_GPA_RANGE | Range of GPA used to group students by their cumulative GPA. | VARCHAR2(63) |
NO | NO | STUDENT, STUDENT PROGRESS | ||
| CUMULATIVE_GPA_RANGE_LD | Long description for the GPA ranges for display on reports. | VARCHAR2(255) |
NO | NO | STUDENT, STUDENT PROGRESS | ||
| CUMULATIVE_GPA_RANGE_SD | Order assigned to the range of GPA to sort in ascending or descending order. | VARCHAR2(255) |
NO | NO | STUDENT, STUDENT PROGRESS | ||
| CUMULATIVE_GPA_THRESHOLD | Cumulative GPA threshold used to group student above or equal to the threshold values specified by the institution or below the threshold. Used in reporting to find groups of students perforating well and those who or not to further investigate either group. | VARCHAR2(63) |
NO | NO | STUDENT, STUDENT PROGRESS | ||
| CUMULATIVE_GPA_THRESHOLD_LD | Long description for the cumulative GPA threshold. | VARCHAR2(255) |
NO | NO | STUDENT, STUDENT PROGRESS | ||
| CUMULATIVE_GPA_THRESHOLD_SD | Short description for the cumulative GPA threshold. | VARCHAR2(255) |
NO | NO | STUDENT, STUDENT PROGRESS | ||
| DEANS_LIST | Identifies whether the student qualified for the dean's list this academic period. | VARCHAR2(63) |
NO | NO | STUDENT, STUDENT PROGRESS | ||
| DEANS_LIST_LD | Long description for the dean's list value. | VARCHAR2(255) |
NO | NO | STUDENT, STUDENT PROGRESS | ||
| DEANS_LIST_SD | Short description for the dean's list value. | VARCHAR2(255) |
NO | NO | STUDENT, STUDENT PROGRESS | ||
| PROGRESS_EVALUATION | Progress evaluation as stored on the student record for this academic study. | VARCHAR2(63) |
NO | NO | STUDENT, STUDENT PROGRESS | ||
| PROGRESS_EVALUATION_LD | Long description for the progress evaluation. | VARCHAR2(255) |
NO | NO | STUDENT, STUDENT PROGRESS | ||
| PROGRESS_EVALUATION_SD | Short description for the progress evaluation. | VARCHAR2(255) |
NO | NO | STUDENT, STUDENT PROGRESS | ||
| STUDENT_PERFORMANCE_KEY | Key for the student performance dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| SYSTEM_LOAD_PROCESS | Name of the transformation that created the row during the load activity process. | VARCHAR2(30) |
NO NO | NO |
STUDENT, STUDENT PROGRESS STUDENT PROGRESS | ||
| SYSTEM_LOAD_TMSTMP | Most current date this record was created or updated. | DATE |
NO NO | NO |
STUDENT, STUDENT PROGRESS STUDENT PROGRESS |