Satisfactory Academic Progress Source Data

The following data elements are populated into the PF_SAP_HIST table during the Calculate Satisfactory Progress process. This data population occurs for all selected calculation methods.

If your school requires additional data values or even a different calculation method for an existing auto-set column, the CUST_CALCULATE_SAP_SP is a shell stored procedure that will allow you to reset data, populate columns not pre-set, or populate data into PF_SAP_HIST_UDF as needed.

Column Label

Notes

ID_NUM

ID_NUM of student

TRM_CDE

TRM_CDE evaluated

YR_CDE

YR_CDE evaluated

DIV_CDE

STUDENT_MASTER.CUR_STUD_DIV of student

DEGREE_CDE

DEGREE_HISTORY.DEGR_CDE of student where DEGREE_HISTORY.CUR_DEGREE = 'Y'.

MAJOR_1

DEGREE_HISTORY.MAJOR_1 of student where DEGREE_HISTORY.CUR_DEGREE = 'Y'.

RULE_VALUE

Set by Rules Update or Stored Procedure.

ENROLL_TYPE

PF_DIV_LOAD_DEF.POE_LOAD_CDE where student's STUDENT_TERM_SUM.HRS_ENROLLED values into the minimum and maximum hours based on their current student division.

Values will be one of the following: 1=Full-time, 2=Three-Quarter time, 3=Half time, 4=Less than Half time

TRM_GPA

STUD_TERM_SUM_DIV.TRM_GPA of student and current division

SAP_TRM_ GPA

If PF_CONFIG.CALCULATE_SAP_GPA = ???N??? Then SAP_TRM_GPA = 0.00

Else perform SAP calculation using the sum of hours attempted, hours earned, and gpa hours as defined in GRADE_TABLE in combination with the included FA SAP CREDIT_TYPE_DEF codes for the selected term

Use same rounding/truncation options as Registration.

TRM_HRS_ATTEMPTED

SUM(CREDIT_HRS) from STUDENT_CRS_HIST based on FA SAP Hours Attempted checkbox in GRADE_TABLE and SAP included CREDIT_TYPE_DEF for the selected term.

TRM_HRS_EARNED

SUM(CREDIT_HRS) from STUDENT_CRS_HIST based on FA SAP Hours Earned checkbox in GRADE_TABLE and SAP included CREDIT_TYPE_DEF for the selected term.

YR_GPA

Will not be set by standard process.  Will require use of stored procedure option to be set.

YR_HRS_ATTEMPTED

SUM(CREDIT_HRS) from STUDENT_CRS_HIST based on FA SAP Hours Attempted checkbox in GRADE_TABLE and SAP included CREDIT_TYPE_DEF for the selected year. Include all terms for the year as of the selected term.

YR_HRS_EARNED

SUM(CREDIT_HRS) from STUDENT_CRS_HIST based on FA SAP Hours Earned checkbox in GRADE_TABLE and SAP included CREDIT_TYPE_DEF for the selected year. Include all terms for the year as of the selected term.

CUMULATIVE_GPA

If PF_CONFIG.GPA_CHOICE = ???L???, Then STUDENT_DIV_MAST.LOCAL_GPA Else Select STUDENT_DIV_MAST.CAREER_GPA

SAP_CUM_GPA

If PF_CONFIG.CALCULATE_SAP_GPA = ???N??? Then SAP_CUM_GPA = 0.00

Else perform SAP calculation using the sum of hours attempted, hours earned and gpa hours as defined in GRADE_TABLE in combination with the included FA SAP CREDIT_TYPE_DEF codes for all terms as of the selected term

 Use same rounding/truncation options as Registration.

CUM_HRS_ATTEMPTED

SUM(CREDIT_HRS) from STUDENT_CRS_HIST based on FA SAP Hours Attempted checkbox in GRADE_TABLE and SAP included CREDIT_TYPE_DEF for all terms as of the selected term.

 

CUM_HRS_EARNED

SUM(CREDIT_HRS) from STUDENT_CRS_HIST based on FA SAP Hours Earned checkbox in GRADE_TABLE and SAP included CREDIT_TYPE_DEF for all terms as of the selected term.

TOTAL_HRS_ATTEMPTED

Same as CUM_HRS_ATTEMPTED.

CURRENT_HRS_IN_PROGRESS

STUDENT_TERM_SUM. HRS_ENROLLED for student and selected term.

ACTUAL_TRM_COUNT

Will not be set by standard process.  Will require use of stored procedure option to be set.

SAP_TRM_COUNT

Will not be set by standard process.  Will require use of stored procedure option to be set.

CURRENT_PROGRESS_1

Set by Stored Procedure or Rules Update

PREVIOUS_PROGRESS_1

Select PF_SAP_HIST.FINAL_PROGRESS_1 from the latest PF_SAP_HIST row.  Determine the latest row based on descending order of PF_SAP_HIST.YR_CDE or PF_SAP_HIST.YR_CDE and PF_SAP_HIST. TRM_CDE

FINAL_PROGRESS_1

Set by Stored Procedure or Rules Update/Client manually sets

APPEAL_1

Manually populated

CURRENT_ PROGRESS_2

Set by Stored Procedure or Rules Update

PREVIOUS_PROGRESS_2

Select PF_SAP_HIST.FINAL_PROGRESS_2 from the latest PF_SAP_HIST row.  Determine the latest row based on descending order of PF_SAP_HIST.YR_CDE or PF_SAP_HIST.YR_CDE and PF_SAP_HIST.TRM_CDE

FINAL_PROGRESS_2

Set by Stored Procedure or Rules Update/Client manually sets

APPEAL_2

Manually populated

CURRENT_PROGRESS_3

Set by Stored Procedure or Rules Update

PREVIOUS_ PROGRESS_3

Select PF_SAP_HIST.FINAL_PROGRESS_3 from the latest PF_SAP_HIST row.  Determine the latest row based on descending order of PF_SAP_HIST.YR_CDE or PF_SAP_HIST.YR_CDE and PF_SAP_HIST.TRM_CDE

FINAL_PROGRESS_3

Set by Stored Procedure or Rules Update/Client manually sets

APPEAL_3

Manually populated

UPDATE_PF

Set by option to send to PowerFAIDS

LOCKED

Manually populated