SSR_IAM_MPGRVWL

(SQL View)
 Index Back

Rel Lang for SSR_IAM_MPGRDVW

Related Language for SSR_IAM_MPGRDVW

SELECT DISTINCT A.SETID ,A.SSR_RES_MAP_ID ,A.EFFDT ,A.GRADING_SCHEME ,A.GRADING_BASIS ,A.SEQUENCE_NO ,A.SSR_CW_SCORE ,A.SSR_RES_SCORE_NUM ,A.SSR_CW_MARK ,A.CRSE_GRADE_INPUT ,A.SSR_RESULTS_STATUS ,AL.LANGUAGE_CD ,BL.DESCR ,AL.DESCR FROM PS_SSR_RES_MAP_DTL A , PS_SSR_RES_MPDTLNG AL , PS_GRADE_TBL B , PS_GRADE_TBL_LANG BL WHERE A.CRSE_GRADE_INPUT <> ' ' AND AL.SETID = A.SETID AND AL.SSR_RES_MAP_ID = A.SSR_RES_MAP_ID AND AL.EFFDT = A.EFFDT AND AL.GRADING_SCHEME = A.GRADING_SCHEME AND AL.GRADING_BASIS = A.GRADING_BASIS AND AL.SEQUENCE_NO = A.SEQUENCE_NO AND B.SETID = A.SETID AND B.GRADING_SCHEME = A.GRADING_SCHEME AND B.GRADING_BASIS = A.GRADING_BASIS AND B.CRSE_GRADE_INPUT = A.CRSE_GRADE_INPUT AND B.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PS_GRADE_TBL B2 WHERE B2.SETID = A.SETID AND B2.GRADING_SCHEME = A.GRADING_SCHEME AND B2.GRADING_BASIS = A.GRADING_BASIS AND B2.CRSE_GRADE_INPUT = A.CRSE_GRADE_INPUT AND B2.EFFDT <= A.EFFDT) AND BL.SETID = B.SETID AND BL.GRADING_SCHEME = B.GRADING_SCHEME AND BL.EFFDT = B.EFFDT AND BL.GRADING_BASIS = B.GRADING_BASIS AND BL.CRSE_GRADE_INPUT = B.CRSE_GRADE_INPUT UNION SELECT DISTINCT A.SETID ,A.SSR_RES_MAP_ID ,A.EFFDT ,A.GRADING_SCHEME ,A.GRADING_BASIS ,A.SEQUENCE_NO ,A.SSR_CW_SCORE ,A.SSR_RES_SCORE_NUM ,A.SSR_CW_MARK ,A.CRSE_GRADE_INPUT ,A.SSR_RESULTS_STATUS ,AL.LANGUAGE_CD ,' ' ,AL.DESCR FROM PS_SSR_RES_MAP_DTL A , PS_SSR_RES_MPDTLNG AL WHERE A.CRSE_GRADE_INPUT = ' ' AND AL.SETID = A.SETID AND AL.SSR_RES_MAP_ID = A.SSR_RES_MAP_ID AND AL.EFFDT = A.EFFDT AND AL.GRADING_SCHEME = A.GRADING_SCHEME AND AL.GRADING_BASIS = A.GRADING_BASIS AND AL.SEQUENCE_NO = A.SEQUENCE_NO

  • Related Language Record for SSR_IAM_MPGRDVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 SSR_RES_MAP_ID Character(12) VARCHAR2(12) NOT NULL Result Scale
    3 EFFDT Date(10) DATE 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 SEQUENCE_NO Number(3,0) SMALLINT NOT NULL Sequence #
    7 SSR_CW_SCORE Character(8) VARCHAR2(8) NOT NULL Score
    8 SSR_RES_SCORE_NUM Number(19,9) DECIMAL(18,9) NOT NULL Score
    9 SSR_CW_MARK Number(19,9) DECIMAL(18,9) NOT NULL Mark
    10 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
    A=A
    11 SSR_RESULTS_STATUS Character(1) VARCHAR2(1) NOT NULL Result Status
    A=Audit
    F=Fail
    I=Incomplete
    P=Pass
    W=Withdrawn
    12 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    13 DESCR30 Character(30) VARCHAR2(30) NOT NULL Description
    14 DESCR Character(30) VARCHAR2(30) NOT NULL Description