STDNT_AGRMNT_CR

(SQL Table)
 Index Back

Student Agreement Courses

This table lists the courses included in the Student Specific Agreement. The first part of the record is for the external course. It describes the class to be taken from the outside institution, the minimum units the student will take it for, the minimum grade or grade points, and whether the student will take it as a graded course or not. The second part of the record is for the equivalent course. It specifies the units and grade the student will earn if the conditions described on the first part of the record is satisfied.

  • Parent record: STDNT_AGRMNT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine

    Default Value: OPR_DEF_TBL_CS.ACAD_CAREER

    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    4 TRNSFR_SRC_ID Character(11) VARCHAR2(11) NOT NULL Source ID

    Prompt Table: %EDITTABLE

    5 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    6 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number
    7 SCHOOL_SUBJECT Character(8) VARCHAR2(8) NOT NULL School Subject

    Prompt Table: SCHL_SUBJ_TRVW

    8 SCHOOL_CRSE_NBR Character(10) VARCHAR2(10) NOT NULL School Course Nbr

    Prompt Table: SCHL_CRSE_TRVW

    9 CRSE_ID_EXT Character(6) VARCHAR2(6) NOT NULL External Course ID

    Prompt Table: CRSE_CAT_TC2_VW

    10 CRSE_OFFER_NBR_EXT Number(2,0) SMALLINT NOT NULL External Course Offering Nbr

    Prompt Table: CRSE_OFFER_EXVW

    11 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
    12 GRADING_SCHEME_EXT Character(3) VARCHAR2(3) NOT NULL External Grading Scheme

    Prompt Table: GRD_SCHM_EXT_VW

    13 GRADING_BASIS_EXT Character(3) VARCHAR2(3) NOT NULL External Grading Basis
    CD=Non-Conforming Grading System
    GRD=Conforming Grading System
    PN=Pass/Non-Pass
    UNG=Ungraded

    Prompt Table: GRD_BASE_EXT_VW

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

    Prompt Table: GRD_NOCNV_EXTVW

    15 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID

    Prompt Table: CRSE_CAT_TC_VW

    16 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr

    Prompt Table: CRSE_OFFER

    17 UNT_TRNSFR Number(9,3) DECIMAL(8,3) NOT NULL Units Transferred
    18 GRADING_SCHEME Character(3) VARCHAR2(3) NOT NULL Grading Scheme

    Prompt Table: GRADESCHEME_TBL

    19 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)

    Prompt Table: GRADE_BASE_E_VW

    20 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade

    Prompt Table: GRD_NO_CNV_VW