| Data element |
Definition |
| Account_Paymenttypeid Indexed - no
Format - Number
May be Null? Y | |
| Accountcode Indexed - no
Format - Varchar2(80)
May be Null? Y | |
| Accountcomments Indexed - no
Format - Varchar2(4000)
May be Null? Y | |
| Accountduedate Indexed - no
Format - Date
May be Null? Y | |
| Accounthold Indexed - no
Format - Varchar2(40)
May be Null? Y | |
| Attendeestatusenum Indexed - no
Format - Number
May be Null? Y | |
| Career Indexed - no
Format - Varchar2(200)
May be Null? Y | |
| Careercomments Indexed - no
Format - Varchar2(400)
May be Null? Y | |
| Citizenship_Countryid Indexed - no
Format - Number
May be Null? Y | |
| Classificationid Indexed - no
Format - Number
May be Null? Y | |
| Comments Indexed - no
Format - Varchar2(4000)
May be Null? Y | |
| Countryofbirth_Countryid Indexed - no
Format - Number
May be Null? Y | |
| Countryofresidence_Countryid Indexed - no
Format - Number
May be Null? Y | |
| Dateentry Indexed - no
Format - Date
May be Null? Y | |
| Dateexit Indexed - no
Format - Date
May be Null? Y | |
| Deceased Indexed - no
Format - Varchar2(40)
May be Null? Y | |
| Deceaseddate Indexed - no
Format - Date
May be Null? Y | |
| Dietary Indexed - no
Format - Varchar2(2000)
May be Null? Y | |
| Disability Indexed - no
Format - Varchar2(2000)
May be Null? Y | |
| Employmentdetails Indexed - no
Format - Varchar2(400)
May be Null? Y | |
| Enrollmentclass Indexed - no
Format - Varchar2(200)
May be Null? Y | |
| Enrollmentlevel Indexed - no
Format - Varchar2(200)
May be Null? Y | For designating undergrad vs. grad student
G=Graduate student, U=Undergraduate
Source=SRS from primary degree |
| Enrollmentstatus Indexed - no
Format - Varchar2(200)
May be Null? Y | |
| Enrollmentterm Indexed - no
Format - Varchar2(200)
May be Null? Y | |
| Enrollmentyear Indexed - no
Format - Number
May be Null? Y | |
| Entrydetailid Indexed - yes
Format - Number
May be Null? N | |
| Entryid Indexed - no
Format - Number
May be Null? Y | Entry Unique Identifier |
| Ethnicity Indexed - no
Format - Varchar2(200)
May be Null? Y | |
| Eventregistrationfeeid Indexed - no
Format - Number
May be Null? Y | |
| Financialcomments Indexed - no
Format - Varchar2(800)
May be Null? Y | |
| Financialsupportid Indexed - no
Format - Number
May be Null? Y | |
| Hearaboutus Indexed - no
Format - Varchar2(200)
May be Null? Y | |
| Incidenthold Indexed - no
Format - Varchar2(40)
May be Null? Y | |
| Incidentholdcomments Indexed - no
Format - Varchar2(400)
May be Null? Y | |
| International Indexed - no
Format - Varchar2(40)
May be Null? Y | |
| Internationaldetails Indexed - no
Format - Varchar2(200)
May be Null? Y | |
| Livingwithdependents Indexed - no
Format - Varchar2(40)
May be Null? Y | |
| Married Indexed - no
Format - Varchar2(40)
May be Null? Y | |
| Medical Indexed - no
Format - Varchar2(2000)
May be Null? Y | |
| Nationalityid Indexed - no
Format - Number
May be Null? Y | |
| Occupation Indexed - no
Format - Varchar2(200)
May be Null? Y | |
| Photopath Indexed - no
Format - Varchar2(800)
May be Null? Y | |
| Previousmembername Indexed - no
Format - Varchar2(200)
May be Null? Y | |
| Previousmemberrelationship Indexed - no
Format - Varchar2(80)
May be Null? Y | |
| Previousmembership Indexed - no
Format - Varchar2(200)
May be Null? Y | |
| Previousmembershipyears Indexed - no
Format - Varchar2(36)
May be Null? Y | |
| Previousmemberyears Indexed - no
Format - Varchar2(36)
May be Null? Y | |
| Profileinterests Indexed - no
Format - Varchar2(2000)
May be Null? Y | |
| Regionofbirthid Indexed - no
Format - Number
May be Null? Y | |
| Religion Indexed - no
Format - Varchar2(80)
May be Null? Y | |
| Residentstatus Indexed - no
Format - Varchar2(200)
May be Null? Y | |
| Residentyear Indexed - no
Format - Number
May be Null? Y | |
| Specialneeds Indexed - no
Format - Varchar2(2000)
May be Null? Y | |
| Staffid Indexed - no
Format - Number
May be Null? Y | |
| Usesscreenreader Indexed - no
Format - Varchar2(40)
May be Null? Y | |
| Vehicledetails Indexed - no
Format - Varchar2(1000)
May be Null? Y | |
| Vehiclepermit Indexed - no
Format - Varchar2(120)
May be Null? Y | |
| Vehicleregistration Indexed - no
Format - Varchar2(80)
May be Null? Y | |
| Visa Indexed - no
Format - Varchar2(40)
May be Null? Y | |
| Visadetails Indexed - no
Format - Varchar2(400)
May be Null? Y | |
| Visitorhold Indexed - no
Format - Varchar2(40)
May be Null? Y | |
