ATTEND_TYPE_VW

(SQL View)
 Index Back

Class Attendance Type View

This view is used as a prompt table for Class Attendance Type.

SELECT A.INSTITUTION, A.STRM, CLASS_NBR, CLASS_ATTEND_TYPE, DESCR, DESCRSHORT, ATTEND_PRESENT_USE, ATTEND_REASON_USE, ATTEND_TARDY_USE, ATTEND_LEFT_USE, ATTEND_CONTACT_USE, ATTEND_TIME_USE, ATTEND_TMPLT_OVRD FROM PS_ATTND_TYP_SUBVW A UNION SELECT DISTINCT AA.Institution , Aa.Strm , Aa.Class_Nbr , Cc.Class_Mtg_Atnd_Typ , X.Xlatlongname , X.Xlatshortname , 'Y' , 'Y' , 'Y' , 'Y' , 'Y' , 'Y' , 'N' FROM Ps_Class_Tbl Aa , Ps_Institution_Tbl Cc , PS_TERM_TBL DD , Psxlatitem 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.EFF_STATUS = 'A' AND X.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PSXLATITEM X1 WHERE X.FIELDNAME = X1.FIELDNAME AND X.Fieldvalue = X1.Fieldvalue AND X1.EFFDT <= DD.TERM_BEGIN_DT) UNION SELECT DISTINCT AA.Institution , Aa.Strm , Aa.Class_Nbr ,Aa.Class_Attend_Type , X.Xlatlongname , X.Xlatshortname , 'Y' , 'Y' , 'Y' , 'Y' , 'Y' , 'Y' , 'N' FROM PS_ATTEND_TMPLT Aa , PS_class_tbl_vw CC , Ps_Term_Tbl Dd , Psxlatitem 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.EFF_STATUS = 'A' AND X.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PSXLATITEM X1 WHERE X.FIELDNAME = X1.FIELDNAME AND X.Fieldvalue = X1.Fieldvalue AND X1.Effdt <= Dd.Term_Begin_Dt)

  • Related Language Record: ATTEND_TYPE_LVW

  • 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 ATTEND_PRESENT_USE Character(1) VARCHAR2(1) NOT NULL Use Present
    8 ATTEND_REASON_USE Character(1) VARCHAR2(1) NOT NULL Use Reason
    9 ATTEND_TARDY_USE Character(1) VARCHAR2(1) NOT NULL Use Tardy
    10 ATTEND_LEFT_USE Character(1) VARCHAR2(1) NOT NULL Use Left Early
    11 ATTEND_CONTACT_USE Character(1) VARCHAR2(1) NOT NULL Use Contact Minutes
    12 ATTEND_TIME_USE Character(1) VARCHAR2(1) NOT NULL Use To and From Time
    13 ATTEND_TMPLT_OVRD Character(1) VARCHAR2(1) NOT NULL Override Template Date / Time