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 (School1/Coll_Code1’s primary major) |
| MajorCodeDesc12 |
STVMAJR_DESC based on SGBSTDN_MAJR_CODE_1_2 (School1/Coll_Code1’s secondary major) |
| MajorCodeDesc2 |
STVMAJR_DESC based on SGBSTDN_MAJR_CODE_2 (School2/Coll_Code2’s primary major) |
| MajorCodeDesc22 |
STVMAJR_DESC based on SGBSTDN_MAJR_CODE_2_2 (School2/Coll_Code2’s secondary major) |
| 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 |