note: in the Business Objects Grad Admissions Reporting universe, the data elements in this table are found in the Academic History class.
| Data element |
Definition |
| Another_Transcript_YN |
If the applicant indicated that another transcript is available for the instititution, this field will be "Y". Populated only for CollegeNet based applications. |
| Application_Key |
An identifying number for an application, assigned in the data warehouse. |
| Begin_Date |
A date in MM/YYYY format, indicating starting date at the previous institution. |
| China_Degree_Verification |
For CollegeNet applications, indicates if degree at the institution was verified. Verifications are done via
CHESICC (China Higher Education Student Information and Career Center)
|
| China_Transcript |
For CollegeNet applications, indicates if a transcript was received from CHESICC. |
| City |
The city of the institution previously attended. |
| CN_China_Inst_Code |
For CollegeNet applications, where the Chinese transcript service was used, the Institution code provided by the CHESICC service. This is not necessarily the same as an ETS institution code. |
| CN_China_Inst_Desc |
For CollegeNet applications, where the Chinese transcript service was used, the Institution name provided by the CHESICC service. |
| CN_Intl_Trscrpt_Service_Used |
Y/N for CollegeNet applications, indicating whether CHESICC or other International transcript service was used to validate the transcript. |
| Country |
The 2-character country code of the institution. |
| Country_Desc |
The country of the institution. |
| Degree_Pursued |
A free-form text field that specified the degree the applicant was working towards while at the previous institution. The text for the degree is in un-validated format, for example, BS, B.S., B.Sc. all could mean the same degree |
| Degree_Received |
A free-form text field that specifies whether the applicant received a degree at the previous institution, and if so, what it was. A 'N' in this column indicates the student attended, but did not receive a degree. A 'Y' in this column presumes the student received the degree found in the Degree_Pursued column. Otherwise, the text for the actual degree received will be in this column, in un-validated format, for example, BS, B.S., B.Sc. all could mean the same degree. |
| End_Date |
A date in MM/YYYY format, this indicates when the applicant ended their study at the previous institution. |
| English_Lang_Primary_Instruct |
For CollegeNet applications, a Y/N indicator of whether courses at this institution were primarily taught in English, as reported by the applicant. |
| Expected_Graduation_Date |
The date the applicant expects or expected to receive the degree from the previous institution. This is not always the same as the End_Date. If the value in Degree_Received is 'N' the Graduation_Date will be null. Expected_Graduation_Date is in free-form, unvalidated format. |
| GPA |
The grade point average that the applicant indicates they achieved at their previous institution. This is self-reported data and is in un-validated format. |
| GPA_Scale |
The grade point average scale, as reported by the applicant, if available. For example, a GPA_Scale of 4.0 indicates that the data in the GPA column will be in the 4.0 scale where 4.0 is A, 3.0 is B, 2.0 is a C, etc. |
| GPA_Scale_Other |
For CollegeNet applications, the "Other" grade point average scale, as reported by the applicant. |
| Institution_Code |
A code that uniquely idenfies a record in the Institution lookup table. Beginning in 2012, this will be the ETS code, and will be consistent with the codes used for institutions in the Student Records System. |
| Institution_Name |
The name of the school, college or university where the applicant previously attended. |
| Last_Edited_On |
The date this record was last edited, typically the date the record was extracted from the source system. |
| Level_of_Study |
Indicates the applicant's level of study -- baccelors, masters, doctoral, etc. -- at their previous institution. Beginning in 2012, there will be a set of valid values for this field. However, historically this was free-form text, and values varied widely. For example, 'Bachelors degree' 'Undergraduate Degree' and 'Bacc' all could mean the same level. |
| Major |
A free-form text field that specifies the applicant's major at their previous institution. |
| Primary_Undergrad_YN |
For CollegeNet applications starting with 2016, Y/N indicator of the applicant's primary undergraduate institution, as reported by the applicant. |
| Recvd_Degree_Prior_Enroll |
Y/N indicator of whether a degree was received by the applicant from this institution. |
| Rec_Number |
Sequence number based on how the data were entered in the source system; It does NOT indicate a priority or chronological order. For example, if an applicant reported attending four prior colleges or universities, there would be four records in this table for the applicant, with Record Numbers 1, 2,3, and 4 respectively.
|
| US_State |
The state associated with the official address of the institution where the applicant previously attended. For US addresses only. This is usually the 2-character code for state, but the field does support free-form un-validated text. |
