STDNT_OEE_LAMVW

(SQL View)
 Index Back

Gradebook: Student Enrl

Join STDNT_ENRL and STDNT_ENRL_OEE, with more records for finding grading scheme.

SELECT A.STRM , A.CLASS_NBR , A.EMPLID , A.STDNT_ENRL_STATUS , A.ENRL_STATUS_REASON , A.GRADING_BASIS_ENRL , A.CRSE_CAREER , B.GRADING_SCHEME , A.ACAD_CAREER , C.GRADING_SCHEME , E.ACAD_PROG_PRIMARY , F.CAR_PTR_EXC_RULE , A.RQMNT_DESIGNTN , A.RQMNT_DESIGNTN_OPT , A.CRSE_GRADE_INPUT , G.START_DT , G.FULLY_GRADED_DT FROM PS_STDNT_ENRL A , PS_ACAD_CAR_TBL B , PS_ACAD_CAR_TBL C , PS_TERM_TBL D , PS_STDNT_CAR_TERM E , PS_ACAD_PROG_TBL F , PS_STDNT_ENRL_OEE G WHERE A.INSTITUTION = B.INSTITUTION AND A.CRSE_CAREER = B.ACAD_CAREER AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_ACAD_CAR_TBL B1 WHERE B1.INSTITUTION = B.INSTITUTION AND B1.ACAD_CAREER = B.ACAD_CAREER AND B1.EFFDT <= D.TERM_BEGIN_DT AND B1.EFF_STATUS = 'A') AND A.INSTITUTION = C.INSTITUTION AND A.ACAD_CAREER = C.ACAD_CAREER AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_ACAD_CAR_TBL C1 WHERE C1.INSTITUTION = C.INSTITUTION AND C1.ACAD_CAREER = C.ACAD_CAREER AND C1.EFFDT <= D.TERM_BEGIN_DT AND C1.EFF_STATUS = 'A') AND A.INSTITUTION = D.INSTITUTION AND A.ACAD_CAREER = D.ACAD_CAREER AND A.STRM = D.STRM AND E.EMPLID = A.EMPLID AND E.ACAD_CAREER = A.ACAD_CAREER AND E.INSTITUTION = A.INSTITUTION AND E.STRM = A.STRM AND F.INSTITUTION = A.INSTITUTION AND F.ACAD_PROG = E.ACAD_PROG_PRIMARY AND F.EFFDT = ( SELECT MAX(F1.EFFDT) FROM PS_ACAD_PROG_TBL F1 WHERE F1.INSTITUTION = F.INSTITUTION AND F1.ACAD_PROG = F.ACAD_PROG AND F1.EFFDT <= D.TERM_BEGIN_DT AND F1.EFF_STATUS = 'A') AND A.STRM = G.STRM AND A.EMPLID = G.EMPLID AND A.INSTITUTION = G.INSTITUTION AND A.ACAD_CAREER = G.ACAD_CAREER AND A.DYN_CLASS_NBR = G.CLASS_NBR

  • Parent record: LAM_CLASS_ACTV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_TBL

    2 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    4 STDNT_ENRL_STATUS Character(2) VARCHAR2(2) NOT NULL Student Enrollment Status
    D=Dropped
    E=Enrolled
    W=Waiting
    5 ENRL_STATUS_REASON Character(4) VARCHAR2(4) NOT NULL Enrollment Status Reason
    ADRP=Administrative Drop
    ALIM=Appointment Limit Exceeded
    CANC=Dropped (class cancelled)
    CREQ=Co-Requisite Enrollment
    DROP=Dropped (was enrolled)
    DRWL=Dropped (was wait listed)
    ENRL=Enrolled
    EWAT=Enrolled from Wait List
    FULL=Section is Full
    RCAP=Reserve Slots Full
    RCMP=Related Component
    SLIM=Session Limit Exceeded
    TIME=Time Conflict Exsists
    TIMR=Time Conflict Resolved
    TLIM=Term Limit Exceeded
    WDRW=Withdrawn from Class
    6 GRADING_BASIS_ENRL Character(3) VARCHAR2(3) NOT NULL Grading Basis
    7 CRSE_CAREER Character(4) VARCHAR2(4) NOT NULL Course Career
    8 GRADING_SCHEME Character(3) VARCHAR2(3) NOT NULL Grading Scheme
    9 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
    10 GRADING_SCHEME1 Character(3) VARCHAR2(3) NOT NULL Grading Scheme
    11 ACAD_PROG_PRIMARY Character(5) VARCHAR2(5) NOT NULL Primary Academic Program
    12 CAR_PTR_EXC_RULE Character(10) VARCHAR2(10) NOT NULL Career Pointer Exception Rule
    13 RQMNT_DESIGNTN Character(4) VARCHAR2(4) NOT NULL This field is used to track the Requirement Designation attached to a course in Student Records. This field is also used for tracking information through Academic Advisement.
    14 RQMNT_DESIGNTN_OPT Character(1) VARCHAR2(1) NOT NULL Requirement Designation Option
    N=No
    Y=Yes
    15 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
    A=A
    16 START_DT Date(10) DATE Start Date
    17 FULLY_GRADED_DT Date(10) DATE Fully Graded Date