CATLG_SRCH_RSLT(SQL View) |
Index Back |
---|---|
Catalog Search Results |
SELECT A.CRSE_ID , A.EFFDT , A.EFF_STATUS , B.CRSE_OFFER_NBR , B.INSTITUTION , B.SUBJECT , B.CATALOG_NBR , B.COURSE_APPROVED , B.CATALOG_PRINT , B.RQRMNT_GROUP , A.DESCR , A.DESCRLONG , A.COURSE_TITLE_LONG , A.UNITS_MINIMUM , A.UNITS_MAXIMUM , A.GRADING_BASIS , A.CONSENT , A.RQMNT_DESIGNTN 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 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
4 | CRSE_OFFER_NBR | Number(2,0) | SMALLINT NOT NULL | Course Offering Nbr |
5 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
6 | SUBJECT | Character(8) | VARCHAR2(8) NOT NULL | Subject Area |
7 | CATALOG_NBR | Character(10) | VARCHAR2(10) NOT NULL | Catalog Nbr |
8 | COURSE_APPROVED | Character(1) | VARCHAR2(1) NOT NULL |
Course Approved
A=Approved D=Denied P=Pending |
9 | CATALOG_PRINT | Character(1) | VARCHAR2(1) NOT NULL | Catalog Print |
10 | RQRMNT_GROUP | Character(6) | VARCHAR2(6) NOT NULL | Requirement Group |
11 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
12 | DESCRLONG | Long Character | CLOB | Long Description |
13 | COURSE_TITLE_LONG | Character(100) | VARCHAR2(100) NOT NULL | Long Course Title |
14 | UNITS_MINIMUM | Number(6,2) | DECIMAL(5,2) NOT NULL | Minimum Units |
15 | UNITS_MAXIMUM | Number(6,2) | DECIMAL(5,2) NOT NULL | Maximum Units |
16 | GRADING_BASIS | Character(3) | VARCHAR2(3) NOT NULL |
Grading Basis
ANC=ABC/NC Grading AUD=Audit BMT=Multi-Term Course: Not Graded CNC=Credit / No Credit EQV=Equivalent GRD=Graded HSC=Hundred Point Scale (NLD) LAW=Law MED=Medical School Grades NOG=No Grade Associated NON=Non-Graded Component NQF=NQF Scale OPT=Student Option PNP=Pass/Not Pass SUS=Satisfactory/Unsatisfactory TRN=Transfer Grading Basis TSC=Ten Point Scale (NLD) |
17 | CONSENT | Character(1) | VARCHAR2(1) NOT NULL |
Used by Course Catalog, Class Table, and Class Permissions.
D=Department Consent Required I=Instructor Consent Required N=No Special Consent Required |
18 | RQMNT_DESIGNTN | Character(4) | VARCHAR2(4) NOT NULL | This field is used to track the Requirement Designation attached to a course in Student Records. This field is also used for tracking information through Academic Advisement. |