ATTEND_TYPSBLVW

(SQL View)
 Index Back

Class Attendance Type View

Related language view for Class Attendance Type.

SELECT DISTINCT A.INSTITUTION , A.STRM , A.CLASS_NBR , B.CLASS_ATTEND_TYPE , X.LANGUAGE_CD , X.XLATLONGNAME , X.XLATSHORTNAME FROM PS_CLASS_TBL A , PS_CRSE_ATTENDANCE B , PS_TERM_TBL C , PSXLATITEMLANG X WHERE A.INSTITUTION = C.INSTITUTION AND A.ACAD_CAREER = C.ACAD_CAREER AND A.STRM = C.STRM AND A.CRSE_ID = B.CRSE_ID AND A.SSR_COMPONENT = B.SSR_COMPONENT AND B.EFFDT <= ( SELECT MAX(EFFDT) FROM PS_CRSE_ATTENDANCE B1 WHERE B.CRSE_ID = B1.CRSE_ID AND B.EFFDT <= C.TERM_BEGIN_DT) AND (A.INSTRUCTION_MODE = B.INSTRUCTION_MODE OR B.INSTRUCTION_MODE = ' ') AND B.CLASS_ATTEND_TYPE = X.FIELDVALUE AND X.FIELDNAME = 'CLASS_ATTEND_TYPE' AND X.EFFDT <= ( SELECT MAX(EFFDT) FROM PSXLATITEMLANG X1 WHERE X.FIELDNAME = X1.FIELDNAME AND X.FIELDVALUE = X1.FIELDVALUE AND X.LANGUAGE_CD = X1.LANGUAGE_CD AND X1.EFFDT <= C.TERM_BEGIN_DT)

  • Related Language Record for ATTND_TYP_SUBVW

  • Parent record: CRSE_CATALOG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    2 STRM Character(4) VARCHAR2(4) NOT NULL Term
    3 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
    4 CLASS_ATTEND_TYPE Character(4) VARCHAR2(4) NOT NULL Attendance Type
    CONF=Conference
    CONS=Instructor Consultation
    FLD=Field Trip
    MTG=Class Meeting
    STDY=Study Group
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description