|
[Home |
Announcements |
Access |
Installation |
User Notes |
Data Dictionary |
Mailing List |
Contact]
D a t a D i c t i o n a r y
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
This page was last updated on July 8, 2003.
[Home |
Announcements |
Access |
Installation |
User Notes |
Data Dictionary |
Mailing List |
Contact]
|
|
