CLS_FID_USG_VW

(SQL View)
Index Back

Class Facility ID Usage View

This view is a link between lass Meeting Pattern Table, Facility Table, Class Table and Set Control Record table. It contains class section data (+ SetID) that identifies where and when that class section meets.

SELECT B.SETID , A.CRSE_ID , A.CRSE_OFFER_NBR , A.STRM , A.SESSION_CODE , A.CLASS_SECTION , A.CLASS_MTG_NBR , A.FACILITY_ID , A.MEETING_TIME_START , A.MEETING_TIME_END , A.MON , A.TUES , A.WED , A.THURS , A.FRI , A.SAT , A.SUN , A.START_DT , A.END_DT , A.CRS_TOPIC_ID , A.DESCR , A.STND_MTG_PAT , A.PRINT_TOPIC_ON_XCR FROM PS_CLASS_MTG_PAT A , PS_FACILITY_TBL B , PS_CLASS_TBL C , PS_SET_CNTRL_REC D WHERE A.FACILITY_ID = B.FACILITY_ID AND C.CRSE_ID = A.CRSE_ID AND C.CRSE_OFFER_NBR = A.CRSE_OFFER_NBR AND C.STRM = A.STRM AND C.SESSION_CODE = A.SESSION_CODE AND C.CLASS_SECTION = A.CLASS_SECTION AND D.RECNAME = 'FACILITY_TBL' AND D.SETCNTRLVALUE = C.INSTITUTION AND D.SETID = B.SETID

  • Related Language Record: CLS_FID_USG_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    3 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    4 STRM Character(4) VARCHAR2(4) NOT NULL Term
    5 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
    6 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
    7 CLASS_MTG_NBR Number(2,0) SMALLINT NOT NULL Class Meeting Pattern Nbr
    8 FACILITY_ID Character(10) VARCHAR2(10) NOT NULL Facility ID
    9 MEETING_TIME_START Time(15) TIMESTAMP Meeting Start Time
    10 MEETING_TIME_END Time(15) TIMESTAMP Meeting End Time
    11 MON Character(1) VARCHAR2(1) NOT NULL Monday
    12 TUES Character(1) VARCHAR2(1) NOT NULL Tuesday
    13 WED Character(1) VARCHAR2(1) NOT NULL Wednesday
    14 THURS Character(1) VARCHAR2(1) NOT NULL Thursday
    15 FRI Character(1) VARCHAR2(1) NOT NULL Friday
    16 SAT Character(1) VARCHAR2(1) NOT NULL Saturday
    17 SUN Character(1) VARCHAR2(1) NOT NULL Sunday
    18 START_DT Date(10) DATE Start Date
    19 END_DT Date(10) DATE end date
    20 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID
    21 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    22 STND_MTG_PAT Character(4) VARCHAR2(4) NOT NULL Standard Meeting Pattern
    23 PRINT_TOPIC_ON_XCR Character(1) VARCHAR2(1) NOT NULL Print Topic On Transcript