DORIS Logo
 Back

  Person


Description
Student and employee identity information and demographics.

Data includes name, address, birthdate, ethnicity, gender, social security number and additional personal properties.

Fields
  address1   string   
Permanent address, street line 1
  address2   string   
Permanent address, street line 2
  address3   string   
Permanent address, street line 3
  birthDate   date   
Date of birth
  city   string   
Permanent address, city
  deathDate   date   
Date of death. If still living, value is null.
  email   string   
Permanent email address
  ethnicity   enum   
Ethnicity/race of person
Allowed Values
  • Hispanic or Latino
  • American Indian or Alaskan Native
  • Asian
  • Black or African American
  • Native Hawaiian or Other Pacific Islander
  • Caucasian
  • Unknown
Allowed Value Details
'Hispanic or Latino' - A person of Cuban, Mexican, Puerto Rican, South or Central American, or other Spanish culture or origin, regardless of race.

'American Indian or Alaskan Native' - A person having origins in any of the original peoples of North and South/Central America who maintains cultural identification through tribal affiliation or community attachment.

'Asian' - A person having origins in any of the original peoples of the Far East, Southeast Asia, or the Indian Subcontinent.

'Black or African American' - A person having origins in any of the black racial groups of Africa.

'Native Hawaiian or Other Pacific Islander' - A person having origins in any of the original peoples of Hawaii, Guam, Samoa, or other Pacific Islands.

'Caucasian' - A person having origins in any of the original peoples of Europe, the Middle East, or North Africa.

'Unknown' - Ethnicity not provided or is unlisted in the provided choices.
  firstName   string   
First name of person
  gender   enum   
Gender of person
Allowed Values
  • Male
  • Female
  • Non-Binary
  • Unknown
Allowed Value Details
'Male' - Binary male.

'Female' - Binary female.

'Non-Binary' - Non-binary identification.

'Unknown' - Gender is not provided.
  isConfidential   boolean   
If personal data should remain confidential, value = 1, else 0
  isHispanic   boolean   
If person''s race is Hispanic, value = 1, else 0
  isInUSOnVisa   boolean   
If currently in US on a visa program and official resident of a foreign country, value = 1, else 0
  isIPEDSReportable   boolean   
If record is applicable for IPEDS reporting, value = 1, else 0
  isMilitary   boolean   
If person is currently serving in the military, value = 1, else 0
  isMultipleRaces   boolean   
If person's origin is of multiple races, value = 1, else 0
  isUSCitizen   boolean   
If a United States citizen, value = 1, else 0
  isVeteran   boolean   
If person has previously served, but not currently serving in the military, value = 1, else 0
  lastFourSsn   string   
Last four digits of Social Security Number
  lastName   string   
Last name of person
  maritalStatus   enum   
Marital status
Allowed Values
  • Single
  • Married
  • Divorced
  • Widowed
  • Separated
  • Domestic Partnership
  • Unknown
Allowed Value Details
'Single' - Single unmarried.

'Married' - Lawfully married. Includes common-law marriage if it is recognized by the institution's state.

'Divorced' - Legally divorced non-widower.

'Widowed' - Surviving spouse that has not remarried.

'Separated' - Legally holding a separation agreement.

'Domestic Partnership' - Registered domestic partnership.

'Unknown' - Marital status is unknown or is unlisted in the provided choices.
  middleName   string   
Middle name or initial of person
  nation   string   
Permanent address, nation
  personId   string   
Unique identifier of a person
  phone   string   
Permanent phone number
  recordActivityDate   date   
Date source record inserted or modified
  state   string   
Permanent address, state
  suffix   string   
Suffix of a person's name, for example: Jr., Sr., etc.
  visaEndDate   date   
If isInUSOnVisa field is true, date when person's visa ends, else null
  visaStartDate   date   
If isInUSOnVisa field is true, date when person''s visa starts, else null
  visaType   enum   
If isInUSOnVisa field is true, then type of visa, else null
Allowed Values
  • Student Non-resident
  • Employee Non-resident
  • Employee Resident
  • Other Non-resident
  • Other Resident
Allowed Value Details
'Student Non-resident' - Student is not a citizen or national of the United States and is in this country on a visa or temporary basis and does not have the right to remain indefinitely.

'Employee Non-resident' - Employee is not a citizen or national of the United States and is in this country on a visa or temporary basis and does not have the right to remain indefinitely.

'Employee Resident' - Employee is not a citizen or national of the United States but who has been admitted as a legal immigrant for the purpose of obtaining permanent resident status. (May include the following visa categories: E1, E2, E3, EW3, C5, T5, R5, I5, S many**, SD, SR, SI, SQ, SQ, DV, SB).

'Other Non-resident' - Non-student/non-employee that is not a citizen or national of the United States and is in this country on a visa or temporary basis and does not have the right to remain indefinitely.

'Other Resident' - Non-student/non-employee that is not a citizen or national of the United States but who has been admitted as a legal immigrant for the purpose of obtaining permanent resident status. (May include the following visa categories: E1, E2, E3, EW3, C5, T5, R5, I5, S many**, SD, SR, SI, SQ, SQ, DV, SB).
  zipcode   string   
Permanent address, zipcode

Example SQL