API Dataset: Students

Dataset: Students

Below is the list of fields available via the Students dataset and how the field is sourced.

Yale API Field Name Database Column
FirstName SPRIDEN_FIRST_NAME
PreferredFirstName SPBPERS_PREF_FIRST_NAME if exists, else use SPRIDEN_FIRST_NAME
MiddleName SPRIDEN_MI
LastName SPRIDEN_LAST_NAME
StudentId SPRIDEN_ID
DateOfBirth SPBPERS_BIRTH_DATE
CitizenshipCode SPBPERS_CITZ_CODE
CitizenshipDesc STVCITZ_DESC
PermanentPhoneNumber

SPRTELE_INTL_ACCESS (if exists)

(SPRTELE_PHONE_AREA) SPRTELE_PHONE_NUMBER - SPRTELE_PHONE_EXT

UniversityEmailAddress

GOREMAL_EMAIL_ADDRESS where EMAL_CODE = ‘YALE’ and STATUS_IND = ‘A’

Note: This will be replaced with sfas.system.services@yale.edu when in test/dev environment.

UPI SYVYIDS_YALE_UPI
NetId SYVYIDS_NETID
TermCode SGBSTDN_TERM_CODE_EFF based on SYVCTRM.CURRENT_TERM_CODE
MajorCodeDesc1 STVMAJR_DESC based on SGBSTDN_MAJR_CODE_1
MajorCodeDesc12 STVMAJR_DESC based on SGBSTDN_MAJR_CODE_1_2
MajorCodeDesc2 STVMAJR_DESC based on SGBSTDN_MAJR_CODE_2
MajorCodeDesc22 STVMAJR_DESC based on SGBSTDN_MAJR_CODE_2_2
DegreeCodeDesc1 STVDEGC_DESC based on SGBSTDN_DEGC_CODE_1
DegreeCodeDesc2 STVDEGC_DESC based on SGBSTDN_DEGC_CODE_2
CohortYear SGRCHRT_CHRT_CODE
ClassYear SGRSATT_ATTS_CODE
ResdCode SGBSTDN_RESD_CODE
ResdDesc STVRESD_DESC  based on SGBSTDN_RESD_CODE
CollegeCode1 SGBSTDN_COLL_CODE_1
CollegeCode2 SGBSTDN_COLL_CODE_2
MailingAddressLine1

SPRADDR_STREET_1 where SPRADDR_ATYP_CODE = ‘MA’

MailingAddressLine2 SPRADDR_STREET_2 where SPRADDR_ATYP_CODE = ‘MA’
MailingAddressLine3

SPRADDR_STREET_3 where SPRADDR_ATYP_CODE = ‘MA’

MailingAddressCity SPRADDR_CITY where SPRADDR_ATYP_CODE = ‘MA’
MailingAddressStateCode SPRADDR_STATE where SPRADDR_ATYP_CODE = ‘MA’
MailingAddressZipCode SPRADDR_ZIP where SPRADDR_ATYP_CODE = ‘MA’
MailingAddressCountryName STVNATN_NATION based on SPRADDR_NATN where SPRADDR_ATYP_CODE = ‘MA’
DprSubmissionDate SHREVNT_EFFECTIVE_DATE where SHREVNT_EVEN_CODE = ‘DPR’
CoverageCode TBRACCD_DETAIL_CODE - One of the following: YH06, YH09, YH45, YH46
CoverageDesc TBBDETC_DESC based on the TBRACCD_DETAIL_CODE; NULL values will be set to “WAIVED”
HasCurrentTerm Y/N based on if the student has a record in SGBSTDN for the current term