REVISED student tracker database form

81528301

OED Student Tracker

Database Design v2.4

Table: Login User	Example Values
UserID
LoginName	jdoe
Password	password
Name – full name	Jane Doe
LoginType – 5 types	CSC Partner User
ProgramID	NOAA Center for Atmospheric Sciences & Meteorology
Role – admin/standard	Standard
InstitutionID	Pennsylvania State University (this is a partner institution ID)
Email	jdoe@pennstate.edu
Phone	555-234-1212
IsActive –bit	Yes
CreateDateTime	2017-08-22 11:34 am
LastLoginDateTime	2017-09-15 4:11 am

Table: OED Programs	Example Values
ProgramID
Name	NOAA Center for Atmospheric Sciences & Meteorology
IsActive	Yes
IsCSC	Yes

Table: Program Information	Example Values
ProgramInfoID
ProgramID	NOAA Center for Atmospheric Sciences & Meteorology
LeadInstitution	Howard University
AwardNumber	NA16SEC4810006
FundingYear	1, 2, 3, 4, or 5 (select one)
InstitutionMSIStatus	Yes
InstitutionMSIType	HBCU
AwardedYear	2016
AwardEndYear	2021
TotalDirectStudentSupport	$1,500,000
DirectStudentSupportProfDevelopment	$150,000

Table: CSC Additional Funding Information	Example Values
ProgramInfoID	( links to table: Program Information -> ProgramInfoID )
CSCContactName	Vernon Morris
StartDate	6/1/2017
EndDate	7/31/2017
Description	(text)
Amount	$30,000
NOAAContactName	Storm Watch
NOAAContactEmail	StormWatch@noaa.gov

TAB: Demographic
Table: Demographic – Example Values
StudentID
OriginalProgramID	NOAA Center for Atmospheric Sciences & Meteorology
IsActive	Yes
IsValid	No
LastName	Doe
FirstName	Jane
MiddleInitial	N
Suffix	-
OtherFirstName	-
OtherLastName	-
PermanentAddress1	1 Main Street
PermanentAddress2	c/o Mary Joe
PermanentCity	Jacksonville
PermanentStateCode	FL
PermanentState	Florida
PermanentZip	12345
PermanentCongDistrict	3
SchoolAddress1	1721 Orange Way
SchoolAddress2	-
SchoolCity	State College
SchoolStateCode	PA
SchoolState	Pennsylvania
SchoolZip	54332
SchoolCongDistrict	1
Citizenship	US Citizen
CitizenshipDocProof (birth certificate, etc.)	Birth Certificate
Hispanic (y, n, decline)	No
Race (black or African American, white, …)	Black or African American
Gender (m, f, o, decline)	F
BirthDate	2/5/1999
EmailSchool	jdoe@pennstate.edu
EmailPersonal	jdoe@gmail.com
WebLink1	http://somelink
WebLink2	http://somelink
Bio	Some bio text (1,200 characters with spaces)
ModifiedBy	John Doe
DateModified	1/25/2018

TAB: ACADEMIC
Table: Academic – Example Values
AcademicID
StudentID
ProgramID	NOAA Center for Atmospheric Sciences & Meteorology
ProgramInfoID
InstitutionID	Howard University
InstitutionMSIstatus	Yes
InstitutionMSIType	HBCU
StudentStatus	Active
StudentStatusDescription	Changed program
DegreeStartDate	9/1/2016
ExpectedGradDate	5/31/2020
ActualGradDate	5/19/2020
Degree	B.S.
GPA	3.2
Major	Physical Sciences - Chemistry
AreaOfConcentration	Analytical Chemistry
ResearchTitle	Biomarkers of lead poisoning
AcademicResearchAdvisor	Marc Williams
NOAAResearchMentor	Jane Wolf
PreviousInstitution	University of Maryland Baltimore County
DateOfTransfer	10/1/2016
CSCDevelopmentPlanCompleted	10/5/2016
CSCTypeCoreCompleted	9/27/2016
CSCSocialScienceCompleted	11/1/2016
CSCDataScienceCompleted	2/5/2017
CSCConductResearchTrainingCompleted	(blank means NOT COMPLETED and no date entered)
CSCUGradAcademicMentor	Helene Bart
GradAcademicMentorName	Belay Demoz
GradAcademicMentorInstitutionDepartment	(blank means NO DATA entered)
GradResearchNOAAMentorName	Vernon Morris
GradResearchNOAAMentorLineOffice	National Weather Service
GradResearchNOAAMentorDivisionUnit	National Hurricane Center
NERTONOAALineOffice	National Weather Service
NERTOLineOfficeLocation	? (full address or what?)
NERTOStartDate	11/4/2016
NERTOEndDate	4/1/2017
NERTOCSCAcademicAdvisor	Belay Demoz
NERTONOAAMentor	Vernon Morris
NERTONOAACo-Mentor	John Doe
NERTONOAAProjectTitle	Weather Forecast
NERTONOAAOutputs	<a selected value from a drop-down list Audrey supplies>
NERTONOAAOutcomes	<a selected value from a drop-down list Audrey supplies>
COHORTNumber	1, 2, 3, 4, 5 (select one)
COHORTStartDate	8/23/2017
COHORTEndDate	11/20/2017
COhORTExitReason (Graduated or No degree awarded)	<a selected value from a drop-down list Audrey supplies>
COHORTNextSteps	<a selected value from a drop-down list Audrey supplies>
ModifiedBy	OED Admin
DateModified	12/1/2017

TAB: FUNDING
Table: Student Funding	Example Values
FundingID
SudentID
AdditionalFundingID
NOAAAwardNumber	NA16SEC48100062016
Year	2016
DateFirstSupported	9/1/2016
Tuition	$4,000.00
Stipend	$500.00
Post-SecondaryStudent-Travel	$400.00
One-TimeAllocationGradResearch	$3,000.00
One-TimeSupportNERTO	$1,000.00
ProfessionalDevelopment	$1,500.00
ModifiedBy	OED Admin
DateModified	3/31/2016

TAB: FUNDING
Table: Additional Funding	Example Values
AdditionalFundingID
StudentID
NOAAAwardNumber	NA16SEC48100062016
ContactName	Vernon Morris
StartDate	6/1/2017
EndDate	7/31/2017
Description	(text)
Amount	$300.00
IsValid	No
SourceProgramID	EPP USP

TAB: PROFESSIONAL DEVELOPMENT
Table: Internship Training	Example Values
StudentID
AgencyOrganization	? (IS THERE A LIST?)
LineOffice	National Weather Service
Location	Washington, D.C.
NOAAMentor	Vernon Morris
NOAACo-Mentor	Vernon Morris
StartDate	4/20/2017
EndDate	5/12/2017
ProjectTitle	Some title
Outputs	<a selected value from a drop-down list Audrey supplies>
Outcomes	<a selected value from a drop-down list Audrey supplies>

TAB: PROFESSIONAL DEVELOPMENT
Table: Conferences	Example Values
StudentID
ConferenceTitle	4th International Conference on Physical and Theoretical Chemistry
Date	September 18-19, 2017 (input as text)
Location	Dublin, Ireland
PresentationTitle	Some title
PresentationType (Oral, Poster, Workshop)	Poster

TAB: PROFESSIONAL DEVELOPMENT
Table: CSC Professional Development
StudentID
Activity	(a paragraph)
Date	October 1-20, 2017 (input as text)
BudgetCategory (Travel, Stipend, etc.)	Travel

TAB: AWARD / PUBLICATIONS
Table: Awards	Example Values
StudentID
Title	Award title
Source	Award source name
Year	2017
Citation	Some text

TAB: AWARD / PUBLICATIONS
Table: Peer Reviewed Publications	Example Values
StudentID
Title	Half-Life and Decay Law of Actinide Elements
Type (journal, book, etc.)	Journal
JournalBookTitle	Chemical Sciences Journal
JournalFactor	2.9
Authors	Fazal-ur-Rehman M and Sana Akram
StudentFirstAuthor (y/n)	No
Volume	8
Issue	2
Edition	-
PublicationDate	6/12/2017
Pages	123-125
OnlineLink	https://www.omicsonline.org/open-access/antisense-cancer-therapy-do-antisense-oligonucleotides-hold-promiseas-a-cure-for-cancer-2150-3494-1000e117.php?aid=89518

TAB: AWARD / PUBLICATIONS
Table: Other Publications	Example Values
StudentID
Name	Dr. Jeff McCarthy* and Dr. Malcolm Thomas
Citation	McCarthy J, Thomas M (2017) International and National Principles and Area Based Local Application for Sustainable Coastal Development. J Coast Zone Manag 20: 445. doi: 10.4172/2473-3350.1000445

TAB: STUDENT EXIT
Table: Further Education	Example Values
StudentID
DegreeField	Environmental Studies (how is this different from Major below? Ask Todd)
DegreeLevel	M.S.
Institution	University of Maryland College Park
Major	Physical Sciences - Atmospheric Science & Meteorology
AreaOfConcentration	Natural Resource Management
StartDate	1/25/2017
EndDate	5/31/2018
DegreeCompletion (yes/no)	No
SourceOfSupport (name)	( text )
NOAASTEMRelated (y/n)	Yes
ModifiedBy	OED User
DateModified	8/30/2017

TAB: STUDENT EXIT
Table: Employment	Example Values
StudentID
EmploymentType - a selection from: self-employed or business owner private sector u.s. government non-u.s. government other	U.S. government
EmploymentSubType (available values to choose from depend on selected EmploymentType )	U.S. State government
Name	Maryland Department of Environment
Position	Research Associate
StartDate	6/1/2016
EndDate	10/23/2017
NOAASTEMRelated (y/n)	No
ModifiedBy	OED User
DateModified	8/30/2017

Page 16 of 16