SSR_CLSRCH_ESVL

(SQL View)
 Index Back

Class Search Rel Lang View

Class Search Related Language 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 , AL.LANGUAGE_CD , CASE WHEN K.SSR_CLSCFG_ATTRVAL = 'Y' THEN KL.DESCR1 || '/' || KL.DESCR2 ELSE KL.DESCR1 END , J.SSR_REQ_DESIG_ES , KL.DESCR1 , KL.DESCR2 , QL.XLATLONGNAME , BL.DESCRSHORT , FL.XLATLONGNAME , DL.XLATLONGNAME , CL.DESCR , HL.DESCR , A.SUBJECT || ' / ' || HL.DESCR , IL.DESCR , GL.XLATLONGNAME , RL.DESCR , S.SSR_SHIFT_ES , CL.COURSE_TITLE_LONG , N.DESCR , CL.DESCRLONG , EL.DESCR 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_DVL 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_VL 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_VL 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_ASC_ESLN 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_VL 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_VL 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_TERM_TBL_LANG BL , PS_CRSE_CATALOG C , PS_CRSE_CATLG_LNG CL , PSXLATITEM D , PSXLATITEMLANG DL , PS_INSTRUCT_MODE E , PS_INSTRUCT_MD_LNG EL , PSXLATITEM F , PSXLATITEMLANG FL , PSXLATITEM G , PSXLATITEMLANG GL , PS_SUBJECT_TBL H , PS_SUBJECT_TBL_LNG HL , PS_CAMPUS_TBL I , PS_CAMPUS_LANG IL , PS_SSR_CS_GEN_OPTS O , PSXLATITEM Q , PSXLATITEMLANG QL , PS_LOCATION_TBL R , PS_LOCATION_LANG RL , PS_CLASS_TBL_LANG AL , PS_SSR_CLS_ATTR_VL KL 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 <= %CurrentDateIn) 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 <= %CurrentDateIn) 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 R.SETID = A.INSTITUTION 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 <= %CurrentDateIn) AND A.CRSE_ID = AL.CRSE_ID AND A.CRSE_OFFER_NBR = AL.CRSE_OFFER_NBR AND A.STRM = AL.STRM AND A.SESSION_CODE = AL.SESSION_CODE AND A.CLASS_SECTION = AL.CLASS_SECTION AND BL.STRM = B.STRM AND BL.INSTITUTION = B.INSTITUTION AND BL.ACAD_CAREER = B.ACAD_CAREER AND BL.LANGUAGE_CD = AL.LANGUAGE_CD AND CL.CRSE_ID = C.CRSE_ID AND CL.LANGUAGE_CD = AL.LANGUAGE_CD AND DL.FIELDNAME = D.FIELDNAME AND DL.FIELDVALUE = D.FIELDVALUE AND DL.LANGUAGE_CD = AL.LANGUAGE_CD AND EL.INSTITUTION = E.INSTITUTION AND EL.INSTRUCTION_MODE = E.INSTRUCTION_MODE AND EL.LANGUAGE_CD = AL.LANGUAGE_CD AND FL.FIELDNAME = F.FIELDNAME AND FL.FIELDVALUE = F.FIELDVALUE AND FL.LANGUAGE_CD = AL.LANGUAGE_CD AND GL.FIELDNAME = G.FIELDNAME AND GL.FIELDVALUE = G.FIELDVALUE AND GL.LANGUAGE_CD = AL.LANGUAGE_CD AND HL.INSTITUTION = H.INSTITUTION AND HL.SUBJECT = H.SUBJECT AND HL.LANGUAGE_CD = AL.LANGUAGE_CD AND IL.INSTITUTION = I.INSTITUTION AND IL.CAMPUS = I.CAMPUS AND IL.LANGUAGE_CD = AL.LANGUAGE_CD AND QL.FIELDNAME = Q.FIELDNAME AND QL.FIELDVALUE = Q.FIELDVALUE AND QL.LANGUAGE_CD = AL.LANGUAGE_CD AND KL.CRSE_ID = K.CRSE_ID AND KL.CRSE_OFFER_NBR = K.CRSE_OFFER_NBR AND KL.STRM = K.STRM AND KL.SESSION_CODE = K.SESSION_CODE AND KL.CLASS_SECTION = K.CLASS_SECTION AND KL.LANGUAGE_CD = AL.LANGUAGE_CD AND RL.SETID = R.SETID AND RL.LOCATION = R.LOCATION AND RL.LANGUAGE_CD = AL.LANGUAGE_CD AND L.LANGUAGE_CD = AL.LANGUAGE_CD AND M.LANGUAGE_CD = AL.LANGUAGE_CD AND N.LANGUAGE_CD = AL.LANGUAGE_CD AND P.LANGUAGE_CD = AL.LANGUAGE_CD AND S.LANGUAGE_CD = AL.LANGUAGE_CD AND J.LANGUAGE_CD = AL.LANGUAGE_CD

  • Related Language Record for SSR_CLSRCH_ESVW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    24 SSR_CLS_ATTR_FL2 Character(70) VARCHAR2(70) NOT NULL Class Attribute
    25 SSR_REQ_DESIG_ES Character(30) VARCHAR2(30) NOT NULL Requirement Designation
    26 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    27 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
    28 SSR_CLASS_STAT_ES Character(30) VARCHAR2(30) NOT NULL Class Status
    29 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    30 SSR_CLASS_COMPO_ES Character(30) VARCHAR2(30) NOT NULL Class Component
    31 SSR_CRSE_CAREER_ES Character(30) VARCHAR2(30) NOT NULL Course Career
    32 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    33 SSR_SUBJ_DESCR_ES Character(30) VARCHAR2(30) NOT NULL Subject
    34 SSR_SUBJ_DESC50_ES Character(50) VARCHAR2(50) NOT NULL Subject
    35 SSR_CAMPUS_ES Character(30) VARCHAR2(30) NOT NULL Campus
    36 SSR_SESS_CODE_ES Character(30) VARCHAR2(30) NOT NULL Academic Session
    37 SSR_LOC_DESCR_ES Character(30) VARCHAR2(30) NOT NULL Location Description
    38 SSR_SHIFT_ES Character(30) VARCHAR2(30) NOT NULL Shift
    39 COURSE_TITLE_LONG Character(100) VARCHAR2(100) NOT NULL Long Course Title
    40 SSR_CRSE_TOPIC_ES Character(30) VARCHAR2(30) NOT NULL Course Topic
    41 DESCRLONG Long Character CLOB Long Description
    42 SSR_INSTR_MODE_ES Character(30) VARCHAR2(30) NOT NULL Instruction Mode