GRADE_BASE_D_VW(SQL View) |
Index Back |
---|---|
Grading Basis Table ViewThis view is a prompt/edit table for Class Association Grading Basis, i.e., the grading basis under which courses can be offered. Converted grading basis are excluded. |
select a.setid, a.grading_scheme, a.effdt, a.grading_basis, b.eff_status from PS_GRADE_BASIS_TBL a , ps_gradescheme_tbl b where a.grading_basis_conv = ' ' and a.setid = b.setid and a.grading_scheme = b.grading_scheme and a.effdt = b.effdt |
# | 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 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |