GRADE_BASIS_VW1(SQL View) |
Index Back |
---|---|
Grading Basis TableThis table contains the valid values for Grading basis and its corresponding properties. |
SELECT a.SETID , a.GRADING_SCHEME , a.EFFDT , a.GRADING_BASIS , a.DESCRFORMAL , a.INCLUDE_IN_GPA , a.PRINT_ON_XCRIPT , a.GRADING_BASIS_CONV , a.ELECT_GRADE_BASIS , a.GRADE_BASIS_CHOICE , a.PRINT_GRD_DESCR , a.AUDIT_GRADE_BASIS , a.GRADE_REQUIRED FROM PS_GRADE_BASIS_TBL a |
# | 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 | GRADING_SCHEME | Character(3) | VARCHAR2(3) NOT NULL |
Grading Scheme
Prompt Table: GRADESCHEME_TBL |
3 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
4 | 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) |
5 | DESCRFORMAL | Character(50) | VARCHAR2(50) NOT NULL | Formal Description field |
6 | INCLUDE_IN_GPA | Character(1) | VARCHAR2(1) NOT NULL |
Include in GPA
Y/N Table Edit Default Value: Y |
7 | PRINT_ON_XCRIPT | Character(1) | VARCHAR2(1) NOT NULL |
Print On Transcript
Y/N Table Edit Default Value: Y |
8 | GRADING_BASIS_CONV | Character(3) | VARCHAR2(3) NOT NULL |
Grading Basis Convert
Prompt Table: GRADE_BASE_D_VW |
9 | ELECT_GRADE_BASIS | Character(1) | VARCHAR2(1) NOT NULL |
Elective Grading Basis
Y/N Table Edit Default Value: N |
10 | 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 Prompt Table: GRD_BASE_CHOICE |
11 | PRINT_GRD_DESCR | Character(1) | VARCHAR2(1) NOT NULL |
Print Grade Basis Desc
N=Do not print Grade Basis Descr Y=Print Grade Basis Description Y/N Table Edit Default Value: Y |
12 | AUDIT_GRADE_BASIS | Character(1) | VARCHAR2(1) NOT NULL |
Audit Grading Basis
Y/N Table Edit Default Value: N |
13 | GRADE_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
Grade Required
Y/N Table Edit Default Value: Y |