SUDS Data Dictionary
APEX_PUBLIC_USER
---
Sign Out
Home
Elements
Edits
Elements
Element: Common Course Outside Indicator - 01003
Page Name
Description:
An alpha code developed by the Common Course Number System to be used to indicate laboratories and provide a method for equating laboratory courses.
Coding Instructions:
Common Course Outside Indicator as defined by the Common Course Numbering System. Courses taken at other institutions and reported on the Hours to Degree File should be reported as coded by the original institution.
On WORKLOAD_ACTIVITIES table any value will be set to NULL when ACT_CODE for the record is not an instructional activity.
Algorithm:
Usage Type:
ELEMENT
Begin Term:
192001
End Term:
Last Modified:
13-OCT-2020
Associated Submissions, Tables, and Columns
Go
Actions
Submission
Ascending
Table Name
Column name
Element ID
Tab column id
Table id
Submission name
Admissions (ADM)
COLLEGE_PREP (PREP)
CRS_IND
13
2549
7
Admissions
College Prep (CP)
COLLEGE_PREP (PREP)
CRS_IND
13
2549
7
College Prep
College Prep Completions (CPC)
COLLEGE_PREP (PREP)
CRS_IND
13
2549
7
College Prep Completions
Hours to Degree (HTD)
COURSES_TO_DEGREE (CHTD)
CRS_IND
13
419
16
Hours to Degree
Instruction & Research (IRD)
WORKLOAD_ACTIVITIES (WKA)
CRS_IND
13
1609
28
Instruction & Research
Student Instruction (SIF)
COURSES_TAKEN (COUR)
CRS_IND
13
2779
9
Student Instruction
Student Instruction (SIF)
COURSE_MEETINGS (MEET)
CRS_IND
13
1157
21
Student Instruction
Student Instruction (SIF)
INSTRUCTIONAL_ACTIVITY (IAF)
CRS_IND
13
1079
20
Student Instruction
Student Instruction Preliminary (SIFP)
COURSES_TAKEN (COUR)
CRS_IND
13
2779
9
Student Instruction Preliminary
1 - 9
Search
Allowed Values
Excel code
Code
Description
Grouping
'.
.
MISSING
-
'C
C
Lecture/Laboratory
A combined lecture-lab sequence in which the lab is offered in conjunction with the lecture at the same time/place.
'L
L
Laboratory
(1) A course of which the content is entirely laboratory or (2) the laboratory component of a lecture-lab sequence in which the lab is offered at a different time/place than the lecture.
Download
1 - 3
Edit Values
Go
Actions
Submission Code
Ascending
Table name
Diagnostic Code
Diagnostic Message
Error Level
Error Description
IRD
WORKLOAD_ACTIVITIES
0163
If Instr_Resrch_Act is Instruction then Crs_Ind must be a valid value ('.', 'L' or 'C' )
9
Critical Error: may cause submission to be rejected
IRD
WORKLOAD_ACTIVITIES
6241
CRS_IND is nulled if INSTR_RESRCH_ACT NOT IN ('11', '12', '43', '44', '15', '19', '20', '21', '16', '17', '25')
1
Generated or Modified during SUDS Edit Process
SIF
COURSES_TAKEN
0005
Invalid Value
9
Critical Error: may cause submission to be rejected
SIF
COURSE_MEETINGS
0005
Invalid Value
9
Critical Error: may cause submission to be rejected
SIFP
COURSES_TAKEN
0005
Invalid Value
9
Critical Error: may cause submission to be rejected
1 - 5
Search
Prior Database Information:
Physical Description:
VARCHAR2(1)
Short Name:
CCOIND
Column Name:
COMM_CRS_IND