Package sp_grading

NOTE: Please be advised that this API is currently intended to only support internal operations.
To ensure data integrity, this API is not supported when called by external applications or interfaces to manipulate data. The recommendation for external applications is to use message level integration to integrate with this entitity in Banner.

This package provides the Common Business interface for the Grading API (sp_grading).
The grading process posts both midterm and final grades for courses. These grades are unofficial until they have been rolled to academic history.

Posted grades are stored with the course registration record (SFRSTCR).
Midterm grades may be changed as needed. Once final grades have been rolled to academic history they can be changed only by an approved entry to the academic history grade record (SHRTCKG).

Midterm and final grades may not be posted for courses with gradable components.
Component marks must be used to calculate the midterm and final grades.

Program units

f_api_version	Returns the API version number.
p_post_grade	Validates all the data in the record.

Constants

M_ENTITY_NAME	Business Entity name
MID_TERM_GRADE	Global Constant
FINAL_GRADE	Global Constant

M_ENTITY_NAME

M_ENTITY_NAME    CONSTANT VARCHAR2(19) := 'GRADING';

Business Entity name

MID_TERM_GRADE

MID_TERM_GRADE   CONSTANT VARCHAR2(1)  := 'M';

Global Constant

FINAL_GRADE

FINAL_GRADE      CONSTANT VARCHAR2(1)  := 'F';

Global Constant

f_api_version

Function f_api_version RETURN PLS_INTEGER

Returns the API version number.

Returns

Version of the API signature. Changes only when the signature changes.

p_post_grade

Procedure p_post_grade(p_term_code             sfrstcr.sfrstcr_term_code%TYPE,
                       p_student_pidm          sfrstcr.sfrstcr_pidm%TYPE,
                       p_crn                   sfrstcr.sfrstcr_crn%TYPE,
                       p_faculty_pidm          sirasgn.sirasgn_pidm%TYPE,
                       p_grade_type            VARCHAR2,
                       p_grade_assigned        sfrstcr.sfrstcr_grde_code%TYPE DEFAULT dml_common.f_unspecified_string,
                       p_grde_code_incmp_final sfrstcr.sfrstcr_grde_code_incmp_final%TYPE DEFAULT NULL,
                       p_incomplete_ext_date   sfrstcr.sfrstcr_incomplete_ext_date%TYPE DEFAULT NULL)

Validates all the data in the record.
Updates a record.
Validates the parameter values.

Parameters

	p_term_code	Registration term code. VARCHAR2(6) Required Key
	p_student_pidm	Internal Identification Number of the student. NUMBER(8) Required Key
	p_crn	Course reference number associated with the class section. VARCHAR2(5) Required Key
	p_faculty_pidm	Internal Identification Number of the faculty member. NUMBER(8) Required Key
	p_grde_type	Indicates whether the provided grade is a midterm or final grade. VARCHAR2(2) Required Key
	p_grde_assigned	Actual grade value assigned for the student by the faculty member. VARCHAR2(6) Required Key
	p_grde_code_incmp_final	Actual Grade code to identify default final grade for incomplete coursework. VARCHAR2(6)
	p_incomplete_ext_date	Date to identify when the default final grade will be applied if coursework is incomplete. DATE