ODD fields - Data Dictionary for On-Demand-Datasets oddfield report generated: 23-MAY-18
NAME	DESCRIPTION
A	number of A grades
a2g_a_ssci	years of high school social science passed
a2g_b_engl	years of high school English passed
a2g_complete	A to G requirements complete (excluding G)
a2g_c_math	years of high school Math passed
a2g_d_lab	years of high school lab science completed
a2g_e_forl	years of high school foreign language completed
a2g_f_vpa	years of high school visual and performing arts completed
a2g_g_elec	years of high school electives completed
abroad	Y if student has a study country in place for that term
academic_level	class level code (10=Frosh, 20=Soph, . . . , 50=Postbac)
acadStanding	academic standing during term (from previous term)
acadStanding_EOT	academic standing at the end of the term
acadStand_EOT	academic standing at end of term
acadstand_EOY	academic standing at end of year
acadStand_spring	academic standing at the end of the following Spring
acadyear	the academic year (ex: 2015 is the acayear for Summer 15, Fall 15, and Spring 16
acad_dept	Indicates Y or N if code is an academic department
acad_org	academic organization
acad_org_class	academic org code from the class table (usually the same as from the subject)
acad_org_last	most recently modified academic org code for a particular department
acad_org_subj	academic org code from the subject table (usually the same as from the class)
acad_plan	academic plan code
acad_prog	academic program
acad_standing	academic standing at the beginning of a term
acad_standing_eot	academic standing at the eod-of-term (after grades)
acad_year	academic year (yyyy) [matches Fall semester]
acad_year_name	YYYY-YY (example 2015-16)
accept	total amount of financial aid accepted
acceptFA	student has accepted financial aid
acceptSUG	student has accepted State University Grant
acceptSUG_td	student has accepted a Student University Grant
accept_grant	grant amount accepted
accept_loan	loan amount accepted
accept_schol	scholarship amount accepted
accept_work	work-study amount accepted
account	fiscal account
accstat	accommodation status code (see ERS manual)
acstand	academic standing (GOOD, PROB, REIN, DISQ, or blank if a new student)
acstand_EOT	academic standing at end of term (GOOD, PROB, REIN, DISQ)
acstand_eot_desc	description of academic standing code (end-of-term)
acstand_EOY	academic standing at end of year (GOOD, PROB, REIN, DISQ)
acstand_fall	academic standing after last Fall semester
acstand_final	a student's current or final academic standing
acstand_spring	academic standing after last Spring semester
act	program action code
ACTcomp	maximum ACT composite score
ACTelig	ACT eligibility index
ACTengl	maximum score on english portion of the ACT test
action	program action code
action_dt	program action date
action_reason	action reason code from the jobs table
active	active prospect (not withdrawn, denied, or no longer interested in attending)
activities	list of activity codes
ACTmath	maximum score on math portion of the ACT test
ACT_comp	ACT composite score
act_dt	activity date when data was last entered or updated
act_engl	ACT English maximum score
ACT_factor	grouped ACT composite scores
act_math	ACT math maximum score
act_read	ACT reading maximum score
act_science	ACT science maximum score
act_writ	ACT writiing maximum score
adbas	admission basis code
adbas_other	other admission basis (not regular or exception)
address1_crm	street address line 1
address2_crm	street address line 2
address_line_1_fixed	street address line 1 from Hobsons user
address_line_2_fixed	street address line 2 from Hobsons user
address_type	which address type is shown
addr_dt	effective date of current mailing address
add_class_dt	date class was added
add_dt	date that a couse was added
ADF_dt	date application decision form was generated
admit	has applicant been admitted (Y/N)
admitterm	Term a student was first admitted to HSU
admit_class	applicant student level for housing file
admit_dt	date of admission
admit_month	months into admission cycle that a student was admitted (Oct=0, Nov=1, etc.)
admit_status	housing status of applicant
admit_term	term a student was admitted to a particular program (ignores returning applications)
admit_termcode	term a student was admitted to a particular program (ignores returning applications)
admit_termdescript	term a student was admitted to a particular program (ignores returning applications)
admit_termname	term a student was admitted to a particular program (ignores returning applications)
admit_term_crm	4-digit CS term code used in Hobsons communications
admit_term_user	4-digit CS term code possibly edited by prospective student in Hobsons
admit_type	CS admit_type (1=continuing, 2=returning, 3=returning with units, 4=transfer, 5=new, 6=transitory)
adothr	Y/N if has ADOTHR checklist item missing
adterms	derived from multiple applicant flag fields
adult	Y if a person is over 18 years old
advDepart	department assigned to instructor/advisor
advDepcode	department code assigned to instructor/advisor
advHold	advising hold exists (Y/N)
advisor	advisor's name (Last FM)
advisors	comma-separated list of advisor names
advNo	advisor #
advRole	advisor role (ADVR, EOPA, THES)
advserve_fall	advising service dates last Fall semester
advserve_spring	advising service dates last Spring semester
affiliation	mid-semester group affiliations, comma-separated, ATHL, EOP, SSS, LC, etc.
aftercensus	Y if a census has passed for a particular term
afterstart	Y if the start of term has passed for a particular term
age	age of student
age_census	age of student on census date of a particular term
age_months	the number of months a person has lived
AGI	adjusted gross income
agi_factor	adjusted gross income, broken into range groups
ago	number of years in the past that a term occurred
aid	Y if a student received financial aid
aidsport	the sport associated with an athletic scholarship
aidyear	financial aid year (2010 = 2009-10)
aid_year	financial aid year (year of spring semester)
aid_year_name	financial aid year
allmajcodes	list of all major codes associated with a particular degree
altadmit	derived from adbas
amerind	student listed American Indian as one of their races
amount	(will someone please tell Ward what this field contains besides numbers from 0 to 14)
amt	amount for student fee
app	has propsect applied (Y/N)
appfeestat	application fee status
APPno	CMS application number - 8 digits starting with 00
apptype	applicant type [F=First-time UG, L=LD Transfer, U=UD Transfer, R=Returning UG, M=Masters, C=C. . .
apptypelet	applicant type [F,L,U,R,M,C,B,P,N]
apptype_erss	application type from the ERSS table
app_daysago	integer reflecting how many days ago is the app_dt
app_dt	application date
app_month	months between the application start date and when this student applied (0-10)
apstatus	description of current application status
arrive	date arrive on campus for HOP
asian	student listed Asian as one of their races
ASL	American Sign Language
athaid	Y/N is the student receiving athletic aid
athaidsport	sport that gave athletic aid to a student
athever	Y/N was this student ever an athlete
athgrad_in_6	grad_in_6 from a final ERSS term perspective (not cohort based)
athlete	student is playing on a University sports team
athlete_fa	appears to be an athlete from financial aid perspective
athlete_finaid	appears to be an athlete from financial aid perspective
athstatus	current athletic partipation status
autoeval	was the application processed by auto-eval process (Y/N)
ayname	academic year name (e.g. 2002-03)
B	number of B grades
BAfailed	Business core classes failed
BApassed	Business core classes passed
base_CN	course number for base supplemental instruction course
base_course	course (subj ###) for which supplemental instruction is offered
belowC	Y if grade less than C
belowcminus	Y if grade less than C- (D, F, NC, WU)
belowD	Y if grade less than D-
billing	the office that was billed for a service
birthdate	mm/dd/yyyy
birthdate2	birthdate in yyyymmdd format
birthmmddyyyy	birthdate in mmddyyyy format
birth_crm	Hobsons format birthdate
black	student listed black as one of their races
blank	blank field for student tracker data files
branch	student tracker school branch code
bridge	is this a "Bridge" student (Y/N)
C	number of C grades
calpass_cls_units	units in a particular class formatted for calpass
calpass_csuffix	course suffix for calpass
calpass_degree	degree code for calpass
calpass_earned	total units earned toward degree formatted for calpass
calpass_earned_HSU	units earned at HSU toward degree formatted for calpass
calpass_earned_term	units earned this term toward degree formatted for calpass
calpass_enrstat	enrollment status codes for calpass
calpass_eth	ethnicity codes for calpass
calpass_finaid	type of financial aid received code
calpass_foster_youth	foster youth, orphan, and ward of the court code
calpass_GPA	overall GPA for courses taken before this term formatted for calpass
calpass_GPA_term	GPA for classes taken this term at HSU formatted for calpass
calpass_level	student level codes for calpass
calpass_units	number of non-audit units a student is enrolled in formatted for calpass
calpass_xfer_earned	transfer units earned formatted for calpass
calpass_xfer_GPA	transfer gpa formatted for calpass
cancel	total amount of financial aid offers that were cancelled
cand_term	term a masters student advanced to candidacy
cap	maximum capacity
career	student "career": UGRD or PBAC
careerno	career number
cashier_hold	existence of a CSH negative service indicator
CAS_ID	Cal Apply on-line application identifier
CEEB	CEEB institution code
cenreg	registered at census
census	Y/N flag if here at census
cenunits	census units
charged	sum of positive amounts in item_sf
chargelist	comma-separated list of charged item codes in item_sf
childcare	number of children
cid	course ID code from CMS (catalog code)
cip	6 digit code cip code of major in XXXXXX format
cip1	6 digit code cip code of major in XXXXXX format of first diploma major
cip2	6 digit code cip code of major in XXXXXX format of second diploma major
cip3	6 digit code cip code of major in XXXXXX format of third diploma major
cipcode	Federal Classification of Instruction Programs (xx.xxxx). Crosswalked with CSU HEGIS code.
cip_code	Federal Classification of Instruction Programs (xx.xxxx). Crosswalked with CSU HEGIS code.
cit	citizenship code from ERSS file
citizenship	citizenship (US Citizen, green card, F Visa, etc.)
citizenship_status	citizenship status code (US Citizen, green card, F Visa, etc.)
citizen_cd	citizenship code from ERSS table
city	mailing address
city_crm	city for Hobsons official use
city_fixed	city from Hobsons user
class	academic level:class name (e.g. 20:Sophomore)
classes	list of registered classes
classlev	1-Frosh, 2-Soph, 3-Junior, 4-Senior, 5-Senior (120+ earned)
classno	1-5 from classlev
class_admit	class at the time of admission
class_on_app	0 (0-30 units), 1 (30-60 units), . . . From Mentor application
class_start_dt	Class start date based on the term or overridden in class section.
class_stop_dt	Class end data based on the term or overridden in class section.
cleanphone	cleaned up phone number (digits only)
cleanpphone	cleaned up permanent phone number (digits only)
clev	class level code: 0=not a real class, 1=lower division, 2=upper div, 3=graduate, P=pre-collegiate
cls_allunits	all units in a class (includes EE and audits)
cls_depcode	class department
cls_eeunits	EE units in a class
cls_term	term for a particular class
cls_units	units in a particular class
cmode	class mode (example: C-1 = Large Lecture)
cmode_cat	category of class mode: Lecture, Activity, Laboratory, Coaching, Seminar. . .
cmode_descript	description of class mode
CN	class number (equivalent to Banner CRN)
CNC	course taken for credit/no credit
CN_SI	supplemental instruction course number
cohort	cohort name
cohortgrad	STUID of student included in a graduation cohort - e.g. FTUG who began more than 6 years ago
cohortontime	STUID if FTUG began more than 4 years ago, LDIV more than 3 years ago, UDIV more than 2 years ago
colcode	two-character college code of first major
colcodes	comma-separated list of college codes associate with student's major(s) (values: AU, HS, NS, PS)
colcode_class	college code based on academic or in class table
colcode_subj	college code based on subject
college	name of college of first major
college_class	college name based on class
college_code	External Org ID for college previously attended stored in Hobsons
college_subj	college name based on subject
colN	14th column in GSR report (incorrectly defined as Non-graduate or Left Ineligible)
commencename	name to print on commencement list (includes trailing * for honors)
comments	comments
comp	component code for a class: LEC, LAB, SEM, ACT, etc.
compdescript	description of class component
complete_dt	date an application is completed - generally the ADF or PRCL date
compunits	units attached to each component of a class
concentration	name of first major option/concentration for this study field
concentration2	name of second option/conentration attached to this study field
concurrent	student is attending another institution at the same time as HSU
conditional	is this a conditional admit (Y/N)
confirm	has admit indicated an intent to enroll (Y/N)
confirmed	Y/N - intent to enroll, HOP reg, housing deposit, or registration
confirm_dt	date an applicant confirmed their intent to enroll
connect_id	hobsons id
contact_hours	contact hours
contact_nbr	contact number
contact_type	what kind of person record (prospect, parent, counselor)
country	mailing address
country_cit	country of citizenship
country_crm	country for Hobsons official use
country_fixed	country from Hobsons user
course	course subject and number
courselev	1st digit of class number
courseno	high school course number
courses	list of registered courses
coursetitle	class title and component name (should be comptitle?)
course_SI	supplemental instruction course (subj ###)
credential	credential name
credits	course or class credit units
credorder	order column for credential commencement list
crsman	course manually entered?
CSIS	id number for student assigned to or by the first CA district in which the student enrolled b. . .
csno	2 digit class mode (examples: 01 for C-1 or 25 for S-25)
CSU Mentor #	number from electronic application download
csuappno	CSU application #
csu_coll	2 digit college code for CSU reporting - from subject
csu_dept	3 digit department code for CSU reporting - from subject
CT_course	GE critical thinking course
CT_grade	GE critical thinking course grade
CT_inst	GE critical thinking course institution
CT_term	GE critical thinking course term
CT_units	GE critical thinking course semester units
D	number of D grades
dars_plan	Yes/No student has primary DARS Plan and number of future terms
DATAaction	constant "DATA"
ddeny	Y/N for has DENY/DDNY in their application stack
deceased	Y/N field is person is deceased
degcode	degree code (BA, BS, MA, MS, etc) without number identifier
degcodes	list of student's degree objectives, one per major (BA, BS, MA, MS, MB, MW, CR)
deghonor	degree honor granted
degmaj	degree ~ major; used for masters commencement bulletin
degname	degree name (e.g. Bachelor of Science)
degno	degree number
degree	degree code from CS
degree_last	degree code for last degree awarded or sought
degree_term	degree term for last degree awarded or sought
degree_term_last	term for the last degree awarded or sought
degr_held	student has an associated degree
degStatus	degree status (sought, awarded, denied)
degStatus_last	degree status for last degree awarded or sought
denyever	application was denied at least once
deny_admit	DN service indicator exists (denied after being admitted)
deny_dt	date of a deny decision on an application
deny_hold	date string for active hold DN/DENY
depart	date depart from campus from HOP
department	department of first major
department_class	department name of acad org in class table
department_subj	department name from acad org of subject
depcode	department code
depcodes	list of department codes that student's majors are in
depcode_class	department code of acad org in class table
depcode_subj	department code from acad org of subject
dependent	dependent status (D or I)
deptid_class	department ID (D200##) from academic org in class table
deptid_subj	department ID (D200##) of class based on subject
description	program action description
dipdate	diploma date - spelled out for diploma printing
diphold	Y if a hold exists which blocks diploma printing (GRAD)
dipmajors	list of diploma major descriptions separated by "and"s
dipname	name to print on a diploma
disability	disability code (see ERSS manual)
disburse	total amount of financial aid disbursed
discipline	general grouping of a student's major from the CIP
disq_semesters_off	number of semesters off after being disqualifed for a given term and career
disservice	disabled student service code (see ERSS manual)
div	division code for class: RE, LD, UD, GR, **
divdesc	division description for a class
divno	divison number (0-3) for a class
dob_fixed	date of birth from Hobsons user
dorm	on-campus residence: hall, building, floor
dropped	was this class dropped (Y/N)
dss	primary disabled student service
dssgroup	membership in DSS student group
dssoptions	comma-separated list of accomodation options
earned	total units earned toward degree
earned_class	units earned in a class
earned_fall	units earned toward degree last Fall semester
earned_final	total units earned
earned_first_fall	units earned during a student's first Fall semester
earned_first_spring	units earned during a student's first Spring semester
earned_ge	total units earned in GEAR classes
earned_GEAR	GEAR units earned at the end of this term
earned_GEAR_n1s	total GEAR units earned at the end of next semester
earned_HSU	units earned at HSU toward degree
earned_hsu_n1s	total units earned at HSU at end of the following semester
earned_major	major units earned this term
earned_major_n1s	total Major units earned at end of the following semester
earned_spring	units earned toward degree last Spring semester
earned_summer	units earned toward degree last Summer semester
earned_term	units earned this term toward degree
earned_term_adj	units earned this term after repeats are taken into account
earned_term_factor	grouped units earned this term
earned_term_orig	units earned this term before repeats are considered
earned_test	units earned from AP, IB and other tests
earned_xfer	transfer units earned
earned_year	units earned this year toward degree
ECID	NCAA ID
ed_father	father's education level
ed_mother	mother's education level
ee	Extended Ed Student Y-yes or N-no
EFC	amount of expected family contribution
elig_nonres	Y/N meets eligibility for non CA resident
elig_res	Y/N meets eligibility for CA resident
elite_scholar	student is in the ESP or ESPR student group
ELM	ELM total score
ELMEPT	ELM/EPT combined need code
ELMEPTprgrs	ELM/EPT progress code
ELMEPT_dt	last date student took the ELM or the EPT
ELMEPT_override	ELM or EPT needed override
ELMstat	Entry Level Mathematics status - 1,2,3 => needs remediation; other values explain why exempt
elmstat_app	Entry Level Mathematics status - 1,2,3 => needs remediation; other values explain why exempt
ELM_dt_first	date of first ELM test
ELM_first	first Entry Level Math score
ELM_last	last Entry Level Math score (if different from first)
email	preferred email address
email_crm	email address for Hobsons official use
email_fixed	email from Hobsons user
email_opt_out_fixed	email opt out from Hobsons user
EMPLID	the HSU ID (without hyphens)
endtime	time class lets out
end_dt	end of HOP session
end_dt01	date meeting #1 for a class ends
ENGLprof	highest english proficiency student group
ENGLrem	English remediation status (text)
enrolled	number of students enrolled
enrolled_365	was this person enrolled at HSU in the past 365 days
enrolled_erss	reported in ERSS this term
enroll_class	student level for housing file
enroll_status	student status for housing file: E)ligible, R)egistered, W)ithdrawn, N)ot eligible
enroll_term	student last enrollment term for housing file
enrstat	enrollment status: 1-Continuing,2-Returning,3-Returning Transfer,4-Transfer,5-First-time,6-Tr. . .
enr_census	enrolled at census
entry_term	term name of admit term (Fall/Spring/Summer)
entry_year	year of admit term
EOP	Y if in an EOP student group
EOPapp	is the applicant an EOP application? (Y/N)
EOPreview	Is the application in EOP review? (Y/N)
EOPstat	EOP status (interest) from application (Y/N/null)
EOP_admit	admitted by EOP (Y/N)
EOP_advisor	EOP advisor name
EOP_app	checklist value for EOP
EOP_app_dt	date on EOP APP checklist item
EOP_dependent	dependent status reported to EOP
EOP_dt	date of last EOP record change
EOP_Elig	Y if EOP eligible
EOP_ERS	value of EOP status field on ERS subform
EOP_estinc	estimate income from EOP form
EOP_family	family size reported to EOP
EOP_income	income from EOP form
EOP_interest	Y if expressed interest in EOP
EOP_LoR1	checklist value for EOP letter of recommendation 1
EOP_LoR1_dt	date on EOP LR1 checklist item
EOP_LoR2	checklist value for EOP letter of recommendation 2
EOP_LoR2_dt	date on EOP LR2 checklist item
EOP_prior_CSU	prior CSU from EOP form
EOP_reason	description of last EOP action reason
EOP_residency	residency from EOP form
EPT	EPT total score
EPTstat	English Proficiency status - 1,2,3 => needs remediation, other values explain why exempt
eptstat_app	English Proficiency status - 1,2,3 => needs remediation, other values explain why exempt
EPT_compo	EPT composition subscore
EPT_dt_first	date of first EPT test
EPT_essay	EPT essay subscore
EPT_first	first English Placement Test score
EPT_last	last English Placement Test score (if different from first)
EPT_read	EPT reading subscore
ESP	early start program participation (B=both, E=English, M=math)
ESPE_grade	grade (CR/NC) from ESP writing
ESPM_grade	grade (CR/NC) from ESP math
ESP_ELMgain	gain in ELM score after taking ESP math
ESP_engl	Early start English code from ERSS (1=completed, 7=not, 2-6 exemptions)
esp_e_plan	Early Start Program campus chosen on Smart Page for english
ESP_math	Early start math code from ERSS (1=completed, 7=not, 2-6 exemptions)
esp_m_plan	Early Start Program campus chosen on Smart Page for math
ESP_not	early start program non-compliance
ESP_school	school code where student signed up to take ESP (30=HSU)
eth	short racial description from dim_person without sorting digit
ethchoice	ethnicity selected by student
ethcitcode	same as ethcode except returns a 9 for nonresident aliens
ethcode	ERSS values: IPEDS_race_cat field if it exists, converted old ethnic_code otherwise
ethgrp	ethnic group code
ethnic	ethnic group without non-resident alien category
ethnicity	primary ethnic group (collapsed from original ethnic code to eight major groups)
ethnicity_cit	primary ethnic group with nonresident aliens split out
ethnicity_last	ethnicity before the current one
ethnic_cit	ethnic group with non-resident alien category
ethnic_dt	last date in ethnic history
ethnic_GSR	ethnic-citizenship ordered for the NCAA GSR report
eth_alien	Y if non-resident alien (citizenship code of Y or I)
eth_asian	Y if ethnicities include Asian
eth_asianrace	specific Asian racial subcategory
eth_black	Y if ethnicities include Pacific Islander
eth_cit	ethic/citizenship code without sorting digit (from dim_person)
eth_hispanic	Y if reported latino/hispanic background
eth_hobsons	ethnic group code used in Hobsons/prospects (1-8)
eth_indian	Y if races include American Indian/Alaskan native (including Latin American Indian)
eth_natamer	Native American: person has reported a North American tribal affiliation
eth_pacisl	Y if ethnicities include Pacific Islander
eth_tribe	tribal affiliation
eth_urm	Y if under-represented minority (not white, asian, or unknown)
eth_urm_desc	description of under represented minority, suitable for column heading
eth_white	Y if ethnicities include white
eval_status	status after auto-evaluation
excadmit	exception admit (Y/N)
excelID	version of student ID that will display leading 0s in Excel
except	exception basis code
exclusion	NCAA allowable exclusion (disabled, military, foreign service, mission)
ext_org_id	CMS institution code
F	number of F grades
facid	5-letter anonymous generated ID for faculty
facname	faculty name
FAFSA	applied for financial aid for this aid year
FAFSA_dt	date FAFSA was completed
FAFSA_last	applied for financial aid last aid year
fail	Y if course was failed
fallgrade	high school fall grade
famsize	family size
fed_aid	amount of federal financial aid disbursed
fed_free_aid	amount of "free" (grants and scholarships) federal aid disbursed
feewaiver	state fee waiver code and short description
fee_wvr	ERSS fee waiver code: 01=Cal Vet, 03=CSU employee, 04=CSU Dependents, 05=Over60 06=High School
FERPA	has student requested confidentiality
fhunp	applicant's First-time HSU User Name Password from "Admissions" External System ID in CS
fid	fiscal id
finaid	student received financial aid (Y/N)
first	first name of student
firstattend	first generation to attend college
firstattend_person0	first generation to attend college
firstgen	first generation student: neither parent graduated from a 4-year college
firstgen_gi	first generation student GI2025 Definition: neither parent graduated from a 4-year college
firstlast	prefix first last, suffix
firstmlast	prefix first mi last, suffix
first_name_crm	first name for Hobsons official use
first_name_fixed	first name from Hobsons user
first_pref	preferred first name
first_term	first term a student was enrolled in any college after high school
fisamount	amount of student fees
fiscat	fiscal category (WUE, CAres, nonRes)
fislev	fiscal level (UGRD, Cred, other PB)
fol_dt	date attached to FOL service (folder label)
foreign_postal_code_crm	non-US postal code for Hobsons communications
foreign_postal_code_user	non-US postal code from Hobsons user
foreign_state_crm	non-US state for Hobsons communications
foreign_state_user	non-US state from Hobsons user
free_aid	scholarships and grants
from_dt	date student began attending another school
FTE	full-time equivalent students (fraction of 12 units for Masters, fraction of 15 for all others)
FTE_ERSS	full-time equivalents from the ERSS staging table
FTE_units	units taken from the ERSS staging table
FTFTUG_ERSS	Y if first-time, full-time, student in ERSS file
FTnoshow	first-time undergraduate applicant who did not enroll
ftug	Y/N - first-time undergraduate (usually a frosh)
FTUGcohort	Y if in Fall first-time full-time undergraduate cohort
fulltime	Y if full-time student (>= 9 units for Masters, >= 12 units for all others)
fulltime_fees	greater than 6 units
future_prospect	is the prospects admit_term more than a year into the future? (Y/N)
GEAR	Y if a class meets a GEAR requirement
gear_attr	GEAR attributes connected to a class
gecrit	first character of ge_ct
GEearned	GE earned units (D or better)
geengl	first character of ge_wc
gemath	first character of ge_mq
gender	Male or Female
gender_fixed	gender from Hobsons user
gespee	first character of ge_oc
ge_area	1-4 or blank - class meets General Ed area: A1,B3,A2,A3
ge_attrs	comma-separated list fo GE attributes
ge_class	Y/N - class meets a general ed requirement
ge_critthk	Y/N/I (in progress) - General Ed critical thinking component met
GE_ct	General education - critical thinking met (Y/N or I for in-progress)
ge_englcomp	Y/N/I (in progress) - General Ed English component met
ge_math	Y/N/I (in progress) - General Ed math component met
GE_mq	General education - math/quantitative reasoning require met (Y/N or I for in-progress)
GE_oc	General education - oral communication met (Y/N or I for in-progress)
ge_oralcomm	Y/N/I (in progress) - General Ed oral communications component met
GE_wc	General education - writing/composition requirement met (Y/N or I for in-progress)
GPA	overall GPA for courses taken through a particular term
gpa2	overall GPA during a particular term, not including the current term
gpainclude	Y if course was graded and not repeated
gpaunits_class	adjusted units taken for grade (excludes repeats)
gpa_1s	overall GPA at the end of the following semester
gpa_1t	overall GPA at the end of the following term (includes summer)
gpa_2s	overall GPA at the end of the subsequent year (2 semesters later)
gpa_2t	overall GPA at the end of 2 terms (including summers) after this one
gpa_3s	overall GPA at the end of 3 semesters (not including summers) after this one
gpa_3t	overall GPA at the end of 3 terms (including summers) after this one
gpa_4t	overall GPA at the end of 4 terms (including summers) after this one
gpa_5t	overall GPA at the end of 5 terms (including summers) after this one
GPA_after_spring	GPA after the following Spring semester
gpa_dars	GPA from DARS
gpa_enr_student	HSU GPA calculated from student history
gpa_eot	overall GPA for courses taken at end of term
gpa_erss	GPA at census (from ERSS file) for a particular term
GPA_fall	GPA earned last Fall semester
GPA_final	student's final GPA
gpa_gear	GPA is GEAR classes taken at HSU
GPA_gear_n1s	GPA earned in GEAR courses at the end of next semester
GPA_HS	GPA from high school
GPA_HSU	overall GPA for classes taken at HSU
gpa_hsu_1s	HSU GPA at the end of the following semester (fall or spring)
gpa_hsu_1s_roll	calculated HSU GPA at the end of the following semester
gpa_hsu_1t	HSU GPA at the end of the following term (includes summer)
gpa_hsu_2s	HSU GPA at the end of the subsequent year (2 semesters later)
gpa_hsu_2t	HSU GPA at the end of 2 terms (including summers) after this one
gpa_hsu_3s	HSU GPA at the end of 3 semesters (not including summers) after this one
gpa_hsu_3t	HSU GPA at the end of 3 terms (including summers) after this one
gpa_hsu_4t	HSU GPA at the end of 4 terms (including summers) after this one
gpa_hsu_5t	HSU GPA at the end of 5 terms (including summers) after this one
gpa_hsu_enr_student	HSU GPA calculated from student history
gpa_hsu_eot	overall GPA for classes taken at HSU at end of term
gpa_hsu_erss	HSU GPA at census (from ERSS file)
gpa_hsu_final	the final or current HSU GPA for a student
gpa_hsu_major_n1s	estimated GPA in major classes one semester after the current one
GPA_HSU_n1s	GPA for courses taken at HSU during at then end of the following semester
gpa_hs_app	self-reported high school GPA from student's application
GPA_HS_factor	grouped high school GPAs
GPA_last_term	GPA at the end of student's last term of attendance
gpa_major	estimated GPA in major courses taken at HSU
GPA_major_n1s	GPA earned in major courses at the end of the next semester
gpa_prior	transfer or high school GPA
gpa_remed	GPA for remedial coursework
GPA_spring	GPA earned last Spring semester
GPA_summer	GPA earned last Summer semester
GPA_term	original GPA for classes taken this term at HSU (not including repeat corrections)
gpa_term_1t	original term GPA for following term (including summers)
gpa_term_2t	original term GPA for term after next (including summers)
gpa_term_3t	original term GPA for 3 terms in the future (including summers)
gpa_term_4t	original term GPA for 4 terms in the future (including summers)
gpa_term_5t	original term GPA for 5 terms in the future (including summers)
gpa_term_adj	adjusted GPA for this term (after repeats)
GPA_term_factor	grouped term GPAs
gpa_term_gear	original term GPA in GEAR courses
GPA_term_major	estimated term GPA in major courses
gpa_term_p1t	term GPA at HSU in prior term (including summer)
gpa_term_p2t	term GPA at HSU in term before previous one (including summer)
gpa_term_precol	term GPA in precollegiate courses
GPA_units	units taken the term that are counted in the GPA (excludes CR/NC and remedial)
gpa_units_adj	adjusted units taken for grade (excludes repeats)
gpa_units_gear	total GEAR units taken for a grade
gpa_units_major	estimated total major units taken for a grade
gpa_units_precol	total precollegiate units taken for a grade
gpa_units_term	term units taken for a grade
gpa_units_term_gear	GEAR units taken this term for a grade
gpa_units_term_major	estimated major units taken this term for a grade
GPA_xfer	GPA transferred from other schools
gpa_xfer_app	transfer GPA from application
grad	grad flag for Hobsons' upload; in dm_gps, Y if student graduated in 6/5/4 years
grade	grade a student received in a course
gradelet	course grade with the + or - removed
gradelet2	grades with + and - removed except for C-
gradelev	high school grade level
grade_required	grade required to pass the class (either CR of C-)
grade_SI	grade received in supplemental instruction
gradID	STUID if a FTUG/LD/UD student graduated in 6/5/4 years
grading_basis	grading basis code for a class (AUD,CNC,LTR,REM,etc.)
grading_basis_class	grading basis code for a class (AUD,CNC,LTR,REM,etc.)
gradontime	Y/N - student graduated in 4 years for FTUG, 3 years for LD transfer, or 2 years for UD transfer
gradprob	probability that a student will graduate
gradstat	graduation status
gradterm	expected or actual graduation term
graduate	received a degree
grad_app_dt	date a student applied to graduate
grad_dt	date of graduation (from HSU for students; from high school or transfer institution for applicants)
grad_else	1/0 4-year (or higher) degree after leaving HSU (cohort based)
grad_elsewhere	Y/N 4-year (or higher) degree after leaving HSU
grad_in_3	graduated in 3 years or less
grad_in_4	graduated in 4 years or less
grad_in_5	graduated in 5 years or less
grad_in_6	graduated in 6 years or less
grad_in_7	graduated in 7 years or less
grad_in_8	graduated in 8 years or less
grad_term	term a student received a degree
grant_aid	total amount of grant aid disbursed
grant_cancel	amount of financial aid grant offers that were cancelled
grant_offer	total amount of Grants offered
GSRresult	Final: G=grad, L=Left Eligible, X=exclusion, E=nonGrad or left ineligible
GSRsport	scholarship sport during student's first year at HSU
GWPE	graduate writing proficiency has been passed (Y/N)
GWPE_attempts	# of attempts at graduate writing proficiency exam
hc_admit	admit headcount - 1 if admitted, 0 otherwise
hc_app	applicant headcount - 1 if admitted, 0 otherwise
hc_belowc	1 if a student's grade was below a C
hc_belowcminus	1 if a student's grade was below a C-
hc_firstattend	Headcount of first generation to attend college
hc_ftug	first-time undergraduate headcount: 1 if FTUG
hc_grad	graduation headcount: 1 if student graduated, 0 if not, blank if not enough time to know
hc_gradontime	1 if student graduated in 4 years for FTUG, 3 years for LD transfer, or 2 years for UD transfer
hc_grad_elsewhere	1 if student graduated from another university
hc_nscgrad4	1 if an undergrad received their degree from anywhere in 4 years (clearinghouse data)
hc_nscgrad6	1 if an undergrad received their degree from anywhere in 6 years (clearinghouse data)
hc_reg	registered headcount - 1 if enrolled in classes, 0 otherwise
hegis_cip	classes CIP code - from the subject table
high_school_code	External Org ID for high school previously attended stored in Hobsons
hispanic	one of a student's races is hispanic
hispcat	hispanic/latino detail
hisp_ap	Hispanic value from Mentor application
hisp_re	Hispanic value from ethnic resurvey
hold_type	housing hold type (probation or removal)
honors	* if a graduate is receiving academic honors
HOOP	Complete (HP+) or Incomplete (RHP)
HOOPdone	finished HOOP/has HP+ service indicator (Y/N)
HOOPelig	is the applicant eligible to go through HOOP? (Y/N)
HOOPreg	has the applicant registered for HOOP? (Y/N)
HOOPregdate	date on which an applicant registered for HOOP
HOP	will partipate in HOP
hour	hour in the day: 0-23
hours	integer number of hours a class meets, usually 1, 2, or 3 (rounds up)
housing	housing_dep
housingdep_td	housing deposit was paid by a comparable date
housing_dep	student has paid a housing deposit
housing_hold	SHF or SPH hold exists for for this student
housing_status	status codes for housing
housing_type	student type for housing, either New, Transfer, or Continuing
hsgpa	high school gpa
hsgradterm	term a student graduated from high school (CMS codes - e.g. 2144)
HSU	Y if a course was taken at HSU; N if a transfer course
HSU_ID	HSU ID (aka EMPLID) with a hyphen
HS_GPA	high school GPA
icontact	initial contact code
ID	student ID (aka EMPLID)
id_app	EMPLID from the application
id_erss	EMPLID from ERSS
id_person	EMPLID from person dimension
id_status	type of id submitted for calpass S= ssn, C= campus assigned
impacted_app	applied for impacted major
inCohort	field required in NCAA GSR upload file
incomplete_checklists	tilde-delimited incomplete ADMA checklists
ind_study	Y/N - independent study
initial_date	initial date of contact with a prospect
inProgress	number of units in progress
instrID	EMPLID for primary instructor
instrids	comma-separated list of instructor EMPLIDs
instructor	primary instructor
instructor_primary	primary instructor name as Last, FM
inst_aid	amount of institutional financial aid disbursed
inst_free_aid	amount of "free" (grants and scholarships) aid from HSU disbursed
inst_id	IPEDS institution number for hsu
inst_orig	instution of origin for calpass
intent_td	applicant confirmed intent to enroll by a comparable date
international	residency status (for fee purposes) of F)oreign (Y/N)
intl	field contains INTL for foreign students (residency=F), blank otherwise
IPEDSciteth	IPEDS ethnicity (with Nonres Alien category) as reported in ERSS
IPEDSciteth2	IPEDS ethnicity (with Nonres Alien category)
IPEDSciteth_cs	citizenship/ethnicity according to ethnic history table in CS
IPEDSciteth_ERSS	IPEDS categories reported in ERSS
ipedseth	our calculated value for the IPEDS race value
ipedsrace	the race value the CSU reports in ERSS
isource	initial source of prospect (collapsed version of icontact)
itemname	long name for item
itemshort	short name for item
item_amount	item amount for student fees
item_type	fiscal item_type number, preceded by a #
journal_date	date of fiscal transaction to journal
KC	Klamath Connection (student group)
key	odd view key
kfactor	k factor: 0-6 or null, used to calculate WTU
KTH	Klamath Themed Housing (student group)
last	last name of student
lastact	last program action/reason
lastactdt	date of last program action
lastdegafter	name of last degree shown in Clearinghouse data after leaving HSU
lastEOPact	last EOP application program action/reason
last_name	student's last name
last_name_crm	last name for Hobsons official use
last_name_fixed	last name from Hobsons user
last_pref	preferred last name
last_self_qual	the last self-qualification we have for this prospect from extracurricular activities in CS o. . .
last_term	last term a student registered for classes
last_update	date record was last updated
lateapp	is the application late? (Y/N)
LC_services	count of Learning Center services provided by term
ld	Y/N - lower-division transfer applicant (frosh or sophmore)
ldiv	derived from adbas
leftEligible	athlete transferred to another school while still eligible to play
limited	less than 6 units
loan_aid	total amount of loans disbursed
loan_cancel	amount of financial aid loan offers that were cancelled
loan_offer	total amount of Loans offered
local	is the address local? (Y/N)
lodging	will need lodging
low_income	family's taxable income (total-standard deduction) less than 150% federal poverty level
LPM	enrolled in a Latino Peer mentoring class
majcode	major code (first four characters of academic plan)
majcode2	major code for 2nd major
majcode3	major code for 3rd major
majcodes	list of majors (codes)
majcodes_after1	major codes 1 year later
majcodes_final	the final majcodes value for a student in a particular academic program
majcode_after1	major code after a student's first semester
majcode_app_first	original majcodes from application
majcode_orig	major code from application
major	major on application or first major in student record
major1	major name or blank for MBA and MSW
major1_crm	major code 1 for Hobsons official use
major1_crm_descr	major description 1 for Hobsons official use
major1_user	major code selected by user first in Hobsons
major2	name of second major
major2_crm	major code 2 for Hobsons official use
major2_crm_descr	major description 2 for Hobsons official use
major2_user	major code selected by user second in Hobsons
major3	name of third major
major3_crm	major code 3 for Hobsons official use
major3_crm_descr	major description 3 for Hobsons official use
major3_user	major code selected by user third in Hobsons
major4	name of fourth major
major5	name of fifth major
majors	either "a major in" or "majors in", depending on the number of distinct diploma majors
majors_list	comma separated list of major codes in which a prospect is interested
major_contract	Y=complete, N=needed, blank if not applied for graduation
major_fall	Major code(s) at census last fall semester
major_final	first major in final ERSS term
major_path	EO1110 definition of STEM/Math dependent majors
major_spring	major code(s) at census last Spring semester
masters	Y if student is trying to earn a masters (may be EE)
MATHprof	highest math proficiency student group
MATHrem	Math remediation status (text)
matric	matriculation term code (first-term degree-seeking)
matricAY	academic year when student first matriculated
matricTerm	matriculation term name
matricType	applicant type for student in the term they first matriculated
maxdegafter	maximum degree received after leaving HSU
maxUnits	maximum units a student is allowed to register for
MBA	Y if MBA student
meetdates	comma-separated list of class meeting date ranges
meetdays	comma-separated list of days the meetings for a class are held (e.g. MW,F)
meetmins	comma-separated list of minutes the meetings for a class (e.g. 80,110)
meettimes	comma-separated list of start times the meetings for a class (e.g. 1400,0900)
mi	middle initial of student
middle	middle name of student
middle_name	middle name
middle_name_crm	middle name for Hobsons official use
middle_name_fixed	middle name from Hobsons user
middle_pref	preferred middle names
mildep	military dependent (applicant)
mil_dependent	military dependent
mincodes	list of minors (codes)
mincodes_after1	minor codes 1 year later
minutes	number of minutes of the primary meeting for each class
missingany	is the applicant missing anything? (Y/N)
missing_items	incomplete items on the checklist
misssig	missing something significant? (Y/N)
month	month of the year (01-Jan, 02-Feb, ¿ 12-Dec)
MQcat	math/quantitative reasoning placement category
MQstat	math/quantitative reasoning status (aka ELMstat)
MQ_course	GE math/quantitative transfer course
MQ_grade	GE math/quantitative transfer course grade
MQ_inst	GE math/quantitative transfer course college
MQ_term	GE math/quantitative transfer course term
MQ_units	GE math/quantitative transfer course units (converted to semesters)
multrace	multiple race field from ERSS
name	students name: last, first mi suffix
native	Y/N - began HSU as a first-time undergraduate
NCAAelig	eligible to compete in NCAA sport
NCAAeth	NCAA ethnic codes (1-7.1)
NCAAethnic	NCAA ethnic code and description
ncaaID	ECID with characters added to keep leading 0s in Excel
NCAAsport	NCAA sport code (examples: MBB, MFB, WSO, WVB)
NCAAtype	NCAA student-athlete type
ncaa_aid	athletic scholarship dollars
need	amount of financial aid need
needelm	does the applicant need to take the ELM? (Y/N)
needengl	needs English remediation
needept	does the applicant need to take the EPT? (Y/N)
needESP	signup needed for Early Start Program status (E=need Engl, M=need math, B=need both, N=neither)
needESPreg	registration needed for ESP (E,M,B,N)
needespsrvreg	Humboldt destination students who are taking ESP at another campus and still need to register. . .
needHStran	do we need high school transcripts? (Y/N)
needmath	needs Math remediation
needPhoto	is an ID photo needed? (Y/N)
needrem	student needs remediation: M/E/B/N (math/english/both/neither)
needstick	does the prospect need stickers from us? (Y/N)
newfolder	message to print on folder label about existing PIP, FOL, or PUR service indicators
newinterests	has the prospect told us about interests since the last time we've emailed them? (Y/N), MAYBE. . .
newname_dt	date of last name change
nextcol	name of next college attended after leaving HSU
nextcoltype	2 or 4 year - type of first college attended after leaving HSU
noprofuture	has this prospect not received a PROFUTURE message for a future admit term? (Y/N), MAYBE OBSOLETE
norem	student failed to complete remediation in Both, English, Math, or Neither
nosuffix	diploma name with the numeric suffix removed for printing on diplomas
nothingnew	has the prospect not asked for any new since last message? (Y/N), MAYBE OBSOLETE
nullssn	blank out the ssn field
numb	Course or class number (see course numbering scheme)
numsuffix	numeric suffix
obsolete	Y if object (class) no longer exists (deleted?)
OC_course	GE oral communications transfer course
OC_grade	GE oral communications transfer course grade
OC_inst	GE oral communications transfer course instutition
OC_term	GE oral communications transfer course term
OC_units	GE oral communications transfer course semester units
ODD_dt	date a particular dataset was generated
offer	total amount of financial aid offered
office	name of office providing service
offpeak	Y/N - off peak (some part of class meets outside of 9-5, M-Th)
oldname	previous name, in case of name change
OLS	on-line supervision (on-line class with sfactor > 0)
oncampus	student lives on campus (Y/N)
online_ever	the maximum value for on_line ever for a particular subject and number
online_offer	the maximum value for on_line for a particular subject, number, and term
onlmode	A/S/blank: on-line mode (asynchronous, synchronous, not on-line)
ontimeid	STUID if a FTUG/LD/UD student graduated in 4/3/2 years
on_line	HYBRID/ONLINE or blank
options	major codes connected to a particular study field
orientation	student has signed up for HOP, HOOP, or summer bridge
orient_session	orientation session name in which applicant is registered
origin	school of origin
origintype	school type for institution of origin
origin_city	city of origin
origin_country	country of origin
origin_county	county of origin
origin_feeder	was the school of origin a "feeder" school for HSU?
origin_id	institution ID for school of origin
origin_market	market for school of origin
origin_postal	zip code for school of origin
origin_recruiter	recruiter responsible for school of origin
origin_region	region of origin (part of California, other state, or foreign) see details on Student Origin
origin_regionord	Hobsons' field
origin_state	state where school of origin is located
origin_zip	zip code of school of origin
orig_code	school of origin code
orphan	orphan - ward of the court
other_last_names	other last names
outcome	final outcome for a student
overdue	overdue rent + overdue board
overdue_board	Housing fees
overdue_rent	Housing fees
pacisl	student listed Pacific Islander as one of their races
paddr_dt	effective date of permanent address
padposted	Y/N whether PAD was posted
PADreason	constant "PAD"
PAD_dt	date applicant became ready for a pad form (last transcript received date or checklist item c. . .
paid	sum of negative amounts in item_sf
passed	total units passed before the current term
passed_HSU	units passed at HSU before this term
paylist	comma-separated list of paid items in item_sf
pb	derived from reclev_crm
pbcred	Y/N - post-bac credential
pcity	city from permanent address
pcountry	country from permanent address
PELL	student was offered a PELL grant for this aid year
pell_award	amount of PELL award
pell_elig	student is eligible for a PELL grant
PELL_eligible	eligible for PELL grant (low-income)
persist	registered at census of the next term
persist_1	registered at census 1 year after this term
persist_2	registered at census 2 years after this term
persist_3	registered at census 3 years after this term
persist_4	registered at census 4 years after this term
persist_5	registered at census 5 years after this term
persist_6	registered at census 6 years after this term
pfirst	first three letters of students first name
phone	MAIL phone type
phone_crm	phone number for Hobsons official use
phone_fixed	phone number from Hobsons user
phone_home	phone number with HOME phone type
phone_mail	phone number with MAIL phone type
plans	academic plan codes
plan_b4summer	transfer units an applicant plans to take before the following summer
plan_summer	transfer units an applicant plans to take during the following summer
plast	first three letters of students last name
points	grade points (A=4, B=3, etc)
points_class	grade points earned in a class
points_class_adj	grade points earned after considering repeats
postal	zip code
postal_crm	zip code for Hobsons official use
pphone	permanent phone number
prefix	prefix to student's name where exists (Dr., Mrs., etc.)
primary_ap	primary ethnic code from the Mentor application
primary_re	primary ethnic code from ethnic resurvey
probadmit	probationary admit
program	CS program (Banner level and degree) or name of primary major program
programno	program number from application
progStatus	program status (active, discontinued, leave of absense)
prog_action	program action code
prog_reason	program action reason
provider	the person who provided a service
provisional	admission is provisional (Y/N)
pstate	state from permanent address
pstreet1	street1 from permanent address
pstreet2	street2 from permanent address
pzip	zip from permanent address
racecnt_ap	number of distinct non-hispanic races from the application
racecnt_re	number of distinct non-hispanic races from the ethnic resurvey
races	comma separated list of racial group checked by individual
reason	description of last program action/reason
REA_dt	RSVP date with intent to attend an admission reception
received_dt	date transcript received
reclev_crm	Recruitment Level used in Hobsons communications
reclev_user	Recruitment Level specified by user in Hobsons (or CS)
recn_auto	has auto-eval been reconsidered? (Y/N)
recn_impc	admit denied due to impaction? (Y/N)
record	D1 record for student tracker data files
recruiter	recruiter code based on origin of student
REC_city	admission reception city
REC_dt	date attended an admission reception
reg	has student registered (Y/N)
regact	registration action (add, drop, change, new)
regact_dt	date of registration action
regb4july	did student register before July 1
region	geographic region where school of origin located
reg_census	Y/N - student was registered at census
reg_dt	date student first self-registered for particular term
reg_ERSS	Y/N field if reported in ERSS
reg_ever	Y/N - student registered for classes for this semester (but maybe not at census)
reg_nextcensus	Y/N - student was enrolled at census next semester
reg_now	currently registered (perhaps EE)
reinstated_times	number of times a student has been reinstated after being disqualified as an undergraduate
relation	relationship to student
remedial	course is remedial (Y/N)
remed_fall	remedial units passed last Fall term
remed_fall_classes	remedial classes passed last Fall
remed_passed	remedial units passed this term
remed_spring	remedial units passed last Spring term
remed_spring_classes	remedial classes passed last Spring
remed_summer	remedial units passed last Summer term
remed_term	remedial units attempted this term
repeat_code	code assigned to class that was repeated later (E=exclude from earned/GPA)
requireESP	student was required to enroll in Early Start Program
req_term	degree requirement term
rescode	residence status code (R, N, F, X, WUE, AB540)
resfee	California resident for fee purposes (includes WUE, AB540, NSE, and some international exchan. . .
residency	residence status (for fee purposes)
resid_code	residency code from ERS files
resid_stat	residency status from ERS file (R,M,S,T,O,F)
res_state	state of residency from the ERSS file
return	Hobsons' field
royall_id	Royall ID
rule12	NCAA ineligible because of Rule of 12/24
rule6	NCAA ineligible because of Rule of 6
rule75	NCAA ineligible because of Rule 75/25
SAT	total of highest SAT math and verbal scores
SATelig	SAT eligibility index
SATmath	highest SAT math score
SATverb	highest SAT verbal score
SATwrite	highest SAT writing score
SAT_math	highest SAT math score
SAT_math_factor	grouped SAT math scores
SAT_total	SAT math + SAT verbal (1600 max)
sat_verb	highest SAT verbal score
SAT_verbal	highest SAT verbal score
SAT_verb_factor	grouped SAT verbal scores
SAT_writ	SAT writing score
schol_aid	total amount of scholarships disbursed
schol_cancel	amount of financial aid scholarship offers that were cancelled
schol_offer	total amount of Scholarships offered
school	name of school where student previously attended
schoolcode	student tracker school code
SDRC	student is being served by the Student Disability Resource Center
search_dt	yyyymmdd - the date used for clearinghouse searches
section	section # associated with a particular CN
sectitle	section title
selfQual	prospect qualification scores (Q0=not interested, Q4=very interested)
selfreg	did this student register themselves (as opposed to the registrar doing it)?
semBiol	semesters of HS biology
semElec	semesters of HS electives
semEngl	semesters of HS English
semester	Fall, Spring, Summer
semForL	semesters of HS foreign language
semLab	semesters of HS lab science (physical science + biology)
semMath	semesters of HS math
semPhys	semesters of HS physical science
semSSci	semesters of HS social science
semVPA	semesters of HS visual and performing arts
serveneg	negative service indicators (semi-colon delimited)
servepos	positive service indicators (semi-colon delimited)
service	code of service provided
service_dt	date of service
service_indicator	tilde delimited list of A&R service indicator/reason for Hobsons
service_name	description of service provided
service_reason	comma separated list of service indicator reasons for a student
sess	orientation session
sex	M/F
sex_crm	gender for Hobsons official use
sfcodes	study field codes associated with this degree (comma separated list)
sortname	diploma name as last suffix, first middle
sortorder	field which can be used to sort the output on several fields at once
source_code	Source Code for Hobsons CRM (similar to legacy contact category)
special	special requests
sport	sport code
sport1	a student's primary sport
sports	comma-separated list of sport codes
sportsever	comma-separated list of sport codes a student ever participated in
sports_apc	special NCAA sport code for Athletic Performance Census
sport_aid	the NCAA sport group for which a student is receiving athletic aid
springgrade	high school spring grade
SSN	Social Security # with hyphens (123-45-6789)
SSN2	9 character SSN. SSN without hyphens
SSNx	last 4 digits of Social Security # (xxx-xx-1234)
Stafford	student received a federal subsidized Stafford loan
start_dt	start of HOP session
stat	status of student fee
state	mailing address
state_aid	amount of state financial aid disbursed
state_crm	state for Hobsons official use
state_fixed	state of mailing address from Hobsons user
state_free_aid	amount of "free" (grants and scholarships) state aid disbursed
status	text description of the status of this student
statusapp	application status (01inq,02not,03app,04w,05c,06d,07ad,08nc,09wd,10int,11hop,12reg)
statusstu	student status (1-IE 2-WD 3-LV 4-EL 5-AD 6-CA 7-RE)
street1	mailing address
street2	mailing address
student	name of student associated with HOP guest
student_group	tilde-delimited list of Hobsons-related student groups
study_agreement	study abroad agreement code
study_country	country code for study abroad
study_field	study_field (base major)
study_field_after1	Study Field after first year
stugroup	student group code
stugroups	student groups (comma-delimited)
stugroups2	list of student groups that includes DSS
stuid	5-letter anonymous generated id for a student
stulevel	class level or postbac category (1-Frosh,2-Soph...6-Masters, 7-Credential, 8-2nd BA, 9-Other . . .
stuservices	counts of services provided by term
stutype	student type: 1)continuing 2)returning 3)transfer 4)new 5)transitory
stutypelet	student type letter: F=first-time UG, T=transfer UG, R=ret UG, P=Cont/Ret PBac, B=New PBac, N. . .
subj	Course or Class subject code
subject	high school subject
suffix	suffix of student's name (II, III, IV, Jr., etc.)
SUG	Y if received a State University Grant
sumBridge	student is in the summer bridge student group
summer2grade	high school summer grade
summergrade	high school summr 2 grade
termActivated	is the app term activated in CS? (Y/N)
termcode	CS 4-digit termcode
termdescript	code:semester YYYY (e.g. 2084:Fall 2008)
termname	the term name without the preceeding term code (e.g. Fall 2008)
termno	a students term# at HSU - matric term=1, next enrolled term=2, etc.
terms2last	# of terms before a student's last term at HSU, 0 a student's final term.
terms_off	terms off between a term and the previously enrolled term
term_admit	term a student was originally admitted to HSU
term_app	CMS term code from application
term_course	the term a course was taken
term_final	last term a student attended as a regular student
term_first	first term a student was active in a student group
term_grad	term a student graduated (or plans to graduate)
term_in_school	term number in school based on count of terms > 0 from admit term
term_last	last term a student was active in a student group
test	test code (e.g. SAT, ACT)
testing	checking to see whether hidden works
testpart	part of test taken (e.g. VERB, MATH)
testscore	highest score ever received on this test
test_dt	date test was taken
thesis	thesis title
time	time of service
title	course title
title25	course title limited to length of 25
TOEFL	TOEFL score
to_dt	date student expects to complete attending another school
transcript_term	last term completed on most recent transcript for another school
transfer_to	School a student transferred to after HSU
transfer_to_type	type of school a student transferred to (2Yr or 4Yr)
tribe	American Indian tribal affiliation
ud	Y/N - upper-division transfer applicant (junior or senior)
udiv	derived from adbas
UDreg	registered for an upper division course
units	number of non-audit units a student is enrolled in
unitsall	all non-ee units enrolled at census at a given career
units_audit	units audited
units_completed	total (semester) units completed when transfer application submitted
units_EE	Extended Education units
units_ERSS	number of units reported in ERSS
units_fall	enrolled units at census last Fall semester
units_spring	enrolled units at census last Spring semester
unmet	amount of unmet financial aid need
unmet_last	unmet need last aid year
upward	is this applicant in Upward Bound?
URG	under-represented group (Y=AmInd,Black,Hispanic,PacIsl N=White,Asian blank=unknown)
URG_ERSS	under-represented group in ERSS (Y=AmInd,Black,Hispanic,PacIsl N=White,Asian blank=unknown)
userID	user providing service
username	oncampus email address (without the @humboldt.edu); example: abc1
verify	integer verifier code that's a repeatable hash of emplid and name for use in Web response URL. . .
vet	Y/N/missing - veteran from the CSU application
veteran	student is in the VET student group
vetgroup	show VET or VETD student group
vet_app	the veteran box was checked on the CSU application
vet_certified	veteran certified units - reference from VET service indicator
vet_chapter	reason code from service indicator
vet_service	VET service indicator
visa	foreign visa type
visit	campus visit? (Y/N)
waitlists	list of waitlisted courses
WCcat	written communication placement category
WCstat	written communication status (used to be EPTstat)
WC_course	GE English composition course
WC_grade	GE English composition course grade
WC_inst	GE English composition course institution
WC_term	GE English composition course term
WC_units	GE English composition course semester units
week	The week number into a semester
weekday	day of the week (1-SUN, 2-MON, . . . , 7-SAT)
wheelchair	will be using a wheelchair
withdraw_dt	date of last withdrawal from unit-bearing non-EE
withdraw_dt_EE	date of last withdrawal from unit-bearing EE
withdraw_fall	approved withdrawal last Fall semester
withdraw_spring	approved withdrawal last Spring semester
work_aid	total amount of work study disbursed
work_cancel	amount of work study cancelled
work_offer	amount of work study offered
WUE	Y if paying WUE fees
WUE_address	is the address in a WUE state? (Y/N)
WUE_prospect	is the application actually under the WUE program? (Y/N)
xfer	Y or N if student began as a transfer student
XFERcohort	Y if in transfer cohort (enrolled, not EE)
xfer_earned	transfer units earned
xfer_GPA	transfer GPA
xlcnt	count of classes cross-listed to this one, 1 or more
xlist	minimum CN cross-listed to this course
xpad	Is there an XPAD action in the stack for a given app (Y/N)
xtitle	Title of transfer course work
year	four-digit year
yearbefore	four-digit for last year
yearend	last day of spring classes (desired by housing)
year_term	year_term for calpass
yyyy	4-digit year
zip	mailing address
zip_fixed	zip code from Hobsons user