GRD_BASE_CHC_VW(SQL View) |
Index Back |
---|---|
Grade Basis Choice Table ViewThis 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. |
SELECT a.setid , a.grading_scheme , a.effdt , a.grading_basis , a.grade_basis_choice , b.eff_status , c.descrformal FROM ps_grd_base_choice a , ps_gradescheme_tbl b , PS_GRADE_BASIS_TBL c WHERE a.setid = b.setid AND a.grading_scheme = b.grading_scheme AND a.effdt = b.effdt AND b.setid = c.setid AND b.grading_scheme = c.grading_scheme AND b.effdt = c.effdt AND a.grade_basis_choice = c.grading_basis |
# | 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 | Character(3) | VARCHAR2(3) NOT NULL |
Grading Basis Choice
AUD=Audited GRD=Graded NOG=No Grade Associated SUO=S/U Exclusive SUS=Satisfactory/Unsatisfactory |
|
6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
7 | DESCRFORMAL | Character(50) | VARCHAR2(50) NOT NULL | Formal Description field |