• Elements

  • Element: Common Course Prefix - 01195

Page Name

The alpha abbreviation which is assigned to a course, by Common Course Numbering.

Common Course Prefix 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. For summary segments on the I&R Data File this element should be coded '999'.

Load programs on WORKLOAD_ACTIVITIES table will NULL value when activity is non-instruction (INSTR_RESRCH_ACT 01509 NOT=11,12,15,19,20,21,43,44).



ELEMENT

192001

11-SEP-2008


Associated Submissions, Tables, and Columns

SubmissionAscendingTable NameColumn nameElement IDTab column idTable idSubmission name
Admissions (ADM)COLLEGE_PREP (PREP)CRS_PREFIX12925457Admissions
College Prep (CP)COLLEGE_PREP (PREP)CRS_PREFIX12925457College Prep
College Prep Completions (CPC)COLLEGE_PREP (PREP)CRS_PREFIX12925457College Prep Completions
Hours to Degree (HTD)COURSES_TO_DEGREE (CHTD)CRS_PREFIX12941516Hours to Degree
Instruction & Research (IRD)WORKLOAD_ACTIVITIES (WKA)CRS_PREFIX129160528Instruction & Research
Student Instruction (SIF)COURSES_TAKEN (COUR)CRS_PREFIX12927759Student Instruction
Student Instruction (SIF)COURSE_MEETINGS (MEET)CRS_PREFIX129115321Student Instruction
Student Instruction (SIF)INSTRUCTIONAL_ACTIVITY (IAF)CRS_PREFIX129107520Student Instruction
Student Instruction Preliminary (SIFP)COURSES_TAKEN (COUR)CRS_PREFIX12927759Student Instruction Preliminary
  • 1 - 9

Allowed Values

Edit Values

Submission CodeAscendingTable nameDiagnostic CodeDiagnostic MessageError LevelError Description
HTDCOURSES_TO_DEGREE0007Missing9Critical Error: may cause submission to be rejected
IRDWORKLOAD_ACTIVITIES0168CRS_PREFIX is required if Instr_Resrch_Act is instruction9Critical Error: may cause submission to be rejected
IRDWORKLOAD_ACTIVITIES0750Summary course section records are no longer allowed9Critical Error: may cause submission to be rejected
IRDWORKLOAD_ACTIVITIES6239CRS_PREFIX is nulled if INSTR_RESRCH_ACT NOT IN ('11', '12', '43', '44', '15', '19', '20', '21', '16', '17', '25') 1Generated or Modified during SUDS Edit Process
SIFCOURSES_TAKEN0007Missing9Critical Error: may cause submission to be rejected
SIFCOURSES_TAKEN5298CRS_CIP, CAMPUS_CD, BE_CD, CRS_SECTN_TYP_PRI must be identical for all records in the same Course Section (CRS_PREFIX, CRS_NBR, CRS_IND, CRS_SECTN_NBR)9Critical Error: may cause submission to be rejected
SIFCOURSE_MEETINGS0007Missing9Critical Error: may cause submission to be rejected
SIFPCOURSES_TAKEN0007Missing9Critical Error: may cause submission to be rejected
SIFPCOURSES_TAKEN5298CRS_CIP, CAMPUS_CD, BE_CD, CRS_SECTN_TYP_PRI must be identical for all records in the same Course Section (CRS_PREFIX, CRS_NBR, CRS_IND, CRS_SECTN_NBR)9Critical Error: may cause submission to be rejected
  • 1 - 9

Prior Database Information:

VARCHAR2(3)
CRSPRE
COMM_CRS_PREFIX
Release 2.0