SSR_RES_MAP_DTL

(SQL Table)
 Index Back

Result Mapping Detail Record

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

  • Related Language Record: SSR_RES_MPDTLNG

  • Parent record: SSR_RES_MPDTLVW

    • # 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 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 SSR_RES_MARK_EXC Character(1) VARCHAR2(1) NOT NULL Exclude Mark

    Y/N Table Edit

    Default Value: N

    11 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
    A=A

    Prompt Table: GRADE_TBL

    12 SSR_AC_DEFAULT Character(1) VARCHAR2(1) NOT NULL Default Mark

    Y/N Table Edit

    Default Value: N

    13 SSR_RESULTS_STATUS Character(1) VARCHAR2(1) NOT NULL Result Status
    A=Audit
    F=Fail
    I=Incomplete
    P=Pass
    W=Withdrawn
    14 SSR_RESITS_ALLOWED Character(1) VARCHAR2(1) NOT NULL This field indicates if resits are allowed.

    Y/N Table Edit

    Default Value: N

    15 SSR_AC_MAND_FAIL Character(1) VARCHAR2(1) NOT NULL Use for Mandatory Fail

    Y/N Table Edit

    Default Value: N

    16 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    17 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    18 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    19 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    20 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time