LAM_STDNT_GRD

(SQL View)
Index Back

Student Gradebook Search Rec.

Use this search record to restrict operator access to the Student Access Grade Book.This view retrieves class sections where the student grades are being kept by the Grade Book application.

SELECT D.EMPLID , A.STRM , A.CLASS_NBR , A.INSTITUTION , A.SUBJECT , A.CATALOG_NBR , D.ACAD_CAREER , A.CAMPUS , A.SESSION_CODE , A.CLASS_SECTION , A.CRSE_ID , A.CRSE_OFFER_NBR , A.DESCR FROM PS_CLASS_TBL A , PS_TERM_VAL_TBL B , PS_LAM_CLASS_ACTV C , PS_STDNT_ENRL D WHERE A.STRM = B.STRM AND A.STRM = C.STRM AND A.CLASS_NBR = C.CLASS_NBR AND A.STRM = D.STRM AND A.CLASS_NBR = D.CLASS_NBR

  • Related Language Record: LAM_STDNT_SGLNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Default Value: OPR_DEF_TBL_CS.STRM

    Prompt Table: TERM_VAL_TBL

    3 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
    4 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    5 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

    Default Value: OPR_DEF_TBL_CS.SUBJECT

    Prompt Table: SUBJECT_TBL_VW

    6 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    7 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
    8 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

    Prompt Table: CAMPUS_TBL

    9 SESSION_CODE Character(3) VARCHAR2(3) NOT NULL Session
    1=Regular Academic Session
    10W=10 Week
    12W=Twelve Week
    4W1=Four Week - First
    4W2=Four Week - Second
    4W3=Four Week - Third
    4W4=Four Week - Fourth
    6W1=Six Week - First
    6W2=Six Week - Second
    8W1=Eight Week - First
    8W2=Eight Week - Second
    A11=Medical Period 1, 4 Weeks
    A12=Medical Period 1, 8 Weeks
    A13=Medical Pd 1, 12 Weeks
    A21=Medical Period 2, 4 Weeks
    A22=Medical Period 2, 8 Weeks
    A23=Medical Period 2, 12 Week
    FYR=Full Year
    MIN=Mini Session
    OEE=Open Entry/Open Exit
    SM1=Semester 1
    SM2=Semester 2
    10 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
    11 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID

    Prompt Table: CRSE_CATALOG

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

    Prompt Table: CRSE_OFFER

    13 DESCR Character(30) VARCHAR2(30) NOT NULL Description