STUDENT ARCHIVE ALUMNI Table
View exposing student archive alumni data.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDR_CAT |
Addr cat associated with the record. |
VARCHAR2 |
3 |
ATTENDED |
Attended associated with the record. |
VARCHAR2 |
5 |
BIRTH_DT |
Birth dt associated with the record. |
DATE |
|
COUNTRY_ORIGIN |
Country origin associated with the record. |
VARCHAR2 |
2 |
CURRENT_ACADEMIC_TERM |
Current academic term associated with the record. |
VARCHAR2 |
6 |
DATA_EXTRACT_DATE |
Date associated with data extract. |
DATE |
|
DEGREE1 |
Degree1 associated with the record. |
VARCHAR2 |
4 |
DEGREE2 |
Degree2 associated with the record. |
VARCHAR2 |
4 |
DEGREE3 |
Degree3 associated with the record. |
VARCHAR2 |
4 |
DEGREE4 |
Degree4 associated with the record. |
VARCHAR2 |
4 |
DEGREE5 |
Degree5 associated with the record. |
VARCHAR2 |
4 |
DEPT |
Dept associated with the record. |
VARCHAR2 |
4 |
DEPT1 |
Dept1 associated with the record. |
VARCHAR2 |
4 |
DEPT2 |
Dept2 associated with the record. |
VARCHAR2 |
4 |
DEPT3 |
Dept3 associated with the record. |
VARCHAR2 |
4 |
DEPT4 |
Dept4 associated with the record. |
VARCHAR2 |
4 |
DEPT5 |
Dept5 associated with the record. |
VARCHAR2 |
4 |
DEPT_OPTION |
Dept option associated with the record. |
VARCHAR2 |
4 |
ELIGIBLE_TO_REG |
Eligible to reg associated with the record. |
VARCHAR2 |
5 |
EMAIL_ADDRESS |
Email address associated with the record. |
VARCHAR2 |
60 |
FIRST_NAME |
First name associated with the person or organization. |
VARCHAR2 |
30 |
GENDER |
Gender associated with the record. |
VARCHAR2 |
1 |
G_ENTRY_TERM |
G entry term associated with the record. |
VARCHAR2 |
6 |
HOME_ADDR_CHANGE_DATE |
Home addr change date associated with the record. |
DATE |
|
HOME_AREA |
Home area associated with the record. |
VARCHAR2 |
3 |
HOME_CITY |
Home city associated with the record. |
VARCHAR2 |
40 |
HOME_NATION |
Home nation associated with the record. |
VARCHAR2 |
30 |
HOME_PHONE |
Home phone associated with the record. |
VARCHAR2 |
7 |
HOME_STATE |
Home state associated with the record. |
VARCHAR2 |
2 |
HOME_STREET1 |
Home street1 associated with the record. |
VARCHAR2 |
30 |
HOME_STREET2 |
Home street2 associated with the record. |
VARCHAR2 |
30 |
HOME_STREET3 |
Home street3 associated with the record. |
VARCHAR2 |
30 |
HOME_ZIP |
Home zip associated with the record. |
VARCHAR2 |
5 |
HOME_ZIP_4 |
Home zip 4 associated with the record. |
VARCHAR2 |
4 |
ILG |
Ilg associated with the record. |
VARCHAR2 |
3 |
IS_COURSE_CONFIDENTIAL |
Indicator identifying whether course confidential (Y/N). |
VARCHAR2 |
5 |
IS_E_MAIL_CONFIDENTIAL |
Indicator identifying whether e mail confidential (Y/N). |
VARCHAR2 |
5 |
IS_HOME_ADDR_CONFIDENTIAL |
Indicator identifying whether home addr confidential (Y/N). |
VARCHAR2 |
5 |
IS_OFFICE_ADDR_CONFIDENTIAL |
Indicator identifying whether office addr confidential (Y/N). |
VARCHAR2 |
5 |
IS_OFFICE_PHONE_CONFIDENTIAL |
Is office phone confidential associated with the record. |
VARCHAR2 |
5 |
IS_SERIOUS_CONFIDENTIAL |
Indicator identifying whether serious confidential (Y/N). |
VARCHAR2 |
1 |
IS_TERM_ADDR_CONFIDENTIAL |
Indicator identifying whether term addr confidential (Y/N). |
VARCHAR2 |
5 |
IS_TERM_PHONE_CONFIDENTIAL |
Is term phone confidential associated with the record. |
VARCHAR2 |
5 |
IS_YEAR_CONFIDENTIAL |
Indicator identifying whether year confidential (Y/N). |
VARCHAR2 |
5 |
LAST_NAME |
Last name associated with the person or organization. |
VARCHAR2 |
30 |
LEGAL_FIRST_NAME |
Legal first name associated with the record. |
VARCHAR2 |
60 |
LEGAL_LAST_NAME |
Legal last name associated with the record. |
VARCHAR2 |
60 |
LEGAL_MIDDLE_NAME |
Legal middle name associated with the record. |
VARCHAR2 |
60 |
MIDDLE_NAME |
Middle name associated with the person or organization. |
VARCHAR2 |
30 |
NAME_CHANGE_DATE |
Date associated with name change. |
DATE |
|
OPTION1 |
Option1 associated with the record. |
VARCHAR2 |
4 |
OPTION2 |
Option2 associated with the record. |
VARCHAR2 |
4 |
OPTION3 |
Option3 associated with the record. |
VARCHAR2 |
4 |
OPTION4 |
Option4 associated with the record. |
VARCHAR2 |
4 |
OPTION5 |
Option5 associated with the record. |
VARCHAR2 |
4 |
REGISTERED |
Registered associated with the record. |
VARCHAR2 |
5 |
REGISTRAR_ID |
Business identifier for the registrar. |
VARCHAR2 |
9 |
REG_TYPE |
Reg type associated with the record. |
VARCHAR2 |
1 |
SSN |
Ssn associated with the record. |
VARCHAR2 |
9 |
TERM1 |
Term1 associated with the record. |
VARCHAR2 |
6 |
TERM2 |
Term2 associated with the record. |
VARCHAR2 |
6 |
TERM3 |
Term3 associated with the record. |
VARCHAR2 |
6 |
TERM4 |
Term4 associated with the record. |
VARCHAR2 |
6 |
TERM5 |
Term5 associated with the record. |
VARCHAR2 |
6 |
TERM_ADDR_CHANGE_DATE |
Term addr change date associated with the record. |
DATE |
|
TERM_AREA1 |
Term area1 associated with the record. |
VARCHAR2 |
3 |
TERM_AREA2 |
Term area2 associated with the record. |
VARCHAR2 |
3 |
TERM_CITY |
Term city associated with the record. |
VARCHAR2 |
40 |
TERM_PHONE1 |
Term phone1 associated with the record. |
VARCHAR2 |
7 |
TERM_PHONE2 |
Term phone2 associated with the record. |
VARCHAR2 |
7 |
TERM_STATE |
Term state associated with the record. |
VARCHAR2 |
2 |
TERM_STREET1 |
Term street1 associated with the record. |
VARCHAR2 |
30 |
TERM_STREET2 |
Term street2 associated with the record. |
VARCHAR2 |
30 |
TERM_STREET3 |
Term street3 associated with the record. |
VARCHAR2 |
30 |
TERM_ZIP |
Term zip associated with the record. |
VARCHAR2 |
5 |
TERM_ZIP_4 |
Term zip 4 associated with the record. |
VARCHAR2 |
4 |
U_ENTRY_TERM |
U entry term associated with the record. |
VARCHAR2 |
6 |
YEAR |
Year associated with the record. |
VARCHAR2 |
1 |