| RETURN TO BANNER EDW META DATA REPORTS LIST | |
| Student Progress Star |
Description
| Student Progress Aggregate Table. | |
| Target Column | Business Definition | Database Data Type | Source Name | Source Column | Local Source | Local Target | Star Name |
|---|---|---|---|---|---|---|---|
| ACADEMIC_OUTCOME_ACADSTUDY_KEY | Key for the academic study dimension for the academic period associated with the academic outcome record. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| ACADEMIC_OUTCOME_GROUP_KEY | Unique identifier for all academic outcome records for the person. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| ACADEMIC_OUTCOME_ROLL_KEY | Outcome number associated with the specific academic outcome record that was created when the priority curriculum was rolled to history. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| ACADEMIC_PERIOD_ADMIT_KEY | Key for the academic time dimension for the academic period in which the student was admitted. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| ACADEMIC_PERIOD_FRSTATTEND_KEY | Key for the academic time dimension that identifies the first academic period that the student attended this institution at the student level by finding the earliest academic period with a student course that has a source type of history or registration. In Banner this is the minimum term with either an SFRSTCR or SHRTCKN record for the person at the student level. Note: all multi year measures for retention and graduation are calculated from the academic period first attended for the person at the student level. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| ACADEMIC_PERIOD_GPA | Student's academic period GPA includes all completed student courses within this academic period. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| ACADEMIC_PERIOD_LASTATTEND_KEY | Key for the academic time dimension that identifies the last academic period that the student attended this institution. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| ACADEMIC_STANDING_END_DATE | Date the end of academic period academic standing from the history record was last calculated or manually updated for this student. | DATE |
NO | NO | |||
| ACADEMIC_STUDY_CHANGE_IND | Indicates that at least one of the academic study attributes (program, college, degree, major, department) has changed. | NUMBER |
CASE WHEN CHANGED_MAJOR_COUNT>0 THEN ACADEMIC_STUDY_CHANGE_IND = 1 ELSE 0 |
NO | NO | STUDENT PROGRESS | |
| ACADEMIC_STUDY_KEY | Key for the academic study dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| ACADEMIC_STUDY_START_KEY | Key for the academic study dimension for the academic period when the student first attended. | NUMBER |
CASE WHEN ACADEMIC_TIME_KEY = ACADEMIC_TIME_KET THEN ACADEMIC_STUDY_KEY ELSE 0 |
NO | NO | ||
| ACADEMIC_TIME_KEY | Key for the academic time dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| ACADEMIC_YEAR_GPA | Student's academic year GPA includes all completed student courses within all academic periods associated with the specific academic year. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| ACAD_HISTORY_EXISTS_HEADCOUNT | Headcount of the students with courses in academic history for this academic period. Distinct count of all the students who have completed institutional courses now graded in academic history. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| ACAD_PERIOD_ATTEND_COUNT | Number of academic periods the student attended the institution up through this academic period. Each academic period in history and the current registration are counted as one. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| ACTIVE_HOLD_IND | Indicates the student has an active hold. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| ADMIT_AGE | Age of the student at time of admission. This is calculated using the student birthdate compared to the start date for the academic period admit recorded for this student. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| ADVISOR_GROUP_KEY | Unique identifier for all the advisors assigned to this person. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| APPLICATION_POSTAL_KEY | Key for postal dimension at the time of the application. This will contain the data regarding nation, state/province and county at the time of admission. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| ATHLETIC_GROUP_KEY | Unique identifier for all the athletic participation recorded for this person. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| BANNER_COMMUNICATION_GROUP_KEY | Unique identifier for all the Banner communications recorded for this person. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| CHANGED_MAJOR_COUNT | Number of different major codes recorded since the academic period first attended for this student. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| CONTACT_GROUP_KEY | Unique identifier for all the Banner contacts recorded for this person. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| COOP_ED_PARTICIPANT_HEADCOUNT | Headcount of students in a program with a cooperative education experience this academic period. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| COURSE_ATTEMPTED_COUNT | Number of student courses attempted by the student. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| COURSE_DROP_COUNT | Number of student courses dropped by the student as identified by the course registration status on the course section record. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| COURSE_FAILED_COUNT | Number of student courses failed by the student as identified by the final grade having a no in a credits passed indicator. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| COURSE_IN_PROGRESS_COUNT | Number of student courses retrieved as registered courses. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| COURSE_PASSED_COUNT | Number of student courses pased by the student as identified by the final grade having a yes in a credits passed indicator. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| COURSE_WITHDRAWN_COUNT | Number of student courses withdrawn by the student as identified by the course registration status on the course section record. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| CUMULATIVE_CREDITS_ATTEMPTED | Cumulative credits attempted based on the final grades for the student courses taken by the student. | NUMBER |
SUM(F.COURSE_CREDITS_ATTEMPTED ) CUMULATIVE_CREDITS_ATTEMPTED, |
NO | NO | ||
| CUMULATIVE_CREDITS_EARNED | Student's cumulative GPA that includes all completed student courses through this academic period. | NUMBER |
NO | NO | |||
| CUMULATIVE_CREDITS_FOR_GPA | Cumulative credits used in the GPA calculation based on the final grades for the student courses taken by the student. | NUMBER |
NO | NO | |||
| CUMULATIVE_CREDITS_PASSED | Cumulative credits passed based on the final grades for the student courses taken by the student. | NUMBER |
NO | NO | |||
| CUMULATIVE_GPA | Cumulative GPA based on the final grades for the student courses taken by the student. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| CUMULATIVE_QUALITY_POINTS | Cumulative quality points based on the final grades for the student courses taken by the student. | NUMBER |
SUM(F.FINAL_GRADE_QUALITY_POINTS ) CUMULATIVE_QUALITY_POINTS, |
NO | NO | ||
| CURRENT_TIME_STATUS_DATE | Date the last system calculated or manually assigned time status record was created for the student in this academic period. | DATE |
NO | NO | STUDENT PROGRESS | ||
| CURRICULUM_ORDER | Order of curriculum assigned by the system when multiple curriculums are recorded for a student. Determined by examining the active and current indicators on the curriculum rows along with the institution assigned curriculum priority to determine the primary curriculum. The primary curriculum is the curriculum with the lowest priority number where the curriculum is both active and current. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| CURRICULUM_PRIORITY | Institution assigned curriculum priority when creating multiple or concurrent curriculum records for a student. These numbers do not need to be sequential but the lowest number is considered the primary curriculum. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| DEMOGRAPHIC_KEY | Key for the demographic dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| DEVELOPMENTAL_COURSE_IND | Institution defined value which indicates if a course is considered a remedial or developmental course. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| ENROLLED_HEADCOUNT | Headcount of students enrolled for this academic period. Enrolled headcount is a distinct count of students who have a registration header record. Based on the Banner definition this means they have a SFBETRM row but may or may not have any course section records or SFRSTCR rows for the academic period. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| ENROLLMENT_STATUS_DATE | Date the academic period enrollment status code was assigned. | DATE |
NO | NO | STUDENT PROGRESS | ||
| ENROLLMENT_STATUS_KEY | Key for enrollment status dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| ENROLL_CENSUS_DATE1_HEADCOUNT | Headcount of students enrolled in at least one course as of the first census date. This means the initial section add date is prior to the census date and any new course registration status does take the student out of the course section count prior to the census date. All student courses registered for an academic period are examined and if one meets this criteria the student is included in the headcount. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| ENROLL_CENSUS_DATE2_HEADCOUNT | Headcount of students enrolled in at least one course as of the second census date. This means the initial section add date is prior to the second census date and any new course registration status does take the student out of the course section count prior to the census date.All student courses registered for an academic period are examined and if one meets this criteria the student is included in the headcount. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| EXPECTED_GRAD_DATE | Date recorded when the student is expected graduate based on the student population (new or transfer), student time status (full or part time) and the academic period first attended that is manually input by the institution. | DATE |
NO | NO | STUDENT PROGRESS | ||
| FINANCIAL_AID_STATUS_KEY | Key for financial aid status dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| FINANCIAL_AID_YEAR_KEY | Key for financial aid year dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| FIRST_BANNER_COMMUNICATION_KEY | Key for the Banner communication dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| FIRST_BANNER_COMM_INIT_DATE | Date the communication or material was scheduled to be sent to the person. | DATE |
NO | NO | STUDENT PROGRESS | ||
| FIRST_BANNER_COMM_PENDING_IND | Identifies whether or not the communication is still pending or has been sent. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| FIRST_BANNER_COMM_SENT_DATE | Date the communication or material was sent to the person. | DATE |
NO | NO | STUDENT PROGRESS | ||
| FIRST_CONTACT_DATE | Date of the contact. This is linked to the calendar date dimension. | DATE |
NO | NO | STUDENT PROGRESS | ||
| FIRST_CONTACT_KEY | Key of the contact dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| FM_FULLY_MET_NEED_HEADCOUNT | Headcount of the aid applicants whose FM need was fully met. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| FM_GROSS_NEED | Gross need of the applicant defined as budget minus total family contribution using the federal methodology. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| FM_NEED_ELIGIBLE_HEADCOUNT | Headcount of applicants with FM need eligible. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| FM_TOTAL_FAMILY_INCOME | Total family income as calculated using the federal methodology. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| FM_UNMET_NEED | Student's federal methodology calculated unmet need (gross need minus total offered awards). | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| FTE | Calculated value the uses the academic period registered credits divided by the normal full time student credit load to specify the portion of an FTE this student represents in this academic period. For example if this student has 15 credits and a normal credit load is 12, this student would be 1.25 FTE. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| GEOGRAPHIC_REGION_KEY | Key for the geographic region dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| GRADUATED_HEADCOUNT | Headcount of the students whose outcome status recorded for this academic outcome identifies the student as awarded the outcome in this academic period. Based on the Banner columns SHRDGMR_DEGS_CODE where the STVDEGS_AWARD_STATUS_IND = A and the SHRDGMR_TERM_CODE_GRAD is equal to this academic period. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| GRADUATE_CREDIT_ELIG_HEADCOUNT | Headcount of students who have permission to take graduate credit courses in this academic period. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| GRADUATION_MULTI_YEAR_KEY | Key for graduation multi year dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| HOLD_GROUP_KEY | Unique identifier for all the Banner holds recorded for this person. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| IM_FULLY_MET_NEED_HEADCOUNT | Headcount of applicants with IM need that has been fully met. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| IM_GROSS_NEED | Gross need of the applicant defined as budget minus total family contribution using the institution methodology. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| IM_NEED_ELIGIBLE_HEADCOUNT | Headcount of applicants who are IM need eligible. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| IM_TOTAL_FAMILY_INCOME | Total family income as calculated using the institution methodology. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| IM_UNMET_NEED | Student's institution methodology calculated unmet need (gross need minus total offered awards). | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| INITIAL_ENROLL_STATUS_DATE | Date the student was first enrolled in an academic period that will not change when a new enrollment status is assigned and the enrollment status date is updated. | DATE |
NO | NO | STUDENT PROGRESS | ||
| INTERNATIONAL_STUDENT_IND | Indicates this person has a visa type recorded. | NUMBER |
CASE WHEN VISA_TYPE <> MTVPARM_DESC AND DEMOGRAPHIC_KEY <> 0 THEN 1 ELSE 0 |
NO | NO | STUDENT PROGRESS | |
| LAST_BANNER_COMMUNICATION_KEY | Key for the Banner communication dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| LAST_BANNER_COMM_INIT_DATE | Date the communication or material was scheduled to be sent to the person. | DATE |
NO | NO | STUDENT PROGRESS | ||
| LAST_BANNER_COMM_PENDING_IND | Identifies whether or not the communication is still pending or has been sent. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| LAST_BANNER_COMM_SENT_DATE | Date the communication or material was sent to the person. | DATE |
NO | NO | STUDENT PROGRESS | ||
| LAST_CONTACT_DATE | Date of the contact. This is linked to the calendar date dimension. | DATE |
NO | NO | STUDENT PROGRESS | ||
| LAST_CONTACT_DAYS | Number of days since the last contact was entered for this student. | NUMBER |
( TRUNC(SYSDATE) - NVL(CONT_LAST_REC.CONTACT_DATE,TRUNC(SYSDATE)) ); |
NO | NO | ||
| LAST_CONTACT_KEY | Key of the contact dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| LAST_FEEDBACK_ACAD_TIME_KEY | Key for the Academic Period when the student last recieved Faculyt Feedback. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| LEAVE_FROM_DATE | Date the student was approved to officially be on leave from the institution. | DATE |
NO | NO | STUDENT PROGRESS | ||
| LEAVE_TO_DATE | Date the student was approved to officially return from leave to continue attending the institution. | DATE |
NO | NO | STUDENT PROGRESS | ||
| MATRICULATED_HEADCOUNT | Headcount of students matriculated in a degree seeking program at the institution. This is based on the Banner column SORLCUR_TERM_CODE_MATRIC that may be populated based on the institution's definition of matriculated. . | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| MULTI_SOURCE_KEY | Key for the multi source dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| NEW_STUDENT_HEADCOUNT | Headcount of the students admitted to the institution in this academic period. This will be the academic period admit for this student is populated with the same academic time key. Academic Period Admit is based on the Banner column SORLCUR_TERM_CODE_ADMIT. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| NON_RETENTION_LIKE_HEADCOUNT | Headcount of the students not retained by the institution for the next like academic period. Headcount of the students not retained by the institution or those who are counted in the registered headcount of one academic period but do not register in the next like academic period. | NUMBER |
DECODE(NOT_RETAINED_OVERALL_IND, 1, PERSON_IN, NULL) NON_RETENTION_LIKE_HEADCOUNT_HEADCOUNT |
NO | NO | ||
| NON_RETENTION_LIKE_HEADCOUNT_C | Headcount of the students not retained within college for the next like academic period. | NUMBER |
DECODE(NOT_RETAINED_COLLEGE_IND, 1, PERSON_IN, NULL) NON_RETENTION_LIKE_HEADCOUNT_C |
NO | NO | ||
| NON_RETENTION_LIKE_HEADCOUNT_P | Headcount the students was not retained within program for the next like academic period. | NUMBER |
DECODE(NOT_RETAINED_PROGRAM_IND, 1, PERSON_IN, NULL) NON_RETENTION_LIKE_HEADCOUNT_P |
NO | NO | ||
| NON_RETENTION_LIKE_HEADCOUNT_S | Headcount of the students not retained within student level for the next like academic period. If the student level of the primary curriculum changes, the student will be included as not retained. | NUMBER |
DECODE(NOT_RETAINED_STDLEVL_IND, 1, PERSON_IN, NULL) NON_RETENTION_LIKE_HEADCOUNT_S, |
NO | NO | ||
| NON_RETENTION_SEQ_HEADCOUNT | Headcount of the students not retained by the institution or those who are counted in the registered headcount of one academic period but do not register in the next sequential academic period. | NUMBER |
DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN,NULL) RET_SEQ_EXCLUDE_HEADCOUNT |
NO | NO | ||
| NON_RETENTION_SEQ_HEADCOUNT_C | Headcount of the students was not retained within college for the next sequential academic period. | NUMBER |
DECODE(NOT_RETAINED_COLLEGE_IND, 1, PERSON_IN,NULL) NON_RETENTION_SEQ_HEADCOUNT_C |
NO | NO | ||
| NON_RETENTION_SEQ_HEADCOUNT_P | Headcount of the students not retained within program for the next sequential academic period. | NUMBER |
DECODE(NOT_RETAINED_PROGRAM_IND, 1, PERSON_IN,NULL) NON_RETENTION_SEQ_HEADCOUNT_P |
NO | NO | ||
| NON_RETENTION_SEQ_HEADCOUNT_S | Headcount of the students not retained within student level for the next sequential academic period. If the student level of the primary curriculum changes, the student will be included as not retained. | NUMBER |
DECODE(NOT_RETAINED_STDLEVL_IND, 1, PERSON_IN,NULL) NON_RETENTION_SEQ_HEADCOUNT_S |
NO | NO | ||
| NOT_REGISTERED_HEADCOUNT | Headcount of students not registered in this academic period. Students will be included in this headcount only when they have no enrollment or registration activity for the academic period and they have not withdrawn. Based on the Banner definition this means they do not have an SFBETRM (or SHRTTRM) record for the academic period. | NUMBER |
CASE WHEN REGISTERED_IND = 1 OR WITHDRAWN_IND = 1 THEN NULL ELSE PERSON_UID |
NO | NO | STUDENT PROGRESS | |
| PERMIT_REGISTRATION_HEADCOUNT | Headcount of students permitted to register for this academic period. This is determined by the student status for the academic period and the STVSTST_REG_IND, when the indicator is Y, the student in counted in the Permit Registration Headcount. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| PERSON_UID | Key for the person dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| POSTAL_KEY | Key for the postal dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| POST_SECONDARY_SCHOOL_GRP_KEY | Unique identifier for all the post secondary schools recorded for this person. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| PREVIOUS_ACADEMIC_PERIOD_GPA | Student's academic period GPA includes all completed student courses within the academic period that was just prior to this academic period. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| PRE_STUDENT_STATUS_KEY | Key for the pre-student status dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| RACE_GROUP_KEY | Unique identifier for all the races recorded for this person. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| REGISTERED_HEADCOUNT | Headcount of students registered for at least one course section in this academic period. Registered headcount is a distinct count of students who have a registration header record and at least one course section record. Based on the Banner definition this means they have a SFBETRM row at at least one SFRSTCR row for the academic period. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| RETENTION_LIKE_HEADCOUNT | Headcount of the students retained by the institution or those who are counted in the registered headcount of one academic period and then registered in the next like academic period. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| RETENTION_LIKE_HEADCOUNT_C | Headcount of the students retained within the same college for the next like academic period. | NUMBER |
DECODE(RETAINED_COLLEGE_IND, 1, PERSON_IN, NULL) RETENTION_LIKE_HEADCOUNT_C |
NO | NO | ||
| RETENTION_LIKE_HEADCOUNT_P | Headcount of the students retained within the same program for the next like academic period. | NUMBER |
DECODE(RETAINED_PROGRAM_IND, 1, PERSON_IN, NULL) RETENTION_LIKE_HEADCOUNT_P |
NO | NO | ||
| RETENTION_LIKE_HEADCOUNT_S | Headcount of the students retained within the same student level for the next like academic period. If the student level of the primary curriculum remains the same, the student will be included as retained. | NUMBER |
DECODE(RETAINED_STDLEVL_IND, 1, PERSON_IN, NULL) RETENTION_LIKE_HEADCOUNT_S |
NO | NO | ||
| RETENTION_LIKE_KEY | Key for retention like dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| RETENTION_MULTI_YEAR_KEY | Key for retention multi year dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| RETENTION_SEQUENTIAL_KEY | Key for retention sequential dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| RETENTION_SEQ_HEADCOUNT | Headcount of the students retained by the institution for the next sequential academic period. Headcount of the students retained by the institution or those who are counted in the registered headcount of one academic period and then registered in the next sequential academic period. Sequential academic periods are defined in setup rules for loading this data. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| RETENTION_SEQ_HEADCOUNT_C | Headcount of the students retained within the same college for the next sequential academic period. | NUMBER |
DECODE(RETAINED_COLLEGE_IND, 1, PERSON_IN,NULL) RETENTION_SEQ_HEADCOUNT_C |
NO | NO | ||
| RETENTION_SEQ_HEADCOUNT_P | Headcount of the students retained within the same program for the next sequential academic period. | NUMBER |
DECODE(RETAINED_PROGRAM_IND, 1, PERSON_IN,NULL) RETENTION_SEQ_HEADCOUNT_P |
NO | NO | ||
| RETENTION_SEQ_HEADCOUNT_S | Headcount of the students retained within the same student level for the next sequential academic period. If the student level of the primary curriculum remains the same, the student will be included as retained. | NUMBER |
DECODE(NOT_RETAINED_OVERALL_IND, 1, PERSON_IN,NULL) NON_RETENTION_SEQ_HEADCOUNT |
NO | NO | ||
| RETENTION_TIME_KEY | Key for the retention time dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| RET_LIKE_EXCLUDE_HEADCOUNT | Headcount of the students not included in the retained nor the not retained headcounts and rates for a like academic period. Persons are excluded as legitimate temporary exclusions either by a student status or enrollment status, by permanent exclusions because of graduation or death. | NUMBER |
DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN, NULL) RET_LIKE_EXCLUDE_HEADCOUNT |
NO | NO | ||
| RET_LIKE_EXCLUDE_HEADCOUNT_C | Headcount of the students not included in the retained nor the not retained headcounts and rates for a like academic period by college will be determined the same way as those who are excluded from the institution headcount and rates. Persons are excluded as legitimate temporary exclusions either by a student status or enrollment status, by permanent exclusions because of graduation or death. | NUMBER |
DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN, NULL) RET_LIKE_EXCLUDE_HEADCOUNT_C |
NO | NO | ||
| RET_LIKE_EXCLUDE_HEADCOUNT_P | Headcount of the students not included in the retained nor the not retained headcounts and rates for a like academic period by program will be determined the same way as those who are excluded from the institution headcount and rates. Persons are excluded as legitimate temporary exclusions either by a student status or enrollment status, by permanent exclusions because of graduation or death. | NUMBER |
DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN, NULL) RET_LIKE_EXCLUDE_HEADCOUNT_P |
NO | NO | ||
| RET_LIKE_EXCLUDE_HEADCOUNT_S | Headcount of the students not included in the retained nor the not retained headcounts and rates for a like academic period by student level will be determined the same way as those who are excluded from the institution headcount and rates. Persons are excluded as legitimate temporary exclusions either by a student status or enrollment status, by permanent exclusions because of graduation or death. | NUMBER |
DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN, NULL) RET_LIKE_EXCLUDE_HEADCOUNT_SXCLUDE_HEADCOUNT_S |
NO | NO | ||
| RET_SEQ_EXCLUDE_HEADCOUNT | Headcount of the students not included in the retained nor the not retained headcounts and rates for a sequential academic period. Persons are excluded as legitimate temporary exclusions either by a student status or enrollment status, by permanent exclusions because of graduation or death. | NUMBER |
DECODE(RETAINED_STDLEVL_IND, 1, PERSON_IN,NULL) RETENTION_SEQ_HEADCOUNT_S |
NO | NO | ||
| RET_SEQ_EXCLUDE_HEADCOUNT_C | Headcount of the students not included in the retained nor the not retained headcounts and rates for a sequential academic period by college will be determined the same way as those who are excluded from the institution headcount and rates. Persons are excluded as legitimate temporary exclusions either by a student status or enrollment status, by permanent exclusions because of graduation or death. | NUMBER |
DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN,NULL) RET_SEQ_EXCLUDE_HEADCOUNT_C |
NO | NO | ||
| RET_SEQ_EXCLUDE_HEADCOUNT_P | Headcount of the students not included in the retained nor the not retained headcounts and rates for a sequential academic period by program will be determined the same way as those who are excluded from the institution headcount and rates. Persons are excluded as legitimate temporary exclusions either by a student status or enrollment status, by permanent exclusions because of graduation or death. | NUMBER |
DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN,NULL) RET_SEQ_EXCLUDE_HEADCOUNT_P |
NO | NO | ||
| RET_SEQ_EXCLUDE_HEADCOUNT_S | Headcount of the students not included in the retained nor the not retained headcounts and rates for a sequential academic period by student level will be determined the same way as those who are excluded from the institution headcount and rates. Persons are excluded as legitimate temporary exclusions either by a student status or enrollment status, by permanent exclusions because of graduation or death. | NUMBER |
DECODE(RETAINED_EXCLUDE_IND, 1, PERSON_IN,NULL) RET_SEQ_EXCLUDE_HEADCOUNT_S |
NO | NO | ||
| SECONDARY_SCHOOL_KEY | Key for the secondary school dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| SS_GEOGRAPHIC_REGION_KEY | Key for the seconcdary school geographic region dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| SS_GPA | Person's secondary institution average or GPA. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| SS_INSTITUTION_KEY | Key for the secondary school institution dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| SS_PERCENTILE | Person's class percentile as related to class rank and size. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| SS_POSTAL_KEY | Key for the secondary school postal dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| SS_RANK | Person's secondary school class rank. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| SS_SIZE | Person's secondary school class size. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| SS_STREET_LINE_KEY | Key of the secondary school address street line dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| SS_SUBJECT_GROUP_KEY | Unique identifier for all the secondary school subjects recorded for this person. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| START_DATE_MATRICULATED | Start date for the academic period matriculated recorded for this student. | DATE |
NO | NO | STUDENT PROGRESS | ||
| STREET_LINE_KEY | Key for street line dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| STUDENT_ACTIVITY_GROUP_KEY | Unique identifier for all the student activities recorded for this person. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| STUDENT_ATTRIBUTE_GROUP_KEY | Unique identifier for all the student attributes recorded for this person. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| STUDENT_COHORT_GROUP_KEY | Unique identifier for all the student cohorts for a person. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| STUDENT_COURSE_GROUP_KEY | Unique identifier for all the student courses for a person within an academic time. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| STUDENT_HEADCOUNT | Headcount of students who are expected to register in this academic period. Based on the Banner definition for a student as anyone with a student record or SGBSTDN where the SGBSTDN_STST_CODE has an STVSTST_REG_IND = Y and that the student is either a new student or a student who graduated in the academic period or the student has registered in or later than this academic period's readmission required academic period defined by the instiution when setting up the registration term or SOBTERM. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| STUDENT_HOUSING_HEADCOUNT | Headcount of students with a housing assignment this academic period. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| STUDENT_KEY | Key for the Student dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| STUDENT_PERFORMANCE_KEY | Key for student performance dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| STUDENT_STATUS_KEY | Key for student status 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 | STUDENT PROGRESS | ||
| SYSTEM_LOAD_TMSTMP | Most current date this record was created or updated. | DATE |
NO | NO | STUDENT PROGRESS | ||
| TEST_ACT_COMPOSITE_HIGHEST_KEY | Key for the test dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TEST_ACT_COMPOSITE_HIGH_SCORE | Test score value for this test. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TEST_GRADUATE1_HIGHEST_KEY | Key for the test dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TEST_GRADUATE1_HIGH_SCORE | Test score value for this test. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TEST_GRADUATE2_HIGHEST_KEY | Key for the test dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TEST_GRADUATE2_HIGH_SCORE | Test score value for this test. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TEST_GROUP_KEY | Unique identifier for all the test scores recorded for this person. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TEST_IELTS_HIGHEST_KEY | Key for the test dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TEST_IELTS_HIGH_SCORE | Test score value for this test. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TEST_LANGUAGE_HIGHEST_KEY | Key for the test dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TEST_LANGUAGE_HIGH_SCORE | Test score value for this test. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TEST_MATH_HIGHEST_KEY | Key for the test dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TEST_MATH_HIGH_SCORE | Test score value for this test. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TEST_PLACEMENT1_HIGHEST_KEY | Key for the test dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TEST_PLACEMENT1_HIGH_SCORE | Test score value for this test. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TEST_PLACEMENT2_HIGHEST_KEY | Key for the test dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TEST_PLACEMENT2_HIGH_SCORE | Test score value for this test. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TEST_SAT_COMBINED_HIGHEST_KEY | Key for the test dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TEST_SAT_COMBINED_HIGH_SCORE | Test score value for this test. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TEST_TOEFL_HIGHEST_KEY | Key for the test dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TEST_TOEFL_HIGH_SCORE | Test score value for this test. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TEST_VERBAL_HIGHEST_KEY | Key for the test dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TEST_VERBAL_HIGH_SCORE | Test score value for this test. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TEST_WRITING_HIGHEST_KEY | Key for the test dimension. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TEST_WRITING_HIGH_SCORE | Test score value for this test. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TOTAL_ACAD_PERIOD_ATTEND_COUNT | Count of the number of academic periods this student attended the institution. Each academic period in history and the current registration are counted as one regardless of its relationship to this academic period. So if the student attend 5 through and 2 after this academic period the total academic periods attended count would equal 7. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TOTAL_CREDITS | Total credits for the student courses taken by the student at the institution (excludes transfer credits). | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TOTAL_CREDITS_ATTEMPTED | Total credits attempted based on the final grades for the student courses taken by the student. | NUMBER |
NO | NO | |||
| TOTAL_CREDITS_EARNED | Total credits earned based on the final grades for the student courses taken by the student. | NUMBER |
NO | NO | |||
| TOTAL_CREDITS_FOR_GPA | Total credits used in the GPA calculation based on the final grades for the student courses taken by the student. | NUMBER |
NO | NO | |||
| TOTAL_CREDITS_PASSED | Total credits passed based on the final grades for the student courses taken by the student. | NUMBER |
NO | NO | |||
| TOTAL_FEDERAL_OFFER_AMOUNT | Total offered amount identified with an aid source of Federal Aid. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TOTAL_GIFT_OFFER_AMOUNT | Total offered amount that is identified as Gift Aid meaning it has an aid type of Grant or Scholarship. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TOTAL_GRANT_OFFER_AMOUNT | Total offered amount identified with an aid type of Grant Aid. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TOTAL_INSTITUTION_OFFER_AMOUNT | Total offered amount identified with an aid source of Institutional Aid. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TOTAL_INST_GIFT_OFFER_AMOUNT | Total offered amount that is identified with an aid source of Institutional and an aid type of either Grant or Scholarship. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TOTAL_LOAN_OFFER_AMOUNT | Total offered amount identified with an aid type of Loan Aid. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TOTAL_OFFER_AMOUNT | Total amount of all awards offered to the aid applicant in this aid year. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TOTAL_ORIGINAL_OFFER_AMOUNT | Total original amount of all awards offered to the aid applicant in this aid year. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TOTAL_OTHER_OFFER_AMOUNT | Total offered amount identified with an aid source of Other Aid. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TOTAL_QUALITY_POINTS | Total quality points based on the final grades for the student courses taken by the student. | NUMBER |
NO | NO | |||
| TOTAL_SCHOLARSHIP_OFFER_AMOUNT | Total offered amount identified with an aid type of Scholarship Aid. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TOTAL_SELF_HELP_OFFER_AMOUNT | Total offered amount that is identified as Self Help Aid meaning it has an aid type of Loan or Work. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TOTAL_STATE_OFFER_AMOUNT | Total offered amount identified with an aid source of State Aid. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TOTAL_WORK_OFFER_AMOUNT | Total offered amount identified with an aid type of Work Aid. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| TRADITIONAL_STUDENT_IND | Indicates the student fits into the traditional student because their current age is equal to or less than the institution rule age specified. | NUMBER |
CASE WHEN BIRTH_DATE IS NULL THEN NULL WHEN TRUNC(MONTH_BETWEEN)<23 THEN 1 ELSE 0 |
NO | NO | STUDENT PROGRESS | |
| UNDECLARED_MAJOR_COUNT | Number of academic periods prior to the academic period when a major code other than the one specified in the institution undeclared major code rule. So if the rule using'0000' as undeclared and the student attended four academic period with that code and in the fifth academic period changed to'HIST', the undeclared major count would equal 4. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| VETERAN_IND | Indicates this person is a veteran based on the existence of veteran's information. | NUMBER |
CASE WHEN VETERAN_TYPE <> MTVPARM_DESC AND VETERAN_CATEGORY <> 0 THEN 1 ELSE 0 |
NO | NO | STUDENT PROGRESS | |
| WITHDRAWN_HEADCOUNT | Headcount of students who have an enrollment status that identifies the student as withdrawn from the institution in this academic period. Based the student having an enrollment record or SFBETRM with an Enrollment Status with the Banner column of either STVESTS_WD_IND or STVESTS_THIRD_PARTY_WD_IND set to Y. | NUMBER |
NO | NO | STUDENT PROGRESS | ||
| YEAR1_GRADUATION_HEADCOUNT | Headcount of the students who graduated within their first attended academic year. | NUMBER |
DECODE(YEAR1_GRADUATION_IND,1,PERSON_IN,NULL) YEAR1_GRADUATION_HEADCOUNT, |
NO | NO | ||
| YEAR1_GRAD_EXCLUDE_HEADCOUNT | Headcount of students who are excluded as legitimate exceptions either by a student status or enrollment status or death. | NUMBER |
DECODE(YEAR1_EXCLUDE_IND,1,PERSON_IN,NULL) YEAR1_GRAD_EXCLUDE_HEADCOUNT, |
NO | NO | ||
| YEAR1_REGISTERED_HEADCOUNT | Headcount of the student in their initial registration. | NUMBER |
NO | NO | |||
| YEAR2_GRADUATION_HEADCOUNT | Headcount of the student graduated within their second year. Headcount is cumulative and includes any graduation at the student level from each year through this year. | NUMBER |
DECODE(YEAR2_GRADUATION_IND,1,PERSON_IN,NULL) YEAR2_GRADUATION_HEADCOUNT |
NO | NO | ||
| YEAR2_GRAD_EXCLUDE_HEADCOUNT | Headcount of students excluded from the graduation rate calculation for year 2. | NUMBER |
DECODE(YEAR2_EXCLUDE_IND,1,PERSON_IN,NULL) YEAR2_GRAD_EXCLUDE_HEADCOUNT |
NO | NO | ||
| YEAR2_NOT_REGISTERED_HEADCOUNT | Headcount of the students not retained to year 2. | NUMBER |
DECODE(YEAR2_NOT_RETAINED_IND,1,PERSON_IN,NULL)YEAR2_NOT_REGISTERED_HEADCOUNT, |
NO | NO | ||
| YEAR2_REGISTERED_HEADCOUNT | Headcount of the students registered and retained to year 2. | NUMBER |
DECODE(YEAR2_RETAINED_IND,1,PERSON_IN,NULL) YEAR2_REGISTERED_HEADCOUNT, |
NO | NO | ||
| YEAR2_RET_EXCLUDE_HEADCOUNT | Headcount of students who are excluded as legitimate exceptions either by a student status or enrollment status, graduation or death. | NUMBER |
DECODE(YEAR2_EXCLUDE_IND,1,PERSON_IN,NULL)YEAR2_RET_EXCLUDE_HEADCOUNT, |
NO | NO | ||
| YEAR3_GRADUATION_HEADCOUNT | Headcount of the student graduated within the third attended academic year. Headcount is cumulative and includes any graduation at the student level from each year through this year. | NUMBER |
DECODE(YEAR3_GRADUATION_IND,1,PERSON_IN,NULL) YEAR3_GRADUATION_HEADCOUNT, |
NO | NO | ||
| YEAR3_GRAD_EXCLUDE_HEADCOUNT | Headcount of students excluded from the graduation rate calculation for year 3. | NUMBER |
DECODE(YEAR3_EXCLUDE_IND,1,PERSON_IN,NULL) YEAR3_GRAD_EXCLUDE_HEADCOUNT, |
NO | NO | ||
| YEAR3_NOT_REGISTERED_HEADCOUNT | Headcount of the students not retained to year 3. | NUMBER |
DECODE(YEAR3_NOT_RETAINED_IND,1,PERSON_IN,NULL)YEAR3_NOT_REGISTERED_HEADCOUNT, |
NO | NO | ||
| YEAR3_REGISTERED_HEADCOUNT | Headcount of the student registered and was retained to year 3. | NUMBER |
DECODE(YEAR3_RETAINED_IND,1,PERSON_IN,NULL)YEAR3_REGISTERED_HEADCOUNT, |
NO | NO | ||
| YEAR3_RET_EXCLUDE_HEADCOUNT | Headcount of students who are excluded as legitimate exceptions either by a student status or enrollment status, graduation or death. | NUMBER |
DECODE(YEAR3_EXCLUDE_IND,1,PERSON_IN,NULL)YEAR3_RET_EXCLUDE_HEADCOUNT, |
NO | NO | ||
| YEAR4_GRADUATION_HEADCOUNT | Headcount of the student graduated within the fourth attended academic year. Headcount is cumulative and includes any graduation at the student level from each year through this year. | NUMBER |
DECODE(YEAR4_GRADUATION_IND,1,PERSON_IN,NULL) YEAR4_GRADUATION_HEADCOUNT, |
NO | NO | ||
| YEAR4_GRAD_EXCLUDE_HEADCOUNT | Headcount of students excluded from the graduation rate calculation for year 4. | NUMBER |
DECODE(YEAR4_EXCLUDE_IND,1,PERSON_IN,NULL) YEAR4_GRAD_EXCLUDE_HEADCOUNT, |
NO | NO | ||
| YEAR4_NOT_REGISTERED_HEADCOUNT | Headcount of the students not retained to year 4. | NUMBER |
DECODE(YEAR4_NOT_RETAINED_IND,1,PERSON_IN,NULL)YEAR4_NOT_REGISTERED_HEADCOUNT, |
NO | NO | ||
| YEAR4_REGISTERED_HEADCOUNT | Headcount of the student registered and was retained to year 4. | NUMBER |
DECODE(YEAR4_RETAINED_IND,1,PERSON_IN,NULL)YEAR4_REGISTERED_HEADCOUNT, |
NO | NO | ||
| YEAR4_RET_EXCLUDE_HEADCOUNT | Headcount of students who are excluded as legitimate exceptions either by a student status or enrollment status, graduation or death. | NUMBER |
DECODE(YEAR4_EXCLUDE_IND,1,PERSON_IN,NULL)YEAR4_RET_EXCLUDE_HEADCOUNT, |
NO | NO | ||
| YEAR5_GRADUATION_HEADCOUNT | Headcount of the student graduated within the fifth attended academic year. Headcount is cumulative and includes any graduation at the student level from each year through this year. | NUMBER |
DECODE(YEAR5_GRADUATION_IND,1,PERSON_IN,NULL) YEAR5_GRADUATION_HEADCOUNT, |
NO | NO | ||
| YEAR5_GRAD_EXCLUDE_HEADCOUNT | Headcount of students excluded from the graduation rate calculation for year 5. | NUMBER |
DECODE(YEAR5_EXCLUDE_IND,1,PERSON_IN,NULL) YEAR5_GRAD_EXCLUDE_HEADCOUNT, |
NO | NO | ||
| YEAR5_NOT_REGISTERED_HEADCOUNT | Headcount of the students not retained to year 5. | NUMBER |
DECODE(YEAR5_NOT_RETAINED_IND,1,PERSON_IN,NULL)YEAR5_NOT_REGISTERED_HEADCOUNT, |
NO | NO | ||
| YEAR5_REGISTERED_HEADCOUNT | Headcount of the student registered and was retained to year 5. | NUMBER |
DECODE(YEAR5_RETAINED_IND,1,PERSON_IN,NULL)YEAR5_REGISTERED_HEADCOUNT, |
NO | NO | ||
| YEAR5_RET_EXCLUDE_HEADCOUNT | Headcount of students who are excluded as legitimate exceptions either by a student status or enrollment status, graduation or death. | NUMBER |
DECODE(YEAR5_EXCLUDE_IND,1,PERSON_IN,NULL)YEAR5_RET_EXCLUDE_HEADCOUNT |
NO | NO | ||
| YEAR6_GRADUATION_HEADCOUNT | Headcount of the student graduated within the sixth attended academic year. Headcount is cumulative and includes any graduation at the student level from each year through this year. | NUMBER |
DECODE(YEAR6_GRADUATION_IND,1,PERSON_IN,NULL) YEAR6_GRADUATION_HEADCOUNT |
NO | NO | ||
| YEAR6_GRAD_EXCLUDE_HEADCOUNT | Headcount of students excluded from the graduation rate calculation for year 6. | NUMBER |
DECODE(YEAR6_EXCLUDE_IND,1,PERSON_IN,NULL) YEAR6_GRAD_EXCLUDE_HEADCOUNT |
NO | NO | ||
| YEAR6_NOT_REGISTERED_HEADCOUNT | Headcount of the students not retained to year 6. | NUMBER |
DECODE(YEAR6_NOT_RETAINED_IND,1,PERSON_IN,NULL)YEAR6_NOT_REGISTERED_HEADCOUNT, |
NO | NO | ||
| YEAR6_REGISTERED_HEADCOUNT | Headcount of the student registered and was retained to year 6. | NUMBER |
DECODE(YEAR6_RETAINED_IND,1,PERSON_IN,NULL)YEAR6_REGISTERED_HEADCOUNT, |
NO | NO | ||
| YEAR6_RET_EXCLUDE_HEADCOUNT | Headcount of students who are excluded as legitimate exceptions either by a student status or enrollment status, graduation or death. | NUMBER |
DECODE(YEAR6_EXCLUDE_IND,1,PERSON_IN,NULL)YEAR6_RET_EXCLUDE_HEADCOUNT |
NO | NO | ||
| YEAR7_GRADUATION_HEADCOUNT | Headcount of the student graduated within the seventh attended academic year. Headcount is cumulative and includes any graduation at the student level from each year through this year. | NUMBER |
DECODE(YEAR7_GRADUATION_IND,1,PERSON_IN,NULL) YEAR7_GRADUATION_HEADCOUNT, |
NO | NO | ||
| YEAR7_GRAD_EXCLUDE_HEADCOUNT | Headcount of students excluded from the graduation rate calculation for year 7. | NUMBER |
DECODE(YEAR7_EXCLUDE_IND,1,PERSON_IN,NULL) YEAR7_GRAD_EXCLUDE_HEADCOUNT, |
NO | NO | ||
| YEAR7_NOT_REGISTERED_HEADCOUNT | Headcount of the students not retained to year 7. | NUMBER |
DECODE(YEAR7_NOT_RETAINED_IND,1,PERSON_IN,NULL)YEAR7_NOT_REGISTERED_HEADCOUNT, |
NO | NO | ||
| YEAR7_REGISTERED_HEADCOUNT | Headcount of the student registered and was retained to year 7. | NUMBER |
DECODE(YEAR7_RETAINED_IND,1,PERSON_IN,NULL)YEAR7_REGISTERED_HEADCOUNT, |
NO | NO | ||
| YEAR7_RET_EXCLUDE_HEADCOUNT | Headcount of students who are excluded as legitimate exceptions either by a student status or enrollment status, by graduation or death. | NUMBER |
DECODE(YEAR7_EXCLUDE_IND,1,PERSON_IN,NULL)YEAR7_RET_EXCLUDE_HEADCOUNT, |
NO | NO | ||
| YEAR8_GRADUATION_HEADCOUNT | Headcount of the student graduated within the eigth attended academic year. Headcount is cumulative and includes any graduation at the student level from each year through this year. | NUMBER |
DECODE(YEAR8_GRADUATION_IND,1,PERSON_IN,NULL) YEAR8_GRADUATION_HEADCOUNT, |
NO | NO | ||
| YEAR8_GRAD_EXCLUDE_HEADCOUNT | Headcount of students excluded from the graduation rate calculation for year 8. | NUMBER |
DECODE(YEAR8_EXCLUDE_IND,1,PERSON_IN,NULL) YEAR8_GRAD_EXCLUDE_HEADCOUNT |
NO | NO | ||
| YEAR8_NOT_REGISTERED_HEADCOUNT | Headcount of the students not retained to year 8. | NUMBER |
DECODE(YEAR8_NOT_RETAINED_IND,1,PERSON_IN,NULL)YEAR8_NOT_REGISTERED_HEADCOUNT, |
NO | NO | ||
| YEAR8_REGISTERED_HEADCOUNT | Headcount of the student registered and was retained to year 8. | NUMBER |
DECODE(YEAR8_RETAINED_IND,1,PERSON_IN,NULL)YEAR8_REGISTERED_HEADCOUNT, |
NO | NO | ||
| YEAR8_RET_EXCLUDE_HEADCOUNT | Headcount of students who are excluded as legitimate exceptions either by a student status or enrollment status, graduation or death. | NUMBER |
DECODE(YEAR8_EXCLUDE_IND,1,PERSON_IN,NULL)YEAR8_RET_EXCLUDE_HEADCOUNT |
NO | NO |