ODD fields - Data Dictionary for On-Demand-Datasets
oddfield report generated: 23-MAY-18
NAME
DESCRIPTION
Anumber of A grades
a2g_a_ssciyears of high school social science passed
a2g_b_englyears of high school English passed
a2g_completeA to G requirements complete (excluding G)
a2g_c_mathyears of high school Math passed
a2g_d_labyears of high school lab science completed
a2g_e_forlyears of high school foreign language completed
a2g_f_vpayears of high school visual and performing arts completed
a2g_g_elecyears of high school electives completed
abroadY if student has a study country in place for that term
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
acadyearthe academic year (ex: 2015 is the acayear for Summer 15, Fall 15, and Spring 16
acad_deptIndicates Y or N if code is an academic department
acad_orgacademic organization
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_standing_eotacademic standing at the eod-of-term (after grades)
acad_yearacademic year (yyyy) [matches Fall semester]
acad_year_nameYYYY-YY (example 2015-16)
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_grantgrant amount accepted
accept_loanloan amount accepted
accept_scholscholarship amount accepted
accept_workwork-study amount accepted
accountfiscal account
accstataccommodation status code (see ERS manual)
acstandacademic standing (GOOD, PROB, REIN, DISQ, or blank if a new student)
acstand_EOTacademic standing at end of term (GOOD, PROB, REIN, DISQ)
acstand_eot_descdescription of academic standing code (end-of-term)
acstand_EOYacademic standing at end of year (GOOD, PROB, REIN, DISQ)
acstand_fallacademic standing after last Fall semester
acstand_finala student's current or final academic standing
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
action_reasonaction reason code from the jobs table
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
adbas_otherother admission basis (not regular or exception)
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
add_dtdate that a couse 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
adultY if a person is over 18 years old
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.
aftercensusY if a census has passed for a particular term
afterstartY if the start of term has passed for a particular term
ageage of student
age_censusage of student on census date of a particular term
age_monthsthe number of months a person has lived
AGIadjusted gross income
agi_factoradjusted gross income, broken into range groups
agonumber of years in the past that a term occurred
aidY if a student received financial aid
aidsportthe sport associated with an athletic scholarship
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]
apptype_erssapplication type from the ERSS table
app_daysagointeger reflecting how many days ago is the app_dt
app_dtapplication date
app_monthmonths between the application start date and when this student applied (0-10)
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
atheverY/N was this student ever an athlete
athgrad_in_6grad_in_6 from a final ERSS term perspective (not cohort based)
athletestudent is playing on a University sports team
athlete_faappears to be an athlete from financial aid perspective
athlete_finaidappears to be an athlete from financial aid perspective
athstatuscurrent athletic partipation status
autoevalwas the application processed by auto-eval process (Y/N)
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
belowCY if grade less than C
belowcminusY if grade less than C- (D, F, NC, WU)
belowDY if grade 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_finaidtype of financial aid received code
calpass_foster_youthfoster youth, orphan, and ward of the court code
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
CAS_IDCal Apply on-line application identifier
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
classacademic level:class name (e.g. 20:Sophomore)
classeslist of registered classes
classlev1-Frosh, 2-Soph, 3-Junior, 4-Senior, 5-Senior (120+ earned)
classno1-5 from classlev
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.
cleanphonecleaned up phone number (digits only)
cleanpphonecleaned up permanent phone number (digits only)
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
cohortgradSTUID of student included in a graduation cohort - e.g. FTUG who began more than 6 years ago
cohortontimeSTUID if FTUG began more than 4 years ago, LDIV more than 3 years ago, UDIV more than 2 years ago
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
collegename of college 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
colN14th column in GSR report (incorrectly defined as Non-graduate or Left Ineligible)
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
confirm_dtdate an applicant confirmed their intent to enroll
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
dars_planYes/No student has primary DARS Plan and number of future terms
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
denyeverapplication was denied at least once
deny_admitDN service indicator exists (denied after being admitted)
deny_dtdate of a deny decision on an application
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
depcodeslist of department codes that student's majors are in
depcode_classdepartment code of acad org in class table
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
dormon-campus residence: hall, building, floor
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_classunits earned in a class
earned_fallunits earned toward degree last Fall semester
earned_finaltotal units earned
earned_first_fallunits earned during a student's first Fall semester
earned_first_springunits earned during a student's first Spring semester
earned_getotal units earned in GEAR classes
earned_GEARGEAR units earned at the end of this term
earned_GEAR_n1stotal GEAR units earned at the end of next semester
earned_HSUunits earned at HSU toward degree
earned_hsu_n1stotal units earned at HSU at end of the following semester
earned_majormajor units earned this term
earned_major_n1stotal Major units earned at end of the following semester
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_adjunits earned this term after repeats are taken into account
earned_term_factorgrouped units earned this term
earned_term_origunits earned this term before repeats are considered
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)
endtimetime class lets out
end_dtend of HOP session
end_dt01date meeting #1 for a class ends
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
enrolled_erssreported in ERSS this term
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
facid5-letter anonymous generated ID for faculty
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
firstattendfirst generation to attend college
firstattend_person0first generation to attend college
firstgenfirst generation student: neither parent graduated from a 4-year college
firstgen_gifirst generation student GI2025 Definition: 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_prefpreferred first name
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)
GEARY if a class meets a GEAR requirement
gear_attrGEAR attributes connected to a class
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 through a particular term
gpa2overall GPA during a particular term, not including the current term
gpaincludeY if course was graded and not repeated
gpaunits_classadjusted units taken for grade (excludes repeats)
gpa_1soverall GPA at the end of the following semester
gpa_1toverall GPA at the end of the following term (includes summer)
gpa_2soverall GPA at the end of the subsequent year (2 semesters later)
gpa_2toverall GPA at the end of 2 terms (including summers) after this one
gpa_3soverall GPA at the end of 3 semesters (not including summers) after this one
gpa_3toverall GPA at the end of 3 terms (including summers) after this one
gpa_4toverall GPA at the end of 4 terms (including summers) after this one
gpa_5toverall GPA at the end of 5 terms (including summers) after this one
GPA_after_springGPA after the following Spring semester
gpa_darsGPA from DARS
gpa_enr_studentHSU GPA calculated from student history
gpa_eotoverall GPA for courses taken at end of term
gpa_erssGPA at census (from ERSS file) for a particular term
GPA_fallGPA earned last Fall semester
GPA_finalstudent's final GPA
gpa_gearGPA is GEAR classes taken at HSU
GPA_gear_n1sGPA earned in GEAR courses at the end of next semester
GPA_HSGPA from high school
GPA_HSUoverall GPA for classes taken at HSU
gpa_hsu_1sHSU GPA at the end of the following semester (fall or spring)
gpa_hsu_1s_rollcalculated HSU GPA at the end of the following semester
gpa_hsu_1tHSU GPA at the end of the following term (includes summer)
gpa_hsu_2sHSU GPA at the end of the subsequent year (2 semesters later)
gpa_hsu_2tHSU GPA at the end of 2 terms (including summers) after this one
gpa_hsu_3sHSU GPA at the end of 3 semesters (not including summers) after this one
gpa_hsu_3tHSU GPA at the end of 3 terms (including summers) after this one
gpa_hsu_4tHSU GPA at the end of 4 terms (including summers) after this one
gpa_hsu_5tHSU GPA at the end of 5 terms (including summers) after this one
gpa_hsu_enr_studentHSU GPA calculated from student history
gpa_hsu_eotoverall GPA for classes taken at HSU at end of term
gpa_hsu_erssHSU GPA at census (from ERSS file)
gpa_hsu_finalthe final or current HSU GPA for a student
gpa_hsu_major_n1sestimated GPA in major classes one semester after the current one
GPA_HSU_n1sGPA for courses taken at HSU during at then end of the following semester
gpa_hs_appself-reported high school GPA from student's application
GPA_HS_factorgrouped high school GPAs
GPA_last_termGPA at the end of student's last term of attendance
gpa_majorestimated GPA in major courses taken at HSU
GPA_major_n1sGPA earned in major courses at the end of the next semester
gpa_priortransfer or high school GPA
gpa_remedGPA for remedial coursework
GPA_springGPA earned last Spring semester
GPA_summerGPA earned last Summer semester
GPA_termoriginal GPA for classes taken this term at HSU (not including repeat corrections)
gpa_term_1toriginal term GPA for following term (including summers)
gpa_term_2toriginal term GPA for term after next (including summers)
gpa_term_3toriginal term GPA for 3 terms in the future (including summers)
gpa_term_4toriginal term GPA for 4 terms in the future (including summers)
gpa_term_5toriginal term GPA for 5 terms in the future (including summers)
gpa_term_adjadjusted GPA for this term (after repeats)
GPA_term_factorgrouped term GPAs
gpa_term_gearoriginal term GPA in GEAR courses
GPA_term_majorestimated term GPA in major courses
gpa_term_p1tterm GPA at HSU in prior term (including summer)
gpa_term_p2tterm GPA at HSU in term before previous one (including summer)
gpa_term_precolterm GPA in precollegiate courses
GPA_unitsunits taken the term that are counted in the GPA (excludes CR/NC and remedial)
gpa_units_adjadjusted units taken for grade (excludes repeats)
gpa_units_geartotal GEAR units taken for a grade
gpa_units_majorestimated total major units taken for a grade
gpa_units_precoltotal precollegiate units taken for a grade
gpa_units_termterm units taken for a grade
gpa_units_term_gearGEAR units taken this term for a grade
gpa_units_term_majorestimated major units taken this term for a grade
GPA_xferGPA transferred from other schools
gpa_xfer_apptransfer GPA from application
gradgrad flag for Hobsons' upload; in dm_gps, Y if student graduated in 6/5/4 years
gradegrade a student received in a course
gradeletcourse grade with the + or - removed
gradelet2grades with + and - removed except for C-
gradelevhigh school grade level
grade_requiredgrade required to pass the class (either CR of C-)
grade_SIgrade received in supplemental instruction
gradIDSTUID if a FTUG/LD/UD student graduated in 6/5/4 years
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.)
gradontimeY/N - student graduated in 4 years for FTUG, 3 years for LD transfer, or 2 years for UD transfer
gradprobprobability that a student will graduate
gradstatgraduation status
gradtermexpected or actual graduation term
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_else1/0 4-year (or higher) degree after leaving HSU (cohort based)
grad_elsewhereY/N 4-year (or higher) degree after leaving HSU
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 a student received a degree
grant_aidtotal amount of grant aid disbursed
grant_cancelamount of financial aid grant offers that were cancelled
grant_offertotal amount of Grants offered
GSRresultFinal: G=grad, L=Left Eligible, X=exclusion, E=nonGrad or left ineligible
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_belowc1 if a student's grade was below a C
hc_belowcminus1 if a student's grade was below a C-
hc_firstattendHeadcount of first generation to attend college
hc_ftugfirst-time undergraduate headcount: 1 if FTUG
hc_gradgraduation headcount: 1 if student graduated, 0 if not, blank if not enough time to know
hc_gradontime1 if student graduated in 4 years for FTUG, 3 years for LD transfer, or 2 years for UD transfer
hc_grad_elsewhere1 if student graduated from another university
hc_nscgrad41 if an undergrad received their degree from anywhere in 4 years (clearinghouse data)
hc_nscgrad61 if an undergrad received their degree from anywhere in 6 years (clearinghouse data)
hc_regregistered headcount - 1 if enrolled in classes, 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
hoursinteger number of hours a class meets, usually 1, 2, or 3 (rounds up)
housinghousing_dep
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)
HSUY if a course was taken at HSU; N if a transfer course
HSU_IDHSU ID (aka EMPLID) with a hyphen
HS_GPAhigh school GPA
icontactinitial contact code
IDstudent ID (aka EMPLID)
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
KCKlamath Connection (student group)
keyodd view key
kfactork factor: 0-6 or null, used to calculate WTU
KTHKlamath Themed Housing (student group)
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_prefpreferred last name
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_app_firstoriginal majcodes from application
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_finalfirst major in final ERSS term
major_pathEO1110 definition of STEM/Math dependent majors
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
middle_prefpreferred middle names
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
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)
MQcatmath/quantitative reasoning placement category
MQstatmath/quantitative reasoning status (aka ELMstat)
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
needPhotois an ID photo needed? (Y/N)
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)
ontimeidSTUID if a FTUG/LD/UD student graduated in 4/3/2 years
on_lineHYBRID/ONLINE or blank
optionsmajor codes connected to a particular study field
orientationstudent has signed up for HOP, HOOP, or summer bridge
orient_sessionorientation session name in which applicant is registered
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
origin_zipzip code of school of origin
orig_codeschool of origin code
orphanorphan - ward of the court
other_last_namesother last names
outcomefinal outcome for a student
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
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_awardamount of PELL award
pell_eligstudent is eligible for a PELL grant
PELL_eligibleeligible for PELL grant (low-income)
persistregistered at census of the next term
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 (A=4, B=3, etc)
points_classgrade points earned in a class
points_class_adjgrade points earned after considering repeats
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
probadmitprobationary admit
programCS program (Banner level and degree) or name of primary major program
programnoprogram number from application
progStatusprogram status (active, discontinued, leave of absense)
prog_actionprogram action code
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
REA_dtRSVP date with intent to attend an admission reception
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
REC_cityadmission reception city
REC_dtdate attended an admission reception
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
repeat_codecode assigned to class that was repeated later (E=exclude from earned/GPA)
requireESPstudent was required to enroll in Early Start Program
req_termdegree requirement term
rescoderesidence status code (R, N, F, X, WUE, AB540)
resfeeCalifornia resident for fee purposes (includes WUE, AB540, NSE, and some international exchan. . .
residencyresidence status (for fee purposes)
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_verbhighest SAT verbal score
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
sportsevercomma-separated list of sport codes a student ever participated in
sports_apcspecial NCAA sport code for Athletic Performance Census
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_agreementstudy abroad agreement code
study_countrycountry code for study abroad
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
stuid5-letter anonymous generated id for a student
stulevelclass level or postbac category (1-Frosh,2-Soph...6-Masters, 7-Credential, 8-2nd BA, 9-Other . . .
stuservicescounts of services provided by term
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
termActivatedis the app term activated in CS? (Y/N)
termcodeCS 4-digit termcode
termdescriptcode:semester YYYY (e.g. 2084:Fall 2008)
termnamethe term name without the preceeding term code (e.g. Fall 2008)
termnoa 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_offterms off between a term and the previously enrolled term
term_admitterm a student was originally admitted to HSU
term_appCMS term code from application
term_coursethe term a course was taken
term_finallast term a student attended as a regular student
term_firstfirst term a student was active in a student group
term_gradterm a student graduated (or plans to graduate)
term_in_schoolterm number in school based on count of terms > 0 from admit term
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?
URGunder-represented group (Y=AmInd,Black,Hispanic,PacIsl N=White,Asian blank=unknown)
URG_ERSSunder-represented group 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
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
WCcatwritten communication placement category
WCstatwritten communication status (used to be EPTstat)
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 began as a transfer student
XFERcohortY if in transfer cohort (enrolled, not EE)
xfer_earnedtransfer units earned
xfer_GPAtransfer GPA
xlcntcount of classes cross-listed to this one, 1 or more
xlistminimum CN cross-listed to this course
xpadIs there an XPAD action in the stack for a given app (Y/N)
xtitleTitle of transfer course work
yearfour-digit year
yearbeforefour-digit for last year
yearendlast day of spring classes (desired by housing)
year_termyear_term for calpass
yyyy4-digit year
zipmailing address
zip_fixedzip code from Hobsons user