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 |