GRD_BASE_CHC_2 (SQL View)	Index Back
Grade Basis Choice Table View This Grade Basis Choice view is used as an edit table for Student Enrollment Grading Basis Enrl if the Grading Basis for a given course is elective. This view is used as a prompt in situations where a student enrolls in a course that belongs to a different career, and so grading basis values have to be re-mapped. It joins the Grading Basis Choice table with the Grading Basis Exception Mapping Detail so that the course grading bases options are automatically re-mapped to the students grading basis.

GRD_BASE_CHC_2

(SQL View)

Grade Basis Choice Table View

This Grade Basis Choice view is used as an edit table for Student Enrollment Grading Basis Enrl if the Grading Basis for a given course is elective. This view is used as a prompt in situations where a student enrolls in a course that belongs to a different career, and so grading basis values have to be re-mapped. It joins the Grading Basis Choice table with the Grading Basis Exception Mapping Detail so that the course grading bases options are automatically re-mapped to the students grading basis.

SELECT a.SETID , a.GRADING_SCHEME , x.GRADING_SCHEME , a.EFFDT , a.GRADING_BASIS , a.GRADE_BASIS_CHOICE , c.GB_MAP_RULE , c.GRADING_BASIS_ENRL , b.EFF_STATUS FROM PS_GRD_BASE_CHOICE a , PS_GRADESCHEME_TBL b , PS_GB_EXC_MAP_DTL c , PS_GRD_BASE_CHOICE x , PS_GRADESCHEME_TBL y WHERE a.SETID = b.SETID AND a.GRADING_SCHEME = b.GRADING_SCHEME AND a.EFFDT = b.EFFDT AND a.SETID = c.INSTITUTION AND c.EFFDT = ( SELECT MAX(c1.EFFDT) FROM PS_GB_EXC_MAP_DTL c1 WHERE c1.INSTITUTION=c.INSTITUTION AND c1.GB_MAP_RULE=c.GB_MAP_RULE AND c1.EFFDT<=a.EFFDT) AND a.GRADE_BASIS_CHOICE = c.GRADING_BASIS AND c.GRADING_BASIS_INV = 'N' AND x.SETID = y.SETID AND x.GRADING_SCHEME = y.GRADING_SCHEME AND x.EFFDT = y.EFFDT AND y.EFFDT = ( SELECT MAX(y1.EFFDT) FROM PS_GRADESCHEME_TBL y1 WHERE y1.SETID=y.SETID AND y1.GRADING_SCHEME=y.GRADING_SCHEME AND y1.EFFDT<=a.EFFDT) AND y.EFF_STATUS = 'A' AND a.SETID = x.SETID AND a.GRADING_BASIS = x.GRADING_BASIS AND c.GRADING_BASIS_ENRL = x.GRADE_BASIS_CHOICE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_CS.SETID_CAREER
Prompt Table: SETID_TBL

2 CRSE_GRD_SCHEME Character(3) VARCHAR2(3) NOT NULL Grading Scheme

3 GRADE_SCHEME_STDNT Character(3) VARCHAR2(3) NOT NULL Student Grading Scheme

4 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

5 GRADING_BASIS Character(3) VARCHAR2(3) NOT NULL Grading Basis
ANC=ABC/NC Grading
AUD=Audit
BMT=Multi-Term Course: Not Graded
CNC=Credit / No Credit
EQV=Equivalent
GRD=Graded
HSC=Hundred Point Scale (NLD)
LAW=Law
MED=Medical School Grades
NOG=No Grade Associated
NON=Non-Graded Component
NQF=NQF Scale
OPT=Student Option
PNP=Pass/Not Pass
SUS=Satisfactory/Unsatisfactory
TRN=Transfer Grading Basis
TSC=Ten Point Scale (NLD)
Prompt Table: GRADE_BASIS_TBL

6 GRADE_BASIS_CHOICE Character(3) VARCHAR2(3) NOT NULL Grading Basis Choice
AUD=Audited
GRD=Graded
NOG=No Grade Associated
SUO=S/U Exclusive
SUS=Satisfactory/Unsatisfactory

7 GB_MAP_RULE Character(5) VARCHAR2(5) NOT NULL Grading Basis Mapping Rule

8 GRADING_BASIS_CONV Character(3) VARCHAR2(3) NOT NULL Grading Basis Convert

9 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_CS.SETID_CAREER Prompt Table: SETID_TBL
2	CRSE_GRD_SCHEME	Character(3)	VARCHAR2(3) NOT NULL	Grading Scheme
3	GRADE_SCHEME_STDNT	Character(3)	VARCHAR2(3) NOT NULL	Student Grading Scheme
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	GRADING_BASIS	Character(3)	VARCHAR2(3) NOT NULL	Grading Basis ANC=ABC/NC Grading AUD=Audit BMT=Multi-Term Course: Not Graded CNC=Credit / No Credit EQV=Equivalent GRD=Graded HSC=Hundred Point Scale (NLD) LAW=Law MED=Medical School Grades NOG=No Grade Associated NON=Non-Graded Component NQF=NQF Scale OPT=Student Option PNP=Pass/Not Pass SUS=Satisfactory/Unsatisfactory TRN=Transfer Grading Basis TSC=Ten Point Scale (NLD) Prompt Table: GRADE_BASIS_TBL
6	GRADE_BASIS_CHOICE	Character(3)	VARCHAR2(3) NOT NULL	Grading Basis Choice AUD=Audited GRD=Graded NOG=No Grade Associated SUO=S/U Exclusive SUS=Satisfactory/Unsatisfactory
7	GB_MAP_RULE	Character(5)	VARCHAR2(5) NOT NULL	Grading Basis Mapping Rule
8	GRADING_BASIS_CONV	Character(3)	VARCHAR2(3) NOT NULL	Grading Basis Convert
9	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive