SSR_HE_MODULE(SQL Table) |
Index Back |
---|---|
Module Outcome Mappings |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
2 | GRADING_SCHEME | Character(3) | VARCHAR2(3) NOT NULL |
Grading Scheme
Prompt Table:
GRADESCHEME_TBL
|
3 | 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) |
4 | CRSE_GRADE_INPUT | Character(3) | VARCHAR2(3) NOT NULL |
Grade Input
A=A Prompt Table: GRADE_TBL |
5 | GRADE_CATEGORY | Character(4) | VARCHAR2(4) NOT NULL |
The default value of NONE is delivered with the system and should not be deleted.
TXFR=Transfer Pass (Sample) Prompt Table:
GRADE_CAT_VW2
|
6 | SSR_HE_MODULE_OUT | Character(30) | VARCHAR2(30) NOT NULL |
HESA Module Outcome
Prompt Table: SSR_HE_CODE_VW |
7 | SSR_HE_ACTIVE | Character(1) | VARCHAR2(1) NOT NULL |
Active
Y/N Table Edit Default Value: Y |
8 | SSR_HE_MODOUTCOME | Character(30) | VARCHAR2(30) NOT NULL |
Outcome
Prompt Table: SSR_HE_MDOUT_VW |
9 | SSR_HE_MODRESULT | Character(30) | VARCHAR2(30) NOT NULL |
Result
Prompt Table: SSR_HE_MDRST_VW |