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 | Character(5) | VARCHAR2(5) NOT NULL | 
SetID
 Default Value: OPR_DEF_TBL_CS.SETID_CAREER Prompt Table: SETID_TBL  | 
|
| 2 | Character(3) | VARCHAR2(3) NOT NULL | 
Grading Scheme
 Prompt Table: GRADESCHEME_TBL  | 
|
| 3 | Date(10) | DATE NOT NULL | 
Effective Date
 Default Value: %date  | 
|
| 4 | 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  |