Schema

Table: GradApps

  • AppID
  • UIN
  • Gender
  • Ethnicity
  • EthnicityText
  • MexicanAmerican
  • Street1
  • Street2
  • City
  • State
  • Zip
  • Country
  • Phone1
  • Phone2
  • Email
  • ProgramStartSem
  • Program
  • Status_Basic (status of the Application Page "Basic")
  • Status_Finance (status of the "Finance" Application Page)
  • Status_AcadProf (status of the "Academic and Professional Information" Application Page)
  • Status_References (status of the "References" Application Page)
  • Status_Personal
  • HowFinance
  • HowFinanceComments
  • Assistantship
  • CurrEmployment
  • CurrEmployment2
  • TakenGRE
  • . . .
  • ProfWorkExeperence (Essay)
  • School Counseling Specific Fields
    • SchoolAffiliation (format = Yes/No;SCHOOL NAME)
    • TeachingExperience (format = Yes/No;SCHOOL NAME)
  • DepartmentReferences
  • ExpDisabilities
  • . . .

Table: GradApps_Documents

Table: GradApps_Evaluations

Table: GradApps_References

  • RefID
  • AppID
  • FullName
  • FirstName
  • Institution
  • Relationship
  • EMail
  • Status
  • Update
  • Message
  • TimeSent
  • TimeResponded
  • TimeFinished
  • Rcmd_Relationship
  • Rcmd_TimeKnown
  • Rcmd_Complete
  • Rcmd_Aptitude
  • Rmcd_NoLimits
  • Rcmd_Percentile
  • Rcmd_Q6
  • Rcmd_Q7
  • Rcmd_Q8
  • Rcmd_Q9
  • . . .
  • Phone
  • LOR_URL
  •  

Table: GradApps_Review

Table: GradApps_StipendApps

 

 

Taxonomy: