SSR_RES_MAP_VW

(SQL View)
 Index Back

Result Mapping Detail Record

This record contains detailed result mapping information for a specified result map for Activity Management (Activity Setup).

SELECT DISTINCT SETID ,SSR_RES_MAP_ID , EFFDT , GRADING_SCHEME , GRADING_BASIS , CRSE_GRADE_INPUT FROM PS_SSR_RES_MAP_DTL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SETID_TBL

2 SSR_RES_MAP_ID_KEY Character(12) VARCHAR2(12) NOT NULL Result Scale
3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 GRADING_SCHEME Character(3) VARCHAR2(3) NOT NULL Grading Scheme
5 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)
6 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
A=A

Prompt Table: GRADE_TBL