| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
ASIAN_IND
|
Indicates if person's race is Asian.
|
VARCHAR2(63)
|
PERSON_SENSITIVE_RACE
|
RACE_CATEGORY
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
BLACK_OR_AFRICAN_IND
|
Indicates if person's race is Black or African.
|
VARCHAR2(63)
|
PERSON_SENSITIVE_RACE
|
RACE_CATEGORY
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
CITIZENSHIP_IND
|
Indicates whether the person has been identified as a citizen of the institution's home country.
|
VARCHAR2(63)
|
PERSON
|
CITIZENSHIP_IND
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
CITIZENSHIP_TYPE
|
Identifies the person's citizen type relationship to the institution's home country.
|
VARCHAR2(63)
|
PERSON
|
CITIZENSHIP_TYPE
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
CITIZENSHIP_TYPE_LD
|
Long description defined in the cleansing process.
|
VARCHAR2(255)
|
ETL GENERATED ETL_GENERATED PERSON
|
NA NA CITIZENSHIP_DESC
|
NO NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR FINANCIAL AID APPLICATION
|
|
CITIZENSHIP_TYPE_SD
|
Short description defined in the cleansing process.
|
VARCHAR2(255)
|
ETL GENERATED ETL_GENERATED PERSON
|
NA NA CITIZENSHIP_DESC
|
NO NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR FINANCIAL AID APPLICATION
|
|
DECEASED_IND
|
Indicates whether a person is deceased.
|
VARCHAR2(63)
|
PERSON
|
DECEASED_STATUS
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
DEMOGRAPHIC_KEY
|
Key of the demographic dimension.
|
NUMBER
|
ETL GENERATED ETL_GENERATED
|
NA NA
|
NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR
|
|
ETHNICITY
|
Identifies the institutional ethnic group for the person.
|
VARCHAR2(63)
|
PERSON
|
PRIMARY_ETHNICITY
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
ETHNICITY_CATEGORY
|
Identifies the governmental ethnic group for the person.
|
VARCHAR2(63)
|
PERSON
|
PRIMARY_ETHNCITY_CATEGORY
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
ETHNICITY_CATEGORY_LD
|
Long description for the governmental ethnic group.
|
VARCHAR2(255)
|
PERSON
|
PRIM_ETHNICITY_CATEGORY_DESC
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
ETHNICITY_CATEGORY_SD
|
Short description for the governmental ethnic group.
|
VARCHAR2(255)
|
PERSON
|
PRIM_ETHNICITY_CATEGORY_DESC
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
ETHNICITY_LD
|
Long description for the institutional ethnic group.
|
VARCHAR2(255)
|
PERSON
|
PRIMARY_ETHNICITY_DESC
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
ETHNICITY_SD
|
Short description for the institutional ethnic group.
|
VARCHAR2(255)
|
PERSON
|
PRIMARY_ETHNICITY_DESC
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
GENDER
|
Identifies the gender of the person.
|
VARCHAR2(63)
|
PERSON
|
GENDER
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
GENDER_LD
|
Long description for the gender code.
|
VARCHAR2(255)
|
PERSON
|
GENDER_DESC
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
GENDER_SD
|
Short description for the gender code.
|
VARCHAR2(255)
|
PERSON
|
GENDER_DESC
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
HISPANIC_LATINO_ETHNICITY_IND
|
Indicates if person's ethnicity is Latino or Hispanic. Changes to the collection of race and ethnicity for federal reporting, separated Race from Ethnicity (now a person can be Hispanic or Latino, or not.
|
VARCHAR2(63)
|
PERSON
|
HISPANIC_LATINO_ETHNICITY_IND
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
LEGACY
|
Code that identifies if the person has a legacy relationship.
|
VARCHAR2(63)
|
PERSON
|
LEGACY
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
LEGACY_LD
|
Long description defined in the cleansing process.
|
VARCHAR2(255)
|
PERSON
|
LEGACY_DESC
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
LEGACY_SD
|
Short description defined in the cleansing process.
|
VARCHAR2(255)
|
PERSON
|
LEGACY_DESC
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
MARITAL_STATUS
|
Marital status code of the person.
|
VARCHAR2(63)
|
PERSON
|
MARITAL_STATUS
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
MARITAL_STATUS_LD
|
Long description defined in the cleansing process.
|
VARCHAR2(255)
|
PERSON
|
MARITAL_STATUS_DESC
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
MARITAL_STATUS_SD
|
Short description defined in the cleansing process.
|
VARCHAR2(255)
|
PERSON
|
MARITAL_STATUS_DESC
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
NATION_OF_BIRTH
|
Country code of the nation of the person's birth.
|
VARCHAR2(63)
|
PERSON
|
NATION_OF_BIRTH
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
NATION_OF_BIRTH_LD
|
Long description defined in the cleansing process.
|
VARCHAR2(255)
|
PERSON
|
NATION_OF_BIRTH_DESC
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
NATION_OF_BIRTH_SD
|
Short description defined in the cleansing process.
|
VARCHAR2(255)
|
PERSON
|
NATION_OF_BIRTH_DESC
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
NATION_OF_CITIZENSHIP
|
Nation of citizen recorded for the person. Important for some institutions, for understanding enrollment patterns and for reporting.
|
VARCHAR2(63)
|
PERSON
|
NATION_OF_CITIZENSHIP
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
NATION_OF_CITIZENSHIP_LD
|
Long description for the nation of citizenship.
|
VARCHAR2(255)
|
PERSON
|
NATION_OF_CITIZENSHIP_DESC
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
NATION_OF_CITIZENSHIP_SD
|
Short description of the nation of citizenship.
|
VARCHAR2(255)
|
PERSON
|
NATION_OF_CITIZENSHIP_DESC
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
NATIVE_AMERICAN_OR_ALASKAN_IND
|
Indicates if person's race is Native American or Alaskan.
|
VARCHAR2(63)
|
PERSON_SENSITIVE_RACE
|
RACE_CATEGORY
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
PACIFIC_ISLANDER_IND
|
Indicates if person's race is Pacific Islander.
|
VARCHAR2(63)
|
PERSON_SENSITIVE_RACE
|
RACE_CATEGORY
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
PRIMARY_DISABILITY
|
Primary or first major disability for the person because of this handicap.
|
VARCHAR2(63)
|
PERSON
|
PRIM_DISABILITY
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
PRIMARY_DISABILITY_LD
|
Long description of the primary disability code.
|
VARCHAR2(255)
|
PERSON
|
PRIM_DISABILITY_DESC
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
PRIMARY_DISABILITY_SD
|
Short description of the primary disability code.
|
VARCHAR2(255)
|
PERSON
|
PRIM_DISABILITY_DESC
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
RELIGION
|
Religious affiliation recorded for the person.
|
VARCHAR2(63)
|
PERSON
|
RELIGION
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
RELIGION_LD
|
Long description defined in the cleansing process.
|
VARCHAR2(255)
|
PERSON
|
RELIGION_DESC
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
RELIGION_SD
|
Short description defined in the cleansing process.
|
VARCHAR2(255)
|
PERSON
|
RELIGION_DESC
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
ETL GENERATED ETL_GENERATED
|
NA NA
|
NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL GENERATED ETL_GENERATED
|
NA NA
|
NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR
|
|
VETERAN_CATEGORY
|
Veteran category as standardized by the federal government to track attendance of particular veteran types or groups.
|
VARCHAR2(63)
|
PERSON
|
VETERAN_CATEGORY
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
VETERAN_CATEGORY_LD
|
Long description defined in the cleansing process.
|
VARCHAR2(255)
|
PERSON
|
VETERAN_CATEGORY_DESC
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
VETERAN_CATEGORY_SD
|
Short description defined in the cleansing process.
|
VARCHAR2(255)
|
PERSON
|
VETERAN_CATEGORY_DESC
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
VETERAN_TYPE
|
Veteran type associated with the person record. This may indicate if the persons is a gulf war veteran, etc.
|
VARCHAR2(63)
|
PERSON
|
VETERAN_TYPE
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
VETERAN_TYPE_LD
|
Long description for the type of veteran.
|
VARCHAR2(255)
|
PERSON
|
VETERAN_TYPE_DESC
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
VETERAN_TYPE_SD
|
Short description for the type of veteran.
|
VARCHAR2(255)
|
PERSON
|
VETERAN_TYPE_DESC
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
VISA_TYPE
|
Type of visa issued to this person. For example, student, employment, visitor, etc.
|
VARCHAR2(63)
|
PERSON PERSON_VISA VISA
|
VISA_TYPE VISA_TYPE VISA_TYPE
|
NO NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION
FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
VISA_TYPE_LD
|
Long description of the visa type.
|
VARCHAR2(255)
|
PERSON PERSON_VISA VISA
|
VISA_TYPE_DESC VISA_TYPE_DESC VISA_TYPE_DESC
|
NO NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION
FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
VISA_TYPE_SD
|
Short description of the visa type.
|
VARCHAR2(255)
|
PERSON PERSON_VISA VISA
|
VISA_TYPE_DESC VISA_TYPE_DESC VISA_TYPE_DESC
|
NO NO NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADVANCEMENT GIFT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, RECRUITING AND ADMISSION
FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|
|
WHITE_IND
|
Indicates if person's race is White.
|
VARCHAR2(63)
|
PERSON_SENSITIVE_RACE
|
RACE_CATEGORY
|
NO
|
NO
|
ACADEMIC PROGRAM COURSE, ADMINISTRATOR, ADMISSIONS APPLICATION, ADMISSIONS RECRUITMENT, ADVANCEMENT GIFT, APPLICATION ATTRIBUTE, APPLICATION COHORT, APPLICATION DECISION, APPLICATION RATING, APPLICATION REQUIREMENT, CONTACT, COURSE REGISTRATION, EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION, ENROLLMENT, FINANCIAL AID APPLICATION, FINANCIAL AID AWARD BY ACADEMIC PERIOD, FINANCIAL AID AWARD BY AID YEAR, FINANCIAL AID PRE STUDENT, FINANCIAL AID STUDENT, GRADUATION COMPLETION, HOLD, INTEREST, POST SECONDARY SCHOOL, PROSPECTIVE STUDENT, RECRUITING AND ADMISSION, RECRUITMENT ATTRIBUTE, RECRUITMENT COHORT, SECONDARY SCHOOL SUBJECT, TEST
|