CRSE_CATALOG(SQL Table) |
Index Back |
---|---|
Course Catalog DataThe Course Catalog Table contains course data that is printed in the academic institution's course catalog. One row exists in this table for each course the institution offers. |
# | 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 NOT NULL |
Effective Date
Default Value: %date |
3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
5 | EQUIV_CRSE_ID | Character(5) | VARCHAR2(5) NOT NULL |
Equivalent Course Group
Prompt Table: CRSE_EQUIV_TBL |
6 | 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 Default Value: N |
7 | ALLOW_MULT_ENROLL | Character(1) | VARCHAR2(1) NOT NULL |
Allow Multiple Enroll in Term
Y/N Table Edit Default Value: N |
8 | UNITS_MINIMUM | Number(6,2) | DECIMAL(5,2) NOT NULL | Minimum Units |
9 | UNITS_MAXIMUM | Number(6,2) | DECIMAL(5,2) NOT NULL | Maximum Units |
10 | UNITS_ACAD_PROG | Number(6,2) | DECIMAL(5,2) NOT NULL | Academic Progress Units |
11 | UNITS_FINAID_PROG | Number(6,2) | DECIMAL(5,2) NOT NULL | Financial Aid Progress Units |
12 | CRSE_REPEATABLE | Character(1) | VARCHAR2(1) NOT NULL |
Repeat for Credit
Y/N Table Edit Default Value: N |
13 | UNITS_REPEAT_LIMIT | Number(6,2) | DECIMAL(5,2) NOT NULL |
Total Units Allowed
Default Value: CRSE_CATALOG.UNITS_MAXIMUM |
14 | CRSE_REPEAT_LIMIT | Number(2,0) | SMALLINT NOT NULL |
Total Completions Allowed
Default Value: 1 |
15 | 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) Default Value: GRD |
16 | GRADE_ROSTER_PRINT | Character(1) | VARCHAR2(1) NOT NULL |
Grade Roster Print
C=Component I=By Instructor N=None S=By Student Default Value: C |
17 | SSR_COMPONENT | Character(3) | VARCHAR2(3) NOT NULL |
Course Component.
CLN=Clinical CON=Continuance DIS=Discussion FLD=Field Studies IND=Independent Study LAB=Laboratory LEC=Lecture PRA=Practicum RSC=Research SEM=Seminar SUP=Supervision THE=Thesis Research TUT=Tutorial |
18 | COURSE_TITLE_LONG | Character(100) | VARCHAR2(100) NOT NULL |
Long Course Title
Default Value: CRSE_CATALOG.DESCR |
19 | LST_MULT_TRM_CRS | Character(1) | VARCHAR2(1) NOT NULL |
Last Course of Mult Term Seq
Y/N Table Edit Default Value: N |
20 | CRSE_CONTACT_HRS | Number(6,2) | DECIMAL(5,2) NOT NULL | Course Contact Hours |
21 | 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.
Prompt Table: RQMNT_DESIG_TBL |
22 | CRSE_COUNT | Number(5,2) | DECIMAL(4,2) NOT NULL |
Course Count
Default Value: 1 |
23 | INSTRUCTOR_EDIT | Character(2) | VARCHAR2(2) NOT NULL |
Instructor Edit
C=Class Instructor Table Edit I=Instructor/Advisor Table Edit N=No Enrollment Choice Default Value: N |
24 | FEES_EXIST | Character(1) | VARCHAR2(1) NOT NULL |
Fees Exist Flag
Y/N Table Edit Default Value: N |
25 | COMPONENT_PRIMARY | Character(3) | VARCHAR2(3) NOT NULL |
Primary Component
Prompt Table: XLAT_SA_VW |
26 | ENRL_UN_LD_CLC_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Enrollment Unit Load Calc Type
1=Actual Units 2=Academic Progress Units Default Value: 1 |
27 | SSR_DROP_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 Default Value: N |
28 | DESCRLONG | Long Character | CLOB | Long Description |
29 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
30 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
31 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
32 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |