Person Object

The Person object contains student personal information. This object contains one record for every person who has records in the Student Data Warehouse.

---

Warehouse ID

Warehouse identification code. A unique identifying value for all persons in the Student Data Warehouse.

Data Type: Number

Example: 123456

Source: derived

Student ID

Student Identification number (often Social Security Number).

Data Type: 9 Characters

Example: 123456789

Source: spriden_id

Confidentiality Flag

If this field is 'Y', you may not release any personally identifiable information about this student without the student's written consent. This includes purposes such as listing the student in the cast of a play, in a list of ensemble members for a musical performance, etc.

Data Type: 1 Character

Example: Y

Source: spbpers_confid_ind

Deceased Flag

Indicates if the student is deceased. 'Y' if a student is deceased, otherwise null. If the student is deceased, all address and telephone fields are null.

Data Type: 1 Character

Example: Y

Source: spbpers_dead_ind

Last Name

Last name of person.

Data Type: 35 Characters

Example: Smith

Source: spriden_last_name

First Name

First name of person.

Data Type: 15 Characters

Example: Beth

Source: spriden_first_name

Middle Name

Middle name of person.

Data Type: 15 Characters

Example: Shara

Source: spriden_mi

LFM Name

Person's complete name in the form of "Last, First Middle", usually used for alphabetically sorted lists. If the person has only one name a comma is not included.

Data Type: 60 Characters

Example: Smith, Beth Shara

Source: derived

Notes: Derived by concatenating spriden_last_name, spriden_first_name and spriden_mi.

FML Name

Person's complete name in the form of "First Middle Last", preferred format for correspondence or mail addresses.

Data Type: 60 Characters

Example: Beth Shara Smith

Source: derived

Notes: Derived by concatenating spriden_first_name, spriden_mi and spriden_last_name.

Contact Name 1

Person designated as parent, spouse, significant other, etc. In the form: "Last, First Middle.

Data Type: 35 Characters

Example: Smith, Sheila Lisa

Source: derived

Notes: Derived by concatenating sorfolk_parent_first and sorfolk_parent_last.

Contact Name 2

Second person designated as parent, spouse, significant other, etc. In the form: "Last, First Middle.

Data Type: 35 Characters

Example: Smith, Brent Eric

Source: derived

Notes: Derived by concatenating sorfolk_parent_first and sorfolk_parent_last.

Gender

Person's gender coded as M (male), F (female), and N (not designated).

Data Type: 1 Character

Example: M

Source: spbpers_sex

Birth Date

Person's birth date.

Data Type: Date

Example: 03-SEP-66

Source: spbpers_birth_date

Age

Person's age.

Data Type: 3 Digit number

Example: 26

Source: derived

Ethnic Code

Ethnicity code associated with person.

Data Type: 2 Characters

Example: A

Source: spbpers_ethn_code

Val Table: Ethnic

Ethnic Desc

Description of Ethnicity Code.

Data Type: 30 Characters

Example: Asian, Asian American

Source: stvethn_desc

Val Table: Ethnic

ETCT Code

Ethnic Type Category Code, groups ethnic codes into the U.S. government-defined ethnic categories required for most official reporting. They are: (1) Black, Non-Hispanic; (2) American Indian or Alaskan Native; (3) Asian or Pacific Islander; (4) Hispanic; (5) White Non-Hispanic; (6) Other.

Data Type: 1 Character

Example: 4

Source: stvethn_etct_code

Val Table: Ethnic Type

ETCT Desc

Description of Ethnic Type Category Code.

Data Type: 30 Characters

Example: Hispanic

Source: stvetct_desc

Val Table: Ethnic Type

US Citizen Flag

Flag indicating whether person is a US citizen. 'Y' = US Citizen (yes), 'R' = Resident Alien, 'N' = Non-US Citizen. If not a US citizen, the student is usually considered an international student.

Data Type: 1 Character

Example: N

Source: derived

Notes: This flag is set to 'R' for persons who have a sprintl record whose sprintl_vtyp_code is RA, 'N' for persons who have a sprintl record, and whose sprintl_vtyp_code_current is not equal to: XI, XU, PR, or RA, and 'Y' for all others.

Citizenship Nation Code

Code of the nation of person's citizenship. Populated only for non-US citizens.

Data Type: 5 Characters

Example: KKW

Source: sprintl_natn_code_legal

Val Table: Nation

Citizenship Nation Desc

Description of nation of person's citizenship.

Data Type: 30 Characters

Example: Kuwait

Source: stvnatn_nation

Val Table: Nation

Visa Type

Code denoting type of Visa (international students only).

Data Type: 2 Characters

Example: F1

Source: sprintl_vtyp_code_current

Visa Expiration Date

Date visa expires (international students only).

Data Type: Date

Example: 9/30/97

Source: sprintl_visa_expire_date

Visa Birth Nation Code

Code of the nation of birth of international students.

Data Type: 5 Characters

Example: KKW

Source: sprintl_natn_code_birth

Val Table: Nation

Visa Birth Nation Desc

Description of the Visa Birth Nation Code.

Data Type: 30 Characters

Example: Kuwait

Source: stvnatn_nation

Val Table: Nation

Visa Spouse Ind

Flag indicating whether person is married (international students only). 'Y' = yes, 'N' = no.

Data Type: 1 Character

Example: N

Source: sprintl_spouse_ind

Visa Num Children

Number of person's dependent children (international students only).

Data Type: 2 Digit number

Example: 2

Source: sprintl_child_number

Email Addrs

E Mail Addresses of the form user@machine, separated by '|' (pipe characters). Null if the deceased flag is set.

Data Type: 60 Characters

Example: |smithb@ucs.orst.edu|

Source: Derived

Notes: Comes from the AUTHORIZE database, users.user_name and user_system.system_id.

Preferred Email

A persons preferred email address.

Data Type: 90 Characters

Example: me@gladstone.uoregon.edu

source: goremal

International Student

This indicator will be Y if the student is an International Student, i.e. has admit type code in (IN,GI). Otherwise, will be null.

Data Type: 1 Character