ATTND_TYP_SUBVW

(SQL View)
 Index Back

Class Attendance Type View

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

SELECT DISTINCT A.INSTITUTION , A.STRM , A.CLASS_NBR , B.CLASS_ATTEND_TYPE , X.XLATLONGNAME , X.XLATSHORTNAME , B.ATTEND_PRESENT_USE , B.ATTEND_REASON_USE , B.ATTEND_TARDY_USE , B.ATTEND_LEFT_USE , B.ATTEND_CONTACT_USE , B.ATTEND_TIME_USE , B.ATTEND_TMPLT_OVRD FROM PS_CLASS_TBL A , PS_CRSE_ATTENDANCE B , PS_TERM_TBL C , PSXLATITEM 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(B1.EFFDT) FROM PS_CRSE_ATTENDANCE B1 WHERE B.CRSE_ID = B1.CRSE_ID AND B1.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.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 <= C.TERM_BEGIN_DT)

  • Related Language Record: ATTEND_TYPSBLVW

  • 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

    Y/N Table Edit

    Default Value: Y

    8 ATTEND_REASON_USE Character(1) VARCHAR2(1) NOT NULL Use Reason

    Y/N Table Edit

    Default Value: Y

    9 ATTEND_TARDY_USE Character(1) VARCHAR2(1) NOT NULL Use Tardy

    Y/N Table Edit

    Default Value: Y

    10 ATTEND_LEFT_USE Character(1) VARCHAR2(1) NOT NULL Use Left Early

    Y/N Table Edit

    Default Value: Y

    11 ATTEND_CONTACT_USE Character(1) VARCHAR2(1) NOT NULL Use Contact Minutes

    Y/N Table Edit

    Default Value: Y

    12 ATTEND_TIME_USE Character(1) VARCHAR2(1) NOT NULL Use To and From Time

    Y/N Table Edit

    Default Value: Y

    13 ATTEND_TMPLT_OVRD Character(1) VARCHAR2(1) NOT NULL Override Template Date / Time

    Y/N Table Edit

    Default Value: N