SS_STUDY_INSTR

(SQL View)
 Index Back

Class Instructor View2

(This view is used to populate class instructor for Student Enrollment Inquiry.) This Class Table view is used for prompting in the Enrollment Request Panelgroup. Only Class Sections in Student Enrollment are selected.

SELECT B.EMPLID ,B.ACAD_CAREER ,A.INSTITUTION ,A.STRM ,A.SUBJECT ,A.CATALOG_NBR ,B.ASSOCIATED_CLASS ,A.CLASS_NBR ,C.CLASS_MTG_NBR ,D.EMPLID ,A.ACAD_GROUP ,A.SESSION_CODE ,A.CLASS_SECTION ,A.ACAD_CAREER ,A.SSR_COMPONENT ,A.ENRL_CAP ,A.ENRL_TOT ,A.DESCR ,B.GRADING_BASIS_ENRL ,B.MANDATORY_GRD_BAS ,B.UNT_TAKEN ,B.UNT_BILLING ,B.UNT_PRGRSS ,B.STDNT_ENRL_STATUS ,A.CRSE_ID ,B.ENRL_STATUS_REASON ,B.RSRV_CAP_NBR ,B.SESSN_ENRL_CNTL ,B.CRSE_GRADE_INPUT ,B.CRSE_GRADE_OFF ,B.GRD_PTS_PER_UNIT ,B.AUDIT_GRADE_BASIS ,B.EARN_CREDIT ,B.INCLUDE_IN_GPA ,B.UNITS_ATTEMPTED ,B.GRADE_POINTS ,B.ENRL_ADD_DT ,A.CRSE_OFFER_NBR ,A.CRS_TOPIC_ID ,A.EQUIV_CRSE_ID ,A.OVRD_CRSE_EQUIV_ID ,A.START_DT ,A.END_DT ,A.CLASS_TYPE ,B.RQMNT_DESIGNTN ,B.RQMNT_DESIGNTN_OPT ,B.RQMNT_DESIGNTN_GRD ,B.CRSE_COUNT ,B.TSCRPT_NOTE_ID ,B.TSCRPT_NOTE_EXISTS ,B.CLASS_PRMSN_NBR ,B.REPEAT_CODE ,B.ENRL_ACTN_RSN_LAST ,B.UNT_PRGRSS_FA ,C.FACILITY_ID ,C.MEETING_TIME_START ,C.MEETING_TIME_END ,C.MON ,C.TUES ,C.WED ,C.THURS ,C.FRI ,C.SAT ,C.SUN FROM PS_CLASS_TBL A , PS_STDNT_ENRL B , PS_CLASS_MTG_PAT C , PS_CLASS_INSTR D WHERE B.STDNT_ENRL_STATUS <> 'D' AND A.STRM = B.STRM AND A.CLASS_NBR = B.CLASS_NBR AND A.CRSE_ID = C.CRSE_ID AND A.CRSE_OFFER_NBR = C.CRSE_OFFER_NBR AND A.STRM = C.STRM AND A.SESSION_CODE = C.SESSION_CODE AND A.CLASS_SECTION = C.CLASS_SECTION AND C.CRSE_ID = D.CRSE_ID AND C.CRSE_OFFER_NBR = D.CRSE_OFFER_NBR AND C.STRM = D.STRM AND C.SESSION_CODE = D.SESSION_CODE AND C.CLASS_SECTION = D.CLASS_SECTION AND C.CLASS_MTG_NBR = D.CLASS_MTG_NBR

  • Related Language Record: SSSTUDYINSTRLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    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
    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    4 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_TBL

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

    Prompt Table: SUBJECT_TBL

    6 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    7 ASSOCIATED_CLASS Number(4,0) SMALLINT NOT NULL Associated Class
    8 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
    9 CLASS_MTG_NBR Number(2,0) SMALLINT NOT NULL Class Meeting Pattern Nbr
    10 INSTRUCTOR_ID Character(11) VARCHAR2(11) NOT NULL Instructor ID
    11 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group

    Prompt Table: ACAD_GROUP_TBL

    12 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
    13 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
    14 CRSE_CAREER Character(4) VARCHAR2(4) NOT NULL Course Career
    15 SSR_COMPONENT Character(3) VARCHAR2(3) NOT NULL Course Component.
    CLN=Clinical
    CON=Continuance
    DIS=Discussion
    FLD=Field Studies
    IND=Independent Study
    LAB=Laboratory
    LEC=Lecture
    PRA=Practicum
    RSC=Research
    SEM=Seminar
    SUP=Supervision
    THE=Thesis Research
    TUT=Tutorial
    16 ENRL_CAP Number(4,0) SMALLINT NOT NULL Enrollment Capacity
    17 ENRL_TOT Number(4,0) SMALLINT NOT NULL Enrollment Total
    18 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    19 GRADING_BASIS_ENRL Character(3) VARCHAR2(3) NOT NULL Grading Basis
    20 MANDATORY_GRD_BAS Character(1) VARCHAR2(1) NOT NULL Mandatory Grading Basis
    21 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
    22 UNT_BILLING Number(6,2) DECIMAL(5,2) NOT NULL Billing Units
    23 UNT_PRGRSS Number(6,2) DECIMAL(5,2) NOT NULL Units Taken-Academic Progress
    24 STDNT_ENRL_STATUS Character(2) VARCHAR2(2) NOT NULL Student Enrollment Status
    D=Dropped
    E=Enrolled
    W=Waiting
    25 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    26 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
    27 RSRV_CAP_NBR Number(3,0) SMALLINT NOT NULL Reserve Capacity Sequence
    28 SESSN_ENRL_CNTL Character(3) VARCHAR2(3) NOT NULL Enrollment Control Session
    29 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
    A=A
    30 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade
    31 GRD_PTS_PER_UNIT Number(10,3) DECIMAL(9,3) NOT NULL Grade Points Per Unit
    32 AUDIT_GRADE_BASIS Character(1) VARCHAR2(1) NOT NULL Audit Grading Basis
    33 EARN_CREDIT Character(1) VARCHAR2(1) NOT NULL Earn Credit
    34 INCLUDE_IN_GPA Character(1) VARCHAR2(1) NOT NULL Include in GPA
    35 UNITS_ATTEMPTED Character(1) VARCHAR2(1) NOT NULL Units Attempted
    I=In Progress
    N=No
    Y=Yes
    36 GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Grade Points
    37 ENRL_ADD_DT Date(10) DATE Enrollment Add Date
    38 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    39 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID
    40 EQUIV_CRSE_ID Character(5) VARCHAR2(5) NOT NULL Equivalent Course Group
    41 OVRD_CRSE_EQUIV_ID Character(1) VARCHAR2(1) NOT NULL Override Equivalent Course
    42 START_DT Date(10) DATE Start Date
    43 END_DT Date(10) DATE end date
    44 CLASS_TYPE Character(1) VARCHAR2(1) NOT NULL Class Type
    E=Enrollment Section
    N=Non-Enrollment Section
    45 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.
    46 RQMNT_DESIGNTN_OPT Character(1) VARCHAR2(1) NOT NULL Requirement Designation Option
    N=No
    Y=Yes
    47 RQMNT_DESIGNTN_GRD Character(1) VARCHAR2(1) NOT NULL Requirement Designation Grade
    N=Not Satisfied
    S=Satisfied
    48 CRSE_COUNT Number(5,2) DECIMAL(4,2) NOT NULL Course Count
    49 TSCRPT_NOTE_ID Character(4) VARCHAR2(4) NOT NULL Transcript Note ID
    50 TSCRPT_NOTE_EXISTS Character(1) VARCHAR2(1) NOT NULL Transcript Note Exists Flag
    51 CLASS_PRMSN_NBR Number(6,0) INTEGER NOT NULL Class Permission Nbr
    52 REPEAT_CODE Character(4) VARCHAR2(4) NOT NULL Repeat Code
    NTEA=No Taking Exam/Assessment
    53 ENRL_ACTN_RSN_LAST Character(4) VARCHAR2(4) NOT NULL Last Enrl Action Reason
    54 UNT_PRGRSS_FA Number(6,2) DECIMAL(5,2) NOT NULL Units Taken-Fin Aid Progress
    55 FACILITY_ID Character(10) VARCHAR2(10) NOT NULL Facility ID
    56 MEETING_TIME_START Time(15) TIMESTAMP Meeting Start Time
    57 MEETING_TIME_END Time(15) TIMESTAMP Meeting End Time
    58 MON Character(1) VARCHAR2(1) NOT NULL Monday

    Y/N Table Edit

    59 TUES Character(1) VARCHAR2(1) NOT NULL Tuesday

    Y/N Table Edit

    60 WED Character(1) VARCHAR2(1) NOT NULL Wednesday

    Y/N Table Edit

    61 THURS Character(1) VARCHAR2(1) NOT NULL Thursday

    Y/N Table Edit

    62 FRI Character(1) VARCHAR2(1) NOT NULL Friday

    Y/N Table Edit

    63 SAT Character(1) VARCHAR2(1) NOT NULL Saturday

    Y/N Table Edit

    64 SUN Character(1) VARCHAR2(1) NOT NULL Sunday

    Y/N Table Edit