Processes in these windows populate certain columns of the Student Term Summary Division Table.
Student Term Summary Division Table |
|
Column Code |
Column Name |
ADVISOR_ID_NUM_1 |
Advisor ID Number 1 |
ADVISOR_ID_NUM_2 |
Advisor ID Number 2 |
ADVISOR_ID_NUM_3 |
Advisor ID Number 3 |
CAREER_CRTYPE1_HRS |
Career Credit Type 1 Hours |
CAREER_CRTYPE2_HRS |
Career Credit Type 2 Hours |
CAREER_CRTYPE3_HRS |
Career Credit Type 3 Hours |
CAREER_GPA |
Career GPA |
CAREER_GRADE_1_HRS |
Career Grade 1 Hours |
CAREER_GRADE_2_HRS |
Career Grade 2 Hours |
CAREER_GRADE_3_HRS |
Career Grade 3 Hours |
CAREER_GRADE_4_HRS |
Career Grade 4 Hours |
CAREER_GRADE_5_HRS |
Career Grade 5 Hours |
CAREER_GRADE_6_HRS |
Career Grade 6 Hours |
CAREER_HRS_ATTEMPT |
Career Hours Attempted |
CAREER_HRS_EARNED |
Career Hours Earned |
CAREER_HRS_GPA |
Career Hours GPA |
CAREER_QUAL_PTS |
Career Quality Points |
DEGREE_CDE |
Degree Code |
GRA_INEL_FOR_HONOR |
Grade Ineligible for Honors |
HONORS_HR_TOTAL |
Honors Hour Total |
HRS_ENROLLED |
Total Hours Enrolled |
LOCAL_GPA |
Local GPA |
LOCAL_HRS_ATTEMPT |
Local Hours Attempted |
LOCAL_HRS_EARNED |
Local Hours Earned |
LOCAL_HRS_GPA |
Local Hours GPA |
LOCAL_QUAL_PTS |
Local Quality Points |
MAJOR_1 |
Major 1 |
MAJOR_2 |
Major 2 |
MAJOR_3 |
Major 3 |
MINOR_1 |
Minor 1 |
MINOR_2 |
Minor 2 |
MINOR_3 |
Minor 3 |
PROBATION_HR_TOTAL |
Probation Hour Total |
PT_FT_HRS |
PT FT Hours |
PT_FT_STS |
PT FT Status |
TRANSACTION_STS |
Transaction Status |
TRM_CDE |
Term Code |
TRM_CRTYPE1_HRS |
Term Credit Type 1 Hours |
TRM_CRTYPE2_HRS |
Term Credit Type 2 Hours |
TRM_CRTYPE3_HRS |
Term Credit Type 3 Hours |
TRM_GPA |
Term GPA |
TRM_GRADE_1_HRS |
Term Grade 1 Hours |
TRM_GRADE_2_HRS |
Term Grade 2 Hours |
TRM_GRADE_3_HRS |
Term Grade 3 Hours |
TRM_GRADE_4_HRS |
Term Grade 4 Hours |
TRM_GRADE_5_HRS |
Term Grade 5 Hours |
TRM_GRADE_6_HRS |
Term Grade 6 Hours |
TRM_HRS_ATTEMPT |
Term Hours Attempted |
TRM_HRS_EARNED |
Term Hours Earned |
TRM_HRS_GPA |
Term Hours GPA |
TRM_QUAL_PTS |
Term Quality Points |
XFER_GPA |
Transfer GPA |
XFER_HRS_ATTEMPTED |
Transfer Hours Attempted |
XFER_HRS_EARNED |
Transfer Hours Earned |
XFER_HRS_GPA |
Transfer Hours GPA |
XFER_QUAL_PTS |
Transfer Quality Points |
Student Term Summary Division Table |
|
Column Code |
Column Name |
HRS_ENROLLED |
Total Hours Enrolled |
ID_NUM |
ID Number |
JOB_NAME |
Job Name |
JOB_TIME |
Job Time |
NUM_OF_CRS |
Total Number of Courses |
PT_FT_HRS |
PT FT Hours |
PT_FT_STS |
PT FT Status |
TRANSACTION_STS |
Transaction Status |
TRM_CDE |
Term Code |
USER_NAME |
User Name |
YR_CDE |
Year Code |
Student Term Summary Division Table |
||
Column Code |
Column Name |
|
CLASS_RANK |
Class Rank |
|
CLASS_RANK_HI_RANG |
Class Rank High Range |
|
CLASS_SIZE |
Class Size |
Student Term Summary Division Table |
||
Column Code |
Column Name |
|
ACADEMIC_HONORS |
Academic Honors |
|
ACADEMIC_PROBATION |
Academic Probation |
Student Term Summary Division Table |
|
Column Code |
Column Name |
CLASS_CDE |
Classification Code |
This table combines the information from the previous tables.
Columns in the |
Windows That Populate the |
|||||
Column Code | Column Name |
Recalculate Academic Record Window |
Part Time/Full Time Update Window |
Class Rank Update Window |
Academic Standing Update Window |
Classification Update Window |
ACADEMIC_HONORS | Academic Honors |
|
|
|
x |
|
ACADEMIC_PROBATION | Academic Probation |
|
|
|
x |
|
ADVISOR_ID_NUM_1 | Advisor ID Number 1 |
? |
|
|
|
|
ADVISOR_ID_NUM_2 | Advisor ID Number 2 |
? |
|
|
|
|
ADVISOR_ID_NUM_3 | Advisor ID Number 3 |
? |
|
|
|
|
CAREER_CRTYPE1_HRS | Career Credit Type 1 Hours |
? |
|
|
|
|
CAREER_CRTYPE2_HRS | Career Credit Type 2 Hours |
? |
|
|
|
|
CAREER_CRTYPE3_HRS | Career Credit Type 3 Hours |
? |
|
|
|
|
CAREER_GPA | Career GPA |
? |
|
|
|
|
CAREER_GRADE_1_HRS | Career Grade 1 Hours |
? |
|
|
|
|
CAREER_GRADE_2_HRS | Career Grade 2 Hours |
? |
|
|
|
|
CAREER_GRADE_3_HRS | Career Grade 3 Hours |
? |
|
|
|
|
CAREER_GRADE_4_HRS | Career Grade 4 Hours |
? |
|
|
|
|
CAREER_GRADE_5_HRS | Career Grade 5 Hours |
? |
|
|
|
|
CAREER_GRADE_6_HRS | Career Grade 6 Hours |
? |
|
|
|
|
CAREER_HRS_ATTEMPT | Career Hours Attempted |
? |
|
|
|
|
CAREER_HRS_EARNED | Career Hours Earned |
? |
|
|
|
|
CAREER_HRS_GPA | Career Hours GPA |
? |
|
|
|
|
CAREER_QUAL_PTS | Career Quality Points |
? |
|
|
|
|
CLASS_CDE | Classification Code |
|
|
|
|
x |
CLASS_RANK | Class Rank |
|
|
x |
|
|
CLASS_RANK_HI_RANG | Class Rank High Range |
|
|
x |
|
|
CLASS_SIZE | Class Size |
|
|
x |
|
|
DEGREE_CDE | Degree Code |
? |
|
|
|
|
DIV_CDE | Division Code |
|
|
|
|
|
GRA_INEL_FOR_HONOR | Grade Ineligible for Honors |
x |
|
|
|
|
HONORS_HR_TOTAL | Honors Hour Total |
x |
|
|
|
|
HRS_ENROLLED | Total Hours Enrolled |
? |
x |
|
|
|
ID_NUM | ID Number |
|
? |
|
|
|
JOB_NAME | Job Name |
|
? |
|
|
|
JOB_TIME | Job Time |
|
? |
|
|
|
LAST_DTE_OF_ATTEND | Last Date of Attendance |
|
|
|
|
|
LOCAL_GPA | Local GPA |
? |
|
|
|
|
LOCAL_HRS_ATTEMPT | Local Hours Attempted |
? |
|
|
|
|
LOCAL_HRS_EARNED | Local Hours Earned |
? |
|
|
|
|
LOCAL_HRS_GPA | Local Hours GPA |
? |
|
|
|
|
LOCAL_QUAL_PTS | Local Quality Points |
? |
|
|
|
|
MAJOR_1 | Major 1 |
? |
|
|
|
|
MAJOR_2 | Major 2 |
? |
|
|
|
|
MAJOR_3 | Major 3 |
? |
|
|
|
|
MINOR_1 | Minor 1 |
? |
|
|
|
|
MINOR_2 | Minor 2 |
? |
|
|
|
|
MINOR_3 | Minor 3 |
? |
|
|
|
|
NUM_OF_CRS | Total Number of Courses |
|
x |
|
|
|
PROBATION_HR_TOTAL | Probation Hour Total |
x |
|
|
|
|
PT_FT_HRS | PT FT Hours |
? |
x |
|
|
|
PT_FT_STS | PT FT Status |
? |
x |
|
|
|
TRANSACTION_STS | Transaction Status |
? |
? |
|
|
|
TRM_CDE | Term Code |
? |
? |
|
|
|
TRM_CRTYPE1_HRS | Term Credit Type 1 Hours |
? |
|
|
|
|
TRM_CRTYPE2_HRS | Term Credit Type 2 Hours |
? |
|
|
|
|
TRM_CRTYPE3_HRS | Term Credit Type 3 Hours |
? |
|
|
|
|
TRM_GPA | Term GPA |
? |
|
|
|
|
TRM_GRADE_1_HRS | Term Grade 1 Hours |
? |
|
|
|
|
TRM_GRADE_2_HRS | Term Grade 2 Hours |
? |
|
|
|
|
TRM_GRADE_3_HRS | Term Grade 3 Hours |
? |
|
|
|
|
TRM_GRADE_4_HRS | Term Grade 4 Hours |
? |
|
|
|
|
TRM_GRADE_5_HRS | Term Grade 5 Hours |
? |
|
|
|
|
TRM_GRADE_6_HRS | Term Grade 6 Hours |
? |
|
|
|
|
TRM_HRS_ATTEMPT | Term Hours Attempted |
? |
|
|
|
|
TRM_HRS_EARNED | Term Hours Earned |
? |
|
|
|
|
TRM_HRS_GPA | Term Hours GPA |
? |
|
|
|
|
TRM_QUAL_PTS | Term Quality Points |
? |
|
|
|
|
UDEF_1A_1 | User Defined 1 Alpha 1 |
|
|
|
|
|
UDEF_1A_2 | User Defined 1 Alpha 2 |
|
|
|
|
|
UDEF_1A_3 | User Defined 1 Alpha 3 |
|
|
|
|
|
UDEF_1A_4 | User Defined 1 Alpha 4 |
|
|
|
|
|
UDEF_1A_5 | User Defined 1 Alpha 5 |
|
|
|
|
|
UDEF_2A_1 | User Defined 2 Alpha 1 |
|
|
|
|
|
UDEF_2A_2 | User Defined 2 Alpha 2 |
|
|
|
|
|
UDEF_2A_3 | User Defined 2 Alpha 3 |
|
|
|
|
|
UDEF_3_2_1 | User Defined 3_2 Numeric 1 |
|
|
|
|
|
UDEF_3_2_2 | User Defined 3_2 Numeric 2 |
|
|
|
|
|
UDEF_3A_1 | User Defined 3 Alpha 1 |
|
|
|
|
|
UDEF_3A_2 | User Defined 3 Alpha 2 |
|
|
|
|
|
UDEF_3A_3 | User Defined 3 Alpha 3 |
|
|
|
|
|
UDEF_5_2_1 | User Defined 5_2 Numeric 1 |
|
|
|
|
|
UDEF_5_2_2 | User Defined 5_2 Numeric 2 |
|
|
|
|
|
UDEF_5_2_3 | User Defined 5_2 Numeric 3 |
|
|
|
|
|
UDEF_5_2_4 | User Defined 5_2 Numeric 4 |
|
|
|
|
|
UDEF_5A_1 | User Defined 5 Alpha 1 |
|
|
|
|
|
UDEF_DTE_1 | User Defined Date 1 |
|
|
|
|
|
UDEF_DTE_2 | User Defined Date 2 |
|
|
|
|
|
UDEF_ID_1 | User Defined ID 1 |
|
|
|
|
|
USER_NAME | User Name |
|
? |
|
|
|
XFER_GPA | Transfer GPA |
? |
|
|
|
|
XFER_HRS_ATTEMPTED | Transfer Hours Attempted |
? |
|
|
|
|
XFER_HRS_EARNED | Transfer Hours Earned |
? |
|
|
|
|
XFER_HRS_GPA | Transfer Hours GPA |
? |
|
|
|
|
XFER_QUAL_PTS | Transfer Quality Points |
? |
|
|
|
|