SETIDGRADING_SCHEME_EXTEFFDTGRADING_BASIS_EXTCD=Non-Conforming Grading System
GRD=Conforming Grading System
PN=Pass/Non-Pass
UNG=Ungraded
CRSE_GRADE_INPUTA=A
GRD_NOCNV_EXTVW(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 SETID, GRADING_SCHEME, EFFDT, GRADING_BASIS, CRSE_GRADE_INPUT, DESCR, DESCRSHORT, GRADE_POINTS, EARN_CREDIT, INCLUDE_IN_GPA from PS_GRADE_TBL where GRADE_CONVERT = ' ' |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 8 | GRADE_POINTS | Number(10,3) | DECIMAL(9,3) NOT NULL | Grade Points |
| 9 | EARN_CREDIT | Character(1) | VARCHAR2(1) NOT NULL | Earn Credit |
| 10 | INCLUDE_IN_GPA | Character(1) | VARCHAR2(1) NOT NULL | Include in GPA |