SSR_CLSRCH_ESVW

(SQL View)
 Index Back

Class Search View

Class Search View

SELECT A.CRSE_ID , A.CRSE_OFFER_NBR , A.STRM , A.SESSION_CODE , A.CLASS_SECTION , A.INSTITUTION , A.ACAD_CAREER , A.CLASS_NBR , A.SSR_COMPONENT , Q.FIELDVALUE , M.DESCR , L.DESCR1 , L.DESCR2 , L.DESCR3 , K.CRSE_ATTR , K.CRSE_ATTR_VALUE , J.RQMNT_DESIGNTN , P.SSR_CAF_DESCR1 , P.SSR_CAF_DESCR2 , P.SSR_CAF_DESCR3 , P.SSR_CAF_DESCR4 , P.SSR_CAF_DESCR5 , CASE WHEN K.SSR_CLSCFG_ATTRVAL = 'Y' THEN K.DESCR1 || '/' || K.DESCR2 ELSE K.DESCR1 END , J.SSR_REQ_DESIG_ES , K.DESCR1 , K.DESCR2 , K.SSR_CLSCFG_ATTRVAL , Q.XLATLONGNAME , B.DESCRSHORT , A.ACAD_GROUP , A.SUBJECT , A.SUBJECT , A.CATALOG_NBR , A.SUBJECT || ' ' || A.CATALOG_NBR , F.XLATLONGNAME , D.XLATLONGNAME , C.DESCR , H.DESCR , A.SUBJECT || '/' || H.DESCR , I.DESCR , G.XLATLONGNAME , R.DESCR , S.SSR_SHIFT_ES , C.COURSE_TITLE_LONG , N.DESCR , A.CLASS_TYPE , A.ASSOCIATED_CLASS , A.AUTO_ENROLL_SECT_1 , A.AUTO_ENROLL_SECT_2 , A.WAIT_CAP , A.WAIT_TOT , A.CRS_TOPIC_ID , A.CAMPUS , A.LOCATION , A.INSTRUCTION_MODE , C.DESCRLONG , E.DESCR , A.SCHEDULE_PRINT , O.SSR_CS_SCHDPRT_OPT FROM PS_CLASS_TBL A LEFT OUTER JOIN PS_SSR_CLS_ATTR_VW K ON A.CRSE_ID = K.CRSE_ID AND A.CRSE_OFFER_NBR = K.CRSE_OFFER_NBR AND A.STRM = K.STRM AND A.SESSION_CODE = K.SESSION_CODE AND A.CLASS_SECTION = K.CLASS_SECTION LEFT OUTER JOIN PS_SSR_CLS_MTG_DVW L ON A.CRSE_ID = L.CRSE_ID AND A.CRSE_OFFER_NBR = L.CRSE_OFFER_NBR AND A.STRM = L.STRM AND A.SESSION_CODE = L.SESSION_CODE AND A.CLASS_SECTION = L.CLASS_SECTION LEFT OUTER JOIN PS_SSR_CS_UNITS_VW M ON A.CRSE_ID = M.CRSE_ID AND A.CRSE_OFFER_NBR = M.CRSE_OFFER_NBR AND A.STRM = M.STRM AND A.SESSION_CODE = M.SESSION_CODE AND M.ASSOCIATED_CLASS = A.ASSOCIATED_CLASS LEFT OUTER JOIN PS_SSR_CLSTOPC_VW N ON A.CRSE_ID = N.CRSE_ID AND A.CRSE_OFFER_NBR = N.CRSE_OFFER_NBR AND A.STRM = N.STRM AND A.SESSION_CODE = N.SESSION_CODE AND A.CLASS_SECTION = N.CLASS_SECTION LEFT OUTER JOIN PS_SSR_CL_ASSOC_ES P ON A.CRSE_ID = P.CRSE_ID AND A.CRSE_OFFER_NBR = P.CRSE_OFFER_NBR AND A.STRM = P.STRM AND A.SESSION_CODE = P.SESSION_CODE AND P.ASSOCIATED_CLASS = A.ASSOCIATED_CLASS LEFT OUTER JOIN PS_SSR_SHIFT_ES_VW S ON A.CRSE_ID = S.CRSE_ID AND A.CRSE_OFFER_NBR = S.CRSE_OFFER_NBR AND A.STRM = S.STRM AND A.SESSION_CODE = S.SESSION_CODE AND A.CLASS_SECTION = S.CLASS_SECTION LEFT OUTER JOIN PS_SSR_RQMNT_DS_VW J ON A.CRSE_ID = J.CRSE_ID AND A.CRSE_OFFER_NBR = J.CRSE_OFFER_NBR AND A.STRM = J.STRM AND A.SESSION_CODE = J.SESSION_CODE AND (J.ASSOCIATED_CLASS = A.ASSOCIATED_CLASS OR J.ASSOCIATED_CLASS = 9999) , PS_TERM_TBL B , PS_CRSE_CATALOG C , PSXLATITEM D , PS_INSTRUCT_MODE E , PSXLATITEM F , PSXLATITEM G , PS_SUBJECT_TBL H , PS_CAMPUS_TBL I , PS_SSR_CS_GEN_OPTS O , PSXLATITEM Q , PS_LOCATION_TBL R , PS_SET_CNTRL_REC Z WHERE A.STRM = B.STRM AND B.INSTITUTION = A.INSTITUTION AND B.ACAD_CAREER = A.ACAD_CAREER AND A.CRSE_ID = C.CRSE_ID AND C.EFFDT = ( SELECT MAX(C_ED.EFFDT) FROM PS_CRSE_CATALOG C_ED WHERE C.CRSE_ID = C_ED.CRSE_ID AND C_ED.EFFDT <= B.TERM_BEGIN_DT) AND D.FIELDNAME = 'ACAD_CAREER' AND D.FIELDVALUE = A.ACAD_CAREER AND D.EFFDT = ( SELECT MAX(D_ED.EFFDT) FROM PSXLATITEM D_ED WHERE D.FIELDNAME = D_ED.FIELDNAME AND D.FIELDVALUE = D_ED.FIELDVALUE AND D_ED.EFFDT <= %CurrentDateIn) AND D.EFF_STATUS = 'A' AND E.INSTITUTION = A.INSTITUTION AND E.INSTRUCTION_MODE = A.INSTRUCTION_MODE AND E.EFFDT = ( SELECT MAX(E_ED.EFFDT) FROM PS_INSTRUCT_MODE E_ED WHERE E.INSTITUTION = E_ED.INSTITUTION AND E.INSTRUCTION_MODE = E_ED.INSTRUCTION_MODE AND E_ED.EFFDT <= B.TERM_BEGIN_DT) AND F.FIELDNAME = 'SSR_COMPONENT' AND F.FIELDVALUE = A.SSR_COMPONENT AND F.EFFDT = ( SELECT MAX(F_ED.EFFDT) FROM PSXLATITEM F_ED WHERE F.FIELDNAME = F_ED.FIELDNAME AND F.FIELDVALUE = F_ED.FIELDVALUE AND F_ED.EFFDT <= %CurrentDateIn) AND F.EFF_STATUS = 'A' AND G.FIELDNAME = 'SESSION_CODE' AND G.FIELDVALUE = A.SESSION_CODE AND G.EFFDT = ( SELECT MAX(G_ED.EFFDT) FROM PSXLATITEM G_ED WHERE G.FIELDNAME = G_ED.FIELDNAME AND G.FIELDVALUE = G_ED.FIELDVALUE AND G_ED.EFFDT <= %CurrentDateIn) AND G.EFF_STATUS = 'A' AND H.INSTITUTION = A.INSTITUTION AND H.SUBJECT = A.SUBJECT AND H.EFFDT = ( SELECT MAX(H_ED.EFFDT) FROM PS_SUBJECT_TBL H_ED WHERE H.INSTITUTION = H_ED.INSTITUTION AND H.SUBJECT = H_ED.SUBJECT AND H_ED.EFFDT <= B.TERM_BEGIN_DT) AND H.EFF_STATUS = 'A' AND I.INSTITUTION = A.INSTITUTION AND I.CAMPUS = A.CAMPUS AND I.EFFDT = ( SELECT MAX(I_ED.EFFDT) FROM PS_CAMPUS_TBL I_ED WHERE I.INSTITUTION = I_ED.INSTITUTION AND I.CAMPUS = I_ED.CAMPUS AND I_ED.EFFDT <= B.TERM_BEGIN_DT) AND I.EFF_STATUS = 'A' AND (( A.SCHEDULE_PRINT = 'Y' AND O.SSR_CS_SCHDPRT_OPT = 'N') OR ( O.SSR_CS_SCHDPRT_OPT = 'Y')) AND Q.EFFDT = ( SELECT MAX(Q_ED.EFFDT) FROM PSXLATITEM Q_ED WHERE Q.FIELDNAME = Q_ED.FIELDNAME AND Q.FIELDVALUE = Q_ED.FIELDVALUE AND Q_ED.EFFDT <= %CurrentDateIn) AND Q.FIELDNAME = 'SSR_CLSRCH_QRY_VAL' AND Q.FIELDVALUE IN ('O','C','W') AND Z.RECNAME = 'LOCATION_TBL' AND Z.SETCNTRLVALUE = A.INSTITUTION AND R.SETID = Z.SETID AND R.LOCATION = A.LOCATION AND R.EFFDT = ( SELECT MAX(R_ED.EFFDT) FROM PS_LOCATION_TBL R_ED WHERE R.SETID = R_ED.SETID AND R.LOCATION = R_ED.LOCATION AND R_ED.EFFDT <= B.TERM_BEGIN_DT) AND R.EFF_STATUS = 'A'

  • Related Language Record: SSR_CLSRCH_ESVL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    2 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    3 STRM Character(4) VARCHAR2(4) NOT NULL Term
    4 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
    5 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
    6 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    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 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
    9 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
    10 ENRL_STAT Character(1) VARCHAR2(1) NOT NULL Enrollment Status
    C=Closed
    O=Open
    W=Wait List
    11 SSR_NUM_UNITS_ES Character(30) VARCHAR2(30) NOT NULL Number of Units
    12 CLASS_MTG_DAYS Character(30) VARCHAR2(30) NOT NULL Class Meeting Days
    13 SSR_START_TIMES_ES Character(30) VARCHAR2(30) NOT NULL Class Start Times
    14 SSR_END_TIMES_ES Character(30) VARCHAR2(30) NOT NULL Class End Times
    15 CRSE_ATTR Character(4) VARCHAR2(4) NOT NULL Course Attribute
    16 CRSE_ATTR_VALUE Character(10) VARCHAR2(10) NOT NULL Course Attribute Value
    17 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.
    18 SSR_CAF_DESCR1 Character(30) VARCHAR2(30) NOT NULL CAF Option 1
    19 SSR_CAF_DESCR2 Character(30) VARCHAR2(30) NOT NULL CAF Option 2
    20 SSR_CAF_DESCR3 Character(30) VARCHAR2(30) NOT NULL CAF Option 3
    21 SSR_CAF_DESCR4 Character(30) VARCHAR2(30) NOT NULL CAF Option 4
    22 SSR_CAF_DESCR5 Character(30) VARCHAR2(30) NOT NULL CAF Option 5
    23 SSR_CLS_ATTR_FL2 Character(70) VARCHAR2(70) NOT NULL Class Attribute
    24 SSR_REQ_DESIG_ES Character(30) VARCHAR2(30) NOT NULL Requirement Designation
    25 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    26 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
    27 SSR_CLSCFG_ATTRVAL Character(1) VARCHAR2(1) NOT NULL Course Attribute Value
    28 SSR_CLASS_STAT_ES Character(30) VARCHAR2(30) NOT NULL Class Status
    29 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    30 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group
    31 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
    32 SSR_SUBJECT_ADV Character(8) VARCHAR2(8) NOT NULL Subject Area
    33 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    34 COURSE_TITLE Character(30) VARCHAR2(30) NOT NULL Course Title
    35 SSR_CLASS_COMPO_ES Character(30) VARCHAR2(30) NOT NULL Class Component
    36 SSR_CRSE_CAREER_ES Character(30) VARCHAR2(30) NOT NULL Course Career
    37 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    38 SSR_SUBJ_DESCR_ES Character(30) VARCHAR2(30) NOT NULL Subject
    39 SSR_SUBJ_DESC50_ES Character(50) VARCHAR2(50) NOT NULL Subject
    40 SSR_CAMPUS_ES Character(30) VARCHAR2(30) NOT NULL Campus
    41 SSR_SESS_CODE_ES Character(30) VARCHAR2(30) NOT NULL Academic Session
    42 SSR_LOC_DESCR_ES Character(30) VARCHAR2(30) NOT NULL Location Description
    43 SSR_SHIFT_ES Character(30) VARCHAR2(30) NOT NULL Shift
    44 COURSE_TITLE_LONG Character(100) VARCHAR2(100) NOT NULL Long Course Title
    45 SSR_CRSE_TOPIC_ES Character(30) VARCHAR2(30) NOT NULL Course Topic
    46 CLASS_TYPE Character(1) VARCHAR2(1) NOT NULL Class Type
    E=Enrollment Section
    N=Non-Enrollment Section
    47 ASSOCIATED_CLASS Number(4,0) SMALLINT NOT NULL Associated Class
    48 AUTO_ENROLL_SECT_1 Character(4) VARCHAR2(4) NOT NULL 1st Auto Enroll Section
    49 AUTO_ENROLL_SECT_2 Character(4) VARCHAR2(4) NOT NULL 2nd Auto Enroll Section
    50 WAIT_CAP Number(4,0) SMALLINT NOT NULL Wait List Capacity
    51 WAIT_TOT Number(4,0) SMALLINT NOT NULL Wait List Total
    52 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID
    53 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
    54 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    55 INSTRUCTION_MODE Character(2) VARCHAR2(2) NOT NULL Instruction Mode
    56 DESCRLONG Long Character CLOB Long Description
    57 SSR_INSTR_MODE_ES Character(30) VARCHAR2(30) NOT NULL Instruction Mode
    58 SCHEDULE_PRINT Character(1) VARCHAR2(1) NOT NULL Schedule Print
    A=All
    N=No
    Y=Yes
    59 SSR_CS_SCHDPRT_OPT Character(1) VARCHAR2(1) NOT NULL Allow Enrollment