SETIDGRADING_SCHEME_EXTEFFDTGRADING_BASIS_EXTCD=Non-Conforming Grading System
GRD=Conforming Grading System
PN=Pass/Non-Pass
UNG=Ungraded
CRSE_GRADE_INPUTA=A
LANGUAGE_CDGRD_NOCNV_EXTVL(SQL View) |
Index Back |
|---|---|
Grade Table No Conv Vw/+EffdtThis is a prompt view of the Grade table . It is used to rename Course Grade Input to Course Grade Official so that Grade Points, Earn Credit and Include in GPA will default correctly. The Set Control ID is TRNSFR_SRC_ID. |
| SELECT a.SETID , a.GRADING_SCHEME , a.EFFDT , a.GRADING_BASIS , a.CRSE_GRADE_INPUT , b.LANGUAGE_CD , b.DESCR , b.DESCRSHORT FROM PS_GRADE_TBL a , PS_GRADE_TBL_LANG b WHERE a.GRADE_CONVERT = ' ' AND a.SETID = b.SETID AND a.GRADING_SCHEME = b.GRADING_SCHEME AND a.EFFDT = b.EFFDT AND a.GRADING_BASIS = b.GRADING_BASIS AND a.CRSE_GRADE_INPUT = b.CRSE_GRADE_INPUT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | GRADING_SCHEME_EXT |
Character(3) | VARCHAR2(3) NOT NULL | External Grading Scheme |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | GRADING_BASIS_EXT |
Character(3) | VARCHAR2(3) NOT NULL |
External Grading Basis
CD=Non-Conforming Grading System GRD=Conforming Grading System PN=Pass/Non-Pass UNG=Ungraded |
| 5 | CRSE_GRADE_INPUT |
Character(3) | VARCHAR2(3) NOT NULL |
Grade Input
A=A |
| 6 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |