CRSE_IDEFFDTDefault Value: %date
A=Active
I=Inactive
CRSE_CAT_R5_VW(SQL View) |
Index Back |
|---|---|
Course Catalog Rqmnt ViewThis view is used to pull data for courses to be displayed in academic advisement. It has been adjusted to handle courses that no longer have an active catalog record available in the CRSE_CATALOG table. |
| SELECT A.CRSE_ID ,A.EFFDT ,B.SUBJECT ,B.CATALOG_NBR ,A.EFF_STATUS ,A.DESCR ,A.EFFDT FROM PS_CRSE_CATALOG A ,PS_CRSE_OFFER B WHERE A.CRSE_ID = B.CRSE_ID AND A.EFFDT = B.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CRSE_ID |
Character(6) | VARCHAR2(6) NOT NULL | Course ID |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | SUBJECT | Character(8) | VARCHAR2(8) NOT NULL | Subject Area |
| 4 | CATALOG_NBR | Character(10) | VARCHAR2(10) NOT NULL | Catalog Nbr |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | DATE1 | Date(10) | DATE | Date 1 |