NAME: Campus
SHORT NAME: campus
LENGTH: 3
TYPE: A
SOURCE OF DATA: SIMS derived (SIMSSOCAD), Campus extract (all others)
SIMS SOURCE FILE: SIMSACF, SIMSADDR, SIMSAPP, SIMSBASE, SIMSDEG, SIMSDISAB, SIMSREG, SIMSSOCAD, SIMSSOCEX, SIMSTEST
DEFINITION / CODES: Code for University of Hawai‘i campus.

HAW Hawai‘i CC MAN UH Manoa
HIL UH Hilo MAU Maui CC
HON Honolulu CC WH West Hawai‘i Site (special data requirement)
KAP Kapi‘olani CC WIN Windward CC
KAU Kaua‘i CC WOA UH West O‘ahu
LEE Leeward CC


Invalid or missing data in this field will invalidate the record, i.e., it will not be accepted/counted in SIMS.


NAME: Chairs-occupied
SHORT NAME: chairs_occupied
LENGTH: 3
TYPE: N
SOURCE OF DATA: SIMS derived (SIMSSOCAD), Campus extract (SIMSSOCEX)
SIMS SOURCE FILE: SIMSSOCAD, SIMSSOCEX
DEFINITION / CODES: The number of students registered for and occupying a chair or student station in the class, i.e., the "warm body" or "head" count of students registered in the class. Excludes students with "W" grades (those who withdrew from the class after the penalty date for withdrawal).

NAME: CIP-code
SHORT NAME: cip_code
LENGTH: 7
TYPE: A
SOURCE OF DATA: SIMS derived
SIMS SOURCE FILE: SIMSBASE, SIMSDEG
DEFINITION / CODES: The matching Classification of Instructional Programs (CIP) code for major1 and d_major, used for federal reporting purposes. Derived using major1 and d_major.
Format: NN.NNNN

See CIP-Code codeset.

NAME: Citizenship
SHORT NAME: citizen
LENGTH: 3
TYPE: A
SOURCE OF DATA: Campus extract
SIMS SOURCE FILE: SIMSAPP, SIMSBASE
DEFINITION / CODES: Citizenship of student. See Citizenship codeset.

NAME: Citizenship-region
SHORT NAME: citizen_region
LENGTH: 3
TYPE: A
SOURCE OF DATA: SIMS derived
SIMS SOURCE FILE: SIMSAPP, SIMSBASE
DEFINITION / CODES: Geographic region for the country of which the student is a citizen, based on citizenship code. See Citizenship codeset and Citizenship-Region codeset.

AUS Australia
EAS East Asia
EEU Eastern Europe
LAM Latin America (Mexico, West Indies, Central America)
ME Middle East and North Africa
NAM North America (USA, Canada)
PAC Pacific Islands (except Hawai‘i)
RUS Russia and Independent States
SAF South Africa (south of the Sahara)
SAM South America
SAS South Asia
SEA Southeast Asia
STA Stateless
WEU Western Europe
No data. Missing or invalid data.

NAME: Class-contact-hours
SHORT NAME: cls_contact_hrs
LENGTH: 3
TYPE: N
SOURCE OF DATA: SIMS derived (SIMSSOCAD), Campus extract (SIMSSOCEX)
SIMS SOURCE FILE: SIMSSOCAD, SIMSSOCEX
DEFINITION / CODES: Currently not used. Definition to be determined.

NAME: Class-fill-percent
SHORT NAME: cls_fill_pct
LENGTH: 4
TYPE: N
SOURCE OF DATA: SIMS derived
SIMS SOURCE FILE: SIMSSOCAD, SIMSSOCEX
DEFINITION / CODES: The "percent fill" or "fill ratio" for the class (ratio between the registrations in the class and the maximum enrollment allowable in the class), multiplied by 100, rounded to 1 decimal place.

Format: NNN.N

In SOCEX, calculated by the formula: (regs) ÷ (enr_max) × 100
In SOCAD, calculated by the formula: (aregs) ÷ (enr_max) × 100

Excludes "hours arranged" classes such as modular, directed reading, cooperative education, etc.


NAME: Class-identification-number
SHORT NAME: cls_id
LENGTH: 5
TYPE: A
SOURCE OF DATA: SIMS derived (SIMSSOCAD), Campus extract (SIMSSOCEX, SIMSREG)
SIMS SOURCE FILE: SIMSSOCAD, SIMSSOCEX, SIMSREG
DEFINITION / CODES: The unique identification number assigned to the class by the campus. It is term-specific, and is used mainly as one of the keys linking the SIMSREG, SIMSSOCAD and SIMSOCEX files. It is also used by the campus as an identifier for editing class data during preliminary production runs.

NAME: Class-lecture-section
SHORT NAME: cls_lecsec
LENGTH: 3
TYPE: A
SOURCE OF DATA: SIMS derived (SIMSSOCAD), Campus extract (SIMSSOCEX)
SIMS SOURCE FILE: SIMSSOCAD, SIMSSOCEX
DEFINITION / CODES: The lecture or lab section of a class.

NAME: Class-load-equivalent-semester-hours
SHORT NAME: cls_load_esh
LENGTH: 3
TYPE: N
SOURCE OF DATA: SIMS derived
SIMS SOURCE FILE: SIMSSOCAD, SIMSSOCEX
DEFINITION / CODES: The sum of instr_load_esh_1 through instr_load_esh_4. However, until a definition for instr_load_esh_1 through instr_load_esh_4 is determined, this field will not be used.

Format: NN.N

NAME: Class-type
SHORT NAME: cls_typ
LENGTH: 5
TYPE: A
SOURCE OF DATA: SIMS derived (SIMSSOCAD), Campus extract (SIMSSOCEX)
SIMS SOURCE FILE: SIMSSOCAD, SIMSSOCEX
DEFINITION / CODES: Identifies the type of credit class being offered, i.e., regular credit offerings or credit offerings of Continuing Education & Community Services or Outreach College. The default is "CR". See also credit-type.

CR Class is offered through campus' regular credit offerings (default)
CO Class is offered through Continuing Education & Community Services or Outreach College

NAME: Classification-level
SHORT NAME: class_lvl
LENGTH: 5
TYPE: A
SOURCE OF DATA: SIMS derived
SIMS SOURCE FILE: SIMSAPP, SIMSBASE
DEFINITION / CODES: Classification level groups students by classified level (degree-seeking), or unclassified level (non-degree seeking), assigned using primary educational level (edlvl1).

CLASS

Classified, degree- or certificate-seeking

UNCLS

Unclassified, non-degree- or certificate-seeking



No data. Missing or invalid data.

Edlvl Acad_level
Class_lvl
FR Freshman UG CLASS
SO Sophomore UG CLASS
JR Junior UG CLASS
SR Senior UG CLASS
UU Undergraduate Unclassified (non-degree) UG UNCLS
PU Post-baccalaureate Unclassified (non-degree) UG UNCLS
GS Graduate-Special GR CLASS
PB Post-baccalaureate in Education (PCT, PD) GR CLASS
M Master's GR CLASS
D Doctor's (except JD, MD) GR CLASS
FP First Professional (JD, MD) GR CLASS
No data

NAME: Concurrent-class

See Associated-class-association.

NAME: Course-alpha
SHORT NAME: crs_alpha
LENGTH: 5
TYPE: A
SOURCE OF DATA: SIMS derived (SIMSSOCAD), Campus extract (SIMSSOCEX, SIMSREG)
SIMS SOURCE FILE: SIMSSOCAD, SIMSSOCEX, SIMSREG
DEFINITION / CODES: Alphabetical abbreviation for the course. This is the standard SIMS abbreviation that identifies the primary subject matter of the course, or the department associated with the subject. This field is sometimes referred to as "course department" or "subject". In some instances, the campus abbreviation may not match the SIMS abbreviation and must be translated to the standard abbreviation used in SIMS.

Examples: ENG, HAWST, MATH, BAKE, WELD

See Course-Alpha codeset.

NAME: Course-number
SHORT NAME: crs_num
LENGTH: 4
TYPE: A
SOURCE OF DATA: SIMS derived (SIMSSOCAD), Campus extract (SIMSSOCEX, SIMSREG)
SIMS SOURCE FILE: SIMSSOCAD, SIMSSOCEX, SIMSREG
DEFINITION / CODES: Course number designation of the course. The first 3 characters are numbers (with leading zeroes if necessary) which designates the level of the course. The fourth character is an optional alpha character, referred to as the course suffix.


crs_num
Undergraduate Level

Lower Division 001 to 299 (courses numbered 001 to 099 are generally not applicable toward a baccalaureate degree)
Upper Division 300 to 499

Graduate Level

Post-baccalaureate 500 to 599
Graduate courses 600 to 699
Thesis research (master's) 700
Advanced graduate courses 700 to 798
Dissertation research 800

Course suffixes are assigned at campus discretion, except for the following:
L Laboratory
V Variable credit course


NAME: Course-organizational-structure
SHORT NAME: crs_orgstr
LENGTH: 7
TYPE: A
SOURCE OF DATA: SIMS derived
SIMS SOURCE FILE: SIMSSOCAD, SIMSSOCEX
DEFINITION / CODES: The college or organizational division under which the course falls. Crs_alpha is used to automatically assign crs_orgstr. See Course-Alpha codeset and Course-Organizational-Structure codeset.



Campus
A&S-BUS Arts & Sciences - Business & Economics HIL
A&S-GEN Arts & Sciences - General Education HIL
A&S-HUM Arts & Sciences - Arts & Humanities MAN
A&S-HUM Arts & Sciences - Humanities HIL, WOA
A&S-LLL Arts & Sciences - Languages, Linguistics & Literature MAN
A&S-NAT Arts & Sciences - Natural Sciences MAN, HIL
A&S-OTH Arts & Sciences - Other MAN
A&S-PST Arts & Sciences - Professional Studies WOA
A&S-SOC Arts & Sciences - Social Sciences MAN, HIL, WOA
SHAPS School of Hawaiian, Asian & Pacific Studies MAN
HL College of Hawaiian Language HIL
SOEST School of Ocean, Earth Science & Technology MAN
ARCH School of Architecture MAN
BUSAD College of Business Administration MAN
STIM School of Travel Industry Management MAN
ED College of Education MAN
ENG College of Engineering MAN
AG College of Tropical Agriculture & Human Resources MAN
AG College of Agriculture HIL
HSSW Health Science and Social Welfare MAN
MEDI School of Medicine MAN
NURS Nursing MAN
PH School of Public Health MAN
SW School of Social Work MAN
LAW School of Law MAN
LIS School of Library & Information Studies MAN
MIL Military Studies MAN
HUM Humanities UHCC
NAT Natural Sciences UHCC
SOC Social Sciences UHCC
OTHGEN Other General Academic UHCC
BUSED Business Education UHCC
FOOD Food Service UHCC
FSHE Food Service & Hospitality Education KAP
HLTH Health Services UHCC
PUB Public Services UHCC
TECH Technology UHCC
OTHVOC Other Vocational Education UHCC
No data. Missing or invalid data. MAN, HIL, WOA, UHCC

NAME: Course-org-structure-campus
SHORT NAME: crs_orgstr_camp
LENGTH: 7
TYPE: A
SOURCE OF DATA: Campus extract (SIMSSOCEX), else SIMS derived (SIMSSOCEX, SIMSSOCAD)
SIMS SOURCE FILE: SIMSSOCAD, SIMSSOCEX
DEFINITION / CODES: The campus-specific organizational division under which the course falls, i.e., the organizational structure used at the campus operational level, as opposed to crs_orgstr which is used in all UH system reporting. If the campus does not provide the data, it is SIMS derived using crs_alpha.

See the following codesets: Course-Alpha, Course-Organizational-Structure, Course-Org-Structure-Campus.

NAME: Course-title
SHORT NAME: crs_title
LENGTH: 30
TYPE: A
SOURCE OF DATA: Campus extract
SIMS SOURCE FILE: SIMSSOCEX
DEFINITION / CODES: Abbreviated course title or description.

NAME: Credit-type
SHORT NAME: credit_type
LENGTH: 2
TYPE: A
SOURCE OF DATA: SIMS derived
SIMS SOURCE FILE: SIMSBASE
DEFINITION / CODES: Indicates whether a student is taking credit courses through regular credit offerings, or through the credit offerings of Continuing Education and Community Services (CCECS), Outreach College or other programs. See also class-type.

CR Indicates student is taking credit offerings exclusively from the campus' regular credit offerings. No data or invalid codes are defaulted to CR.
CO Indicates student is taking credit offerings exclusively from Continuing Education and Community Services or Outreach College.
BC Indicates student is taking credit offerings from both the campus' regular credit classes and Continuing Education and Community Services or Outreach College.

NAME: Cross-listed-class

See Associated-class-association.

NAME: Cumulative-attempted-semester-hours
SHORT NAME: cum_attempted_sh
LENGTH: 3
TYPE: N
SOURCE OF DATA: Campus extract
SIMS SOURCE FILE: SIMSBASE
DEFINITION / CODES: Total number of semester hours taken at the campus by the student, including semester hours in the current semester.

Includes semester hours for all courses reflected on the student's record, regardless of the grade assigned. Includes W, NC, etc.

NAME: Cumulative-earned-semester-hours
SHORT NAME: cum_earned_sh
LENGTH: 3
TYPE: N
SOURCE OF DATA: Campus extract
SIMS SOURCE FILE: SIMSBASE
DEFINITION / CODES: Total number of semester hours for courses passed by the student. Contributes to student's overall credit total at the campus. Before current semester grades are posted, cum_earned_sh is as of the last semester (if any) the student registered at the campus. After current semester grades are posted, cum_earned_sh includes courses passed up to and including the current semester.

Includes semester hours for: A, B, C, D, CR, CE, S, H grades

Excludes semester hours for: F, NC, I, W, N, NG, NR, U, AU grades

NAME: Cumulative-grade-point-ratio (GPR)
SHORT NAME: cum_gpr
LENGTH: 5
TYPE: N
SOURCE OF DATA: Campus extract
SIMS SOURCE FILE: SIMSBASE
DEFINITION / CODES: Student's cumulative grade point ratio. Also known as cumulative grade point average. The student's cumulative grade points divided by cumulative-quality-semester-hours. Calculated for all courses taken at the campus with A, B, C, D, and F grades.

Before current semester grades are posted, cum_gpr is as of the last semester (if any) the student registered at the campus. After current semester grades are posted, cum_gpr includes A, B, C, D, and F grades up to and including the current semester.

Format: N.NNNN, truncated to 4 decimals, zero fill as necessary.

NAME: Cumulative-grade-points (GP)
SHORT NAME: cum_gp
LENGTH: 5
TYPE: N
SOURCE OF DATA: Campus extract
SIMS SOURCE FILE: SIMSBASE
DEFINITION / CODES: Cumulative grade points. For all work at the campus: the sum of (semester hours for the class multiplied by the grade point value of the grade earned in the class).

Before current semester grades are posted, cum_gp is as of the last semester (if any) the student registered at the campus. After current semester grades are posted, cum_gp includes total grade points in classes taken up to and including current semester.

Format: NNNN.N

Grade Grade point value
A+ 4.0
A 4.0
A- 3.7
B+ 3.3
B 3.0
B- 2.7
C+ 2.3
C 2.0
C- 1.7
D+ 1.3
D 1.0
D- 0.7
F 0.0

NAME: Cumulative-quality-semester-hours
SHORT NAME: cum_q_sh
LENGTH: 3
TYPE: N
SOURCE OF DATA: Campus extract
SIMS SOURCE FILE: SIMSBASE
DEFINITION / CODES: Student's cumulative quality semester hours. Used by the campus to compute the student's cumulative GPR.

Before current semester grades are posted, cum_q_sh is as of the last semester (if any) the student registered at the campus. After current semester grades are posted, cum_q_sh includes total semester hours for A, B, C, D and F grades in classes taken up to and including the current semester.

Includes semester hours for: A, B, C, D, F grades

Excludes semester hours for: all other grades

NAME: Cumulative-transfer-other-credit
SHORT NAME: cum_trans_oth_credit
LENGTH: 3
TYPE: N
SOURCE OF DATA: Campus extract
SIMS SOURCE FILE: SIMSBASE
DEFINITION / CODES: Student's cumulative semester hours awarded for courses taken at other institutions, or for Advanced Placement Examinations (AP), College Level Placement Examination (CLEP), or courses in the military.

NAME: Current-attempted-semester-hours
SHORT NAME: cur_attempted_sh
LENGTH: 2
TYPE: N
SOURCE OF DATA: Campus extract
SIMS SOURCE FILE: SIMSBASE
DEFINITION / CODES: For the current semester: total number of semester hours taken at the campus by the student.

Includes semester hours for all courses reflected on the student's semester record.

NAME: Current-earned-semester-hours
SHORT NAME: cur_earned_sh
LENGTH: 2
TYPE: N
SOURCE OF DATA: Campus extract
SIMS SOURCE FILE: SIMSBASE
DEFINITION / CODES: Total number of semester hours for courses passed by the student in the current semester. Contributes to the student's overall credit total at the campus.
Before current semester grades are posted, cur_earned_sh is 0.

Includes semester hours for: A, B, C, D, CR, CE, S, H grades

Excludes semester hours for: F, NC, I, W, N, NG, NR, U, AU grades

NAME: Current-grade-point-ratio (GPR)
SHORT NAME: cur_gpr
LENGTH: 5
TYPE: N
SOURCE OF DATA: Campus extract
SIMS SOURCE FILE: SIMSBASE
DEFINITION / CODES: Student's grade point ratio for the current semester. Also known as current grade point average. The student's current-grade-points divided by current-quality-semester-hours. Calculated for classes taken at the campus with A, B, C, D or F grades.

Before current semester grades are posted, cur_gpr is 0.0000.

Format: N.NNNN, truncated to 4 decimals, zero fill as necessary

NAME: Current-grade-points
SHORT NAME: cur_gp
LENGTH: 4
TYPE: N
SOURCE OF DATA: Campus extract
SIMS SOURCE FILE: SIMSBASE
DEFINITION / CODES: Current grade points. For the semester indicated: the sum of (semester hours for the class multiplied by the grade point value of the grade earned in the class).

Before current semester grades are posted, cur_gp is 0.

Format: NNN.N

Grade Grade point value
A+ 4.0
A 4.0
A- 3.7
B+ 3.3
B 3.0
B- 2.7
C+ 2.3
C 2.0
C- 1.7
D+ 1.3
D 1.0
D- 0.7
F 0.0

If a student received these grades:

Class sem hr grade grade-points-for-class (sem hr × grade point value)
Geog 101 03 A 12
Psy 125 04 C 8

the student's cur_gp = 12 + 8 = 20.


NAME: Current-quality-semester-hours
SHORT NAME: cur_q_sh
LENGTH: 2
TYPE: N
SOURCE OF DATA: Campus extract
SIMS SOURCE FILE: SIMSBASE
DEFINITION / CODES: Student's current quality semester hours. Used by the campus to compute the student's current GPR.

Before current semester grades are posted, cur_q_sh is 0.

Includes semester hours for: A, B, C, D, F grades

Excludes semester hours for: all other grades

Last update: July 14, 1999
This page maintained by the Institutional Research Office Web Team
Copyright © 1999, 1998 & 1997
All rights reserved
Previous Codeset User Access System-wide Definitions Student/Course Elements