SSR_CAT_AUD_ES(SQL Table) |
Index Back |
|---|---|
Course Catatalog Audit for RTICourse Catatalog Audit Record for Real Time Indexing |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  CRSE_ID |
Character(6) | VARCHAR2(6) NOT NULL |
Course ID
Prompt Table: CRSE_CATALOG |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | CRSE_OFFER_NBR |
Number(2,0) | SMALLINT NOT NULL | Course Offering Nbr |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | 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) |
| 6 | 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 |
| 7 | UNITS_MINIMUM | Number(6,2) | DECIMAL(5,2) NOT NULL | Minimum Units |
| 8 | UNITS_MAXIMUM | Number(6,2) | DECIMAL(5,2) NOT NULL | Maximum Units |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 10 | COURSE_TITLE_LONG | Character(100) | VARCHAR2(100) NOT NULL | Long Course Title |