ODD fields - Data Dictionary for On-Demand-Datasets
oddfield report generated: 09-DEC-15
NAME
DESCRIPTION
Anumber of A grades
academic_levelclass level code (10=Frosh, 20=Soph, . . . , 50=Postbac)
acadStandingacademic standing during term (from previous term)
acadStanding_EOTacademic standing at the end of the term
acadStand_EOTacademic standing at end of term
acadstand_EOYacademic standing at end of year
acadStand_springacademic standing at the end of the following Spring
acad_deptIndicates Y or N if code is an academic department
acad_org_classacademic org code from the class table (usually the same as from the subject)
acad_org_lastmost recently modified academic org code for a particular department
acad_org_subjacademic org code from the subject table (usually the same as from the class)
acad_planacademic plan code
acad_progacademic program
acad_standingacademic standing at the beginning of a term
acad_yearacademic year (yyyy) [matches Fall semester]
accepttotal amount of financial aid accepted
acceptFAstudent has accepted financial aid
acceptSUGstudent has accepted State University Grant
acceptSUG_tdstudent has accepted a Student University Grant
accept_grant. . .
accept_loan. . .
accept_work. . .
accountfiscal account
acstandacademic standing (GOOD, PROB, REIN, DISQ, or blank if a new student)
acstand_EOTacademic standing at end of term (GOOD, PROB, REIN, DISQ)
acstand_EOYacademic standing at end of year (GOOD, PROB, REIN, DISQ)
acstand_fallacademic standing after last Fall semester
acstand_springacademic standing after last Spring semester
actprogram action code
ACTcompmaximum ACT composite score
ACTeligACT eligibility index
ACTenglmaximum score on english portion of the ACT test
actionprogram action code
action_dtprogram action date
activeactive prospect (not withdrawn, denied, or no longer interested in attending)
activitieslist of activity codes
ACTmathmaximum score on math portion of the ACT test
ACT_compACT composite score
act_dtactivity date when data was last entered or updated
act_englACT English maximum score
ACT_factorgrouped ACT composite scores
act_mathACT math maximum score
act_readACT reading maximum score
act_scienceACT science maximum score
act_writACT writiing maximum score
adbasadmission basis code
address1_crmstreet address line 1
address2_crmstreet address line 2
address_line_1_fixedstreet address line 1 from Hobsons user
address_line_2_fixedstreet address line 2 from Hobsons user
address_typewhich address type is shown
addr_dteffective date of current mailing address
add_class_dtdate class was added
ADF_dtdate application decision form was generated
admithas applicant been admitted (Y/N)
admittermTerm a student was first admitted to HSU
admit_classapplicant student level for housing file
admit_dtdate of admission
admit_monthmonths into admission cycle that a student was admitted (Oct=0, Nov=1, etc.)
admit_statushousing status of applicant
admit_termterm a student was admitted to a particular program (ignores returning applications)
admit_termcodeterm a student was admitted to a particular program (ignores returning applications)
admit_termdescriptterm a student was admitted to a particular program (ignores returning applications)
admit_termnameterm a student was admitted to a particular program (ignores returning applications)
admit_term_crm4-digit CS term code used in Hobsons communications
admit_term_user4-digit CS term code possibly edited by prospective student in Hobsons
admit_typeCS admit_type (1=continuing, 2=returning, 3=returning with units, 4=transfer, 5=new, 6=transitory)
adothrY/N if has ADOTHR checklist item missing
adtermsderived from multiple applicant flag fields
advDepartdepartment assigned to instructor/advisor
advDepcodedepartment code assigned to instructor/advisor
advHoldadvising hold exists (Y/N)
advisoradvisor's name (Last FM)
advisorscomma-separated list of advisor names
advNoadvisor #
advRoleadvisor role (ADVR, EOPA, THES)
advserve_falladvising service dates last Fall semester
advserve_springadvising service dates last Spring semester
affiliationmid-semester group affiliations, comma-separated, ATHL, EOP, SSS, LC, etc.
ageage of student
age_censusage of student on census date of a particular term
AGIadjusted gross income
aid. . .
aidyearfinancial aid year (2010 = 2009-10)
aid_yearfinancial aid year (year of spring semester)
aid_year_namefinancial aid year
allmajcodeslist of all major codes associated with a particular degree
altadmitderived from adbas
amerindstudent listed American Indian as one of their races
amount(will someone please tell Ward what this field contains besides numbers from 0 to 14)
amtamount for student fee
apphas propsect applied (Y/N)
appfeestatapplication fee status
APPnoCMS application number - 8 digits starting with 00
apptypeapplicant type [F=First-time UG, L=LD Transfer, U=UD Transfer, R=Returning UG, M=Masters, C=C. . .
apptypeletapplicant type [F,L,U,R,M,C,B,P,N]
app_daysagointeger reflecting how many days ago is the app_dt
app_dtapplication date
apstatusdescription of current application status
arrivedate arrive on campus for HOP
asianstudent listed Asian as one of their races
ASLAmerican Sign Language
athaidY/N is the student receiving athletic aid
athaidsportsport that gave athletic aid to a student
athletestudent is playing on a University sports team
athstatuscurrent athletic partipation status
autoevalwas the application processed by auto-eval process (Y/N)
award. . .
aynameacademic year name (e.g. 2002-03)
Bnumber of B grades
BAfailedBusiness core classes failed
BApassedBusiness core classes passed
base_CNcourse number for base supplemental instruction course
base_coursecourse (subj ###) for which supplemental instruction is offered
belowCgrade less than C-
belowDgrade less than D-
billingthe office that was billed for a service
birthdatemm/dd/yyyy
birthdate2birthdate in yyyymmdd format
birthmmddyyyybirthdate in mmddyyyy format
birth_crmHobsons format birthdate
blackstudent listed black as one of their races
blankblank field for student tracker data files
branchstudent tracker school branch code
bridgeis this a "Bridge" student (Y/N)
Cnumber of C grades
calpass_cls_unitsunits in a particular class formatted for calpass
calpass_csuffixcourse suffix for calpass
calpass_degreedegree code for calpass
calpass_earnedtotal units earned toward degree formatted for calpass
calpass_earned_HSUunits earned at HSU toward degree formatted for calpass
calpass_earned_termunits earned this term toward degree formatted for calpass
calpass_enrstatenrollment status codes for calpass
calpass_ethethnicity codes for calpass
calpass_GPAoverall GPA for courses taken before this term formatted for calpass
calpass_GPA_termGPA for classes taken this term at HSU formatted for calpass
calpass_levelstudent level codes for calpass
calpass_unitsnumber of non-audit units a student is enrolled in formatted for calpass
calpass_xfer_earnedtransfer units earned formatted for calpass
calpass_xfer_GPAtransfer gpa formatted for calpass
canceltotal amount of financial aid offers that were cancelled
cand_termterm a masters student advanced to candidacy
capmaximum capacity
careerstudent "career": UGRD or PBAC
careernocareer number
cashier_holdexistence of a CSH negative service indicator
CEEBCEEB institution code
cenregregistered at census
censusY/N flag if here at census
cenunitscensus units
chargedsum of positive amounts in item_sf
chargelistcomma-separated list of charged item codes in item_sf
childcarenumber of children
cidcourse ID code from CMS (catalog code)
cip6 digit code cip code of major in XXXXXX format
cip16 digit code cip code of major in XXXXXX format of first diploma major
cip26 digit code cip code of major in XXXXXX format of second diploma major
cip36 digit code cip code of major in XXXXXX format of third diploma major
cipcodeFederal Classification of Instruction Programs (xx.xxxx). Crosswalked with CSU HEGIS code.
cip_codeFederal Classification of Instruction Programs (xx.xxxx). Crosswalked with CSU HEGIS code.
citcitizenship code from ERSS file
citizenshipcitizenship (US Citizen, green card, F Visa, etc.)
citizenship_statuscitizenship status code (US Citizen, green card, F Visa, etc.)
citizen_cdcitizenship code from ERSS table
citymailing address
city_crmcity for Hobsons official use
city_fixedcity from Hobsons user
cit_erss. . .
classacademic level:class name (e.g. 20:Sophomore)
classeslist of registered classes
class_admitclass at the time of admission
class_on_app0 (0-30 units), 1 (30-60 units), . . . From Mentor application
class_start_dtClass start date based on the term or overridden in class section.
class_stop_dtClass end data based on the term or overridden in class section.
clevclass level code: 0=not a real class, 1=lower division, 2=upper div, 3=graduate, P=pre-collegiate
cls_allunitsall units in a class (includes EE and audits)
cls_depcodeclass department
cls_eeunitsEE units in a class
cls_termterm for a particular class
cls_unitsunits in a particular class
cmodeclass mode (example: C-1 = Large Lecture)
cmode_catcategory of class mode: Lecture, Activity, Laboratory, Coaching, Seminar¿
cmode_descriptdescription of class mode
CNclass number (equivalent to Banner CRN)
CNCcourse taken for credit/no credit
CN_SIsupplemental instruction course number
cohortcohort name
colcodetwo-character college code of first major
colcodescomma-separated list of college codes associate with student's major(s) (values: AU, HS, NS, PS)
colcode_classcollege code based on academic or in class table
colcode_subjcollege code based on subject
collegecollege of first major
college_classcollege name based on class
college_codeExternal Org ID for college previously attended stored in Hobsons
college_subjcollege name based on subject
commencenamename to print on commencement list (includes trailing * for honors)
commentscomments
compcomponent code for a class: LEC, LAB, SEM, ACT, etc.
compdescriptdescription of class component
complete_dtdate an application is completed - generally the ADF or PRCL date
compunitsunits attached to each component of a class
concentrationname of first major option/concentration for this study field
concentration2name of second option/conentration attached to this study field
concurrentstudent is attending another institution at the same time as HSU
conditionalis this a conditional admit (Y/N)
confirmhas admit indicated an intent to enroll (Y/N)
confirmedY/N - intent to enroll, HOP reg, housing deposit, or registration
connect_idhobsons id
contact_hourscontact hours
contact_nbrcontact number
contact_typewhat kind of person record (prospect, parent, counselor)
countrymailing address
country_citcountry of citizenship
country_crmcountry for Hobsons official use
country_fixedcountry from Hobsons user
coursecourse subject and number
courselev1st digit of class number
coursenohigh school course number
courseslist of registered courses
coursetitleclass title and component name (should be comptitle?)
course_SIsupplemental instruction course (subj ###)
credentialcredential name
creditscourse or class credit units
credorderorder column for credential commencement list
crsmancourse manually entered?
CSISid number for student assigned to or by the first CA district in which the student enrolled b. . .
csno2 digit class mode (examples: 01 for C-1 or 25 for S-25)
CSU Mentor #number from electronic application download
csuappnoCSU application #
csu_coll2 digit college code for CSU reporting - from subject
csu_dept3 digit department code for CSU reporting - from subject
CT_courseGE critical thinking course
CT_gradeGE critical thinking course grade
CT_instGE critical thinking course institution
CT_termGE critical thinking course term
CT_unitsGE critical thinking course semester units
Dnumber of D grades
DATAactionconstant "DATA"
ddenyY/N for has DENY/DDNY in their application stack
deceasedY/N field is person is deceased
degcodedegree code (BA, BS, MA, MS, etc) without number identifier
degcodeslist of student's degree objectives, one per major (BA, BS, MA, MS, MB, MW, CR)
deghonordegree honor granted
degmajdegree ~ major; used for masters commencement bulletin
degnamedegree name (e.g. Bachelor of Science)
degnodegree number
degreedegree code from CS
degree_lastdegree code for last degree awarded or sought
degree_termdegree term for last degree awarded or sought
degree_term_lastterm for the last degree awarded or sought
degr_heldstudent has an associated degree
degStatusdegree status (sought, awarded, denied)
degStatus_lastdegree status for last degree awarded or sought
deny_admitDN service indicator exists (denied after being admitted)
deny_holddate string for active hold DN/DENY
departdate depart from campus from HOP
departmentdepartment of first major
department_classdepartment name of acad org in class table
department_subjdepartment name from acad org of subject
depcodedepartment code
depcode2. . .
depcode3. . .
depcodeslist of department codes that student's majors are in
depcode_classdepartment code of acad org in class table
depcode_masters. . .
depcode_subjdepartment code from acad org of subject
dependentdependent status (D or I)
deptid_classdepartment ID (D200##) from academic org in class table
deptid_subjdepartment ID (D200##) of class based on subject
descriptionprogram action description
dipdatediploma date - spelled out for diploma printing
dipholdY if a hold exists which blocks diploma printing (GRAD)
dipmajorslist of diploma major descriptions separated by "and"s
dipnamename to print on a diploma
disabilitydisability code (see ERSS manual)
disbursetotal amount of financial aid disbursed
disciplinegeneral grouping of a student's major from the CIP
disq_semesters_offnumber of semesters off after being disqualifed for a given term and career
disservicedisabled student service code (see ERSS manual)
divdivision code for class: RE, LD, UD, GR, **
divdescdivision description for a class
divnodivison number (0-3) for a class
dob_fixeddate of birth from Hobsons user
droppedwas this class dropped (Y/N)
dssprimary disabled student service
dssgroupmembership in DSS student group
dssoptionscomma-separated list of accomodation options
earnedtotal units earned toward degree
earned_fallunits earned toward degree last Fall semester
earned_first_fallunits earned during a student's first Fall semester
earned_first_springunits earned during a student's first Spring semester
earned_HSUunits earned at HSU toward degree
earned_springunits earned toward degree last Spring semester
earned_summerunits earned toward degree last Summer semester
earned_termunits earned this term toward degree
earned_term_factorgrouped units earned this term
earned_testunits earned from AP, IB and other tests
earned_xfertransfer units earned
earned_yearunits earned this year toward degree
ECIDNCAA ID
ed_fatherfather's education level
ed_mothermother's education level
eeExtended Ed Student Y-yes or N-no
EFCamount of expected family contribution
elig_nonresY/N meets eligibility for non CA resident
elig_resY/N meets eligibility for CA resident
elite_scholarstudent is in the ESP or ESPR student group
ELMELM total score
ELMEPTELM/EPT combined need code
ELMEPTprgrsELM/EPT progress code
ELMEPT_dtlast date student took the ELM or the EPT
ELMEPT_overrideELM or EPT needed override
ELMstatEntry Level Mathematics status - 1,2,3 => needs remediation; other values explain why exempt
elmstat_appEntry Level Mathematics status - 1,2,3 => needs remediation; other values explain why exempt
ELM_dt_firstdate of first ELM test
ELM_firstfirst Entry Level Math score
ELM_lastlast Entry Level Math score (if different from first)
emailpreferred email address
email_crmemail address for Hobsons official use
email_fixedemail from Hobsons user
email_opt_out_fixedemail opt out from Hobsons user
EMPLIDthe HSU ID (without hyphens)
enddt. . .
endtimetime class lets out
end_dtend of HOP session
end_dt01date meeting #1 for a class ends
end_dt02. . .
end_dt03. . .
end_dt1. . .
end_dt2. . .
end_dt3. . .
ENGLprofhighest english proficiency student group
ENGLremEnglish remediation status (text)
enrollednumber of students enrolled
enrolled_365was this person enrolled at HSU in the past 365 days
enroll_classstudent level for housing file
enroll_statusstudent status for housing file: E)ligible, R)egistered, W)ithdrawn, N)ot eligible
enroll_termstudent last enrollment term for housing file
enrstatenrollment status: 1-Continuing,2-Returning,3-Returning Transfer,4-Transfer,5-First-time,6-Tr. . .
enr_censusenrolled at census
entry_termterm name of admit term (Fall/Spring/Summer)
entry_yearyear of admit term
EOPY if in an EOP student group
EOPappis the applicant an EOP application? (Y/N)
EOPreviewIs the application in EOP review? (Y/N)
EOPstatEOP status (interest) from application (Y/N/null)
eop_admitadmitted by EOP (Y/N)
EOP_advisorEOP advisor name
EOP_appchecklist value for EOP
EOP_app_dtdate on EOP APP checklist item
EOP_dependentdependent status reported to EOP
EOP_dtdate of last EOP record change
EOP_EligY if EOP eligible
EOP_ERSvalue of EOP status field on ERS subform
EOP_estincestimate income from EOP form
EOP_familyfamily size reported to EOP
EOP_incomeincome from EOP form
EOP_interestY if expressed interest in EOP
EOP_LoR1checklist value for EOP letter of recommendation 1
EOP_LoR1_dtdate on EOP LR1 checklist item
EOP_LoR2checklist value for EOP letter of recommendation 2
EOP_LoR2_dtdate on EOP LR2 checklist item
EOP_prior_CSUprior CSU from EOP form
EOP_reasondescription of last EOP action reason
EOP_residencyresidency from EOP form
EPTEPT total score
EPTstatEnglish Proficiency status - 1,2,3 => needs remediation, other values explain why exempt
eptstat_appEnglish Proficiency status - 1,2,3 => needs remediation, other values explain why exempt
EPT_compoEPT composition subscore
EPT_dt_firstdate of first EPT test
EPT_essayEPT essay subscore
EPT_firstfirst English Placement Test score
EPT_lastlast English Placement Test score (if different from first)
EPT_readEPT reading subscore
ESPearly start program participation (B=both, E=English, M=math)
ESPE_gradegrade (CR/NC) from ESP writing
ESPM_gradegrade (CR/NC) from ESP math
ESP_ELMgaingain in ELM score after taking ESP math
ESP_englEarly start English code from ERSS (1=completed, 7=not, 2-6 exemptions)
esp_e_planEarly Start Program campus chosen on Smart Page for english
ESP_mathEarly start math code from ERSS (1=completed, 7=not, 2-6 exemptions)
esp_m_planEarly Start Program campus chosen on Smart Page for math
ESP_notearly start program non-compliance
ESP_schoolschool code where student signed up to take ESP (30=HSU)
ethshort racial description from dim_person without sorting digit
ethchoiceethnicity selected by student
ethcitcodesame as ethcode except returns a 9 for nonresident aliens
ethcodeERSS values: IPEDS_race_cat field if it exists, converted old ethnic_code otherwise
ethgrpethnic group code
ethnicethnic group without non-resident alien category
ethnicityprimary ethnic group (collapsed from original ethnic code to eight major groups)
ethnicity_citprimary ethnic group with nonresident aliens split out
ethnicity_lastethnicity before the current one
ethnic_citethnic group with non-resident alien category
ethnic_dtlast date in ethnic history
ethnic_GSRethnic-citizenship ordered for the NCAA GSR report
eth_alienY if non-resident alien (citizenship code of Y or I)
eth_asianY if ethnicities include Asian
eth_asianracespecific Asian racial subcategory
eth_blackY if ethnicities include Pacific Islander
eth_citethic/citizenship code without sorting digit (from dim_person)
eth_hispanicY if reported latino/hispanic background
eth_hobsonsethnic group code used in Hobsons/prospects (1-8)
eth_indianY if races include American Indian/Alaskan native (including Latin American Indian)
eth_natamerNative American: person has reported a North American tribal affiliation
eth_pacislY if ethnicities include Pacific Islander
eth_tribetribal affiliation
eth_urmY if under-represented minority (not white, asian, or unknown)
eth_urm_descdescription of under represented minority, suitable for column heading
eth_whiteY if ethnicities include white
eval_statusstatus after auto-evaluation
excadmitexception admit (Y/N)
excelIDversion of student ID that will display leading 0s in Excel
exceptexception basis code
exclusionNCAA allowable exclusion (disabled, military, foreign service, mission)
ext_org_idCMS institution code
Fnumber of F grades
facnamefaculty name
FAFSAapplied for financial aid for this aid year
FAFSA_dtdate FAFSA was completed
FAFSA_lastapplied for financial aid last aid year
failY if course was failed
fallgradehigh school fall grade
famsizefamily size
fed_aidamount of federal financial aid disbursed
fed_free_aidamount of "free" (grants and scholarships) federal aid disbursed
feewaiverstate fee waiver code and short description
fee_wvrERSS fee waiver code: 01=Cal Vet, 03=CSU employee, 04=CSU Dependents, 05=Over60 06=High School
FERPAhas student requested confidentiality
fhunpapplicant's First-time HSU User Name Password from "Admissions" External System ID in CS
fidfiscal id
finaidstudent received financial aid (Y/N)
firstfirst name of student
firstgenfirst generation student: neither parent graduated from a 4-year college
firstlastprefix first last, suffix
firstmlastprefix first mi last, suffix
first_name_crmfirst name for Hobsons official use
first_name_fixedfirst name from Hobsons user
first_termfirst term a student was enrolled in any college after high school
fisamountamount of student fees
fiscatfiscal category (WUE, CAres, nonRes)
fislevfiscal level (UGRD, Cred, other PB)
fol_dtdate attached to FOL service (folder label)
foreign_postal_code_crmnon-US postal code for Hobsons communications
foreign_postal_code_usernon-US postal code from Hobsons user
foreign_state_crmnon-US state for Hobsons communications
foreign_state_usernon-US state from Hobsons user
free_aidscholarships and grants
from_dtdate student began attending another school
FTEfull-time equivalent students (fraction of 12 units for Masters, fraction of 15 for all others)
FTE_ERSSfull-time equivalents from the ERSS staging table
FTE_unitsunits taken from the ERSS staging table
FTFTUG_ERSSY if first-time, full-time, student in ERSS file
FTnoshowfirst-time undergraduate applicant who did not enroll
ftugY/N - first-time undergraduate (usually a frosh)
FTUGcohortY if in Fall first-time full-time undergraduate cohort
fulltimeY if full-time student (>= 9 units for Masters, >= 12 units for all others)
fulltime_feesgreater than 6 units
future_prospectis the prospects admit_term more than a year into the future? (Y/N)
f_work. . .
gecritfirst character of ge_ct
GEearnedGE earned units (D or better)
geenglfirst character of ge_wc
gemathfirst character of ge_mq
genderMale or Female
gender_fixedgender from Hobsons user
gespeefirst character of ge_oc
ge_area1-4 or blank - class meets General Ed area: A1,B3,A2,A3
ge_attrscomma-separated list fo GE attributes
ge_classY/N - class meets a general ed requirement
ge_critthkY/N/I (in progress) - General Ed critical thinking component met
GE_ctGeneral education - critical thinking met (Y/N or I for in-progress)
ge_englcompY/N/I (in progress) - General Ed English component met
ge_mathY/N/I (in progress) - General Ed math component met
GE_mqGeneral education - math/quantitative reasoning require met (Y/N or I for in-progress)
GE_ocGeneral education - oral communication met (Y/N or I for in-progress)
ge_oralcommY/N/I (in progress) - General Ed oral communications component met
GE_wcGeneral education - writing/composition requirement met (Y/N or I for in-progress)
GPAoverall GPA for courses taken before this term
gpa2overall GPA during a particular term, not including the current term
GPA_after_springGPA after the following Spring semester
gpa_eotoverall GPA for courses taken at end of term
GPA_fallGPA earned last Fall semester
GPA_HSGPA from high school
GPA_HSUoverall GPA for classes taken at HSU
gpa_hsu_eotoverall GPA for classes taken at HSU at end of term
GPA_HS_factorgrouped high school GPAs
GPA_last_termGPA at the end of student's last term of attendance
gpa_remedGPA for remedial coursework
GPA_springGPA earned last Spring semester
GPA_summerGPA earned last Summer semester
GPA_termGPA for classes taken this term at HSU
GPA_term_factorgrouped term GPAs
GPA_unitsunits taken the term that are counted in the GPA (excludes CR/NC and remedial)
GPA_xferGPA transferred from other schools
gradgrad flag for Hobsons' upload
gradegrade a student received in a course
gradeletcourse grade with the + or - removed
gradelevhigh school grade level
grade_requiredgrade required to pass the class (either CR of C-)
grade_SIgrade received in supplemental instruction
grading_basisgrading basis code for a class (AUD,CNC,LTR,REM,etc.)
grading_basis_classgrading basis code for a class (AUD,CNC,LTR,REM,etc.)
gradstat. . .
gradterm. . .
graduatereceived a degree
grad_app_dtdate a student applied to graduate
grad_dtdate of graduation (from HSU for students; from high school or transfer institution for applicants)
grad_in_3graduated in 3 years or less
grad_in_4graduated in 4 years or less
grad_in_5graduated in 5 years or less
grad_in_6graduated in 6 years or less
grad_in_7graduated in 7 years or less
grad_in_8graduated in 8 years or less
grad_termterm student graduated or has applied to graduate
grant_aidtotal amount of grant aid disbursed
grant_cancelamount of financial aid grant offers that were cancelled
grant_offertotal amount of Grants offered
GSRsportscholarship sport during student's first year at HSU
GWPEgraduate writing proficiency has been passed (Y/N)
GWPE_attempts# of attempts at graduate writing proficiency exam
hc_admitadmit headcount - 1 if admitted, 0 otherwise
hc_appapplicant headcount - 1 if admitted, 0 otherwise
hc_regregistered headcount - 1 if enrolled at census, 0 otherwise
hegis_cipclasses CIP code - from the subject table
high_school_codeExternal Org ID for high school previously attended stored in Hobsons
hispanicone of a student's races is hispanic
hispcathispanic/latino detail
hisp_apHispanic value from Mentor application
hisp_reHispanic value from ethnic resurvey
hold_typehousing hold type (probation or removal)
honors* if a graduate is receiving academic honors
HOOPComplete (HP+) or Incomplete (RHP)
HOOPdonefinished HOOP/has HP+ service indicator (Y/N)
HOOPeligis the applicant eligible to go through HOOP? (Y/N)
HOOPreghas the applicant registered for HOOP? (Y/N)
HOOPregdatedate on which an applicant registered for HOOP
HOPwill partipate in HOP
hourhour in the day: 0-23
hour1. . .
hour2. . .
hour3. . .
hoursinteger number of hours a class meets, usually 1, 2, or 3 (rounds up)
hours1. . .
hours2. . .
hours3. . .
housingdep_tdhousing deposit was paid by a comparable date
housing_depstudent has paid a housing deposit
housing_holdSHF or SPH hold exists for for this student
housing_statusstatus codes for housing
housing_typestudent type for housing, either New, Transfer, or Continuing
hsgpahigh school gpa
hsgradtermterm a student graduated from high school (CMS codes - e.g. 2144)
HSU_IDHSU ID (aka EMPLID) with a hyphen
HS_GPAhigh school GPA
icontactinitial contact code
IDstudent ID
id_appEMPLID from the application
id_erssEMPLID from ERSS
id_personEMPLID from person dimension
id_statustype of id submitted for calpass S= ssn, C= campus assigned
impacted_appapplied for impacted major
inCohortfield required in NCAA GSR upload file
incomplete_checkliststilde-delimited incomplete ADMA checklists
ind_studyY/N - independent study
initial_dateinitial date of contact with a prospect
inProgressnumber of units in progress
instrIDEMPLID for primary instructor
instridscomma-separated list of instructor EMPLIDs
instructorprimary instructor
instructor_primaryprimary instructor name as Last, FM
inst_aidamount of institutional financial aid disbursed
inst_free_aidamount of "free" (grants and scholarships) aid from HSU disbursed
inst_idIPEDS institution number for hsu
inst_originstution of origin for calpass
intent_tdapplicant confirmed intent to enroll by a comparable date
internationalresidency status (for fee purposes) of F)oreign (Y/N)
intlfield contains INTL for foreign students (residency=F), blank otherwise
IPEDScitethIPEDS ethnicity (with Nonres Alien category) as reported in ERSS
IPEDSciteth2IPEDS ethnicity (with Nonres Alien category)
IPEDSciteth_cscitizenship/ethnicity according to ethnic history table in CS
IPEDSciteth_ERSSIPEDS categories reported in ERSS
ipedsethour calculated value for the IPEDS race value
ipedsracethe race value the CSU reports in ERSS
isourceinitial source of prospect (collapsed version of icontact)
itemnamelong name for item
itemshortshort name for item
item_amountitem amount for student fees
item_typefiscal item_type number, preceded by a #
journal_datedate of fiscal transaction to journal
keyodd view key
kfactork factor: 0-6 or null, used to calculate WTU
lastlast name of student
lastactlast program action/reason
lastactdtdate of last program action
lastdegaftername of last degree shown in Clearinghouse data after leaving HSU
lastEOPactlast EOP application program action/reason
last_namestudent's last name
last_name_crmlast name for Hobsons official use
last_name_fixedlast name from Hobsons user
last_self_qualthe last self-qualification we have for this prospect from extracurricular activities in CS o. . .
last_termlast term a student registered for classes
last_updatedate record was last updated
lateappis the application late? (Y/N)
LC_servicescount of Learning Center services provided by term
ldY/N - lower-division transfer applicant (frosh or sophmore)
ldivderived from adbas
leftEligibleathlete transferred to another school while still eligible to play
limitedless than 6 units
loan_aidtotal amount of loans disbursed
loan_cancelamount of financial aid loan offers that were cancelled
loan_offertotal amount of Loans offered
localis the address local? (Y/N)
lodgingwill need lodging
low_incomefamily's taxable income (total-standard deduction) less than 150% federal poverty level
LPMenrolled in a Latino Peer mentoring class
majcodemajor code (first four characters of academic plan)
majcode2major code for 2nd major
majcode3major code for 3rd major
majcodeslist of majors (codes)
majcodes_after1major codes 1 year later
majcodes_finalthe final majcodes value for a student in a particular academic program
majcode_after1major code after a student's first semester
majcode_origmajor code from application
majormajor on application or first major in student record
major1major name or blank for MBA and MSW
major1_crmmajor code 1 for Hobsons official use
major1_crm_descrmajor description 1 for Hobsons official use
major1_usermajor code selected by user first in Hobsons
major2name of second major
major2_crmmajor code 2 for Hobsons official use
major2_crm_descrmajor description 2 for Hobsons official use
major2_usermajor code selected by user second in Hobsons
major3name of third major
major3_crmmajor code 3 for Hobsons official use
major3_crm_descrmajor description 3 for Hobsons official use
major3_usermajor code selected by user third in Hobsons
major4name of fourth major
major5name of fifth major
majorseither "a major in" or "majors in", depending on the number of distinct diploma majors
majors_listcomma separated list of major codes in which a prospect is interested
major_contractY=complete, N=needed, blank if not applied for graduation
major_fallMajor code(s) at census last fall semester
major_springmajor code(s) at census last Spring semester
mastersY if student is trying to earn a masters (may be EE)
MATHprofhighest math proficiency student group
MATHremMath remediation status (text)
matricmatriculation term code (first-term degree-seeking)
matricAYacademic year when student first matriculated
matricTermmatriculation term name
matricTypeapplicant type for student in the term they first matriculated
maxdegaftermaximum degree received after leaving HSU
maxUnitsmaximum units a student is allowed to register for
MBAY if MBA student
meetdatescomma-separated list of class meeting date ranges
meetdayscomma-separated list of days the meetings for a class are held (e.g. MW,F)
meetminscomma-separated list of minutes the meetings for a class (e.g. 80,110)
meettimescomma-separated list of start times the meetings for a class (e.g. 1400,0900)
mimiddle initial of student
middlemiddle name of student
middle_namemiddle name
middle_name_crmmiddle name for Hobsons official use
middle_name_fixedmiddle name from Hobsons user
mildepmilitary dependent (applicant)
mil_dependentmilitary dependent
mincodeslist of minors (codes)
mincodes_after1minor codes 1 year later
minutesnumber of minutes of the primary meeting for each class
minutes1. . .
minutes2. . .
minutes3. . .
missinganyis the applicant missing anything? (Y/N)
missing_itemsincomplete items on the checklist
misssigmissing something significant? (Y/N)
monthmonth of the year (01-Jan, 02-Feb, ¿ 12-Dec)
MQ_courseGE math/quantitative transfer course
MQ_gradeGE math/quantitative transfer course grade
MQ_instGE math/quantitative transfer course college
MQ_termGE math/quantitative transfer course term
MQ_unitsGE math/quantitative transfer course units (converted to semesters)
multracemultiple race field from ERSS
namestudents name: last, first mi suffix
nativeY/N - began HSU as a first-time undergraduate
NCAAeligeligible to compete in NCAA sport
NCAAethNCAA ethnic codes (1-7.1)
NCAAethnicNCAA ethnic code and description
ncaaIDECID with characters added to keep leading 0s in Excel
NCAAsportNCAA sport code (examples: MBB, MFB, WSO, WVB)
NCAAtypeNCAA student-athlete type
ncaa_aidathletic scholarship dollars
needamount of financial aid need
needelmdoes the applicant need to take the ELM? (Y/N)
needenglneeds English remediation
needeptdoes the applicant need to take the EPT? (Y/N)
needESPsignup needed for Early Start Program status (E=need Engl, M=need math, B=need both, N=neither)
needESPregregistration needed for ESP (E,M,B,N)
needespsrvregHumboldt destination students who are taking ESP at another campus and still need to register. . .
needHStrando we need high school transcripts? (Y/N)
needmathneeds Math remediation
needremstudent needs remediation: M/E/B/N (math/english/both/neither)
needstickdoes the prospect need stickers from us? (Y/N)
newfoldermessage to print on folder label about existing PIP, FOL, or PUR service indicators
newinterestshas the prospect told us about interests since the last time we've emailed them? (Y/N), MAYBE. . .
newname_dtdate of last name change
nextcolname of next college attended after leaving HSU
nextcoltype2 or 4 year - type of first college attended after leaving HSU
noprofuturehas this prospect not received a PROFUTURE message for a future admit term? (Y/N), MAYBE OBSOLETE
noremstudent failed to complete remediation in Both, English, Math, or Neither
nosuffixdiploma name with the numeric suffix removed for printing on diplomas
nothingnewhas the prospect not asked for any new since last message? (Y/N), MAYBE OBSOLETE
nullssnblank out the ssn field
numbCourse or class number (see course numbering scheme)
numsuffixnumeric suffix
obsoleteY if object (class) no longer exists (deleted?)
OC_courseGE oral communications transfer course
OC_gradeGE oral communications transfer course grade
OC_instGE oral communications transfer course instutition
OC_termGE oral communications transfer course term
OC_unitsGE oral communications transfer course semester units
ODD_dtdate a particular dataset was generated
offertotal amount of financial aid offered
officename of office providing service
offpeakY/N - off peak (some part of class meets outside of 9-5, M-Th)
oldnameprevious name, in case of name change
OLSon-line supervision (on-line class with sfactor > 0)
oncampusstudent lives on campus (Y/N)
online_everthe maximum value for on_line ever for a particular subject and number
online_offerthe maximum value for on_line for a particular subject, number, and term
onlmodeA/S/blank: on-line mode (asynchronous, synchronous, not on-line)
on_lineHYBRID/ONLINE or blank
optionsmajor codes connected to a particular study field
orientationstudent has signed up for HOP, HOOP, or summer bridge
originschool of origin
origintypeschool type for institution of origin
origin_citycity of origin
origin_countrycountry of origin
origin_countycounty of origin
origin_feederwas the school of origin a "feeder" school for HSU?
origin_idinstitution ID for school of origin
origin_marketmarket for school of origin
origin_postalzip code for school of origin
origin_recruiterrecruiter responsible for school of origin
origin_regionregion of origin (part of California, other state, or foreign) see details on Student Origin
origin_regionordHobsons' field
origin_statestate where school of origin is located
orig_codeschool of origin code
orphanorphan - ward of the court
other_last_namesother last names
outcomefinal outcome for a student (1-graduated, 2-transfer, 3-no degree) [used by NCAA GSR]
overdueoverdue rent + overdue board
overdue_boardHousing fees
overdue_rentHousing fees
pacislstudent listed Pacific Islander as one of their races
paddr_dteffective date of permanent address
padpostedY/N whether PAD was posted
PADreasonconstant "PAD"
PAD_dtdate applicant became ready for a pad form (last transcript received date or checklist item c. . .
paidsum of negative amounts in item_sf
parttime. . .
passedtotal units passed before the current term
passed_HSUunits passed at HSU before this term
paylistcomma-separated list of paid items in item_sf
pbderived from reclev_crm
pbcredY/N - post-bac credential
pcitycity from permanent address
pcountrycountry from permanent address
PELLstudent was offered a PELL grant for this aid year
pell_award. . .
pell_elig. . .
PELL_eligibleeligible for PELL grant (low-income)
pell_fa. . .
persistregistered at census of the next term
persist1. . .
persist_1registered at census 1 year after this term
persist_2registered at census 2 years after this term
persist_3registered at census 3 years after this term
persist_4registered at census 4 years after this term
persist_5registered at census 5 years after this term
persist_6registered at census 6 years after this term
pfirstfirst three letters of students first name
phoneMAIL phone type
phone_crmphone number for Hobsons official use
phone_fixedphone number from Hobsons user
phone_homephone number with HOME phone type
phone_mailphone number with MAIL phone type
plansacademic plan codes
plan_b4summertransfer units an applicant plans to take before the following summer
plan_summertransfer units an applicant plans to take during the following summer
plastfirst three letters of students last name
pointsgrade points
postalzip code
postal_crmzip code for Hobsons official use
pphonepermanent phone number
prefixprefix to student's name where exists (Dr., Mrs., etc.)
primary_apprimary ethnic code from the Mentor application
primary_reprimary ethnic code from ethnic resurvey
progcat. . .
programCS program (Banner level and degree)
programnoprogram number from application
progStatusprogram status (active, discontinued, leave of absense)
prog_reasonprogram action reason
providerthe person who provided a service
provisionaladmission is provisional (Y/N)
pstatestate from permanent address
pstreet1street1 from permanent address
pstreet2street2 from permanent address
pzipzip from permanent address
racecnt_apnumber of distinct non-hispanic races from the application
racecnt_renumber of distinct non-hispanic races from the ethnic resurvey
racescomma separated list of racial group checked by individual
reasondescription of last program action/reason
received_dtdate transcript received
reclev_crmRecruitment Level used in Hobsons communications
reclev_userRecruitment Level specified by user in Hobsons (or CS)
recn_autohas auto-eval been reconsidered? (Y/N)
recn_impcadmit denied due to impaction? (Y/N)
recordD1 record for student tracker data files
recruiterrecruiter code based on origin of student
reghas student registered (Y/N)
regactregistration action (add, drop, change, new)
regact_dtdate of registration action
regb4julydid student register before July 1
regiongeographic region where school of origin located
reg_censusY/N - student was registered at census
reg_dtdate student first self-registered for particular term
reg_ERSSY/N field if reported in ERSS
reg_everY/N - student registered for classes for this semester (but maybe not at census)
reg_nextcensusY/N - student was enrolled at census next semester
reg_nowcurrently registered (perhaps EE)
reinstated_timesnumber of times a student has been reinstated after being disqualified as an undergraduate
relationrelationship to student
remedialcourse is remedial (Y/N)
remed_fallremedial units passed last Fall term
remed_fall_classesremedial classes passed last Fall
remed_passedremedial units passed this term
remed_springremedial units passed last Spring term
remed_spring_classesremedial classes passed last Spring
remed_summerremedial units passed last Summer term
remed_termremedial units attempted this term
requireESPstudent was required to enroll in Early Start Program
req_termdegree requirement term
rescode. . .
resfeeCalifornia resident for fee purposes (includes WUE, AB540, NSE, and some international exchan. . .
residencyresidence status (R, N, F, X, WUE, AB540)
resid_coderesidency code from ERS files
resid_statresidency status from ERS file (R,M,S,T,O,F)
res_statestate of residency from the ERSS file
returnHobsons' field
royall_idRoyall ID
rule12NCAA ineligible because of Rule of 12/24
rule6NCAA ineligible because of Rule of 6
rule75NCAA ineligible because of Rule 75/25
SATtotal of highest SAT math and verbal scores
SATeligSAT eligibility index
SATmathhighest SAT math score
SATverbhighest SAT verbal score
SATwritehighest SAT writing score
SAT_mathhighest SAT math score
SAT_math_factorgrouped SAT math scores
SAT_totalSAT math + SAT verbal (1600 max)
SAT_verbalhighest SAT verbal score
SAT_verb_factorgrouped SAT verbal scores
SAT_writSAT writing score
schol_aidtotal amount of scholarships disbursed
schol_cancelamount of financial aid scholarship offers that were cancelled
schol_offertotal amount of Scholarships offered
schoolname of school where student previously attended
schoolcodestudent tracker school code
SDRCstudent is being served by the Student Disability Resource Center
search_dtyyyymmdd - the date used for clearinghouse searches
sectionsection # associated with a particular CN
sectitlesection title
selfQualprospect qualification scores (Q0=not interested, Q4=very interested)
selfregdid this student register themselves (as opposed to the registrar doing it)?
semBiolsemesters of HS biology
semElecsemesters of HS electives
semEnglsemesters of HS English
semesterFall, Spring, Summer
semForLsemesters of HS foreign language
semLabsemesters of HS lab science (physical science + biology)
semMathsemesters of HS math
semPhyssemesters of HS physical science
semSScisemesters of HS social science
semVPAsemesters of HS visual and performing arts
servenegnegative service indicators (semi-colon delimited)
servepospositive service indicators (semi-colon delimited)
servicecode of service provided
service_dtdate of service
service_indicatortilde delimited list of A&R service indicator/reason for Hobsons
service_namedescription of service provided
service_reasoncomma separated list of service indicator reasons for a student
sessorientation session
sexM/F
sex_crmgender for Hobsons official use
sfcodesstudy field codes associated with this degree (comma separated list)
sortnamediploma name as last suffix, first middle
sortorderfield which can be used to sort the output on several fields at once
source_codeSource Code for Hobsons CRM (similar to legacy contact category)
specialspecial requests
sportsport code
sport1a student's primary sport
sportscomma-separated list of sport codes
sport_aidthe NCAA sport group for which a student is receiving athletic aid
springgradehigh school spring grade
SSNSocial Security # with hyphens (123-45-6789)
SSN29 character SSN. SSN without hyphens
SSNxlast 4 digits of Social Security # (xxx-xx-1234)
Staffordstudent received a federal subsidized Stafford loan
start_dtstart of HOP session
statstatus of student fee
statemailing address
state_aidamount of state financial aid disbursed
state_crmstate for Hobsons official use
state_fixedstate of mailing address from Hobsons user
state_free_aidamount of "free" (grants and scholarships) state aid disbursed
statustext description of the status of this student
statusappapplication status (01inq,02not,03app,04w,05c,06d,07ad,08nc,09wd,10int,11hop,12reg)
statusstustudent status (1-IE 2-WD 3-LV 4-EL 5-AD 6-CA 7-RE)
street1mailing address
street2mailing address
studentname of student associated with HOP guest
student_grouptilde-delimited list of Hobsons-related student groups
study_fieldstudy_field (base major)
study_field_after1Study Field after first year
stugroupstudent group code
stugroupsstudent groups (comma-delimited)
stugroups2list of student groups that includes DSS
stulev. . .
stulevelclass level or postbac category (1-Frosh,2-Soph...6-Masters, 7-Credential, 8-2nd BA, 9-Other . . .
stuservicescounts of services provided by term
stustatus. . .
stutypestudent type: 1)continuing 2)returning 3)transfer 4)new 5)transitory
stutypeletstudent type letter: F=first-time UG, T=transfer UG, R=ret UG, P=Cont/Ret PBac, B=New PBac, N. . .
subjCourse or Class subject code
subjecthigh school subject
suffixsuffix of student's name (II, III, IV, Jr., etc.)
SUGY if received a State University Grant
sumBridgestudent is in the summer bridge student group
summer2gradehigh school summer grade
summergradehigh school summr 2 grade
termcodeCS 4-digit termcode
termdescriptcode:semester YYYY (e.g. 2084:Fall 2008)
termnamethe term name without the preceeding term code (e.g. Fall 2008)
terms_offterms off between a term and the previously enrolled term
term_admit. . .
term_appCMS term code from application
term_coursethe term a course was taken
term_erss. . .
term_finallast term a student attended as a regular student
term_firstfirst term a student was active in a student group
term_lastlast term a student was active in a student group
testtest code (e.g. SAT, ACT)
testingchecking to see whether hidden works
testpartpart of test taken (e.g. VERB, MATH)
testscorehighest score ever received on this test
test_dtdate test was taken
thesisthesis title
timetime of service
titlecourse title
title25course title limited to length of 25
TOEFLTOEFL score
to_dtdate student expects to complete attending another school
transcript_termlast term completed on most recent transcript for another school
transfer_toSchool a student transferred to after HSU
transfer_to_typetype of school a student transferred to (2Yr or 4Yr)
tribeAmerican Indian tribal affiliation
udY/N - upper-division transfer applicant (junior or senior)
udivderived from adbas
UDregregistered for an upper division course
unitsnumber of non-audit units a student is enrolled in
unitsallall non-ee units enrolled at census at a given career
units_auditunits audited
units_completedtotal (semester) units completed when transfer application submitted
units_EEExtended Education units
units_ERSSnumber of units reported in ERSS
units_fallenrolled units at census last Fall semester
units_springenrolled units at census last Spring semester
unmetamount of unmet financial aid need
unmet_lastunmet need last aid year
upwardis this applicant in Upward Bound?
URMunder-represented minority (Y=AmInd,Black,Hispanic,PacIsl N=White,Asian blank=unknown)
URM_ERSSunder-represented minority in ERSS (Y=AmInd,Black,Hispanic,PacIsl N=White,Asian blank=unknown)
userIDuser providing service
usernameoncampus email address (without the @humboldt.edu); example: abc1
verifyinteger verifier code that's a repeatable hash of emplid and name for use in Web response URL. . .
vetY/N/missing - veteran from the CSU application
vetd. . .
veteranstudent is in the VET student group
vetgroupshow VET or VETD student group
vet_appthe veteran box was checked on the CSU application
vet_certifiedveteran certified units - reference from VET service indicator
vet_chapterreason code from service indicator
vet_serviceVET service indicator
visaforeign visa type
visitcampus visit? (Y/N)
waitlistslist of waitlisted courses
WC_courseGE English composition course
WC_gradeGE English composition course grade
WC_instGE English composition course institution
WC_termGE English composition course term
WC_unitsGE English composition course semester units
weekThe week number into a semester
weekdayday of the week (1-SUN, 2-MON, . . . , 7-SAT)
wheelchairwill be using a wheelchair
withdraw_dtdate of last withdrawal from unit-bearing non-EE
withdraw_dt_EEdate of last withdrawal from unit-bearing EE
withdraw_fallapproved withdrawal last Fall semester
withdraw_springapproved withdrawal last Spring semester
work_aidtotal amount of work study disbursed
work_cancelamount of work study cancelled
work_offeramount of work study offered
WUEY if paying WUE fees
WUE_addressis the address in a WUE state? (Y/N)
WUE_prospectis the application actually under the WUE program? (Y/N)
xferY or N if student is a transfer student
XFERcohortY if in transfer cohort (enrolled, not EE)
xfer_earnedtransfer units earned
xfer_GPAtransfer GPA
xpadIs there an XPAD action in the stack for a given app (Y/N)
yearfour-digit year
yearbeforefour-digit for last year
yearendlast day of spring classes (desired by housing)
year_termyear_term for calpass
zipmailing address
zip_fixedzip code from Hobsons user