SSR_APTSY_RESVW

(SQL View)
Index Back

SELECT DISTINCT SETID ,SSR_RES_MAP_ID , EFFDT , GRADING_SCHEME , GRADING_BASIS , CRSE_GRADE_INPUT , SSR_RESULTS_STATUS 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 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

Prompt Table: GRADESCHEME_TBL

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

7 SSR_RESULTS_STATUS Character(1) VARCHAR2(1) NOT NULL Result Status
A=Audit
F=Fail
I=Incomplete
P=Pass
W=Withdrawn