Populating the Student Term Summary Division Table

Processes in these windows populate certain columns of the Student Term Summary Division Table.

Recalculate Academic Record Window

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

 

Part Time/Full Time Update Window

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

 

Class Rank Update

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

 

Academic Standing Update Window

Student Term Summary Division Table

Column Code

Column Name

ACADEMIC_HONORS

Academic Honors

ACADEMIC_PROBATION

Academic Probation

 

Classification Update Window

Student Term Summary Division Table

Column Code

Column Name

CLASS_CDE

Classification Code

 

Combined Table

This table combines the information from the previous tables.

Columns in the
Student Term Summary Division Table

Windows That Populate the
Student Term Summary Division Table

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

?