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