Skip to main content
Continuing Online Operations
Loyola is continuing online operations while we prepare for reopening safely in the fall. Coronavirus resources

Evaluation Kit Data Processing: Codes/Tables/Queries

Reference Codes, Access Queries, and Access Tables

COLLEGE CODES

Code

Description

GPS

Graduate and Professional Studies

PS

Graduate and Professional Studies

HN

College of Humanities & Natural Sciences

HNN

College of Humanities & Natural Sciences

LAW

Law School

LSP

Law Special Programs

MU

College of Music

ND

Notre Dame Seminary**

SO

Southern University

SSN

College of Social Sciences

SSD

College of Social Sciences

TU

Tulane University***

CEO

LIMC Courses not in Social Sciences

CEX

LIMX Courses not in Social Sciences

AM

American University

AS

Arts and Sciences

BA

Business Administration

BU

Business

CAE

College of Arts and Sciences

CAS

College of Arts and Sciences

CC

City College

CE

Continuing Education

CN

Consortium

DC

Dominican College***

DU

Dillard University

UN

University of New Orleans

XV

Xavier University***

CEL

Continuing Education - LPLC

CEP

Continuing Education - LPLX

ID

Interdisciplinary

LW

College of Law

MA

College of Music and Fine Arts

SP

Special Programs

SS

College of Social Sciences


 

ACTIVITY CODES

Activity

Description

LEC

Lecture

LAB

Laboratory

LLB

Lecture and Lab

RCT

Recitation

PRA

Practicum

SEM

Seminar

STU

Studio

IND

Independent Study

PRL

Private Lesson

RES

Research

FLD

Field Experience

DSR

Dissertation

MST

Master’s Thesis

CLN

Clinic

WSP

Workshop

CLR

Clerkship

ICA

Informal Credit Activity

IWC

Intensive Weekend Coll

STA

Study Abroad

EXC

Exchange Program

VIS

Visiting

LEH

Louisiana Endowment for the Humanities

ENS

Ensemble

LUM

LUMCON Program

 


 

 

ACCESS DATABASE TABLES

TABLE NAME

DESCRIPTION

CODES

Reference codes, such as Colleges, Activity Types, Course Status codes, and LORA registration availability codes. Rarely changes.

COURSESRAW

Course IDs with course title, college, department, activity type, and other codes. Imported from the Raw Courses BB Extract on WebFocus.

ENROLLINST

Instructors enrolled in courses. Imported from the Enroll Instructors BB Extract via WebFocus.

ENROLLSTUD

Students enrolled in courses. Imported from the Enroll Students BB Extract on WebFocus.

INSTRUCTORS

User names and email addresses of Instructors. Imported from the Create Instructors BB Extract on WebFocus.

PROJBYCOLL

Evaluation Kit Project IDs by College Code

PROJBYCOURSE  

Evaluation Kit Project IDs by Course ID

SESSIONS

The name of each sessions and the start and end dates for student, instructor, and administrator access to Evaluation Kit Surveys.

SESSBYCOURSE

Session IDs by Course ID, used to override the Session ID in COURSESRAW for an individual course (usually special sessions).

STUDENTS

User names and email addresses of Students. Imported from the Create Students BB Extract on WebFocus.

 


 

SELECTED ACCESS DATABASE QUERIES

QUERY NAME

DESCRIPTION

Activity Codes

Based on the CODES table; describes activity codes for reporting purposes.

CODES LIST

List of all the Codes in the CODES table

College Codes

Based on the CODES table; describes college codes for reporting purposes.

COURSES

Based on the COURSESFIXED query; brings reference data from multiple other tables and queries to list complete information for each course. Adds Exclusion flags based on selection criteria.

COURSESFIXED

Based on the COURSESRAW table; Removes embeded blanks from Course IDs, fixes other fields, and looks up override Session ID by Course, if any.

Cross Listed Courses 

Based on the COURSES query; lists only those courses that have a cross listed course id.

ENROLLMENTS

A union of the ENROLLINST and ENROLLSTUD tables; all course enrollments, including both students and instructors.

EXCLUDED

Based on the COURSES query; lists only those rows in which one or more of the exclusion values is not null. That is, this query lists all the courses that are excluded from end-of-semester course evaluations.

MinEnrColl

Based on the CODES table; lists the minimum enrollment level by college. 

MinEnrDept 

Based on the CODES table; lists the minimum enrollment level by department. 

Rep: Colleges in Survey

Summarizes courses by college code from the TOSURVEY query.

Rep: Depts in Survey

Summarizes courses by depatment from the TOSURVEY query.

Rep: Missing Dates

Identifies courses in the TOSURVEY query for which no survey start or end dates could be looked up.

Rep: Missing Projects

Identifies courses in the TOSURVEY query for which no Project ID could be looked up.

Rep: Sessions in Survey  

Summarizes courses by Session ID from the TOSURVEY query.

TOSURVEY

Includes all rows from the COURSES query in which all of the exclusion flags are null. That is, this is the detailed list of all the courses that should be included in the end-of-semester course surveys. This is the logical inverse of the EXCLUDED query.

Uploadable

All the rows from the TOSURVEY query, formatted for uploading to the EvaluationKit system.

USERS

Union of the STUDENTS and INSTRUCTORS tables.