ATTEND_TYPE_LVW

(SQL View)
 Index Back

Class Attendance Type View

Related language view for Class Attendance Type.

SELECT A.INSTITUTION , A.STRM , A.CLASS_NBR , A.CLASS_ATTEND_TYPE , A.Language_Cd , A.Descr ,A.Descrshort From Ps_Attend_Typsblvw A UNION SELECT DISTINCT AA.Institution , Aa.Strm , Aa.Class_Nbr , Cc.Class_Mtg_Atnd_Typ , X.Language_Cd , X.Xlatlongname , X.Xlatshortname FROM Ps_Class_Tbl Aa , Ps_Institution_Tbl Cc , Ps_Term_Tbl Dd , PsxlatitemLANG X WHERE Aa.Institution = Cc.Institution AND Cc.Effdt = ( SELECT MAX(Cc1.Effdt) FROM Ps_Institution_Tbl Cc1 WHERE Cc.Institution = Cc1.Institution) AND AA.INSTITUTION = DD.INSTITUTION AND Aa.Acad_Career = Dd.Acad_Career AND Aa.Strm = Dd.Strm AND Cc.Class_Mtg_Atnd_Typ = X.FIELDVALUE AND X.FIELDNAME = 'CLASS_ATTEND_TYPE' AND X.EFFDT = ( Select Max(X1.Effdt) FROM PSXLATITEMLANG X1 WHERE X.FIELDNAME = X1.FIELDNAME And X.Fieldvalue = X1.Fieldvalue And X.Language_Cd = X1.Language_Cd And X1.Effdt <= Dd.Term_Begin_Dt) Union SELECT DISTINCT AA.Institution , Aa.Strm , Aa.Class_Nbr ,Aa.Class_Attend_Type , X.Language_Cd , X.Xlatlongname , X.Xlatshortname FROM PS_ATTEND_TMPLT Aa , PS_class_tbl_vw CC , Ps_Term_Tbl Dd , PsxlatitemLANG X WHERE Aa.Institution = CC.Institution AND Aa.CLASS_NBR = CC.CLASS_NBR AND Aa.Strm = CC.Strm AND Dd.Institution = CC.Institution AND DD.Acad_Career = CC.Acad_Career AND DD.Strm = CC.Strm AND AA.Class_Attend_Type = X.FIELDVALUE AND X.FIELDNAME = 'CLASS_ATTEND_TYPE' AND X.EFFDT = ( Select Max(X1.Effdt) FROM PSXLATITEMLANG X1 WHERE X.FIELDNAME = X1.FIELDNAME And X.Fieldvalue = X1.Fieldvalue AND X1.Effdt <= Dd.Term_Begin_Dt)

  • Related Language Record for ATTEND_TYPE_VW

  • 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