VARIABLE NAME:
SCHOOL
DESCRIPTOR: School
DEFINITION:
Signifies ownership by a school/college on one of
the eight campuses of USC. On the enrollment and degrees awarded files, school
is assigned by the registrar. On the courses file, school is determined by the
acronym assigned to the course. On the faculty file, school is determined by the
home department as defined in the organizational structure of USC during the
pertinent semester.
VALUES:
205-899
See the
USC Codebook, under Simple Search select SCHOOL/COLLEGE/CAMPUS CODES (E0037)
for codes and descriptions.
FIELD ATTRIBUTE: A3
NOTE: Columbia undergraduate colleges end with 0. Columbia graduate colleges end with 5. Columbia first professional colleges are as follows: Medicine M.D. = 209, Law = 499, Joint Law/Masters Programs = 498. PharmD is identified by majors of 800 without the P suffix and the course acronym of 'DPHR'.
SOURCE: USC INFO, Degrees Awarded, Courses, and Faculty Files.
Courses and faculty assignments are determined by IPA.
EXAMPLE: To select the
undergraduate School of Music, type SCHOOL='380' in the WHERE statement.
To select undergraduate and graduate School of Music, type SCHOOL IN
('380','385') in the WHERE statement.