FLORIDA STATE UNIVERSITY
schema file in site.data.schemata.student_schema
for the data records in site.data.allstudents
Categories: academic, admin, admissions, deprecated, derived, personal, postgrad
Data Types: .Options, blocktext, boolean, collection, date, integer, real, seconds, term (term code), text, timestamp, years
| Name | Key | Category | Value Type | Source | Required | Note |
|---|---|---|---|---|---|---|
| Mongo ID | _id | mongo | text | mongo, READONLY | no | the id of the record in the mongodb |
| Record Created | _created | mongo | date | mongo, derived | yes | |
| Last Updated | _updated | mongo | date | mongo, derived | yes | |
| First Name | first_name | admin | text | admin, student | yes | |
| Last Name | last_name | admin | text | admin, student | yes | |
| Degrees Held | degrees_held | personal | text | admin,student | degrees awarded by FSU or already possessed by student, so they can be displayed next to name | |
| Full Name (FSU) | full_name | admin | text | GST,READONLY | yes | |
| emplid | emplid | admin | integer | application | yes | only students from ~2003 onward have real emplids |
| fsuid | fsuid | admin | text | GST | yes | only students from ~2003 onward have fsuids |
| Name (for display) | name | admin | text | admin, student | yes | generate this in eve or by jedi_auto, derived (refactor_plans.js) |
| admin | admin, student | yes | ||||
| Campus Email | campus_email | admin | GST,READONLY | no | ||
| Preferred Email | preferred_email | admin | GST,READONLY | no | ||
| Image URL | image_url | admin | url | admin, student | optional | |
| ID Card Image URL | idcard_image_url | admin | url | GST,READONLY | optional | |
| mdb_admit_term | mdb_admit_term | internal | term | admin | no | a backup field in case of conflict between gst and mongodb |
| mdb_last_term | mdb_last_term | internal | term | admin | no | a backup field in case of conflict between gst and mongodb |
| Terms | terms | internal | map | internal | yes | list of support and status for each term |
| Academic Plans | academic_plans | internal | map | internal | yes | list of academic plans; each academic plan contains data for info and requirement fields specified in academic_plan_code.yaml |
| Awards | awards | deprecated | array | internal | no | original version array of awards received, never used |
| Teaching | teaching | deprecated | array | internal | no | original version array of courses taught for teaching requirement, never used |
| Seminars | seminars | deprecated | array | internal | no | original version array of seminars given for seminar requirement, never used |
| Rotations | rotations | deprecated | array | internal | no | original version array of rotations for rotations requirement, never used |
| Annual Reviews | annual_reviews | deprecated | array | internal | no | original version array of annual review dates, never used |
| Courses Taken | courses_taken | deprecated | array | internal | no | original version array of courses taken (ie transcript), never used |
| alternate fsuid | alternate_fsuid | admin | text | admin | no | some students have two fsuids! especially if employee before becoming student |
| fsusn | fsusn | admin | integer | GST | students prior to sometime in early 2000's have actual SSNs, which are NOT stored in gradphile | |
| Residency Code | residency_code | admin | univ.residencyCodeOptions | GST,READONLY | yes | see _data/univ/residencyValues.json for possible values |
| Visa Permit Type | visa_permit_type | admin | string | GST,READONLY | ||
| deprecated Current Academic Plan | current_academic_plan_code | deprecated | dept.planCodeOptions | admin | yes if last_term == null | superseded by academic_plan_code; used to be current_plan_code; can be null or undefined if not currently enrolled |
| Last Updated from GST | last_updated_from_gst_date | admin | date | jedi_auto, derived | ||
| Last Updated from Jedi | last_updated_date | admin | ECMA-262 date | jedi_auto, derived | generated by jedi when change uploaded to mongo, so uses javascript Date.toString() -> eg Tue Aug 19 1975 23:15:30 GMT+0200 | |
| Area | area | admin | dept.areaCodeOptions | admin | yes | |
| Current Academic Plan | academic_plan_code | admin | dept.planCodeOptions | admin | yes if last_term == null | current academic plan code; can be null or undefined if not currently enrolled; TODO: will be made into an array of currently active plan codes... |
| Current GST Track ID | gst_track_id | admin | integer | GST,READONLY | current gst track id; TODO: will be made into an array of currently active gst tracks... | |
| Comment | _comment | admin | text | admin | no | |
| GRE_quantitative_prior_to_8_11 | GRE_quantitative_prior_to_8_11 | deprecated | integer | application | ||
| GRE_verbal_prior_to_8_11 | GRE_verbal_prior_to_8_11 | deprecated | integer | application | ||
| GRE_quantitative | GRE_quantitative | admissions | integer | GST,READONLY | yes | |
| GRE_verbal | GRE_verbal | admissions | integer | GST,READONLY | yes | |
| GRE_analytical | GRE_analytical | admissions | integer | GST,READONLY | ||
| GRE_writing | GRE_writing | admissions | integer | GST,READONLY | ||
| admit_term | admit_term | admissions | term | GST, admin | yes | |
| application_id | application_id | admissions | integer | application | ||
| initial_plan_code | initial_plan_code | admissions | dept.planCodeOptions | admin | yes | |
| initial_advisor | initial_advisor | admissions | text | admin | yes | |
| name_in_application | name_in_application | admissions | text | application | ||
| residency_in_application | residency_in_application | admissions | univ.residencyCodeOptions | application | yes | |
| toefl | toefl | admissions | integer | GST,READONLY | optional if from non-English speaking country | |
| toefl_speak | toefl_speak | admissions | integer | GST,READONLY | optional if from non-English speaking country | |
| ielts | ielts | admissions | integer | GST,READONLY | optional if from non-English speaking country | |
| ielts_speak | ielts_speak | admissions | integer | GST,READONLY | optional if from non-English speaking country | |
| undergrad_college | undergrad_college | admissions | text | application | ||
| undergrad_country | undergrad_country | admissions | text | application | ||
| undergrad_code | undergrad_code | admissions | text | application | ||
| undergrad_upperdiv_gpa | undergrad_upperdiv_gpa | admissions | real | application | ||
| grad_college | grad_college | admissions | text | application | ||
| grad_country | grad_country | admissions | text | application | ||
| grad_code | grad_code | admissions | text | application | ||
| grad_gpa | grad_gpa | admissions | real | application | ||
| research_experience | research_experience | admissions | fp_year | application | number of years in full-time research, e.g. technician or graduate program (not undergrad credit) prior to admission | |
| Current Academic Program | academic_program_code | deprecated | text | admin | true | current academic program code; can be null or undefined if not currently enrolled |
| Anticipated Graduation | anticipated_graduation_term | academic | term | admin | ||
| Program | program | academic | text | admin | true | |
| Department | department | academic | text | admin | true | |
| Cumulative GPA | cumulative_gpa | academic | real | GST, admin, student central | ||
| RCR Online Training | rcr_online_date | academic | date | admin | ||
| Academic Plans | academic_plans | academic | collection | admin | true | |
| Terms with Support | terms | academic | collection | admin | true | terms have degree, end_of_term_status, standing, status, supervisor, support |
| Committee Meetings | committee_meetings | academic | collection | admin | ||
| Sex | sex | personal | text | GST, admin, student | yes | |
| Disability | disability | personal | text | admin, student | yes | enter type of disability if known otherwise just yes or no |
| Veteran | veteran | personal | text | admin, student | yes | veteran status yes or no |
| Ethnicity | ethnicity | personal | const.ethnicityCodeOptions | GST,READONLY | yes | |
| Country of Birth | country | personal | text | GST,READONLY | yes if not citizen? | country of birth; if non-citizen, assumed to be citizenship country as well; iso3code from GST |
| Date of Birth | date_of_birth | personal | date | GST, application,READONLY | yes | |
| Cell Phone | phone | personal | text | admin, student | ||
| Home Address | home | personal | text | admin, student | ||
| Official Address | address | personal | text | GST,READONLY | has to be compiled from MAIL_ADDRESS1, MAIL_ADDRESS2, MAIL_CITY, MAIL_STATE, MAIL_POSTAL | |
| Fax Number | fax | deprecated | text | admin, student | ||
| Office Location | office | personal | text | admin, student | ||
| Lab Location | lab | personal | text | admin, student | ||
| Lab Phone | lab_phone | personal | text | admin, student | ||
| ORCID | orcid | personal | text | student | ||
| Personal URL | personal_url | personal | text | admin, student | ||
| Blurb | blurb | personal | blocktext | admin, student | ||
| Last Term | last_term | postgrad | term | GST, admin | ||
| Postgrad Outcome | outcome | postgrad | dept.degreeOutcomeOptions | admin | ||
| Outcome Comment | outcome_comment | postgrad | text | GST,admin,READONLY | ||
| MD_Outcome Comment | md_outcome_comment | postgrad | text | admin | no | a backup field in case of conflict between gst and mongodb |
| Initial Postgrad Position | initial_postgrad_position | postgrad | text | admin, student | ||
| Initial Postgrad Location | initial_postgrad_location | postgrad | text | admin, student | ||
| Initial Postgrad Position Type | initial_position_type | postgrad | const.postgradPositionOptions | admin, student | ||
| Current Position | current_postgrad_position | postgrad | text | admin, student | ||
| Current Location | current_postgrad_location | postgrad | text | admin, student | ||
| Current Position Type | current_position_type | postgrad | const.postgradPositionOptions | admin, student | ||
| current_position_updated | current_position_updated | postgrad | date | admin, student | ||
| current_address | current_address | postgrad | text | admin, student | ||
| current_comment | current_comment | postgrad | text | admin, student | ||
| current_email | current_email | postgrad | admin, student | |||
| current_phone | current_phone | postgrad | text | admin, student | ||
| current_url | current_url | postgrad | url | admin, student | ||
| age | age | derived | fp_year | jedi_auto, derived | time in years since date_of_birth | |
| time_now | time_now | derived | timestamp | jedi_auto, derived | time when refactor_plans was last run on mongodb download | |
| time_entered | time_entered | derived | timestamp | jedi_auto, derived | time at start of the first term entered | |
| term_entered | term_entered | derived | term | jedi_auto, derived | term is 1, 6, or 9 | |
| academic_year_entered | academic_year_entered | derived | yyyy | jedi_auto, derived | yyyy (of fall term of academic year) | |
| academic_year_entered_label | academic_year_entered_label | derived | text | jedi_auto, derived | yy zero padded last two digits | |
| academic_year_left | academic_year_left | derived | yyyy | jedi_auto, derived | yyyy (of fall term of academic year) | |
| academic_year_left_label | academic_year_left_label | derived | text | jedi_auto, derived | yy zero padded last two digits | |
| time_line_start | time_line_start | derived | timestamp | jedi_auto, derived | ||
| time_left | time_left | derived | timestamp | jedi_auto, derived | seconds (unix timestamp) at end of student.last_term (so includes duration of the last term) | |
| time_in_program | time_in_program | derived | seconds | jedi_auto, derived | seconds; either (time_now - time_entered), or (time_left - time_entered) if finished | |
| academic_time_in_program | academic_time_in_program | derived | seconds | jedi_auto, derived | seconds since time_line_start | |
| years_in_program | years_in_program | derived | fp_year | jedi_auto, derived | years since started first plan; real value, i.e. 0.5 (so in year 1), 1.3 (rounded to tenth of year) | |
| program_year | program_year | derived | int_year | jedi_auto, derived | integer value, i.e year 1 at 0.5 years in program for first year student | |
| years_in_plan | years_in_plan | derived | fp_year | jedi_auto, derived | years since started current plan; real value, for sorting by time in current plan | |
| underrepresented_ethnicity | underrepresented_ethnicity | derived | boolean | jedi_auto, derived | derived from ethnicity if AMIND, HISPA, BLACK, or MULTIPLE regardless of residency | |
| minority | minority | derived | boolean | jedi_auto, derived | derived from underrepresented_ethnicity and citizenship - if AMIND, HISPA,PACIF, BLACK, or MULTIPLE and residency == usa | |
| minority_noncitizen | minority_noncitizen | derived | boolean | jedi_auto, derived | derived from underrepresented_ethnicity and citizenship - if AMIND, HISPA,PACIF. BLACK, or MULTIPLE and residency != usa | |
| citizenship | citizenship | derived | text | jedi_auto, derived | iso3code derived from residency_code and country (of birth) | |
| residency | residency | derived | text | jedi_auto, derived | [ usa, intl] determine from residency_code if usa resident (FLRS or NFLR), otherwise intl ; | |
| lac | lac | derived | text | jedi_auto, derived | [null , lac] lac if residency == intl and country is a lac country | |
| usa_or_lac | usa_or_lac | derived | boolean | jedi_auto, derived | determine from residency_code and citizenship if US citizen or LAC (Latin American Carribean) citizen | |
| in_state_tuition_rate | in_state_tuition_rate | derived | boolean | jedi_auto, derived | true if student eligible for in-state tuition (i.e. is in-state resident FLRS or LAC) |