SIMS | Data Element Dictionary

NAME:

Campus

SHORT NAME:

campus

LENGTH:

TYPE:

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:

TYPE:

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:

TYPE:

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:

TYPE:

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:

TYPE:

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:

TYPE:

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:

TYPE:

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:

TYPE:

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:

TYPE:

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:

TYPE:

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