GRDBASECHCVWLNG(SQL View) |
Index Back |
---|---|
Grade Basis Choice Table ViewGRDBASECHCVWLNG is the language record related to GRD_BASE_CHC_VW A related language record enables text fields on a table to be translated into various languages for use in other countries. |
SELECT a.setid , a.grading_scheme , a.effdt , a.grading_basis , a.grade_basis_choice , c.language_cd , c.descrformal FROM PS_GRD_BASE_CHOICE a , ps_gradescheme_tbl b , ps_grade_basis_lng 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 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
7 | DESCRFORMAL | Character(50) | VARCHAR2(50) NOT NULL | Formal Description field |