Financial_Aid_Academic_Progress table

This table defines a student’s academic progress for financial aid.

Oracle source: ReportsNet.FINANCIAL_AID_ACAD_PROGRESS_DW view

Oracle objects: RORSAPR, RTVSAPR

Updated: nightly

Oracle Field/Calc

DW Field

Description or Sample

RORSAPR_PIDM

PIDM

Student’s PIDM

RORSAPR_TERM_CODE

TERM

Academic standing for financial aid for a given term

RORSAPR_SAPR_CODE

SAPR_CODE

SATISFACTORY ACADEMIC PROGRESS CODE: This field maintains the student's SAP c ode associated with the term code in this record.

RTVSAPR_DESC

SAPR_DESC

SAPR_CODE description

RORSAPR_SAPR_CODE_CALC

CALC_SAPR_CODE

CALCULATED SAP STATUS CODE: Code which represents the calculated academic progress of applicants and aid recipients for the most recently completed term.

RTVSAPR_DESC

CALC_SAPR_DESC

CALC_SAPR_CODE description