SSR_BRWSCTLG_VW(SQL View) |
Index Back |
|---|---|
Recently Viewed CoursesBrowse Course Catalog - Recently Viewed Courses |
| SELECT A.EMPLID , A.INSTITUTION , A.CRSE_ID , A.CRSE_OFFER_NBR , A.EFFDT , B.SUBJECT , B.CATALOG_NBR , B.COURSE_TITLE_LONG , B.UNITS_MINIMUM , B.UNITS_MAXIMUM , B.SSR_CRSE_TYPOFF_CD , A.AVAILABLE_FROM_DT , A.AVAILABLE_TO_DT , A.SSR_DISP_CRSE_ID , A.SCC_ROW_UPD_DTTM FROM PS_SSR_BRWSCTLG_RV A , PS_SSR_CRSE_OFF_VW B WHERE A.INSTITUTION = B.INSTITUTION AND A.CRSE_ID = B.CRSE_ID AND A.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_SSR_CRSE_OFF_VW B1 WHERE B1.CRSE_ID = B.CRSE_ID AND B1.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR AND B1.EFFDT <= A.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 3 | CRSE_ID | Character(6) | VARCHAR2(6) NOT NULL | Course ID |
| 4 | CRSE_OFFER_NBR | Number(2,0) | SMALLINT NOT NULL | Course Offering Nbr |
| 5 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 6 | SUBJECT | Character(8) | VARCHAR2(8) NOT NULL | Subject Area |
| 7 | CATALOG_NBR | Character(10) | VARCHAR2(10) NOT NULL | Catalog Nbr |
| 8 | COURSE_TITLE_LONG | Character(100) | VARCHAR2(100) NOT NULL | Long Course Title |
| 9 | UNITS_MINIMUM | Number(6,2) | DECIMAL(5,2) NOT NULL | Minimum Units |
| 10 | UNITS_MAXIMUM | Number(6,2) | DECIMAL(5,2) NOT NULL | Maximum Units |
| 11 | SSR_CRSE_TYPOFF_CD | Character(10) | VARCHAR2(10) NOT NULL | Course Typically Offered |
| 12 | AVAILABLE_FROM_DT | Date(10) | DATE | Car available from |
| 13 | AVAILABLE_TO_DT | Date(10) | DATE | Car available to (date) |
| 14 | SSR_DISP_CRSE_ID | Character(1) | VARCHAR2(1) NOT NULL | Display Course Id |
| 15 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |