Student Schedule Window (Financial Aid Inquiry)

This window displays the schedule for the ID Number and Registration Year and Term selected on the Financial Aid Inquiry window. The student's schedule data is consistent with the student schedule generated by the Registrar's Office. Full course title and information regarding any day or time override is not included. You can also view other year-term combinations for the selected student.

Columns

The following information is displayed:

Course

End Time

Title

Location

Status

Building

Credits

Room

Subterm

Instructor

Days

Instructor Name

Begin Time

 

Data Sources

The data sources for the data on this tab are detailed in the tables below:

Selection Criteria

Data defaults to information from the Registration Configuration

ID #

Data defaults to ID # selected from FA Inquiry prompt

Data selects from STUDENT_CRS_HIST.ID_NUM

Year

Data defaults to value from REG_CONFIG.CUR_YR_DFLT

Data selects against STUDENT_CRS_HIST.YR_CDE

Term

Data defaults to value from REG_CONFIG.CUR_TRM_DFLT

Data selects against STUDENT_CRS_HIST.TRM_CDE

Subterm

Data defaults to Null

Data selects against STUDENT_CRS_HIST.SUBTRM_CDE

 

Schedule Grid

Data is primarily from Student Course History and Section Schedules tables

Course Code

STUDENT_CRS_HIST.CRS_CDE

Title

STUDENT_CRS_HIST.CRS_TITLE

Status

STUDENT_CRS_HIST.TRANSACTION_STS

Credits

STUDENT_CRS_HIST.CREDIT_HRS

Subterm

STUDENT_CRS_HIST.SUBTERM_CDE

Days

COMPUTED COLUMN from SECTION_SCHEDULES table:

monday_cde +

tuesday_cde +

wednesday_cde +

thursday_cde +

friday_cde +

saturday_cde +

sunday_cde

Begin/End Time

COMPUTED COLUMN from SECTION_SCHEDULES table:

begin_tim + end_tim

Location

SECTION_SCHEDULES.LOC_CDE

Building

SECTION_SCHEDULES.BLDG_CDE

Room

SECTION_SCHEDULES.ROOM_CDE

Instructor

SECTION_SCHEDULES.PROFESSOR_ID_NUM

Instructor Name

Name is from the NameMaster table