- DATA VIEW NAME
- ALUMNI_DEMOGRAPHIC
- OVERVIEW
- This view contains demographic information for each individual with a “constituent type” which includes alumni with degrees and alumni without degrees. Individuals who are deceased are also included, but they have been identified accordingly. A FERPA indicator is provided in this view and it is the user’s responsibility to check this indicator if the information is being considered for release.
- LOAD FREQUENCY
- Data is refreshed nightly (Monday through Saturday).
- DATA CUSTODIAN
- Registrar’s Office
Contact: Phil Hull - AUTHORIZATION
- You must receive approval to access data from the data custodian. For information about how to get authorized for InfoAccess data views, connect to the InfoAccess Home Page
- SPECIAL
CONSIDERATIONS - Key fields are identified with an asterisk(*).
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 01/2001 New Data View created.
12/2007 Removed SSN, Rars_ID, all ALM name fields, class_year, ethnicity fields, add’l constituent codes, sport codes, spouse info, service ind fields, country of citizenship, all ALB name fields, all prior fields except for prior ALR fields, employee- employer fields, and ending-title. c4j - DATA FORMATS
- Primary Key Columns are identified with an asterisk(*)
- Alphanumeric Data
- VARCHAR2( N) (N) = maximum length. Field contains letters and/or numbers. Trailing blanks are eliminated.
Example: VARCHAR2 (5) could contain ‘ABC12’ or ‘ABC’ or ‘A’ - Numeric Data
- NUMBER (N) (N) = length. Field contains only numbers.
NUMBER (X,Y) = format for numbers with decimal positions.
X = total number of digits
Y = the number of digits after the decimal
Examples: NUMBER (6) represents 250012 NUMBER (6,2) represents 2500.12 - Date
- DATE – Date can be in various formats. Date functions available with your query tool can be used to format the date.
Examples: DATE (YYYYMMDD), DATE (YYDDD), DATE (DD-MM-YY)
| Column Name | Format | Description |
|---|---|---|
| EMPLID | Varchar2 (11) | The EMPLID (also known as ISIS ID) is generated by the ISIS system. EMPLID is a unique identifier for an alumnus and will never be changed throughout the individual’s relationship with the University. This is not the same as Campus_ID. Only 10 characters are in use. |
| CAMPUS_ID | Varchar2 (16) | ID number assigned to ISIS to be used by alumnus (formerly Student ID). Only 10 characters are in use. |
| ALR_NAME refers to the Alumni Record Name. This is the primary name used in the RARS system and may be different from the primary name used in ISIS. This is the name that the Registrar’s Office uses to maintain a history of unofficial name changes.` | ||
| Alr_Full_Name | Varchar2 (50) | A concatenation of the First Name, Middle Name, and Last Name. |
| Alr_Last_Name | Varchar2 (30) | Individual’s alumni record last name. |
| Alr_First_Name | Varchar2 (30) | Individual’s alumni record first name. |
| Alr_Middle_Name | Varchar2 (30) | Individual’s alumni record middle name or middle initial. |
| Alr_Name_Prefix | Varchar2 (4) | Individual’s alumni record prefix, if specified. For example: Mr., Mrs., Rev., etc. |
| Alr_Name_Suffix | Varchar2 (15) | Individual’s alumni record suffix, if specified. For example: Jr., Sr., III, etc. |
| NAME This is the primary name. | ||
| Last_Name | Varchar2 (30) | Individual’s last name. |
| First_Name | Varchar2 (30) | Individual’s first name |
| Middle_Name | Varchar2 (30) | Individual’s middle name or middle initial. |
| Name_Prefix | Varchar2 (4) | Individual’s prefix, if specified. For example: Mr., Mrs., Rev., etc. |
| Name_Suffix | Varchar2 (15) | Individual’s suffix, if specified. For example: Jr., Sr., III, etc. |
| Gender | Varchar2 (1) | Individual’s gender, if indicated. F = Female M = Male U = Unknown |
| Constituent_Type | Varchar2 (1) | This indicates whether the person is a degree alumnus/ae (Constituent_Type = 1) or a non-degreed alumnus/ae (Constituent_Type = 2). |
| Constituent_Type_Date | Date | The date associated with the Constituent_Type |
| Birthdate | Date | Individual’s date of birth. |
| Date_Of_Death | Date | Date of death as recorded on the ISIS page. This may reflect only the year, or only the month/year of death. The place of death field on the ISIS page records the day on which we received notification of the death and our source. |
| Deceased_Ind | Varchar2 (1) | Y = Deceased |
| Ferpa_Ind | Varchar2 (1) | Restricted information indicator. Y = Information restricted. If an individual has a FERPA=Y, DO NOT release this information to anyone outside the university community. |
| PRIOR_ALR_LAST_NAME is the name used previously to the current name as the alumni record, or primary, name. | ||
| Prior_Alr_Last_Name | Varchar2 (30) | Individual’s prior record last name. |
| Prior_Alr_First_Name | Varchar2 (30) | Individual’s prior record first name. |
| Prior_Alr_Middle_Name | Varchar2 (30) | Individual’s prior record middle name or middle initial. |
| Prior_Alr_Name_Prefix | Varchar2 (4) | Individual’s prior record prefix, if specified. For example: Mr., Mrs., Rev., etc. |
| Prior_Alr_Name_Suffix | Varchar2 (15) | Individual’s prior record suffix, if specified. For example: Jr., Sr., III, etc. |
| Extract_Date_Time | Date | Date and time of the most recently extracted data from the ISIS database. |