CRSE_IDDATE1A=Active
I=Inactive
CRSE_CATALOG_VW(SQL View) |
Index Back |
|---|---|
Course Catalog ViewThis Course Catalog Table View is used to display all effective dated rows of a Course if at least one of its rows reference the current Equivalent Course ID in the Course Equivalencies Panel. |
| SELECT a.crse_id , a.effdt , a.equiv_crse_id , a.eff_status , a.descr , a.descrlong FROM PS_CRSE_CATALOG a |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CRSE_ID |
Character(6) | VARCHAR2(6) NOT NULL | Course ID |
| 2 | DATE1 |
Date(10) | DATE | Date 1 |
| 3 | EQUIV_CRSE_ID | Character(5) | VARCHAR2(5) NOT NULL | Equivalent Course Group |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRLONG | Long Character | CLOB | Long Description |