Recruit Person Object

The Recruit Person object contains recruit personal data. This object contains one record per recruit person in the Student Data Warehouse for the time spanning the current term to one year in the future.

---

PIDM

Identification number. A unique identifying value for all persons in the Student Data Warehouse.

Data Type: 8 Digit number

Example: 123456

Source: spriden_pidm

Student ID

Student Identification.

Data Type: 9 Characters

Example: 1234567890

Source: spriden_id

Last Name

Last name of Recruit.

Data Type: 60 Characters

Example: Smith

Source: spriden_last_name

First Name

First name of Recruit.

Data Type: 15 Characters

Example: John

Source: spriden_first_name

Middle Name

Middle name of Recruit.

Data Type: 15 Characters

Example: Anthony

Source: spriden_mi

LFM Name

Recruit's complete name in the form of last, comma, first & middle, usually used for sorting. If the person has only one name a comma is not included.

Data Type: 96 Characters

Example: Smith, John Anthony

Source: derived

FML Name

Recruit's complete name in the form of first middle & last, preferred format for correspondence or mail addresses.

Data Type: 96 Characters

Example: John Anthony Smith

Source: derived

Gender

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

Data Type: 1 Character

Example: M

Source: spbpers_sex

Birth Date

Recruit's birth date. If birth date is not known, element contains zeroes.

Data Type: Date

Example: 05-MAR-64

Source: spbpers_birth_date

Ethnic Code

Ethnicity code associated with Recruit.

Data Type: 2 Characters

Example: AA

Source: spbpers_ethn_code

Val Table: Ethnic

Ethnic Desc

Description of Ethnicity Code.

Data Type: 30 Characters

Example: Asian-Asian Indian

Source: stvethn_desc

Val Table: Ethnic

ETCT Code

Ethnic Category Type Code.

Data Type: 1 Character

Example: 1

Source: stvethn_etct_code

Val Table: Ethnic Type

ETCT Desc

Description of ETCT Code.

Data Type: 30 Characters

Example: black Non-Hispanic

Source: stvetct_desc

Val Table: Ethnic Type

Mail Addr Str 1

First line of mailing street address.

Data Type: 30 Characters

Example: 234 N Harrison St

Source: spraddr_street_line1

Mail Addr Str 2

Second line of mailing street address.

Data Type: 30 Characters

Example: c/o John Smith

Source: spraddr_street_line2

Mail Addr City

City of mailing address.

Data Type: 30 Characters

Example: Tacoma

Source: spraddr_city

Mail Addr State

State code of mailing address.

Data Type: 3 Characters

Example: WA

Source: spraddr_stat_code

Mail Addr Nation

Nation code of mailing address.

Data Type: 30 Characters

Example: US

Source: stvnatn_nation

Val Table: Nation

Mail Addr Zip Code

ZIP code of mailing address, includes the dash for ZIP+4 codes.

Data Type: 10 Characters

Example: 98366

Source: spraddr_zip

Mail Addr CSZ

Concatention of City, comma, space, state, space, and zip code of mailing address.

Data Type: 48 Characters

Example: Eugene, OR 97402

Source: derived

Mail Addr Area Code

Area code of telephone number associated with this address.

Data Type: 3 Characters

Example: 503

Source: sprtele_phone_area

Mail Addr Phone

Prefix and extension number of telephone number associated with this address.

Data Type: 7 Characters

Example: 758-0011

Source: sprtele_phone_number